Table zfindb.informix.blast_hit Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
bhit_zdb_id varchar 50
bhit_bqry_zdb_id varchar 50
blast_query.bqry_zdb_id bhit_bqry_zdb_id_foreign_keyn_odc C
bhit_target_accbk_pk_id int8 19
accession_bank.accbk_pk_id bhit_target_accbk_pk_id_foreign_keyn_odc C
bhit_hit_number int 10
bhit_score int 10
bhit_expect_value float 17
bhit_probability float 17  √  null
bhit_positives_numerator int 10
bhit_positives_denominator int 10
bhit_identities_numerator int 10  √  null
bhit_identities_denominator int 10  √  null
bhit_strand varchar 30  √  null
bhit_alignment lvarchar 30000  √  null

Table contained 231,909 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
bhit_alignment + bhit_bqry_zdb_id Performance Asc/Asc 293_1455
bhit_alignment + bhit_zdb_id Must be unique Asc/Asc blast_hit_primary_key_indexn
bhit_alignment + bhit_target_accbk_pk_id Performance Asc/Asc blast_hit_target_accbk_pk_id_foreign_key_indexn

Close relationships  within of separation: