This document can be used to prepare or evaluate feasibility of ancillary study proposals and paper proposals, but is NOT intended for publication.

Specimen Assays

File NameData as ofPopulationData collectedOne row perRows
spec_tests_ctos_inv.dat5/26/2026N/ABaseline, Main, Ext1, Ext2Specimen Test1,293

This file contains details about the assays referred to in spec_results_ctos_inv.dat. This file has one row for each version of an assay. Assays are assigned version numbers based on variations of lab/specimen type or method. e.g. if the GLUCOSE assay has results from two labs there would be two rows in this file, both rows would have the same TESTABBR, TESTNAME and TESTDESC values but the other columns would vary by version.

TESTVERID - Test version ID
Col 1

Unique identifier of the test name and test version.

NMissingMinMaxMeanStdDev
1,2930137,63819,152.27415,057.587
TESTABBR - Test abbreviation
Col 2
Usage Notes:

e.g. CRP, GLUC.

NMissing
1,2930
TESTVER - Test version
Col 3

A new version number is assigned for every change in lab, specimen type, units or method. e.g. if we have results from two different labs for a glucose assay, each would get its own version number. GLUC V1 & GLUC V2.

NMissingMinMaxMeanStdDev
1,29301442.94.247
TESTNAME - Test Name
Col 4
NMissing
1,2930
TESTDESC - Test Description
Col 5

Short description of the test.

NMissing
1,2930
TESTMTHD - Test Method
Col 6
Usage Notes:

Some test methods are not available.

NMissing
1,24152
TESTUNITS - Test Units
Col 7
NMissing
1,2930
TESTCMNTS - Test Comments
Col 8
NMissing
600693
SPECTYPE - Specimen Type
Col 9
NMissing
1,2930
LABNAME - Lab Name
Col 10
NMissing
1,2930
VERCOUNT - Number of rows in result file for this test/version
Col 11
NMissingMinMaxMeanStdDev
1,29301243,3722,797.03513,825.111
TESTVALMED - Median of TESTVAL
Col 12

The median of TESTVAL in specimen results file (spec_results) for this test/version.

NMissingMinMaxMeanStdDev
1,2930033,467,50083,989.8431,348,161.067
TESTVALSTD - Standard deviation of TESTVAL
Col 13

The standard deviation of TESTVAL in specimen results file (spec_results) for this test/version.

NMissingMinMaxMeanStdDev
1,2930050,174,734.5593,621.5241,692,378.058
NUMDUPPAIRS - Number of blind duplicate pairs
Col 14

Number of blind duplicate pairs used to calculate DUPAVGCV and DUPCORR.

Usage Notes:

See the Specimen Results readme documentation for a discussion of "blinded duplicate" samples used for QC.

NMissingMinMaxMeanStdDev
1,14015331,07592.543137.231
DUPCORR - Coefficient of correlation of blinded duplicates
Col 15

The correlation of result values over ALL duplicate pairs for this test version.

NMissingMinMaxMeanStdDev
1,118175-0.5810.8560.211
DUPAVGCV - Average Coefficient of Variation (%) of duplicate pairs
Col 16
Usage Notes:

Coefficient of Variation (stddev/avg) is calculated for EACH duplicate pair.

NMissingMinMaxMeanStdDev
1,140153077.3914.71313.584
DUPMINCV - Minumum Coefficient of Variation (%) of duplicate pairs
Col 17
Usage Notes:

Coefficient of Variation (stddev/avg) is calculated for EACH duplicate pair.

NMissingMinMaxMeanStdDev
1,140153-552.8627.08-0.68521.159
DUPMAXCV - Maximum Coefficient of Variation (%) of duplicate pairs
Col 18
Usage Notes:

Coefficient of Variation (stddev/avg) is calculated for EACH duplicate pair.

NMissingMinMaxMeanStdDev
1,14015301,495.1763.79963.727