There are many ways to do an export:
- Export a Table using the export button (supported formats: {xlsx, xls, csv})
- Export data using Copy/Paste from the selected rows of a Table to an application like Excel.
- Export all data corresponding to an Identification Summary, Xic or SpectralCount
- Export an image of a view
- Export Identification Summary data into Pride (ProteomeXchange) format.
- Export Identification Summary spectra list.
To export a table, click on the Export Button at the left top of a table.
An Export Dialog is opened, you can select the file path for the export and the format of the export (supported formats: {xlsx, xls, csv}).
In case that the selected format is either .xls or .xlsx, the user has now the ability to maintain in his exported excel document any rich text format elements (color, font weight etc.) apparent on the original table in Proline Studio. Choice is done using the two radio buttons shown on the following screenshot.
To perform the export, click on the OK Button. The task can take a few seconds if the table has a lot of rows and so a progress bar is displayed.
To copy/Paste a Table:
- Select rows you want to copy
- Press Ctrl and C keys at the same time
- Open your spreadsheet editor and press Ctrl and V keys at the same time to paste the copied rows.
To Export all data of an Identification Summary, or of a XIC or a Spectral Count, you must right click on the dataset to open the contextual popup and select the “Export…” Menu.
You can also export multiple dataset simultaneously, if they have the same type (Identification Summary or XIC or Spectral Count).
An Export Dialog is opened, you can select the file path and the type of the export (Excel (.xlsx) or Tabulation Separated Values (.tsv)).
You can export with the default parameters or perform a custom export. To enable custom export, click on the tickbox located on the right of the dialog:
Custom export allows a number of parameters in addition to the file format to be chosen:
You can enable/disable individual sheets, rename them, rename individual fields and move then up and down, disable them. You can also save your own configuration and load it later on, and even share it with colleagues. (configuration file stored locally).
Description of exported file is available here.
To export a graphics, click on the Export Image Button at the left top of the image.
An Export Dialog is opened, you can select the file path for the export and the type of the export
Note: Before exporting data to Pride format, all spectrum matches should have been generated. To do so, right click on the dataset and select “Generate Spectrum Matches”.
To export all data of an Identification Summary into Pride (ProteomeXchange compatible) format, you must right click on the dataset to open the contextual popup and select the “Export to Pride…” Menu.
Some additional information could be specified (some of them are required, those with a *) in the displayed dialogs.
a. Experimental Details : Specify Project and Experiment name and contact
b. Protocol Description : Specify a name for the Protocol Description. Add at least one Step for the descritption by clicking on “Add Step” button.
An ontology search dialog will be opened to help getting protocol step description
c. Sample Description : Specify a sample name and description. Species, Tissue and Cell Type is specified using Controlled Vocabulary
. If desired data is not listed, you can click on the “other…” button to search through complete ontology.
To export valid PSM Spectra from an Identification Summary or from a XIC Dataset. The exported tsv file is compatible with Peakview