Skip to main content

Table 2 Effectiveness of string and hierarchical queries

From: TBMap: a taxonomic perspective on the phylogenetic database TreeBASE

TreeBASE studies retrieved by text and hierarchical queries
Rank Term Frequency tax_id Text Hierarchical
1 homo sapiens 9700 9606 22 25
2 mammalia 5028 40674 7 69
3 Fungi 1875 4751 6 440
4 angiosperms 1825 3398 8 470
5 pine 1772    
6 carnivora 1723 33554 6 18
7 maple 1666    
8 acer 1618 4022 5 7
9 chordata 1373 7711 1 140
10 Agaricus bisporus 1286 5341 17 18
11 Homo 1212 9605 1 26
12 oak 1103    
13 Cetacea 1006 9721 9 15
14 bacteria 988 2 2 21
15 pinus 973 3337 4 14
16 Candida albicans@ 963 5476 21 21
17 human 951 9606   25
18 Zea mays 929 4577 13 17
19 donoghue 914   - -
20 jody hey 901   - -
21 Aves 888 8782 5 28
22 quercus 865 3511 1 3
23 chase 804   - -
24 Hibbett 803   - -
25 drosophila 792 7215 3 15
26 Drosophila melanogaster 727 7227 13 13
27 Nematoda@ 649 6231 3 29
28 arthropoda 648 6656 5 148
29 primates 619 9443 2 28
30 mollusca 610 6447 4 38
Total   45211   158 1628
  1. For the 30 most common query terms entered by users of TreeBASE between December 1998 to March 2006, the table shows the frequency of that term, the NCBI taxonomy tax_id (where applicable), and the number of studies retrieved by a SQL text query and by a hierarchical query using a nested sets representation of the NCBI classification (Fig. 3). Queries in boldface are vernacular names that are also present in the NCBI taxonomy database. Two queries used the '@' symbol, which TreeBASE treats as a wild-card. For those terms the corresponding SQL text query used the '%' wild-card.