Schema for Dongbu102 snps - Dongbu102 snps
|
|
Database: Radish Primary Table: C2_SNP Row Count: 1,672,295
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 | 881 | 882 | C/T | 0 | + | 881 | 882 | 255,0,0 |
R1 | 987 | 988 | G/C | 0 | + | 987 | 988 | 0,255,0 |
R1 | 1013 | 1014 | T/C | 0 | + | 1013 | 1014 | 0,255,0 |
R1 | 1030 | 1031 | A/G | 0 | + | 1030 | 1031 | 0,255,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 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|