This shows you the differences between two versions of the page.
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)}} |