User Tools

Site Tools


how_to:generateamtdb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
how_to:generateamtdb [2012/02/29 09:39]
132.168.73.124
how_to:generateamtdb [2012/02/29 11:57]
132.168.73.124
Line 46: Line 46:
  
   * **__Table AMT__**: species of the exported User context   * **__Table AMT__**: species of the exported User context
 +    * AMT_ID: index for this AMT tag (generated)
 +    * AMTMonoisotopicMass:​ peptide calculated mass
 +    * NET: computed from peptide (aligned) retention time using the formula: NET = (rtSeconds/​60 - delayMinutes) / durationMinutes
 +    * PNET:
 +    * MSMS_Obs_Count:​
 +    * High_Normalized_Score:​ peptide score
 +    * High_Discriminant_Score:​
 +    * Sequence: peptide sequence
 +    * msidb_peptide_match_id:​ peptide_match_id used in MSIdb to create this AMT tag
   * **__Table AMT_Proteins__**:​ proteins on which species match   * **__Table AMT_Proteins__**:​ proteins on which species match
     * Protein_ID: protein identifier     * Protein_ID: protein identifier
Line 69: Line 78:
     * context_is_saved:​ is the exported context has been saved to MSIdb ?     * context_is_saved:​ is the exported context has been saved to MSIdb ?
     * msidb_context_id:​ context identifier in the MSIdb (look at this field only if the context has been saved to MSIdb)     * msidb_context_id:​ context identifier in the MSIdb (look at this field only if the context has been saved to MSIdb)
 +    * duration_minutes:​ analysis duration in minutes
 +    * delay_minutes:​ analysis delay in minutes
  
 UMCs tables are populated when using '​[[how_to:​includeumcinamtdb|Read UMCs]]'​ tool. UMCs tables are populated when using '​[[how_to:​includeumcinamtdb|Read UMCs]]'​ tool.
  
 {{:​how_to:​amtexport_relationsmsaccess.png|Relationships in the AMT database (MS Access)}} {{:​how_to:​amtexport_relationsmsaccess.png|Relationships in the AMT database (MS Access)}}
how_to/generateamtdb.txt · Last modified: 2012/02/29 12:30 by 132.168.73.124