|
|
Database: papAnu4 Primary Table: all_mrna Row Count: 739   Data last updated: 2019-01-11
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 587 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
matches | 2463 | int(10) unsigned | range | Number of bases that match that aren't repeats |
misMatches | 88 | int(10) unsigned | range | Number of bases that don't match |
repMatches | 0 | int(10) unsigned | range | Number of bases that match but are part of repeats |
nCount | 0 | int(10) unsigned | range | Number of 'N' bases |
qNumInsert | 1 | int(10) unsigned | range | Number of inserts in query |
qBaseInsert | 8 | int(10) unsigned | range | Number of bases inserted in query |
tNumInsert | 5 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 572 | int(10) unsigned | range | Number of bases inserted in target |
strand | + | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | DQ381400 | varchar(255) | values | Query sequence name |
qSize | 2559 | int(10) unsigned | range | Query sequence size |
qStart | 0 | int(10) unsigned | range | Alignment start position in query |
qEnd | 2559 | int(10) unsigned | range | Alignment end position in query |
tName | chr1 | varchar(255) | values | Target sequence name |
tSize | 217458864 | int(10) unsigned | range | Target sequence size |
tStart | 292074 | int(10) unsigned | range | Alignment start position in target |
tEnd | 295197 | int(10) unsigned | range | Alignment end position in target |
blockCount | 6 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 191,301,783,204,110,962, | longblob | | Size of each block |
qStarts | 0,191,492,1275,1479,1597, | longblob | | Start of each block in query. |
tStarts | 292074,292366,292752,293649... | longblob | | Start of each block in target. |
|
| |
|
|
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 |
---|
587 | 2463 | 88 | 0 | 0 | 1 | 8 | 5 | 572 | + | DQ381400 | 2559 | 0 | 2559 | chr1 | 217458864 | 292074 | 295197 | 6 | 191,301,783,204,110,962, | 0,191,492,1275,1479,1597, | 292074,292366,292752,293649,293989,294235, |
636 | 713 | 1 | 0 | 0 | 0 | 0 | 6 | 18364 | - | FJ348360 | 714 | 0 | 714 | chr1 | 217458864 | 6754031 | 6773109 | 7 | 65,132,131,67,138,108,73, | 0,65,197,328,395,533,641, | 6754031,6766586,6768115,6770770,6771251,6771778,6773036, |
656 | 544 | 0 | 0 | 0 | 0 | 0 | 1 | 1105 | + | EU035757 | 544 | 0 | 544 | chr1 | 217458864 | 9321523 | 9323172 | 2 | 79,465, | 0,79, | 9321523,9322707, |
83 | 2272 | 2 | 0 | 0 | 0 | 0 | 16 | 18374 | + | KX356076 | 2274 | 0 | 2274 | chr1 | 217458864 | 10873635 | 10894283 | 17 | 175,136,163,125,109,108,154,68,122,127,105,103,221,156,197,135,70, | 0,175,311,474,599,708,816,970,1038,1160,1287,1392,1495,1716,1872,2069,2204, | 10873635,10876665,10880000,10881129,10882899,10883116,10885214,10885583,10885796,10888216,10888731,10889050,10889932,10890744,10 ... |
716 | 2223 | 1 | 0 | 0 | 1 | 296 | 4 | 17212 | - | DQ386300 | 2520 | 0 | 2520 | chr1 | 217458864 | 17187114 | 17206550 | 5 | 929,124,210,777,184, | 0,929,1053,1263,2336, | 17187114,17189235,17197965,17202864,17206366, |
91 | 1745 | 1 | 0 | 0 | 0 | 0 | 7 | 14507 | + | KX356080 | 1746 | 0 | 1746 | chr1 | 217458864 | 18989963 | 19006216 | 8 | 387,288,101,183,164,128,237,258, | 0,387,675,776,959,1123,1251,1488, | 18989963,18993986,18996011,19000948,19002025,19004033,19004525,19005958, |
94 | 1078 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | - | KX356083 | 1083 | 0 | 1083 | chr1 | 217458864 | 22150269 | 22151352 | 1 | 1083, | 0, | 22150269, |
882 | 64 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | + | MF190779 | 64 | 0 | 64 | chr1 | 217458864 | 39025129 | 39025193 | 1 | 64, | 0, | 39025129, |
899 | 1383 | 0 | 0 | 0 | 0 | 0 | 8 | 30701 | - | GQ352544 | 1383 | 0 | 1383 | chr1 | 217458864 | 41211164 | 41243248 | 9 | 201,204,102,105,188,163,241,161,18, | 0,201,405,507,612,800,963,1204,1365, | 41211164,41211739,41213072,41213350,41213735,41214015,41214776,41215196,41243230, |
926 | 1740 | 0 | 0 | 0 | 0 | 0 | 14 | 18097 | + | KX356074 | 1740 | 0 | 1740 | chr1 | 217458864 | 44765632 | 44785469 | 15 | 195,114,135,134,207,41,125,126,98,100,41,40,109,146,129, | 0,195,309,444,578,785,826,951,1077,1175,1275,1316,1356,1465,1611, | 44765632,44774049,44777271,44777637,44777848,44778298,44778499,44780316,44780991,44782292,44782707,44783502,44784033,44784967,44 ... |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|