Tools

Git

• Commit all modification and added files: git commit -am "informative message"
• To show all the history of a file: git log -p -- file
• To retrieve a specific version of a file: git show COMMIT:file
• Revert repo to a specific commit: git checkout COMMIT
• Undo a commit: git reset HEAD~ and then for the real commit git commit -c ORIG_HEAD.
• Add all untracked files: git st -s | grep '??' | cut -f2 -d ' ' | xargs git add
• Unstage a file (without reverting its potential changes): git restore --staged FILE
• Unstage all files git reset
• Add remote e.g. after a fork: git remote add mine git@github.com:jmonlong/REPO.git
• Activate credential saving (avoid retyping username/passwords, e.g. when SSH keys don’t work): git config credential.helper store

git config --global alias.co checkout
git config --global alias.ci commit
git config --global alias.st status
git config --global alias.br branch
git config --global user.email '<EMAIL>'
git config --global user.name 'Jean Monlong'

git tag -a tagname -m "message"

git push --tags

## in the submodule
git fetch
git checkout <COMMIT>
## in the main repo
git add .
git commit -m "updated the submodule"
git push

WD=`pwd`
for ff in `find . -maxdepth 5 -name .git`
do
    GDIR=`dirname $ff`
    echo $GDIR
    cd $WD/$GDIR
    git st -s
    git st | grep ahead
done
cd $WD

Snakemake

• Documentation

A few trick I’d like to remember or try soon:

• Double “{{”/“}}” to escape { } in expand or NOT to define wildcards.
• Define regexp constraints on wildcards as {data,\d+} or using wildcard_constraints (within a rule or globally).
• Passing a Python/R script: directly.
• Output file marked as temp() are deleted when not needed by any rules anymore.
• Output file marked as touch() for flag files.
• Local rules when running on a HPC.
• Use remote (S3) files with remote()

Configuration files used as config["samples"]. Can also be used as snakemake --config yourparam=1.5. For sample metadata, a tabular configuration can also be used using Pandas. It’s also possible to define a separate config file for the cluster configuration (e.g. resources for each rule).

To use more flexible inputs, use a function and unpack:

def input_func(wildcards):
    return {'file1': '{wildcards.val}.txt'.format(wildcards=wildcards)}
rule myrule:
    input:
        unpack(input_func)
    output:
        "output.{val}.txt"
    shell: " ... {input.file1} ..."

bcftools

• bcftools man page
• bcftools tutorials

echo SAMPLENAME > temp.txt
bcftools reheader -s temp.txt input.vcf.gz > output.vcf.gz

bcftools annotate -x INFO,^FORMAT/GT input.vcf.gz

bcftools view -c 1 -s SAMPLENAME input.vcf.gz

bcftools +fill-tags input.vcf.gz -Oz -o output.vcf.gz --threads 4 -- -t AN,AC,AF

bcftools view -i "STRLEN(REF)<30 & MAX(STRLEN(ALT))<30" input.vcf

jq

Lesson at programminghistorian.org

• Select elements based on one field’s value: jq 'select(.field==value)'
• Keep only desired fields: jq '{id: .id, title: .title}'
• Write in TSV: jq '.array | @tsv'

vd

vd can read many file formats, including TSV, CSV, JSON. I use it to explore TSV files as a more powerful less. It’s great to format wide columns but also to quickly explore summary stats of the table.

Keybindings:

• Ctr-H or z? triggers the help page
• _ expand/contract column.
• z_ <N> set current column width to N.
• / regex search in current column
• g/ regex search in all columns
• n/N move to next/previous match
• [/] sort ascending/descending by current column
• Select rows and filter:
  • | select by regexp in current column
  • , select rows matching current cell in current column
  • z| select by Python expression
  • z" copy selected rows to new sheet
• F toggle a frequency table/histogram of the current column.
  • Enter to focus on a subset defined by a row in frequency table.
  • Enable binning of the values (and decide the bin size) in the Options sheet (O)
• I toggle Describe sheet with summary statistics for each column.
• . toggle dot plot.
  • Make sure to set a column as numeric with #.
  • Eventually select x-axis or labels with ! first.

To keep the same color palette/theme as my terminal, I set the theme to asciimono in my ~/.visidatarc (see manual):

options.theme = "asciimono"

rsync

rsync is not completely intuitive to me. Here are some of the commands I could make work.

To recurrently sync all the files that match the patterns in rsyncIncludes.txt:

rsync -r --include='*/' --include-from=rsyncIncludes.txt --exclude='*' --prune-empty-dirs SRC DEST

To recurrently sync all the files that match the patterns in rsyncIncludes.txt EXCEPT some with a specific pattern. Practical example: all the R scripts but not the ones created by BatchJobs in *-files directories:

rsync -r --exclude="*-files" --include='*/' --include='*.R' --exclude='*' --prune-empty-dirs SRC DEST

Docker

docker build -t jmonlong/popsv-docker .

RUN apt-get -y update && DEBIAN_FRONTEND=noninteractive apt-get -y install tzdata
ENV TZ=America/Los_Angeles

docker run -t -i -v /home/ubuntu/analysis1:/root/analysis1 jmonlong/popsv-docker

docker-machine stop
VBoxManage modifyvm default --cpus 3
VBoxManage modifyvm default --memory 8192
docker-machine start

docker rm -vf $(docker ps -a -q)
docker rmi -f $(docker images -a -q)

docker system prune -a

WDL

A few useful commands/trick/remainders for WDL (see full specs).

