Labii Documentation
HomeFree SignupFree DemoContact Us
  • Getting Started
    • Introduction
    • Quick Start
  • User Guide
    • Interface
      • Side Menu
      • Views
    • Add Record
      • Add a project
      • Add a blank record
      • Add records in bulk
      • Add a record from a template
      • Add record(s) from file(s)
      • Add a template
    • Record List View
      • Table List View
      • Project List View
      • Row List View
      • ❗Import Records
      • Export Records
      • Bulk Operations
        • Bulk Edit Columns
        • Bulk Edit Sections
        • Bulk Print Detail
        • Bulk Print Labels
        • Bulk Print Barcodes
        • Bulk Print QR Codes
        • Bulk Download
        • Use Selected to Add Blank Record
        • Use Selected to Bulk Add Records
    • Record Detail View
      • Columns
      • Sections
      • Notes
      • Signers
      • Versions
      • Activities
      • Visitors
      • Permissions
      • Section
      • Actions
        • Sign
        • Print
        • Share
    • Navbar
      • Search
        • Global search
        • Search at list view
        • Search query
      • Scan
    • Side Menu
      • Dashboard
      • Calendar
      • Notifications
      • Reload Organization
      • Switch Organization
      • Change Data Center
    • Accounts
      • Authentication
      • Setup an account
      • Create an account
      • My Profile
    • AI Integration
      • Prompt box
      • Prompt template
      • ProtocolGPT
      • AI in Widgets
      • Use cases
  • Admin Guide
    • Organization
    • Backups
    • Personnel
    • Certifications
    • Teams
    • Projects
      • Members
    • Applications
    • Tables
      • Columns
      • Sections
      • Filters
    • Workflows
    • Widgets
    • Subscriptions
    • Credits
    • Invoices
    • Single Sign On
      • Google G Suite
      • Okta
      • OneLogin
      • Microsoft Azure
    • API Keys
  • Widgets
    • Overview
    • Column Widgets
      • Form
        • Text inputs
          • Text
          • MultilineText
          • RichText
          • Number
          • RangeUnit
          • Email
          • Phone
          • Secret
          • Link
          • Address
        • Boolean
          • Checkbox
          • Switch
        • DateTime
          • Date
          • Time
          • DateTime
          • Appointment
          • TimeStamp
          • Timezone
        • Dropdown
          • Select
          • MultiSelect
          • ForeignKey
          • ForeignKeys
          • Member
          • Members
        • File
          • Files
          • Image
          • File Path
          • File Size
          • File Antivirus Status
      • Barcode
        • Barcode
        • QR Code
      • Calculation
        • Formula
        • Numbering
        • RowCount
        • Consumption
      • Integration
        • API
          • API
        • Dropdown
          • API ForeignKey
          • API ForeignKeys
      • Column
        • Record Citation
        • Column Citation
        • Column Data
        • Column Addition
      • Regulation
        • Signature
          • Signature
          • Open Signature
          • Signature Status
      • ❗Chemistry
      • ❗PubMed
      • ❗Device
      • ❗Integration
      • Advanced
        • Subtitle
        • Rating
        • Nested Fields
        • Storage Coordinates
    • Section Widgets
      • Office
        • Text
          • Plain Text
          • CKEditor Classic
          • CKEditor Balloon
          • CKEditor Document
          • CKEditor Restricted
          • CKEditor Classic Controlled
          • Code Editor
        • ❗Table
        • File
          • Files
          • File Preview
        • Google Drive
        • Drawing
        • G Suite
        • Microsoft Office
      • Data Display
        • Columns
          • Columns
          • Metadata
        • Sections
          • Section Display By Record
          • Section Display By ForeignKey
        • Record List
          • Record List
          • Record List by Column
          • Record List by ForeignKey
          • Record List by Query
      • ✅Regulation
        • Signers
        • ✅Audit Trail
          • ✅Activities
          • Versions
          • Visitors
      • Process Management
        • Flowchart
        • Steps
      • Diagram
        • Mermaid
        • Gantt Chart
        • Stage Flowchart
        • Relation Flowchart
      • Reference Manager
      • Biology
        • Plasmid Editor
        • Open Vector Editor
        • Microplate
          • 6-Well Plate
          • 12-Well Plate
          • 24-Well Plate
          • 48-Well Plate
          • 96-Well Plate
          • 384-Well Plate
          • Flexible Well Plate
        • Sample Aliquoting
        • Assay
          • ELISA Standard Curve
          • ELISA Qualitative
          • Dose Response Curve
        • Protein
          • MolStar
          • RCSB Saguaro
        • Bioinformatics
          • QUiCKR Analysis
          • CRISPResso2
      • Chemistry
        • Chemical Formats
        • Chemical Drawing
        • Chemical Analysis
        • Chemical Reaction
      • Combination
        • Clinical Genomicist Workstation
      • Productivity
        • ✅Calendars
          • Calendar
          • Scheduling
        • Automation
          • Workflows
        • Ungrouped
          • Storage Map
        • Table of Contents
        • Communication
          • Email Template
          • Notifications
          • Comments
        • Barcode
        • ToDo
        • Timer
      • Report
        • Record Summary
          • Record Summary
        • Data Driven Charts
          • Chart By Category X
          • Chart By Numeric X
        • Custom Input Charts
          • Data Visualizer
    • Dashboard Widgets
      • Labii
      • Shortcut
        • Applications
        • Links
        • Filters
      • Productivity
        • Office
        • Flowchart
        • Section
        • Project Management
          • ✅Tasks
        • Summary
      • ✅Reports
        • Record Summary
          • Record Summary By Date
          • Record Summary By Tables
          • Record Summary By Projects
          • Record Summary By Users
        • Data Driven Charts
          • Chart By Category X
          • Chart By Numeric X
        • Matrix
          • Record Count By Filter
        • Audit
          • Storage Audit
      • Integration
        • Quickbooks
          • Quickbooks Customers
          • Quickbooks Accounts
          • Quickbooks Items
          • Quickbooks Invoices
  • API
    • Concepts
      • How to get token from Labii ELN & LIMS
      • How can I load Labii data from API into DataFrame
    • Methods
      • Authentication
      • Notification
      • Organization
      • Personnel
      • Team
      • Organization Widget
      • Statement
      • Backup
      • Project
      • Member
      • Table
      • Column
      • Filter
      • Row
      • Cell
      • Section
      • Activity
      • Version
      • Visitor
      • Workflow
      • Step
      • Widget
    • Variables
    • SDK
      • API Client (python)
      • API Client (javascript)
      • SDK (python)
      • SDK (javascript)
      • Examples
  • Applications
    • Electronic Lab Notebook
      • ELN for Research and Development
      • ELN for Production
      • ELN for ELISA Data Analysis
      • ELN for Dose Response Curve
    • Process Management
      • ❗Report creating process in diagnosis testing
      • ❗Email follow up process in CRM
      • ❗Management of the purchasing, approval, and ordering processes.
    • Sample Management
      • Sample Receiving
      • Track sample consumption
      • Aliquots Management
    • Equipment Management
      • ❗Equipment Scheduling
      • ❗Equipment Maintenance
    • Inventory Management
      • Barcode System
      • Stock Checkin and Checkout
      • Storage Management
      • ❗Purchase Management
    • Laboratory Information Management System
      • LIMS for Sample Testing
      • LIMS for NGS
    • Customer Relationship Management (CRM)
      • Quickbooks Integration
    • Document Management
    • Chemical Registration
    • Mouse Colony Management
    • Diagnostic Testing
    • Diabetes Tracker
    • Project Management
      • Task Management
      • How to manage research goals
    • Reference Management
    • Training Management
  • Support
    • Overview
    • Documentation
    • YouTube
    • Videos
    • Tickets
    • Chat with us
    • Schedule a meeting
    • Take a survey
    • Resources
    • Download
    • Blogs
    • FAQ
    • Other
      • Guidelines for Preparing Documents on Research Needs for Labii Configuration
