Skip to content

Instantly share code, notes, and snippets.

@drdrsh
drdrsh / index.html
Last active February 25, 2019 16:41
Mapbox selective cluster icon
<!DOCTYPE html>
<html>
<head>
<meta charset='utf-8' />
<title>Create and style clusters</title>
<meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
<script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.53.0/mapbox-gl.js'></script>
<link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.53.0/mapbox-gl.css' rel='stylesheet' />
<style>
body { margin:0; padding:0; }
'use strict';
const Promise = require("bluebird");
const records = [{
'title': null,
'lat' : 9.1111,
'lng' : 5.1111,
'desc' : 'A record missing a title'
},{
'title': "Not missing data",
async function getUserInput(missing_record) {
const puppeteer = require('puppeteer');
return new Promise(async (resolve, reject) => {
//This message we will show the user
const prompt_msg = `Missing data: ${missing_record.desc}, please input value \n`;
//Construct a URL using longitude and latitude values from the record
'use strict';
const Promise = require("bluebird");
const readline = require('readline');
const rl = readline.createInterface(process.stdin, process.stdout, null);
//Some dummy data
const records = [{
'title': null,
'lat' : 9.1111,
@drdrsh
drdrsh / CppToOpenGL.cpp
Last active June 26, 2017 16:11
A templated function to convert C++ types to OpenGL types
template <typename T> GLenum typeToGL() {
if (typeid(T) == typeid(float)) {
return GL_FLOAT;
};
if (typeid(T) == typeid(double)) {
return GL_DOUBLE;
};
@drdrsh
drdrsh / Ensambl_5utr_3utr_query.sql
Created December 8, 2015 02:51
A Query to Ensambl Database the returns the 5utr and 3utr lengths given a transcript_id
SELECT
1 + tr.seq_start + IFNULL((SELECT SUM(ABS(ex_1.seq_region_end - ex_1.seq_region_start)) FROM exon ex_1 WHERE ex_1.exon_id IN (SELECT et_1.exon_id FROM exon_transcript et_1 WHERE et_1.rank < et_start.rank AND et_1.transcript_id=tr.transcript_id)), 0) as utr5_length,
((SELECT ex_3.seq_region_end - ex_3.seq_region_start FROM exon ex_3 WHERE ex_3.exon_id = tr.end_exon_id) - tr.seq_end - 1) + IFNULL((SELECT SUM(ABS(ex_2.seq_region_end - ex_2.seq_region_start)) FROM exon ex_2 WHERE ex_2.exon_id IN (SELECT et_2.exon_id FROM exon_transcript et_2 WHERE et_2.rank > et_end.rank AND et_2.transcript_id=tr.transcript_id)), 0) as utr3_length
FROM
homo_sapiens_core_82_38.translation tr
LEFT JOIN
homo_sapiens_core_82_38.exon_transcript et_start
ON
et_start.exon_id = tr.start_exon_id
LEFT JOIN