|
|---|
| |
Database: droMoj2 Primary Table: xenoMrna Row Count: 3,280,322 Data last updated: 2016-02-15
On download server: MariaDB table dump directory
| field | example | SQL type |
|---|
| bin | 585 | smallint(5) unsigned |
| matches | 107 | int(10) unsigned |
| misMatches | 64 | int(10) unsigned |
| repMatches | 0 | int(10) unsigned |
| nCount | 0 | int(10) unsigned |
| qNumInsert | 1 | int(10) unsigned |
| qBaseInsert | 27 | int(10) unsigned |
| tNumInsert | 1 | int(10) unsigned |
| tBaseInsert | 27 | int(10) unsigned |
| strand | ++ | char(2) |
| qName | X66695 | varchar(255) |
| qSize | 3500 | int(10) unsigned |
| qStart | 528 | int(10) unsigned |
| qEnd | 726 | int(10) unsigned |
| tName | scaffold_1038 | varchar(255) |
| tSize | 1046 | int(10) unsigned |
| tStart | 27 | int(10) unsigned |
| tEnd | 225 | int(10) unsigned |
| blockCount | 2 | int(10) unsigned |
| blockSizes | 126,45, | longblob |
| qStarts | 528,681, | longblob |
| tStarts | 27,180, | longblob |
|
| |
|
|
|
Connected Tables and Joining Fields
|
|
|
Sample Rows
|
|---|
| |
| bin | matches | misMatches | repMatches | nCount | qNumInsert | qBaseInsert | tNumInsert | tBaseInsert | strand | qName | qSize | qStart | qEnd | tName | tSize | tStart | tEnd | blockCount | blockSizes | qStarts | tStarts |
|---|
| 585 | 107 | 64 | 0 | 0 | 1 | 27 | 1 | 27 | ++ | X66695 | 3500 | 528 | 726 | scaffold_1038 | 1046 | 27 | 225 | 2 | 126,45, | 528,681, | 27,180, |
| 585 | 94 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | EZ421277 | 514 | 276 | 372 | scaffold_1038 | 1046 | 753 | 849 | 1 | 96, | 276, | 753, |
| 585 | 94 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | EZ421554 | 514 | 276 | 372 | scaffold_1038 | 1046 | 753 | 849 | 1 | 96, | 276, | 753, |
| 585 | 106 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | AK256035 | 110 | 0 | 110 | scaffold_1038 | 1046 | 845 | 955 | 1 | 110, | 0, | 845, |
| 585 | 94 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | +- | EZ421277 | 514 | 276 | 372 | scaffold_1039 | 1033 | 178 | 274 | 1 | 96, | 276, | 759, |
| 585 | 94 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | +- | EZ421554 | 514 | 276 | 372 | scaffold_1039 | 1033 | 178 | 274 | 1 | 96, | 276, | 759, |
| 585 | 75 | 39 | 0 | 0 | 0 | 0 | 0 | 0 | +- | HP477402 | 2643 | 849 | 963 | scaffold_1040 | 1317 | 87 | 201 | 1 | 114, | 849, | 1116, |
| 585 | 75 | 39 | 0 | 0 | 0 | 0 | 0 | 0 | +- | HP532335 | 2057 | 605 | 719 | scaffold_1040 | 1317 | 87 | 201 | 1 | 114, | 605, | 1116, |
| 585 | 75 | 39 | 0 | 0 | 0 | 0 | 0 | 0 | +- | HP532337 | 2507 | 1055 | 1169 | scaffold_1040 | 1317 | 87 | 201 | 1 | 114, | 1055, | 1116, |
| 585 | 75 | 39 | 0 | 0 | 0 | 0 | 0 | 0 | +- | HP564707 | 2268 | 19 | 133 | scaffold_1040 | 1317 | 87 | 201 | 1 | 114, | 19, | 1116, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server