2.15. Tips: how to work with DataTable

For example, you can see a list of metabolites included in the metabolome dataset by accessing https://jmorp.megabank.tohoku.ac.jp/metabolome. This table offers filtering, keyword search, CSV file export, and other features. Tables are frequently used by jMorp to display data, and some of them let you perform simple operations like the ones mentioned above. How to use these tables is covered in this section.

../../_images/tips_datatable-overview.en.png

2.15.1. Keyword search

The keyword input box will be shown when you click the magnifying glass icon as shown below. You can extract only rows that contain the keyword specified by the search box.In addition, when you separate your keywords with whitespace, you can also extract rows that contain all of the keywords.

../../_images/tips_datatable-keyword_search.en.png

2.15.2. Column selector

The column selection panel will appear when you click the icon with three squares in the upper left of the table. By operating the ON/OFF switch on the left side of each item, you can increase or decrease the number of columns displayed in the table.

../../_images/tips_datatable-column_selector.en.png

In the image above, ID, Common Name, Analysis method, # of samples (ALL) columns are displayed, while Local Name, Mean (All), SD (All) and CV (ALL) columns are hidden.

You can instantly alter whether all columns are displayed or hidden by clicking the SHOW ALL and HIDE ALL buttons at the panel’s bottom.

2.15.3. Save as CSV

By clicking the download icon in the top left corner of the table, you can save the table as a CSV file. If you download it as a CSV file, you may use Excel to open it and perform additional analysis on your personal computer.

../../_images/tips_datatable-export.en.png

The ALL ROWS and SELECTED ROWS options will appear when you click the download button. The first allows you to download the entire table’s data as a CSV file. On the other hand, if you select the latter, you can only download the lines that were found using the aforementioned keyword search as a CSV file.

2.15.4. Sort

Click the header of the desired column to sort by that column. An arrow is displayed next to the column name when the data is sorted by column value. The example of applying a descending sort on the data in the # of samples (ALL) column is shown in the image below.

../../_images/tips_datatable-sort.en.png

2.15.5. Filtering

A panel for filtering by a column’s values will appear when you click on the hollow icon to the right of a column name. In this panel, enter your filtering criteria. An example of a search for columns with acid in the Common Name is shown below. When column filtering is enabled, a number (the total number of configured filters) is shown in the dimple’s top right corner.

../../_images/tips_datatable-filter.en.png

The value type affects the filtering criteria you can set in this panel (whether the column is string data, numeric data, etc.). Strings can have the following criteria applied to them.

Operator	Meaning
likes	Contains (case in-sensitive)
contains	Contains (case sensitive)
starts with	Starts with
Ends with	Ends with
Empty	Is empty
is not empty	Is not empty

You can specify the following criteria for numerical values.

Operator	Meaning
=	Equals
!=	Not equals
>	Greater than
>=	Greater than or equals
<	Less than
<=	Less than or equals