|
|
Database: strPur1 Primary Table: all_mrna Row Count: 47,891   Data last updated: 2019-07-01
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 | 746 | 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 | 7 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 4142 | int(10) unsigned | range | Number of bases inserted in target |
strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | JT095622 | varchar(255) | values | Query sequence name |
qSize | 746 | int(10) unsigned | range | Query sequence size |
qStart | 0 | int(10) unsigned | range | Alignment start position in query |
qEnd | 746 | int(10) unsigned | range | Alignment end position in query |
tName | Scaffold1 | varchar(255) | values | Target sequence name |
tSize | 962155 | int(10) unsigned | range | Target sequence size |
tStart | 185 | int(10) unsigned | range | Alignment start position in target |
tEnd | 5073 | int(10) unsigned | range | Alignment end position in target |
blockCount | 8 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 70,40,76,106,96,124,122,112, | longblob | | Size of each block |
qStarts | 0,70,110,186,292,388,512,634, | longblob | | Start of each block in query. |
tStarts | 185,825,1543,2007,2521,3423... | 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 | 746 | 0 | 0 | 0 | 0 | 0 | 7 | 4142 | - | JT095622 | 746 | 0 | 746 | Scaffold1 | 962155 | 185 | 5073 | 8 | 70,40,76,106,96,124,122,112, | 0,70,110,186,292,388,512,634, | 185,825,1543,2007,2521,3423,4125,4961, |
585 | 2188 | 31 | 138 | 0 | 2 | 11 | 6 | 1901 | + | JT121197 | 2723 | 354 | 2722 | Scaffold1 | 962155 | 15222 | 19480 | 8 | 38,744,39,285,203,147,204,697, | 354,392,1136,1175,1467,1670,1821,2025, | 15222,15854,16615,16681,16969,17174,17321,18783, |
585 | 1050 | 13 | 0 | 0 | 0 | 0 | 2 | 1163 | - | JT122506 | 1063 | 0 | 1063 | Scaffold1 | 962155 | 22767 | 24993 | 3 | 746,179,138, | 0,746,925, | 22767,24093,24855, |
585 | 1204 | 0 | 0 | 0 | 0 | 0 | 3 | 2130 | - | JT102440 | 1204 | 0 | 1204 | Scaffold1 | 962155 | 22767 | 26101 | 4 | 746,179,134,145, | 0,746,925,1059, | 22767,24093,24855,25956, |
585 | 2260 | 43 | 0 | 0 | 4 | 5 | 4 | 3218 | + | JT123297 | 2372 | 64 | 2372 | Scaffold1 | 962155 | 26389 | 31910 | 9 | 56,112,106,239,148,974,77,584,7, | 64,121,233,339,578,726,1701,1779,2365, | 26389,26445,27663,28258,29136,30268,31242,31319,31903, |
585 | 1067 | 57 | 0 | 0 | 11 | 81 | 13 | 84 | - | JT101771 | 1996 | 791 | 1996 | Scaffold1 | 962155 | 35089 | 36297 | 18 | 81,10,14,5,41,39,89,6,13,114,33,108,2,2,24,24,68,451, | 0,82,106,125,131,175,217,306,345,358,473,520,628,630,632,656,682,754, | 35089,35170,35185,35200,35205,35247,35295,35385,35407,35421,35535,35594,35703,35706,35709,35752,35776,35846, |
586 | 5932 | 8 | 753 | 0 | 0 | 0 | 9 | 4323 | - | JT119717 | 6693 | 0 | 6693 | Scaffold1 | 962155 | 137780 | 148796 | 10 | 5459,344,404,119,105,4,15,13,49,181, | 0,5459,5803,6207,6326,6431,6435,6450,6463,6512, | 137780,143805,144621,145632,147270,147832,147837,147853,147867,148615, |
586 | 1016 | 0 | 0 | 0 | 1 | 154 | 7 | 84328 | - | JT117324 | 1170 | 0 | 1170 | Scaffold1 | 962155 | 151230 | 236574 | 8 | 100,117,174,151,132,109,109,124, | 0,100,217,391,542,674,783,1046, | 151230,153025,153851,154490,155166,169261,186159,236450, |
586 | 1263 | 0 | 0 | 0 | 1 | 155 | 7 | 88509 | - | JT110680 | 1418 | 0 | 1418 | Scaffold1 | 962155 | 151230 | 241002 | 8 | 100,117,174,151,132,109,109,371, | 0,100,217,391,542,674,783,1047, | 151230,153025,153851,154490,155166,169261,186159,240631, |
73 | 7088 | 41 | 111 | 0 | 2 | 16 | 9 | 73344 | + | JT115239 | 7849 | 593 | 7849 | Scaffold1 | 962155 | 328625 | 409209 | 10 | 170,67,108,87,4361,775,15,105,25,1527, | 593,763,830,938,1025,5397,6172,6187,6297,6322, | 328625,369980,391600,399609,402379,406742,407519,407535,407649,407682, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|