Schema Version: 1.3 Module: chado.organism

TABLES 8
VIEWS 0
COLUMNS 39
Constraints 17

chado.organism Tables

Table / View Referenced Foreign Keys Columns Type Comments
organism 14 1 8 Table

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.

organism_cvterm 1 3 5 Table

organism to cvterm associations. Examples: taxonomic name

organism_cvtermprop 0 2 5 Table

Extensible properties for organism to cvterm associations. Examples: qualifiers

organism_dbxref 0 2 3 Table

Links an organism to a dbxref.

organism_pub 0 2 3 Table

Attribution for organism.

organism_relationship 0 3 5 Table

Specifies relationships between organisms that are not taxonomic. For example, in breeding, relationships such as "sterile_with", "incompatible_with", or "fertile_with" would be appropriate. Taxonomic relatinoships should be housed in the phylogeny tables.

organismprop 1 2 5 Table

Tag-value properties - follows standard chado model.

organismprop_pub 0 2 5 Table

Attribution for organismprop.