|
|---|
| |
Database: strPur2 Primary Table: refSeqAli Row Count: 685 Data last updated: 2020-02-07
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 | 3516 | int(10) unsigned | range | Number of bases that match that aren't repeats |
| misMatches | 81 | 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 | 3 | int(10) unsigned | range | Number of inserts in query |
| qBaseInsert | 6 | int(10) unsigned | range | Number of bases inserted in query |
| tNumInsert | 18 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 10252 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | NM_001032371 | varchar(255) | values | Query sequence name |
| qSize | 3603 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 3603 | int(10) unsigned | range | Alignment end position in query |
| tName | Scaffold4367 | varchar(255) | values | Target sequence name |
| tSize | 116559 | int(10) unsigned | range | Target sequence size |
| tStart | 45766 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 59615 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 20 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 39,67,225,472,498,148,122,1... | longblob | | Size of each block |
| qStarts | 0,42,110,335,809,1307,1455,... | longblob | | Start of each block in query. |
| tStarts | 45766,45807,45874,46103,465... | longblob | | Start of each block in target. |
|
| |
|
|
|
Connected Tables and Joining Fields
|
|---|
| |
hgFixed.gbCdnaInfo.acc (via refSeqAli.qName)
hgFixed.gbMiscDiff.acc (via refSeqAli.qName)
hgFixed.gbSeq.acc (via refSeqAli.qName)
hgFixed.gbWarn.acc (via refSeqAli.qName)
hgFixed.imageClone.acc (via refSeqAli.qName)
hgFixed.refLink.mrnaAcc (via refSeqAli.qName)
hgFixed.refSeqStatus.mrnaAcc (via refSeqAli.qName)
hgFixed.refSeqSummary.mrnaAcc (via refSeqAli.qName)
knownGeneV39.kgXref.refseq (via refSeqAli.qName)
knownGeneV39.knownToRefSeq.value (via refSeqAli.qName)
strPur2.all_est.qName (via refSeqAli.qName)
strPur2.all_mrna.qName (via refSeqAli.qName)
strPur2.mrnaOrientInfo.name (via refSeqAli.qName)
strPur2.refFlat.name (via refSeqAli.qName)
strPur2.refGene.name (via refSeqAli.qName)
strPur2.xenoMrna.qName (via refSeqAli.qName)
strPur2.xenoRefGene.name (via refSeqAli.qName)
strPur2.xenoRefSeqAli.qName (via refSeqAli.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 |
|---|
| 585 | 3516 | 81 | 0 | 0 | 3 | 6 | 18 | 10252 | - | NM_001032371 | 3603 | 0 | 3603 | Scaffold4367 | 116559 | 45766 | 59615 | 20 | 39,67,225,472,498,148,122,151,165,123,132,207,104,145,202,239,254,130,159,15, | 0,42,110,335,809,1307,1455,1577,1728,1893,2016,2148,2355,2459,2604,2806,3045,3299,3429,3588, | 45766,45807,45874,46103,46576,48045,48807,49738,50659,51316,52271,52910,53772,54515,55136,55913,56532,57284,59100,59600, |
| 585 | 105 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | + | NM_214594 | 4075 | 1650 | 1756 | Scaffold100099 | 595 | 152 | 259 | 2 | 5,101, | 1650,1655, | 152,158, |
| 585 | 80 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | - | NM_001144976 | 2397 | 2129 | 2211 | Scaffold100423 | 589 | 276 | 358 | 1 | 82, | 186, | 276, |
| 585 | 3441 | 165 | 24 | 0 | 19 | 276 | 20 | 49352 | + | NM_214618 | 3936 | 10 | 3916 | Scaffold10417 | 164249 | 75068 | 128050 | 35 | 105,213,104,153,156,146,114,154,132,281,96,67,77,82,133,43,16,209,147,82,3,23,37,231,10,145,8,24,147,245,2,62,28,88,67, | 10,115,521,625,778,934,1080,1194,1348,1480,1761,1857,1927,2007,2095,2229,2272,2289,2499,2655,2738,2742,2766,2838,3071,3081,3228, ... | 75068,102295,118306,119944,121171,121901,122766,123419,124931,125449,125745,126033,126100,126177,126260,126399,126443,126459,126 ... |
| 585 | 6422 | 367 | 0 | 0 | 7 | 3024 | 35 | 19398 | - | NM_001081968 | 10023 | 0 | 9813 | Scaffold10421 | 387608 | 18116 | 44303 | 37 | 142,46,175,17,262,164,183,151,228,124,192,161,103,104,216,233,152,202,267,183,213,141,75,71,71,106,139,162,281,68,5,51,39,630,71 ... | 210,352,398,590,614,876,1040,1223,1374,1602,1726,1918,2079,2198,2302,2518,2751,2903,3105,3372,3555,3768,3909,3984,4055,4126,4232 ... | 18116,18789,18853,19479,19799,21009,21584,23360,24044,24781,25929,26919,27739,28446,29058,30083,30957,31260,32159,32964,34191,34 ... |
| 586 | 1629 | 18 | 0 | 0 | 1 | 2 | 6 | 2730 | - | NM_001079546 | 2538 | 888 | 2537 | Scaffold10421 | 387608 | 185258 | 189635 | 7 | 35,469,173,147,123,126,574, | 1,38,507,680,827,950,1076, | 185258,185310,186219,186936,187988,188477,189061, |
| 585 | 182 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | + | NM_001144976 | 2397 | 313 | 498 | Scaffold104248 | 513 | 27 | 212 | 1 | 185, | 313, | 27, |
| 585 | 1278 | 2 | 197 | 0 | 1 | 112 | 2 | 4613 | - | NM_214638 | 1589 | 0 | 1589 | Scaffold10475 | 32168 | 11813 | 17903 | 3 | 345,933,199, | 0,457,1390, | 11813,12208,17704, |
| 585 | 1411 | 4 | 0 | 0 | 1 | 1 | 1 | 6 | + | NM_214611 | 1416 | 0 | 1416 | Scaffold10475 | 32168 | 30010 | 31431 | 3 | 1072,221,122, | 0,1072,1294, | 30010,31088,31309, |
| 585 | 1645 | 30 | 0 | 0 | 1 | 90 | 8 | 3004 | + | NM_214507 | 3704 | 1931 | 3696 | Scaffold10573 | 12155 | 283 | 4962 | 9 | 355,250,174,576,184,17,64,7,48, | 1931,2286,2536,2710,3376,3560,3577,3641,3648, | 283,2852,3378,4007,4637,4823,4841,4906,4914, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server