This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Query Genbank Using A Mysql Interface

Hi - how can I query genbank using a mysql type interface, so that I can bring back sequences of interest based on a sub-string of the Definition field? or what is the least painful way to download all proteins in genbank and put them into a mysql file? even just download the flat file database and I can work out the rest from there.

thanks

mysql genbank
• 5,108 views • link
updated by Pierre Lindenbaum Pierre Lindenbaum • written by arronslacey arronslacey

1 answer

As far as I remember, NCBI uses Sybase(?) ( http://www.ncbi.nlm.nih.gov/books/NBK21081/ outdated ? ) : you cannot query it using a mysql client

. Retrieval of full documents comes from a variety of “back-end” databases, depending on the node. These might be Sybase or Microsoft SQL Server relational databases of a variety of schemas or text files of various formats. Links are supported using the Sybase IQ database product.

You should use the E-Utilities: http://www.ncbi.nlm.nih.gov/books/NBK25500/

or what is the least painful way to download all proteins in genbank and put them into a mysql file

ftp://ftp.ncbi.nih.gov/genbank/

• 255 views • link
written by Pierre Lindenbaum Pierre Lindenbaum

thanks pierre this is great.

• 0 views • link
written by arronslacey arronslacey

NCBI is Microsoft SQL Server.

• 352 views • link
written by wdiwdi wdiwdi

Log in to answer this question.

More posts like this