Powered by GitBook
On this page
  • Overview
  • Before starting
  • Metadata
  • Tables
  • Columns
  • Default Sections
  • Import data
  • CGWCase
  • Create a case
  • Update a case
  • Clear case data
  • CGWUploadFile
  • CGWJob
  • Create a job
  • Cancel a job
  • Check report
  • Download report
  • CGW Workflow
  1. Widgets
  2. Section Widgets
  3. Combination

Clinical Genomicist Workstation

Clinical Genomicist Workstation

PreviousCombinationNextProductivity

Last updated 6 years ago

Overview

(CGW) is a secure, n-tiered application where web browser submits requests to application servers that persist the data in a relational database. CGW is used by Washington University Genomic and Pathology Services for clinical genomic testing of many cancers. CGW is a 'soup-to-nuts' solution to track, analyze, interpret, and report clinical genomic diagnostic tests.

Sharma MK, Phillips J, Agarwal S, Wiggins WS, Shrivastava S, Koul SB, Bhattacharjee M, Houchins CD, Kalakota RR, George B, Meyer RR, Spencer DH, Lockwood CM, Nguyen TT, Duncavage EJ, Al-Kateb H, Cottrell CE, Godala S, Lokineni R, Sawant SM, Chatti V, Surampudi S, Sunkishala RR, Darbha R, Macharla S, Milbrandt JD, Virgin HW, Mitra RD, Head RD, Kulkarni S, Bredemeyer A, Pfeifer JD, Seibert K, Nagarajan R.

AMIA Jt Summits Transl Sci Proc. 2013 Mar 18;2013:156-7. eCollection 2013.

PMID: 24303327

Per the request of our customers, has developed many widgets to perform CGW analysis directly with Labii interface. CGW widgets is developed to create accessions for new cases, create new sequencing runs for cases, upload appropriate data files (VCF/BAM files) for a given sequencing run, begin bioinformatics jobs for generating a pharmacogenomic report, and retrieve reports in pdf format after they have been signed off on by an accredited individual.

