<p>After trying a few different queries, I don't believe there is a more specific one than this and I found that by searching and clicking through all of the results given by this query that eventually I found patients that fit the criteria of having both WGS and 16s.</p>

CC BY-SA 4.0
2018-10-24T02:03:11.790Z
2018-10-24T02:03:11.790Z
ljs
<p>I am looking for a query to run on <a href="https://portal.hmpdacc.org/query/s" rel="nofollow noreferrer">the HMP database</a> that will return all subjects who have had BOTH 16s <em>and</em> whole genomes sequence (WGS) workups.  I am currently using this query...</p>

<pre><code>file.matrix_type = 16s_community OR file.matrix_type = wgs_community AND (file.format = FASTA OR file.format = FASTQ) 
</code></pre>

<p>and sifting through the results by adding them to my shopping cart, browsing the file types until I have added all of the samples from one subject, and then I check to see if I have at least one 16s and one WGS.  So far, I have not found one person who has had both 16s and WGS where both files were publicly accessible, and most do not have WGS at all.  There must be a way to get subjects with both workups done to make this faster.</p>

<public-databases><genomics><data-download><metagenome>
How to query the Human Microbiome Project (HMP) to find all subjects with both 16s and WGS workups?
# How to query the Human Microbiome Project (HMP) to find all subjects with both 16s and WGS workups?

(Asked by: username_0 on 2018-09-19)

I am looking for a query to run on the HMP database that will return all subjects who have had BOTH 16s and whole genomes sequence (WGS) workups.  I am currently using this query...
file.matrix_type = 16s_community OR file.matrix_type = wgs_community AND (file.format = FASTA OR file.format = FASTQ) 

and sifting through the results by adding them to my shopping cart, browsing the file types until I have added all of the samples from one subject, and then I check to see if I have at least one 16s and one WGS.  So far, I have not found one person who has had both 16s and WGS where both files were publicly accessible, and most do not have WGS at all.  There must be a way to get subjects with both workups done to make this faster.

**Tags:** public-databases, genomics, data-download, metagenome

---

## 1 answers

### Answer by username_0 on 2018-10-24. Score: 0 | Accepted answer

After trying a few different queries, I don't believe there is a more specific one than this and I found that by searching and clicking through all of the results given by this query that eventually I found patients that fit the criteria of having both WGS and 16s.


---

