# Running Joins on Galaxy

* Use the [Galaxy](http://main.g2.bx.psu.edu/) Get Data --> Upload File tool to load the data located at the following paths:

```
/net/ostrom/data/dropbox/arrayDat.txt
/net/ostrom/data/dropbox/arrayAnnot.txt
```

* Array Data contains a 100 lines of affymetrix microarray data. Gene Data is 70 lines of annotation information corresponding to a subset of the array data.
* Examine the information in each file using the eye icons on the right side of the page. Note that the first column in both files is "ProbeID". That common column will be the basis for binding the 2 files together. In database terms, ProbeID is the "key" used in the join.

<figure><img src="/files/jKWs9OKHofe3uliASsZw" alt=""><figcaption></figcaption></figure>

* Examine the results. Column c1, (ProbeID) from the array data file was used to examine column c1 of the gene data file. Whenever a match was found, the infromation in the gene data file was appended to the array data file.


---

# 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://igb.mit.edu/bioinformatics-topics/tools-a-basic-bioinformatics-toolkit/relational-databases/running-joins-on-galaxy.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.