Widgets can take full advantages of Labii LIMS () to provide sample specific metadata. Labii widgets simplified the usage of CGW with just a few clicks and enabled the documentation of all analysis process.

Notes: These widgets are private to a certain customer(s) only.

Labii ELN & LIMS currently provides these widgets:

Widget

Type

Description

Column

Create a CGW case

Column

Upload analysis-related files

Section

Generate a job and report

Before starting

Here are some settings needed to be configured before starting using the widgets.

Metadata

These metadata is required:

  • CGW_INSTITUTION: your account username

  • CGW_EMAIL: your email address to login

  • CGW_PASSWORD: your password

  • CGW_VERSION: v2.0.0

Tables

The samples and patients are stored in the tables. These tables are required:

  • samples, to store specimen information

  • patients, to store the patient information

  • disease, to store disease code

  • mass, to store the sample type code

Please create the tables with these settings:

Name singular

Name plural

Description

Unique code

sample

samples

Specimen information

SP

patient

patients

Patient information

PA

disease

diseases

Disease code

DS

mass

masses

Sample type code

MS

Columns

The columns are used to store the attribution of a table.

Samples:

Name

Description

Widget

Default Value

Is Required

dateAccessioned

Date

false

firstName

Text

false

lastName

Text

false

dateOfBirth

Date

false

datecollected

Date

false

dateReceived

Date

false

gender

Select

unknown

male

female

unspecified

other

ambiguous

not_applicable

false

race

Select

american_indian_or_alaska_native

asian

black_or_african_american

native_hawaiian_or_other_pacific_islander

not_reported

unknown

white

false

ethnicity

Select

hispanic_or_latino

not_hispanic_or_latino

not_reported

unknown

false

externalSpecimenId

Text

false

hl7SpecimenId

Text

false

studyIdentifier

Text

false

studySubjectIdentifier

Text

false

type

Sample Type

ForeignKey

MS

true

panelName

Text

false

sampleType

Select

patientcare

true

indication

Text

false

identified

Boolean

1

false

disease

ForeignKey

DS

false

physicians

ForeignKeys

PA

false

accessionNumber

Text

false

case

CGWCase

false

lane

Number

1

false

barcode

Text

false

runType

This identifies whether the sequencing was done using paired end or single end.

Select

pairedEnd

false

analysis_related_files

CGWUploadFile

false

Patients:

No specific columns are required. However, the name field have to be:

[First Name] [Last Name]

Disease:

Name

Widget

Default value

Is required

code

Number

TRUE

code_system

Text

SNOMED-CT

TRUE

Mass:

Name

Widget

Default value

Is required

code

Number

TRUE

code_system

Text

SNOMED-CT

TRUE

Default Sections

Add a default section so that all new records will have the same section. The default section is only needed for samples:

  • Job, use the widget of CGWJob

Import data

CGWCase

CGWCase is a widget to create or update a Case.

Create a case

Click the edit icon and the widget shall collect all necessary information to create a case. Error message will be provided if certain data is missing.

Click Create Case button to create a case. If successful, a case id will be stored for the column.

Update a case

The detail of a case can be updated via update a case. To do that, click the edit icon, and then click the Update Case button.

Clear case data

If for some reason, you want to discard the case and redo the analysis. You can click Clear Case button and then create a new case.

CGWUploadFile

A *.vcf file needs to be uploaded to initial the jobs. Use this widget to upload a *.vcf file. A case needs to be created first for this widget to work.

CGWJob

One or more CGW jobs can be created for one sample. Each section of CGWJob can create one job.

Before creating a CGW job, a CGW case need to be created and a *.vcf file need to be uploaded first.

Create a job

Click Create a job button to create a job.

Once a job is created, the job id will be assigned to the job id.

Cancel a job

Once a job is created, it can be canceled by clicking Cancel Job button.

Note: Currently, the CGW API to cancel job is not working.

Check report

Once a job is generated, the job will start running immediately. It will take around two hours to finish the CGW scripts.

You can use the button Check report to check if the report is complete. If it is complete, a report id will be assigned and you will have the option to download the report.

Download report

Once a report is completed, the report can be downloaded via clicking Download report button.

The report is generated in PDF format, and zipped in a package [Report Id].pdf.gz.

CGW Workflow

  1. Add a new sample, fill in all necessary information.

CGW is account specific, your CGW authentication information needs to be provided and configured in the (Settings -> Organization Detail -> Metadata).

If you already have some data for samples, patients, disease, and/or mass, use function to import them first.

To start a CGW analysis, please follow these steps. This workflow assumes you have configured everything in .

from Case column.

from Analysis related files column.

Add a new section with widget CGWJob (optional, such section will be created automatically if correctly configured in the ).

.

.

.

Clinical Genomicist Workstation
Clinical genomicist workstation.
Labii ELN & LIMS
Laboratory Information Management System
Before starting
Create a new case
Upload a *.vcf file
default sections
Create a new job
Check the report
Download the report
CGWCase
CGWUploadFile
CGWJob
Import
organization metadata