blast_hits

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
blast_hit_id serial 10 nextval('sgn.blast_hits_blast_hit_id_seq'::regclass)
blast_annotation_id int4 10 null
blast_annotations.blast_annotation_id blast_hits_blast_annotation_id_fkey C
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
blast_defline.defline_id Implied Constraint R

Indexes

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

Relationships