Flexible network reconstruction from relational databases with Cytoscape and CytoSQL

Area of Science:

• Bioinformatics
• Computational Biology
• Systems Biology

Background:

• Molecular interaction networks are crucial for biological research and are often visualized using software like Cytoscape.
• Data import into Cytoscape typically relies on specific file formats or dedicated plugins for external databases.
• Existing solutions lack a generic method for integrating data from diverse relational databases with unique structures.

Purpose of the Study:

• To develop a versatile Cytoscape plugin for seamless interaction with any relational database.
• To provide a unified solution for accessing and visualizing molecular data stored in various database formats.

Main Methods:

• Development of the CytoSQL plugin for Cytoscape.
• Implementation of SQL query execution directly within the Cytoscape environment.
• Integration of node and edge attributes from existing networks as parameters in SQL queries.
• Conversion of retrieved relational data into Cytoscape network components.

Main Results:

• The CytoSQL plugin facilitates direct connection between Cytoscape and any relational database.
• Users can execute SQL queries to retrieve specific molecular data subsets.
• The plugin enables the dynamic generation and enrichment of molecular networks based on complex criteria.
• Case studies demonstrate the plugin's flexibility in creating meaningful network representations.

Conclusions:

• CytoSQL provides a unified and powerful approach for Cytoscape to interact with relational databases.
• The tool leverages SQL's capabilities to rapidly generate and refine complex biological networks.
• CytoSQL enhances the utility of Cytoscape for data-driven network analysis and visualization.