Schema for fbAllele
  Database: dm1    Primary Table: fbAllele    Row Count: 179,156   Data last updated: 2004-06-28
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
        dm1.bdgpExprLink.flyBaseId (via fbAllele.geneId)
      dm1.bdgpGeneInfo.flyBaseId (via fbAllele.geneId)
      dm1.bdgpNonCodingInfo.flyBaseId (via fbAllele.geneId)
      dm1.bdgpSwissProt.flyBaseId (via fbAllele.geneId)
      dm1.fbGene.geneId (via fbAllele.geneId)
      dm1.fbPhenotype.geneId (via fbAllele.geneId)
      dm1.fbSynonym.geneId (via fbAllele.geneId)
      dm1.fbTranscript.geneId (via fbAllele.geneId)
      dm1.flyBaseSwissProt.flyBaseId (via fbAllele.geneId)
      dm1.fbPhenotype.fbAllele (via fbAllele.id)

Sample Rows
 
idgeneIdname
1FBgn0025724wild-type
2FBgn0025724&bgr;'Cop+
3FBgn0043467classical
4FBgn0043467064Ya064Ya
5FBgn0043467wild-type
6FBgn0043467064Ya+
7FBgn0010347classical
8FBgn00103471.28P
9FBgn00103471.28rv13
10FBgn0010347wild-type

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