# Organize Metadata

## Export Metadata

Now in our Parkinson’s Disease Gut Microbiome – Subset Study that we created earlier, select the Export Metadata button. This will create an Excel file of the samples we uploaded to this study. 

<figure><img src="https://820779907-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDWKOAVP0eaMhg1acSkor%2Fuploads%2FabBcx1ABkd28N3Wx6h86%2Fimage.png?alt=media&#x26;token=f1d6e955-cefa-4097-8f81-8ce91ea844f8" alt=""><figcaption></figcaption></figure>

We want to align and combine the exported, basic metadata of the profiled samples with comprehensive metadata for greater analysis. In this example, we will integrate the matching metadata from SRA. Alternatively, if you are using your own data, then you can input any information you require for each sample. Be careful to follow along with these metadata guidelines (link).

{% hint style="info" %}
Even if you upload as an Excel file, EzBioCloud will automatically convert it into a .csv or .tsv
{% endhint %}

## Sort by Sample Name

Sort by 'sample\_name' so we can easily match the metadata from the SRA.

<figure><img src="https://820779907-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDWKOAVP0eaMhg1acSkor%2Fuploads%2FVz71d5eWeJxluWoiKdEH%2Fimage.png?alt=media&#x26;token=43fcf9ee-9548-4f33-9286-977ce877342c" alt=""><figcaption><p>Exported metadata of profiled samples from EzBioCloud.net. </p></figcaption></figure>

## Open SRA Metadata

Open the SRA Metadata file and select all the relevant metadata you want to add to the profiled study, basic metadata.&#x20;

<figure><img src="https://820779907-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDWKOAVP0eaMhg1acSkor%2Fuploads%2Fa1zW61t17JkYBmMJdAEc%2Fimage.png?alt=media&#x26;token=3ad7f67f-f798-42a2-89e5-ff9ee0b6def8" alt=""><figcaption></figcaption></figure>

## Sort SRA Metadata

Sort by 'Run' to match with 'sample\_name' in the study metadata Excel sheet.

Copy and paste the sorted SRA metadata cells into the sorted EzBioCloud spreadsheet.

<figure><img src="https://820779907-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDWKOAVP0eaMhg1acSkor%2Fuploads%2FBrDlnOpdxdimnrKy9phm%2Fimage.png?alt=media&#x26;token=7fca9a4a-9a1f-46bf-8968-75236cc9974d" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
The 'sample\_name' cells should align with the 'Run' cells. E.g. SRR19064316\_N with SRR19064316
{% endhint %}

## Save Cocatenated Sheet

Save the resulting spreadsheet as a combined metadata file for upload to our study.

{% file src="<https://820779907-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDWKOAVP0eaMhg1acSkor%2Fuploads%2Fa18pVKUvijIAM54OBfCi%2FPRJNA834801_subset_metadata_concatenated.xlsx?alt=media&token=78bccf78-1fe5-4671-9f6f-463ed604431d>" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.ezbiocloud.net/home/protocols/shotgun-microbiome/describe-profiles/organize-metadata.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.