Schema for UCSC Clone Ends - UCSC mapping of clone libraries end placements |
|---|
| |
Database: hg19 Primary Table: cloneEndsJCVIhuRef9500WGS Row Count: 642,774 Data last updated: 2014-11-12
Format description: Standard linked features series table
On download server: MariaDB table dump directory
| field | example | SQL type | description |
|---|
| bin | 73 | smallint(6) | Bin number for browser speedup |
| chrom | chr1 | varchar(255) | Reference sequence chromosome or scaffold |
| chromStart | 10000 | int(10) unsigned | Start position of clone in chromosome |
| chromEnd | 230234 | int(10) unsigned | End position of clone in chromosome |
| name | 1090216218755 | varchar(100) | Name of clone |
| score | 1000 | int(10) unsigned | 1000 if uniquely aligned, else 1500/(# of alignments to assembly) |
| strand | + | char(2) | Value should be + or - |
| pslTable | | varchar(50) | Table which contains corresponding PSL records for linked features |
| lfCount | 2 | int(10) unsigned | Number of linked features in the series |
| lfStarts | 10000,229300 | longblob | Comma separated list of start positions of each linked feature in genomic |
| lfSizes | 233,934 | longblob | Comma separated list of sizes of each linked feature in genomic |
| lfNames | 1741833131,1742708302 | longblob | Comma separated list of names of linked features |
|
| |
|
|
|
Sample Rows
|
|---|
| |
| bin | chrom | chromStart | chromEnd | name | score | strand | pslTable | lfCount | lfStarts | lfSizes | lfNames |
|---|
| 73 | chr1 | 10000 | 230234 | 1090216218755 | 1000 | + | | 2 | 10000,229300 | 233,934 | 1741833131,1742708302 |
| 73 | chr1 | 10000 | 234285 | 1090216328209 | 1000 | - | | 2 | 10000,233335 | 438,950 | 1742768830,1742047092 |
| 585 | chr1 | 10000 | 20315 | 1090216147060 | 1000 | - | | 2 | 10000,19332 | 233,983 | 1742725661,1742599136 |
| 585 | chr1 | 10002 | 19059 | 1090216511911 | 1000 | - | | 2 | 10002,16856 | 466,2203 | 1742802686,1742311937 |
| 585 | chr1 | 10125 | 21199 | 1090216502824 | 1000 | - | | 2 | 10125,20245 | 255,954 | 1742285209,1742679897 |
| 73 | chr1 | 10255 | 230538 | 1090216304400 | 1000 | - | | 2 | 10255,229673 | 71,865 | 1742228764,1742048240 |
| 73 | chr1 | 10359 | 523416 | 1090216188960 | 1000 | - | | 2 | 10359,522583 | 77,833 | 1741561355,1742729035 |
| 585 | chr1 | 14541 | 26642 | 1090216570600 | 1000 | + | | 2 | 14541,25745 | 971,897 | 1742437841,1742417473 |
| 585 | chr1 | 17385 | 29442 | 1090216284861 | 1000 | - | | 2 | 17385,28486 | 700,956 | 1742157073,1741721567 |
| 585 | chr1 | 21690 | 35430 | 1090216310597 | 1000 | - | | 2 | 21690,34497 | 948,933 | 1741638635,1742073394 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|