Schema for ccdsInfo
  Database: hg17    Primary Table: ccdsInfo    Row Count: 30,711   Data last updated: 2008-02-01
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 ENST00000328115char(18) values mRNA accession (NCBI or Hinxton)
protAcc ENSP00000331758char(18) values protein accession (NCBI or Hinxton)

Connected Tables and Joining Fields
        hg17.ccdsGene.name (via ccdsInfo.ccds)
      hg17.ccdsKgMap.ccdsId (via ccdsInfo.ccds)
      hg17.altGraphX.mrnaRefs (via ccdsInfo.mrnaAcc)
      hg17.dupSpMrna.dupMrnaID (via ccdsInfo.mrnaAcc)
      hg17.dupSpMrna.mrnaID (via ccdsInfo.mrnaAcc)
      hg17.ensGene.name (via ccdsInfo.mrnaAcc)
      hg17.kgXref.refseq (via ccdsInfo.mrnaAcc)
      hg17.knownToRefSeq.value (via ccdsInfo.mrnaAcc)
      hg17.mrnaOrientInfo.name (via ccdsInfo.mrnaAcc)
      hg17.mrnaRefseq.mrna (via ccdsInfo.mrnaAcc)
      hg17.mrnaRefseq.refseq (via ccdsInfo.mrnaAcc)
      hg17.refFlat.name (via ccdsInfo.mrnaAcc)
      hg17.refGene.name (via ccdsInfo.mrnaAcc)
      hg17.refSeqAli.qName (via ccdsInfo.mrnaAcc)
      hg17.spMrna.mrnaID (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.1HENST00000328115ENSP00000331758
CCDS10.1NNM_004195.2NP_004186.1
CCDS100.1HENST00000319254ENSP00000317735
CCDS100.1NNM_024980.4NP_079256.4
CCDS1000.1NNM_020127.1NP_064512.1
CCDS1000.1HOTTHUMT00000035022OTTHUMP00000014511
CCDS10000.1HENST00000339418ENSP00000339175
CCDS10000.1NNM_177533.2NP_803877.2
CCDS10001.1NNM_001519.2NP_001510.2
CCDS10001.1HOTTHUMT00000074548OTTHUMP00000028454

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