Query Tabular

Query Tabular imports tabular files into a SQLite database within Galaxy and enables SQL- and regular expression-based transformations to support integration across genomics, proteomics, and metabolomics workflows.

Key Features:

• SQLite Database Integration: Automatically generates a SQLite database from tabular input files within a Galaxy workflow to enable relational queries.
• SQL Querying: Allows execution of SQL queries on the generated SQLite database for data manipulation and aggregation.
• Regular Expression Support: Provides regular expression-based find/replace and filtering for advanced text processing beyond SQL.
• Customized Tabular Output Generation: Produces transformed tabular outputs from the database tailored for downstream analysis tools.

Scientific Applications:

• Multi-omic Workflow Integration: Facilitates integration of datasets across genomics, proteomics, and metabolomics by converting intermediate outputs into a relational format.
• Preparation of Inputs for Downstream Analyses: Transforms and formats tabular data to generate compatible inputs for subsequent analysis tools within Galaxy workflows.

Methodology:

The tool creates a SQLite database from tabular input data in Galaxy, enables execution of SQL queries and application of regular expressions for data manipulations and transformations, and saves customized tabular outputs back into the Galaxy history.