Table scop.astral_seq_hmm_pfam
Pfam hits in ASTRAL sequences

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
id int unsigned 10  √ 
astral_seq_hmm_pfam_gap.hit_id astral_seq_hmm_pfam_gap_ibfk_1 C
seq_id int unsigned 10
astral_seq.id astral_seq_hmm_pfam_ibfk_1 C
pfam_id int unsigned 10
pfam.id astral_seq_hmm_pfam_ibfk_2 C
log10_e double 22 log10 of E-value reported by hmmer, or -999 for E=0
score double 22 raw score of hit reported by hmmer
start int unsigned 10 start of hit in ASTRAL sequence, 0-indexed
length int unsigned 10 length of hit in ASTRAL sequence
hmm_start int unsigned 10 start of hit in HMM, 0-indexed
hmm_length int unsigned 10 length of hit in HMM

Table contained 1,081,322 rows at Sat Feb 27 10:37 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
pfam_id Performance Asc pfam_id
seq_id Performance Asc seq_id

Close relationships  within of separation: