Table browser

From ExpressionPlot
Jump to: navigation, search

When you click on an action button next to a 2way or 4way plot you are asking ExpressionPlot what genes or events are changed in the plot. The answer comes in the form of table browser, ExpressionPlot's dynamic spreadsheet.

The heart of the table browser is the large table in the middle of the page. Each row corresponds to a changed gene or event. The columns give different information and statistics about each gene/event. The number and names of columns depend on the type of event and whether the table represents a 2way or 4way comparison.

Some of the column headers are activated; these will change color when you roll your mouse over them. You can click on the header to sort the table by that row. If you click again it will reverse sort them. Activated columns can also be filtered. Some have text filters, in which case you will see a single text field. Enter some (case-sensitive) text in the field, then focus away from the field by hitting the tab key or clicking on another part of the page. Only rows containing your text in that column will show. Remove the text (and then focus away) to remove the filter, showing all rows again. Other activated columns have numeric filters. Type a number in the text field, then choose the filter from the drop down menu. To remove the filter, select "All" from the drop-down menu. You can apply multiple filters to different columns, and only rows matching all filters will be shown.

The rows of the table are themselves activated. If you click on any part of any row, a context menu will appear containing a link that will open the seqview tool with the relevant project and genomic regions already chosen and, if the row is an alternative splicing event, the relevant alternatively spliced region highlighted.

Above the table, the left section shows information about the comparison you've made, including the project name(s), comparison name(s), <math>P</math>-value and fold-change cutoff(s), and the number of genes or events passing those cutoffs. As you apply further filters on the table, the number of remaining rows is updated.

The section above the table to the right of the separator contains several action buttons.

table browser actions
row 1, cell 1 row 1, cell 2
row 2, cell 1 row 2, cell 2
table browser statistics
row 1, cell 1 row 1, cell 2 row 1, cell 3
row 2, cell 1 row 2, cell 2 row 2, cell 3