Schema for UCSC Clone Ends - UCSC mapping of clone libraries end placements
  Database: hg19    Primary Table: cloneEndsJCVIhuRef10000WGS    Row Count: 1,137,318   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 236849int(10) unsigned End position of clone in chromosome
name 1090219166137varchar(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,235812longblob Comma separated list of start positions of each linked feature in genomic
lfSizes 442,1037longblob Comma separated list of sizes of each linked feature in genomic
lfNames 1743030129,1744421790longblob Comma separated list of names of linked features

Sample Rows
 
binchromchromStartchromEndnamescorestrandpslTablelfCountlfStartslfSizeslfNames
73chr11000023684910902191661371000-210000,235812442,10371743030129,1744421790
585chr1100002013510902187168561000-210000,19094233,10411743272801,1744565586
585chr1100002007810902186492181000+210000,19130232,9481743642141,1744544729
585chr1100081793810610062696761000+210008,17032511,9061735318098,1735335375
585chr1131532873010902187508751000+213153,27750911,9801744195296,1743592627
585chr1141932382110610065311451000-214193,22760978,10611735819715,1735821460
585chr1169992920110902191102141000+216999,28251981,9501744421421,1744507320
585chr1251033924610902187819751000+225103,38289987,9571744642583,1744582507
585chr125139373541061006524138750-225139,364881024,8661735819308,1735813304
585chr1281833960110610000132111000-228183,38595882,10061735196553,1735213592

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