Protein Purification Table: Specific Activity, Yield, and Purification Fold Calculator

Enter volume, protein concentration, and activity for each purification step; calculates specific activity, yield, and purification fold and generates a publication-ready table.

Step data (one step per line, four columns: step name / volume mL / protein concentration mg·mL⁻¹ / activity U·mL⁻¹, columns separated by Tab; paste directly from Excel)

Activity unit (affects column header only)

Formulas and Core Logic

A Protein Purification Table is a standard bookkeeping tool in biochemistry. It tracks total protein and target activity at each step from crude extract to purified protein, letting you quantify purification performance. Each step requires three measurements: sample volume V (mL), protein concentration per unit volume c_p (mg/mL), and enzyme activity per unit volume a (U/mL). From these, five standard quantities are derived:

Total protein (mg)        = V × c_p
Total activity (U)        = V × a
Specific activity (U/mg)  = Total activity / Total protein
Yield (%)                 = Total activity at this step / Total activity at step 1 × 100
Purification fold         = Specific activity at this step / Specific activity at step 1

Step 1 (typically crude extract or clarified lysate) is defined as 100% yield and 1.00-fold purification. These five formulas are standard content in biochemistry textbooks (Stryer, Lehninger, Current Protocols in Protein Science), contain no approximations or empirical parameters, and apply to any enzyme.

Why You Cannot Compare Activity Readings Directly

Enzyme activity per unit volume (U/mL) is not directly comparable across steps, because collection volumes differ enormously — a crude extract may be 100 mL while a final gel-filtration peak may be only 3 mL. You must first multiply by volume to get totals, then compare the fraction retained. This is the most common and most insidious error in purification tables: using U/mL directly to calculate yield will almost always underestimate true recovery.

Scope

Applicable when: - You have enzyme activity data (spectrophotometric, fluorometric, luminometric, etc.) measured under identical conditions throughout the same protocol; - Protein concentration is measured by the same method (Bradford, BCA, or A280) consistently across all steps; - The volume recorded for each step is the volume of the collected target peak, not the total eluate.

Not applicable, or requires modification: - Target protein has no catalytic activity (structural proteins, antibodies, etc.): you can substitute ELISA readings, ligand-binding quantities, or similar measurements for the “activity” column — the formulas are unchanged, but the surrogate metric must be stated explicitly; - Protein quantification method changes between steps (e.g., BCA for crude extract, A280 for later steps): readings from different methods are not comparable, and the yield becomes meaningless; - A single step yields multiple elution peaks: record each peak separately; do not pool all peaks into one row.

Common Mistakes

Forgetting to multiply by volume: Treating U/mL as “total activity” directly in the table will severely distort the yield.
Confusing collection volume: Using the total eluate volume from a column (including unbound flow-through) instead of the volume of the collected target peak.
Misinterpreting yield > 100%: Seeing a yield above 100% and assuming a calculation error — in fact, this can occur when inhibitors in the crude extract are removed, releasing apparent activity. This is a legitimate result; keep the value as is.
Mixing activity data across batches: When activity assays are run on different days or with slightly different standards, combining data from different batches into one table introduces systematic error that makes yield and purification fold incomparable.

Verifiable Example

A three-step purification scheme, using input values identical to those preloaded in the tool:

Step	Volume (mL)	Protein (mg/mL)	Activity (U/mL)
Crude extract	50	8.5	120
Ammonium sulfate precipitation	15	20.0	340
DEAE ion exchange	5	2.5	960

Expected output:

Step	Total protein (mg)	Total activity (U)	Specific activity (U/mg)	Yield (%)	Purification fold
Crude extract	425.0	6000	14.12	100.0	1.00
Ammonium sulfate precipitation	300.0	5100	17.00	85.0	1.20
DEAE ion exchange	12.5	4800	384.00	80.0	27.20

Manual check — DEAE step: total protein = 5 × 2.5 = 12.5 mg, total activity = 5 × 960 = 4800 U, specific activity = 4800 ÷ 12.5 = 384.0 U/mg, yield = 4800 ÷ 6000 × 100 = 80.0%, purification fold = 384.0 ÷ 14.12 = 27.20 (the value the tool shows). These numbers are realistic for an actual ion-exchange experiment: total protein drops by 97% while activity loss is only 20%, indicating that very little target protein was lost in the flow-through and most was selectively eluted.

FAQ

Why is the yield at step 1 defined as 100% rather than a true recovery?

The "yield" in a purification table uses step 1 (crude extract) total activity as the reference baseline, defined as 100%. It is a relative recovery, not an absolute one. There is no way to measure "all recoverable activity" before the first step, so using the first measurable step as the denominator is the standard convention. It does not imply zero loss at that step.

Is it normal for yield to exceed 100% at an intermediate step?

Yes. Crude extracts often contain proteases, inhibitors, or factors that complex with the target protein; removing them can increase apparent activity and temporarily push yield above 100%. This is seen most commonly after ammonium sulfate precipitation or ultrafiltration, and is not a calculation error.

High purification fold but single-digit yield — how should I interpret this?

Purification fold tracks the increase in specific activity; yield tracks total activity retained. The two typically trade off. High fold with low yield means purity is approaching homogeneity but total quantity loss is severe. At that point, evaluate whether another purification step is truly needed, or whether optimizing elution conditions could reduce losses.

My target protein has no enzyme activity — can I use this tool?

Not directly, because specific activity is defined in terms of enzyme activity. If the target protein has no catalytic activity, you can substitute ELISA readings, ligand-binding quantities, or fluorescence intensity for the "activity" column. The formulas are unchanged, but you must state the surrogate metric's units and meaning in your paper and note that it does not represent catalytic activity.