This repository has been marked as deprecated, so some tool shed features may be restricted.
Repository revision
repository tip
Select a revision to inspect and download versions of Galaxy utilities from this repository.

Repository query_tabular
Owner: jjohnson
Synopsis: Loads tabular files into a SQLite DB to perform a SQL query producing a tabular output
Deprecated.  The new version is maintained by iuc: https://toolshed.g2.bx.psu.edu/view/iuc/query_tabular/3708ff0198b7

Provides tools for manipulation of tablular files.  

A variety of line filters may be applied to each line of a tabular file as it is read.  
These filters can be used to select lines, select and reorder columns, 
and normalize tabular files for use in a relational database.

Regex regular expression functions re.match, re.search, and re.sub as defined in 
SQLite databse connections, so that re.match, re.search, and re.sub can be used in SQL queries.

The Query Tabular Loads tabular files into a new or existing SQLite DB to perform a SQL query 
producing a tabular output.   It includes the line filtering options.
The SQLite DB may optionally be saved as an additional output.

The SQLite to Tabular tool performs a query on an existing SQLite DB.

The Filter Tabular tool only uses the filtering options to produce a filtered tabaular output.

http://www.sqlite.org/index.html
https://docs.python.org/release/2.7/library/re.html
Type: unrestricted
Revision: 23:5bb148ee644a
This revision can be installed: True
Times cloned / installed: 672

Contents of this repository

Name Description Version Minimum Galaxy Version
5.0.0 any
for SQL query 5.0.0 any
using sqlite sql 5.0.0 any

Categories
Text Manipulation - Tools for manipulating data