|
|---|
| |
Database: hg38 Primary Table: affyGnf1h Row Count: 12,626 Data last updated: 2015-01-08
Format description: Summary info about a patSpace alignment
| field | example | SQL type | info | description |
|---|
| bin | 585 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 70 | 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 | 0 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 0 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | gnf1h03908_s_at | varchar(255) | values | Query sequence name |
| qSize | 70 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 70 | int(10) unsigned | range | Alignment end position in query |
| tName | chr1 | varchar(255) | values | Target sequence name |
| tSize | 248956422 | int(10) unsigned | range | Target sequence size |
| tStart | 14969 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 15039 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 1 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 70, | longblob | | Size of each block |
| qStarts | 0, | longblob | | Start of each block in query. |
| tStarts | 14969, | 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 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | gnf1h03908_s_at | 70 | 0 | 70 | chr1 | 248956422 | 14969 | 15039 | 1 | 70, | 0, | 14969, |
| 585 | 338 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | - | gnf1h01690_s_at | 339 | 0 | 339 | chr1 | 248956422 | 16934 | 17273 | 1 | 339, | 0, | 16934, |
| 585 | 250 | 0 | 0 | 2 | 4 | 20 | 4 | 335 | + | gnf1h07742_at | 272 | 0 | 272 | chr1 | 248956422 | 21411 | 21998 | 5 | 25,77,48,25,77, | 0,30,112,165,195, | 21411,21467,21649,21737,21921, |
| 585 | 375 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | - | gnf1h03342_at | 376 | 0 | 376 | chr1 | 248956422 | 24347 | 24723 | 1 | 376, | 0, | 24347, |
| 585 | 456 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | + | gnf1h04689_at | 456 | 0 | 456 | chr1 | 248956422 | 63332 | 63788 | 1 | 456, | 0, | 63332, |
| 586 | 112 | 0 | 0 | 0 | 1 | 5 | 1 | 61 | + | gnf1h11145_s_at | 117 | 0 | 117 | chr1 | 248956422 | 132022 | 132195 | 2 | 74,38, | 0,79, | 132022,132157, |
| 586 | 188 | 2 | 0 | 0 | 0 | 0 | 1 | 506 | - | gnf1h03516_x_at | 193 | 3 | 193 | chr1 | 248956422 | 132947 | 133643 | 2 | 116,74, | 0,116, | 132947,133569, |
| 586 | 532 | 3 | 0 | 0 | 0 | 0 | 2 | 2156 | - | gnf1h03907_at | 535 | 0 | 535 | chr1 | 248956422 | 183694 | 186385 | 3 | 397,69,69, | 0,397,466, | 183694,185490,186316, |
| 586 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | gnf1h03908_s_at | 70 | 0 | 70 | chr1 | 248956422 | 185490 | 185560 | 1 | 70, | 0, | 185490, |
| 586 | 337 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | - | gnf1h01690_s_at | 339 | 0 | 339 | chr1 | 248956422 | 187456 | 187795 | 1 | 339, | 0, | 187456, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server