Tool: SRA Run Collector Google Sheets Add-on: Looking for feedback!
2
gravatar for bimlay2
11 months ago by
bimlay230
bimlay230 wrote:

I recently put together a simple Google App Script add-on for sheets that retrieves run information from SRA from a GSE, SRP, or PRJNA accession.

The git repository can be found here. All of the code can be found in the Code.gs file.

SRA provides its metadata in XML format, but if you want to create an experimental matrix from public data, you need tabular data. Moreover, going from a GSE accession to a table of run emtadata is non-trivial. This tool allows you to simply pull all run information for a given study with a click of a button.

I'm looking for feedback and future directions for the tool. I'm not bound to the Google App Script platform. I could easily make a web app with this code foundation. I figured a sheets add-on would be very accessible.

Here is an example of output from the script: https://drive.google.com/file/d/1c4_7xwMjuB2de4oJuzhvr2uuODze7UXy/view?usp=sharing

rna-seq tool • 328 views
ADD COMMENTlink modified 11 months ago • written 11 months ago by bimlay230
1

In case you have not seen : sra-explorer : find SRA and FastQ download URLs in a couple of clicks

ADD REPLYlink modified 11 months ago • written 11 months ago by genomax85k

Yes, I've seen this tool. My inspiration for this project is that I wanted to know sample attributes and various other metadata fields for the associated runs.

The desired output of my tool is not necessarily run numbers alone, which are easy to get from sra-explorer. Rather, my tool collects run information and metadata for multiple studies at once.

I've also found that SRA Explorer does not find all studies because of the way it interfaces with Eutils. My method will always find associated sequencing runs. For example, try GSE48812 with SRA Explorer.

ADD REPLYlink modified 11 months ago • written 11 months ago by bimlay230

The script requires some major permissions

Can you be more specific what that exactly means? No offense, but I would for sure not sudo (or similar) any code that comes from Github. Who knows what would happen ;-)

ADD REPLYlink modified 11 months ago • written 11 months ago by ATpoint36k

Permissions as in permissions from Google. The script uses a URL fetch method to get information from NCBI. Google will request permission to do this before you can run the script.

This is not a command line tool. There are no real client permissions involved.

ADD REPLYlink modified 11 months ago • written 11 months ago by bimlay230
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: 772 users visited in the last hour