Abstract:Motivation: Integrating heterogeneous data across distributed sources is a major requirement for in silico bioinformatics supporting translational research. For example, genome-scale data on patterns of gene expression in the fruit fly Drosophila melanogaster are widely used in functional genomic studies in many organisms to inform candidate gene selection and validate experimental results. However, current data integration solutions tend to be heavy weight, and require significant initial and ongoing investment of effort. Development of a common Web-based data integration infrastructure (a.k.a. data web), using Semantic Web standards, promises to alleviate these difficulties, but little is known about the feasibility, costs, risks or practical means of migrating to such an infrastructure. Results: We describe the development of OpenFlyData, a proof-of-concept system integrating gene expression data on D. melanogaster, combining Semantic Web standards with light-weight approaches to Web programming based on Web 2.0 design patterns. To support researchers designing and validating functional genomic studies, OpenFlyData includes user-facing search applications providing intuitive access to and comparison of gene expression data from FlyAtlas, the BDGP in situ database, and FlyTED, using data from FlyBase to expand and disambiguate gene names. OpenFlyData's services are also openly accessible, and are available for reuse by other bioinformaticians and application developers. Semi-automated methods and tools were developed to support labour- and knowledge-intensive tasks involved in deploying SPARQL services. These include methods for generating ontologies and relational-to-RDF mappings for relational databases, which we illustrate using the FlyBase Chado database schema; and methods for mapping gene identifiers between databases. The advantages of using Semantic Web standards for biomedical data integration are discussed, as are open issues. In particular, although the performance of open source SPARQL implementations is sufficient to query gene expression data directly from user-facing applications such as Web-based data fusions (a.k.a. mashups), we found open SPARQL endpoints to be vulnerable to denial-of-service-type problems, which must be mitigated to ensure reliability of services based on this standard. These results are relevant to data integration activities in translational bioinformatics. Availability: The gene expression search applications and SPARQL endpoints developed for OpenFlyData are deployed at http://openflydata.org. FlyUI, a library of JavaScript widgets providing re-usable user-interface components for Drosophila gene expression data, is available at http://flyui.googlecode.com. Software and ontologies to support transformation of data from FlyBase, FlyAtlas, BDGP and FlyTED to RDF are available at http://openflydata.googlecode.com. SPARQLite, an implementation of the SPARQL protocol, is available at http://sparqlite.googlecode.com. All software is provided under the GPL version 3 open source license.

FlyBase: updates to the Drosophila melanogaster knowledge base

FlyBase: updates to the Drosophila genes and genomes database

FlyBase 2.0: the next generation

FlyBase: a guided tour of highlighted features

FlyBase: introduction of the Drosophila melanogaster Release 6 reference genome assembly and large-scale migration of genome annotations

FlyRNAi.org 2025 update-expanded resources for new technologies and species

FlyAtlas 2: a new version of the Drosophila melanogaster expression atlas with RNA-Seq, miRNA-Seq and sex-specific data

A new experimental evidence-weighted signaling pathway resource in FlyBase

Updates to the Alliance of Genome Resources Central Infrastructure

Using FlyAtlas to identify better Drosophila melanogaster models of human disease

OpenFlyData: an exemplar data web integrating gene expression data on the fruit fly Drosophila melanogaster

Updates to the Alliance of Genome Resources Central Infrastructure Alliance of Genome Resources Consortium

New research resources at the Bloomington Drosophila Stock Center

Fly Cell Atlas: A single-nucleus transcriptomic atlas of the adult fruit fly

FlyVar: a database for genetic variation in Drosophila melanogaster.

FlyPrimerBank: an Online Database for Drosophila Melanogaster Gene Expression Analysis and Knockdown Evaluation of RNAi Reagents

The Genome Sequence of Drosophila Melanogaster.

Flynet: A Genomic Resource For Drosophila Melanogaster Transcriptional Regulatory Networks

The Drosophila melanogaster Genetic Reference Panel

Harnessing full-text publications for deep insights into C. elegans and Drosophila biomaps

Identification of Functional Elements and Regulatory Circuits by Drosophila Modencode