Table homo_sapiens_core_98_38.protein_feature 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
protein_feature_id int unsigned 10  √ 
translation_id int unsigned 10
translation.translation_id Implied Constraint R
seq_start int 10
seq_end int 10
hit_start int 10
hit_end int 10
hit_name varchar 40
analysis_id smallint unsigned 5
analysis.analysis_id Implied Constraint R
score double 22  √  null
evalue double 22  √  null
perc_ident float 12  √  null
external_data text 65535  √  null
hit_description text 65535  √  null
cigar_line text 65535  √  null
align_type enum 9  √  null

Table contained 1,789,147 rows at Wed Nov 27 11:43 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
protein_feature_id Primary key Asc PRIMARY
translation_id + hit_name + seq_start + seq_end + hit_start + hit_end + analysis_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc aln_idx
analysis_id Performance Asc analysis_idx
hit_name Performance Asc hitname_idx
translation_id Performance Asc translation_idx

Close relationships: