Difference between revisions of "Chado Organism Module"

From GMOD
Jump to: navigation, search
m (Table: organism)
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
=Introduction=
 
=Introduction=
  
 +
The organism module is designed to hold information about a given species, as such it is fairly simple.
 +
 +
 +
=More Information=
 +
 +
See the page on the related [[Chado_Phylogeny_Module|Phylogeny module]]. The phylogeny module is designed for phylogenetic trees and taxonomies.
  
 
=Tables=
 
=Tables=
Line 11: Line 17:
 
|+ organism Structure
 
|+ organism Structure
 
|-
 
|-
! F-Key
+
! FK
 
! Name
 
! Name
 
! Type
 
! Type
Line 56: Line 62:
  
 
* [[Chado_Tables#Table:_organism_dbxref| organism_dbxref]]
 
* [[Chado_Tables#Table:_organism_dbxref| organism_dbxref]]
 
* [[Chado_Tables#Table:_organism_relationship| organism_relationship]]
 
 
* [[Chado_Tables#Table:_organismpath| organismpath]]
 
  
 
* [[Chado_Tables#Table:_organismprop| organismprop]]
 
* [[Chado_Tables#Table:_organismprop| organismprop]]
Line 70: Line 72:
  
 
----
 
----
 +
 +
  
 
== Table: organism_dbxref ==
 
== Table: organism_dbxref ==
Line 76: Line 80:
 
|+ organism_dbxref Structure
 
|+ organism_dbxref Structure
 
|-
 
|-
! F-Key
+
! FK
 
! Name
 
! Name
 
! Type
 
! Type
Line 97: Line 101:
 
| integer
 
| integer
 
| '' UNIQUE#1 NOT NULL ''
 
| '' UNIQUE#1 NOT NULL ''
|}
 
 
----
 
 
 
 
== Table: organism_relationship ==
 
 
{| border="1" cellpadding="3"
 
|+ organism_relationship Structure
 
|-
 
! F-Key
 
! Name
 
! Type
 
! Description
 
|- class="tr0"
 
|
 
| organism_relationship_id
 
| serial
 
| '' PRIMARY KEY ''
 
|- class="tr1"
 
|
 
[[Chado_Tables#Table:_organism| organism]]
 
| subject_id
 
| integer
 
| '' UNIQUE#1 NOT NULL ''
 
|- class="tr0"
 
|
 
[[Chado_Tables#Table:_organism| organism]]
 
| object_id
 
| integer
 
| '' UNIQUE#1 NOT NULL ''
 
|- class="tr1"
 
|
 
[[Chado_Tables#Table:_cvterm| cvterm]]
 
| type_id
 
| integer
 
| '' UNIQUE#1 NOT NULL ''
 
|}
 
 
----
 
 
 
 
== Table: organismpath ==
 
 
{| border="1" cellpadding="3"
 
|+ organismpath Structure
 
|-
 
! F-Key
 
! Name
 
! Type
 
! Description
 
|- class="tr0"
 
|
 
| organismpath_id
 
| serial
 
| '' PRIMARY KEY ''
 
|- class="tr1"
 
|
 
[[Chado_Tables#Table:_organism| organism]]
 
| subject_id
 
| integer
 
| '' UNIQUE#1 NOT NULL ''
 
|- class="tr0"
 
|
 
[[Chado_Tables#Table:_organism| organism]]
 
| object_id
 
| integer
 
| '' UNIQUE#1 NOT NULL ''
 
|- class="tr1"
 
|
 
[[Chado_Tables#Table:_cvterm| cvterm]]
 
| type_id
 
| integer
 
| '' UNIQUE#1 NOT NULL ''
 
|- class="tr0"
 
|
 
| pathdistance
 
| integer
 
| '' UNIQUE#1 ''
 
 
|}
 
|}
  
Line 191: Line 114:
 
|+ organismprop Structure
 
|+ organismprop Structure
 
|-
 
|-
! F-Key
+
! FK
 
! Name
 
! Name
 
! Type
 
! Type
Line 226: Line 149:
 
----
 
----
  
[[Category:Chado]]
+
[[Category:Chado Modules]]
[[Category:To Do]]
+
[[Category:!Lacking ERD]]

Latest revision as of 04:39, 18 February 2015

Introduction

The organism module is designed to hold information about a given species, as such it is fairly simple.


More Information

See the page on the related Phylogeny module. The phylogeny module is designed for phylogenetic trees and taxonomies.

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.

organism Structure
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

organism_dbxref Structure
FK Name Type Description
organism_dbxref_id serial PRIMARY KEY

organism

organism_id integer UNIQUE#1 NOT NULL

dbxref

dbxref_id integer UNIQUE#1 NOT NULL


Table: organismprop

Tag-value properties - follows standard chado model.

organismprop Structure
FK Name Type Description
organismprop_id serial PRIMARY KEY

organism

organism_id integer UNIQUE#1 NOT NULL

cvterm

type_id integer UNIQUE#1 NOT NULL
value text
rank integer UNIQUE#1 NOT NULL