Schema for kg5ToKg6

JavaScript is disabled in your web browser

You must have JavaScript enabled in your web browser to use the Genome Browser

Schema for kg5ToKg6

Database: hg19 Primary Table: kg5ToKg6 Row Count: 77,614 Data last updated: 2012-01-04
Format description: Lists old genes and equivalent new genes if any, and reason for dropping if any.
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`oldId`	uc001aaa.3	`varchar(255)`	values	Old gene ID
`oldChrom`	chr1	`varchar(255)`	values	Old chromosome
`oldStart`	11873	`int(11)`	range	Old start position
`oldEnd`	14409	`int(11)`	range	Old end position
`newId`	uc001aaa.3	`varchar(255)`	values	New gene ID, may be empty
`status`	exact	`varchar(255)`	values	How new/old correspond. Exact and compatible are good. Overlap, none are bad.
`note`		`varchar(255)`	values	Additional info if status if overlap or none.

Sample Rows

oldId	oldChrom	oldStart	oldEnd	newId	status	note
uc001aaa.3	chr1	11873	14409	uc001aaa.3	exact
uc010nxq.1	chr1	11873	14409	uc010nxq.1	exact
uc010nxr.1	chr1	11873	14409	uc010nxr.1	exact
uc009vis.2	chr1	14362	16765	uc009vis.3	compatible	Bases added to UTR
uc009vit.2	chr1	14362	19759	uc009vit.3	compatible	Bases added to UTR
uc001aae.3	chr1	14362	19759	uc001aae.4	compatible	Bases added to UTR
uc009viu.2	chr1	14362	19759	uc009viu.3	compatible	Bases added to UTR
uc001aab.3	chr1	14362	24901	uc001aah.4	overlap	Different number of exons
uc001aah.3	chr1	14362	29370	uc001aah.4	compatible	Bases added to UTR
uc009vir.2	chr1	14362	29370	uc009vir.3	compatible	Bases added to UTR

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