Skip to content

Instantly share code, notes, and snippets.

View c0mpiler's full-sized avatar
🥷

Harsha Krishnareddy c0mpiler

🥷
6 followers · 29 following
View GitHub Profile
@c0mpiler
c0mpiler / blast_response.json
Created September 26, 2018 01:12
Blast Search service response
{
"results": [
{
"alignments": [
{
"hsps": [
{
"align_length": 68,
"bits": 135.293,
"expect": 9.08954e-31,
@c0mpiler
c0mpiler / install_python37.sh
Last active September 30, 2018 04:14
Setup python 3.7 on Ubuntu
#! /usr/bin/env bash
# Requirements
sudo apt-get install -y build-essential checkinstall libreadline-gplv2-dev libncursesw5-dev libssl-dev libsqlite3-dev tk-dev libgdbm-dev libc6-dev libbz2-dev zlib1g-dev openssl libffi-dev python3-dev python3-setuptools wget
# Prepare to build
mkdir /tmp/Python37
cd /tmp/Python37
# Pull down Python 3.7, build, and install
@c0mpiler
c0mpiler / ES_partial_search_by_non_existant_genome_id.json
Created October 23, 2018 01:11
ES_partial_search_by_non_existant_genome_id.json
{
"took": 134,
"timed_out": false,
"_shards": {
"total": 60,
"successful": 60,
"skipped": 0,
"failed": 0
},
"hits": {
@c0mpiler
c0mpiler / copy_sheets.vba
Last active November 16, 2018 08:05
excel macro test
Sub Combine()
Dim J As Integer
Dim s As Worksheet
On Error Resume Next
Sheets(1).Select
Worksheets.Add
dt = Format(CStr(Now), "yyy_mm_dd_hh_mm")
nam = "Combined_"
new_sheet_name = nam & dt
@c0mpiler
c0mpiler / mark_dups.vba
Created November 29, 2018 09:03
assign the same serial no, for duplicate transaction rows
Sub MarkDuplicates()
' Activate the Master Sheet
Sheets("master").Activate
' Count the number of non-empty rows in the master sheet
RowCount = Worksheets("master").Cells(Rows.Count, 1).End(xlUp).Row
ColCount = Worksheets("master").Cells(1, Columns.Count).End(xlToLeft).Column
dealAmtCol = 3
firstRow = 1
@c0mpiler
c0mpiler / test_data.csv
Created November 29, 2018 09:25
test data csv
1 IBM 36222
1 softlayer 36222
1 RedHat 36222
2 Google 989151
2 Oracle 632
3 Facebook 987092
3 Twitter 987092
1 Tesla 34333
1 Acer 9789332
2 Deloitte 467
@c0mpiler
c0mpiler / resorty_numpy_2_cluster_sort_order.py
Created January 10, 2019 21:36
Resort alpha-sorted numpy matrix to cluster-sort order
#!/usr/bin/env python
import numpy as np
import time
from datetime import timedelta
def cluster_sort(genus1, genus2):
start_time = time.monotonic()
@c0mpiler
c0mpiler / omxware_spore_genes.json
Created March 12, 2019 22:20
OMXWare Genes with `spore` in the name
{
"took" : 2074,
"hits" : {
"total" : 52979,
},
"aggregations" : {
"names" : {
"buckets" : [
{
"key" : "Spore germination protein YndE",
@c0mpiler
c0mpiler / SRR1057376.json
Last active April 10, 2019 17:06
search for SRR1057376 on dev cluster
{
"took" : 2795,
"timed_out" : false,
"_shards" : {
"total" : 60,
"successful" : 60,
"skipped" : 0,
"failed" : 0
},
"hits" : {
@c0mpiler
c0mpiler / omxware_gene_2943ed16fb0889ef5e372113d97f56d0.json
Created April 16, 2019 18:11
omxware_gene_2943ed16fb0889ef5e372113d97f56d0.json
{
"@timestamp": "2019-04-16T06:21:07.417Z",
"@version": "1",
"omxid": "2943ed16fb0889ef5e372113d97f56d0",
"name": [
"Elongation factor Tu 1"
],
"type": "gene",
"sequence": "ATGTCTAAAGAAAAGTTTGAACGTACAAAACCGCACGTTAACGTCGGTACTATCGGCCACGTTGACCATGGTAAAACAACGCTGACCGCTGCCATCACTACCGTACTGGCTAAAACCTACGGTGGTTCCGCTCGCGCATTCGACCAGATCGATAACGCGCCGGAAGAAAAAGCTCGTGGTATCACCATCAACACCTCTCACGTTGAATATGACACCCCGACTCGCCACTACGCGCACGTAGACTGCCCGGGCCACGCCGACTATGTTAAAAACATGATCACCGGTGCTGCGCAGATGGACGGCGCGATCCTGGTTGTTGCTGCGACTGACGGCCCGATGCCGCAGACTCGTGAGCACATCCTGCTGGGTCGTCAGGTAGGCGTTCCGTACATCATCGTGTTCCTGAACAAATGCGACATGGTTGATGACGAAGAGCTGCTGGAACTGGTTGAGATGGAAGTTCGTGAACTGCTGTCTCAGTACGATTTCCCGGGCGACGACACTCCGATCGTTCGTGGTTCTGCTCTGAAAGCGCTGGAAGGCGACGCAGAGTGGGAAGCGAAAATCATCGAACTGGCTGGCCACCTGGATACCTATATCCCGGAACCAGAGCGTGCGATTGACAAGCCGTTCCTGCTGCCGATCGAAGACGTATTCTCCATCTCCGGTCGTGGTACCGTTGTTACCGGTCGTGTAGAGCGCGGTATCATCAAAGTAGGTGAAGAAGTTGAAATCGTTGGTATCAAAGAAACCGCGAAAACCACCTGTACTGGCGTTGAAATGTTCCGCAAACTGCTGGACGAAGGCCGTGCTGGTG