Exporting Tree Nodes to CSV
Step 1: Introduction
In this tutorial we’ll look at exporting tree nodes from Genome Workbench as CSV files. 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 CSF format is described in RFC 4180.
Example file for this tutorial can be downloaded here: http://0-www-ncbi-nlm-nih-gov.brum.beds.ac.uk/projects/treeview/data/sample_tree.asn
Step 2: Getting Started
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 you downloaded the test file for this tutorial, select sample_tree.asn and click Open. Then click Finish.
Step 3: Opening Tree View
Now there is a 'New Project' in the Project Tree View.
Double click Tree, 'sample_tree' 12 nodes, 7 leaves to open the Open View dialog and select Tree View from the list:
A new Tree View will open.
Step 4: Exporting the Nodes
Select the nodes, you want to export by right clicking on their parent node (clicking the root node will export the entire tree):
Choose Export Selection to CSV… from the newly opened context menu.
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 fields
- whether the output CSV file shall contain only leaves or all nodes
- which fields will be exported (Select fields 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.
Current Version is 3.8.2 (released December 12, 2022)
General
Help
Tutorials
- Basic Operation
- Using Active Objects Inspector
- Configure tracks and track display settings
- Working with Non-Public Data
- Viewing Multiple Alignments and Trees
- Broadcasting
- Genes and Variation
- Generating and Viewing Sequence Overlap Alignment
- Working with BAM Files
- Loading Tabular Data
- Working with VCF Files
- Sequence View Markers
- Opening Projects in Genome Workbench
- Publication quality graphics (PDF/SVG image export)
- Editing in Genome Workbench
- Create Protein Alignments using ProSplign
- GFF-CIGAR export for alignments
- Exporting Tree Nodes to CSV
- Generic Table View
- Running BLAST search against custom BLAST databases
- Using Phylogenetic Tree
- Coloring methods in Multiple Alignment View
- Displaying translation discrepancies
- Searching in Genome Workbench
- Graphical View Navigation and Manipulation
- Using the Text View to Review and Edit a Submission
- BAM haplotype filtering
- Displaying new non-NCBI molecules with annotations
- Creating phylogenetic tree from precalculated multiple alignment
- Creating phylogenetic tree starting from search
- Video Tutorials
General use Manuals
- Tree Viewer Formatting
- Tree Viewer Broadcasting
- Genome Workbench Macro
- Query Syntax in Genome Workbench and Tree Viewer
- Multiple Sequence Aligners
- Running Genome Workbench over X Window System
NCBI GenBank Submissions Manuals
- Table of Contents
- Introduction
- Genome Submission Wizard
- Save Submission File
- Reports
- Import
- Sequences
- Add Features
- Add Publication
- Comments
- Editing Tools