|
|---|
| |
Database: droVir2 Primary Table: xenoMrna Row Count: 3,512,506 Data last updated: 2016-02-15
On download server: MariaDB table dump directory
| field | example | SQL type |
|---|
| bin | 585 | smallint(5) unsigned |
| matches | 67 | int(10) unsigned |
| misMatches | 14 | int(10) unsigned |
| repMatches | 0 | int(10) unsigned |
| nCount | 0 | int(10) unsigned |
| qNumInsert | 0 | int(10) unsigned |
| qBaseInsert | 0 | int(10) unsigned |
| tNumInsert | 0 | int(10) unsigned |
| tBaseInsert | 0 | int(10) unsigned |
| strand | ++ | char(2) |
| qName | FQ233356 | varchar(255) |
| qSize | 1045 | int(10) unsigned |
| qStart | 1 | int(10) unsigned |
| qEnd | 82 | int(10) unsigned |
| tName | scaffold_10001 | varchar(255) |
| tSize | 9183 | int(10) unsigned |
| tStart | 149 | int(10) unsigned |
| tEnd | 230 | int(10) unsigned |
| blockCount | 1 | int(10) unsigned |
| blockSizes | 81, | longblob |
| qStarts | 1, | longblob |
| tStarts | 149, | 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 | 67 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | FQ233356 | 1045 | 1 | 82 | scaffold_10001 | 9183 | 149 | 230 | 1 | 81, | 1, | 149, |
| 585 | 69 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | AJ311501 | 1516 | 1 | 83 | scaffold_10001 | 9183 | 149 | 231 | 1 | 82, | 1, | 149, |
| 585 | 69 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | AK236486 | 1562 | 7 | 89 | scaffold_10001 | 9183 | 149 | 231 | 1 | 82, | 7, | 149, |
| 585 | 69 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | BC154743 | 2086 | 7 | 89 | scaffold_10001 | 9183 | 149 | 231 | 1 | 82, | 7, | 149, |
| 585 | 70 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | CT025457 | 2529 | 2344 | 2426 | scaffold_10001 | 9183 | 149 | 231 | 1 | 82, | 2344, | 149, |
| 585 | 69 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | FQ211544 | 184 | 7 | 89 | scaffold_10001 | 9183 | 149 | 231 | 1 | 82, | 7, | 149, |
| 585 | 69 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | FQ223150 | 1002 | 2 | 84 | scaffold_10001 | 9183 | 149 | 231 | 1 | 82, | 2, | 149, |
| 585 | 69 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | FQ224447 | 643 | 1 | 83 | scaffold_10001 | 9183 | 149 | 231 | 1 | 82, | 1, | 149, |
| 585 | 69 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | FQ224513 | 179 | 1 | 83 | scaffold_10001 | 9183 | 149 | 231 | 1 | 82, | 1, | 149, |
| 585 | 69 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | FQ225235 | 941 | 2 | 84 | scaffold_10001 | 9183 | 149 | 231 | 1 | 82, | 2, | 149, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server