Question: change *.msf file into excel file
0
gravatar for yueli7
7 days ago by
yueli7190
China
yueli7190 wrote:

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 • 85 views
ADD COMMENTlink modified 7 days ago by Pierre Lindenbaum131k • written 7 days ago by yueli7190

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

ADD REPLYlink written 4 days ago by genomax92k

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

ADD REPLYlink written 2 days ago by genomax92k
1
gravatar for Pierre Lindenbaum
7 days ago by
France/Nantes/Institut du Thorax - INSERM UMR1087
Pierre Lindenbaum131k wrote:
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 COMMENTlink written 7 days ago by Pierre Lindenbaum131k

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 REPLYlink modified 2 days ago by _r_am31k • written 4 days ago by yueli7190
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1330 users visited in the last hour