Is there any availiable tool for export skyline results and deal with the results?

16622080827

2020-12-02 04:17

I find the exported results format is just liake this:
Protein Name Protein Accession Peptide Modified Sequence Point Count Protein Gene Replicate Name
sp|A0AVT1|UBA6_HUMAN A0AVT1 M[+42]EGSEPVAAHQGEEASC[+57]SSWGTGSTNK 0 UBA6 500ng_1
sp|A0AVT1|UBA6_HUMAN A0AVT1 M[+42]EGSEPVAAHQGEEASC[+57]SSWGTGSTNK 0 UBA6 500ng_2
sp|A0AVT1|UBA6_HUMAN A0AVT1 M[+42]EGSEPVAAHQGEEASC[+57]SSWGTGSTNK 0 UBA6 500ng_3
sp|A0AVT1|UBA6_HUMAN A0AVT1 YQC[+57]VVLTEMK 0 UBA6 500ng_1
sp|A0AVT1|UBA6_HUMAN A0AVT1 YQC[+57]VVLTEMK 0 UBA6 500ng_2
sp|A0AVT1|UBA6_HUMAN A0AVT1 YQC[+57]VVLTEMK 0 UBA6 500ng_3

But actually，I want the result like this:
Protein Name Protein Accession Peptide Modified Sequence 500ng_1 500ng_2 500ng_3

This format is more friendly for my data analysis.So is there any .skyr file for exporting the quantification in both protein and peptide level?I know that skyline support exporting the results mannuly.But there're too many informations here.So I want some useful information by default. And for the data format transformation,is there any avalible tools here?

Nick Shulman responded:	2020-12-02 05:01
I think you will find useful information in the Custom Reports tutorial: https://skyline.ms/wiki/home/software/Skyline/page.view?name=tutorial_custom_reports On page 6 of the tutorial it talks about using the "Pivot Replicate Name" checkbox so that you get one row per peptide, and the data columns repeat horizontally for each replicate. Skyline has another feature called the "Pivot Editor" which lets you do more complicated transformations involving summing or averaging. You can read about the Pivot Editor here: https://skyline.ms/wiki/home/software/Skyline/page.view?name=PivotEditor -- Nick