Schema for UCSC Clone Ends - UCSC mapping of clone libraries end placements
|
|
Database: hg19 Primary Table: cloneEndsJCVIhuRef43000WGS Row Count: 264,303   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 | 73 | 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 | 533112 | int(10) unsigned | range | End position of clone in chromosome |
name | 1061018593172 | 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,532261 | longblob | | Comma separated list of start positions of each linked feature in genomic |
lfSizes | 233,851 | longblob | | Comma separated list of sizes of each linked feature in genomic |
lfNames | 1733720336,1733732490 | 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 | 533112 | 1061018593172 | 1000 | + | | 2 | 10000,532261 | 233,851 | 1733720336,1733732490 |
73 | chr1 | 10000 | 547358 | 1061012118813 | 1000 | + | | 2 | 10000,546568 | 233,790 | 1733394372,1733379267 |
73 | chr1 | 10000 | 546507 | 1061018638858 | 1000 | + | | 2 | 10000,545262 | 233,1245 | 1733755947,1733768300 |
73 | chr1 | 10000 | 537334 | 1061018355135 | 1000 | - | | 2 | 10000,536207 | 233,1127 | 1735066758,1735067585 |
73 | chr1 | 10000 | 539639 | 1061018943770 | 1000 | - | | 2 | 10000,538826 | 233,813 | 1733840910,1733840167 |
585 | chr1 | 10000 | 110901 | 1061018587540 | 1000 | + | | 2 | 10000,109879 | 233,1022 | 1733330067,1733345035 |
585 | chr1 | 10000 | 39376 | 1061018528758 | 1000 | + | | 2 | 10000,38483 | 233,893 | 1733317013,1733322204 |
73 | chr1 | 10020 | 537370 | 1061018583680 | 1000 | - | | 2 | 10020,536578 | 214,792 | 1733731493,1733725878 |
73 | chr1 | 93856 | 135849 | 1061018645844 | 1000 | + | | 2 | 93856,134874 | 868,975 | 1733795477,1733792251 |
73 | chr1 | 120968 | 153669 | 1061018571286 | 1000 | - | | 2 | 120968,152900 | 847,769 | 1733332823,1733345520 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|