Template:ChadoTable feature relationship
This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:
- The module page for the module the table is a part of. This is where updates and comments should be posted.
- The Chado Tables page, which lists all tables.
You can include this template anywhere you want to show the table description.
Table: | feature_relationship |
Module: | Sequence |
Features can be arranged in graphs, e.g. "exon part_of transcript part_of gene"; If type is thought of as a verb, the each arc or edge makes a statement [Subject Verb Object]. The object can also be thought of as parent (containing feature), and subject as child (contained feature or subfeature). We include the relationship rank/order, because even though most of the time we can order things implicitly by sequence coordinates, we can not always do this - e.g. transpliced genes. It is also useful for quickly getting implicit introns.
FK | Name | Type | Description |
---|---|---|---|
feature_relationship_id | serial | PRIMARY KEY | |
feature | subject_id | integer | UNIQUE#1 NOT NULL |
feature | object_id | integer | UNIQUE#1 NOT NULL |
cvterm | type_id | integer | UNIQUE#1 NOT NULL |
value | text | Additional notes or comments. | |
rank | integer | UNIQUE#1 NOT NULL |
Tables referencing feature_relationship via foreign key constraints: