This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
how_to:generateamtdb [2012/02/29 12:01] 132.168.73.124 |
how_to:generateamtdb [2012/02/29 12:30] (current) 132.168.73.124 |
||
---|---|---|---|
Line 2: | Line 2: | ||
:!: **Requirements** \\ | :!: **Requirements** \\ | ||
- | Context have to be **[[how_to:proteingrouping|grouped]]** previously. | + | * Context have to be **[[how_to:proteingrouping|grouped]]** previously. You generally apply some filtering during and/or after the protein grouping step to suppress: |
- | You may want apply some filters during this step: | + | * Reverse proteins |
- | * Reverse proteins | + | * Species with a sequence < 7 |
- | * Species with a sequence < 7 | + | * Proteins identified by only 1 species with a score < 60 |
- | * Proteins identified by only 1 species with a score < 60 | + | * **[[how_to:alignretentiontime|Retention time alignment]]** & **[[how_to:recomputeretentiontime|retention time recomputing]]** algorithms may have to be run before creating |
- | + | * Save your MSIdb | |
- | :!: **Notes** \\ | + | \\ |
- | **[[how_to:alignretentiontime|Retention time alignment]]** & **[[how_to:recomputeretentiontime|retention time recomputing]]** algorithms may have to be run before creating | + | \\ |
- | + | \\ | |
- | + | To generate a new AMT database in the MS Access format (.mdb file) from a given User context, follow these steps: | |
- | + | ||
- | To generate a new AMT database in the MS Access format (.mdf file) from a given User context, follow these steps: | + | |
{{ :amtexport_menu.png|Export a context to a new AMT database}} | {{ :amtexport_menu.png|Export a context to a new AMT database}} | ||
Line 26: | Line 24: | ||
* A confirmation dialog will indicate when saving process is finished.\\ | * A confirmation dialog will indicate when saving process is finished.\\ | ||
{{:amtexportconfirmdialog.png|}} | {{:amtexportconfirmdialog.png|}} | ||
- | |||
- | ===== AMT database filters & Details about some field calculations ===== | ||
- | |||
- | How specific values are calculated: | ||
- | * MonoistopicMass: calculated_mass | ||
- | * NET: (Retention Time/60)-delay)/duration (delay & duration are information entered by user, retention time is expected in seconds) | ||
- | * PNET : null | ||
- | * MS_MS_Obs_Count: # of child species | ||
- | * sequence: species sequence | ||
- | * High_Normalized_Score: score (max of child species scores) | ||
- | * High_Discriminant_Score: null | ||
===== AMT database model ===== | ===== AMT database model ===== | ||
Line 45: | Line 32: | ||
* AMT_ID: index for this AMT tag (generated) | * AMT_ID: index for this AMT tag (generated) | ||
* AMTMonoisotopicMass: peptide calculated mass | * AMTMonoisotopicMass: peptide calculated mass | ||
- | * NET: computed from peptide (aligned) retention time using the formula: NET = (rtSeconds/60 - delayMinutes) / durationMinutes | + | * NET: computed from peptide (aligned) retention time using the formula: NET = (retentionTimeSeconds/60 - delayMinutes) / durationMinutes |
- | * PNET: | + | * PNET: null |
- | * MSMS_Obs_Count: | + | * MSMS_Obs_Count: # of child species |
- | * High_Normalized_Score: peptide score | + | * High_Normalized_Score: score (max of child peptides scores) |
- | * High_Discriminant_Score: | + | * High_Discriminant_Score: null |
* Sequence: peptide sequence | * Sequence: peptide sequence | ||
- | * msidb_peptide_match_id: peptide_match_id used in MSIdb to create this AMT tag | + | * **NEW** :!: **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 75: | Line 62: | ||
* 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 | + | * **NEW** :!: **duration_minutes**: analysis duration in minutes |
- | * delay_minutes: analysis delay in minutes | + | * **NEW** :!: **delay_minutes**: analysis delay in minutes |
:!: **Notes**: | :!: **Notes**: | ||
* UMCs tables were populated using '[[how_to:includeumcinamtdb|Read UMCs]]' tool until hEIDI 1.12.0.\\ | * UMCs tables were populated using '[[how_to:includeumcinamtdb|Read UMCs]]' tool until hEIDI 1.12.0.\\ | ||
- | * Since hEIDI 1.13.0, UMCs result files are included into MSIdb (instead of AMTdb) | + | * Since hEIDI 1.13.0, [[how_to:importumctomsidb|UMCs result files are included into MSIdb]] (instead of AMTdb) |
{{:how_to:amtexport_relationsmsaccess.png|Relationships in the AMT database (MS Access)}} | {{:how_to:amtexport_relationsmsaccess.png|Relationships in the AMT database (MS Access)}} |