Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-10-24T02:03:11.790Z
Answers.LastActivityDate: 2018-10-24T02:03:11.790Z
Answers.UserDisplayName: ljs
Body: <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>
  
Tags: <public-databases><genomics><data-download><metagenome>
Title: How to query the Human Microbiome Project (HMP) to find all subjects with both 16s and WGS workups?
ThreadText: # 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](https://portal.hmpdacc.org/query/s) 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.
  
  
  ---
  
  