Filtering tables

The final concept to introduce is Filtering. The table filter as an advanced and a simple mode. The simple mode is the default and is applied simply by typing text or numbers (see an example in figure 3.24).3.1

Image orf_table_simple_filter
Figure 3.24: Typing "neg" in the filter in simple mode.

Typing "neg" in the filter will only show the rows where "neg" is part of the text in any of the columns (also the ones that are not shown). The text does not have to be in the beginning, thus "ega" would give the same result. This simple filter works fine for fast, textual and non-complicated filtering and searching.

However, if you wish to make use of numerical information or make more complex filters, you can switch to the advanced mode by clicking the Advanced filter (Image annotations_popup) button. The advanced filter is structure in a different way: First of all, you can have more than one criterion in the filter. Criteria can be added or removed by clicking the Add (Image add_new_parameter_16_n_p) or Remove (Image close_x_red_16_n_p) buttons. At the top, you can choose whether all the criteria should be fulfilled (Match all), or if just one of the needs to be fulfilled (Match any).

For each filter criterion, you first have to select which column it should apply to. Next, you choose an operator. For numbers, you can choose between:

Note, that the number of digits displayed is a formatting option which can be set in the View Preferences. The true number may well be (slightly) larger. This behaviour can lead to problems when filtering on exact matches using the = (equal to) operator on numbers. Instead, users are advised to use two filters of inequalities (< (smaller than) and > (greater than)) delimiting a (small) interval around the target value.

For text-based columns, you can choose between:

Once you have chosen an operator, you can enter the text or numerical value to use.

If you wish to reset the filter, simply remove (Image close_x_red_16_n_p) all the search criteria. Note that the last one will not disappear - it will be reset and allow you to start over.

Figure 3.25 shows an example of an advanced filter which displays the open reading frames larger than 400 that are placed on the negative strand.

Image orf_table_advanced_filter
Figure 3.25: The advanced filter showing open reading frames larger than 400 that are placed on the negative strand.

Both for the simple and the advanced filter, there is a counter at the upper left corner which tells you the number of rows that pass the filter (91 in figure 3.24 and 15 in figure 3.25).


Note that for tables with more than 10000 rows, you have to actually click the Filter button for the table to take effect.