Schema for fbTranscript
  Database: dm1    Primary Table: fbTranscript    Row Count: 18,746   Data last updated: 2005-01-08
Format description: Links FlyBase gene IDs and BDGP transcript IDs
On download server: MariaDB table dump directory
fieldexampleSQL type info description
geneId FBgn0039596varchar(255) values FlyBase Gene ID
transcriptId CG10000-RAvarchar(255) values BDGP Transcript ID

Connected Tables and Joining Fields
        dm1.bdgpExprLink.flyBaseId (via fbTranscript.geneId)
      dm1.bdgpGeneInfo.flyBaseId (via fbTranscript.geneId)
      dm1.bdgpNonCodingInfo.flyBaseId (via fbTranscript.geneId)
      dm1.bdgpSwissProt.flyBaseId (via fbTranscript.geneId)
      dm1.fbAllele.geneId (via fbTranscript.geneId)
      dm1.fbGene.geneId (via fbTranscript.geneId)
      dm1.fbPhenotype.geneId (via fbTranscript.geneId)
      dm1.fbSynonym.geneId (via fbTranscript.geneId)
      dm1.flyBaseSwissProt.flyBaseId (via fbTranscript.geneId)
      dm1.arbExpDistance.query (via fbTranscript.transcriptId)
      dm1.arbExpDistance.target (via fbTranscript.transcriptId)
      dm1.bdgpBlastTab.query (via fbTranscript.transcriptId)
      dm1.bdgpBlastTab.target (via fbTranscript.transcriptId)
      dm1.bdgpCanonical.transcript (via fbTranscript.transcriptId)
      dm1.bdgpGene.name (via fbTranscript.transcriptId)
      dm1.bdgpGenePep.name (via fbTranscript.transcriptId)
      dm1.bdgpIsoforms.transcript (via fbTranscript.transcriptId)
      dm1.bdgpSwissProt.bdgpName (via fbTranscript.transcriptId)
      dm1.bdgpToCanonical.name (via fbTranscript.transcriptId)
      dm1.bdgpToLocusLink.name (via fbTranscript.transcriptId)
      dm1.bdgpToPfam.name (via fbTranscript.transcriptId)
      dm1.bdgpToRefSeq.name (via fbTranscript.transcriptId)
      dm1.blastFBPep00.name (via fbTranscript.transcriptId)
      dm1.drBlastTab.query (via fbTranscript.transcriptId)
      dm1.hgBlastTab.query (via fbTranscript.transcriptId)
      dm1.pscreen.geneIds (via fbTranscript.transcriptId)
      dm1.scBlastTab.query (via fbTranscript.transcriptId)

Sample Rows
 
geneIdtranscriptId
FBgn0039596CG10000-RA
FBgn0039595CG10001-RA
FBgn0000659CG10002-RA
FBgn0037972CG10005-RA
FBgn0036461CG10006-RA
FBgn0037971CG10007-RA
FBgn0026400CG10009-RA
FBgn0039590CG10011-RA
FBgn0038012CG10013-RA
FBgn0038000CG10014-RA

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