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
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 0int(10) unsigned Start position in chromosome (forward strand)
chromEnd 1000int(10) unsigned End position in chromosome
extFile 5277int(10) unsigned ID of associated external file
offset 31bigint(20) Offset in external file
score 0.001double Overall score

Sample Rows
 
binchromchromStartchromEndextFileoffsetscore
585chr1010005277310.001
585chr110002000527710810.001
585chr120003000527721340.001
585chr130004000527731870.001
585chr140005000527742400.001
585chr150006000527752930.001
585chr160007000527763460.001
585chr170008000527773990.001
585chr180009000527784520.001
585chr1900010000527795050.001

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.