Schema for ctdSorted
  Database: hgFixed    Primary Table: ctdSorted    Row Count: 447,297   Data last updated: 2013-06-23
On download server: MariaDB table dump directory
fieldexampleSQL type info
GeneSymbol A1BGvarchar(40) values
ChemicalId C028474varchar(40) values
count 1int(11) range
ChemicalName 1,4-bis(2-(3,5-dichloropyri...blob values

Connected Tables and Joining Fields
        hg16.kgXref.geneSymbol (via ctdSorted.GeneSymbol)
      hg17.kgXref.geneSymbol (via ctdSorted.GeneSymbol)
      hg18.kgXref.geneSymbol (via ctdSorted.GeneSymbol)
      hg19.kgXref.geneSymbol (via ctdSorted.GeneSymbol)
      hg38.kgXref.geneSymbol (via ctdSorted.GeneSymbol)

Sample Rows
 
GeneSymbolChemicalIdcountChemicalName
A1BGC02847411,4-bis(2-(3,5-dichloropyridyloxy))benzene
A1BGD0001111Acetylcysteine
A1BGD0166041Aflatoxin B1
A1BGD0006431Ammonium Chloride
A1BGD0029941Clofibrate
A1BGD0193271Copper Sulfate
A1BGD0040521Diethylnitrosamine
A1BGD0049971Ethinyl Estradiol
A1BGD0113451Fenofibrate
A1BGD0086281Mercury

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