Schema for fbTranscript
  Database: dm3    Primary Table: fbTranscript    Row Count: 0   Data last updated: 2006-10-11
Format description: Links FlyBase gene IDs and BDGP transcript IDs
On download server: MariaDB table dump directory
fieldSQL type info description
geneId varchar(255) values FlyBase Gene ID
transcriptId varchar(255) values BDGP Transcript ID

Connected Tables and Joining Fields
        dm3.bdgpExprLink.flyBaseId (via fbTranscript.geneId)
      dm3.fbAllele.geneId (via fbTranscript.geneId)
      dm3.fbGene.geneId (via fbTranscript.geneId)
      dm3.fbPhenotype.geneId (via fbTranscript.geneId)
      dm3.fbSynonym.geneId (via fbTranscript.geneId)
      dm3.flyBase2004Xref.fbgn (via fbTranscript.geneId)
      dm3.pscreen.geneIds (via fbTranscript.geneId)

Sample Rows
 
geneIdtranscriptId

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