Schema for bdgpToRefSeq
  Database: dm1    Primary Table: bdgpToRefSeq    Row Count: 18,746   Data last updated: 2005-01-08
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name CG11023-RAvarchar(255) values primary ID
value NM_175941varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        dm1.arbExpDistance.query (via bdgpToRefSeq.name)
      dm1.arbExpDistance.target (via bdgpToRefSeq.name)
      dm1.bdgpBlastTab.query (via bdgpToRefSeq.name)
      dm1.bdgpBlastTab.target (via bdgpToRefSeq.name)
      dm1.bdgpCanonical.transcript (via bdgpToRefSeq.name)
      dm1.bdgpGene.name (via bdgpToRefSeq.name)
      dm1.bdgpGenePep.name (via bdgpToRefSeq.name)
      dm1.bdgpIsoforms.transcript (via bdgpToRefSeq.name)
      dm1.bdgpSwissProt.bdgpName (via bdgpToRefSeq.name)
      dm1.bdgpToCanonical.name (via bdgpToRefSeq.name)
      dm1.bdgpToLocusLink.name (via bdgpToRefSeq.name)
      dm1.bdgpToPfam.name (via bdgpToRefSeq.name)
      dm1.blastFBPep00.name (via bdgpToRefSeq.name)
      dm1.drBlastTab.query (via bdgpToRefSeq.name)
      dm1.fbTranscript.transcriptId (via bdgpToRefSeq.name)
      dm1.hgBlastTab.query (via bdgpToRefSeq.name)
      dm1.pscreen.geneIds (via bdgpToRefSeq.name)
      dm1.scBlastTab.query (via bdgpToRefSeq.name)
      dm1.mrnaOrientInfo.name (via bdgpToRefSeq.value)
      dm1.refFlat.name (via bdgpToRefSeq.value)
      dm1.refGene.name (via bdgpToRefSeq.value)
      dm1.refSeqAli.qName (via bdgpToRefSeq.value)
      hgFixed.gbCdnaInfo.acc (via bdgpToRefSeq.value)
      hgFixed.gbSeq.acc (via bdgpToRefSeq.value)
      hgFixed.imageClone.acc (via bdgpToRefSeq.value)
      hgFixed.refLink.mrnaAcc (via bdgpToRefSeq.value)
      hgFixed.refSeqStatus.mrnaAcc (via bdgpToRefSeq.value)
      hgFixed.refSeqSummary.mrnaAcc (via bdgpToRefSeq.value)
      knownGeneV39.kgXref.refseq (via bdgpToRefSeq.value)
      knownGeneV39.knownToRefSeq.value (via bdgpToRefSeq.value)

Sample Rows
 
namevalue
CG11023-RANM_175941
CG11371-RBNM_134642
CG11372-RANM_134643
CG11374-RANM_134644
CG11376-RANM_134645
CG11377-RANM_134646
CG2674-RENM_205880
CG2674-RBNM_164361
CG2674-RANM_164356
CG2674-RHNM_164359

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