Evidence map›Paper›PMID 30519459›Full record

ArticleF1000Research2018

Improve your Galaxy text life: The Query Tabular Tool.

James E Johnson, Praveen Kumar, Caleb Easterly, Mark Esler, Subina Mehta, Arthur C Eschenlauer, Adrian D Hegeman, Pratik D Jagtap, Timothy J Griffin

Abstract read
In one paragraph

Article in F1000Research, 2018. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 7 papers.

0numbers the graph read from it
0cells of the map it votes in
7citing papers in PubMed
–field-weighted citation impact
1 · What the graph read from it

What it found

Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.

The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.

2 · The registry

The trial behind it

Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.

Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.

3 · Its place in the literature

Who cites it

7 citing papers in PubMed.

  1. Article
  2. Article
  3. Article
  4. Article
  5. Article
  6. Article
  7. Pathogenomes of Atypical Non-shigatoxigenicFrontiers in microbiology · 2020
    Article
4 · The record

Corrections and comments

PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.

5 · Who and what money

Authors and funding

9 authors.

James E JohnsonMinnesota Supercomputing Institute, University of Minnesota, Minneapolis, MN, 55455, USA.
Praveen KumarDepartment of Biochemistry, Molecular Biology and Biophysics, University of Minnesota, Minneapolis, Minnesota, 55455, USA.
Caleb EasterlyDepartment of Biochemistry, Molecular Biology and Biophysics, University of Minnesota, Minneapolis, Minnesota, 55455, USA.ORCID 0000-0001-7853-377X
Mark EslerDepartment of Horticulture, University of Minnesota, St. Paul, MN, 55108, USA.
Subina MehtaDepartment of Biochemistry, Molecular Biology and Biophysics, University of Minnesota, Minneapolis, Minnesota, 55455, USA.
Arthur C EschenlauerDepartment of Biochemistry, Molecular Biology and Biophysics, University of Minnesota, Minneapolis, Minnesota, 55455, USA.ORCID 0000-0002-2882-0508
Adrian D HegemanDepartment of Horticulture, University of Minnesota, St. Paul, MN, 55108, USA.ORCID 0000-0003-1008-6066
Pratik D JagtapDepartment of Biochemistry, Molecular Biology and Biophysics, University of Minnesota, Minneapolis, Minnesota, 55455, USA.ORCID 0000-0003-0984-0973
Timothy J GriffinDepartment of Biochemistry, Molecular Biology and Biophysics, University of Minnesota, Minneapolis, Minnesota, 55455, USA.ORCID 0000-0001-6801-2559

Funding

Expanding multiplexed kinase biosensor analysis to SWATH-MS (Part 2 of 2)U24CA199347 · NCI · UNIVERSITY OF MINNESOTA · PI GRIFFIN, TIMOTHY J. · 2016 to 2019
$2.4M
NCI NIH HHS U24 CA199347
6 · The paper itself

Abstract

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.

Indexed as

GalaxyGenomicsMetabolomicsMetaproteomicsMulti-omicsProteogenomicsProteomicsSQLiteWorkflows

Identifiers

PMID30519459
PMCPMC6248266

What OpenQuestion holds

Textmetadata
LicenceCC BY
Read underepoch 390

Registered trials

None linked

Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.