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.9 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.9: 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 or unchecking the boxes beside column names in 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 types (such as Expression Browsers), the content of some columns can be modified using settings in the Side Panel (such as Expression values and Grouping in figure 3.10).

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

Working with tables using the right-click menu

Right-clicking on a table reveals standard menu options, as well as table-specific options, found under these submenus:

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.

Adjusting the column order

The column order for viewing and exporting purposes can be changed. To move a column, click on its heading and, keeping the mouse button depressed, drag it to the desired location in the table. Files exported from a table at this point, such as .csv files, will reflect the new column order.

It is not possible to save the revised column order in the Workbench.



Subsections