Skip to content

Instantly share code, notes, and snippets.

@natefoo
Last active August 29, 2015 14:08
Show Gist options
  • Save natefoo/ac47dc0f8bc1291fe331 to your computer and use it in GitHub Desktop.
Save natefoo/ac47dc0f8bc1291fe331 to your computer and use it in GitHub Desktop.
over mem jobs
% sacct -u g2main -L -s CA -S 2014-10-01 -E now -o 'jobname%-128' -X -n | cut -d_ -f1 | tr -d '^g' | (echo -n "select tool_id,count(tool_id) ct from job where id in("; while read jobid; do [[ $jobid =~ ^-?[0-9]+$ ]] && echo -n "$c$jobid"; c=','; done; echo ") and state='error' group by tool_id order by ct") | psql galaxy_main
tool_id | ct
---------------------------------------------------------------------------------------------------+----
toolshed.g2.bx.psu.edu/repos/devteam/fastq_to_tabular/fastq_to_tabular/1.1.0 | 1
toolshed.g2.bx.psu.edu/repos/devteam/intersect/gops_intersect_1/1.0.0 | 1
toolshed.g2.bx.psu.edu/repos/devteam/flanking_features/flanking_features_1/4.0.1 | 1
Extract genomic DNA 1 | 1
gff2bed1 | 1
toolshed.g2.bx.psu.edu/repos/devteam/get_flanks/get_flanks1/1.0.0 | 1
toolshed.g2.bx.psu.edu/repos/devteam/emboss_5/EMBOSS: cpgreport16/5.0.0 | 1
toolshed.g2.bx.psu.edu/repos/devteam/picard/rgPicardMarkDups/1.56.0 | 1
echo_main_w1_handler2 | 1
toolshed.g2.bx.psu.edu/repos/devteam/subtract_query/subtract_query1/0.1 | 1
toolshed.g2.bx.psu.edu/repos/devteam/megablast_wrapper/megablast_wrapper/1.2.0 | 1
toolshed.g2.bx.psu.edu/repos/devteam/picard/picard_ARRG/1.56.0 | 1
liftOver1 | 1
Paste1 | 1
toolshed.g2.bx.psu.edu/repos/devteam/sam_pileup/sam_pileup/1.1.2 | 1
ucsc_table_direct1 | 1
cat1 | 1
toolshed.g2.bx.psu.edu/repos/devteam/table_recalibration/gatk_table_recalibration/0.0.5 | 2
toolshed.g2.bx.psu.edu/repos/devteam/cuffdiff/cuffdiff/0.0.7 | 2
toolshed.g2.bx.psu.edu/repos/devteam/count_covariates/gatk_count_covariates/0.0.5 | 2
ebi_sra_main | 2
Filter1 | 2
toolshed.g2.bx.psu.edu/repos/devteam/fastx_collapser/cshl_fastx_collapser/1.0.0 | 2
toolshed.g2.bx.psu.edu/repos/devteam/fastq_groomer/fastq_groomer/1.0.4 | 2
toolshed.g2.bx.psu.edu/repos/devteam/varscan_version_2/varscan/0.1 | 2
toolshed.g2.bx.psu.edu/repos/devteam/clustalw/clustalw/0.1 | 2
CONVERTER_gff_to_interval_index_0 | 3
toolshed.g2.bx.psu.edu/repos/devteam/emboss_5/EMBOSS: needle56/5.0.0 | 3
toolshed.g2.bx.psu.edu/repos/devteam/variant_recalibrator/gatk_variant_recalibrator/0.0.4 | 3
toolshed.g2.bx.psu.edu/repos/devteam/t2ps/Draw_phylogram/1.0.0 | 3
toolshed.g2.bx.psu.edu/repos/devteam/lastz/lastz_wrapper_2/1.2.2 | 3
CONVERTER_gff_to_fli_0 | 3
toolshed.g2.bx.psu.edu/repos/devteam/emboss_5/EMBOSS: water107/5.0.0 | 4
toolshed.g2.bx.psu.edu/repos/devteam/depth_of_coverage/gatk_depth_of_coverage/0.0.2 | 4
CONVERTER_bed_to_fli_0 | 4
Interval2Maf1 | 5
upload1 | 5
CONVERTER_bedgraph_to_bigwig | 6
toolshed.g2.bx.psu.edu/repos/devteam/picard/picard_SamToFastq/1.56.1 | 6
toolshed.g2.bx.psu.edu/repos/devteam/indel_realigner/gatk_indel_realigner/0.0.6 | 6
toolshed.g2.bx.psu.edu/repos/devteam/tophat2/tophat2/0.6 | 7
toolshed.g2.bx.psu.edu/repos/devteam/gi2taxonomy/Fetch Taxonomic Ranks/1.1.0 | 7
toolshed.g2.bx.psu.edu/repos/devteam/fastq_paired_end_joiner/fastq_paired_end_joiner/1.0.0 | 8
toolshed.g2.bx.psu.edu/repos/devteam/realigner_target_creator/gatk_realigner_target_creator/0.0.4 | 9
toolshed.g2.bx.psu.edu/repos/aaronquinlan/bedtools/bedtools_coveragebed_counts/0.1.0 | 10
comp1 | 13
join1 | 14
toolshed.g2.bx.psu.edu/repos/devteam/unified_genotyper/gatk_unified_genotyper/0.0.6 | 24
wig_to_bigWig | 46
toolshed.g2.bx.psu.edu/repos/devteam/join/gops_join_1/1.0.0 | 66
(50 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment