The exporter can be used to:
- Export bioinformatic data in most of the formats that can be imported. There are a few exceptions. See Import of bioinformatic data.
- Export one or more data elements at a time to a given format. When multiple data elements are chosen, each is written out to an individual file, unless compression is turned on.
The standard export functionality can be launched using the Export button on the toolbar, or by going to the menu:
File | Export ()
An additional export tool is available from under the File menu:
File | Export with Dependent Elements
This tool is described further in section 6.4.2.
The general steps when configuring a standard export job are:
- (Optional) Select the data to export in the Navigation Area.
- Start up the exporter tool via the Export button in the toolbar or using the Export option under the File menu.
- Select the format the data should be exported to.
- Select the data to export, or confirm the data to export if it was already selected via the Navigation Area.
- Configure the parameters. This includes compression and naming of the output files, along with other format-specific settings where relevant.
- Select where the data should be exported to.
- Click on the button labeled Finish.
Selecting data for export - part I. You can select the data elements to export before you run the export tool or after the format to export to has been selected. If you are not certain which formats are supported for the data being exported, then we recommend selecting the data in the Navigation Area before launching the export tool.
Selecting a format to export to. When data is pre-selected in the Navigation Area before launching the export tool, then you will see a column in the export interface called Supported formats. Formats that the selected data elements can be exported to are indicated by a Yes in this column. Supported formats will appear at the top of the list of formats. See figure 6.16.
Figure 6.16: The Select exporter dialog where sequence lists were pre-selected in the Navigation Area before launching the export tool. Here, the formats sequence lists can be exported to are listed at the top, with a Yes in the Selected formats column. Other formats are found below, with No in this column.
Formats that the selected data cannot be exported to have a No listed in the Supported formats column. If you have selected multiple data elements of different types, then formats which can be used for some of the selected data elements but not all of them are indicated by the word Partly in this column.
Please note that the information in the Supported formats column only refers to the data already selected in the Navigation Area. If you are going to choose your data later in the export process, then the information in this column will not be pertinent.
Only one export format is available if you select a folder to be exported. This is described in more detail in section 6.4.1.
Finding a particular format in the list. You can quickly find a particular format by using the text box at the top of the exporter window as shown in figure 6.17, where formats that include the term VCF are searched for. This search term will remain in place the next time the Export tool is launched. Just delete the text from the search box if you no longer wish only the formats with that term to be listed.
When the desired export format has been identified, click on the button labeled Open.
Selecting data for export - part II. A dialog appears, with a name reflecting the format you choose. For example here, the "Variant Call Format" (VCF format) was selected, so the window is labeled "Export VCF".
If you are logged into a CLC Server, you will be asked whether to run the export job using the Workbench or the Server. After this, you are provided with the opportunity to select or de-select data to be exported.
In figure 6.18 we show the selection of a variant track for export to VCF format.
The parameters under Basic export parameters and File name are offered when exporting to any format. There may be additional parameters for particular export formats. This is illustrated here with the VCF exporter, where a reference sequence track must be selected. See figure 6.19.
Compression options. Within the Basic export parameters section, you can choose to compress the exported files. The options are no compression (None), gzip or zip format. Choosing zip format results in all data files being compressed into a single file. Choosing gzip compresses the exported file for each data element individually.
Choosing the exported file name(s) The default setting for the File name is to use the original data element name as the basename and the export format as the suffix.
When exporting just one data element, or exporting to a zip file, the desired filename could just be typed in the Custom file name box.
When working with the export of multiple files, using some combination of the terms shown by default in this field and in figure 6.20 are recommended. Clicking in the Custome file name field with them mouse and then simultaneously pressing the Shift + F1 keys bring up a list of the available terms that can be included in this field.
As you add or remove text and terms in the Custome file name field, the text in the Output file name field will change so you can see what the result of your naming choice will be for your data. When working with multiple files, only the name of the first one is shown. Just move the mouse cursor over the name shown in the Output file name field to show a listing of the all the filenames.
The last step is to specify the exported data should be saved (figure 6.21).
A note about decimals and Locale settings. When exporting to CSV and tab delimited files, decimal numbers are formatted according to the Locale setting of the Workbench (see General preferences). If you open the CSV or tab delimited file with spreadsheet software like Excel, you should make sure that both the Workbench and the spreadsheet software are using the same Locale.
- Export of folders and multiple elements in CLC format
- Export of dependent elements
- Export history
- The CLC format
- Backing up data from the CLC Workbench
- Export of workflow output