Working with tables

Tables are used in a lot of places in the CLC Genomics Workbench. There are some general features for all tables, irrespective of their contents, that are described here.

Figure 3.25 shows an example of a typical table. This is the table result of Find Open Reading Frames (Image orf). We use this table as an example to illustrate concepts relevant to all kinds of tables.

Image orf_table
Figure 3.25: A table showing the results of an open reading frames analysis.

Table viewing options in the Side Panel

Options relevant to the view of the table can be configured in the Side Panel on the right.

The Column width can be set to Automatic or Manual. By default, the first time you open a table, it will be set to Automatic. The default selected columns are hereby resized to fit the width of the viewing area. When changing to the Manual option, column widths will adjust to the actual header size, and each column size can subsequently be adjusted manually. When the table content exceeds the size of the viewing area, a horizontal scroll becomes available for navigation across the columns.

You can choose which columns can be displayed in the table by checking them in or out from the Side Panel. In some tables, a single checkbox can be used to hide or show a whole set of columns belonging to a certain category. Two buttons called Select all and Deselect all allow you to select or deselect all columns from that Side Panel section in one click.

Finally, in some table (such as Expression Browser), the content of some columns can be modified using the settings from the Side Panel (such as Expression values and Grouping in figure 3.26).

Image expbrowser_table
Figure 3.26: A table showing the results of an RNA-seq analysis.

Sorting tables

You can sort table according to the values of a particular column by clicking a column header. Clicking once will sort in ascending order. A second click will change the order to descending. A third click will set the order back its original order.

Pressing Ctrl - Image command_key_web on Mac - while you click other columns will refine the existing sorting with the values of the additional columns, in the order in which you clicked them.