Difference between revisions of "Chado Genetic Module"
m (New page: ==Introduction== ==Tables== ===phenstatement=== Phenotypes are things like ”larval lethal”. Phenstatements are things like ”dpp[1] is recessive larval lethal”. So essentially ...) |
m |
||
| Line 1: | Line 1: | ||
| − | |||
==Introduction== | ==Introduction== | ||
| Line 56: | Line 55: | ||
type id integer | type id integer | ||
pub idinteger | pub idinteger | ||
| + | |||
| + | |||
| + | ===genotype=== | ||
| + | |||
| + | Table 4.35: genotype | ||
| + | |||
| + | ColumnDatatype Description | ||
| + | genotype id integer | ||
| + | uniquename text | ||
| + | description varchar | ||
| + | |||
| + | |||
| + | ===feature_genotype=== | ||
| + | |||
| + | Table 4.36: feature genotype | ||
| + | |||
| + | Column Datatype Description | ||
| + | feature genotype id integer | ||
| + | feature id integer | ||
| + | genotype idinteger | ||
| + | chromosome id integer | ||
| + | rank integer | ||
| + | cgroup integer | ||
| + | cvterm id integer | ||
| + | |||
| + | |||
| + | ===environment=== | ||
| + | |||
| + | Table 4.37: environment | ||
| + | |||
| + | ColumnDatatype Description | ||
| + | environment id integer | ||
| + | uniquename text | ||
| + | description text | ||
| + | |||
| + | |||
| + | ===environment_cvterm=== | ||
| + | |||
| + | Table 4.38: environment cvterm | ||
| + | |||
| + | Column Datatype Description | ||
| + | environment cvterm id integer | ||
| + | environment id integer | ||
| + | cvterm id integer | ||
| + | |||
[[Category:Chado]] | [[Category:Chado]] | ||
[[Category:To Do]] | [[Category:To Do]] | ||
Revision as of 18:08, 14 February 2007
Contents
Introduction
Tables
phenstatement
Phenotypes are things like ”larval lethal”. Phenstatements are things like ”dpp[1] is recessive larval lethal”. So essentially phenstatement is a linking table expressing the relationship between genotype, environment, and phenotype.
Table 4.39: phenstatement
Column DatatypeDescription phenstatement id integer genotype idinteger environment idinteger phenotype id integer type id integer pub id integer
phendesc
a summary of a set of phenotypic statements for any one gcontext made in any one publication
Table 4.40: phendesc
ColumnDatatype Description phendesc id integer genotype id integer environment id integer description text pub idinteger
phenotype_comparison
comparison of phenotypes eg, genotype1/environment1/phenotype1 ”non-suppressible” wrt geno- type2/environment2/phenotype2
Table 4.41: phenotype comparison
ColumnDatatype Description phenotype comparison id integer genotype1 idinteger environment1 idinteger genotype2 idinteger environment2 idinteger phenotype1 id integer phenotype2 id integer type id integer pub idinteger
genotype
Table 4.35: genotype
ColumnDatatype Description genotype id integer uniquename text description varchar
feature_genotype
Table 4.36: feature genotype
Column Datatype Description feature genotype id integer feature id integer genotype idinteger chromosome id integer rank integer cgroup integer cvterm id integer
environment
Table 4.37: environment
ColumnDatatype Description environment id integer uniquename text description text
environment_cvterm
Table 4.38: environment cvterm
Column Datatype Description environment cvterm id integer environment id integer cvterm id integer
