If the column has constrained values they are listed under values on the far right. Click on MORE to see full list and description of constrained values.
Back to table listings
Columns in table "ncbi_taxa"
Column |
Data Type |
Null |
Description |
Values |
superkingdom |
text |
YES |
|
|
name_id |
bigint |
NO |
Integer ID for this taxon name (added by BIEN) |
|
tax_id |
bigint |
NO |
NCBI identifier for this taxon |
|
rank |
text |
NO |
taxonomic rank |
|
major_higher_taxon |
text |
YES |
Major higher taxonomic group, not necessarily monophyletic (added by BIEN) |
|
is_embryophyte |
smallint |
YES |
Is taxon a land plant (Embryophte)? |
|
kingdom |
text |
YES |
Taxonomic kingdom |
|
phylum |
text |
YES |
Taxonomic phylum |
|
class |
text |
YES |
Taxonomic class |
|
taxon |
text |
NO |
taxon name |
|
unique_taxon |
text |
YES |
Unique taxon name if >1 usage |
|
name_class |
text |
YES |
NCBI name class |
|
left_index |
bigint |
YES |
MPTT index for ancestor-descendent searches |
|
right_index |
bigint |
YES |
MPTT index for ancestor-descendent searches |
|
|