Skip to content

Instantly share code, notes, and snippets.

@craigmccauley
Created October 17, 2020 13:53
Show Gist options
  • Save craigmccauley/4682a1cb0cb0e4cb2c4a58ecd40e4d0f to your computer and use it in GitHub Desktop.
Save craigmccauley/4682a1cb0cb0e4cb2c4a58ecd40e4d0f to your computer and use it in GitHub Desktop.
Batch file for querying the MISTIC dataset
@echo off
set /p chrom="Enter chromosome: "
set /p pos="Enter position: "
echo.
echo Searching for
echo Chromosome: %chrom% Position: %pos%
"C:\Program Files (x86)\Log Parser 2.2\LogParser.exe" -i:TSV -nSkipLines:1 -e:1 -dtlines:0 "SELECT #CHROM, POS, REF, ALT, MISTIC_score, MISTIC_pred FROM './MISTIC_GRCh37.tsv' WHERE #CHROM = '%chrom%' AND POS = '%pos%'"
pause
@craigmccauley
Copy link
Author

Queries the MISTIC dataset http://www.lbgi.fr/mistic/download
Requires LogParser 2.2 to be installed. https://www.microsoft.com/download/details.aspx?id=24659

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment