|
|
Database: macEug2 Primary Table: xenoMrna Row Count: 6,759,450   Data last updated: 2016-02-16
On download server: MariaDB table dump directory
field | example | SQL type |
bin | 585 | smallint(5) unsigned |
matches | 140 | int(10) unsigned |
misMatches | 41 | 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 | JI430307 | varchar(255) |
qSize | 393 | int(10) unsigned |
qStart | 210 | int(10) unsigned |
qEnd | 391 | int(10) unsigned |
tName | ABQO010000375 | varchar(255) |
tSize | 938 | int(10) unsigned |
tStart | 551 | int(10) unsigned |
tEnd | 732 | int(10) unsigned |
blockCount | 1 | int(10) unsigned |
blockSizes | 181, | longblob |
qStarts | 210, | longblob |
tStarts | 551, | 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 | 140 | 41 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | JI430307 | 393 | 210 | 391 | ABQO010000375 | 938 | 551 | 732 | 1 | 181, | 210, | 551, |
585 | 140 | 58 | 0 | 0 | 0 | 0 | 0 | 0 | +- | JP328108 | 1063 | 509 | 707 | ABQO010000375 | 938 | 551 | 749 | 1 | 198, | 509, | 189, |
585 | 106 | 44 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | HP503938 | 523 | 337 | 487 | ABQO010000375 | 938 | 552 | 702 | 1 | 150, | 337, | 552, |
585 | 112 | 47 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | HP479561 | 453 | 293 | 452 | ABQO010000375 | 938 | 552 | 711 | 1 | 159, | 293, | 552, |
585 | 114 | 51 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | JP344452 | 618 | 433 | 598 | ABQO010000375 | 938 | 552 | 717 | 1 | 165, | 433, | 552, |
585 | 160 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | JI895261 | 929 | 748 | 928 | ABQO010000375 | 938 | 552 | 732 | 1 | 180, | 748, | 552, |
585 | 160 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | JP043533 | 929 | 748 | 928 | ABQO010000375 | 938 | 552 | 732 | 1 | 180, | 748, | 552, |
585 | 150 | 48 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | AK174722 | 732 | 14 | 212 | ABQO010000375 | 938 | 552 | 750 | 1 | 198, | 14, | 552, |
585 | 143 | 54 | 0 | 0 | 0 | 0 | 1 | 1 | ++ | CU679135 | 1110 | 842 | 1039 | ABQO010000375 | 938 | 552 | 750 | 2 | 128,69, | 842,970, | 552,681, |
585 | 73 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | +- | JO680000 | 629 | 519 | 627 | ABQO010000375 | 938 | 608 | 716 | 1 | 108, | 519, | 222, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|