Schema for flyBaseToRefSeq
  Database: dm3    Primary Table: flyBaseToRefSeq    Row Count: 21,078   Data last updated: 2008-10-21
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 CG17866-RBvarchar(255) values primary ID
value NM_001015505varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        dm3.arbExpDistance.query (via flyBaseToRefSeq.name)
      dm3.arbExpDistance.target (via flyBaseToRefSeq.name)
      dm3.ceBlastTab.query (via flyBaseToRefSeq.name)
      dm3.drBlastTab.query (via flyBaseToRefSeq.name)
      dm3.flyBase2004Xref.name (via flyBaseToRefSeq.name)
      dm3.flyBaseBlastTab.query (via flyBaseToRefSeq.name)
      dm3.flyBaseBlastTab.target (via flyBaseToRefSeq.name)
      dm3.flyBaseCanonical.transcript (via flyBaseToRefSeq.name)
      dm3.flyBaseGene.name (via flyBaseToRefSeq.name)
      dm3.flyBaseIsoforms.transcript (via flyBaseToRefSeq.name)
      dm3.flyBaseNoncoding.name (via flyBaseToRefSeq.name)
      dm3.flyBasePep.name (via flyBaseToRefSeq.name)
      dm3.flyBaseToCG.name (via flyBaseToRefSeq.name)
      dm3.flyBaseToDescription.name (via flyBaseToRefSeq.name)
      dm3.flyBaseToPfam.name (via flyBaseToRefSeq.name)
      dm3.flyBaseToUniProt.name (via flyBaseToRefSeq.name)
      dm3.flyP2P.query (via flyBaseToRefSeq.name)
      dm3.flyP2P.target (via flyBaseToRefSeq.name)
      dm3.hgBlastTab.query (via flyBaseToRefSeq.name)
      dm3.mmBlastTab.query (via flyBaseToRefSeq.name)
      dm3.rnBlastTab.query (via flyBaseToRefSeq.name)
      dm3.scBlastTab.query (via flyBaseToRefSeq.name)
      dm3.mrnaOrientInfo.name (via flyBaseToRefSeq.value)
      dm3.refFlat.name (via flyBaseToRefSeq.value)
      dm3.refGene.name (via flyBaseToRefSeq.value)
      dm3.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
CG17866-RBNM_001015505
CG40446-RANM_001015498
CG40444-RANM_001015499
CG17629-RANM_001111012
CG40440-RANM_001015502
CG40448-RANM_001015497
CG40445-RANM_001015500
CG40441-RANM_001111013
CG2893-RBNM_001015260
CG2893-RCNM_001015261

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