# Two Databases are different

**URL:** <https://forum.qiime2.org/t/two-databases-are-different/9531>\
**Category:** User Support\
**Created:** [May 5, 2019, 6:08pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531 "2019-05-05T18:08:59Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![TurboQiimer](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/46a35a/32.png) [@TurboQiimer](https://forum.qiime2.org/u/TurboQiimer)\
**Post date:** [May 5, 2019, 6:09pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/1 "2019-05-05T18:09:00Z")

</div>

a couple of questions I have in regard to the two databases.

I used the pre-trained databases in the tutorial. I have different results in taxa. They demonstrate in phylum what I checked so far. It is common knowledge that SILVA is more reliable owing to its frequently updated version released sooner than Greengenes, but in the phylum level, their outputs should be so close; however, I received diversified results. More interestingly, the Greengenes result looks normal in my case rather than the SILVA's result.  
By the way, what I achieved from SILVA classifier I have a huge number of unclassified taxa while the statistics of Greenegenes showing by far lower. I would like to know its reason!

I tended to train my own classifiers for both databases. In the last version of SILVA, there are some files in taxonomy directory, such as "all levels "and "7-levels". which one of them should appropriately be taken up? and why?

Greengenes does not have different taxonomy files as SILVA has. For example, there are different similarities like 99%, 97% and so forth. On the other hand, I did not see different similarities in Greengene website. I would like also to know how did you find the 85% similarity of Greenegen database.

In the Qiime2 forum, I found a discussion that your colleague suggested that the user apply fasta 99, but I do not see different similarities.  
[https://greengenes.secondgenome.com/?prefix=downloads/greengenes\_database/gg\_13\_5/](https://greengenes.secondgenome.com/?prefix=downloads/greengenes_database/gg_13_5/)

Finally, Greeneges's website launched the new modification of the last version a few days ago. I do not know whether these changes cover the Greenegenes limitations against SILVA or not. What is your opinion? And there is not present the unaligned sequences except gg\_13\_5\_ssualign.fasta.gz.

[https://greengenes.secondgenome.com/?prefix=downloads/greengenes\_database/gg\_13\_5/](https://greengenes.secondgenome.com/?prefix=downloads/greengenes_database/gg_13_5/)

Best regards,  
TurboQiimer

---

<div class="post-metadata">

**Author:** ![Nicholas\_Bokulich](https://forum.qiime2.org/user_avatar/forum.qiime2.org/nicholas_bokulich/32/19937_2.png) [@Nicholas\_Bokulich](https://forum.qiime2.org/u/Nicholas_Bokulich)\
**Post date:** [May 6, 2019, 12:47pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/2 "2019-05-06T12:47:51Z")

</div>

> [@TurboQiimer](#):
>
> More interestingly, the Greengenes result looks normal in my case rather than the SILVA’s result.  
> By the way, what I achieved from SILVA classifier I have a huge number of unclassified taxa while the statistics of Greenegenes showing by far lower. I would like to know its reason!

Are both classifiers trained on the correct region? E.g., did you use the full-length greengenes classifier vs. the V4 SILVA classifier?

> [@TurboQiimer](#):
>
> I tended to train my own classifiers for both databases. In the last version of SILVA, there are some files in taxonomy directory, such as "all levels "and “7-levels”. which one of them should appropriately be taken up? and why?

There is a "notes" file in the SILVA releases that explains this — I recommend checking that document. Short answer: a taxonomy with even numbers of levels allows the use of taxonomic classification methods that rely on confidence or consensus scores to determine the most likely taxonomic lineage. If the levels are uneven, such methods can become confused because the taxonomic lineages for related organisms look very different if they have uneven levels.

> [@TurboQiimer](#):
>
> Greengenes does not have different taxonomy files as SILVA has. For example, there are different similarities like 99%, 97% and so forth

Download the QIIME-compatible releases [here](https://docs.qiime2.org/2019.4/data-resources/#greengenes-16s-rrna). Those contain sequence and taxonomy files clustered at different % similarities.

> [@TurboQiimer](#):
>
> Finally, Greeneges’s website launched the new modification of the last version a few days ago. I do not know whether these changes cover the Greenegenes limitations against SILVA or not. What is your opinion? And there is not present the unaligned sequences except gg\_13\_5\_ssualign.fasta.gz.

You should contact secondgenome to ask about that modification. It seems that is the same 13\_5 release, not a new release.

---

<div class="post-metadata">

**Author:** ![TurboQiimer](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/46a35a/32.png) [@TurboQiimer](https://forum.qiime2.org/u/TurboQiimer)\
**Post date:** [May 7, 2019, 1:17pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/3 "2019-05-07T13:17:29Z")

</div>

> [@Nicholas\_Bokulich](#):
>
> Are both classifiers trained on the correct region?

Step three in training is arbitrary, as i understood. The classifier was not trained to special part of the 16S rRNA gene, so I skipped it.

> [@Nicholas\_Bokulich](#):
>
> the full-length

I am using full length for both databases.

I even tried 97% similarity instead of 99% taxonomy. The newly result is similar to the result I received with 99% one — still I have the unmatched taxonomy barplots. Also, the unassigned taxa are abundant in the barplot I got from the SILVA database. desperately wired!

---

<div class="post-metadata">

**Author:** ![TurboQiimer](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/46a35a/32.png) [@TurboQiimer](https://forum.qiime2.org/u/TurboQiimer)\
**Post date:** [May 7, 2019, 1:19pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/4 "2019-05-07T13:19:47Z")

</div>

I am sharing the barplot.

 ![Screenshot%20from%202019-05-07%2015-07-08](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/f/f5a0e0c436f0ddcd37e5bd8e23bf86bd20b5f4ae.png)

I think the result is not reliable.

---

<div class="post-metadata">

**Author:** ![Nicholas\_Bokulich](https://forum.qiime2.org/user_avatar/forum.qiime2.org/nicholas_bokulich/32/19937_2.png) [@Nicholas\_Bokulich](https://forum.qiime2.org/u/Nicholas_Bokulich)\
**Post date:** [May 7, 2019, 1:23pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/5 "2019-05-07T13:23:27Z")

</div>

could you share the greengenes barplot? (ideally, upload the QZVs instead of a screenshot)

I agree, the SILVA results look unreliable.

---

<div class="post-metadata">

**Author:** ![TurboQiimer](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/46a35a/32.png) [@TurboQiimer](https://forum.qiime2.org/u/TurboQiimer)\
**Post date:** [May 7, 2019, 2:27pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/6 "2019-05-07T14:27:51Z")

</div>

![Screenshot%20from%202019-05-07%2016-10-44](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/b/b4f8e8f95aa84d6c4ddf642c398d90721d1c6afd.png)

This is for the Greengenes. If I consider the level 7 in the Greengenes's results, there the unassigned bacteria but the SILVA's result hugely are just unassigned when I put the taxonomy to level 7.

For Greenegens:

 ![Screenshot%20from%202019-05-07%2016-15-55](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/b/ba8c9903c80567b1a17cf3e36a7589c48f75a4a0.png)

For SILVA:

 ![Screenshot%20from%202019-05-07%2016-16-58](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/5/56b16f9a58d3992e8bd9cfb5557808f83ab985c8.png)

---

<div class="post-metadata">

**Author:** ![TurboQiimer](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/46a35a/32.png) [@TurboQiimer](https://forum.qiime2.org/u/TurboQiimer)\
**Post date:** [May 7, 2019, 2:30pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/7 "2019-05-07T14:30:53Z")

</div>

By the way, I used these parameters:

qiime feature-table group   
\*_--p-mode mean-ceiling \*_

qiime feature-table merge   
\*_--p-overlap-method sum \*_

I felt maybe these parameters made them so weird. I am not sure! it is just a theory!

---

<div class="post-metadata">

**Author:** ![Nicholas\_Bokulich](https://forum.qiime2.org/user_avatar/forum.qiime2.org/nicholas_bokulich/32/19937_2.png) [@Nicholas\_Bokulich](https://forum.qiime2.org/u/Nicholas_Bokulich)\
**Post date:** [May 7, 2019, 2:36pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/8 "2019-05-07T14:36:55Z")

</div>

Thanks for showing both.

It looks like you are getting the same bad result with both, but what is "unassigned" with SILVA is for some reason receiving kingdom-level classification (and no more) with greengenes.

I would recommend removing any sequences that do not have at least phylum-level classification, but first I recommend spot-checking a few: grab the sequence and use NCBI BLAST to try and determine if this is non-target DNA, junk, or if it really is bacterial DNA that should be receiving a classification.

NCBI BLAST will confirm for us. This could be a technical error: the sklearn classifier does not handle sequences that are in mixed orientations (i.e., a mixture of forward and reverse reads relative to the orientation they appear in in the reference database), in which case I recommend the `classify-consensus-vsearch` method, which can handle these.

However, given that the unassigned reads are mostly in a few samples, I suspect this is not a mixed-orientation issue (which would more or less impact all samples evenly), so I suspect this is just non-target or bad reads, in which case you should filter these out.

Let us know what your search digs up! 🔍

---

<div class="post-metadata">

**Author:** ![TurboQiimer](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/46a35a/32.png) [@TurboQiimer](https://forum.qiime2.org/u/TurboQiimer)\
**Post date:** [May 7, 2019, 6:21pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/9 "2019-05-07T18:21:47Z")

</div>

> [@Nicholas\_Bokulich](#):
>
> use NCBI BLAST

I checked some sequences randomly (there are a lot of reads), and blasted. many microorganisms are uncultured bacteria as you see in the photo. As an example, I attached a part of the blasting.  
 ![Screenshot%20from%202019-05-07%2016-54-45](https://forum.qiime2.org/images/transparent.png)

> [@Nicholas\_Bokulich](#):
>
> I recommend the `classify-consensus-vsearch` method, which can handle these

I think this method was good, but I wondered that I just analyzing by forward read, not revers (no mixture reads in my forward file). The reverse reads are in a different file that I did not use it. This method, anyway, improved my result remarkably:slightly\_smiling\_face: but I still have a fraction of unassigned taxa specially in the two samples which are high. For your information I just used the Greengenes database to data. Do you have any suggestion to solve it? Or do you know why they are? Please share your idea.

![Screenshot%20from%202019-05-07%2020-12-19](https://forum.qiime2.org/images/transparent.png)

I enjoyed your suggestion to use the method. I never thought I would be able to solve this issue although I have the problem in a range  
. You made my day!

---

<div class="post-metadata">

**Author:** ![Nicholas\_Bokulich](https://forum.qiime2.org/user_avatar/forum.qiime2.org/nicholas_bokulich/32/19937_2.png) [@Nicholas\_Bokulich](https://forum.qiime2.org/u/Nicholas_Bokulich)\
**Post date:** [May 7, 2019, 6:47pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/10 "2019-05-07T18:47:42Z")

</div>

> [@TurboQiimer](#):
>
> I checked some sequences randomly (there are a lot of reads), and blasted. many microorganisms are uncultured bacteria as you see in the photo.

you should exclude uncultured organisms in your blast search.

> [@TurboQiimer](#):
>
> I think this method was good, but I wondered that I just analyzing by forward read, not revers (no mixture reads in my forward file).

What I mean is the orientation of the reads relative to the reference, not the read direction (e.g., forward and reverse paired-end reads). Some sequencing protocols result in mixed-orientation reads.

> [@TurboQiimer](#):
>
> but I still have a fraction of unassigned taxa specially in the two samples which are high.

These are probably junk DNA or non-target DNA, e.g., host. This is not an uncommon problem and I recommend blasting a few of those reads to confirm, then if they appear to be non-target just filter them all out as described in the tutorials.

> [@TurboQiimer](#):
>
> I enjoyed your suggestion to use the method. I never thought I would be able to solve this issue although I have the problem in a range  
> . You made my day!

Glad that worked for you!

---

<div class="post-metadata">

**Author:** ![TurboQiimer](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/46a35a/32.png) [@TurboQiimer](https://forum.qiime2.org/u/TurboQiimer)\
**Post date:** [May 23, 2019, 10:48am UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/11 "2019-05-23T10:48:28Z")

</div>

Dear @Nicholas_Bokulich,

Two questions over this topic distressed me that's why I retrieved it!

Vsearch classifier worked for me in the end, but I have unassigned taxa in the treated samples while all untreated samples were faced with too low unranked taxa (negligible). Firstly, I am curious to know what is the reason? What probabilities maybe you suggest?

Next, I used the pre-trained Greengenes classifier which is existed in Qiime2 tutorial. Its result showed too low unassigned taxa for all treated and untreated samples. I mean this worked better than Vserach classifier in treated samples (about untreated samples differences were not remarkable).

If you need the photos, I will provide you later.

Sorry for the inconvenience!

---

<div class="post-metadata">

**Author:** ![Nicholas\_Bokulich](https://forum.qiime2.org/user_avatar/forum.qiime2.org/nicholas_bokulich/32/19937_2.png) [@Nicholas\_Bokulich](https://forum.qiime2.org/u/Nicholas_Bokulich)\
**Post date:** [May 23, 2019, 12:34pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/12 "2019-05-23T12:34:51Z")

</div>

> [@TurboQiimer](#):
>
> If you need the photos, I will provide you later.

Please provide. It is not really clear what you mean by this:

> [@TurboQiimer](#):
>
> I have unassigned taxa in the treated samples while all untreated samples were faced with too low unranked taxa (negligible)

---

<div class="post-metadata">

**Author:** ![TurboQiimer](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/46a35a/32.png) [@TurboQiimer](https://forum.qiime2.org/u/TurboQiimer)\
**Post date:** [May 24, 2019, 3:21pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/13 "2019-05-24T15:21:38Z")

</div>

This plot related to the per-trained Greengenes database! as you see my samples have lower unassigned taxa but one.

 ![Screenshot%20from%202019-05-24%2016-55-14](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/f/f93ff27617242ddb18895448ed7ab4afc1db632d.png)

This barplot related to the SILVA database trained by Vsearch consensus classifier.

 ![Screenshot%20from%202019-05-24%2016-54-48](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/2/28e86c7aa1d265330992b5ade8d62209c6fad9c2.png)

As you see, some of my controls have low unranked taxa but the treated samples have more unassigned ones.

What is the reason? How can justify it?

---

<div class="post-metadata">

**Author:** ![Nicholas\_Bokulich](https://forum.qiime2.org/user_avatar/forum.qiime2.org/nicholas_bokulich/32/19937_2.png) [@Nicholas\_Bokulich](https://forum.qiime2.org/u/Nicholas_Bokulich)\
**Post date:** [May 24, 2019, 4:25pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/14 "2019-05-24T16:25:35Z")

</div>

> [@TurboQiimer](#):
>
> What is the reason? How can justify it?

I do not know the reason but draw two important conclusions:

1. the effect is minor and I would not worry about it (see steps below)
2. it is not a technical error (i.e., something QIIME 2 is doing wrong). It is probably not an error at all, but follow the steps below to find out.

Now what do we do about it?

1. use NCBI BLAST to spot check a few of the unclassified sequences, as I described above
2. my guess is these should be junk or host DNA. The reason they are more abundant in the treatment? Depends on what the treatment is and the biomass of those samples. E.g., a treatment like broad-spectrum antibiotic use will lead to lower biomass followed by potentially greater detection of background "noise".
3. just remove all unassigned taxa after seeing what the cause might be, unless if it is not junk.

---

<div class="post-metadata">

**Author:** ![system](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/3X/2/1/21af5fe23cb6f4579467c66a9ed94e55274ca7bd.svg) [@system](https://forum.qiime2.org/u/system)\
**Post date:** [June 24, 2019, 10:25pm UTC](https://forum.qiime2.org/t/two-databases-are-different/9531/15 "2019-06-24T22:25:37Z")

</div>

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
