Schema for ccdsInfo
  Database: hg18    Primary Table: ccdsInfo    Row Count: 52,323   Data last updated: 2019-10-05
Format description: Consensus CDS information, links CCDS ids to NCBI and Hinxton accessions
On download server: MariaDB table dump directory
fieldexampleSQL type info description
ccds CCDS10.1char(12) values CCDS id
srcDb Hchar(1) values source database: N=NCBI, H=Hinxton
mrnaAcc ENST00000379268char(18) values mRNA accession (NCBI or Hinxton)
protAcc ENSP00000368570char(18) values protein accession (NCBI or Hinxton)

Connected Tables and Joining Fields
        hg18.ccdsGene.name (via ccdsInfo.ccds)
      hg18.ccdsKgMap.ccdsId (via ccdsInfo.ccds)
      hg18.ccdsNotes.ccds (via ccdsInfo.ccds)
      hg18.ensGene.name (via ccdsInfo.mrnaAcc)
      hg18.kgXref.refseq (via ccdsInfo.mrnaAcc)
      hg18.knownToRefSeq.value (via ccdsInfo.mrnaAcc)
      hg18.mrnaOrientInfo.name (via ccdsInfo.mrnaAcc)
      hg18.mrnaRefseq.refseq (via ccdsInfo.mrnaAcc)
      hg18.refFlat.name (via ccdsInfo.mrnaAcc)
      hg18.refGene.name (via ccdsInfo.mrnaAcc)
      hg18.refSeqAli.qName (via ccdsInfo.mrnaAcc)
      hgFixed.gbCdnaInfo.acc (via ccdsInfo.mrnaAcc)
      hgFixed.gbSeq.acc (via ccdsInfo.mrnaAcc)
      hgFixed.imageClone.acc (via ccdsInfo.mrnaAcc)
      hgFixed.refLink.mrnaAcc (via ccdsInfo.mrnaAcc)
      hgFixed.refSeqStatus.mrnaAcc (via ccdsInfo.mrnaAcc)
      hgFixed.refSeqSummary.mrnaAcc (via ccdsInfo.mrnaAcc)
      knownGeneV39.kgXref.refseq (via ccdsInfo.mrnaAcc)
      knownGeneV39.knownToRefSeq.value (via ccdsInfo.mrnaAcc)

Sample Rows
 
ccdssrcDbmrnaAccprotAcc
CCDS10.1HENST00000379268ENSP00000368570
CCDS10.1NNM_004195.2NP_004186.1
CCDS10.1HOTTHUMT00000004083OTTHUMP00000001519
CCDS100.2HENST00000377411ENSP00000366628
CCDS100.2NNM_024980.4NP_079256.4
CCDS100.2HOTTHUMT00000127658OTTHUMP00000082681
CCDS1000.1HENST00000368849ENSP00000357842
CCDS1000.1NNM_020127.2NP_064512.1
CCDS1000.1HOTTHUMT00000035022OTTHUMP00000014511
CCDS10000.1HENST00000339418ENSP00000339175

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