Table cxgn.sgn_bt.blast_hits

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
blast_hit_id serial 10  √  nextval('blast_hits_blast_hit_id_seq'::regclass)
blast_annotation_id int4 10  √  null
blast_annotations.blast_annotation_id blast_hits_blast_annotation_id_fkey
target_db_id varchar 255  √  null
evalue float8 17,17  √  null
score float8 17,17  √  null
identity_percentage float8 17,17  √  null
apply_start int8 19  √  null
apply_end int8 19  √  null
defline_id int4 10  √  null
cxgn_production_visible bool 1  √  false

Table contained 13,781,459 rows at Thu Jun 21 23:03 EDT 2007

Indexes:
Column(s) Type Sort Constraint Name
blast_hit_id Primary key Asc blast_hits_pkey
blast_annotation_id Performance Asc blast_annotation_id_idx
defline_id + blast_annotation_id Performance Asc/Asc defline_annotation_idx
defline_id Performance Asc defline_id_idx
evalue Performance Asc evalue_idx
score Performance Asc score_idx

Close relationships  within one two degrees of separation :