Table 3 Data types used for HERV data
From: DRUMS: Disk Repository with Update Management and Select option for high throughput sequencing data
Column | MySQL properties | DRUMS properties |
|---|---|---|
Chromosome | TINY INT, primary key | 1 byte, key part 1 |
Start-position on chromosome | INT, primary key | 4 byte, key part 2 |
End-position on chromosome | INT, primary key | 4 byte, key part 3 |
Start-position on HERV | SMALL INT, primary key | 2 byte, key part 4 |
End-position on HERV | SMALL INT, primary key | 2 byte, key part 5 |
Id of referenced HERV | SMALL INT, primary key | 2 byte, key part 6 |
Strand on chromosome | TINY INT, primary key | 1 byte, key part 7 |
E-value | DOUBLE | 4 byte, value part 1 |