|
|---|
| |
Database: equCab2 Primary Table: intronEst (chr1_intronEst) Row Count: 2,057 Data last updated: 2016-05-09
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory
| field | example | SQL type | info | description |
|---|
| bin | 640 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 271 | 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 | 82 | 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 | 1 | int(10) unsigned | range | Number of inserts in query |
| qBaseInsert | 1 | int(10) unsigned | range | Number of bases inserted in query |
| tNumInsert | 3 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 9712 | int(10) unsigned | range | Number of bases inserted in target |
| strand | + | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | AB096934 | varchar(255) | values | Query sequence name |
| qSize | 372 | int(10) unsigned | range | Query sequence size |
| qStart | 18 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 372 | int(10) unsigned | range | Alignment end position in query |
| tName | chr1 | varchar(255) | values | Target sequence name |
| tSize | 185838109 | int(10) unsigned | range | Target sequence size |
| tStart | 7286606 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 7296671 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 5 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 78,13,81,75,106, | longblob | | Size of each block |
| qStarts | 18,97,110,191,266, | longblob | | Start of each block in query. |
| tStarts | 7286606,7286684,7291431,729... | longblob | | Start of each block in target. |
|
| |
|
|
|
Connected Tables and Joining Fields
|
|---|
| |
equCab2.all_est.qName (via intronEst.qName)
equCab2.est.qName (via intronEst.qName)
equCab2.estOrientInfo.name (via intronEst.qName)
hgFixed.gbCdnaInfo.acc (via intronEst.qName)
hgFixed.gbSeq.acc (via intronEst.qName)
hgFixed.imageClone.acc (via intronEst.qName)
| |
|
|
|
Sample Rows
|
|---|
| |
| bin | matches | misMatches | repMatches | nCount | qNumInsert | qBaseInsert | tNumInsert | tBaseInsert | strand | qName | qSize | qStart | qEnd | tName | tSize | tStart | tEnd | blockCount | blockSizes | qStarts | tStarts |
|---|
| 640 | 271 | 0 | 82 | 0 | 1 | 1 | 3 | 9712 | + | AB096934 | 372 | 18 | 372 | chr1 | 185838109 | 7286606 | 7296671 | 5 | 78,13,81,75,106, | 18,97,110,191,266, | 7286606,7286684,7291431,7292212,7296565, |
| 790 | 359 | 0 | 0 | 0 | 6 | 10 | 5 | 5095 | + | AW260934 | 550 | 0 | 369 | chr1 | 185838109 | 26932975 | 26938429 | 10 | 22,34,19,3,14,4,7,65,93,98, | 0,23,58,77,81,96,101,113,178,271, | 26932975,26932999,26933033,26936718,26936721,26936735,26936739,26936749,26936899,26938331, |
| 127 | 350 | 0 | 0 | 6 | 10 | 17 | 5 | 3938 | - | AW260939 | 442 | 1 | 374 | chr1 | 185838109 | 56752327 | 56756621 | 14 | 13,38,12,84,5,35,10,31,15,8,18,17,32,38, | 68,82,121,133,218,224,259,270,302,318,327,350,367,403, | 56752327,56752340,56752378,56752581,56752665,56752670,56754276,56754286,56754317,56754332,56754340,56754361,56756549,56756583, |
| 1527 | 288 | 13 | 0 | 2 | 1 | 7 | 5 | 1651 | - | AW268042 | 311 | 1 | 311 | chr1 | 185838109 | 123479464 | 123481418 | 6 | 57,75,117,12,37,5, | 0,57,132,256,268,305, | 123479464,123480523,123481237,123481362,123481375,123481413, |
| 1546 | 371 | 0 | 0 | 5 | 1 | 6 | 4 | 958 | + | AW260915 | 386 | 4 | 386 | chr1 | 185838109 | 126045956 | 126047290 | 5 | 59,76,125,71,45, | 4,69,145,270,341, | 126045956,126046019,126046540,126047173,126047245, |
| 1546 | 229 | 0 | 0 | 3 | 10 | 21 | 5 | 291 | + | AW260923 | 400 | 0 | 253 | chr1 | 185838109 | 126047578 | 126048101 | 12 | 11,18,12,19,16,29,9,15,24,19,26,34, | 0,12,31,48,69,86,116,126,142,166,188,219, | 126047578,126047589,126047607,126047622,126047642,126047658,126047687,126047696,126047711,126048018,126048038,126048067, |
| 1587 | 503 | 3 | 0 | 4 | 10 | 12 | 9 | 7622 | + | AW260897 | 663 | 9 | 531 | chr1 | 185838109 | 131454546 | 131462678 | 19 | 21,5,52,11,9,8,31,10,7,22,5,12,68,60,94,21,20,31,23, | 9,33,39,91,102,112,121,153,164,172,194,199,212,280,340,434,455,476,508, | 131454546,131454569,131454574,131454627,131457716,131457725,131457733,131457764,131457774,131457781,131458017,131458721,13145873 ... |
| 223 | 579 | 0 | 0 | 12 | 3 | 5 | 6 | 47732 | - | AW261095 | 602 | 0 | 596 | chr1 | 185838109 | 158033842 | 158082165 | 9 | 9,35,55,48,76,23,131,124,90, | 6,15,53,108,156,232,256,388,512, | 158033842,158033852,158033889,158050144,158050825,158055771,158055794,158055925,158082075, |
| 244 | 489 | 3 | 0 | 3 | 11 | 13 | 5 | 9309 | - | AW260819 | 639 | 125 | 633 | chr1 | 185838109 | 180083318 | 180093122 | 15 | 52,29,60,7,35,65,36,18,12,14,64,43,35,18,7, | 6,59,90,152,159,195,261,297,316,329,344,408,452,488,507, | 180083318,180083370,180085191,180085252,180085750,180085785,180085850,180092233,180092251,180092263,180092277,180093019,18009306 ... |
| 796 | 576 | 0 | 0 | 0 | 0 | 0 | 4 | 587 | - | BI961580 | 576 | 0 | 576 | chr1 | 185838109 | 27754305 | 27755468 | 5 | 207,112,173,70,14, | 0,207,319,492,562, | 27754305,27754610,27754861,27755255,27755454, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server