Improve your Galaxy text life: The Query Tabular Tool [version 1; referees: 1 approved, 2 approved with reservations]

Galaxy provides an accessible platform where multi-step data analysis workflows integrating disparate software can be run, even by researchers with limited programming expertise.  Applications of such sophisticated workflows are many, including those which integrate software from different ‘omic domains (e.g. genomics, proteomics, metabolomics). In these complex workflows, intermediate outputs are often generated as tabular text files, which must be transformed into customized formats which are compatible with the next software tools in the pipeline.  Consequently, many text manipulation steps are added to an already complex workflow, overly complicating the process and decreasing usability, especially for non-expert bench researchers focused on obtaining results.  In some cases, limitations to existing text manipulation are such that desired analyses can only be carried out using highly sophisticated processing steps beyond the reach of most users.  As a solution, we have developed the Query Tabular Galaxy tool, which leverages a SQLite database generated from tabular input data.  This database can be queried and manipulated to produce transformed and customized tabular outputs compatible with downstream processing steps.  Regular expressions can also be utilized for even more sophisticated manipulations, such as find and replace and other filtering actions.  Using several Galaxy-based multi-omic workflows as an example, we demonstrate how the Query Tabular tool dramatically streamlines and simplifies the creation of multi-step analyses, efficiently enabling complicated textual manipulations and processing.  This tool should find broad utility for users of the Galaxy platform seeking to develop and use sophisticated workflows involving text manipulation on tabular outputs

Improve your Galaxy text life: The Query Tabular Tool [version 2; referees: 2 approved, 1 approved with reservations]

Galaxy provides an accessible platform where multi-step data analysis workflows integrating disparate software can be run, even by researchers with limited programming expertise. Applications of such sophisticated workflows are many, including those which integrate software from different ‘omic domains (e.g. genomics, proteomics, metabolomics). In these complex workflows, intermediate outputs are often generated as tabular text files, which must be transformed into customized formats which are compatible with the next software tools in the pipeline. Consequently, many text manipulation steps are added to an already complex workflow, overly complicating the process. In some cases, limitations to existing text manipulation are such that desired analyses can only be carried out using highly sophisticated processing steps beyond the reach of even advanced users and developers. For users with some SQL knowledge, these text operations could be combined into single, concise query on a relational database. As a solution, we have developed the Query Tabular Galaxy tool, which leverages a SQLite database generated from tabular input data. This database can be queried and manipulated to produce transformed and customized tabular outputs compatible with downstream processing steps. Regular expressions can also be utilized for even more sophisticated manipulations, such as find and replace and other filtering actions. Using several Galaxy-based multi-omic workflows as an example, we demonstrate how the Query Tabular tool dramatically streamlines and simplifies the creation of multi-step analyses, efficiently enabling complicated textual manipulations and processing. This tool should find broad utility for users of the Galaxy platform seeking to develop and use sophisticated workflows involving text manipulation on tabular outputs

OGT Regulates Mitochondrial Biogenesis and Function via Diabetes Susceptibility Gene Pdx1

-GlcNAc transferase (OGT), a nutrient sensor sensitive to glucose flux, is highly expressed in the pancreas. However, the role of OGT in the mitochondria of β-cells is unexplored. In this study, we identified the role of OGT in mitochondrial function in β-cells. Constitutive deletion of OGT (βOGTKO) or inducible ablation in mature β-cells (iβOGTKO) causes distinct effects on mitochondrial morphology and function. Islets from βOGTKO, but not iβOGTKO, mice display swollen mitochondria, reduced glucose-stimulated oxygen consumption rate, ATP production, and glycolysis. Alleviating endoplasmic reticulum stress by genetic deletion of Chop did not rescue the mitochondrial dysfunction in βOGTKO mice. We identified altered islet proteome between βOGTKO and iβOGTKO mice. Pancreatic and duodenal homeobox 1 (Pdx1) was reduced in in βOGTKO islets. Pdx1 overexpression increased insulin content and improved mitochondrial morphology and function in βOGTKO islets. These data underscore the essential role of OGT in regulating β-cell mitochondrial morphology and bioenergetics. In conclusion, OGT couples nutrient signal and mitochondrial function to promote normal β-cell physiology

The Galaxy platform for accessible, reproducible and collaborative biomedical analyses: 2022 update

Abstract Galaxy is a mature, browser accessible workbench for scientific computing. It enables scientists to share, analyze and visualize their own data, with minimal technical impediments. A thriving global community continues to use, maintain and contribute to the project, with support from multiple national infrastructure providers that enable freely accessible analysis and training services. The Galaxy Training Network supports free, self-directed, virtual training with >230 integrated tutorials. Project engagement metrics have continued to grow over the last 2 years, including source code contributions, publications, software packages wrapped as tools, registered users and their daily analysis jobs, and new independent specialized servers. Key Galaxy technical developments include an improved user interface for launching large-scale analyses with many files, interactive tools for exploratory data analysis, and a complete suite of machine learning tools. Important scientific developments enabled by Galaxy include Vertebrate Genome Project (VGP) assembly workflows and global SARS-CoV-2 collaborations