Schema for Multiz Align - Multiz Alignments of 46 Vertebrates
Database: hg19    Primary Table: multiz46way    Row Count: 33,612,571
Format description: Score and reference to external file position (generally used for multiple alignment display).
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 10917int(10) unsigned Start position in chromosome (forward strand)
chromEnd 11396int(10) unsigned End position in chromosome
extFile 2386996int(10) unsigned ID of associated external file
offset 34bigint(20) Offset in external file
score 0.85738double Overall score
Sample Rows
binchromchromStartchromEndextFileoffsetscore
585chr110917113962386996340.85738
585chr11139611489238699611160.485341
585chr11148911570238699616330.631527
585chr11157011625238699626190.590915
585chr11162511804238699633860.630984
585chr11180411857238699655700.565192
585chr11185712072238699665850.626202
585chr11207212110238699691480.767157
585chr112110121762386996100970.502963
585chr112176122492386996112820.652791

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