Schema for hg38ContigDiff
  Database: hg19    Primary Table: hg38ContigDiff    Row Count: 6,097   Data last updated: 2014-02-13
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 317719int(10) unsigned range Start position in chromosome
chromEnd 471368int(10) unsigned range End position in chromosome
name AL732372.15varchar(255) values Name of item
score 500int(10) unsigned range Optional score, nominal range 0-1000
strand +char(1) values + or -
thickStart 317719int(10) unsigned range Start of where display should be thick (start codon)
thickEnd 471368int(10) unsigned range End of where display should be thick (stop codon)
itemRgb 10715653int(10) unsigned range Used as itemRgb as of 2004-11-22

Connected Tables and Joining Fields
        hg19.gold.frag (via hg38ContigDiff.name)

Sample Rows
 
binchromchromStartchromEndnamescorestrandthickStartthickEndreserved
73chr1317719471368AL732372.15500+31771947136810715653
73chr1632917812484AL669831.13500+63291781248410715653
74chr111272681237427AL162741.44500+1127268123742710715653
74chr112374271319872AL139287.24500+1237427131987210715653
595chr113265281392451AL391244.11500-1326528139245110715653
74chr115165501621653AL691432.54500+1516550162165310715653
74chr117302631893454AL109917.22500+1730263189345410715653
75chr126842202804248AL592464.24500+2684220280424810715653
75chr128042482909351AL589702.8500+2804248290935110715653
76chr132266603365232AL354743.33500+3226660336523210715653

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