Download Arq for Windows;. Buy Now $49.99 per user. for personal computers; per-server license for servers. System Requirements. Mac: OS X 10.7 or later Windows: Windows 7 or later or Windows Server 2012R2 or later, with.NET 4.5.1 or later. Release Notes. Arq for Mac Release Notes.
![](/uploads/1/2/6/5/126574450/576324334.jpg)
![Arq 4.5.5 Download Arq 4.5.5 Download](/uploads/1/2/6/5/126574450/467278450.jpg)
Project: | filo |
---|---|
Version: | 1.1.0 |
Authors: | Aaron Quinlan, University of Virginia Assaf Gordon, Cold Spring Harbor Laboratories |
Contact: | [email protected] |
The following tools are available as part of the filo package. More to come...
Contents
- filo - Useful FILe and stream Operations
groupBy is a useful tool that mimics the 'groupBy' clause in database systems. Given a file or stream that is sorted by the appropriate 'grouping columns', groupBy will compute summary statistics on another column in the file or stream. This will work with output from all BEDTools as well as any other tab-delimited file or stream.
![Arq 4.5.5 download free Arq 4.5.5 download free](/uploads/1/2/6/5/126574450/285306193.jpg)
You specify a list of columns that should be 'grouped' with the -g parameter (e.g., -g 2,3,4 will group on the second through fourth columns). You then specify column(s) that should be summarized or 'operated upon' for each group with the -c parameter (e.g., -c 2 or -c 2,3 or -c 2,2,2,5). Finally, you specify what operations should be applied to the list of columns in -c.
Here is the current list of the available operations.
- sum - numeric only
- count - numeric or text
- min - numeric only
- max - numeric only
- mean - numeric only
- stdev - numeric only
- median - numeric only
- mode - numeric or text
- antimode - numeric or text collapse (i.e., print a comma separated list) - numeric or text
- freqasc - print a comma separated list of values observed and the number of times they were observed. Reported in ascending order of frequency.
- freqdesc - print a comma separated list of values observed and the number of times they were observed. Reported in descending order of frequency.
- collapse - print a comma separated list of each value in the grouped column.
- concat - concattenate each value in the grouped column into a single string.
And here are some usage examples. I hope you find this utility to be of use in your work. I have found it to be a huge time saver.
shuffle will randomize the order of lines in a file. In other words, if you have a sorted file, shuffle will undo the sort.
stats is a small utility for computing descriptive statistic on a given column of a tab-delimited file or stream. By default, it will assume you want to gather stats on the first column in your file/stream and compute all of the following statistics:
- total number of lines
- the sum of all the values in the column
- the arithmetic mean (i.e., the 'average') of the values in the column
- the geometric mean (if possible)
- the median
- the mode
- the anti-mode (i.e., the least frequent value)
- the minimum
- the maximum
- the variance
- the standard deviation.
Here are some examples of stats in action.
![](/uploads/1/2/6/5/126574450/576324334.jpg)