cre.gemini_variant_impacts.sh

#!/bin/bash
#   exports variant_impacts from gemini.db database to gemini.db.variant_impacts.txt file
#   database schema: https://gemini.readthedocs.io/en/latest/content/database_schema.html#the-variants-table
#   by default bcbio writes PASS only variants to the database

#PBS -l walltime=1:00:00,nodes=1:ppn=1
#PBS -joe .
#PBS -d .
#PBS -l vmem=10g,mem=10g

if [ -z $file ]
then
    file=$1
fi

depth_threshold=$2

severity_threshold=$3

if [[ "$severity_threshold" == 'ALL' ]]
then
#used for RNA-seq = 20k variants in the report
    severity_filter=""
#use for WES = 1k variants in the report
else
    severity_filter="v.impact_severity<>'LOW' and "
fi
        

sQuery="select 
	i.variant_id,
	i.gene,
	i.transcript,
	i.is_exonic,
	i.is_coding,
	i.is_lof,
	i.exon,
	i.codon_change,
	i.aa_change,
	i.aa_length,
	i.biotype,
	i.impact,
	i.impact_so,
	i.impact_severity,
	i.polyphen_pred,
	i.polyphen_score,
	i.sift_pred,
	i.sift_score,
	i.vep_canonical,
	i.vep_ccds,
	i.vep_hgvsc,
	i.vep_hgvsp"

#old runs before Oct2017 does not have maxentscanfields in the database
if gemini db_info $1 | grep -q "maxentscan";
then 
    sQuery=$sQuery",
	i.vep_maxentscan_alt,
	i.vep_maxentscan_diff,
	i.vep_maxentscan_ref,
	i.vep_spliceregion
	"
fi

sQuery=$sQuery" from variants v, 
		variant_impacts i 
		where "$severity_filter"v.max_aaf_all <= "$max_af" and 
		v.variant_id=i.variant_id and 
		(v.depth>="$depth_threshold" or v.depth='' or v.depth is null)"

echo $sQuery

gemini query --header -q "$sQuery" $file > ${file}.impacts.txt