using mysql on ucsc table browser
0
0
Entering edit mode
7.8 years ago
bioguy24 ▴ 230

Is there a way to query the usuc mysql database using a file and return the fasta sequence of each line in the file and get the same output as in the table browser? This is DNA, CDS exons, one fasta record per region with 10 bases 5' and 3', exons in upper case, everything else in lower case. Thank you :).

file

A2M

output

>hg19_refGene_NM_000014_0 range=chr12:9268350-9268455 5'pad=10 3'pad=10 strand=- repeatMasking=none
  tttctgcaacATGGGGAAGAACAAACTCCTTCATCCAAGTCTGGTTCTTC
  TCCTCTTGGTCCTCCTGCCCACAGACGCCTCAGTCTCTGGAAAACCgtga
  gttcca
>hg19_refGene_NM_000014_1 range=chr12:9265946-9266149 5'pad=10 3'pad=10 strand=- repeatMasking=none
tcattcccagGCAGTATATGGTTCTGGTCCCCTCCCTGCTCCACACTGAG
ACCACTGAGAAGGGCTGTGTCCTTCTGAGCTACCTGAATGAGACAGTGAC
TGTAAGTGCTTCCTTGGAGTCTGTCAGGGGAAACAGGAGCCTCTTCACTG
ACCTGGAGGCGGAGAATGACGTACTCCACTGTGTCGCCTTCGCTgtgagt
gtgg

Maybe:

mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -D hg37 -e 'select /home/user/file()'
ngs • 1.6k views
ADD COMMENT
0
Entering edit mode

using mysql only ? no

ADD REPLY
0
Entering edit mode

What do you suggest? Thanks.

ADD REPLY

Login before adding your answer.

Traffic: 2440 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6