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 () 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 () or Remove () 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:
- = (equal to)
- < (smaller than)
- > (greater than)
- <> (not equal to)
- abs. value < (absolute value smaller than. This is useful if it doesn't matter whether the number is negative or positive)
- abs. value > (absolute value greater than. This is useful if it doesn't matter whether the number is negative or positive)
- contains (the text does not have to be in the beginning)
- doesn't contain
- = (the whole text in the table cell has to match, also lower/upper case)
If you wish to reset the filter, simply remove () all the search criteria. Note that the last one will not disappear - it will be reset and allow you to start over.
Figure 30.3 shows an example of an advanced filter which displays the open reading frames larger than 400 that are placed on the negative strand.
- Note that for tables with more than 10000 rows, you have to actually click the Filter button for the table to take effect.