Schema Version: 1.3 Module: chado

feature_genotype


Columns

Column Type Size Foreign Key Nullable Default Comments
feature_genotype_id bigserial 19
nextval('genetic.feature_genotype_feature_genotype_id_seq'::regclass)
feature_id int8 19
feature.feature_id feature_genotype_feature_id_fkey C
null
genotype_id int8 19
genotype.genotype_id feature_genotype_genotype_id_fkey C
null
chromosome_id int8 19
feature.feature_id feature_genotype_chromosome_id_fkey N
√ null

A feature of SO type "chromosome".
rank int4 10
null

rank can be used for n-ploid organisms or to preserve order.
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).
cvterm_id int8 19
cvterm.cvterm_id feature_genotype_cvterm_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
feature_genotype_pkey Primary key Asc feature_genotype_id
feature_genotype_c1 Must be unique Asc/Asc/Asc/Asc/Asc/Asc feature_id + genotype_id + cvterm_id + chromosome_id + rank + cgroup
feature_genotype_idx1 Performance Asc feature_id
feature_genotype_idx2 Performance Asc genotype_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the feature_genotype 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