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
fieldexampleSQL type info description
bin 73smallint(6) range Bin number for browser speedup
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 10000int(10) unsigned range Start position of clone in chromosome
chromEnd 533112int(10) unsigned range End position of clone in chromosome
name 1061018593172varchar(100) values Name of clone
score 1000int(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 2int(10) unsigned range Number of linked features in the series
lfStarts 10000,532261longblob   Comma separated list of start positions of each linked feature in genomic
lfSizes 233,851longblob   Comma separated list of sizes of each linked feature in genomic
lfNames 1733720336,1733732490longblob   Comma separated list of names of linked features

Sample Rows
 
binchromchromStartchromEndnamescorestrandpslTablelfCountlfStartslfSizeslfNames
73chr11000053311210610185931721000+210000,532261233,8511733720336,1733732490
73chr11000054735810610121188131000+210000,546568233,7901733394372,1733379267
73chr11000054650710610186388581000+210000,545262233,12451733755947,1733768300
73chr11000053733410610183551351000-210000,536207233,11271735066758,1735067585
73chr11000053963910610189437701000-210000,538826233,8131733840910,1733840167
585chr11000011090110610185875401000+210000,109879233,10221733330067,1733345035
585chr1100003937610610185287581000+210000,38483233,8931733317013,1733322204
73chr11002053737010610185836801000-210020,536578214,7921733731493,1733725878
73chr19385613584910610186458441000+293856,134874868,9751733795477,1733792251
73chr112096815366910610185712861000-2120968,152900847,7691733332823,1733345520

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.