Schema for cloneEndRP11
  Database: hg38    Primary Table: cloneEndRP11    Row Count: 85,903   Data last updated: 2015-06-18
Format description: Browser extensible data
fieldexampleSQL type info description
bin 73smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 27982int(10) unsigned range Start position in chromosome
chromEnd 177318int(10) unsigned range End position in chromosome
name RP11-430E19varchar(255) values Name of item
score 750int(10) unsigned range Optional score, nominal range 0-1000
strand +char(1) values + or -
thickStart 27982int(10) unsigned range Start of where display should be thick (start codon)
thickEnd 177318int(10) unsigned range End of where display should be thick (stop codon)
reserved 0int(10) unsigned range Used as itemRgb as of 2004-11-22
blockCount 2int(10) unsigned range Number of blocks
blockSizes 543,343longblob   Comma separated list of block sizes
chromStarts 0,148993longblob   Start positions relative to chromStart

Connected Tables and Joining Fields
        hg38.cloneEndCTD.name (via cloneEndRP11.name)
      hg38.fishClones.name (via cloneEndRP11.name)

Sample Rows
 
binchromchromStartchromEndnamescorestrandthickStartthickEndreservedblockCountblockSizeschromStarts
73chr127982177318RP11-430E19750+2798217731802543,3430,148993
73chr166657439276RP11-952I8500+6665743927602482,4920,372127
73chr1166150383621RP11-242C5500+16615038362102546,5260,216945
73chr1178094354965RP11-179I12500+17809435496502508,5500,176321
73chr1674273831305RP11-790D11750+67427383130502356,5210,156511
73chr1684267831302RP11-654J19750-68426783130202441,5130,146522
73chr1697571877099RP11-206L101000+69757187709902567,4520,179076
73chr1709221886638RP11-25M11000+70922188663802394,3260,177091
73chr1805362968734RP11-668E21000+80536296873402436,3480,163024
9chr110140201197110RP11-425E151000+1014020119711002423,4130,182677

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