Generic Table View

Introduction

Genome Workbench implements a spreadsheet-like relational view for the data, which can be represented as a table. Generic table view can be used to display:

1. Genomic Assemblies (Collections)
2. Imported Tabular Data
3. Phylogenetic Trees

Generic Tabular View can be used to search and query the data. It can also export data to use in third-party programs, like MS Excel.

Viewing Genomic Assemblies (Collections) with Generic Table View

Use Open Dialog to find and load the Genomic Assembly to your project.

Once assembly is loaded select it in the Project Tree and use Open View dialog -> Generic Table View.

Genome Workbench will display the assembly as a relational table.

Imported Tabular Data

For detailed information on imported tabular data please see the Loading Tabular Data tutorial.

Viewing Phylogenetic Trees with Generic Table View

Obtaining the Test File

Please download test ASN.1 file to be used in this tutorial.

Opening the tree's ASN.1 file

From the File menu choose Open and select File Import from the left side:

Select NCBI ASN.1 files from the drop down list File Format. Navigate to the folder where the file is located and click Open. Then click Finish.

Opening Generic Table View

Now there is a 'New Project' in the Project Tree View.

Double click the tree to open the Open View dialog and select Generic Table View from the list:

A new Generic Table View will open:

Each node is represented by one line in the table and its id, parent, and a set of properties are shown.

Showing/hiding columns

You can select the columns (properties) that are displayed by right clicking the table’s header:

If the table has more than 20 columns, the context menu will display 20 and show item "More...".

Clicking it opens a new Filter Columns dialog, that lets the user set columns visibility:

In this dialog:

• individual columns can be selected
• all columns can be selected or deselected
• a range of visible columns can be defined

The range field is flexible and can hold column numbers, column ranges (from number - to number) and a comma separated combinations of the two. The columns list box is updated to reflect the selection in the range field.

Press Select to save your selection.

Exporting tabular data to CSV

The CSV ("Comma Separated Values") file format is often used to exchange data between different applications. CSV stores tabular data in plain text. Each record is stored on one line and consists of one or more fields, separated by commas. The CSV format is described in RFC 4180.

In order to export a tree’s tabular data to CSV, right click inside the table and select Export to CSV…:

Export To CSV dialog lets you control what data is exported:

You can choose:

• whether the first row in the output CSV file will contain the names (headers) of the columns
• to export only the selected cells only
• which columns will be exported (Select columns to export list box)

When you are done with the configuration, press OK to generate the output CSV file. It will be stored in the path defined in the File Name field.

You can open the generated CSV file using Microsoft Excel or other compatible application: