Schema for DB Cactus 241-way - DB table version Cactus Alignment & Conservation of Placental Mammals from Zoonomia Project (241 Species)
Database: hg38 Primary Table: cactus241way Row Count: 653,619,836   Data last updated: 2020-12-17 Format description: Score and reference to external file position (generally used for multiple alignment display). On download server: MariaDB table dump directory
field
example
SQL type
description
bin
585
smallint(5) unsigned
Indexing field to speed chromosome range queries.
chrom
chr1
varchar(255)
Reference sequence chromosome or scaffold
chromStart
0
int(10) unsigned
Start position in chromosome (forward strand)
chromEnd
1000
int(10) unsigned
End position in chromosome
extFile
5277
int(10) unsigned
ID of associated external file
offset
31
bigint(20)
Offset in external file
score
0.001
double
Overall score
Sample Rows
bin
chrom
chromStart
chromEnd
extFile
offset
score
585
chr1
0
1000
5277
31
0.001
585
chr1
1000
2000
5277
1081
0.001
585
chr1
2000
3000
5277
2134
0.001
585
chr1
3000
4000
5277
3187
0.001
585
chr1
4000
5000
5277
4240
0.001
585
chr1
5000
6000
5277
5293
0.001
585
chr1
6000
7000
5277
6346
0.001
585
chr1
7000
8000
5277
7399
0.001
585
chr1
8000
9000
5277
8452
0.001
585
chr1
9000
10000
5277
9505
0.001
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.