Schema Version: 1.3 Module: chado

phenotype


Description

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.

Columns

Column Type Size Foreign Key Nullable Default Comments
phenotype_id bigserial 19
nextval('phenotype.phenotype_phenotype_id_seq'::regclass)
uniquename text 2147483647
null
name text 2147483647
√ null
observable_id int8 19
cvterm.cvterm_id phenotype_observable_id_fkey C
√ null

The entity: e.g. anatomy_part, biological_process.
attr_id int8 19
cvterm.cvterm_id phenotype_attr_id_fkey N
√ null

Phenotypic attribute (quality, property, attribute, character) - drawn from PATO.
value text 2147483647
√ null

Value of attribute - unconstrained free text. Used only if cvalue_id is not appropriate.
cvalue_id int8 19
cvterm.cvterm_id phenotype_cvalue_id_fkey N
√ null

Phenotype attribute value (state).
assay_id int8 19
cvterm.cvterm_id phenotype_assay_id_fkey N
√ null

Evidence type.

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
phenotype_pkey Primary key Asc phenotype_id
phenotype_c1 Must be unique Asc uniquename
phenotype_idx1 Performance Asc cvalue_id
phenotype_idx2 Performance Asc observable_id
phenotype_idx3 Performance Asc attr_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the phenotype table.

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation