phenotype_comparison

0 rows


Description

Comparison of phenotypes e.g., genotype1/environment1/phenotype1 “non-suppressible” with respect to genotype2/environment2/phenotype2.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
phenotype_comparison_id serial 10 nextval('phenotype_comparison_phenotype_comparison_id_seq'::regclass)
phenotype_comparison_cvterm.phenotype_comparison_id phenotype_comparison_cvterm_phenotype_comparison_id_fkey C
genotype1_id int4 10 null
genotype.genotype_id phenotype_comparison_genotype1_id_fkey C
environment1_id int4 10 null
environment.environment_id phenotype_comparison_environment1_id_fkey C
genotype2_id int4 10 null
genotype.genotype_id phenotype_comparison_genotype2_id_fkey C
environment2_id int4 10 null
environment.environment_id phenotype_comparison_environment2_id_fkey C
phenotype1_id int4 10 null
phenotype.phenotype_id phenotype_comparison_phenotype1_id_fkey C
phenotype2_id int4 10 null
phenotype.phenotype_id phenotype_comparison_phenotype2_id_fkey C
pub_id int4 10 null
pub.pub_id phenotype_comparison_pub_id_fkey C
organism_id int4 10 null
organism.organism_id phenotype_comparison_organism_id_fkey C

Indexes

Constraint Name Type Sort Column(s)
phenotype_comparison_pkey Primary key Asc phenotype_comparison_id
phenotype_comparison_c1 Must be unique Asc/Asc/Asc/Asc/Asc/Asc genotype1_id + environment1_id + genotype2_id + environment2_id + phenotype1_id + pub_id
phenotype_comparison_idx1 Performance Asc genotype1_id
phenotype_comparison_idx2 Performance Asc genotype2_id
phenotype_comparison_idx4 Performance Asc pub_id

Relationships