Schema for ccdsKgMap
  Database: hg18    Primary Table: ccdsKgMap    Row Count: 30,391   Data last updated: 2019-03-13
Format description: mapping between CCDS ids and Known Genes by similarity
On download server: MariaDB table dump directory
fieldexampleSQL type info description
ccdsId CCDS30547.1varchar(32) values CCDS id with version
geneId uc001aal.1varchar(255) values Id of other gene
chrom chr1varchar(255) values Chromosome or scaffold of other gene
chromStart 58953int(10) unsigned range Chromosome start of other gene
chromEnd 59871int(10) unsigned range Chromosome end of other gene
cdsSimilarity 1float range CDS similarity by genomic overlap

Connected Tables and Joining Fields
        hg18.ccdsGene.name (via ccdsKgMap.ccdsId)
      hg18.ccdsInfo.ccds (via ccdsKgMap.ccdsId)
      hg18.ccdsNotes.ccds (via ccdsKgMap.ccdsId)
      hg18.bioCycPathway.kgID (via ccdsKgMap.geneId)
      hg18.ceBlastTab.query (via ccdsKgMap.geneId)
      hg18.dmBlastTab.query (via ccdsKgMap.geneId)
      hg18.drBlastTab.query (via ccdsKgMap.geneId)
      hg18.foldUtr3.name (via ccdsKgMap.geneId)
      hg18.foldUtr5.name (via ccdsKgMap.geneId)
      hg18.gnfAtlas2Distance.query (via ccdsKgMap.geneId)
      hg18.gnfAtlas2Distance.target (via ccdsKgMap.geneId)
      hg18.gnfU95Distance.query (via ccdsKgMap.geneId)
      hg18.gnfU95Distance.target (via ccdsKgMap.geneId)
      hg18.humanHprdP2P.query (via ccdsKgMap.geneId)
      hg18.humanHprdP2P.target (via ccdsKgMap.geneId)
      hg18.humanVidalP2P.query (via ccdsKgMap.geneId)
      hg18.humanVidalP2P.target (via ccdsKgMap.geneId)
      hg18.humanWankerP2P.query (via ccdsKgMap.geneId)
      hg18.humanWankerP2P.target (via ccdsKgMap.geneId)
      hg18.keggPathway.kgID (via ccdsKgMap.geneId)
      hg18.kgAlias.kgID (via ccdsKgMap.geneId)
      hg18.kgColor.kgID (via ccdsKgMap.geneId)
      hg18.kgProtAlias.kgID (via ccdsKgMap.geneId)
      hg18.kgProtMap2.qName (via ccdsKgMap.geneId)
      hg18.kgSpAlias.kgID (via ccdsKgMap.geneId)
      hg18.kgTargetAli.qName (via ccdsKgMap.geneId)
      hg18.kgTxInfo.name (via ccdsKgMap.geneId)
      hg18.kgXref.kgID (via ccdsKgMap.geneId)
      hg18.knownBlastTab.query (via ccdsKgMap.geneId)
      hg18.knownBlastTab.target (via ccdsKgMap.geneId)
      hg18.knownCanonToDecipher.name (via ccdsKgMap.geneId)
      hg18.knownCanonical.protein (via ccdsKgMap.geneId)
      hg18.knownCanonical.transcript (via ccdsKgMap.geneId)
      hg18.knownGene.name (via ccdsKgMap.geneId)
      hg18.knownGeneMrna.name (via ccdsKgMap.geneId)
      hg18.knownGenePep.name (via ccdsKgMap.geneId)
      hg18.knownIsoforms.transcript (via ccdsKgMap.geneId)
      hg18.knownToAllenBrain.name (via ccdsKgMap.geneId)
      hg18.knownToDecipher.name (via ccdsKgMap.geneId)
      hg18.knownToEnsembl.name (via ccdsKgMap.geneId)
      hg18.knownToGnf1h.name (via ccdsKgMap.geneId)
      hg18.knownToGnfAtlas2.name (via ccdsKgMap.geneId)
      hg18.knownToHInv.name (via ccdsKgMap.geneId)
      hg18.knownToHprd.name (via ccdsKgMap.geneId)
      hg18.knownToKeggEntrez.name (via ccdsKgMap.geneId)
      hg18.knownToLocusLink.name (via ccdsKgMap.geneId)
      hg18.knownToMupit.name (via ccdsKgMap.geneId)
      hg18.knownToPfam.name (via ccdsKgMap.geneId)
      hg18.knownToRefSeq.name (via ccdsKgMap.geneId)
      hg18.knownToSuper.gene (via ccdsKgMap.geneId)
      hg18.knownToTreefam.name (via ccdsKgMap.geneId)
      hg18.knownToU133.name (via ccdsKgMap.geneId)
      hg18.knownToU133Plus2.name (via ccdsKgMap.geneId)
      hg18.knownToU95.name (via ccdsKgMap.geneId)
      hg18.knownToVisiGene.name (via ccdsKgMap.geneId)
      hg18.mmBlastTab.query (via ccdsKgMap.geneId)
      hg18.rnBlastTab.query (via ccdsKgMap.geneId)
      hg18.scBlastTab.query (via ccdsKgMap.geneId)
      hg18.ucscScop.ucscId (via ccdsKgMap.geneId)
      knownGeneV39.bioCycPathway.kgID (via ccdsKgMap.geneId)
      knownGeneV39.ceBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.dmBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.drBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.foldUtr3.name (via ccdsKgMap.geneId)
      knownGeneV39.foldUtr5.name (via ccdsKgMap.geneId)
      knownGeneV39.gnfAtlas2Distance.query (via ccdsKgMap.geneId)
      knownGeneV39.gnfAtlas2Distance.target (via ccdsKgMap.geneId)
      knownGeneV39.kgAlias.kgID (via ccdsKgMap.geneId)
      knownGeneV39.kgColor.kgID (via ccdsKgMap.geneId)
      knownGeneV39.kgProtAlias.kgID (via ccdsKgMap.geneId)
      knownGeneV39.kgSpAlias.kgID (via ccdsKgMap.geneId)
      knownGeneV39.kgTargetAli.qName (via ccdsKgMap.geneId)
      knownGeneV39.kgXref.kgID (via ccdsKgMap.geneId)
      knownGeneV39.knownAttrs.kgID (via ccdsKgMap.geneId)
      knownGeneV39.knownBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.knownBlastTab.target (via ccdsKgMap.geneId)
      knownGeneV39.knownCanonical.protein (via ccdsKgMap.geneId)
      knownGeneV39.knownCanonical.transcript (via ccdsKgMap.geneId)
      knownGeneV39.knownCds.name (via ccdsKgMap.geneId)
      knownGeneV39.knownGene.name (via ccdsKgMap.geneId)
      knownGeneV39.knownGeneMrna.name (via ccdsKgMap.geneId)
      knownGeneV39.knownGenePep.name (via ccdsKgMap.geneId)
      knownGeneV39.knownIsoforms.transcript (via ccdsKgMap.geneId)
      knownGeneV39.knownToEnsembl.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToGnfAtlas2.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToHprd.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToLocusLink.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToMrna.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToMrnaSingle.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToMupit.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToPfam.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToRefSeq.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToSuper.gene (via ccdsKgMap.geneId)
      knownGeneV39.knownToTag.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToU133.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToU95.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToVisiGene.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToWikipedia.name (via ccdsKgMap.geneId)
      knownGeneV39.mmBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.rnBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.scBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.ucscScop.ucscId (via ccdsKgMap.geneId)

Sample Rows
 
ccdsIdgeneIdchromchromStartchromEndcdsSimilarity
CCDS30547.1uc001aal.1chr158953598711
CCDS41221.1uc001abd.1chr16109586118971
CCDS2.2uc001abw.1chr18509838698241
CCDS3.1uc001abz.2chr18694458845421
CCDS3.1uc009vjq.1chr18694458845420.993378
CCDS30550.1uc001aca.1chr18858298909581
CCDS4.1uc001acd.1chr18917399003471
CCDS5.1uc001aci.1chr19242069253331
CCDS6.1uc001acj.2chr19387099397821
CCDS30551.1uc001ack.1chr19453659813551

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