The organismal taxonomic classification. Note that phylogenies are represented using the phylogeny module, and taxonomies can be represented using the cvterm module or the phylogeny module.
A type of organism is always uniquely identified by genus and species. When mapping from the NCBI taxonomy names.dmp file, this column must be used where it is present, as the common_name column is not always unique (e.g. environmental samples). If a particular strain or subspecies is to be represented, this is appended onto the species name. Follows standard NCBI taxonomy pattern.
common_name
varchar
255
√
null
infraspecific_name
varchar
1024
√
null
The scientific name for any taxon below the rank of species. The rank should be specified using the type_id field and the name is provided here.
A controlled vocabulary term that specifies the organism rank below species. It is used when an infraspecific name is provided. Ideally, the rank should be a valid ICN name such as subspecies, varietas, subvarietas, forma and subforma
comment
text
2147483647
√
null
Showing 1 to 8 of 8 entries
Table contained -1 rows
Indexes
Constraint Name
Type
Sort
Column(s)
organism_pkey
Primary key
Asc
organism_id
organism_c1
Must be unique
Asc/Asc/Asc/Asc
genus + species + type_id + infraspecific_name
Showing 1 to 2 of 2 entries
Relationships
The following entity relationship (ER) diagram shows the relationships involving the organism table.
