Running Joins on Galaxy

• Use the Galaxy 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.

• 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.