1
00:00:05,812 --> 00:00:06,875
Hello and welcome to our

2
00:00:06,875 --> 00:00:12,125
demo presentation of the NTC query
tool Platform, which exists as a resource

3
00:00:12,125 --> 00:00:16,250
to the community to support feasibility
assessments of consortium resources

4
00:00:16,437 --> 00:00:19,375
and the creation and submission
of a formal request application.

5
00:00:20,187 --> 00:00:23,250
I am a member of the Data
Coordinating Center and my goal here

6
00:00:23,375 --> 00:00:27,812
with the presentation is to demonstrate
how the query tool can be used efficiently

7
00:00:28,375 --> 00:00:32,937
to submit a request, ensure the platform
and process are clear to all researchers.

8
00:00:33,562 --> 00:00:37,625
As always, please feel to reach out
to the DCC via email at an A.C.

9
00:00:37,625 --> 00:00:41,500
at Amazon.com, EMC, Eskom.

10
00:00:41,875 --> 00:00:44,750
If there are any questions
or technical challenges encountered

11
00:00:44,875 --> 00:00:48,000
when using our tool,
we are always available to assist,

12
00:00:48,812 --> 00:00:52,687
even if appropriate resources might not
appear available within the query tool.

13
00:00:53,000 --> 00:00:55,750
Never assume that a consortium
is unable to support you.

14
00:00:56,250 --> 00:00:59,437
We may be able to suggest
alternative resources or approaches

15
00:00:59,625 --> 00:01:03,062
that could address the same research
questions using the wealth of experience

16
00:01:03,312 --> 00:01:06,125
and scientific expertise
that exists within our team

17
00:01:06,125 --> 00:01:07,812
and the consortium as a whole.

18
00:01:07,812 --> 00:01:12,062
Our goal at the DCC is to support
as many researchers as possible

19
00:01:12,312 --> 00:01:15,375
and help demonstrate the immense value
of well-characterized samples

20
00:01:15,687 --> 00:01:19,312
tied to longitudinal assessments
and lab data that have been collected over

21
00:01:19,312 --> 00:01:20,562
the past 25 years.

22
00:01:21,625 --> 00:01:22,375
Moving on to

23
00:01:22,375 --> 00:01:25,750
our demo today, I'm
going to pose as a neuro HIV researcher

24
00:01:26,125 --> 00:01:30,500
who wishes wishes to pursue a pilot
project examining the genetic mechanisms

25
00:01:30,875 --> 00:01:34,875
underlying substance use in
an African-American population with HIV.

26
00:01:35,562 --> 00:01:40,437
I plan to utilize a to group design
with patients with and without HIV.

27
00:01:40,875 --> 00:01:44,562
I'm interested in receiving
frozen specimens from the frontal cortex

28
00:01:44,937 --> 00:01:46,937
that can be used for snip analysis.

29
00:01:47,625 --> 00:01:50,500
The patients in both groups
should have a history of substance use,

30
00:01:50,937 --> 00:01:53,562
and I also require demographic data

31
00:01:53,812 --> 00:01:57,187
in brain pathology
to serve as covariates in my analysis.

32
00:01:57,937 --> 00:02:00,000
So the first step in using our query tool

33
00:02:00,812 --> 00:02:03,250
is to request
an account from the NTC website.

34
00:02:03,812 --> 00:02:06,937
The process for this activity
is covered in a separate demo.

35
00:02:07,250 --> 00:02:09,375
Please
reference that video for more details.

36
00:02:09,812 --> 00:02:13,937
Once access to the to the website and the
query will have been granted by the DCC,

37
00:02:14,187 --> 00:02:17,437
you will then access the query tool
by navigating to an A.C.

38
00:02:17,437 --> 00:02:19,375
Dawg and clicking the link

39
00:02:19,375 --> 00:02:23,187
at the bottom of the page
titled Submit or Modify your application.

40
00:02:23,750 --> 00:02:24,687
Click this link

