blast_annotations

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

blast_annotation_id

serial

10

√

nextval('sgn.blast_annotations_blast_annotation_id_seq'::regclass)

blast_hits.blast_annotation_id

blast_hits_blast_annotation_id_fkey

C

apply_id

int4

10

√

null

unigene.unigene_id

apply_id_fkey

R

apply_type

int4

10

√

null

blast_target_id

int4

10

√

null

blast_targets.blast_target_id

Implied Constraint

R

n_hits

int4

10

√

null

hits_stored

int4

10

√

null

last_updated

int4

10

√

null

host

varchar

20

√

null

pid

int4

10

√

null

p_markers.pid

Implied Constraint

R

Showing 1 to 9 of 9 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
blast_annotations_pkey	Primary key	Asc	blast_annotation_id
apply_id_idx	Performance	Asc	apply_id
blast_annotations_apply_id_blast_target_id_uq	Must be unique	Asc/Asc	apply_id + blast_target_id

Showing 1 to 3 of 3 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation