Difference between revisions of "Template:ChadoTable organism"

From GMOD
Jump to: navigation, search
(Table definition, first upload on 2010/11/22.)
 
(Table definition for Chado on 2010/11/24)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
<noinclude>{{ChadoTableTemplateHeader}}</noinclude><protect>{{ChadoTableDesc|Organism|organism|The organismal taxonomic
+
<protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude>
 +
{{ChadoTableDesc|Organism|organism|The organismal taxonomic
 
classification. Note that phylogenies are represented using the
 
classification. Note that phylogenies are represented using the
 
phylogeny module, and taxonomies can be represented using the cvterm
 
phylogeny module, and taxonomies can be represented using the cvterm
 
module or the phylogeny module.}}
 
module or the phylogeny module.}}
 
{{ChadoColumnsHeader|Organism|organism}}
 
{{ChadoColumnsHeader|Organism|organism}}
{{ChadoColumnDesc||organism_id|serial|''PRIMARY KEY''
+
{{ChadoColumnDesc||organism_id|serial|''PRIMARY KEY''<br />
 
+
 
}}
 
}}
 
{{ChadoColumnDesc||abbreviation|character varying(255)|}}
 
{{ChadoColumnDesc||abbreviation|character varying(255)|}}
{{ChadoColumnDesc||genus|character varying(255)|''UNIQUE#1''
+
{{ChadoColumnDesc||genus|character varying(255)|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
{{ChadoColumnDesc||species|character varying(255)|''UNIQUE#1''
+
{{ChadoColumnDesc||species|character varying(255)|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
A type of organism is always
 
A type of organism is always
 
uniquely identified by genus and species. When mapping from the NCBI
 
uniquely identified by genus and species. When mapping from the NCBI
Line 29: Line 25:
  
 
{{ChadoTablesReferencingHeader|organism}}
 
{{ChadoTablesReferencingHeader|organism}}
 
+
{{ChadoReferencingTable|Mage|biomaterial}}
* None.
+
{{ChadoReferencingTable|Cell Line|cell_line}}
 +
{{ChadoReferencingTable|Sequence|feature}}
 +
{{ChadoReferencingTable|Library|library}}
 +
{{ChadoReferencingTable|Organism|organism_dbxref}}
 +
{{ChadoReferencingTable|Organism|organismprop}}
 +
{{ChadoReferencingTable|Genetic|phenotype_comparison}}
 +
{{ChadoReferencingTable|Phylogeny|phylonode_organism}}
 +
{{ChadoReferencingTable|Stock|stock}}
 
</protect>
 
</protect>

Latest revision as of 19:58, 24 November 2010

This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:

  1. The module page for the module the table is a part of. This is where updates and comments should be posted.
  2. The Chado Tables page, which lists all tables.

You can include this template anywhere you want to show the table description.


Table: organism
Module: 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.

organism columns
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 organism via foreign key constraints: