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.

A new experimental evidence-weighted signaling pathway resource in FlyBase

FlyBase 2.0: the next generation

Flynet: A Genomic Resource For Drosophila Melanogaster Transcriptional Regulatory Networks

FlyBase: updates to the Drosophila melanogaster knowledge base

FlyBase: a guided tour of highlighted features

FlyBase: updates to the Drosophila genes and genomes database

Using FlyAtlas to identify better Drosophila melanogaster models of human disease

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

FlyPhoneDB: An integrated web-based resource for cell-cell communication prediction in Drosophila

Uniformly curated signaling pathways reveal tissue-specific cross-talks and support drug target discovery

Identification of Functional Elements and Regulatory Circuits by Drosophila Modencode

Proteomic Study Reveals Major Pathways Regulating the Development of Black Soldier Fly

Binding profiles for 954 Drosophila and transcription factors reveal tissue specific regulatory relationships

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

A Large-Scale Functional Approach to Uncover Human Genes and Pathways in Drosophila

Genome-Wide Identification of Neuronal Activity-Regulated Genes in Drosophila

New research resources at the Bloomington Drosophila Stock Center

DVT: a high-throughput analysis pipeline for locomotion and social behavior in adult Drosophila melanogaster

A resource for manipulating gene expression and analyzing cis-regulatory modules in the Drosophila CNS

Perspectives on gene expression regulation techniques in Drosophila

A large-scale in vivo screen to investigate the roles of human genes in Drosophila melanogaster