Simple alias to search in UCSC

genome_simple.sh

#!/bin/bash

# Include in your ~/.bash_aliases
function search_genome(){
    mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A hg38 --execute="select kg.chrom, kg.strand, kg.txStart, kg.txEnd, kg.exonCount, kg.proteinID, kgp.seq from knownGene as kg inner join knownGenePep as kgp on kg.name=kgp.name where chrom=\"$1\" and txStart>=$2 limit $3;"
}

alias genomeSearch=search_genome

# How to run
# genomeSearch <Chromosome> <Position start> <result limit>
# genomeSearch chr21 5079293 3