Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This picture does not depict the more complicated procedures, trial sets, or observational units for our example study, 8325064.   For study 8325064, the applicant chose to define the REFIDs at the trial set level with a single character (e.g., A, F, G, R) and chose to define REFIDs at the observational level based on the location of each tube in one of multiple exposure/incubation plates (e.g, 6_1 for plate 6, position 1).


Dataset wrap
Namerelref.xpt
Rowcaps
Row 1:Shows the value of REFID=A, This REFID refers to the trial set with a SETCD of 'SetA', as defined in the trial set dataset, tx.xpt.  LEVEL=1 and LVLDESC='TRIAL SET' indicates this identifier relates to the entire trial set.
Rows 2-6:Show the values of five observational units 0_1 through 0_5 that are within the parent experimental unit, REFID=A
Row 7: Shows the value of REFID=F, This REFID refers to the trial set with a SETCD of 'SetF', as defined in the trial set dataset, tx.xpt.  LEVEL=1 and LVLDESC='TRIAL SET' indicates this identifier relates to the entire trial set.
Rows 8-10:Show the values of three observational units 6_1 through 6_3 that are within the parent experimental unit, REFID=F
Row 11:Shows the value of REFID=G, This REFID refers to the trial set with a SETCD of 'SetG', as defined in the trial set dataset, tx.xpt.  LEVEL=1 and LVLDESC='TRIAL SET' indicates this identifier relates to the entire trial set.
Rows 12-14:Show the values of three observational units 7_1 through 7_3 that are within the parent experimental unit, REFID=F
Row 15:Shows the value of REFID=R. This REFID refers to the trial set with a SETCD of 'SetG', as defined in the trial set dataset, tx.xpt.  LEVEL=1 and LVLDESC='TRIAL SET' indicates this identifier relates to the entire trial set.
Rows 16-18:Show the values of three observational units 18_1 through 18_3 that are within the parent experimental unit, REFID=F
Dataset2
tableidrelref.xpt

Row

STUDYID

GNTXAID

SETCD

REFID

PARENT

LEVEL

LVLDESC

1

8325064

Ames

SetA

A


1

TRIAL SET

2

8325064

Ames

SetA

0_1

A

2

OBSERVATIONAL UNIT

3

8325064

Ames

SetA

0_2

A

2

OBSERVATIONAL UNIT

4

8325064

Ames

SetA

0_3

A

2

OBSERVATIONAL UNIT

5

8325064

Ames

SetA

0_4

A

2

OBSERVATIONAL UNIT

6

8325064

Ames

SetA

0_5

A

2

OBSERVATIONAL UNIT

7

8325064

Ames

SetF

F


1

TRIAL SET

8

8325064

Ames

SetF6_1F

2

OBSERVATIONAL UNIT

9

8325064

Ames

SetF6_2F

2

OBSERVATIONAL UNIT

10

8325064

Ames

SetF

6_3F

2

OBSERVATIONAL UNIT

11

8325064

Ames

SetG

G


1

TRIAL SET

12

8325064

Ames

SetG7_1G

2

OBSERVATIONAL UNIT

13

8325064

Ames

SetG

7_2G

2

OBSERVATIONAL UNIT

14

8325064

Ames

SetG7_3G

2

OBSERVATIONAL UNIT

15

8325064

Ames

SetG

R


1

TRIAL SET

16

8325064

Ames

SetR18_1R

2

OBSERVATIONAL UNIT

17

8325064

Ames

SetR18_2R

2

OBSERVATIONAL UNIT

18

8325064

Ames

SetR18_3R

2

OBSERVATIONAL UNIT

Dataset wrap
Namegt.xpt
Rowcaps
Rows 1-5:Show the number of revertant colonies per plate collected for each of five observational units ( REFID=0_1 through 0_5 as described in the relref dataset).
Rows 6, 7:Show summary values collected (MEAN, STANDARD DEVIATION) for REFID=A that apply to the entire trial set, SetA, as indicated by LEVEL=1 and LVLDESC=TRIAL SET for this REFID in the relref dataset. 
Rows 8-13: Revertent colonies were counted for each of three plates/observational units (REFID=6_1 through 6_3) and each value is associated with a record to show a postfix code of "V" = "Very thin background bacterial lawn"
Rows 14-16:Show summary values collected (MEAN, STANDARD DEVIATION, and FOLD INCREASE) for REFID=F that apply to the entire trial set, SetF, as indicated by LEVEL=1 and LVLDESC=TRIAL SET for this REFID in the relref dataset. 
Rows 17-19:Show three plates/observational units (REFID=5_1 through 5_3) where no revertant colonies were counted due to too much cytotoxicity and a postfix code of "T".
Rows 20-22:Show the number of revertant colonies per plate collected for each of three observational units (REFID=18_1 through 18_3 as described in the relref dataset).
Rows 23-25:Show summary values collected (MEAN, STANDARD DEVIATION, and FOLD INCREASE) for REFID=R that apply to the entire trial set, SetR, as indicated by LEVEL=1 and LVLDESC=TRIAL SET for this REFID in the relref dataset. 
Dataset2
RowSTUDYIDASSAYIDDOMAINGTSEQREFIDGTTESTCDGTTESTGTORRESGTORRESUGTCOLSRTGTSTRESCGTSTRESNGTSTRESUGTSTATGTREASNDGTMETHODGTDTC
18325064AmesGT10_1RPPRevertant Numbers Per Plate26COLONIES
2626COLONIES

