WEBVTT

1
00:00:01.200 --> 00:00:04.980
Welcome to the Integrated Chemical
Environment, also known as ICE.

2
00:00:05.010 --> 00:00:06.940
In this video, we will show you how

3
00:00:06.970 --> 00:00:10.660
to understand and interpret
results from the ICE Search tool.

4
00:00:10.680 --> 00:00:12.780
We will be viewing the results of a search

5
00:00:12.810 --> 00:00:16.380
built in the previous video
on building a query in ICE.

6
00:00:16.400 --> 00:00:18.540
If you have not yet viewed that video,

7
00:00:18.560 --> 00:00:21.860
you may want to do so
before watching this one.

8
00:00:21.890 --> 00:00:25.900
Once the Search query is run,
the results tab will open.

9
00:00:25.920 --> 00:00:29.180
On the top,
there are three expandable headings.

10
00:00:29.210 --> 00:00:34.380
The first heading gives the names of the
Chemical Quick Lists selected by the user.

11
00:00:34.410 --> 00:00:39.060
The second heading shows the names
of the assays selected by the user,

12
00:00:39.090 --> 00:00:44.260
and the last heading gives the identifiers
that were not returned by the query.

13
00:00:44.290 --> 00:00:48.440
Identifiers may not be returned because
the chemical had no data for the assay

14
00:00:48.470 --> 00:00:53.760
selected or the specific identifier
was not available in the database.

15
00:00:54.120 --> 00:00:57.420
Chemical search results are
returned as a summary table.

16
00:00:57.450 --> 00:00:59.500
This table can be filtered.

17
00:00:59.530 --> 00:01:02.140
Click the filter icon in a table heading

18
00:01:02.170 --> 00:01:07.770
to open a dialog box and select
a subset of your results.

19
00:01:07.800 --> 00:01:14.560
Click on the Long View button to view
the assay-chemical pair data points.

20
00:01:15.160 --> 00:01:20.460
You'll need to drag the scroll bar
to the right to view the entire table.

21
00:01:20.490 --> 00:01:23.260
You can interact with the
elements of the table.

22
00:01:23.290 --> 00:01:25.880
Click on the chemical's CASRN to be

23
00:01:25.910 --> 00:01:29.380
directed to the available test article
page about the chemical

24
00:01:29.410 --> 00:01:36.200
in the NTP Chemical Effects
in Biological Systems or CEBS database.

25
00:01:36.440 --> 00:01:41.060
Or click on the DTXSID
to be directed to the EPA

26
00:01:41.090 --> 00:01:46.120
Comptox Chemical Dashboard
entry for the chemical.

27
00:01:47.840 --> 00:01:50.570
The first column of the ICE results table

28
00:01:50.600 --> 00:01:54.290
displays a "View Details"
button for each chemical.

29
00:01:54.320 --> 00:02:00.540
This view contains two tabs, Substance
or Mixture Details and Curve Surfer.

30
00:02:00.570 --> 00:02:07.200
Let's look at the details
for the substance 17beta-Estradiol.

31
00:02:08.080 --> 00:02:12.100
Under Substance Details you can find
the chemical structure,

32
00:02:12.130 --> 00:02:16.400
physicochemical properties,
and a plot of bioactivity results,

33
00:02:16.430 --> 00:02:20.020
if any cHTS assays were selected.

34
00:02:20.050 --> 00:02:25.780
The pie chart presents the bioactivity
of the chemicals in all assays combined.

35
00:02:25.810 --> 00:02:33.500
The stacked bar plot on the right displays
assay call count for each cHTS assay.

36
00:02:33.530 --> 00:02:35.580
You can change the format of this plot

37
00:02:35.610 --> 00:02:39.260
from the stacked bar to pie chart
and display assay call count as

38
00:02:39.290 --> 00:02:45.360
percentages by selecting the different
options under "Plot Type".

39
00:02:45.400 --> 00:02:50.900
Click on the graph legend to remove or add
bioactivity from the graph view or specify

40
00:02:50.930 --> 00:02:55.960
what assay types to be
included in the graph view.

41
00:02:56.600 --> 00:02:59.020
In either the single chemical or mixture

42
00:02:59.050 --> 00:03:02.120
detail view the Curve Surfer tab allows

43
00:03:02.150 --> 00:03:05.664
you to view and interact with the
concentration-response curves from

44
00:03:05.864 --> 00:03:07.740
cHTS data.

45
00:03:07.770 --> 00:03:13.140
You can use the drop downs to filter
the view or reorder the graphs.

