How do we handle "toxic, no revertant colonies"? (LAK will add 6 records with GTSTAT = NOT DONE, GTREASND = "TOO MUCH CYTOTOXICITY,"
When "-" in Mean, Std Dev, Fold Inc - refer to SEND team's marked-up table (GTSTAT = NOT DONE; variety of REASND)
recreate the data table - clean up, add "S" to the first set A
move assumptions out of all of the examples
add row captions to highlight exceptions/assumptions
This is an example showing trial design and results from the in vitro bacterial reverse mutation test of Study #8325064. The bacterial reverse mutation test uses four different amino acid-requiring strains of Salmonella typhimurium (S. typhimurium) and one strain of Escherichia coli (E. coli) to detect point mutations, which involve substitution, addition or deletion of one or a few DNA base pairs. The principle of this bacterial reverse mutation test is that it detects chemicals that induce mutations which revert mutations present in the S typhimurium and E. colitester strains and restore the functional capability of the bacteria to synthesize an essential amino acid. The revertant bacteria are detected by their ability to grow in the absence of the amino acid required by the parent tester strain.
Assumption: When the experimental unit is derived from the species and strain, such as a cell line, then TESTSYS should be supplied.
Row
STUDYID
ASSAYID
DOMAIN
TSSEQ
TSGRPID
TSPARMCD
TSPARM
TSVAL
TSVALNF
1
8325064
Ames
TS
1
GLPTYP
Good Laboratory Practice Type
FDA
2
8325064
Ames
TS
2
GLPTYP
Good Laboratory Practice Type
OECD
3
8325064
Ames
TS
1
STSTDTC
Study Start Date
2015-07-29
4
8325064
Ames
TS
1
STITLE
Study Title
The Bacterial Reverse Mutation Test, Study 8325064-1
5
8325064
Ames
TS
1
SNDIGVER
SEND Implementation Guide Version
TOBACCO IMPLEMENTATION GUIDE VERSION 1.0
6
8325064
Ames
TS
1
SNDCTVER
SEND Controlled Terminology Version
SEND Terminology 2021-09-30
7
8325064
Ames
TS
1
SSPONSOR
Sponsor Organization
Example Sponsor Inc.
8
8325064
Ames
TS
1
SPREFID
Sponsor's Study Reference ID
NOT APPLICABLE
9
8325064
Ames
TS
1
1
TSTFNAM
Test Facility Name
Example Tox Lab Name
10
8325064
Ames
TS
1
1
TSTFLOC
Test Facility Location
10 Somewhere Street, Montgomery, AL 10000
11
8325064
Ames
TS
1
1
TFCNTRY
Test Facility Country
USA
12
8325064
Ames
TS
1
1
STDIR
Study Director
Dr. R. Smith
13
8325064
Ames
TS
1
GLPFL
GLP Flag
N
14
8325064
Ames
TS
1
ASTD
Assay Standard
OECD Test No. 471
15
8325064
Ames
TS
1
ASTDV
Assay Standard Version
2020-06-29
16
8325064
Ames
TS
1
SSTYP
Study Type
GENOTOXICITY IN VITRO
17
8325064
Ames
TS
1
SSSTYP
Study Sub Type
Bacterial Reverse Mutation Test
18
8325064
Ames
TS
1
2
SPECIES
Species
Salmonella
19
8325064
Ames
TS
1
2
STRAIN
Strain
TA98
20
8325064
Ames
TS
1
2
STRAIN
Strain
TA100
21
8325064
Ames
TS
1
2
STRAIN
Strain
TA1535
22
8325064
Ames
TS
1
2
STRAIN
Strain
TA1537
23
8325064
Ames
TS
1
3
SPECIES
Species
Escherichia coli
24
8325064
Ames
TS
1
3
STRAIN
Strain
WP2 uvrA pKM101
Rows 1-22:
Show trial set parameters and trial set values that comprise the test conditions for the set SetA. SetA is the data for the vehicle control (i.e., a concentration level of 0) as shown in the first row, labeled "SetA", in the table Raw Data for Study 8325064.
Rows 23-4:
Rows 6-7:
Row 13:
Rows 1, 6:
Row Captions Debug Message
Please provide a caption for every row caption label.
$titleHtml
tx.xpt trial sets.xpt
Row
STUDYID
ASSAYID
DOMAIN
SETCD
SET
TXSEQ
TXPARMCD
TXPARM
TXVAL
1
8325064
Ames
TX
SetA
A-TA98-C0
1
SPECIES
Species
Salmonella typhimurium
2
8325064
Ames
TX
SetA
A-TA98-C0
2
STRAIN
Strain/Substrain
TA98
3
8325064
Ames
TX
SetA
A-TA98-C0
3
METACT
Metabolic Activation
4
8325064
Ames
TX
SetA
A-TA98-C0
4
METACTFL
Y/N presence of metabolic activation
N
5
8325064
Ames
TX
SetA
A-TA98-C0
5
TRTDMIN
Treatment Duration Minimum
71.5
6
8325064
Ames
TX
SetA
A-TA98-C0
6
TRTDTRG
Treatment Duration Target
72
7
8325064
Ames
TX
SetA
A-TA98-C0
7
TRTDMAX
Treatment Duration Maximum
72.5
8
8325064
Ames
TX
SetA
A-TA98-C0
8
TRTDU
Treatment Duration Unit
HOURS
9
8325064
Ames
TX
SetA
A-TA98-C0
9
INCBTMP
Incubation Temperature
37
10
8325064
Ames
TX
SetA
A-TA98-C0
10
INCBTMPU
Incubation Temperature Unit
C
11
8325064
Ames
TX
SetA
A-TA98-C0
11
HUMID
Atmospheric Relative Humidity Percent
50
12
8325064
Ames
TX
SetA
A-TA98-C0
12
ATMCO2
Atmospheric CO2 Percent
5
13
8325064
Ames
TX
SetA
A-TA98-C0
13
SPTOBID
Sponsor defined tobacco identifier
CIG01a
14
8325064
Ames
TX
SetA
A-TA98-C0
14
EXPTYP
Exposure Type (See TIG NC workstream minutes 30-Jan here: Nonclinical)
Submerged
15
8325064
Ames
TX
SetA
A-TA98-C0
15
SAMTYP
Sample Type
Total Particulate Matter in PBS
16
8325064
Ames
TX
SetA
A-TA98-C0
16
INTRVN
name of the intervention article
TA1
17
8325064
Ames
TX
SetA
A-TA98-C0
17
ITVTYPE
type of intervention article
Vehicle Control
18
8325064
Ames
TX
SetA
A-TA98-C0
18
ITVCONC
Concentration of intervention article
0
19
8325064
Ames
TX
SetA
A-TA98-C0
19
ITVCONCU
Concentration Unit
ug/plate
20
8325064
Ames
TX
SetA
A-TA98-C0
20
TRTV
Treatment Vehicle
DMSO
21
8325064
Ames
TX
SetA
A-TA98-C0
21
SPDEVID
Sponsor defined device identifier
PUFFMASTER3K
22
8325064
Ames
TX
SetA
A-TA98-C0
22
DUREFID
Smoke Regimen
Medium Intensity Regimen
23
8325064
Ames
TX
SetF
F-TA98-C500
1
SPECIES
Species
Salmonella typhimurium
24
8325064
Ames
TX
SetF
F-TA98-C500
2
STRAIN
Strain/Substrain
TA98
25
8325064
Ames
TX
SetF
F-TA98-C500
3
METACT
Metabolic Activation
26
8325064
Ames
TX
SetF
F-TA98-C500
4
METACTFL
Y/N presence of metabolic activation
N
27
8325064
Ames
TX
SetF
F-TA98-C500
5
TRTDMIN
Treatment Duration Minimum
71.5
28
8325064
Ames
TX
SetF
F-TA98-C500
6
TRTDTRG
Treatment Duration Target
72
29
8325064
Ames
TX
SetF
F-TA98-C500
7
TRTDMAX
Treatment Duration Maximum
72.5
30
8325064
Ames
TX
SetF
F-TA98-C500
8
TRTDU
Treatment Duration Unit
HOURS
31
8325064
Ames
TX
SetF
F-TA98-C500
9
INCBTMP
Incubation Temperature
37
32
8325064
Ames
TX
SetF
F-TA98-C500
10
INCBTMPU
Incubation Temperature Unit
C
33
8325064
Ames
TX
SetF
F-TA98-C500
11
HUMID
Atmospheric Relative Humidity Percent
50
34
8325064
Ames
TX
SetF
F-TA98-C500
12
ATMCO2
Atmospheric CO2 Percent
5
35
8325064
Ames
TX
SetF
F-TA98-C500
13
SPTOBID
Sponsor defined tobacco identifier
CIG01a
36
8325064
Ames
TX
SetF
F-TA98-C500
14
EXPTYP
Exposure Type (See TIG NC workstream minutes 30-Jan here: Nonclinical)
Submerged
37
8325064
Ames
TX
SetF
F-TA98-C500
15
SAMTYP
Sample Type
Total Particulate Matter in PBS
38
8325064
Ames
TX
SetF
F-TA98-C500
16
INTRVN
name of the intervention article
TA1
39
8325064
Ames
TX
SetF
F-TA98-C500
17
ITVTYPE
type of intervention article
Vehicle Control
40
8325064
Ames
TX
SetF
F-TA98-C500
18
ITVCONC
Concentration of intervention article
0
41
8325064
Ames
TX
SetF
F-TA98-C500
19
ITVCONCU
Concentration Unit
ug/plate
42
8325064
Ames
TX
SetF
F-TA98-C500
20
TRTV
Treatment Vehicle
DMSO
43
8325064
Ames
TX
SetF
F-TA98-C500
21
SPDEVID
Sponsor defined device identifier
PUFFMASTER3K
44
8325064
Ames
TX
SetF
F-TA98-C500
22
DUREFID
Smoke Regimen
Medium Intensity Regimen
45
46
47
48
8325064
Ames
TX
SetG (row 7) do G not I!!!
METACT
Metabolic Activation (should there be two parms? Presence, type)?
None
8325064
Ames
TX
SetG
TRTDRTRG
Treatment Duration target. (how do we show 3-6 hour range? start/end, target and tolerance?, one text field not-analyzable)
8325064
Ames
TX
SetG
TRTDRTOL
Treatment Duration Tolerance
8325064
Ames
TX
SetG
TRTDURU
Treatment Duration Unit (this is for both TRTDURT, TRTDURTOL)
8325064
Ames
TX
SetG
INTRVN
name of the intervention article
(Tobacco ProdA, Bleomycin or Cyclophosphamid A)
2-Nitrofluorine
8325064
Ames
TX
SetG
ITVTYPE
type of intervention article
choices of values: product; negative control; positive control
Positive Control
8325064
Ames
TX
SetG
ITVCONC
Concentration of intervention article
5
8325064
Ames
TX
SetG
ITVCONCU
Concentration Unit
ug/plate
8325064
Ames
TX
SetG
REGIME
Smoking Regime
ISO
...
SetG
8325064
Ames
TX
SetR
(Row 18)
METACT
Metabolic Activation (should there be two parms? Presence, type)?
None
8325064
Ames
TX
SetR
TRTDRTRG
Treatment Duration target. (how do we show 3-6 hour range? start/end, target and tolerance?, one text field not-analyzable)
8325064
Ames
TX
SetR
TRTDRTOL
Treatment Duration Tolerance
8325064
Ames
TX
SetR
TRTDURU
Treatment Duration Unit (this is for both TRTDURT, TRTDURTOL)
8325064
Ames
TX
SetR
INTRVN
name of the intervention article
(Tobacco ProdA, Bleomycin or Cyclophosphamid A)
4-Nitroquinoline-1-oxide
8325064
Ames
TX
SetR
ITVTYPE
type of intervention article
choices of values: product; negative control; positive control
Positive Control
8325064
Ames
TX
SetR
ITVCONC
Concentration of intervention article
2
8325064
Ames
TX
SetR
ITVCONCU
Concentration Unit
ug/plate
8325064
Ames
TX
SetR
STRAIN
Strain/Substrain
TA98
8325064
Ames
TX
SetR
REGIME
Smoking Regime
ISO
$warningHtml
Dataset Wrapper Debug Message
Please add a row column to your dataset.
Observational Unit Identifiers (OBUIDs) are defined by the sponsor to uniquely identify the observational unit within an experimental unit. In this example the sponsor chose to define the EUIDs based on trial sets (e.g., F) and OBUIDs based on the position of the tube in one of multiple exposure/incubation plates (e.g, 6_1 for plate 6, position 1).
Rows 1-5:
Show the values for OBUID within the experimental unit identifier, A, for Set A, as defined in the trial set dataset.
Rows 6-8:
Show the values for OBUID within the experimental unit identifier, F, for Set F, as defined in the trial set dataset.
Rows 9-11:
Show the values for OBUID within the experimental unit identifier, G, for Set G, as defined in the trial set dataset.
Rows 12-14:
Show the values for OBUID within the experimental unit identifier, R, for Set R, as defined in the trial set dataset.
$titleHtml
ou.xpt observational and experimentat unit identifiers.xpt
Row
STUDYID
ASSAYID
DOMAIN
SETCD
EUID
OBUID
1
8325064
Ames
OU
SetA
A
0_1
2
8325064
Ames
OU
SetA
A
0_2
3
8325064
Ames
OU
SetA
A
0_3
4
8325064
Ames
OU
SetA
A
0_4
5
8325064
Ames
OU
SetA
A
0_5
6
8325064
Ames
OU
SetF
F
6_1
7
8325064
Ames
OU
SetF
F
6_2
8
8325064
Ames
OU
SetF
F
6_3
9
8325064
Ames
OU
SetG
G
7_1
10
8325064
Ames
OU
SetG
G
7_2
11
8325064
Ames
OU
SetG
G
7_3
12
8325064
Ames
OU
SetR
R
18_1
13
8325064
Ames
OU
SetR
R
18_2
14
8325064
Ames
OU
SetR
R
18_3
$warningHtml
Dataset Wrapper Debug Message
Please add a row column to your dataset.
Rows 1-7:
Show values collected for the set, SetA.
Rows 8-16:
Shows values collected for the set, SetF. Revertent colonies were counted and each value is associated with a record to show a postfix of code of "V".
Rows 17-19:
Shows values collected for the set, SetG. Each record for this EUID shows the postfix code of "T". No revertent colonies were counted and there are no summary values collected.
Rows 20-25:
Shows values collected for the set, SetR.
Rows 6,7,14,15,16, 23,24,25:
Show summary values collected (e.g., MEAN, STANDARD DEVIATION, and/or FOLD INCREASE) that apply to all of the observational units within the experimental unit, as shown by OBUID = "ALL".
Row Captions Debug Messages
Remember to keep number agreement between labels and captions.
Please construct row caption labels as instructed in <ac:link><ri:page ri:content-title="Constructing labels for row captions" ri:space-key="TTD"/></ac:link>.
gt.xpt
gt.xpt.xpt
Row
STUDYID
ASSAYID
DOMAIN
TXSETCD
EUID
OUID
GTSEQ
GTTESTCD
GTTEST
GTORRES
GTORRESU
GTCOLSRT (coll. summ. result type)
GTSTRESC
GTSTRESN
GTSTRESU
GTDTC
GTMETHOD
1
8325064
Ames
GT
SETA
A
0_1
1
RPP
Revertant Numbers Per Plate
26
COLONIES
26
26
COLONIES
2015-08-03
INSTRUMENT COUNTED
2
8325064
Ames
GT
SETA
A
0_2
2
RPP
Revertant Numbers Per Plate
35
COLONIES
35
35
COLONIES
2015-08-03
INSTRUMENT COUNTED
3
8325064
Ames
GT
SETA
A
0_3
3
RPP
Revertant Numbers Per Plate
39
COLONIES
39
39
COLONIES
2015-08-03
INSTRUMENT COUNTED
4
8325064
Ames
GT
SETA
A
0_4
4
RPP
Revertant Numbers Per Plate
35
COLONIES
35
35
COLONIES
2015-08-03
INSTRUMENT COUNTED
5
8325064
Ames
GT
SETA
A
0_5
5
RPP
Revertant Numbers Per Plate
30
COLONIES
30
30
COLONIES
2015-08-03
INSTRUMENT COUNTED
6
8325064
Ames
GT
SETA
A
ALL
6
RPP
Revertant Numbers Per Plate
33.0
COLONIES
MEAN
33.0
33.0
COLONIES
2015-08-03
7
8325064
Ames
GT
SETA
A
ALL
7
RPP
Revertant Numbers Per Plate
5.0
COLONIES
STANDARD DEVIATION
5.0
5.0
COLONIES
2015-08-03
8
8325064
Ames
GT
SETF
F
6_1
1
RPP
Revertant Numbers Per Plate
8
COLONIES
8
8
COLONIES
2015-08-03
MANUALLY COUNTED
9
8325064
Ames
GT
SETF
F
6_1
2
CYTOTOX
Cytotoxicity
Very thin background bacterial lawn
V
2015-08-03
10
8325064
Ames
GT
SETF
F
6_2
3
RPP
Revertant Numbers Per Plate
10
COLONIES
10
10
COLONIES
2015-08-03
MANUALLY COUNTED
11
8325064
Ames
GT
SETF
F
6_2
2
CYTOTOX
Cytotoxicity
Very thin background bacterial lawn
V
2015-08-03
12
8325064
Ames
GT
SETF
F
6_3
4
RPP
Revertant Numbers Per Plate
12
COLONIES
12
12
COLONIES
2015-08-03
MANUALLY COUNTED
13
8325064
Ames
GT
SETF
F
6_3
2
CYTOTOX
Cytotoxicity
Very thin background bacterial lawn
V
2015-08-03
14
8325064
Ames
GT
SETF
F
ALL
5
RPPMEAN
Mean of Revertant Numbers Per Plate
10.0
COLONIES
MEAN
10.0
10.0
COLONIES
2015-08-03
15
8325064
Ames
GT
SETF
F
ALL
6
RPPSTDDV
Standard Deviation of Revertant Numbers Per Plate
2.0
COLONIES
STANDARD DEVIATION
2.0
2.0
COLONIES
2015-08-03
16
8325064
Ames
GT
SETF
F
ALL
7
RPPFDINC
Fold Increase of Revertant Numbers Per Plate
0.3
COLONIES
FOLD INCREASE
0.3
0.3
COLONIES
2015-08-03
17
8325064
Ames
GT
SETG
G
5_1
1
CYTOTOX
Cytotoxicity
Toxic No Revertant Colonies
T
2015-08-03
18
8325064
Ames
GT
SETG
G
5_2
2
CYTOTOX
Cytotoxicity
Toxic No Revertant Colonies
T
2015-08-03
19
8325064
Ames
GT
SETG
G
5_3
3
CYTOTOX
Cytotoxicity
Toxic No Revertant Colonies
T
2015-08-03
20
8325064
Ames
GT
SETR
R
18_1
1
RPP
Revertant Numbers Per Plate
812
COLONIES
812
812
COLONIES
2015-08-03
INSTRUMENT COUNTED
21
8325064
Ames
GT
SETR
R
18_2
2
RPP
Revertant Numbers Per Plate
912
COLONIES
912
912
COLONIES
2015-08-03
INSTRUMENT COUNTED
22
8325064
Ames
GT
SETR
R
18_3
3
RPP
Revertant Numbers Per Plate
839
COLONIES
839
839
COLONIES
2015-08-03
INSTRUMENT COUNTED
23
8325064
Ames
GT
SETR
R
ALL
4
RPPMEAN
Mean of Revertant Numbers Per Plate
854.3
COLONIES
MEAN
854.3
854.3
COLONIES
2015-08-03
24
8325064
Ames
GT
SETR
R
ALL
5
RPPSTDDV
Standard Deviation of Revertant Numbers Per Plate
51.7
COLONIES
STANDARD DEVIATION
51.7
51.7
COLONIES
2015-08-03
25
8325064
Ames
GT
SETR
R
ALL
6
RPPFLDINC
Fold Increase of Revertant Numbers Per Plate
6.4
COLONIES
FOLD INCREASE
6.4
6.4
COLONIES
2015-08-03
Dataset Debug Messages
There are 14 leading, trailing, or non-breaking spaces in the dataset.