Schema for fbAllele
  Database: dm3    Primary Table: fbAllele    Row Count: 228,333   Data last updated: 2006-10-11
Format description: The alleles of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(11) range Allele ID
geneId FBgn0025724varchar(255) values Flybase ID of gene
name wild-typevarchar(255) values Allele name

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

Sample Rows
 
idgeneIdname
1FBgn0025724wild-type
2FBgn0025724&bgr;'Cop+
3FBgn0070058classical
4FBgn0070058&lgr;attP1
5FBgn0070058&lgr;attP2
6FBgn0043467classical
7FBgn0043467064Ya064Ya
8FBgn0043467wild-type
9FBgn0043467064Ya+
10FBgn0010347classical

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