Columns
| Column | Type | Size | Foreign Key | Nullable | Default | Comments | ||
|---|---|---|---|---|---|---|---|---|
| organism_id | bigserial | 19 |
|
nextval('chado.organism_organism_id_seq'::regclass) | ||||
| abbreviation | varchar | 255 |
|
√ | null | |||
| genus | varchar | 255 |
|
null | ||||
| species | varchar | 255 |
|
null | 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. |
||
| type_id | int8 | 19 |
|
√ | null | 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 |
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 |
Relationships
The following entity relationship (ER) diagram shows the relationships involving the organism table.
Show relationships within degrees of separation
