Question: creating local database using ncbi ftp files in the clc main worker bench
gravatar for samuelksm
5.1 years ago by
samuelksm0 wrote:

I want to create a local database using the ncbi database ftp files, am using clc main work bench to analyse my sequences (proteins), for some resean it does not connect to the ncbi serve to download the ncbi through the software, so i decided to download them manually from the server, i have tried to create a folder in the ncbi and make a local database but the software does not recognise the files , i think because they are already formated, so how can create a local database use the ftp files from ncbi

ADD COMMENTlink modified 4.8 years ago by bonoack10 • written 5.1 years ago by samuelksm0

Have you considered contacting CLC tech support?

ADD REPLYlink written 5.1 years ago by Sean Davis26k

yes but they are taking too long to get back to me, so i came here thinking , there could be any one who has had the same problem.

ADD REPLYlink written 5.1 years ago by samuelksm0
gravatar for bonoack
4.8 years ago by
United States
bonoack10 wrote:


I use CLC as a primary tool for all my bioinformatic analysis. Ever since KLAST was disabled on CLC, I have been using the BLAST+ tool taht is built in. While CLC has a BLAST database manager that only allows pre-formated databases from the :// FTP site. The databases are vast and extensive, it takes too much time to run. I found custom databases from

To answer your question about custom local databases. Because CLC uses BLAST+ program. I was able to use the BLAST+ STANDALONE to format all my local databases. 

(I am using windows)
First download BLAST+ on your machine from this site (
Documentation (
follow the instruction to add /db/ folder. 

Second format custom local databases
download any database with a .gz file. 
add it to you /db/ directory and run the following commands to create the database.
Essentially converts them from .faa to the appropriate .pin, .nhr, .psi, etc... 

For nucleotide fasta file: makeblastdb -in input_db -dbtype nucl -parse_seqids

For protein fasta file:  makeblastdb -in input_db -dbtype prot -parse_seqids

Once formated, Simply restart CLC and refresh blast database manager and now you should have your local databases. 

CREDIT source:

ADD COMMENTlink written 4.8 years ago by bonoack10

i hope this helps. If you have further questions let me know.

ADD REPLYlink written 4.8 years ago by bonoack10

Thank you this was helpful

ADD REPLYlink written 4.7 years ago by samuelksm0
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1527 users visited in the last hour