# Sort Rows by Prototype

*Sort Rows by Prototype* is a function that can identify genes with similar expression patterns. For example, if a gene with an interesting expression pattern has been detected, using *Sort Rows by Prototype* makes it possible to find other genes that have a similar pattern of intensity values. Although this is most commonly used for changes in gene expression over a time course, it can be applied to other experimental designs as well.

To invoke *Sort Rows by Prototype*\_,\_ probe(sets)/genes must be on rows. If you want to use this tool to analyze the main intensity values spreadsheet, the spreadsheet must be transposed prior to analysis. A common way to view and analyze gene expression in a time-series experiment is to include means or LS means in the ANOVA spreadsheet.

* Configure the ANOVA dialog to include the factor or interaction of interest
* Select **Advanced...** from the ANOVA dialog
* Select **LS-Mean** or **Mean**
* Use the drop down menus to select the factors or interaction you want the LS mean / mean of
* Select **Add** for each
* Select **OK** (Figure 1)

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-b87be1f7c2d38988318b1d593e69a1e306c2b4c4%2F2017-08-16%2014_05_59-Configure%20of%20Spreadsheet%201.png?alt=media)

Figure 1. Using Advanced ANOVA setup to include group means in the ANOVA output

* Select **OK** to close the ANOVA configuration dialog and open the ANOVA spreadsheet

The *Sort Rows by Prototype* function uses every non-text column in a spreadsheet to build and compare patterns; any columns you do not want to include in the pattern similarity analysis need to be removed before running the function.

If you want to preserve the ANOVA spreadsheet contents, clone the ANOVA spreadsheet prior to deleting columns.

* Select columns you want to remove
* Right-click on a selected column headers
* Select **Delete** from the pop-up menu
* Select (![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-795be23ace6ddca21985b239a96af5205d061c7c%2Fimage2017-8-24%209_50_36.png?alt=media)) from the main command bar to save the modified spreadsheet

We can now invoke *Sort Rows by Prototype* on the modified spreadsheet.

* Select **Tools** from the main toolbar
* Select **Discovery**
* Select **Sort Rows by Prototype...** (Figure 2)

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-e4c7927888fcd04a8631ad6e72d0c67266f582a1%2F2017-08-16%2014_58_13-Partek%20Genomics%20Suite%20-%201_2%20\(SRBP\).png?alt=media)

Figure 2. Invoking Sort Rows by Prototype on spreadsheet with LS mean values for conditions/time points

The *Sort Rows by Prototype* dialog will launch (Figure 3).

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-c1b9909526c4d12e4f9d6756b1ea9ad1fa4f3c66%2F2017-08-16%2015_12_50-Sort%20Rows%20by%20Prototype%20of%20Spreadsheet%201_2.png?alt=media)

Figure 3. Sort Rows by Prototype dialog

This dialog allows you to configure the pattern, or prototype, that all probe(sets)/genes will be compared to by *Sort Rows by Prototype*\_.\_

The *Pattern Type* options (![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-eae6330239dad3301a06b2c8011e6949b7c53cc0%2Fimage2017-8-16%2015_3_21.png?alt=media)) allow preset shapes to be applied to the prototype within the range specified by the *Begin, End, Min,* and *Max* parameters. The final option *From Row* allows you to select any row number in the spreadsheet to serve as the prototype. This is a useful option if you have a particular gene of interest and want to find other genes with similar expression profiles in your data set. You can also manually configure the prototype by dragging the points.

The *Select Dissimilarity Measure* drop-down menu allows to select from a wide variety of parametric and non-parametric measures of dissimilarity.

* After configuring the prototype and selecting a dissimilarity measure, select **Sort** to run the function
* Select **Cancel** to close the dialog

A new column 1 will be added to the spreadsheet and the rows will be reordered (Figure 4). The new column contains the dissimilarity score for each row; the lower the value, the more similar the row is to the prototype. The row with the highest similarity to the prototype is listed first, with the other rows listed in descending similarity to the prototype.

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-cfcd7dc22770a1288f4e041ae6a1e1da4d887f50%2F2017-08-16%2015_13_01-Partek%20Genomics%20Suite%20-%201_2%20\(SRBP%20_\).png?alt=media)

Figure 4. Result of sorting by prototype. The prototype gene is in the first row, while the other genes are listed based on their similarity to the prototype gene. Smaller proximity values imply more similarity to the selected shape

To view the results, we can generate a profile plot of several of the rows. For example, here we will show the top five most similar probe(sets)/genes.

* Select the row headers of the top 5 rows by selecting each while holding the **Ctrl** key or selecting the first then fifth while holding the **Shift** key
* Select **View** from the main toolbar
* Select **Profiles**
* Select **Row Profiles**
* Select **Select** for both *Plots* and *X-Axis* in the *Configure Data Source* dialog

The profile plot will open as a new tab (Figure 5).

![](https://1384254481-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJVEESmJAPppJ3ijFq5aR%2Fuploads%2Fgit-blob-dc4b0be529854450dd913ae4c10cd48190f3c646%2F2017-08-16%2015_20_26-Partek%20Genomics%20Suite%20-%201_2%20\(SRBP%20_\).png?alt=media)

Figure 5. Profile plot of 5 probe(sets)/genes most similar to the prototype used in Sort rows by prototype

## Additional Assistance

If you need additional assistance, please visit [our support page](http://www.partek.com/support) to submit a help ticket or find phone numbers for regional support.