# Qurro: Export numerator - denominator list

**URL:** https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851
**Category:** Library Support
**Created:** [March 2, 2020, 12:04pm UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851 "2020-03-02T12:04:16Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![arwqiime](https://forum.qiime2.org/user_avatar/forum.qiime2.org/arwqiime/32/12728_2.png) [@arwqiime](https://forum.qiime2.org/u/arwqiime)
#### Post date: [March 2, 2020, 12:04pm UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/1 "2020-03-02T12:04:16Z")

</div>

Hello,  
An auto-selection value of 5% at a specific axis results in considerabl deifferences in the log-ratio between different sample groups and displays the interesting list of taxa in the nominator and denominator section of qurro plots. Is there any possibility to export the nominator and denominator list from the qurro plot visualisation?  
Best regards,

---

<div class="post-metadata">

### Author: ![colinbrislawn](https://forum.qiime2.org/user_avatar/forum.qiime2.org/colinbrislawn/32/6221_2.png) [@colinbrislawn](https://forum.qiime2.org/u/colinbrislawn)
#### Post date: [March 2, 2020, 2:51pm UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/2 "2020-03-02T14:51:52Z")

</div>



---

<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: [March 2, 2020, 3:17pm UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/3 "2020-03-02T15:17:52Z")

</div>



---

<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: [March 2, 2020, 3:18pm UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/4 "2020-03-02T15:18:22Z")

</div>

pinging @fedarko... thank you both!

---

<div class="post-metadata">

### Author: ![fedarko](https://forum.qiime2.org/user_avatar/forum.qiime2.org/fedarko/32/5361_2.png) [@fedarko](https://forum.qiime2.org/u/fedarko)
#### Post date: [March 2, 2020, 5:39pm UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/5 "2020-03-02T17:39:55Z")

</div>

Hi @arwqiime,

There isn't an easy way to do this right now, sorry -- I've had this on my TODO list for Qurro for a while now (the relevant issue is [here](https://github.com/biocore/qurro/issues/87)). Hopefully we'll be able to get this sort of functionality implemented soon.

In the meantime, if you just want to check out the IDs of the top- / bottom- ranked features for a given ranking, you can always inspect the rankings outside of Qurro -- for example, by loading the corresponding QZA through the QIIME 2 Artifact API, then going from there to a Pandas DataFrame representation of the rankings (from which you can use methods like [`.nlargest()`](https://pandas.pydata.org/pandas-docs/version/0.25.0/reference/api/pandas.DataFrame.nlargest.html) or [`.nsmallest()`](https://pandas.pydata.org/pandas-docs/version/0.25.0/reference/api/pandas.DataFrame.nsmallest.html) to retrieve the extremely ranked features for a given ranking).

---

<div class="post-metadata">

### Author: ![gibsramen](https://forum.qiime2.org/user_avatar/forum.qiime2.org/gibsramen/32/7020_2.png) [@gibsramen](https://forum.qiime2.org/u/gibsramen)
#### Post date: [March 2, 2020, 6:43pm UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/8 "2020-03-02T18:43:42Z")

</div>

Hi @arwqiime

I think I have a _really_ hacky solution that might address your needs.

When you're on the webpage with the Qurro visualization, you can "inspect element" (on Chrome) and see all the constituent parts of the webpage. If you dig deep enough into the datatables you should find all the features you are looking for. You should be able to copy the element containing them and then paste into a document on which you can perform some text searching to find the IDs.

I've attached a screenshot of where this appears on my end.

 ![Screen Shot 2020-03-02 at 10.42.14 AM (2)](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/8/8b67054a2404095c3db086f0d71a1259076c6b4f.png)

Super cumbersome and possibly unstable with future Qurro updates but I hope it helps you out in the short-term.

EDIT: I think you can right-click the `<tbody>` tag and copy the whole element which I _think_ should give you all the rows.

---

<div class="post-metadata">

### Author: ![arwqiime](https://forum.qiime2.org/user_avatar/forum.qiime2.org/arwqiime/32/12728_2.png) [@arwqiime](https://forum.qiime2.org/u/arwqiime)
#### Post date: [March 3, 2020, 7:18am UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/9 "2020-03-03T07:18:12Z")

</div>

@fedarko, @gibsramen Hi. thanks a lot for your comments and pointing me to some workarounds.  
Actually, I select the table content and copy it via the clipboard, which works but it is not very conveniant (and error-prone, if you do not select the entire table for some reasons).  
If a 'copy-to-clipboard' button wold be easier to implement compared to a csv exporter, this would be sufficient.

Thanks again!

 ![grafik](https://forum-qiime2-org.s3.dualstack.us-west-2.amazonaws.com/original/2X/8/8fa09261e11d79d6a7095fe57db133174af973f7.png)

---

<div class="post-metadata">

### Author: ![fedarko](https://forum.qiime2.org/user_avatar/forum.qiime2.org/fedarko/32/5361_2.png) [@fedarko](https://forum.qiime2.org/u/fedarko)
#### Post date: [March 3, 2020, 9:59am UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/10 "2020-03-03T09:59:22Z")

</div>

@arwqiime The copy-to-clipboard solution is a cool idea, thanks! In terms of effort needed to implement things, I think that would be a similar amount of work as just exporting a TSV file (like is already done for the sample plot data).

Your question inspired me to get some work done on the selected feature list export -- [here's a tentative screenshot](https://user-images.githubusercontent.com/4177727/75764067-29b83300-5cf2-11ea-9c91-54eefeeace13.png) of what the interface will look like. Out of curiosity, what sort of output file would be most useful for you? I'm thinking along the lines of a simple TSV file formatted like

```plaintext
"Feature ID" [tab] Log_Ratio_Classification
ASV1 [tab] Numerator
ASV2 [tab] Denominator
ASV3 [tab] Numerator
ASV4 [tab] Both

```

but if you'd prefer something else, just let me know and I may be able to sort it out. (That being said I can't promise I'll get this finished soon -- things are getting a bit busy over here...)

**edit:** I bit the bullet and got a draft version of this functionality implemented over in [GitHub - fedarko/qurro: Visualize differentially ranked features (taxa, metabolites, ...) in tandem with log-ratios of their sample abundances](https://github.com/fedarko/qurro/). The new functionality in this version isn't tested yet (this version of Qurro should be treated as "experimental" for now), but if you want to try it out you should be able to install it using `pip install git+https://github.com/fedarko/qurro.git` 🙂

---

<div class="post-metadata">

### Author: ![arwqiime](https://forum.qiime2.org/user_avatar/forum.qiime2.org/arwqiime/32/12728_2.png) [@arwqiime](https://forum.qiime2.org/u/arwqiime)
#### Post date: [March 4, 2020, 7:38am UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/11 "2020-03-04T07:38:28Z")

</div>

@fedarko

> [@fedarko](#):
>
> Out of curiosity, what sort of output file would be most useful for you? I’m thinking along the lines of a simple TSV file formatted like

Yes, a TSV export (including the colum headers) would be just fine!  
Thanks!

---

<div class="post-metadata">

### Author: ![fedarko](https://forum.qiime2.org/user_avatar/forum.qiime2.org/fedarko/32/5361_2.png) [@fedarko](https://forum.qiime2.org/u/fedarko)
#### Post date: [March 11, 2020, 5:02am UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/12 "2020-03-11T05:02:09Z")

</div>

> Yes, a TSV export (including the colum headers) would be just fine!

Ok, version 0.6.0 of Qurro ([out now](https://library.qiime2.org/plugins/qurro/22/)!) has support for this! Hope this is useful.

---

<div class="post-metadata">

### Author: ![arwqiime](https://forum.qiime2.org/user_avatar/forum.qiime2.org/arwqiime/32/12728_2.png) [@arwqiime](https://forum.qiime2.org/u/arwqiime)
#### Post date: [March 11, 2020, 7:49am UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/13 "2020-03-11T07:49:19Z")

</div>

Hi @fedarko, thank you for the export function! Is it correct that only the 'feature' and the 'log ratio classification' columns are exported, but not the PCA values for axis1/2/3, the taxon, and the confidence column? Would it be possible to get the entire table?

Best regards!

---

<div class="post-metadata">

### Author: ![fedarko](https://forum.qiime2.org/user_avatar/forum.qiime2.org/fedarko/32/5361_2.png) [@fedarko](https://forum.qiime2.org/u/fedarko)
#### Post date: [March 11, 2020, 9:56am UTC](https://forum.qiime2.org/t/qurro-export-numerator-denominator-list/13851/14 "2020-03-11T09:56:04Z")

</div>

Hi @arwqiime, yes as of right now just those two columns are exported. It'd be possible to export all of the columns, but this would take some extra work -- I've created an issue to keep track of this [here](https://github.com/biocore/qurro/issues/292).

I probably won't be able to get to that for a while since things are pretty busy over here, sorry.
