unigene

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
unigene_id serial 10 √ nextval('sgn.unigene_unigene_id_seq'::regclass)
locus_unigene.unigene_id locus_unigene_unigene_id_fkey R
unigene_dbxref.unigene_id unigene_dbxref_unigene_id_fkey R
unigene_relations.superceded_by unigene_relations_superceded_by_fkey R
unigene_relations.unigene_id unigene_relations_unigene_id_fkey R
unigene_signalp.unigene_id unigene_signalp_unigene_id_fkey R
blast_annotations.apply_id apply_id_fkey R
cds.unigene_id cds_unigene_id_fkey C
cosii_ortholog.unigene_id Implied Constraint R
primer_unigene_match.unigene_id primer_unigene_match_unigene_id_fkey R
rflp_unigene_associations.unigene_id unigene_id_fk R
ssr_primer_unigene_matches.unigene_id unigene_id_fk R
unigene_member.unigene_id unigene_member_unigene_id_fkey R
unigene_build_id int4 10 √ null
unigene_build.unigene_build_id unigene_unigene_build_id_fkey R
consensi_id int4 10 √ null
unigene_consensi.consensi_id unigene_unigene_consensi_id_fkey R
cluster_no int8 19 √ null
contig_no int8 19 √ null
nr_members int8 19 √ null
database_name varchar 2147483647 'SGN'::character varying
sequence_name int8 19 null

Indexes

Constraint Name Type Sort Column(s)
unigene_pkey Primary key Asc unigene_id
cluster_no_2_idx Performance Asc/Asc cluster_no + contig_no
cluster_no_idx Performance Asc cluster_no
consensi_id_idx Performance Asc consensi_id
unigene_build_id_idx Performance Asc/Asc unigene_build_id + cluster_no
unigene_sequence_name Performance Asc sequence_name

Check Constraints

Constraint Name Constraint
unigene_database_name_check ((((database_name)::text = 'SGN'::text) OR ((database_name)::text = 'CGN'::text)))
unigene_nr_members_iff_consensi_id ((((nr_members > 1) AND (consensi_id IS NOT NULL)) OR ((nr_members = 1) AND (consensi_id IS NULL))))

Relationships

Close relationships within degrees of separation