Release 18.1

FlyMine 18.1 contains no new data but fixes several issues with advanced QueryBuilder features and rare export problems.  All other functionality remains the same.

The technical details:


  • The Query Overview in the top right pane is now more consistently ordered.
  • Constraint Logic: queries with multiple sets of OR constraints now work correctly, subsequent OR constraints were being ignored.
  • Constraint Logic: removing constraints no longer resets all operations from OR to AND, and no longer removes brackets.
  • ‘loop queries’ and outer joins now work correctly together, loop constraints are not permitted across outer joins.
  • New constraints added to the query always default to inner joins.
  • Paths are no longer added to the Query Overview when you cancel adding a constraint


  • Fixed a bug where export failed in some cases with complex queries.
  • Exported column headings now use the description if this has been specified in a Template Query – to match the results table behaviour.
  • The column description for the root node is no longer lost when exporting.
  • Rows are no longer duplicated when exporting a query with multiple outer joined collections that each contain only one row.
  • Removing the column the original query was sorted by no longer gives an error when exporting.

Release 18.0

In Release 18.0 we have updated data from FlyBase to release FB2009_06 and many sources are updated to the latest versions.


Data from FlyBase is updated to the FB2009_06 release and many other sources have been updated to the latest versions, specific changes are detailed below. For a complete list of all data included in FlyMine see the ‘Data’ tab above.

  • NEW – Added orthologues from TreeFam
  • FIX – Fixed bug that caused some genes and protein domains to lose their names.
  • UPDATE – Added a goterm.parents collection to make querying easier.
  • UPDATE – Orthologues between the 12 Drosophila species now come directly from FlyBase rather than the orginal Clark-Eisen analysis (PMID: 17994087).


  • FIX – Favourite star on my mine page for templates
  • NEW – Added sign up for mailing list when creating account
  • FIX – Several QueryBuilder bugs, regarding a combination of loop queries and outer joins
  • UPDATE – The order of the QueryBuilder summary no longer changes when join styles change. We’ve implemented a better way of ordering paths:
    • that ignores the difference between inner and outer joins
    • the puts attributes before references and collections
    • orders alphabetically within attributes/refs/collections

Release 17.0

In Release 17.0 we have updated data from FlyBase to release FB2009_05 and many sources are updated to the latest versions.


Data from FlyBase is updated to the FB2009_05 release and many other sources have been updated to the latest versions, specific changes are detailed below. For a complete list of all data included in FlyMine see the ‘Data’ tab above.

  • NEW – Added natural_transposable_element features from FlyBase chado.
  • FIX – Fixed bug that caused some proteins from FlyBase not to be loaded.
  • UPDATE – Create synonyms for FlyBase proteins discarded because they have an identical sequence to a protein already stored in the database.
  • UPDATE – Added seven new FlyAtlas tissues.
  • FIX – Added datasets and long names to FlyBase interactions.
  • FIX – Added datasets to protein domains from InterPro.
  • FIX – Fixed bug that prevented the loading of self-self interactions from IntAct and BioGRID.

User interface

  • UPDATE – Added symbol to identifiers to show in HTML title, eg changed ‘Report page: FBgn0000606’ to ‘Gene report for eve (FBgn0000606)’
  • NEW – Added link from list analysis and report pages to modMine.
  • FIX – Improved performance of templates page in MyMine.
  • FIX – Fixed bug encountered when trying to access the list web services.
  • UPDATE – Changed the orientation of the FlyAtlas widget to increase readability.
  • UPDATE – Improved error messages generated by the web services.
  • UPDATE – Improved messages given when arriving to FlyMine from another website.
  • FIX – Fixed link to QueryBuilder on home page.
  • UPDATE – GOTerm now autocompletes in the QueryBuilder.
  • FIX – Fixed bug in bulk download query for Anopheles homologues.

Release 16.0

In Release 16.0 we have updated data from FlyBase to release FB2009_04 and many sources are updated to the latest versions, the way we include proteins has been redesigned so that all isoforms from UniProt are loaded. We have introduced a significant new feature to querying (‘outer joins’) and improved general query and export performance.