41
00:02:26,750 --> 00:02:27,500
and a system.

42
00:02:27,500 --> 00:02:31,187
If you've not already logged into your
account, we'll ask you to log in again.

43
00:02:31,250 --> 00:02:34,375
Otherwise it'll bring you to the dashboard
of the query tool.

44
00:02:37,875 --> 00:02:40,875
Scroll to the bottom of the page.

45
00:02:40,937 --> 00:02:45,000
Since our researcher is interested
in requesting samples

46
00:02:45,437 --> 00:02:48,000
for a pilot study, I will request.

47
00:02:49,250 --> 00:02:50,375
I will. I will.

48
00:02:50,375 --> 00:02:51,687
I will click the link.

49
00:02:51,687 --> 00:02:54,812
New Level one request.

50
00:02:55,750 --> 00:02:58,187
The next option I will select
is specimen request

51
00:02:58,187 --> 00:03:00,375
because I'm interested
in acquiring specimens

52
00:03:04,437 --> 00:03:06,687
and this will open up the main

53
00:03:06,750 --> 00:03:11,250
donor search query page, which allows one
to specify the cohort of interest

54
00:03:11,812 --> 00:03:14,562
and clinical criteria of the participants
you wish to study.

55
00:03:15,250 --> 00:03:17,562
The page is divided into different
sections.

56
00:03:17,875 --> 00:03:21,812
The left hand portion of the page
contains all the searchable criteria.

57
00:03:23,437 --> 00:03:23,875
The middle

58
00:03:23,875 --> 00:03:26,750
section of the page displays
all the donors

59
00:03:27,250 --> 00:03:30,937
and their characteristics that meet
any of the criteria that you've selected.

60
00:03:31,500 --> 00:03:33,750
Note We can update this table

61
00:03:34,187 --> 00:03:36,937
to include different

62
00:03:36,937 --> 00:03:40,187
fields depending on your interest.

63
00:03:44,125 --> 00:03:47,062
The top portion of the page indicates
the stage

64
00:03:47,062 --> 00:03:50,625
at which you are within the query tool,
starting with donor search.

65
00:03:50,875 --> 00:03:53,687
And once you've complete your donor
search, you'll move to specimen search,

66
00:03:54,125 --> 00:03:58,312
followed by data dataset search, followed
by a final review of your application.

67
00:03:59,812 --> 00:04:02,937
Below those tabs are the filter results.

68
00:04:03,250 --> 00:04:06,125
So this indicates
the number of donors that have met

69
00:04:06,125 --> 00:04:09,375
the criteria that you've selected.

70
00:04:09,562 --> 00:04:12,375
Please note there's an additional link
at the bottom of the results

71
00:04:12,375 --> 00:04:15,937
table called Donor
Search Variable Definitions.

72
00:04:16,375 --> 00:04:18,750
Clicking
This link will open up a separate document

73
00:04:19,000 --> 00:04:23,500
which defines all the the filter criteria
in the options that you can select.

74
00:04:26,875 --> 00:04:29,437
Moving back to the query tool,

75
00:04:30,000 --> 00:04:32,937
I'm going to select criteria

76
00:04:33,125 --> 00:04:36,375
based on the research project
that I'm interested in.

77
00:04:37,062 --> 00:04:39,437
So as as my researcher,

78
00:04:39,625 --> 00:04:42,937
I'm going to select the NTC as my cohort.

79
00:04:45,875 --> 00:04:46,750
And you can see that

80
00:04:46,750 --> 00:04:50,375
the page of donors
automatically updates to reflect that.

81
00:04:50,375 --> 00:04:52,437
I've chosen the NTC cohort.

82
00:04:52,437 --> 00:04:56,250
So this will occur every time
you make a filter criteria selection.

83
00:04:57,562 --> 00:05:01,437
Next, I'm going to choose P,
which as my HIV status,

84
00:05:01,437 --> 00:05:05,187
which reflects patients with HIV,

