Schema for cloneEndCTD
  Database: hg38    Primary Table: cloneEndCTD    Row Count: 94,941   Data last updated: 2015-06-18
Format description: Browser extensible data
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 29891int(10) unsigned range Start position in chromosome
chromEnd 32658int(10) unsigned range End position in chromosome
name CTD-3085F7varchar(255) values Name of item
score 214int(10) unsigned range Optional score, nominal range 0-1000
strand -char(1) values + or -
thickStart 29891int(10) unsigned range Start of where display should be thick (start codon)
thickEnd 32658int(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 390,475longblob   Comma separated list of block sizes
chromStarts 0,2292longblob   Start positions relative to chromStart

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

Sample Rows
 
binchromchromStartchromEndnamescorestrandthickStartthickEndreservedblockCountblockSizeschromStarts
585chr12989132658CTD-3085F7214-298913265802390,4750,2292
73chr197923193917CTD-2317L211000-9792319391702576,3640,95630
586chr1139328187059CTD-3214E101000+13932818705902450,5240,47207
586chr1154595166577CTD-3011G10214+15459516657702431,3110,11671
73chr1193496262530CTD-2017L11000+19349626253002429,4790,68555
587chr1276208277820CTD-3043C11150-27620827782002375,4510,1161
73chr1348358471433CTD-2243O22750+34835847143302280,4220,122653
73chr1351534522802CTD-3037P16500+35153452280202435,2530,171015
73chr1364462619538CTD-3185M14375+36446261953802549,4720,254604
587chr1364470389653CTD-3185K14375+36447038965302530,4750,24708

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