Schema Version: 1.3 Module: chado

featurerange


Description

In cases where the start and end of a mapped feature is a range, leftendf and rightstartf are populated. leftstartf_id, leftendf_id, rightstartf_id, rightendf_id are the ids of features with respect to which the feature is being mapped. These may be cytological bands.

Columns

Column Type Size Foreign Key Nullable Default Comments
featurerange_id bigserial 19
nextval('map.featurerange_featurerange_id_seq'::regclass)
featuremap_id int8 19
featuremap.featuremap_id featurerange_featuremap_id_fkey C
null

featuremap_id is the id of the feature being mapped.
feature_id int8 19
feature.feature_id featurerange_feature_id_fkey C
null
leftstartf_id int8 19
feature.feature_id featurerange_leftstartf_id_fkey C
null
leftendf_id int8 19
feature.feature_id featurerange_leftendf_id_fkey N
√ null
rightstartf_id int8 19
feature.feature_id featurerange_rightstartf_id_fkey N
√ null
rightendf_id int8 19
feature.feature_id featurerange_rightendf_id_fkey C
null
rangestr varchar 255
√ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
featurerange_pkey Primary key Asc featurerange_id
featurerange_idx1 Performance Asc featuremap_id
featurerange_idx2 Performance Asc feature_id
featurerange_idx3 Performance Asc leftstartf_id
featurerange_idx4 Performance Asc leftendf_id
featurerange_idx5 Performance Asc rightstartf_id
featurerange_idx6 Performance Asc rightendf_id

Relationships

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