Question: Trinotate error DBD::SQLite::db do failed: no such table:
0
gravatar for biologo
2.7 years ago by
biologo40
biologo40 wrote:

hello: Dear all, i am doing the genome annotation now, and we have RNA-seq data, so i did the trinity assembly, and use Trinotate do the annotation, but after i generate several results and need to import into Trinotate.sqlite, i got the error.

that is my code: Trinotate ./Trinotate.sqlite init --gene_trans_map trinity_unigene_clean.fa.gene_trans_map --transcript_fasta trinity_unigene_clean.fa --transdecoder_pep longest_orfs.pep

and the error here: DBD::SQLite::db do failed: no such table: Transcript(1) at dbdimp.c line 271 at /share_bio/disk8/software/Trinotate-3.0.2/util/trinotateSeqLoader/TrinotateSeqLoader.pl line 93.

waiting for your help and thank you so much

rna-seq • 1.7k views
ADD COMMENTlink modified 2.7 years ago by Santiago Montero-Mendieta130 • written 2.7 years ago by biologo40

Did you download (and unpacked) or created ($TRINOTATE_HOME/admin/Build_Trinotate_Boilerplate_SQLite_db.pl Trinotate) a boilerplate db?

ADD REPLYlink modified 2.7 years ago • written 2.7 years ago by h.mon29k

yes, thank you for your suggestion, because at that time i can no create the database through Build_Trinotate_Boilerplate_SQLite_db.pl, so i built it by myself and it still did not work and finally i change the version of perl and it works.

ADD REPLYlink written 2.7 years ago by biologo40
1
gravatar for Santiago Montero-Mendieta
2.7 years ago by
Sweden

The TRINOTATE software provides a boilerplate SQLite database that comes pre-populated with a lot of generic data about SwissProt records and Pfam domains. Please make sure that you downloaded the TRINOTATE pre-generated SQLite database and decompress it:

wget https://data.broadinstitute.org/Trinity/Trinotate_v3_RESOURCES/Trinotate_v3.sqlite.gz -O Trinotate.sqlite.gz
gunzip Trinotate.sqlite.gz
ADD COMMENTlink written 2.7 years ago by Santiago Montero-Mendieta130

yes, i find it for a long time, and thank you for your link

ADD REPLYlink written 2.7 years ago by biologo40

The command shows the resource doesn't exist now. From where I can download the Trinotate.sqlite.gz??

ADD REPLYlink written 22 months ago by Pranavathiyani G290
1

You are asking a question, as a comment, on a 10-month old post - you should not, you should open a new post.

Even better: read my comment above, or Trinotate page, and create a new boilerplate database:

$TRINOTATE_HOME/admin/Build_Trinotate_Boilerplate_SQLite_db.pl Trinotate
ADD REPLYlink written 22 months ago by h.mon29k
Please log in to add an answer.

Help
Access

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