Schema for flyBaseToRefSeq
  Database: dm2    Primary Table: flyBaseToRefSeq    Row Count: 19,430   Data last updated: 2007-04-03
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 CG12581-RBvarchar(255) values primary ID
value NM_141178varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        dm2.arbExpDistance.query (via flyBaseToRefSeq.name)
      dm2.arbExpDistance.target (via flyBaseToRefSeq.name)
      dm2.ceBlastTab.query (via flyBaseToRefSeq.name)
      dm2.drBlastTab.query (via flyBaseToRefSeq.name)
      dm2.flyBase2004Xref.name (via flyBaseToRefSeq.name)
      dm2.flyBaseBlastTab.query (via flyBaseToRefSeq.name)
      dm2.flyBaseBlastTab.target (via flyBaseToRefSeq.name)
      dm2.flyBaseCanonical.transcript (via flyBaseToRefSeq.name)
      dm2.flyBaseGene.name (via flyBaseToRefSeq.name)
      dm2.flyBaseIsoforms.transcript (via flyBaseToRefSeq.name)
      dm2.flyBaseNoncoding.name (via flyBaseToRefSeq.name)
      dm2.flyBasePep.name (via flyBaseToRefSeq.name)
      dm2.flyBaseToCG.name (via flyBaseToRefSeq.name)
      dm2.flyBaseToDescription.name (via flyBaseToRefSeq.name)
      dm2.flyBaseToPfam.name (via flyBaseToRefSeq.name)
      dm2.flyBaseToUniProt.name (via flyBaseToRefSeq.name)
      dm2.flyP2P.query (via flyBaseToRefSeq.name)
      dm2.flyP2P.target (via flyBaseToRefSeq.name)
      dm2.hgBlastTab.query (via flyBaseToRefSeq.name)
      dm2.mmBlastTab.query (via flyBaseToRefSeq.name)
      dm2.rnBlastTab.query (via flyBaseToRefSeq.name)
      dm2.scBlastTab.query (via flyBaseToRefSeq.name)
      dm2.mrnaOrientInfo.name (via flyBaseToRefSeq.value)
      dm2.refFlat.name (via flyBaseToRefSeq.value)
      dm2.refGene.name (via flyBaseToRefSeq.value)
      dm2.refSeqAli.qName (via flyBaseToRefSeq.value)
      hgFixed.gbCdnaInfo.acc (via flyBaseToRefSeq.value)
      hgFixed.gbSeq.acc (via flyBaseToRefSeq.value)
      hgFixed.imageClone.acc (via flyBaseToRefSeq.value)
      hgFixed.refLink.mrnaAcc (via flyBaseToRefSeq.value)
      hgFixed.refSeqStatus.mrnaAcc (via flyBaseToRefSeq.value)
      hgFixed.refSeqSummary.mrnaAcc (via flyBaseToRefSeq.value)
      knownGeneV39.kgXref.refseq (via flyBaseToRefSeq.value)
      knownGeneV39.knownToRefSeq.value (via flyBaseToRefSeq.value)

Sample Rows
 
namevalue
CG12581-RBNM_141178
CG12581-RANM_141178
CG33294-RANM_001038949
CG12582-RANM_141179
CG1107-RANM_164317
CG1107-RBNM_141181
CG14637-RANM_079496
CG1106-RFNM_080126
CG1106-RHNM_164321
CG1106-RENM_164321

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