|
|
Database: musFur1 Primary Table: all_mrna Row Count: 118,076   Data last updated: 2020-08-19
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 585 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
matches | 673 | int(10) unsigned | range | Number of bases that match that aren't repeats |
misMatches | 0 | int(10) unsigned | range | Number of bases that don't match |
repMatches | 138 | 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 | 0 | int(10) unsigned | range | Number of inserts in query |
qBaseInsert | 0 | int(10) unsigned | range | Number of bases inserted in query |
tNumInsert | 5 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 2077 | int(10) unsigned | range | Number of bases inserted in target |
strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | JR782665 | varchar(255) | values | Query sequence name |
qSize | 818 | int(10) unsigned | range | Query sequence size |
qStart | 7 | int(10) unsigned | range | Alignment start position in query |
qEnd | 818 | int(10) unsigned | range | Alignment end position in query |
tName | AEYP01108159 | varchar(255) | values | Target sequence name |
tSize | 42269 | int(10) unsigned | range | Target sequence size |
tStart | 14476 | int(10) unsigned | range | Alignment start position in target |
tEnd | 17364 | int(10) unsigned | range | Alignment end position in target |
blockCount | 6 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 91,419,115,63,43,80, | longblob | | Size of each block |
qStarts | 0,91,510,625,688,731, | longblob | | Start of each block in query. |
tStarts | 14476,14756,15561,16758,171... | 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 |
---|
585 | 673 | 0 | 138 | 0 | 0 | 0 | 5 | 2077 | - | JR782665 | 818 | 7 | 818 | AEYP01108159 | 42269 | 14476 | 17364 | 6 | 91,419,115,63,43,80, | 0,91,510,625,688,731, | 14476,14756,15561,16758,17148,17284, |
585 | 390 | 0 | 47 | 0 | 0 | 0 | 1 | 386 | - | EZ501644 | 437 | 0 | 437 | AEYP01108159 | 42269 | 14765 | 15588 | 2 | 410,27, | 0,410, | 14765,15561, |
585 | 537 | 0 | 47 | 0 | 0 | 0 | 2 | 1468 | - | JP012862 | 584 | 0 | 584 | AEYP01108159 | 42269 | 14768 | 16820 | 3 | 407,115,62, | 0,407,522, | 14768,15561,16758, |
585 | 211 | 0 | 0 | 0 | 1 | 5 | 3 | 1414 | - | EZ493293 | 216 | 0 | 216 | AEYP01108159 | 42269 | 15560 | 17185 | 4 | 87,24,63,37, | 0,92,116,179, | 15560,15652,16758,17148, |
585 | 891 | 0 | 0 | 0 | 7 | 9 | 5 | 1863 | - | JR781024 | 900 | 0 | 900 | AEYP01108159 | 42269 | 19265 | 22019 | 12 | 30,4,60,74,106,5,311,13,77,86,74,51, | 0,33,38,98,173,279,285,597,611,689,775,849, | 19265,19296,19300,19361,19435,20147,20152,20463,20476,20553,21012,21968, |
585 | 736 | 0 | 0 | 0 | 0 | 0 | 2 | 979 | - | JP012861 | 741 | 0 | 736 | AEYP01108159 | 42269 | 19342 | 21057 | 3 | 199,492,45, | 5,204,696, | 19342,20147,21012, |
585 | 203 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | EZ500165 | 203 | 0 | 203 | AEYP01108159 | 42269 | 20283 | 20486 | 1 | 203, | 0, | 20283, |
585 | 412 | 0 | 0 | 0 | 4 | 4 | 3 | 1846 | - | JR792469 | 417 | 1 | 417 | AEYP01108159 | 42269 | 20393 | 22651 | 8 | 12,6,6,68,4,149,74,93, | 0,12,19,26,95,100,249,323, | 20393,20406,20412,20418,20486,20490,21012,22558, |
585 | 372 | 0 | 0 | 0 | 9 | 15 | 4 | 1850 | - | JR784318 | 388 | 1 | 388 | AEYP01108159 | 42269 | 20407 | 22629 | 13 | 14,22,29,18,21,6,8,19,48,46,74,30,37, | 0,15,38,68,87,109,116,125,145,193,239,313,350, | 20407,20421,20443,20472,20490,20511,20517,20525,20544,20593,21012,22558,22592, |
585 | 393 | 19 | 0 | 0 | 1 | 1 | 1 | 103 | - | JR787408 | 453 | 1 | 414 | AEYP01108526 | 24660 | 15239 | 15754 | 3 | 11,311,90, | 39,51,362, | 15239,15250,15664, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|