85
00:05:07,187 --> 00:05:09,500
I'm going to choose black as the race.

86
00:05:13,125 --> 00:05:16,062
I'm going to choose specimen
availability is yes,

87
00:05:16,062 --> 00:05:18,375
because I'm interested
in acquiring frontal cortex

88
00:05:20,562 --> 00:05:22,500
and I'm going to choose substance

89
00:05:22,500 --> 00:05:24,687
abuse history as present.

90
00:05:30,000 --> 00:05:30,750
So now you can see

91
00:05:30,750 --> 00:05:34,875
the results have generated
772 participants.

92
00:05:34,875 --> 00:05:37,812
They're kind of creating
a good pool of eligible donors

93
00:05:38,125 --> 00:05:42,000
from which the consortium can help select
those ideal specimens from.

94
00:05:42,812 --> 00:05:46,562
So if I'm happy with my results, I'm
going to click Save and continue.

95
00:05:49,500 --> 00:05:51,250
The system
will then bring me to the next great

96
00:05:51,250 --> 00:05:54,375
tool page called Specimen Search,
which allows me to visualize

97
00:05:54,375 --> 00:05:58,125
the availability of specimens from donors
selected in the donor search page.

98
00:05:59,437 --> 00:06:02,687
This is the
the visualization of all the specimens

99
00:06:03,312 --> 00:06:06,312
and their current preparations
that are available from the list

100
00:06:06,312 --> 00:06:09,187
of specimens from the list of donors
of selected earlier.

101
00:06:09,750 --> 00:06:13,187
I can also look at the status of specimens
to check the availability

102
00:06:13,437 --> 00:06:15,250
of all the specimens.

103
00:06:15,250 --> 00:06:19,750
Next, I want to make my specimen
categorization criteria selection,

104
00:06:20,250 --> 00:06:24,187
so I'm interested in acquiring
frontal cortex specimens for my donors.

105
00:06:24,750 --> 00:06:27,437
So I'm going to select
from the specimen category of CNS,

106
00:06:29,812 --> 00:06:32,750
and then I'm going to select
frontal cortex.

107
00:06:34,062 --> 00:06:37,500
If I wanted to select more than one
specimen, here's where I would do it.

108
00:06:37,500 --> 00:06:40,000
I would select another option
from the dropdown list,

109
00:06:41,625 --> 00:06:43,812
and then
the the results would update accordingly.

110
00:06:44,375 --> 00:06:47,500
So I'm ultimately only interested
in acquiring frontal cortex at the moment.

111
00:06:48,187 --> 00:06:51,625
So I'm going to accept the results as is
and then click Save

112
00:06:51,625 --> 00:06:55,000
and continue to dataset creation.

113
00:06:56,375 --> 00:06:58,062
So on this page, I'm allowed to,

114
00:06:58,062 --> 00:07:02,000
I'm allowed to select the datasets
that I'm interested in obtaining.

115
00:07:02,250 --> 00:07:05,687
They will characterize the specimens
that I'm a obtaining.

116
00:07:06,125 --> 00:07:09,000
So I'm going to choose
demographics, pathology

117
00:07:11,250 --> 00:07:14,062
from the category, from the subcategory.

118
00:07:14,062 --> 00:07:18,000
I'm going to choose donor demographics
and general pathology information,

119
00:07:19,062 --> 00:07:21,437
the variables
I'm going to select all variables

120
00:07:21,437 --> 00:07:23,562
that are available
from those different tables.

121
00:07:24,187 --> 00:07:25,500
And I'm not going to make a selection

122
00:07:25,500 --> 00:07:28,687
for visits
because this data is not visit specific.

123
00:07:29,250 --> 00:07:32,625
Once I've made my selection for datasets
that I'm interested in acquiring,

124
00:07:32,875 --> 00:07:34,437
I'm going to click Save and continue.

125
00:07:37,812 --> 00:07:38,625
This brings me to a

