Table homo_sapiens_core_52_36n.protein_align_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_align_feature_id int unsigned 10  √ 
seq_region_id int unsigned 10 0
dna.seq_region_id Implied Constraint
seq_region_start int unsigned 10 0
seq_region_end int unsigned 10 0
seq_region_strand bit 0 0
hit_start int 10
hit_end int 10
hit_name varchar 40
analysis_id smallint unsigned 5 0
analysis.analysis_id Implied Constraint
score double 22  √  null
evalue double 22  √  null
perc_ident float 12  √  null
cigar_line text 65535  √  null
external_db_id smallint unsigned 5  √  null
external_db.external_db_id Implied Constraint
hcoverage double 22  √  null

Table contained 7 897 598 rows at ma maalis 23 00:31 EET 2009

Indexes:
Column(s) Type Sort Constraint Name
protein_align_feature_id Primary key Asc PRIMARY
analysis_id Performance Asc analysis_idx
external_db_id Performance Asc external_db_idx
hit_name Performance Asc hit_idx
seq_region_id + analysis_id + seq_region_start + score Performance Asc/Asc/Asc/Asc seq_region_idx
seq_region_id + seq_region_start Performance Asc/Asc seq_region_idx_2

Close relationships: