Technical Overview, mem peptides table

The mem_peptides table in the peakdb database is used to generate the MRM displays for protein and peptide information in GPMDB.

The main difference between this table and the other tables that make up the GPM is that it is a memory table; the contents of this table reside in the database server's memory, to increase the response time for queries involving these tables.

The contents of this table are updated manually, when new source data files are generated.

Columns:

• id: the unique identifier for a row of data. This id column corresponds to the peptide with the same id value in the mem_peak_info table, so these two tables will always have the same number of rows.
• mass: the mass of the peptide, in Daltons.
• charge: the charge state of the peptide at detection in the instrument used to generate the data files which populated peakdb.
• seq: the residue sequence of the peptide.