46
00:03:13.170 --> 00:03:16.940
The Curve Surfer is
also a stand-alone tool.

47
00:03:16.970 --> 00:03:22.160
You can check the user guide and help
page to learn more about it.

48
00:03:22.840 --> 00:03:25.300
To see how this works for a mixture,

49
00:03:25.330 --> 00:03:30.760
click on the Detail View
for Bengal Dry Roach Spray.

50
00:03:31.520 --> 00:03:34.220
Under Mixture Details on the top left,

51
00:03:34.250 --> 00:03:37.610
we have information on the active
ingredients of the mixture

52
00:03:37.640 --> 00:03:40.220
and on the right,
we get the chemical structure if

53
00:03:40.250 --> 00:03:45.300
available, and the physicochemical
properties for each active ingredient.

54
00:03:45.330 --> 00:03:48.220
On the bottom left
we have the box and whiskers plot

55
00:03:48.250 --> 00:03:54.680
that shows the AC50 and LD50
values for each active ingredient.

56
00:03:56.880 --> 00:03:58.740
You can download your search results

57
00:03:58.770 --> 00:04:04.780
to your desktop. When you click "Download"
you are given three options.

58
00:04:04.810 --> 00:04:09.700
Summary Data includes a single row
for each chemical with a summary of all

59
00:04:09.730 --> 00:04:13.180
assays run on that chemical
given in the columns.

60
00:04:13.210 --> 00:04:16.240
A second option, Wide Format, returns

61
00:04:16.270 --> 00:04:19.460
summary data with the
individual cHTS assays

62
00:04:19.480 --> 00:04:25.260
if there is a cHTS assay
group specified in the query.

63
00:04:25.280 --> 00:04:28.620
Long Format view returns data as one row

64
00:04:28.650 --> 00:04:32.860
for each unique chemical-assay combination.

65
00:04:32.890 --> 00:04:35.440
This view provides additional experimental

66
00:04:35.470 --> 00:04:41.140
detail and can be useful for those
wanting to analyze the data further.

67
00:04:41.160 --> 00:04:46.900
Each format is available for download as a
tab-delimited text file, or Excel file.

68
00:04:46.920 --> 00:04:51.700
Any filters applied to the displayed data
will also be applied to the download.

69
00:04:51.720 --> 00:04:55.500
So if you need all the data,
make sure that you clear any filters

70
00:04:55.530 --> 00:04:57.041
before downloading.

71
00:04:57.241 --> 00:05:00.380
Use the "Send filtered results to" dropdown list

72
00:05:00.410 --> 00:05:05.420
next to the download button to send
Search parameters to other ICE tools

73
00:05:05.450 --> 00:05:07.467
to run additional queries.

74
00:05:07.667 --> 00:05:13.980
For details on the use and outputs of these tools,
refer to their user guides.

75
00:05:14.010 --> 00:05:16.980
You can also send chemicals
to query the EPA

76
00:05:17.010 --> 00:05:24.620
CompTox Chemicals Dashboard or copy
the CASRNs or DTXSIDs to the clipboard.

77
00:05:24.650 --> 00:05:26.380
Same as downloading results,

78
00:05:26.410 --> 00:05:30.420
any filters applied to the table
would be carried over here.

79
00:05:30.450 --> 00:05:35.020
The last item on the Results tab is
the bioactivity results graphs for all

80
00:05:35.040 --> 00:05:40.980
selected chemicals and any selected
cHTS assays presented in two plots.

81
00:05:41.010 --> 00:05:42.940
The pie chart which appears below

82
00:05:42.970 --> 00:05:46.220
the legend presents the bioactivity of all

83
00:05:46.250 --> 00:05:53.340
assays combined and the stacked bar plot
that displays call count for each cHTS assay.

84
00:05:53.360 --> 00:05:58.140
As with the detailed view, the format of
this plot can be changed to pie charts,

85
00:05:58.170 --> 00:06:01.020
with the counts displayed as percentages.

86
00:06:01.040 --> 00:06:05.700
You can click on the graph legends
to remove or add data from the view

87
00:06:05.730 --> 00:06:11.200
and select which assay types
are included in the graph.

88
00:06:12.280 --> 00:06:15.780
Thank you for watching our
video on Search Results in ICE.

89
00:06:15.800 --> 00:06:17.260
For more detailed information

90
00:06:17.290 --> 00:06:21.480
on the Search tool, go to the Help
top menu item and select "User Guides".