Schema for WK10024 snps - WK10024 snps |
|---|
| |
Database: Radish Primary Table: WK24_SNP Row Count: 1,664,021
| field | example | SQL type |
|---|
| chrom | R1 | varchar(255) |
| chromStart | 569 | int(10) unsigned |
| chromEnd | 570 | int(10) unsigned |
| name | G/A | varchar(255) |
| score | 0 | int(10) unsigned |
| strand | + | char(1) |
| thickStart | 569 | int(10) unsigned |
| thickEnd | 570 | int(10) unsigned |
| itemRgb | 16711680 | int(10) unsigned |
|
| |
|
|
|
Sample Rows
|
|---|
| |
| chrom | chromStart | chromEnd | name | score | strand | thickStart | thickEnd | itemRgb |
|---|
| R1 | 569 | 570 | G/A | 0 | + | 569 | 570 | 255,0,0 |
| R1 | 793 | 794 | T/C | 0 | + | 793 | 794 | 255,0,0 |
| R1 | 1072 | 1073 | C/T | 0 | + | 1072 | 1073 | 0,255,0 |
| R1 | 1131 | 1132 | A/T | 0 | + | 1131 | 1132 | 0,0,255 |
| R1 | 1147 | 1148 | T/G | 0 | + | 1147 | 1148 | 0,255,0 |
| R1 | 1287 | 1288 | A/T | 0 | + | 1287 | 1288 | 0,0,255 |
| R1 | 1401 | 1402 | T/A | 0 | + | 1401 | 1402 | 0,0,255 |
| R1 | 1434 | 1435 | G/A | 0 | + | 1434 | 1435 | 0,0,255 |
| R1 | 1453 | 1454 | T/C | 0 | + | 1453 | 1454 | 0,0,255 |
| R1 | 1487 | 1488 | A/C | 0 | + | 1487 | 1488 | 0,255,0 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|