Schema Version: 1.3

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('chado.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.

Show relationships within degrees of separation