...
- User wishes to create a task that will generate additional DNA pairs for genome analysis
Show all female lung cancer participants who have tumor RNA (> 5 ug) AND tumor DNA (>5 ug) from a tumor specimen
Search for DNA/RNA - User wants to find a unique set of participants for genome analysis
Show all lung cancer patients who have had lung tumor specimens collected AND who have also had a second, non-lung tumor collected. Return values of Specimen ID number, specimen availability, and specimen location.
Matched samples query - User wants to find participants for a serum biomarker study
Show all lung cancer patients for whom a pre-operative serum sample, a 30-120 day post operative day serum sample, and a primary tumor tissue sample has been collected. Return values of Specimen ID number, specimen availability, and specimen location.
Query based on multiple time-points - User is looking for slides to distribute for a tumor tissue survey study
Find all segments of type “frozen section slide” that are status=available and that correspond to tissue class="primary" tumor. Return values of segment ID number, specimen ID number, tissue site, date created, quantity, and storage location.
Search for tissue slides - User is preparing a utilization review report
Return all specimens / segments / samples distributed in the past year.
Query based on distributed samples - User is looking for potential pairs of primary and relapse tumor specimens (Parameterized Query)
Return all participants where tumor specimens have been collected at multiple time points.
Search for tissue collected at various date range - Query for samples based on list of MRNs
User has a list of MRNs for participants who were given a treatment (or treated with drug 'X'). The user needs to check for samples taken from these participants and stored in the biobank.
Search based on MRNs - Search for samples based on time different (Temporal Query)
User wants to find all aliquots which are processed within 30 minutes of collection
Search based on time difference - Search based on countSummary reports(Count based queries)
User wants to find count of participants by race and ethnicity per protocol
Summary report (Pivot Table)
...