|
|
Database: nomLeu1 Primary Table: all_mrna Row Count: 204   Data last updated: 2020-08-22
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 | 942 | 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 | 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 | 0 | int(10) unsigned | range | Number of inserts in query |
qBaseInsert | 0 | int(10) unsigned | range | Number of bases inserted in query |
tNumInsert | 4 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 9308 | int(10) unsigned | range | Number of bases inserted in target |
strand | + | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | KJ531793 | varchar(255) | values | Query sequence name |
qSize | 4680 | int(10) unsigned | range | Query sequence size |
qStart | 3275 | int(10) unsigned | range | Alignment start position in query |
qEnd | 4217 | int(10) unsigned | range | Alignment end position in query |
tName | ADFV01139266 | varchar(255) | values | Target sequence name |
tSize | 12684 | int(10) unsigned | range | Target sequence size |
tStart | 513 | int(10) unsigned | range | Alignment start position in target |
tEnd | 10763 | int(10) unsigned | range | Alignment end position in target |
blockCount | 5 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 230,267,158,144,143, | longblob | | Size of each block |
qStarts | 3275,3505,3772,3930,4074, | longblob | | Start of each block in query. |
tStarts | 513,1992,5725,8388,10620, | 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 | 942 | 0 | 0 | 0 | 0 | 0 | 4 | 9308 | + | KJ531793 | 4680 | 3275 | 4217 | ADFV01139266 | 12684 | 513 | 10763 | 5 | 230,267,158,144,143, | 3275,3505,3772,3930,4074, | 513,1992,5725,8388,10620, |
73 | 1879 | 2 | 0 | 0 | 0 | 0 | 15 | 59677 | - | JQ231129 | 1881 | 0 | 1881 | GL397262 | 65759183 | 605190 | 666748 | 16 | 135,138,105,93,140,116,92,109,101,156,71,116,161,73,67,208, | 0,135,273,378,471,611,727,819,928,1029,1185,1256,1372,1533,1606,1673, | 605190,611755,612373,617798,619000,625229,626445,630712,630939,633797,641379,644916,649686,656017,662060,666540, |
90 | 3741 | 0 | 0 | 0 | 1 | 939 | 21 | 88838 | - | KJ531793 | 4680 | 0 | 4680 | GL397264 | 60541954 | 18596768 | 18689347 | 22 | 241,225,430,157,183,165,178,139,114,299,117,188,134,141,93,88,138,164,181,108,140,118, | 0,241,1405,1835,1992,2175,2340,2518,2657,2771,3070,3187,3375,3509,3650,3743,3831,3969,4133,4314,4422,4562, | 18596768,18599334,18608801,18612117,18613338,18619594,18620845,18626884,18628161,18631161,18633117,18637403,18641216,18650879,18 ... |
739 | 1463 | 1 | 0 | 0 | 2 | 21 | 5 | 16038 | - | EF551343 | 1485 | 0 | 1485 | GL397264 | 60541954 | 20224231 | 20241733 | 7 | 587,27,103,232,96,214,205, | 0,587,614,737,969,1065,1280, | 20224231,20225085,20225410,20239773,20240629,20241314,20241528, |
739 | 1497 | 0 | 0 | 0 | 0 | 0 | 6 | 17029 | + | EU124698 | 1497 | 0 | 1497 | GL397264 | 60541954 | 20263969 | 20282495 | 7 | 423,96,231,23,101,27,596, | 0,423,519,750,773,874,901, | 20263969,20264984,20266050,20278987,20281028,20281432,20281899, |
727 | 1836 | 0 | 0 | 0 | 0 | 0 | 3 | 1547 | - | JN966748 | 1836 | 0 | 1836 | GL397265 | 58224783 | 18696358 | 18699741 | 4 | 1106,141,163,426, | 0,1106,1247,1410, | 18696358,18697582,18698907,18699315, |
853 | 1720 | 2 | 0 | 0 | 0 | 0 | 7 | 6183 | - | HM486806 | 1722 | 0 | 1722 | GL397265 | 58224783 | 35164174 | 35172079 | 8 | 362,169,129,174,318,163,295,112, | 0,362,531,660,834,1152,1315,1610, | 35164174,35164965,35167488,35168212,35169320,35170035,35170568,35171967, |
107 | 3034 | 1 | 0 | 0 | 1 | 121 | 14 | 140411 | - | KJ531765 | 3354 | 0 | 3156 | GL397269 | 47109586 | 36134459 | 36277905 | 15 | 113,82,93,114,293,60,184,216,107,123,1146,123,115,70,196, | 198,311,393,486,600,893,953,1137,1353,1460,1583,2729,2852,3088,3158, | 36134459,36137518,36147632,36149600,36151195,36151609,36152268,36156365,36158099,36193419,36194543,36198430,36201251,36256614,36 ... |
666 | 2019 | 2 | 0 | 0 | 1 | 58 | 12 | 42778 | + | HM486777 | 2079 | 0 | 2079 | GL397271 | 42511992 | 10655011 | 10699810 | 13 | 109,52,85,58,102,73,141,102,137,55,89,95,923, | 0,109,161,304,362,464,537,678,780,917,972,1061,1156, | 10655011,10659873,10663766,10671494,10672505,10673243,10673498,10675051,10680848,10681910,10685971,10689206,10698887, |
10 | 1005 | 0 | 0 | 0 | 0 | 0 | 6 | 259925 | + | HM486815 | 1005 | 0 | 1005 | GL397283 | 28686067 | 15616680 | 15877610 | 7 | 139,176,167,156,107,148,112, | 0,139,315,482,638,745,893, | 15616680,15622838,15717905,15725815,15727079,15781081,15877498, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|