126
00:07:38,625 --> 00:07:41,625
final review page
which summarizes the details of the donors

127
00:07:41,875 --> 00:07:45,187
specimens and data sets have selected
in previous query pages.

128
00:07:45,625 --> 00:07:47,375
The first table

129
00:07:48,375 --> 00:07:52,000
shows the results of the donor
query search showing the number of donors.

130
00:07:52,312 --> 00:07:55,062
So 772 is what

131
00:07:55,062 --> 00:07:58,312
I was able to find
based on these criteria entered.

132
00:07:59,000 --> 00:08:02,687
The second table shows
the specimen search details.

133
00:08:02,687 --> 00:08:06,375
So I'm looking for CNS samples
from frontal cortex

134
00:08:07,125 --> 00:08:08,500
for group one

135
00:08:09,562 --> 00:08:10,875
next to me, able to clarify

136
00:08:10,875 --> 00:08:14,812
exactly the details of the specimens
I'm requesting.

137
00:08:15,500 --> 00:08:18,500
So here you can indicate the specimen
preparation.

138
00:08:18,500 --> 00:08:21,000
So I want frozen dental cortex.

139
00:08:21,562 --> 00:08:24,500
I can indicate the weight
and dimensions of the sample.

140
00:08:24,875 --> 00:08:27,187
So I'm interested in acquiring a 300

141
00:08:28,500 --> 00:08:30,625
milligram block.

142
00:08:32,625 --> 00:08:33,312
I'm interested

143
00:08:33,312 --> 00:08:36,437
interested
in acquiring specimens from three donors.

144
00:08:37,437 --> 00:08:39,625
And I want three.

145
00:08:39,937 --> 00:08:42,187
I want one donor,

146
00:08:42,750 --> 00:08:45,500
one specimen per donor.

147
00:08:47,125 --> 00:08:48,625
The next table kind of summarizes

148
00:08:48,625 --> 00:08:51,687
the data sets that I've I've requested

149
00:08:51,687 --> 00:08:54,687
that should be associated with my data
by my specimens.

150
00:08:56,125 --> 00:08:59,187
The final table

151
00:08:59,375 --> 00:09:03,187
captures all of the contact information
from your from the requester,

152
00:09:03,812 --> 00:09:07,875
the shipping details
and project details about your request

153
00:09:09,437 --> 00:09:11,687
as well as the grant number.

154
00:09:11,687 --> 00:09:14,312
If any funding exists.

155
00:09:15,375 --> 00:09:16,562
Additionally,

156
00:09:16,562 --> 00:09:20,437
there's an area on the bottom
which allows you to upload all requested

157
00:09:20,437 --> 00:09:23,625
application materials,
including the processing checklist.

158
00:09:24,187 --> 00:09:25,875
Your CV,

159
00:09:26,062 --> 00:09:28,375
your supervising CV,

160
00:09:29,062 --> 00:09:31,812
the the project outline or concept
outline,

161
00:09:33,562 --> 00:09:35,812
specimen request, user agreements

162
00:09:37,250 --> 00:09:38,812
and a data user agreement.

163
00:09:38,812 --> 00:09:41,000
If you're requesting datasets only.

164
00:09:41,625 --> 00:09:44,062
So you click browse

165
00:09:44,937 --> 00:09:47,625
and this will allow you to
to find your special

166
00:09:47,625 --> 00:09:52,062
your documents of interest and upload
those to the request application.

167
00:09:53,625 --> 00:09:54,312
Once you've

168
00:09:54,312 --> 00:09:57,750
confirmed all fields have been completed,
look good,

169
00:09:58,375 --> 00:10:02,312
you're going to save the request draft
and this will allow you to be able

170
00:10:02,312 --> 00:10:05,875
to go back to the request at a future date
and make any updates

171
00:10:06,187 --> 00:10:09,500
or if you're interested
in adding an additional group

172
00:10:09,750 --> 00:10:12,812
clinical group to your application,
you can do so now.