INSTRUMENT COUNTED

2015-08-03
28325064AmesGT20_2RPPRevertant Numbers Per Plate35COLONIES
3535COLONIES

INSTRUMENT COUNTED2015-08-03
38325064AmesGT30_3RPPRevertant Numbers Per Plate39COLONIES
3939COLONIES

INSTRUMENT COUNTED2015-08-03
48325064AmesGT40_4RPPRevertant Numbers Per Plate35COLONIES
3535COLONIES

INSTRUMENT COUNTED

2015-08-03
58325064AmesGT50_5RPPRevertant Numbers Per Plate30COLONIES
3030COLONIES

INSTRUMENT COUNTED2015-08-03
68325064AmesGT6ARPPRevertant Numbers Per Plate33.0COLONIESMEAN33.033.0COLONIES


2015-08-03
78325064AmesGT7ARPPRevertant Numbers Per Plate5.0COLONIESSTANDARD DEVIATION5.05.0COLONIES


2015-08-03
88325064AmesGT16_1RPPRevertant Numbers Per Plate8COLONIES
88COLONIES

MANUALLY COUNTED2015-08-03
98325064AmesGT26_1CYTOTOXCytotoxicityVery thin background bacterial lawn

V




2015-08-03
108325064AmesGT36_2RPPRevertant Numbers Per Plate10COLONIES
1010COLONIES

MANUALLY COUNTED2015-08-03
118325064AmesGT46_2CYTOTOXCytotoxicityVery thin background bacterial lawn

V




2015-08-03
128325064AmesGT56_3RPPRevertant Numbers Per Plate12COLONIES
1212COLONIES

MANUALLY COUNTED2015-08-03
138325064AmesGT66_3CYTOTOXCytotoxicityVery thin background bacterial lawn

V




2015-08-03
148325064AmesGT7FRPPMEANMean of Revertant Numbers Per Plate

10.0

COLONIESMEAN

10.0

10.0

COLONIES


2015-08-03
158325064AmesGT8FRPPSTDDVStandard Deviation of Revertant Numbers Per Plate2.0COLONIESSTANDARD DEVIATION2.02.0COLONIES


2015-08-03
168325064AmesGT9FRPPFDINCFold Increase of Revertant Numbers Per Plate0.3COLONIESFOLD INCREASE0.30.3COLONIES


2015-08-03
178325064AmesGT15_1CYTOTOXCytotoxicity

Toxic No Revertant Colonies



T

NOT DONETOO MUCH CYTOTOXICITY
2015-08-03
188325064AmesGT25_2CYTOTOXCytotoxicityToxic No Revertant Colonies

T

NOT DONETOO MUCH CYTOTOXICITY
2015-08-03
198325064AmesGT35_3CYTOTOXCytotoxicityToxic No Revertant Colonies

T

NOT DONETOO MUCH CYTOTOXICITY
2015-08-03
208325064AmesGT118_1RPPRevertant Numbers Per Plate

812

COLONIES


812

812

COLONIES

INSTRUMENT COUNTED

2015-08-03
218325064AmesGT218_2RPPRevertant Numbers Per Plate

912

COLONIES


912

912

COLONIES

INSTRUMENT COUNTED2015-08-03
228325064AmesGT318_3RPPRevertant Numbers Per Plate

839

COLONIES


839

839

COLONIES

INSTRUMENT COUNTED2015-08-03
238325064AmesGT4RRPPMEANMean of Revertant Numbers Per Plate854.3COLONIESMEAN854.3854.3COLONIES


2015-08-03
248325064AmesGT5RRPPSTDDVStandard Deviation of Revertant Numbers Per Plate51.7COLONIESSTANDARD DEVIATION51.751.7COLONIES


2015-08-03
258325064AmesGT6RRPPFLDINCFold Increase of Revertant Numbers Per Plate6.4COLONIESFOLD INCREASE6.46.4COLONIES


2015-08-03

...