Data from FlyBase is updated to the FB2009_04 release and many other sources have been updated to the latest versions, specific changes are detailed below. For a complete list of all data included in FlyMine see the ‘Data’ tab above.

  • UPDATE – We now include all isoforms of proteins from UniProt.
  • UPDATE – Gene Ontology (GO) data assigned to genes has been re-modelled to now include relationship types between terms. Genes no longer have an allGoAnnotation collection to model transitive closure of the ontology, instead use the GoAnnotation.relations.parents collection.
  • NEW – We now load deficiencies/deletions and aberrations from FlyBase
  • FIX – TransposableElementInsertionSite features now have orientations, these are displayed in GBrowse.
  • FIX – Rat genes now have synonyms, organisms and datasets correctly attached
  • FIX – Drosophila mRNA now have synonyms and datasets correctly attached
  • FIX – ESTs now have locations
  • FIX – Dmel proteins from UniProt are correctly attached to genes.
  • FIX – All genes and proteins now have a datasource.
  • UPDATE – Cytological location data now available
  • UPDATE – Proteins and transcripts are now linked
  • NEW – Predicted miRNA targets
  • NEW – Drosophila development ontology
  • NEW – Synonyms now have datasets, so you can tell who is using which identifier.
  • UPDATE – Anopheles proteins now loaded for correct strain.
  • UPDATE - Apis mellifera genome removed.

Query system

In a major update to the query system it is now possible to choose whether columns include information that must be present to produce a row in the results or should just be shown if a value is present. This is best illustrated with an example. Consider an organism that has a thousand genes but only 900 are known to code for a protein. In FlyMine there would be 1000 genes and 900 of them would be related to a protein. You can now query for genes and related proteins in two ways:

  1. ‘inner join’ – You create a query with two columns, the first for the gene identifier, the second with the protein identifier. Only 900 rows are return, those that don’t have a protein aren’t included. This is how all queries worked before this release.
  2. ‘outer join’ – You create the same query but specify the gene to protein relationship as an ‘outer join’. This will return all 1000 genes in the first column and have empty cells in the second column for the 100 genes that don’t have a protein.

Organise your lists

You can now apply aritrary tags to your saved lists both on the list analysis page and in MyMine. Tags can be any label you like to help you categorise your saved information, one list can have multiple tags applied. You can filter lists by tag from the Lists view page.


Improvements to the internals of InterMine have made exporting large datasets significantly faster – you should find download speeds around an order of magnitude better.

User interface

  • NEW – web service API is available.
  • FIX – Creating a list after converting between orthologues now works.
  • NEW – link to ArrayExpress atlas is available on certain report pages.
  • NEW – link to FlyBase appears on list analysis pages for alleles and insertions.
  • FIX – Foreign characters display properly
  • FIX – Chromosome distribution widget now excludes rubbish chromosomes from its calculations.
  • FIX – 404 error page improved.
  • FIX – List information on the report page is now at the top, for increased visibility
  • FIX – Export display issues fixed for Internet Explorer.
  • FIX – Fixed some slow algorithms displaying results data.
  • FIX – Fixed error in “Add Column” function where there are no extra columns to add.
  • FIX – Fixed “View all” button on Sequence residues.
  • UPDATE – Export now has column headings at the top.
  • FIX – Performance of widget queries improved.
  • FIX – Wildcards in queries are exported correctly.
  • UPDATE – Collection sizes are updated using AJAX on report pages.
  • UPDATE – UTRs now present in GBrowse

Release 15.0

In Release 15.0 we have updated data from FlyBase to release FB2008_08 and many sources are updated to the latest versions.


Data from FlyBase is updated to the FB2008_08 release and many other sources have been updated to the latest versions, specific changes are detailed below. For a complete list of all data included in FlyMine see the ‘Data’ tab above.

  • NEW – FlyMine now loads all types interactions from the BioGRID for D. melanogaster, C. elegans and S. cerevisiae. Currently, no distinction is made between protein and genetic interactions. All of them (the ones from IntAct as well as the ones from the BioGRID) are now called ‘Interaction’. The Interaction Term allows to search for a particular interaction, eg phenotypic enhancement, two hybrid.
  • NEW – Affymetrix Probesets from the GeneChip D. melanogaster Genome 1.0 and 2.0 Arrays now have locations and mapped genes, obtained from the Ensembl database. FlyMine only loads probesets that match to at least one gene. More information on the Ensembl probeset mappings, can be found at Ensembl help
  • NEW – Loaded all aberrations from FlyBase including Drosdel deletions and they are now called ChromosomeStructureVariation. Each feature type is represented by a seperate sub-class: ChromosomalDeletion, ChromosomalDuplication, ChromosomalInversion, and ChromosomalTranslocation.
  • FIXED – The Ensembl id is correctly set for human genes.
  • NEW – Gene.flybaseFeatureType has been renamed to Gene.featureType.
  • FIXED – all MRNAs now have Translations.
  • FIXED – UTRs now have chromosome locations and appear in GBrowse.


In this release, we’ve extended and improved the export system. We’ve optomised and configured the export process which has resulted in marked speed improvements. Also, we’ve added new functionality.

User interface

  • NEW – you can now have a dash in a list name
  • NEW – links on the allele list page directly to FlyBase
  • NEW – links on the allele list page to convert list to genes
  • FIXED – improved error handling throughout the site, including the QueryBuilder, template and query import pages
  • FIXED – the quick search now handles special characters correctly so you can search for any identifier, eg.
  • FIXED – selected records in your list stay highlighted even if you navigate away and then back to the list analysis page
  • FIXED – template form handles wildcards correctly

