<p>You can use <a href="https://www.ncbi.nlm.nih.gov/books/NBK179288/" rel="nofollow noreferrer">Entrez Direct</a> for this as follows:</p>
<pre><code>esearch -db gds -query 'GSE104279' \
  | esummary \
  | xtract -pattern DocumentSummary \
    -if 'entryType' -equals 'GSM' \
    -def 'NA' -element Accession title summary FTPLink
</code></pre>
<p>This will return a table with data similar to this:</p>
<pre><code>GSM2580330      18_Z13_2_d5_Zika        cortical organoids_Zika_5d      ftp://ftp.ncbi.nlm.nih.gov/geo/samples/GSM2580nnn/GSM2580330/
GSM2580329      17_Z13_2_d5_Control     cortical organoids_mock_5d      ftp://ftp.ncbi.nlm.nih.gov/geo/samples/GSM2580nnn/GSM2580329/
</code></pre>
<p>To download sequence reads, you should follow links to SRA. Using Entrez Direct you can do this as follows:</p>
<pre><code>esearch -db gds -query 'GSE104279' \
  | elink -target sra \
  | efetch -format runinfo
</code></pre>
<p>This will return a comma-delimited table containing SRA identifiers and an FTP path to the SRA data. These FTP paths won't lead you to FASTQ files though. You can pass the SRA run identifiers of the format SRR### (or ERR### or DRR###) to <code>fastq-dump</code> or <code>fasterq-dump</code> tools from the <a href="https://trace.ncbi.nlm.nih.gov/Traces/sra/sra.cgi?view=software" rel="nofollow noreferrer">SRAToolkit</a> to download data in FASTQ format.</p>

CC BY-SA 4.0
2020-10-25T23:36:00.950Z
Thank you @vkkodali, this is so helpful, but I want files with sequence, not just summary, by the way, it was good timing, because I just installed Entrez Direct tool but I did not know how to use it, do you know what sequence should I use for cutadapt for these file, they are human genome –
user432797
CC BY-SA 4.0
2020-10-25T21:09:09.073Z
2020-10-26T00:48:49.073Z
2020-10-26T00:48:49.073Z
vkkodali
<p>I have this GSE dataset ( GSE104279 ) (<a href="https://www.ncbi.nlm.nih.gov/geo/query/acc.cgi?acc=GSE104279" rel="nofollow noreferrer">https://www.ncbi.nlm.nih.gov/geo/query/acc.cgi?acc=GSE104279</a>).</p>
<p>I want to make a table with set IDs and ftp urls to use it as a table in galaxy.org</p>
<p>I know that we can use ENA to get specific arrangement:
<a href="https://www.ebi.ac.uk/ena/browser/" rel="nofollow noreferrer">https://www.ebi.ac.uk/ena/browser/</a></p>
<p>I tried to get:</p>
<pre><code>SampleID    Group   URL

</code></pre>
<p>so I used :
<a href="https://www.ebi.ac.uk/ena/browser/view/PRJNA412223" rel="nofollow noreferrer">https://www.ebi.ac.uk/ena/browser/view/PRJNA412223</a></p>
<p>But nothing is showing.</p>
<p>Is there away to get these urls in the arrangement above?</p>

<phylogenetics><sam><bioconductor>
Get list of urls of GSM data set of a GSE set
# Get list of urls of GSM data set of a GSE set

(Asked by: username_0 on 2020-10-25)

I have this GSE dataset ( GSE104279 ) (https://www.ncbi.nlm.nih.gov/geo/query/acc.cgi?acc=GSE104279).
I want to make a table with set IDs and ftp urls to use it as a table in galaxy.org
I know that we can use ENA to get specific arrangement:
https://www.ebi.ac.uk/ena/browser/
I tried to get:
SampleID    Group   URL


so I used :
https://www.ebi.ac.uk/ena/browser/view/PRJNA412223
But nothing is showing.
Is there away to get these urls in the arrangement above?

**Tags:** phylogenetics, sam, bioconductor

---

## 1 answers

### Answer by username_1 on 2020-10-25. Score: 1 | Accepted answer

You can use Entrez Direct for this as follows:
esearch -db gds -query 'GSE104279' \
  | esummary \
  | xtract -pattern DocumentSummary \
    -if 'entryType' -equals 'GSM' \
    -def 'NA' -element Accession title summary FTPLink

This will return a table with data similar to this:
GSM2580330      18_Z13_2_d5_Zika        cortical organoids_Zika_5d      ftp://ftp.ncbi.nlm.nih.gov/geo/samples/GSM2580nnn/GSM2580330/
GSM2580329      17_Z13_2_d5_Control     cortical organoids_mock_5d      ftp://ftp.ncbi.nlm.nih.gov/geo/samples/GSM2580nnn/GSM2580329/

To download sequence reads, you should follow links to SRA. Using Entrez Direct you can do this as follows:
esearch -db gds -query 'GSE104279' \
  | elink -target sra \
  | efetch -format runinfo

This will return a comma-delimited table containing SRA identifiers and an FTP path to the SRA data. These FTP paths won't lead you to FASTQ files though. You can pass the SRA run identifiers of the format SRR### (or ERR### or DRR###) to fastq-dump or fasterq-dump tools from the SRAToolkit to download data in FASTQ format.

> **Comments:**
> **username_0**: Thank you @vkkodali, this is so helpful, but I want files with sequence, not just summary, by the way, it was good timing, because I just installed Entrez Direct tool but I did not know how to use it, do you know what sequence should I use for cutadapt for these file, they are human genome –  

---

