|
|---|
| |
Database: equCab2 Primary Table: xenoMrna Row Count: 6,182,435 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 | description |
|---|
| bin | 585 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
| matches | 654 | int(10) unsigned | Number of bases that match that aren't repeats |
| misMatches | 123 | int(10) unsigned | Number of bases that don't match |
| repMatches | 0 | int(10) unsigned | Number of bases that match but are part of repeats |
| nCount | 0 | int(10) unsigned | Number of 'N' bases |
| qNumInsert | 5 | int(10) unsigned | Number of inserts in query |
| qBaseInsert | 255 | int(10) unsigned | Number of bases inserted in query |
| tNumInsert | 11 | int(10) unsigned | Number of inserts in target |
| tBaseInsert | 8167 | int(10) unsigned | Number of bases inserted in target |
| strand | ++ | char(2) | + or - for strand. First character query, second target (optional) |
| qName | AK305863 | varchar(255) | Query sequence name |
| qSize | 1392 | int(10) unsigned | Query sequence size |
| qStart | 1 | int(10) unsigned | Alignment start position in query |
| qEnd | 1033 | int(10) unsigned | Alignment end position in query |
| tName | chr1 | varchar(255) | Target sequence name |
| tSize | 185838109 | int(10) unsigned | Target sequence size |
| tStart | 7032 | int(10) unsigned | Alignment start position in target |
| tEnd | 15976 | int(10) unsigned | Alignment end position in target |
| blockCount | 12 | int(10) unsigned | Number of blocks in alignment |
| blockSizes | 51,20,52,60,74,53,93,64,67,... | longblob | Size of each block |
| qStarts | 1,88,190,242,302,424,477,57... | longblob | Start of each block in query. |
| tStarts | 7032,7111,11209,11908,12331... | 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 | 654 | 123 | 0 | 0 | 5 | 255 | 11 | 8167 | ++ | AK305863 | 1392 | 1 | 1033 | chr1 | 185838109 | 7032 | 15976 | 12 | 51,20,52,60,74,53,93,64,67,126,18,99, | 1,88,190,242,302,424,477,570,634,701,872,934, | 7032,7111,11209,11908,12331,13298,14079,14420,15297,15446,15687,15877, |
| 585 | 771 | 93 | 0 | 0 | 5 | 173 | 13 | 8329 | +- | KA513296 | 1162 | 90 | 1127 | chr1 | 185838109 | 7048 | 16241 | 14 | 45,90,62,41,70,68,63,91,56,49,76,61,65,27, | 90,136,272,334,386,456,524,587,679,735,784,860,921,1100, | 185821868,185822143,185822406,185822540,185822595,185822746,185823625,185823937,185824756,185825062,185825704,185826142,18582684 ... |
| 585 | 66 | 33 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | JT702008 | 540 | 213 | 312 | chr1 | 185838109 | 9009 | 9108 | 1 | 99, | 213, | 9009, |
| 73 | 2702 | 527 | 0 | 0 | 48 | 3782 | 51 | 125090 | +- | AB209700 | 7917 | 8 | 7019 | chr1 | 185838109 | 11010 | 139329 | 58 | 159,10,63,5,169,2,175,142,190,81,108,6,12,50,11,17,116,45,18,138,93,30,87,123,84,13,10,21,43,19,42,11,11,17,4,9,9,159,63,33,4,45 ... | 8,297,400,464,540,709,711,886,1028,1279,1435,1545,1552,1805,1929,1941,2040,2249,2341,2471,2667,3086,3449,3737,3894,4152,4168,421 ... | 185698780,185699041,185699136,185699199,185699257,185699440,185699784,185701067,185703781,185704569,185821504,185821612,18582162 ... |
| 585 | 237 | 17 | 0 | 0 | 0 | 0 | 3 | 1603 | +- | JR407504 | 301 | 38 | 292 | chr1 | 185838109 | 11191 | 13048 | 4 | 48,75,60,71, | 38,86,161,221, | 185825061,185825703,185826141,185826847, |
| 585 | 225 | 16 | 0 | 0 | 0 | 0 | 4 | 1616 | +- | JR418071 | 288 | 34 | 275 | chr1 | 185838109 | 11191 | 13048 | 5 | 48,40,23,60,70, | 34,82,122,145,205, | 185825061,185825703,185825755,185826141,185826848, |
| 585 | 418 | 43 | 0 | 0 | 0 | 0 | 6 | 2831 | +- | KA439827 | 489 | 13 | 474 | chr1 | 185838109 | 11191 | 14483 | 7 | 63,90,55,48,75,60,70, | 13,76,166,221,269,344,404, | 185823626,185823937,185824755,185825061,185825703,185826141,185826848, |
| 585 | 747 | 86 | 0 | 0 | 4 | 61 | 12 | 4217 | +- | JU760157 | 1097 | 92 | 986 | chr1 | 185838109 | 11191 | 16241 | 13 | 44,91,62,42,68,67,64,90,57,43,75,60,70, | 92,136,272,335,388,456,523,587,677,738,781,856,916, | 185821868,185822142,185822406,185822539,185822595,185822745,185823625,185823937,185824755,185825066,185825703,185826141,18582684 ... |
| 585 | 690 | 78 | 0 | 0 | 2 | 15 | 11 | 4282 | +- | JU760158 | 986 | 92 | 875 | chr1 | 185838109 | 11191 | 16241 | 12 | 44,88,42,68,67,64,90,57,43,75,60,70, | 92,136,224,277,345,412,476,566,627,670,745,805, | 185821868,185822142,185822539,185822595,185822745,185823625,185823937,185824755,185825066,185825703,185826141,185826848, |
| 585 | 749 | 87 | 0 | 0 | 3 | 57 | 12 | 4214 | +- | JU931700 | 1111 | 103 | 996 | chr1 | 185838109 | 11191 | 16241 | 13 | 44,91,62,42,68,67,64,90,55,48,75,60,70, | 103,147,283,346,399,467,534,598,688,743,791,866,926, | 185821868,185822142,185822406,185822539,185822595,185822745,185823625,185823937,185824755,185825061,185825703,185826141,18582684 ... |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server