Schema for UCSC Clone Ends - UCSC mapping of clone libraries end placements
|
|
Database: hg19 Primary Table: cloneEndsJCVIhuRef44000WGS Row Count: 236,070   Data last updated: 2014-11-12
Format description: Standard linked features series table On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 585 | smallint(6) | range | Bin number for browser speedup |
chrom | chr1 | varchar(255) | values | Reference sequence chromosome or scaffold |
chromStart | 10000 | int(10) unsigned | range | Start position of clone in chromosome |
chromEnd | 99904 | int(10) unsigned | range | End position of clone in chromosome |
name | 1061013346982 | varchar(100) | values | Name of clone |
score | 1000 | int(10) unsigned | range | 1000 if uniquely aligned, else 1500/(# of alignments to assembly) |
strand | - | char(2) | values | Value should be + or - |
pslTable | | varchar(50) | values | Table which contains corresponding PSL records for linked features |
lfCount | 2 | int(10) unsigned | range | Number of linked features in the series |
lfStarts | 10000,99093 | longblob | | Comma separated list of start positions of each linked feature in genomic |
lfSizes | 233,811 | longblob | | Comma separated list of sizes of each linked feature in genomic |
lfNames | 1745068658,1745067410 | longblob | | Comma separated list of names of linked features |
|
| |
|
|
Sample Rows
|
|
bin | chrom | chromStart | chromEnd | name | score | strand | pslTable | lfCount | lfStarts | lfSizes | lfNames |
---|
585 | chr1 | 10000 | 99904 | 1061013346982 | 1000 | - | | 2 | 10000,99093 | 233,811 | 1745068658,1745067410 |
73 | chr1 | 10352 | 539635 | 1061013290096 | 1000 | + | | 2 | 10352,538720 | 84,915 | 1737078766,1737091192 |
586 | chr1 | 131120 | 165944 | 1061013343217 | 1000 | + | | 2 | 131120,165096 | 920,848 | 1745224261,1745229341 |
587 | chr1 | 317719 | 356245 | 1061013236123 | 1000 | + | | 2 | 317719,355247 | 869,998 | 1736985558,1736973864 |
587 | chr1 | 345676 | 379475 | 1061013875640 | 750 | - | | 2 | 345676,378709 | 775,766 | 1745140928,1745142599 |
73 | chr1 | 360198 | 402940 | 1061017399380 | 500 | - | | 2 | 360198,402017 | 913,923 | 1733545641,1733544173 |
73 | chr1 | 369077 | 405414 | 1061013296585 | 750 | - | | 2 | 369077,404488 | 889,926 | 1737093318,1737076780 |
73 | chr1 | 378482 | 411482 | 1061013225543 | 750 | + | | 2 | 378482,410513 | 956,969 | 1736958495,1736957057 |
73 | chr1 | 380560 | 416998 | 1061013348056 | 750 | - | | 2 | 380560,416218 | 674,780 | 1745067779,1745066627 |
73 | chr1 | 380855 | 412519 | 1061013234953 | 1000 | + | | 2 | 380855,411614 | 868,905 | 1736993661,1736990043 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|