Schema for UCSC Clone Ends - UCSC mapping of clone libraries end placements
  Database: hg19    Primary Table: cloneEndsABCNA18517ABC740000CLONEEND    Row Count: 777,399   Data last updated: 2014-11-12
Format description: Standard linked features series table
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 73smallint(6) Bin number for browser speedup
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 10000int(10) unsigned Start position of clone in chromosome
chromEnd 541217int(10) unsigned End position of clone in chromosome
name ABC7-40632100C3varchar(100) Name of clone
score 1000int(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 2int(10) unsigned Number of linked features in the series
lfStarts 10000,541121longblob Comma separated list of start positions of each linked feature in genomic
lfSizes 233,96longblob Comma separated list of sizes of each linked feature in genomic
lfNames 930978122,930978121longblob Comma separated list of names of linked features

Sample Rows
 
binchromchromStartchromEndnamescorestrandpslTablelfCountlfStartslfSizeslfNames
73chr110000541217ABC7-40632100C31000+210000,541121233,96930978122,930978121
73chr110000541234ABC7-42397300E91000-210000,540500468,734970791603,970791604
73chr110000540334ABC7-42442800P41000+210000,539773229,561973591353,973591354
73chr110000536894ABC7-43039900I201000+210000,535758233,11361001420020,1002403096
73chr110000540781ABC7-42372500L171000-210000,540191230,590931018094,931018095
73chr110000528972ABC7-42757000A171000+210000,528258229,7141017117220,1017117221
73chr110000536894ABC7-610122I231000+210000,536174233,720998465446,997917882
585chr11000099917ABC7-43066900J121000+210000,99219233,6981004590898,1004584538
585chr110000104898ABC7-42518300O171000+210000,104497230,401977802890,978146797
585chr11000096810ABC7-42477200E31000-210000,96121233,689975375361,975375362

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