|
|
Database: danRer4 Primary Table: all_mrna Row Count: 40,413   Data last updated: 2020-08-21
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 73 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
matches | 760 | int(10) unsigned | range | Number of bases that match that aren't repeats |
misMatches | 27 | int(10) unsigned | range | Number of bases that don't match |
repMatches | 54 | 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 | 3 | int(10) unsigned | range | Number of inserts in query |
qBaseInsert | 19 | int(10) unsigned | range | Number of bases inserted in query |
tNumInsert | 5 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 92218 | int(10) unsigned | range | Number of bases inserted in target |
strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | BC095673 | varchar(255) | values | Query sequence name |
qSize | 1104 | int(10) unsigned | range | Query sequence size |
qStart | 0 | int(10) unsigned | range | Alignment start position in query |
qEnd | 860 | int(10) unsigned | range | Alignment end position in query |
tName | chr1 | varchar(255) | values | Target sequence name |
tSize | 70589895 | int(10) unsigned | range | Target sequence size |
tStart | 67209 | int(10) unsigned | range | Alignment start position in target |
tEnd | 160268 | int(10) unsigned | range | Alignment end position in target |
blockCount | 7 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 200,9,4,263,190,76,99, | longblob | | Size of each block |
qStarts | 244,444,470,475,738,928,1005, | longblob | | Start of each block in query. |
tStarts | 67209,67410,67445,67449,140... | 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 |
---|
73 | 760 | 27 | 54 | 0 | 3 | 19 | 5 | 92218 | - | BC095673 | 1104 | 0 | 860 | chr1 | 70589895 | 67209 | 160268 | 7 | 200,9,4,263,190,76,99, | 244,444,470,475,738,928,1005, | 67209,67410,67445,67449,140671,160091,160169, |
914 | 164 | 5 | 0 | 0 | 1 | 12 | 1 | 12 | + | AF246188 | 360 | 167 | 348 | chr24 | 46081529 | 43160532 | 43160713 | 2 | 46,123, | 167,225, | 43160532,43160590, |
914 | 217 | 1 | 0 | 0 | 1 | 20 | 2 | 1282 | - | EF222441 | 574 | 327 | 565 | chr24 | 46081529 | 43164087 | 43165587 | 3 | 56,127,35, | 9,85,212, | 43164087,43164148,43165552, |
586 | 1517 | 4 | 29 | 0 | 3 | 13 | 5 | 3610 | - | BC142883 | 1581 | 4 | 1567 | chr1 | 70589895 | 162675 | 167835 | 9 | 234,239,145,56,169,116,142,229,220, | 14,251,498,643,701,870,986,1128,1357, | 162675,162909,163148,163294,163350,163520,165380,166057,167615, |
73 | 688 | 4 | 0 | 0 | 0 | 0 | 4 | 22918 | - | EF463079 | 1237 | 537 | 1229 | chr1 | 70589895 | 247919 | 271529 | 5 | 129,95,157,54,257, | 8,137,232,389,443, | 247919,256467,260612,261111,271272, |
73 | 634 | 4 | 0 | 0 | 0 | 0 | 3 | 22972 | - | EU284559 | 1183 | 537 | 1175 | chr1 | 70589895 | 247919 | 271529 | 4 | 129,95,157,257, | 8,137,232,389, | 247919,256467,260612,271272, |
73 | 957 | 5 | 0 | 0 | 0 | 0 | 5 | 27848 | - | EF463080 | 1630 | 660 | 1622 | chr1 | 70589895 | 247919 | 276729 | 6 | 129,53,157,255,201,167, | 8,137,190,347,602,803, | 247919,256467,260612,271272,275892,276562, |
73 | 1052 | 6 | 0 | 0 | 0 | 0 | 6 | 27752 | - | EF463081 | 1726 | 660 | 1718 | chr1 | 70589895 | 247919 | 276729 | 7 | 129,95,157,54,255,201,167, | 8,137,232,389,443,698,899, | 247919,256467,260612,261111,271272,275892,276562, |
73 | 934 | 0 | 0 | 0 | 0 | 0 | 6 | 27794 | - | BC171362 | 1400 | 466 | 1400 | chr1 | 70589895 | 248001 | 276729 | 7 | 47,53,157,54,255,201,167, | 0,47,100,257,311,566,767, | 248001,256467,260612,261111,271272,275892,276562, |
589 | 3422 | 54 | 247 | 1 | 1 | 2 | 22 | 11604 | - | AY094620 | 3838 | 5 | 3731 | chr1 | 70589895 | 576068 | 591396 | 23 | 191,422,92,102,131,146,124,155,169,151,134,179,193,135,309,269,118,135,114,201,60,114,80, | 107,300,722,814,916,1047,1193,1317,1472,1641,1792,1926,2105,2298,2433,2742,3011,3129,3264,3378,3579,3639,3753, | 576068,576262,581925,582111,582354,582591,582812,583023,583253,583513,583741,583956,584223,584526,586099,586489,588542,588746,58 ... |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|