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
fieldexampleSQL type info description
bin 585smallint(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 99904int(10) unsigned range End position of clone in chromosome
name 1061013346982varchar(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,99093longblob   Comma separated list of start positions of each linked feature in genomic
lfSizes 233,811longblob   Comma separated list of sizes of each linked feature in genomic
lfNames 1745068658,1745067410longblob   Comma separated list of names of linked features

Sample Rows
 
binchromchromStartchromEndnamescorestrandpslTablelfCountlfStartslfSizeslfNames
585chr1100009990410610133469821000-210000,99093233,8111745068658,1745067410
73chr11035253963510610132900961000+210352,53872084,9151737078766,1737091192
586chr113112016594410610133432171000+2131120,165096920,8481745224261,1745229341
587chr131771935624510610132361231000+2317719,355247869,9981736985558,1736973864
587chr13456763794751061013875640750-2345676,378709775,7661745140928,1745142599
73chr13601984029401061017399380500-2360198,402017913,9231733545641,1733544173
73chr13690774054141061013296585750-2369077,404488889,9261737093318,1737076780
73chr13784824114821061013225543750+2378482,410513956,9691736958495,1736957057
73chr13805604169981061013348056750-2380560,416218674,7801745067779,1745066627
73chr138085541251910610132349531000+2380855,411614868,9051736993661,1736990043

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