Schema for liftOver & ReMap - UCSC LiftOver and NCBI ReMap: Genome alignments to convert annotations to hg38
  Database: hg19    Primary Table: chainHg38ReMap    Row Count: 5,315   Data last updated: 2020-02-11
Format description: Summary info about a chain of alignments
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 73smallint(5) unsigned range Indexing field to speed chromosome range queries.
score 15882668double range score of chain
tName chr1varchar(255) values Target sequence name
tSize 249250621int(10) unsigned range Target sequence size
tStart 10000int(10) unsigned range Alignment start position in target
tEnd 177417int(10) unsigned range Alignment end position in target
qName chr1varchar(255) values Query sequence name
qSize 248956422int(10) unsigned range Query sequence size
qStrand +char(1) values Query strand
qStart 10000int(10) unsigned range Alignment start position in query
qEnd 177417int(10) unsigned range Alignment end position in query
id 1int(10) unsigned range chain id

Sample Rows
 
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
7315882668chr124925062110000177417chr1248956422+100001774171
5852510506chr12492506211029737148chr1248956422+1808322076662
5861444789chr1249250621139218154500chr9138394717-1164951317363
733809466chr1249250621227417267719chr1248956422+2576662979684
7314571217chr1249250621317719471368chr1248956422-2484548052486084545
5871515440chr1249250621326096342202chr9138394717+1382782221382943306
5881173745chr1249250621449273461786chrUn_KI270748v193321+80848933217
9102031194chr12492506215213681584551chr1248956422+58598816491858
589154868chr1249250621543121544746chrUn_KI270748v193321-22771243969
589169211chr1249250621546073547935chrUn_KI270748v193321-249832691110

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

liftOver & ReMap (liftHg38) Track Description
 

Description

This track shows alignments from the hg19 to the hg38 genome assembly, used by the UCSC liftOver tool and NCBI's ReMap service, respectively.

Display Conventions and Configuration

The track has three subtracks, one for UCSC and two for NCBI alignments.

The alignments are shown as "chains" of alignable regions. The display is similar to the other chain tracks, see our chain display documentation for more information.

Data access

UCSC liftOver chain files for hg19 to hg38 can be obtained from a dedicated directory on our Download server. The NCBI chain file can be obtained from the MySQL tables directory on our download server, the filename is 'chainHg38ReMap.txt.gz'.

Both tables can also be explored interactively with the Table Browser or the Data Integrator.

Methods

ReMap 2.2 alignments were downloaded from the NCBI FTP site and converted with the UCSC kent command line tools. Like all data processing for the genome browser, the procedure is documented in our hg19 makeDoc file.

Credits

Thanks to NCBI for making the ReMap data available and to Angie Hinrichs for the file conversion.