• size(file_name, 'G') to get the size in Gb (e.g. for dynamic disk space allocation). Used with ceil/round to get a round number.
• and=&&, or=||
• ~{true="yes" false="no" boolean_value} to inject different strings in the command section, depending on the value of a Boolean.
• ~{sep="," array_value} to “join” an array into a string.
• Int value = if othervalue < 5 then 1 else 4
• glob("*.bam") to cath output files for example.
• String out_prefix = basename(in_gam_file, ".gam") to get the basename of a file and strip a suffix too.
• String out_prefix = sub(sub(sub(basename(in_gam_file), "\\.gz$", ""), "\\.gaf$", ""), "\\.gam$", "") another way for when the extension is variable.
• File sel_file = select_first([OPTIONAL_INPUT_FILE, task.output_file]) to select the first defined arg in an array (e.g. when a task can recreate an optional input).
• flatten([array1, [new_element]]) to add new_element to an existing array1.
• Array[Pair[File,File]] paired_files_list = zip(file_list_1, file_list_2), e.g. to scatter across two lists. In the scatter, access with .left/.right.
• Start command section with set -eux -o pipefail to stop the job at the first error, even in a pipe.
• Simple workflow with typical structure

If an input is a (long) array, use it through a file with one element per line (see in WDL Spec):

input {
    Array[File] in_vcf_list
}
command <<<
while read invcf
do
    command $invcf
done < ~{write_lines(in_vcf_list)}
## or
command -f ~{write_lines(in_vcf_list)}
>>>

Makefile

• GNU make manual

• Makefile basics from Isaacs.

• Automatic variables

  • $@ the target
  • $< the first prerequisite
  • $^ all prerequisites
  • $(@D) the directory part of $@ (works the same with <,^, etc).
  • $(@F) the filename part of $@ (works the same with <,^, etc).

• File name functions

  • $(notdir src/foo.c) returns foo.c.
  • $(addsuffix .c,foo) returns foo.c.
  • $(basename dir/foo.test.c) returns dir/foo.test.
  • objects := $(wildcard *.o) to list files in a variable.

• String functions

  • $(patsubst %.c,%.o,file.c) to substitute file extensions
  • $(subst from,to,text) replaces all occurrences of from to to in text.
  • $(word n,text) returns the n-th word in text.

• Shell function: $(shell cat foo) runs a shell command.

FTP

Basic commands:

• cd/ls to change directory/list files in the remote location
• get to copy a file from the remote location to the local machine
• put to copy a file from the local machine to the remote location
• delete to remove a file in the remote location
• lcd to change directory in the local machine
• help to list FTP commands

Thunderbird

• Force a better date format: Settings, General, Config Editor (at the bottom), Set intl.date_time.pattern_override.date_short to a string yyyy-MM-dd.
• Langtool extension for spell checking.
• Shorcuts
  • Archive message: A
  • New message: Ctrl+N
  • Add attachment: Ctrl+Shift+A
  • Send message: Ctrl+Enter
  • Reply: Ctrl+R or Ctrl+Shift+R
  • Forward: Ctrl+L
  • Expand/collapse threads: Left/Right
  • Search all message: Ctrl+K
  • Advanced search: Ctrl+Shift+F
  • Go to previous/next message: B/F

For file conversion

ffmpeg -i in.m4a -acodec mp3 -ac 2 -ab 192k out.mp3

ffmpeg -y -i large.mkv -vf "scale=-1:720" -c:v libx264 -crf 23 smaller.mkv

inkscape document.pdf --export-eps=document.eps

pdftops -eps document.pdf

gs -dPDFA=1 -dBATCH -dNOPAUSE -dEmbedAllFonts=true -dSubsetFonts=false -dHaveTrueTypes=true -dPDFSETTINGS=/prepress -sProcessColorModel=DeviceRGB -sDEVICE=pdfwrite -sPDFACompatibilityPolicy=1 -sOutputFile=mainPDFA.pdf main.pdf

pdftops main.pdf main.ps
gs -dPDFA -dBATCH -dNOPAUSE -dNOOUTERSAVE -dUseCIEColor -sProcessColorModel=DeviceCMYK -sDEVICE=pdfwrite -sPDFACompatibilityPolicy=1 -sOutputFile=mainPDFA.pdf main.ps

pdftk original.pdf output uncompressed.pdf uncompress 
sed -e "s/watermarktextstring/ /" uncompressed.pdf > unwatermarked.pdf
pdftk unwatermarked.pdf output fixed.pdf compress

sed -e "s/33.94110107 33.94110107 -33.94110107 33.94110107 5.8685999 122.48609924 Tm/0 0 0 0 0 0 Tm/g" < uncompress.pdf > unwatermarked.pdf

...
BT
0 0 0 rg
/GS2 gs
/C2_1 1 Tf
0 Tc
0 Tw
33.94110107 33.94110107 -33.94110107 33.94110107 5.8685999 122.48609924 Tm
(^@$)Tj
.695 0 Td
(^@&)Tj
.722 0 Td
(^@&)Tj
.695 0 Td
(^@\()Tj
.61199998 0 Td
(^@/)Tj
.61199998 0 Td
(^@\()Tj
.695 0 Td
(^@5)Tj
.695 0 Td
(^@$)Tj
.639 0 Td
(^@7)Tj
.639 0 Td
(^@\()Tj
.695 0 Td
(^@')Tj
.361 -.85799998 Td
(^@^C)Tj
...