Schema Version: 1.3 Module: chado

Columns

Columns

Table Type Column Type Size Nulls Default Comments
phenotype_comparison Table genotype2_id int8 19 null
feature_genotype Table chromosome_id int8 19 √ null

A feature of SO type "chromosome".
environment_cvterm Table environment_cvterm_id bigserial 19 nextval('genetic.environment_cvterm_environment_cvterm_id_seq'::regclass)
feature_genotype Table genotype_id int8 19 null
phendesc Table pub_id int8 19 null
phenstatement Table phenotype_id int8 19 null
phendesc Table description text 2147483647 null
phenstatement Table type_id int8 19 null
environment Table uniquename text 2147483647 null
genotypeprop Table value text 2147483647 √ null
phendesc Table type_id int8 19 null
genotypeprop Table genotypeprop_id bigserial 19 nextval('genetic.genotypeprop_genotypeprop_id_seq'::regclass)
genotype Table name text 2147483647 √ null

Optional alternative name for a genotype, for display purposes.
feature_genotype Table feature_genotype_id bigserial 19 nextval('genetic.feature_genotype_feature_genotype_id_seq'::regclass)
phenotype_comparison Table phenotype1_id int8 19 null
phenotype_comparison_cvterm Table phenotype_comparison_id int8 19 null
phendesc Table genotype_id int8 19 null
phenotype_comparison_cvterm Table pub_id int8 19 null
genotype Table description text 2147483647 √ null
genotype Table genotype_id bigserial 19 nextval('genetic.genotype_genotype_id_seq'::regclass)
phenstatement Table pub_id int8 19 null
phenotype_comparison_cvterm Table rank int4 10 0
feature_genotype Table rank int4 10 null

rank can be used for n-ploid organisms or to preserve order.
phenotype_comparison_cvterm Table phenotype_comparison_cvterm_id bigserial 19 nextval('genetic.phenotype_comparison_cvterm_phenotype_comparison_cvterm_id_seq'::regclass)
phenotype_comparison Table pub_id int8 19 null
genotype Table type_id int8 19 null
genotypeprop Table rank int4 10 0
environment_cvterm Table environment_id int8 19 null
phenstatement Table phenstatement_id bigserial 19 nextval('genetic.phenstatement_phenstatement_id_seq'::regclass)
feature_genotype Table feature_id int8 19 null
phenstatement Table genotype_id int8 19 null
genotype Table uniquename text 2147483647 null

The unique name for a genotype; typically derived from the features making up the genotype.
genotypeprop Table type_id int8 19 null
phenotype_comparison Table environment1_id int8 19 null
phenotype_comparison_cvterm Table cvterm_id int8 19 null
phenstatement Table environment_id int8 19 null
phenotype_comparison Table phenotype2_id int8 19 √ null
phendesc Table environment_id int8 19 null
phenotype_comparison Table genotype1_id int8 19 null
feature_genotype Table cgroup int4 10 null

Spatially distinguishable group. group can be used for distinguishing the chromosomal groups, for example (RNAi products and so on can be treated as different groups, as they do not fall on a particular chromosome).
phenotype_comparison Table phenotype_comparison_id bigserial 19 nextval('genetic.phenotype_comparison_phenotype_comparison_id_seq'::regclass)
environment_cvterm Table cvterm_id int8 19 null
environment Table environment_id bigserial 19 nextval('genetic.environment_environment_id_seq'::regclass)
environment Table description text 2147483647 √ null
phendesc Table phendesc_id bigserial 19 nextval('genetic.phendesc_phendesc_id_seq'::regclass)
phenotype_comparison Table organism_id int8 19 null
phenotype_comparison Table environment2_id int8 19 null
feature_genotype Table cvterm_id int8 19 null
genotypeprop Table genotype_id int8 19 null