TSV Download and Meta-data icons

[ababaian]

Serratus looks very exciting. I haven't seen it before so thanks for sharing. The interface is intuitive and the graphics are quite nice. My only suggestion would be to possibly include some SRA metadata on the main results page- I noticed some of the SRA are from transcriptomes or isolate viral genome sequencing projects - if someone was interested in only metagenomes it might be easier to prioritize the results with some of that data present.

I am thinking that adding an icon representing what kind of sample (very generally) an SRA is from might do this well. Categories would be Human, Mouse, Mammal, Vertebrate, Invertebrate, Fungus, Plant, Prokaryote, Metagenome, Other. I can implement this into the SQL database via parsing the SraRunInfo files.

If including that data makes that display page too busy then perhaps a download link for a .tsv file with the SRA mapping results summary and metadata could be useful.

Adding a "Download Results" button for a given query I think has been requested three or four times now. This seems to be the most common request we've gotten and should be a little bit of a higher priority. Essentially I think this would look like whatever is displayed on the page, you can download those query results (without a LIMIT filter) to a tsv file.

For both of these let's get the SQL update we're working on ready first and then we can swing back to these UI features.

[victorlin]

Cool, on board with all that’s mentioned.

For the SRA categories - if this will be strictly a website feature, it maybe sufficient to pull data directly from NCBI (this is what is currently done for the title that appears under the SRA ID).

Otherwise, we’d have to think about the best way to add columns to the data after upload.

[ababaian]

I have categories for each SRA based on which query it was part of, once we get our ducks in row SQL wise I can add a classification to each SRA in a small 2 column table for this