|
|---|
| |
Database: hg38 Primary Table: kg7ToKg8 Row Count: 82,582 Data last updated: 2014-02-25
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 | uc010nxq.1 | 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 | uc010nxq.1 | 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 |
|---|
| uc010nxq.1 | chr1 | 11873 | 14409 | uc010nxq.1 | exact | |
| uc001aab.3 | chr1 | 11873 | 14409 | uc001aab.3 | exact | |
| uc001aaa.3 | chr1 | 11873 | 14409 | uc001aaa.3 | exact | |
| uc009viq.3 | chr1 | 14361 | 29370 | uc009viq.3 | exact | |
| uc001aac.4 | chr1 | 14361 | 29370 | uc001aah.4 | overlap | intronsChanged |
| uc001aah.4 | chr1 | 14361 | 29370 | uc001aah.4 | exact | |
| uc009vir.3 | chr1 | 14361 | 29370 | uc009vit.3 | overlap | differentNumberOfBlocks,intronsChanged,basesRemovedFromUTR |
| uc001aae.4 | chr1 | 14361 | 19759 | uc001aae.4 | exact | |
| uc009vit.3 | chr1 | 14361 | 19759 | uc009vit.3 | exact | |
| uc009viu.3 | chr1 | 14361 | 19759 | uc009viu.3 | exact | |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server