View= localhost, mysqli, toxsummary_mpsl, table_content, rows=61
LabSampleIDSourcefilenameStationCodeEventCodeProtocolCodeLocationCodeSampleDateCollectionTimeCollectionMethodCodeSampleTypeCodeReplicateCollectionDepthUnitCollectionDepthProjectCodeAgencyCodeLabCollectionCommentsSampleIDDWC_TT_MatrixNameDWC_TT_MethodNameToxTestDurNameFinalIDTestExposureTypeToxBatchToxTestCommentsTreatmentConcentrationUnitTreatmentDilutionToxPointMethodDWC_TP_AnalyteNameFractionNameWQSourceTimePointNameUnitAnalyteRepCountMeanStdDevStatisticalMethodAlphaLevelbValueCalcValueTypeCalculatedValueCritcalValuePercentEffectCALC_PercentControlEvalThresholdSigEffectCodeToxPointSummaryCommentsTestQACodeSubmittingAgencyDWC_TT_AgencyCodeToxBatchCommentsLabSubmissionCodeBatchVerificationCodeDWC_DatabaseSourceTargetLatitudeTargetLongitudeYearToxPointSummaryRowIDid_keyActive
64-305SJA-T01PER_CMP_64CD_C6_W_TOX305SJAWQCMP_QAPP_2010Not Recorded2010-03-30 00:00:001899-12-30 13:50:00Water_GrabGrab10.1mRWB3_CMPCCWQP64-305SJA-T01samplewaterEPA 821/R-02-0136 daysCeriodaphnia dubiaChronicPER_CMP_64CD_C6_W_TOXNone0none100NoneYoung/femaleNonenot applicableDay 6Num/Rep1011.75.813Paired T-test0.05Probability00.0552.0491803347.9508196720SLNRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm36.87536-121.561411905-07-02 00:00:00{961A9595-A05A-4A8C-B604-DB8048C2EE0D}110981
121_309OLD-ECMP_121CV_C1309OLDWQCMP_QAPP_2012Midchannel2014-12-02 00:00:001899-12-30 08:10:00Water_GrabGrab10.1mRWB3_CMPPERCMP_121_309OLD-EsamplewaterEPA 821/R-02-0147 daysCyprinodon variegatusChronicPER_CMP_121CV_C1_W_TOXNone0none100NoneSurvivalNonenot applicableDay 7%41000Mann-Whitney U-test0.05Probability10.05-2.56102.5620NSGNRPERPERANRMLML_Perm36.772290981-121.7878551905-07-06 00:00:00{F53D31AF-476E-4727-9CCE-84F4102C946A}51821
64-305STL-T01PER_CMP_64CD_C6_W_TOX305STLWQCMP_QAPP_2010Not Recorded2010-03-30 00:00:001899-12-30 08:30:00Water_GrabGrab10.1mRWB3_CMPCCWQP64-305STL-T01samplewaterEPA 821/R-02-0136 daysCeriodaphnia dubiaChronicPER_CMP_64CD_C6_W_TOXNone0none100NoneSurvivalNonenot applicableDay 6%101000Fisher's Exact0.05Probability10.05010020NSGNRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm36.903841841-121.78230711905-07-02 00:00:00{6242A674-53E4-4E7F-86F9-0F894E4A3475}110991
121_312ORC-ECMP_121CV_C2312ORCWQCMP_QAPP_2012Midchannel2014-12-11 00:00:001899-12-30 13:40:00Water_GrabGrab10.1mRWB3_CMPTetraTechCMP_121_312ORC-EsamplewaterEPA 821/R-02-0147 daysCyprinodon variegatusChronicPER_CMP_121CV_C2_W_TOXNone0none100NoneBiomass (wt/orig indiv)Nonenot applicableDay 7mg/ind41.2380.0267Paired T-test0.05Probability0.0020.05118920SGNRPERPERANRMLML_Perm34.957554-120.6314541905-07-06 00:00:00{0FE57597-ECA3-4531-A967-1CCBC1619763}51831
CMP-02-312OFC-00501-CD-LWControl-01312OFCWQCMP_QAPP_2005Not Recorded2005-02-21 00:00:001899-12-30 12:30:00Water_GrabGrab1-88mRWB3_CMPCCWQPCMP-02-312OFC-005samplewaterEPA 821/R-02-0135 daysCeriodaphnia dubiaChronic01-CD-LWControl-01None0none100NoneSurvivalNonenot applicableDay 5%101000Fisher's Exact0.05Probability10.05010020NSGNRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm35.016388-120.5862591905-06-27 00:00:00{A729D6BF-FCCD-4BF1-83C7-49653456AC9C}11
CMP-02-312OFC-00501-CD-LWControl-01312OFCWQCMP_QAPP_2005Not Recorded2005-02-21 00:00:001899-12-30 12:30:00Water_GrabGrab1-88mRWB3_CMPCCWQPCMP-02-312OFC-005samplewaterEPA 821/R-02-0135 daysCeriodaphnia dubiaChronic01-CD-LWControl-01None0none100NoneYoung/femaleNonenot applicableDay 5Num/Rep1022.45.54176Paired T-test0.05Probability0.196460.0510.489.620NSGNRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm35.016388-120.5862591905-06-27 00:00:00{2970DE61-F09B-470C-8526-3E37EF79B89D}21
64-305STL-T01PER_CMP_64CD_C6_W_TOX305STLWQCMP_QAPP_2010Not Recorded2010-03-30 00:00:001899-12-30 08:30:00Water_GrabGrab10.1mRWB3_CMPCCWQP64-305STL-T01samplewaterEPA 821/R-02-0136 daysCeriodaphnia dubiaChronicPER_CMP_64CD_C6_W_TOXNone0none100NoneYoung/femaleNonenot applicableDay 6Num/Rep928.569.435Mann-Whitney U-test0.05Probability0.9980.05-1711720NSGMPSL: 060617 PercentEffect updated based on QAMean and SampleMean per CCWQP and R3NRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm36.903841841-121.78230711905-07-02 00:00:00{E8250FC5-B3A2-485D-B219-A9362C2C366D}111001
121_312ORC-ECMP_121CV_C2312ORCWQCMP_QAPP_2012Midchannel2014-12-11 00:00:001899-12-30 13:40:00Water_GrabGrab10.1mRWB3_CMPTetraTechCMP_121_312ORC-EsamplewaterEPA 821/R-02-0147 daysCyprinodon variegatusChronicPER_CMP_121CV_C2_W_TOXNone0none100NoneSurvivalNonenot applicableDay 7%41000Mann-Whitney U-test0.05Probability10.05-2.56102.5620NSGNRPERPERANRMLML_Perm34.957554-120.6314541905-07-06 00:00:00{199EA38E-B57E-45BF-AE46-03CFA75DB890}51841
64-305WSA-T01PER_CMP_64CD_C6_W_TOX305WSAWQCMP_QAPP_2010Not Recorded2010-03-30 00:00:001899-12-30 09:20:00Water_GrabGrab10.1mRWB3_CMPCCWQP64-305WSA-T01samplewaterEPA 821/R-02-0136 daysCeriodaphnia dubiaChronicPER_CMP_64CD_C6_W_TOXNone0none100NoneSurvivalNonenot applicableDay 6%101000Fisher's Exact0.05Probability10.05010020NSGNRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm36.890512981-121.8007091905-07-02 00:00:00{72B8BE4A-4ABC-4979-9631-D1CF212FC553}111011
CMP-02-312OFN-00401-CD-LWControl-01312OFNWQCMP_QAPP_2005Not Recorded2005-02-21 00:00:001899-12-30 13:10:00Water_GrabGrab1-88mRWB3_CMPCCWQPCMP-02-312OFN-004samplewaterEPA 821/R-02-0135 daysCeriodaphnia dubiaChronic01-CD-LWControl-01None0none100NoneSurvivalNonenot applicableDay 5%10900.31623Fisher's Exact0.05Probability0.526320.05109020NSGNRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm35.022795-120.5861571905-06-27 00:00:00{48C2CCD4-F0AC-430F-8FA4-A50D0A50D76D}31
121_312ORI_FDCMP_121CV_C2312ORIWQCMP_QAPP_2012Midchannel2014-12-11 00:00:001899-12-30 14:15:00Water_GrabGrab20.1mRWB3_CMPTetraTechCMP_121_312ORI_FDsamplewaterEPA 821/R-02-0147 daysCyprinodon variegatusChronicPER_CMP_121CV_C2_W_TOXField duplicateNone0none100NoneBiomass (wt/orig indiv)Nonenot applicableDay 7mg/ind41.40.1769Paired T-test0.05Probability0.5360.05-0.65100.6520NSGRPD 2.5NRPERPERANRMLML_Perm34.941374-120.5728821905-07-06 00:00:00{86403FCC-BB9C-443E-BA4B-CB51C7A0DA8C}51851
121_312ORI-ECMP_121CV_C2312ORIWQCMP_QAPP_2012Midchannel2014-12-11 00:00:001899-12-30 14:15:00Water_GrabGrab10.1mRWB3_CMPTetraTechCMP_121_312ORI-EsamplewaterEPA 821/R-02-0147 daysCyprinodon variegatusChronicPER_CMP_121CV_C2_W_TOXNone0none100NoneBiomass (wt/orig indiv)Nonenot applicableDay 7mg/ind41.3370.107Paired T-test0.05Probability0.2120.053.8796.1320NSGNRPERPERANRMLML_Perm34.941374-120.5728821905-07-06 00:00:00{6FCDF894-EA7E-4623-A20D-8028CC7E533A}51861
CMP-02-312OFN-00401-CD-LWControl-01312OFNWQCMP_QAPP_2005Not Recorded2005-02-21 00:00:001899-12-30 13:10:00Water_GrabGrab1-88mRWB3_CMPCCWQPCMP-02-312OFN-004samplewaterEPA 821/R-02-0135 daysCeriodaphnia dubiaChronic01-CD-LWControl-01None0none100NoneYoung/femaleNonenot applicableDay 5Num/Rep1019.98.68524Paired T-test0.05Probability0.093780.0520.479.620NSLMPSL: 072817 SigEffectCode updated from NSG to NSL based on CalculatedValue and CriticalValue per CCWQP and R3NRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm35.022795-120.5861571905-06-27 00:00:00{E2CABB89-18BB-4F06-9A64-A372F758A7EC}41
64-305WSA-T01PER_CMP_64CD_C6_W_TOX305WSAWQCMP_QAPP_2010Not Recorded2010-03-30 00:00:001899-12-30 09:20:00Water_GrabGrab10.1mRWB3_CMPCCWQP64-305WSA-T01samplewaterEPA 821/R-02-0136 daysCeriodaphnia dubiaChronicPER_CMP_64CD_C6_W_TOXNone0none100NoneYoung/femaleNonenot applicableDay 6Num/Rep1031.32.163Paired T-test0.05Probability10.05-28.3128.320NSGMPSL: 060617 PercentEffect updated based on QAMean and SampleMean per CCWQP and R3NRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm36.890512981-121.8007091905-07-02 00:00:00{DED8FD6E-B595-4E1E-8AAF-6AE34BCFC11D}111021
CMP-02-312ORC-00201-CD-LWControl-01312ORCWQCMP_QAPP_2005Not Recorded2005-02-21 00:00:001899-12-30 14:45:00Water_GrabGrab1-88mRWB3_CMPCCWQPCMP-02-312ORC-002samplewaterEPA 821/R-02-0135 daysCeriodaphnia dubiaChronic01-CD-LWControl-01None0none100NoneSurvivalNonenot applicableDay 5%101000Fisher's Exact0.05Probability10.05010020NSGNRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm34.957554-120.6314541905-06-27 00:00:00{DB029786-1480-4971-A815-B1B95A794EAB}51
PER_CMP_64CD_C6_W_TOXPER_CMP_64CD_C6_W_TOXLABQAWQCMP_QAPP_2010Not Applicable2010-03-31 00:00:001899-12-30 00:00:00Not ApplicableCNEG1-88mRWB3_CMPPERCMP_64CD_C6labwaterEPA 821/R-02-0136 daysCeriodaphnia dubiaChronicPER_CMP_64CD_C6_W_TOXMPSL: updated QAControlID and LabSampleIDNone0none100NoneSurvivalNonenot applicableDay 6%11000Not Recorded0.05Probability-880.05010020NANRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm-88-881905-07-02 00:00:00{48A16C57-31A7-4D75-B2D2-9E8C113577B6}111031
121_312ORI_FDCMP_121CV_C2312ORIWQCMP_QAPP_2012Midchannel2014-12-11 00:00:001899-12-30 14:15:00Water_GrabGrab20.1mRWB3_CMPTetraTechCMP_121_312ORI_FDsamplewaterEPA 821/R-02-0147 daysCyprinodon variegatusChronicPER_CMP_121CV_C2_W_TOXField duplicateNone0none100NoneSurvivalNonenot applicableDay 7%41000Mann-Whitney U-test0.05Probability10.05-2.56102.5620NSGRPD 2.6NRPERPERANRMLML_Perm34.941374-120.5728821905-07-06 00:00:00{58076185-61AF-46FA-8A03-6CE685148B7E}51871
121_312ORI-ECMP_121CV_C2312ORIWQCMP_QAPP_2012Midchannel2014-12-11 00:00:001899-12-30 14:15:00Water_GrabGrab10.1mRWB3_CMPTetraTechCMP_121_312ORI-EsamplewaterEPA 821/R-02-0147 daysCyprinodon variegatusChronicPER_CMP_121CV_C2_W_TOXNone0none100NoneSurvivalNonenot applicableDay 7%497.55Mann-Whitney U-test0.05Probability0.7860.05010020NSGNRPERPERANRMLML_Perm34.941374-120.5728821905-07-06 00:00:00{83357BA1-2069-46C7-B283-9D325191BFA2}51881
PER_CMP_64CD_C6_W_TOXPER_CMP_64CD_C6_W_TOXLABQAWQNot ApplicableNot Applicable2010-03-31 00:00:001899-12-30 00:00:00Not ApplicableCNEG1-88mRWB3_CMPPERCMP_64CD_C6labwaterEPA 821/R-02-0136 daysCeriodaphnia dubiaChronicPER_CMP_64CD_C6_W_TOXNone0none100NoneYoung/femaleNonenot applicableDay 6Num/Rep1024.42.716Paired T-test0.05Probability0.50.05010020NAMPSL: Updated LabSampleID to reflect QAControlIDNRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm-88-881905-07-02 00:00:00{F569912C-3DE3-410B-A50C-BBB91A9D30F7}111041
CMP-02-312ORC-00301-CD-LWControl-01312ORCWQCMP_QAPP_2005Not Recorded2005-02-21 00:00:001899-12-30 14:45:00Water_GrabGrab2-88mRWB3_CMPCCWQPCMP-02-312ORC-003samplewaterEPA 821/R-02-0135 daysCeriodaphnia dubiaChronic01-CD-LWControl-01None0none100NoneYoung/femaleNonenot applicableDay 5Num/Rep1016.64.8808Paired T-test0.05Probability0.004340.0533.666.420SLMPSL: 072817 SigEffectCode updated from SG to SL based on CalculatedValue and CriticalValue per CCWQP and R3NRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm34.957554-120.6314541905-06-27 00:00:00{CBAED3AD-04E4-47FB-9080-6E30FEEC135F}61
CMP-02-312ORC-00201-CD-LWControl-01312ORCWQCMP_QAPP_2005Not Recorded2005-02-21 00:00:001899-12-30 14:45:00Water_GrabGrab1-88mRWB3_CMPCCWQPCMP-02-312ORC-002samplewaterEPA 821/R-02-0135 daysCeriodaphnia dubiaChronic01-CD-LWControl-01None0none100NoneYoung/femaleNonenot applicableDay 5Num/Rep1017.33.49762Paired T-test0.05Probability0.004310.0530.869.220SLMPSL: 072817 SigEffectCode updated from SG to SL based on CalculatedValue and CriticalValue per CCWQP and R3NRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm34.957554-120.6314541905-06-27 00:00:00{07C417E8-7B95-4980-A85B-FAA56C046129}71
64-310LBC-T01PER_CMP_64CD_C7_W_TOX310LBCWQCMP_QAPP_2010Not Recorded2010-03-31 00:00:001899-12-30 14:35:00Water_GrabGrab10.1mRWB3_CMPCCWQP64-310LBC-T01samplewaterEPA 821/R-02-0136 daysCeriodaphnia dubiaChronicPER_CMP_64CD_C7_W_TOXNone0none100NoneYoung/femaleNonenot applicableDay 6Num/Rep1028.23.99Mann-Whitney U-test0.05Probability10.05-80.8180.820NSGSamples with signif. survival tox are excluded from reprod. tox assess; MPSL 060617 PercentEffect updated based on QAMean and SampleMean; changed SigEffect orig. reported as NSU to NSG based on CalcValue and CritValue per CCWQP and R3NRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm35.10306-120.578891905-07-02 00:00:00{49DAF029-78F1-4328-B497-C84BE623ABEA}111051
121_312SMA-ECMP_121CV_C2312SMAWQCMP_QAPP_2012Midchannel2014-12-11 00:00:001899-12-30 12:45:00Water_GrabGrab10.1mRWB3_CMPTetraTechCMP_121_312SMA-EsamplewaterEPA 821/R-02-0147 daysCyprinodon variegatusChronicPER_CMP_121CV_C2_W_TOXNone0none100NoneBiomass (wt/orig indiv)Nonenot applicableDay 7mg/ind41.2650.04304Paired T-test0.05Probability0.0090.059.0390.9720SGNRPERPERANRMLML_Perm34.96377398-120.6417961905-07-06 00:00:00{61BB9EAE-FDBD-434D-B9A3-C26F655F06A3}51891
121_312SMA-ECMP_121CV_C2312SMAWQCMP_QAPP_2012Midchannel2014-12-11 00:00:001899-12-30 12:45:00Water_GrabGrab10.1mRWB3_CMPTetraTechCMP_121_312SMA-EsamplewaterEPA 821/R-02-0147 daysCyprinodon variegatusChronicPER_CMP_121CV_C2_W_TOXNone0none100NoneSurvivalNonenot applicableDay 7%41000Mann-Whitney U-test0.05Probability10.05-2.56102.5620NSGNRPERPERANRMLML_Perm34.96377398-120.6417961905-07-06 00:00:00{0C2E5878-9E0F-4931-AC8A-E9F8EDB49252}51901
CMP-02-312SMA-00101-CD-LWControl-01312SMAWQCMP_QAPP_2005Not Recorded2005-02-21 00:00:001899-12-30 14:10:00Water_GrabGrab1-88mRWB3_CMPCCWQPCMP-02-312SMA-001samplewaterEPA 821/R-02-0135 daysCeriodaphnia dubiaChronic01-CD-LWControl-01None0none100NoneSurvivalNonenot applicableDay 5%101000Fisher's Exact0.05Probability10.05010020NSGNRCCWQPPERTox results added from historic RWB3 pipeline, Summary data only, no replicates reported to MPSLNRNRMLML_Perm34.96377398-120.6417961905-06-27 00:00:00{2EAC39D6-167B-4C30-A2ED-85CAC5F3D282}81