|
|---|
| |
Database: hg38 Primary Table: kg10ToKg11 Row Count: 197,782 Data last updated: 2018-09-05
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 | uc031tla.1 | varchar(255) | values | Old gene ID |
| oldChrom | chr1 | varchar(255) | values | Old chromosome |
| oldStart | 17368 | int(11) | range | Old start position |
| oldEnd | 17436 | int(11) | range | Old end position |
| newId | ENST00000619216.1 | varchar(255) | values | New gene ID, may be empty |
| status | overlap | varchar(255) | values | How new/old correspond. Exact and compatible are good. Overlap, none are bad. |
| note | noChange | varchar(255) | values | Additional info if status if overlap or none. |
|
| |
|
|
|
Sample Rows
|
|---|
| |
| oldId | oldChrom | oldStart | oldEnd | newId | status | note |
|---|
| uc031tla.1 | chr1 | 17368 | 17436 | ENST00000619216.1 | overlap | noChange |
| uc057aty.1 | chr1 | 29553 | 31097 | ENST00000473358.1 | overlap | noChange |
| uc057atz.1 | chr1 | 30266 | 31109 | ENST00000469289.1 | overlap | noChange |
| uc031tlb.1 | chr1 | 30365 | 30503 | ENST00000469289.1 | overlap | differentNumberOfBlocks,intronsChanged,basesAddedToUTR |
| uc001aak.4 | chr1 | 34553 | 36081 | ENST00000417324.1 | overlap | noChange |
| uc057aua.1 | chr1 | 35244 | 36073 | ENST00000461467.1 | overlap | noChange |
| uc001aal.1 | chr1 | 69090 | 70008 | ENST00000641515.2 | overlap | differentNumberOfBlocks,basesAddedToCoding,intronsChanged,basesAddedToUTR |
| uc057aub.1 | chr1 | 89294 | 120932 | ENST00000466430.5 | overlap | noChange |
| uc057auc.1 | chr1 | 89550 | 91105 | ENST00000466430.5 | overlap | differentNumberOfBlocks,intronsChanged,basesAddedToUTR |
| uc057aud.1 | chr1 | 92229 | 129217 | ENST00000477740.5 | overlap | noChange |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server