173
00:10:13,812 --> 00:10:16,000
So if I was interested
in adding a new group,

174
00:10:16,500 --> 00:10:19,000
I would click Return to Start
request page.

175
00:10:23,750 --> 00:10:24,875
The system will bring me back

176
00:10:24,875 --> 00:10:28,312
to the first page
and I click update existing request.

177
00:10:29,250 --> 00:10:31,562
I find the request
that I was just working on

178
00:10:33,875 --> 00:10:36,500
and I click Add group.

179
00:10:38,625 --> 00:10:42,125
Now I would go through the exact
same process that I would with group one,

180
00:10:42,562 --> 00:10:44,625
but now I'm going to enter details
for group two.

181
00:10:44,625 --> 00:10:49,562
So if you remember, Group
two was a group with patients without HIV.

182
00:10:50,250 --> 00:10:53,000
So I'm going to click my code
of interest and if you see

183
00:10:55,000 --> 00:10:56,437
clicking patients

184
00:10:56,437 --> 00:10:58,375
without HIV,

185
00:10:59,812 --> 00:11:03,500
clicking black for race,

186
00:11:03,500 --> 00:11:06,375
Specimen availability. Yes.

187
00:11:07,000 --> 00:11:09,187
And substance abuse history present.

188
00:11:12,500 --> 00:11:14,062
You can see for group two.

189
00:11:14,062 --> 00:11:17,750
I have a more limited number of cases
that are meeting criteria

190
00:11:17,750 --> 00:11:20,125
50 to save and continue.

191
00:11:21,312 --> 00:11:24,437
That brings me to the specimen search page

192
00:11:24,750 --> 00:11:28,375
where I'm going to select CNS

193
00:11:28,375 --> 00:11:30,375
frontal cortex

194
00:11:32,250 --> 00:11:32,500
and I'm

195
00:11:32,500 --> 00:11:34,937
a click save
and continue to dataset search.

196
00:11:35,750 --> 00:11:39,250
Again, I want to obtain demographics
and pathology

197
00:11:39,812 --> 00:11:42,187
for all these donors.

198
00:11:43,125 --> 00:11:45,250
Now request donor demographics

199
00:11:45,562 --> 00:11:48,250
in general pathology from the subcategory

200
00:11:48,562 --> 00:11:52,437
and I'm I'm going to request all specimen
all dataset

201
00:11:53,000 --> 00:11:54,125
variables.

202
00:11:56,375 --> 00:11:57,562
Seven Continue.

203
00:11:57,562 --> 00:12:00,250
That brings me to my final

204
00:12:00,250 --> 00:12:02,062
request review page.

205
00:12:02,062 --> 00:12:04,750
We're going to update the specimen details
indicating

206
00:12:04,750 --> 00:12:06,750
I want frozen cortex

207
00:12:08,625 --> 00:12:11,062
300 milligram

208
00:12:11,437 --> 00:12:12,437
block

209
00:12:14,437 --> 00:12:16,812
from three donors

210
00:12:17,937 --> 00:12:18,812
and one block

211
00:12:21,187 --> 00:12:22,187
per donor.

212
00:12:23,062 --> 00:12:26,812
Once I'm happy with my application of up
to uploaded all my details

213
00:12:27,312 --> 00:12:30,500
and I'm ready to submit,
I would click submit request

214
00:12:34,000 --> 00:12:36,375
and that will submit your request
to the DCC

215
00:12:36,750 --> 00:12:40,125
for initial screening and review.

216
00:12:42,625 --> 00:12:45,750
And this concludes
my demo of how to use the NTC

217
00:12:45,750 --> 00:12:48,125
query tool
and submit a request application.

218
00:12:49,625 --> 00:12:52,750
Again, please feel free
to reach out to the DCC at any time

219
00:12:53,000 --> 00:12:55,437
if there are any questions
during your use of the tool.

220
00:12:55,812 --> 00:12:58,312
Thank you very much
for your attention and have a good day.
