Schema for UCSC Clone Ends - UCSC mapping of clone libraries end placements
  Database: hg19    Primary Table: cloneEndsJCVICorielleCOR0234000CLONEEND    Row Count: 242,213   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 538021int(10) unsigned range End position of clone in chromosome
name COR02-DD0002LK1NU_G15varchar(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,537713longblob   Comma separated list of start positions of each linked feature in genomic
lfSizes 233,308longblob   Comma separated list of sizes of each linked feature in genomic
lfNames 1374120661,1374121237longblob   Comma separated list of names of linked features

Sample Rows
 
binchromchromStartchromEndnamescorestrandpslTablelfCountlfStartslfSizeslfNames
73chr110000538021COR02-DD0002LK1NU_G151000+210000,537713233,3081374120661,1374121237
73chr110000527330COR02-DD0002SZ5NU_K161000-210000,526462233,8681378388451,1393087521
73chr110000537336COR02-DD0002SIZNU_M191000+210000,537252233,841374280592,1374283794
73chr110000539100COR02-DD0002SK1NU_E121000-210000,538405233,6951394910857,1406293776
73chr110000543781COR02-DD0002JX8NU_F191000+210000,543308233,4731374225303,1374232561
73chr110000535633COR02-DD0002RUTNU_G221000+210000,534793233,8401374314393,1374313088
585chr11000040651COR02-DD0002K7QNU_N191000-210000,39968233,6831374450955,1374443513
585chr110000104249COR02-DD0002K53NU_M131000+210000,103689233,5601399712802,1398756940
585chr11000241451COR02-DD0002RW4NU_N11000-210002,40813390,6381374292044,1374290028
73chr110004534512COR02-DD0002JTBNU_J61000+210004,534038428,4741374143738,1374145508

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