Difference between revisions of "Chado Phenotype Module"
From GMOD
m (→Table: phenotype_cvterm) |
m (→Introduction) |
||
Line 2: | Line 2: | ||
{{NeedsEditing}} | {{NeedsEditing}} | ||
+ | |||
+ | Chris Mungall's 2006 [[Media:02-chado-for-nescent-2006.pdf|Chado for evolutionary science]] presentation discusses the Phenotype module. | ||
=Tables= | =Tables= |
Latest revision as of 21:11, 6 February 2008
Contents
Introduction
This page or section needs to be edited. Please help by editing this page to add your revisions or additions.
Chris Mungall's 2006 Chado for evolutionary science presentation discusses the Phenotype module.
Tables
Table: feature_phenotype
F-Key | Name | Type | Description |
---|---|---|---|
feature_phenotype_id | serial | PRIMARY KEY | |
feature_id | integer | UNIQUE#1 NOT NULL | |
phenotype_id | integer | UNIQUE#1 NOT NULL |
Table: phenotype
A phenotypic statement, or a single atomic phenotypic observation, is a controlled sentence describing observable effects of non-wild type function. E.g. Obs=eye, attribute=color, cvalue=red.
F-Key | Name | Type | Description |
---|---|---|---|
phenotype_id | serial | PRIMARY KEY | |
uniquename | text | UNIQUE NOT NULL | |
observable_id | integer | The entity: e.g. anatomy_part, biological_process. | |
attr_id | integer | Phenotypic attribute (quality, property, attribute, character) - drawn from PATO. | |
value | text | Value of attribute - unconstrained free text. Used only if cvalue_id is not appropriate. | |
cvalue_id | integer | Phenotype attribute value (state). | |
assay_id | integer | Evidence type |
Tables referencing this one via Foreign Key Constraints:
Table: phenotype_cvterm
F-Key | Name | Type | Description |
---|---|---|---|
phenotype_cvterm_id | serial | PRIMARY KEY | |
phenotype_id | integer | UNIQUE#1 NOT NULL | |
cvterm_id | integer | UNIQUE#1 NOT NULL |