Schema for ccdsKgMap
  Database: hg38    Primary Table: ccdsKgMap    Row Count: 61,217   Data last updated: 2021-01-26
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 ENST00000335137.4varchar(255) values Id of other gene
chrom chr1varchar(255) values Chromosome or scaffold of other gene
chromStart 69054int(10) unsigned range Chromosome start of other gene
chromEnd 70108int(10) unsigned range Chromosome end of other gene
cdsSimilarity 1float range CDS similarity by genomic overlap

Connected Tables and Joining Fields
        hg38.ccdsGene.name (via ccdsKgMap.ccdsId)
      hg38.ccdsInfo.ccds (via ccdsKgMap.ccdsId)
      hg38.ccdsNotes.ccds (via ccdsKgMap.ccdsId)
      hg38.bioCycPathway.kgID (via ccdsKgMap.geneId)
      hg38.ceBlastTab.query (via ccdsKgMap.geneId)
      hg38.dmBlastTab.query (via ccdsKgMap.geneId)
      hg38.drBlastTab.query (via ccdsKgMap.geneId)
      hg38.foldUtr3.name (via ccdsKgMap.geneId)
      hg38.foldUtr5.name (via ccdsKgMap.geneId)
      hg38.gnfAtlas2Distance.query (via ccdsKgMap.geneId)
      hg38.gnfAtlas2Distance.target (via ccdsKgMap.geneId)
      hg38.gnfU95Distance.query (via ccdsKgMap.geneId)
      hg38.gnfU95Distance.target (via ccdsKgMap.geneId)
      hg38.humanHprdP2P.query (via ccdsKgMap.geneId)
      hg38.humanHprdP2P.target (via ccdsKgMap.geneId)
      hg38.humanVidalP2P.query (via ccdsKgMap.geneId)
      hg38.humanVidalP2P.target (via ccdsKgMap.geneId)
      hg38.humanWankerP2P.query (via ccdsKgMap.geneId)
      hg38.humanWankerP2P.target (via ccdsKgMap.geneId)
      hg38.keggPathway.kgID (via ccdsKgMap.geneId)
      hg38.kgAlias.kgID (via ccdsKgMap.geneId)
      hg38.kgColor.kgID (via ccdsKgMap.geneId)
      hg38.kgProtAlias.kgID (via ccdsKgMap.geneId)
      hg38.kgSpAlias.kgID (via ccdsKgMap.geneId)
      hg38.kgTargetAli.qName (via ccdsKgMap.geneId)
      hg38.kgXref.kgID (via ccdsKgMap.geneId)
      hg38.knownAttrs.kgID (via ccdsKgMap.geneId)
      hg38.knownBlastTab.query (via ccdsKgMap.geneId)
      hg38.knownBlastTab.target (via ccdsKgMap.geneId)
      hg38.knownCanonical.transcript (via ccdsKgMap.geneId)
      hg38.knownCds.name (via ccdsKgMap.geneId)
      hg38.knownGene.name (via ccdsKgMap.geneId)
      hg38.knownGeneMrna.name (via ccdsKgMap.geneId)
      hg38.knownGenePep.name (via ccdsKgMap.geneId)
      hg38.knownIsoforms.transcript (via ccdsKgMap.geneId)
      hg38.knownToEnsembl.name (via ccdsKgMap.geneId)
      hg38.knownToGnfAtlas2.name (via ccdsKgMap.geneId)
      hg38.knownToHprd.name (via ccdsKgMap.geneId)
      hg38.knownToKeggEntrez.name (via ccdsKgMap.geneId)
      hg38.knownToLocusLink.name (via ccdsKgMap.geneId)
      hg38.knownToLynx.name (via ccdsKgMap.geneId)
      hg38.knownToMrna.name (via ccdsKgMap.geneId)
      hg38.knownToMrnaSingle.name (via ccdsKgMap.geneId)
      hg38.knownToMupit.name (via ccdsKgMap.geneId)
      hg38.knownToNextProt.name (via ccdsKgMap.geneId)
      hg38.knownToPfam.name (via ccdsKgMap.geneId)
      hg38.knownToRefSeq.name (via ccdsKgMap.geneId)
      hg38.knownToSuper.gene (via ccdsKgMap.geneId)
      hg38.knownToTag.name (via ccdsKgMap.geneId)
      hg38.knownToU133.name (via ccdsKgMap.geneId)
      hg38.knownToU95.name (via ccdsKgMap.geneId)
      hg38.knownToVisiGene.name (via ccdsKgMap.geneId)
      hg38.knownToWikipedia.name (via ccdsKgMap.geneId)
      hg38.mmBlastTab.query (via ccdsKgMap.geneId)
      hg38.rnBlastTab.query (via ccdsKgMap.geneId)
      hg38.scBlastTab.query (via ccdsKgMap.geneId)
      hg38.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.1ENST00000335137.4chr169054701081
CCDS72675.1ENST00000426406.3chr14507024516971
CCDS41221.1ENST00000332831.4chr16856786866731
CCDS2.2ENST00000342066.8chr19257309445741
CCDS2.2ENST00000622503.4chr19257409445810.998536
CCDS3.1ENST00000327044.7chr19442029592561
CCDS30550.1ENST00000338591.8chr19605839657191
CCDS53256.1ENST00000379407.7chr19665019750081
CCDS4.1ENST00000379410.8chr19664819758651
CCDS76083.1ENST00000433179.3chr19752049810291

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