change *.msf file into excel file
1
0
Entering edit mode
12 months ago
yueli7 ▴ 230

Hello

I have a *.msf file.

How I can change my protein *.msf file to the excel file?

Thanks in advance for great help!

Best,

Yue

$ sqlite3
SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open LD-CS-150113_OstromR_OR_AC2_enriched.msf
sqlite> .table
AminoAcidModifications                PeptidesProteins_decoy              
AminoAcidModificationsAminoAcids      PeptidesReferenceSpectra            
AminoAcidModificationsAminoAcidsNL    PeptidesTerminalModifications       
AminoAcidModificationsNeutralLosses   PeptidesTerminalModifications_decoy 
AminoAcids                            Peptides_decoy                      
AnnotationDataVersion                 PrecursorIonAreaSearchSpectra       
AnnotationDataset                     PrecursorIonQuanResults             
AnnotationGroups                      PrecursorIonQuanResultsSearchSpectra
AnnotationTypes                       ProcessingNodeConnectionPoints      
Annotations                           ProcessingNodeExtensions            
AnnotationsAnnotationGroups           ProcessingNodeFilterParameters      
AnnotationsProtein                    ProcessingNodeInterfaces            
Chromatograms                         ProcessingNodeParameters     
CustomDataPeptides_decoy              ProcessingNodesSpectra              
CustomDataProcessingNodes             ProteinAnnotations                  
CustomDataProteins                    ProteinIdentificationGroups         
CustomDataProteins_decoy              ProteinScores                       
CustomDataSpectra                     ProteinScores_decoy                 
Enzymes                               Proteins                            
EnzymesCleavageSpecificities          ProteinsProteinGroups               
EventAnnotations                      PtmAnnotationData                   
EventAreaAnnotations                  ReferenceSpectra                    
Events                                ReporterIonQuanResults              
FastaFiles                            ReporterIonQuanResultsSearchSpectra 
FastaFilesProteinAnnotations          ScanEvents                          
FileInfos                             SchemaInfo                          
MassPeakRelations                     Spectra                             
MassPeaks                             SpectrumHeaders                     
PeptideScores                         SpectrumScores                      
PeptideScores_decoy                   TaxonomyNames                       
Peptides                              TaxonomyNodes                       
PeptidesAminoAcidModifications        WorkflowInfo                        
PeptidesAminoAcidModifications_decoy  WorkflowMessages                    
PeptidesProteins
sequence • 292 views
ADD COMMENT
0
Entering edit mode

If @Pierre's answer did not address your question then please unmark it as accepted.

ADD REPLY
0
Entering edit mode

Answered by @yueli7 in a parallel thread: A: How I can get all the information of proteins?

ADD REPLY
1
Entering edit mode
12 months ago
echo ".tables" | sqlite3  db.sqlite  | tr -s " " | tr " " "\n" | while read T; do echo "select * from $T ;" | sqlite3 -header -separator $'\t' db.sqlite > ${T}.tsv ; done

and ... do not use excel.

ADD COMMENT
0
Entering edit mode

Hello Pierre,

Thank you so much for your great help.

It seems do not have any response. What can I do in next step?

Thank you again for your great help!

Best,

Yue

p0xxx:~$ sqlite3

SQLite version 3.22.0 2018-01-22 18:45:57

Enter ".help" for usage hints.

Connected to a transient in-memory database.

Use ".open FILENAME" to reopen on a persistent database.

sqlite> .open OstromR_Set7_Enriched.msf

sqlite> .table

AminoAcidModifications                PeptidesProteins_decoy              
AminoAcidModificationsAminoAcids      PeptidesReferenceSpectra            
AminoAcidModificationsAminoAcidsNL    PeptidesTerminalModifications       
AminoAcidModificationsNeutralLosses   PeptidesTerminalModifications_decoy 
AminoAcids                            Peptides_decoy                      
AnnotationDataVersion                 PrecursorIonAreaSearchSpectra       
AnnotationDataset                     PrecursorIonQuanResults             
AnnotationGroups                      PrecursorIonQuanResultsSearchSpectra
AnnotationTypes                       ProcessingNodeConnectionPoints      
Annotations                           ProcessingNodeExtensions            
AnnotationsAnnotationGroups           ProcessingNodeFilterParameters      
AnnotationsProtein                    ProcessingNodeInterfaces            
Chromatograms                         ProcessingNodeParameters            
CustomDataFields                      ProcessingNodeScores                
CustomDataPeptides                    ProcessingNodes                     
CustomDataPeptides_decoy              ProcessingNodesSpectra              
CustomDataProcessingNodes             ProteinAnnotations                  
CustomDataProteins                    ProteinIdentificationGroups         
CustomDataProteins_decoy              ProteinScores                       
CustomDataSpectra                     ProteinScores_decoy                 
Enzymes                               Proteins                            
EnzymesCleavageSpecificities          ProteinsProteinGroups               
EventAnnotations                      PtmAnnotationData                   
EventAreaAnnotations                  ReferenceSpectra                    
Events                                ReporterIonQuanResults              
FastaFiles                            ReporterIonQuanResultsSearchSpectra 
FastaFilesProteinAnnotations          ScanEvents                          
FileInfos                             SchemaInfo                          
MassPeakRelations                     Spectra                             
MassPeaks                             SpectrumHeaders                     
PeptideScores                         SpectrumScores                      
PeptideScores_decoy                   TaxonomyNames                       
Peptides                              TaxonomyNodes                       
PeptidesAminoAcidModifications        WorkflowInfo                        
PeptidesAminoAcidModifications_decoy  WorkflowMessages                    
PeptidesProteins 

sqlite> echo "1.tables" | sqlite3  db.sqlite  | tr -s " " | tr " " "\n" | while read T; do echo "select * from $T ;" | sqlite3 -header -separator $'\t' db.sqlite > ${T}.tsv ; done
ADD REPLY

Login before adding your answer.

Traffic: 2163 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6