Published
Edited
Dec 8, 2020
md`# WEBgen doc`
md`## Query a firebrowse JSON`
hosturl = 'https://firebrowse.herokuapp.com' // overall data location
endpointurl = "http://firebrowse.org/api/v1/Samples/mRNASeq" // seq data specifically
jq = require("https://code.jquery.com/jquery-3.4.1.js") // import the json query package
queryJSON = {
let queryJSON = {
format: 'json',
gene: 'SRY',
cohort: 'PAAD',
protocol: 'RSEM',
page: 1,
page_size: 2000,
sort_by: 'cohort'
}
return queryJSON
}
queryurl =jq.param(queryJSON) // formats query into full URL
PAAD_data=(await fetch(hosturl +'?'+endpointurl +'?' + queryurl)).json() // run query
hosturl +'?'+endpointurl +'?' + queryurl
md`## Plot some data with Plotly`
Plotly = require("https://cdn.plot.ly/plotly-latest.min.js")
md`### Sample Plot with fake data`
{
var trace1 = {
x: [1, 2, 3, 4],
y: [10, 15, 13, 17],
mode: 'markers',
type: 'scatter'
};
var trace2 = {
x: [2, 3, 4, 5],
y: [16, 5, 11, 9],
mode: 'lines',
type: 'scatter'
};
var trace3 = {
x: [1, 2, 3, 4],
y: [12, 9, 15, 12],
mode: 'lines+markers',
type: 'scatter'
};
var data = [trace1, trace2, trace3];
const div = DOM.element('div');
Plotly.newPlot(div, data, {width: width});
return div;
}
md`### Plot with TCGA data`
plot_data=PAAD_data.mRNASeq
md`## Clinical Query`
Clinendpointurl = "http://firebrowse.org/api/v1/Samples/Clinical_FH" // clin data specifically
clinQueryJSON = {
let queryJSON = {
format: 'json',
fh_cde_name: "psa_value",
tcga_participant_barcode: "TCGA-2A-A8VL, TCGA-CH-5738", // look into replacing this with barcode so we can take specific patients.
page: '1',
page_size: 2001,
sort_by: 'tcga_participant_barcode'
}
debugger
return queryJSON
}
Clinqueryurl = "http://firebrowse.org/api/v1/Samples/Clinical_FH?format=json&cohort=PRAD&fh_cde_name=psa_value&page=1&page_size=250&sort_by=cohort" // formats query into full URL
temp = jq.param(clinQueryJSON)
PRAD_data=(await fetch(hosturl + '?' + Clinendpointurl +'?'+temp)).json() // run query
// http://firebrowse.org/api/v1/Samples/Clinical_FH?format=json&cohort=PRAD&fh_cde_name=psa_value&page=1&page_size=250&sort_by=cohort
PRAD_data.Clinical_FH
md`#### Comparing the API generated URL with my manual URL, all checks out`
hosturl +'?' + Clinqueryurl
hosturl + '?' + Clinendpointurl + '?' + temp
md`### Extract barcodes from a gene query to query clinical data`
PAAD_data
PAAD_data_trim = PAAD_data.mRNASeq
PAAD_data_trim.length
barcodes = {
var barcodes =[];
for (var i = 0;i < 10; i++){
barcodes.push(PAAD_data_trim[i].tcga_participant_barcode)
}
return barcodes
}
barcodes.join()
newPAADquery = {
let queryJSON = {
format: 'json',
fh_cde_name: "gender",
tcga_participant_barcode: barcodes.join(), // obj is an array of barcodes
page: '1',
page_size: 2001,
sort_by: 'tcga_participant_barcode'
}
return queryJSON
}
tempPAAD = jq.param(newPAADquery)
newPAADclin=(await fetch(hosturl + '?' + Clinendpointurl +'?'+tempPAAD)).json()
hosturl + '?' + Clinendpointurl +'?'+tempPAAD
md `## Integrate clinical with expression`
trimmedClin = newPAADclin.Clinical_FH
PAAD_data_trim
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
