search

marbl / Krona

Interactively explore metagenomes and more from a web browser.
https://github.com/marbl/Krona/wiki
457 stars 101 forks source link

Excel Templates #70

Open sawasap opened 6 years ago

sawasap commented 6 years ago

Hi all,

Is there an excel template besides the nutritional one that is available here? Preferably one with taxonomic assignment - i.e.; OTU's assigned to Order/family/genus/species - with similarities and frequency of occurrence abundance.

It would be super helpful for constructing my own krona graph with my data.

Thanks in advance.

sawasap commented 6 years ago

Okay I managed with a template added in one of the replies in this forum.

I have another question: Is it possible to add another "score" column to the excel template somehow?

see template: https://github.com/marbl/Krona/raw/master/ExcelTemplate/Krona.xltm

ondovb commented 6 years ago

Unfortunately, no, the Krona viewer can only display one score, so the template only allows one (related to #49).

sawasap commented 6 years ago

Hi Brian, Thanks for the reply.

Krona is great! I really like the concept! I created a graph which I am really pleased with!

Do you think journals will move forward to allow interactive graphs in the future?

Some ideas/suggestions: It would be really nice if there was an option to add vector pictures to the graph. An option to record a "clip" of moving through different datas\highlighting etc'. And an option to include the graphs/clips in power point presentations!

Thanks alot!

ondovb commented 6 years ago

Good suggestions! I think it would be pretty straightforward for a journal to allow an HTML embed with something like an interactive D3 chart or Krona chart, and I wouldn't be surprised if something like that appears in the near future.

Vector images and recorded navigation are nice ideas, but we may not have the resources to implement them, at least in the near future. What you could do is add vector images to a static snapshot with an SVG editor, or record a clip with your favorite screen capturer (e.g. Grab on macOS).

ghost commented 6 years ago

In connection to the journal reference, I work for a science publisher and am looking at the option of using Krona. It happens that we have a number of datasets in Newick format so right now I am exploring if we could visualize those files with Krona as well. However, at this point I have not seen a path from Newick format to Krona. If there is, let me know !

ondovb commented 6 years ago

Hi @rkwakkel - The problem with Newick is that it is not typically associated with quantities at each tree node. The "distances" certainly could be used this way (instead of their usual use for branch length), however, this association is not standardized, at least that I have heard of. So it would probably be possible to convert, but it depends on the type of data you have.