Difference between revisions of "Chado Organism Module"
From GMOD
m |
(Latest version of tables) |
||
Line 18: | Line 18: | ||
|+ organism Structure | |+ organism Structure | ||
|- | |- | ||
− | ! | + | ! FK |
! Name | ! Name | ||
! Type | ! Type | ||
Line 63: | Line 63: | ||
* [[Chado_Tables#Table:_organism_dbxref| organism_dbxref]] | * [[Chado_Tables#Table:_organism_dbxref| organism_dbxref]] | ||
− | |||
− | |||
− | |||
− | |||
* [[Chado_Tables#Table:_organismprop| organismprop]] | * [[Chado_Tables#Table:_organismprop| organismprop]] | ||
Line 77: | Line 73: | ||
---- | ---- | ||
+ | |||
+ | |||
== Table: organism_dbxref == | == Table: organism_dbxref == | ||
Line 83: | Line 81: | ||
|+ organism_dbxref Structure | |+ organism_dbxref Structure | ||
|- | |- | ||
− | ! | + | ! FK |
! Name | ! Name | ||
! Type | ! Type | ||
Line 104: | Line 102: | ||
| integer | | integer | ||
| '' UNIQUE#1 NOT NULL '' | | '' UNIQUE#1 NOT NULL '' | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} | ||
Line 198: | Line 115: | ||
|+ organismprop Structure | |+ organismprop Structure | ||
|- | |- | ||
− | ! | + | ! FK |
! Name | ! Name | ||
! Type | ! Type |
Revision as of 22:10, 13 April 2007
Contents
Introduction
This page or section needs to be edited. Please help by editing this page to add your revisions or additions.
More Information
See the page on the related Phylogeny module.
Tables
Table: organism
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.
FK | Name | Type | Description |
---|---|---|---|
organism_id | serial | PRIMARY KEY | |
abbreviation | character varying(255) | ||
genus | character varying(255) | UNIQUE#1 NOT NULL | |
species | character varying(255) | UNIQUE#1 NOT 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 | character varying(255) | ||
comment | text |
Tables referencing this one via Foreign Key Constraints:
Table: organism_dbxref
FK | Name | Type | Description |
---|---|---|---|
organism_dbxref_id | serial | PRIMARY KEY | |
organism_id | integer | UNIQUE#1 NOT NULL | |
dbxref_id | integer | UNIQUE#1 NOT NULL |
Table: organismprop
Tag-value properties - follows standard chado model.
FK | Name | Type | Description |
---|---|---|---|
organismprop_id | serial | PRIMARY KEY | |
organism_id | integer | UNIQUE#1 NOT NULL | |
type_id | integer | UNIQUE#1 NOT NULL | |
value | text | ||
rank | integer | UNIQUE#1 NOT NULL |