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.dat3/14/2023N/ABaseline, Main, Ext1, Ext2Specimen Test1,242

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,2420135,85018,416.84414,909.439
TESTABBR - Test abbreviation
Col 2
Usage Notes:

e.g. CRP, GLUC.

NMissing
1,2420
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,24201342.7373.665
TESTNAME - Test Name
Col 4
NMissing
1,2420
TESTDESC - Test Description
Col 5

Short description of the test.

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

Some test methods are not available.

NMissing
1,21626
TESTUNITS - Test Units
Col 7
NMissing
1,2420
TESTCMNTS - Test Comments
Col 8
NMissing
591651
SPECTYPE - Specimen Type
Col 9
NMissing
1,2420
LABNAME - Lab Name
Col 10
NMissing
1,2420
VERCOUNT - Number of rows in result file for this test/version
Col 11
NMissingMinMaxMeanStdDev
1,24201243,3722,756.2914,098.226
TESTVALMED - Median of TESTVAL
Col 12

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

NMissingMinMaxMeanStdDev
1,2420033,467,50087,405.5431,375,476.261
TESTVALSTD - Standard deviation of TESTVAL
Col 13

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

NMissingMinMaxMeanStdDev
1,2420050,174,734.5597,451.7171,726,695.015
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,11812431,07591.736137.758
DUPCORR - Coefficient of correlation of blinded duplicates
Col 15

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

NMissingMinMaxMeanStdDev
1,096146-0.5810.8560.212
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,118124077.3914.77913.623
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,118124-552.8627.08-0.70721.366
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,11812401,495.1763.90464.131