Getting Peak Area values table from Panorama

support
Getting Peak Area values table from Panorama chittineni  2025-02-21 11:34:38
 

I'm looking to download a table from Panorama that includes retention time and peak area for each peptide, similar to the transition results table that can be exported from Skyline. Does anyone know how I can obtain this type of data from Panorama?

 
 
chittineni responded:  2025-02-25 18:06:36

Hello,

You can get that through some of the tables that Panorama exposes. These instructions assume you're a folder admin where you want to extract the data:

Click on the Gear in the upper right, then Go to Module->Query.
Choose the "targetedms" schema.
Choose either "PrecursorChromInfo" or "TransitionChromInfo" depending on whether you want precursor- or transition-level data.
Click the View Data link.

You'll see one row per precursor or transition and replicate.

You can customize the grid display to remove or add columns:

https://www.labkey.org/Documentation/wiki-page.view?name=customViews

You can export to Excel, TSV, CSV, etc. You can also get a code snippet to access the data programmatically through Python, R, etc.

https://www.labkey.org/Documentation/wiki-page.view?name=exportData

Thanks,
Josh

 
jeckels responded:  2025-02-25 18:07:35

Apologies - I was impersonating your account when I replied! I was double-checking your access to make sure the instructions should apply.

Thanks,
Josh