Table Columns

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

  Sort columns ordinally
  Sort columns alphabetically

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