Future of FlyMine

Dear FlyMine users,
We regret to announce that FlyMine will only be updated until December 2008/ January 2009. After that the final version will be kept live for as many years as it is still significantly used. Condolences would be appreciated and can be sent to!
There are a couple of reasons for this change. Currently there is a great opportunity to develop a medically-focussed database using the InterMine system developed during the FlyMine project: we plan to generate a resource valuable to the broader biomedical research community and for which there will be little overlap with other resources worldwide. In addition, our most recent funding reviewers expressed concern at perceived overlap with FlyBase, leading us to re-evaluate where we could most effectively contribute.
Fortunately, FlyBase is keen to cover the loss of functionality provided to the Drosophila community either by adopting InterMine or by developing similar functionality themselves. In order to assess priorities for users we will be carrying out a survey jointly with FlyBase and encourage you to take part.
Drosophila data will still be available through the InterMine platform as part of the modENCODE project. In addition, the NIH is reviewing an application to incorporate InterMine functionality as part of the yeast (SGD), rat (RGD) and zebrafish (ZFIN) model organism databases.
During the FlyMine project our group developed the open source InterMine system, which is software used to create data warehouses with a flexible web interface. InterMine reduces the effort needed to build and maintain both small and large-scale data warehouses, while providing flexible querying, powerful operations on lists and integrated analysis tools.
InterMine has become a successful project in its own right and is being adopted by a growing number of groups for their own database projects. It has made real progress in enabling the creation of integrated databases and providing biologists with advanced functionality, and we will continue its development. We thank all users of FlyMine for contributing to this success by providing feedback and suggestions.
The FlyMine/ InterMine Team

Release 14.0

In Release 14.0 we have updated data from FlyBase to release FB2008_06 and many sources are updated to the latest versions. We have added an autocompletion feature for many constraints in template queries and QueryBuilder. This means that as you type, for example a GO term or protein domain name, suggested matches will be provided.


Data from FlyBase is updated to the FB2008_06 release and many other sources have been updated to the latest versions, specific changes are detailed below. For a complete list of all data included in FlyMine see the ‘Data’ tab above.

  • NEW - Drosophila genes now have a field ‘flyBaseFeatureType’ field for the gene type e.g. protein_coding, miRNA_gene.
  • NEW - D. melanogaster microRNATargets now have chromosome locations and appear in GBrowse.
  • FIX - C. elegans genes and proteins are now correctly linked to one another.
  • NEW – CRM and binding sites from REDfly now have an evidence field which contains information about the experiment.
  • FIX – More probesets from AffyMetrix are correctly mapped to genes, including those with predicted transcripts
  • NEW – A new tissue, the salivary gland, has been added to the FlyAtlas dataset.

Data integration

In this release we further improved the data integration system to update old identifiers for Drosophila genes that are provided by many data sources to match a current FlyBase identifier. We now include only current FlyBase genes that have a genome location (see 13.0 release notes for more details).

Data sources

Most data, including all genes and proteins, have been assigned a dataset. A dataset includes the source of the data, dataset name and URL, allowing you to quickly and easily find the origin of the data.


Many name fields in template queries and the QueryBuilder now have type-ahead autocompletion to assist in selecting valid terms. As you start to type, possible matches are fetched from FlyMine; the text you have typed can match anywhere within the terms and multiple words can be matched. This is particularly useful for GO terms or protein domain names.

Removing list entries

It is now possible to remove entries from one of your lists. On the List Analysis page you can now select entries in the list and use the new ‘Edit’ menu to delete them from your list or add them to another existing list.

User interface

  • NEW – added linkouts for genes to BDGP in situ and for alleles to FlyBase
  • FIX – you can now access the lists and query history section of MyMine when not logged in. This allows you to delete your temporary lists.
  • FIX – GLEANR symbols are no longer low quality matches when using them to upload a list of Drosophila genes.
  • FIX – template and list search pages no longer reset the search term when using the back button.

Template web services

  • FIX – the ‘Show link with constraint values highlighted in red’ now highlights every value correctly
  • FIX – various javascript errors in Internet Explorer 6.0 have been fixed that prevented the results count from being updated.
  • NEW – results are returned with the correct file extension which makes it easier for programs to correctly open the file
  • FIX – you can now login while on the template web services page
  • FIX – template form correctly updates on error


  • NEW – extra columns added to the widget export
  • FIX – enrichment widgets include more digits when displayed in scientific notation
  • FIX – enrichment widgets no longer overlap when displayed
  • NEW – statistical enrichment widgets now link to documentation on the method of calculation used