Schema for Wild radish2 snps - Wild radish2 snps |
|---|
| |
Database: Radish Primary Table: W2_SNP Row Count: 1,497,359
| 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 | 1119 | 1120 | C/T | 0 | + | 1119 | 1120 | 0,0,255 |
| R1 | 1275 | 1276 | T/C | 0 | + | 1275 | 1276 | 0,0,255 |
| R1 | 1309 | 1310 | G/C | 0 | + | 1309 | 1310 | 0,255,0 |
| R1 | 1314 | 1315 | C/G | 0 | + | 1314 | 1315 | 0,0,255 |
| R1 | 1323 | 1324 | G/T | 0 | + | 1323 | 1324 | 0,0,255 |
| R1 | 1326 | 1327 | C/T | 0 | + | 1326 | 1327 | 0,0,255 |
| R1 | 1344 | 1345 | G/C | 0 | + | 1344 | 1345 | 0,0,255 |
| R1 | 1350 | 1351 | C/A | 0 | + | 1350 | 1351 | 0,0,255 |
| R1 | 1351 | 1352 | C/A | 0 | + | 1351 | 1352 | 0,255,0 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|