Table zfindb.public.blast_hit Generated by
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 text 2147483647
bhit_bqry_zdb_id text 2147483647
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 int4 10
bhit_score int4 10
bhit_expect_value float8 17,17
bhit_probability float8 17,17  √  null
bhit_positives_numerator int4 10
bhit_positives_denominator int4 10
bhit_identities_numerator int4 10  √  null
bhit_identities_denominator int4 10  √  null
bhit_strand text 2147483647  √  null
bhit_alignment text 2147483647  √  null

Table contained 252,452 rows at Tue Sep 15 16:40 PDT 2020

Column(s) Type Sort Constraint Name
bhit_zdb_id Primary key Asc blast_hit_primary_keyn
bhit_bqry_zdb_id Performance Asc bhit_bqry_zdb_id_fk_odc_index
bhit_target_accbk_pk_id Performance Asc blast_hit_target_accbk_pk_id_foreign_key_indexn

Close relationships  within of separation: