#plots the figures in place instead of a new window
%matplotlib inline

import matplotlib.pyplot as plt
import seaborn as sns

import pandas as pd
import numpy as np

import io
import requests

from timeit import default_timer as timer
from sklearn.manifold import TSNE

import altair as alt
# for the notebook only (not for JupyterLab) run this command once per session
alt.renderers.enable('notebook')
alt.data_transformers.disable_max_rows()

from umap import UMAP

# Install a conda package in the current Jupyter kernel
#import sys
#!conda install --yes --prefix {sys.prefix} requests
#!conda install --yes --prefix {sys.prefix} -c conda-forge umap-learn

Auth¶

base_url = "http://localhost:9000"
user="Harry Potter"
pw="Alohomora"

session = requests.Session()
session.auth = (user, pw)

# Login 
request = session.post(base_url+"/login", params={"username":user,"password":pw,"remember":"True"})

"Success" if request.status_code == 200 else "Failed"

'Success'

#session.cookies

Collect Data¶

def get_data_frame(url):
    request = session.get(url)
    df = pd.read_json(io.StringIO(request.content.decode('utf-8')))
    return df

# Using Cohort backend to get just the ids
#tissue_url = base_url+"/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000135679"
#tissues = get_data_frame(tissue_url)

#tissues.tail()

# Using TDP backennd to get all the data
tissue_url = base_url + "/api/tdp/db/publicdb/tissue/filter?filter_species=human"
# cellline_url = base_url + "/api/tdp/db/publicdb/cellline/filter?filter_species=human"

request = session.get(tissue_url)
tissues = pd.read_json(io.StringIO(request.content.decode('utf-8')))
tissues.tail()

# Get the Cancer Gene Census:
# https://ordino-daily.caleydoapp.org/api/tdp/db/publicdb/gene/filter?filter_species=human&filter_panel=Cancer+Gene+Census
gene_url = base_url + "/api/tdp/db/publicdb/gene/filter?filter_species=human&filter_panel=Cancer+Gene+Census"

genes = get_data_frame(gene_url)
genes = genes.filter(items=["symbol", "ensg"])
genes.head()

# For all Tissues (Cohort: 6380)
# URL https://cohort-daily.caleydoapp.org/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000135679

cohort_id = 6380

# Setup dataframe
data = tissues

for index, row in genes.iterrows():
    #if index % 3 == 0: # sample strategy
    score_url = base_url + "/api/cohortdb/db/geneScore?cohortId={}&table=expression&attribute=tpm&ensg={}".format(cohort_id, row["ensg"])
    print(index, row["symbol"], 'URL: ' + score_url)
    score = get_data_frame(score_url)
    score = score.rename(columns={"score": row["symbol"]})
    data = pd.merge(data, score, on="id")

0 A1BG URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000121410
1 ABI1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000136754
2 ABL1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000097007
3 ABL2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000143322
4 ACKR3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000144476
5 ACSL3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000123983
6 ACVR1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000115170
7 ACVR2A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000121989
8 AFF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000172493
9 AFF3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000144218
10 AFF4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000072364
11 AKT1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000142208
12 AKT2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000105221
13 ALK URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000171094
14 AMER1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000184675
15 APC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000134982
16 APOBEC3B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000179750
17 AR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000169083
18 ARHGAP26 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000145819
19 ARHGEF12 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000196914
20 ARID1A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000117713
21 ARID1B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000049618
22 ARID2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000189079
23 ARNT URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000143437
24 ASPSCR1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000169696
25 ASXL1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000171456
26 ATF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000123268
27 ATIC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000138363
28 ATM URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000149311
29 ATP1A1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163399
30 ATP2B3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000067842
31 ATR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000175054
32 ATRX URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000085224
33 AXIN1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000103126
34 AXIN2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000168646
35 B2M URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000166710
36 BAP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163930
37 BCL10 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000142867
38 BCL11A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000119866
39 BCL11B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000127152
40 BCL2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000171791
41 BCL3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000069399
42 BCL6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000113916
43 BCL7A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000110987
44 BCL9 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000116128
45 BCL9L URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000186174
46 BCOR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000183337
47 BCORL1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000085185
48 BCR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000186716
49 BIRC3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000023445
50 BLM URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000197299
51 BMPR1A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000107779
52 BRAF URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000157764
53 BRCA1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000012048
54 BRCA2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000139618
55 BRD3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000169925
56 BRD4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000141867
57 BRIP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000136492
58 BTG1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000133639
59 BTK URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000010671
60 BUB1B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000156970
61 C2orf44 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163026
62 CACNA1D URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000157388
63 CALR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000179218
64 CAMTA1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000171735
65 CANT1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000171302
66 CARD11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000198286
67 CARS URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000110619
68 CASC5 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000137812
69 CASP8 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000064012
70 CBFA2T3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000129993
71 CBFB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000067955
72 CBL URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000110395
73 CBLB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000114423
74 CBLC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000142273
75 CCDC6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000108091
76 CCNB1IP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100814
77 CCND1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000110092
78 CCND2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000118971
79 CCND3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000112576
80 CCNE1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000105173
81 CD274 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000120217
82 CD74 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000019582
83 CD79A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000105369
84 CD79B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000007312
85 CDC73 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000134371
86 CDH1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000039068
87 CDH11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000140937
88 CDK12 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000167258
89 CDK4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000135446
90 CDK6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000105810
91 CDKN1B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000111276
92 CDKN2A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000147889
93 CDKN2C URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000123080
94 CDX2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000165556
95 CEBPA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000245848
96 CHCHD7 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000170791
97 CHD4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000111642
98 CHEK2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000183765
99 CIC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000079432
100 CIITA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000179583
101 CLIP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000130779
102 CLTC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000141367
103 CLTCL1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000070371
104 CNBP URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000169714
105 CNOT3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000088038
106 CNTRL URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000119397
107 COL1A1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000108821
108 COL2A1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000139219
109 CREB1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000118260
110 CREB3L1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000157613
111 CREB3L2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000182158
112 CREBBP URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000005339
113 CRLF2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000205755
114 CRTC1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000105662
115 CRTC3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000140577
116 CSF3R URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000119535
117 CTCF URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000102974
118 CTNNB1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000168036
119 CUX1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000257923
120 CXCR4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000121966
121 CYLD URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000083799
122 DAXX URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000204209
123 DCTN1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000204843
124 DDB2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000134574
125 DDIT3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000175197
126 DDR2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000162733
127 DDX10 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000178105
128 DDX3X URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000215301
129 DDX5 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000108654
130 DDX6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000110367
131 DEK URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000124795
132 DICER1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100697
133 DNAJB1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000132002
134 DNM2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000079805
135 DNMT3A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000119772
136 DROSHA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000113360
137 EBF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000164330
138 EGFR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000146648
139 EIF3E URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000104408
140 EIF4A2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000156976
141 ELF4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000102034
142 ELK4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000158711
143 ELL URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000105656
144 EML4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000143924
145 EP300 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100393
146 EPAS1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000116016
147 EPS15 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000085832
148 ERBB2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000141736
149 ERBB3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000065361
150 ERBB4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000178568
151 ERC1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000082805
152 ERCC2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000104884
153 ERCC3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163161
154 ERCC4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000175595
155 ERCC5 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000134899
156 ERG URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000157554
157 ESR1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000091831
158 ETNK1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000139163
159 ETV1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000006468
160 ETV4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000175832
161 ETV5 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000244405
162 ETV6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000139083
163 EWSR1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000182944
164 EXT1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000182197
165 EXT2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000151348
166 EZH2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000106462
167 EZR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000092820
168 FAM46C URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000183508
169 FANCA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000187741
170 FANCC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000158169
171 FANCD2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000144554
172 FANCE URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000112039
173 FANCF URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000183161
174 FANCG URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000221829
175 FAS URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000026103
176 FAT1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000083857
177 FAT4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000196159
178 FBXO11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000138081
179 FBXW7 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000109670
180 FCGR2B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000072694
181 FCRL4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163518
182 FES URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000182511
183 FEV URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163497
184 FGFR1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000077782
185 FGFR1OP URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000213066
186 FGFR2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000066468
187 FGFR3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000068078
188 FGFR4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000160867
189 FH URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000091483
190 FHIT URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000189283
191 FIP1L1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000145216
192 FLCN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000154803
193 FLI1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000151702
194 FLT3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000122025
195 FLT4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000037280
196 FOXA1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000129514
197 FOXL2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000183770
198 FOXO1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000150907
199 FOXO3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000118689
200 FOXO4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000184481
201 FOXP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000114861
202 FSTL3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000070404
203 FUBP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000162613
204 FUS URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000089280
205 GAS7 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000007237
206 GATA1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000102145
207 GATA2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000179348
208 GATA3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000107485
209 GNA11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000088256
210 GNAQ URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000156052
211 GNAS URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000087460
212 GOLGA5 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000066455
213 GOPC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000047932
214 GPC3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000147257
215 GPHN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000171723
216 GRIN2A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000183454
217 H3F3A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163041
218 H3F3B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000132475
219 HERPUD1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000051108
220 HEY1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000164683
221 HIF1A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100644
222 HIP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000127946
223 HIST1H3B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000124693
224 HLA-A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000206503
225 HLF URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000108924
226 HMGA1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000137309
227 HMGA2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000149948
228 HNF1A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000135100
229 HNRNPA2B1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000122566
230 HOOK3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000168172
231 HOXA11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000005073
232 HOXA13 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000106031
233 HOXA9 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000078399
234 HOXC11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000123388
235 HOXC13 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000123364
236 HOXD11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000128713
237 HOXD13 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000128714
238 HRAS URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000174775
239 HSP90AA1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000080824
240 HSP90AB1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000096384
241 IDH1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000138413
242 IDH2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000182054
243 IKBKB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000104365
244 IKZF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000185811
245 IL2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000109471
246 IL21R URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000103522
247 IL6ST URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000134352
248 IL7R URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000168685
249 IRF4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000137265
250 ITK URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000113263
251 JAK1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000162434
252 JAK2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000096968
253 JAK3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000105639
254 JUN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000177606
255 KAT6A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000083168
256 KAT6B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000156650
257 KCNJ5 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000120457
258 KDM5A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000073614
259 KDM5C URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000126012
260 KDM6A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000147050
261 KDR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000128052
262 KDSR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000119537
263 KEAP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000079999
264 KIF5B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000170759
265 KIT URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000157404
266 KLF4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000136826
267 KLF6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000067082
268 KLK2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000167751
269 KMT2A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000118058
270 KMT2C URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000055609
271 KMT2D URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000167548
272 KRAS URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000133703
273 KTN1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000126777
274 LASP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000002834
275 LCK URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000182866
276 LEF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000138795
277 LIFR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000113594
278 LMNA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000160789
279 LMO1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000166407
280 LMO2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000135363
281 LPP URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000145012
282 LRIG3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000139263
283 LRP1B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000168702
284 LYL1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000104903
285 LZTR1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000099949
286 MAF URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000178573
287 MAFB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000204103
288 MALT1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000172175
289 MAML2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000184384
290 MAP2K1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000169032
291 MAP2K2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000126934
292 MAP2K4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000065559
293 MAP3K1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000095015
294 MAP3K13 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000073803
295 MAPK1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100030
296 MAX URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000125952
297 MDM2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000135679
298 MDM4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000198625
299 MECOM URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000085276
300 MED12 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000184634
301 MEN1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000133895
302 MET URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000105976
303 MITF URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000187098
304 MKL1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000196588
305 MLF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000178053
306 MLH1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000076242
307 MLLT1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000130382
308 MLLT10 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000078403
309 MLLT11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000213190
310 MLLT3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000171843
311 MLLT4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000130396
312 MLLT6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000108292
313 MN1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000169184
314 MPL URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000117400
315 MSH2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000095002
316 MSH6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000116062
317 MSI2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000153944
318 MSN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000147065
319 MTCP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000214827
320 MTOR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000198793
321 MUC1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000185499
322 MUTYH URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000132781
323 MYB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000118513
324 MYC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000136997
325 MYCL URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000116990
326 MYCN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000134323
327 MYD88 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000172936
328 MYH11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000133392
329 MYH9 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100345
330 MYO5A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000197535
331 MYOD1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000129152
332 NAB2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000166886
333 NBN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000104320
334 NCOA1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000084676
335 NCOA2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000140396
336 NCOA4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000138293
337 NCOR1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000141027
338 NCOR2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000196498
339 NDRG1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000104419
340 NF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000196712
341 NF2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000186575
342 NFATC2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000101096
343 NFE2L2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000116044
344 NFIB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000147862
345 NFKB2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000077150
346 NFKBIE URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000146232
347 NIN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100503
348 NKX2-1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000136352
349 NONO URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000147140
350 NOTCH1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000148400
351 NOTCH2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000134250
352 NPM1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000181163
353 NR4A3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000119508
354 NRAS URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000213281
355 NRG1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000157168
356 NSD1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000165671
357 NT5C2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000076685
358 NTRK1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000198400
359 NTRK3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000140538
360 NUMA1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000137497
361 NUP214 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000126883
362 NUP98 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000110713
363 NUTM1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000184507
364 NUTM2A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000184923
365 NUTM2B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000188199
366 OLIG2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000205927
367 P2RY8 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000182162
368 PAFAH1B2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000168092
369 PALB2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000083093
370 PATZ1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100105
371 PAX3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000135903
372 PAX5 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000196092
373 PAX7 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000009709
374 PAX8 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000125618
375 PBRM1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163939
376 PBX1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000185630
377 PCM1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000078674
378 PDCD1LG2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000197646
379 PDE4DIP URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000178104
380 PDGFB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100311
381 PDGFRA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000134853
382 PDGFRB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000113721
383 PER1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000179094
384 PHF6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000156531
385 PHOX2B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000109132
386 PICALM URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000073921
387 PIK3CA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000121879
388 PIK3R1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000145675
389 PIM1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000137193
390 PLAG1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000181690
391 PLCG1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000124181
392 PML URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000140464
393 PMS2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000122512
394 POLE URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000177084
395 POT1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000128513
396 POU2AF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000110777
397 POU5F1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000204531
398 PPARG URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000132170
399 PPFIBP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000110841
400 PPM1D URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000170836
401 PPP2R1A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000105568
402 PPP6C URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000119414
403 PRCC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000143294
404 PRDM1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000057657
405 PRDM16 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000142611
406 PREX2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000046889
407 PRF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000180644
408 PRKACA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000072062
409 PRKAR1A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000108946
410 PRRX1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000116132
411 PSIP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000164985
412 PTCH1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000185920
413 PTEN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000171862
414 PTK6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000101213
415 PTPN11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000179295
416 PTPN13 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163629
417 PTPRB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000127329
418 PTPRC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000081237
419 PTPRK URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000152894
420 PTPRT URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000196090
421 QKI URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000112531
422 RABEP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000029725
423 RAC1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000136238
424 RAD21 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000164754
425 RAD51B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000182185
426 RAF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000132155
427 RANBP2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000153201
428 RAP1GDS1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000138698
429 RARA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000131759
430 RB1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000139687
431 RBM10 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000182872
432 RBM15 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000162775
433 RECQL4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000160957
434 REL URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000162924
435 RET URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000165731
436 RHOA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000067560
437 RHOH URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000168421
438 RMI2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000175643
439 RNF213 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000173821
440 RNF43 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000108375
441 ROS1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000047936
442 RPL10 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000147403
443 RPL22 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000116251
444 RPL5 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000122406
445 RPN1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163902
446 RSPO2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000147655
447 RSPO3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000146374
448 RUNX1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000159216
449 RUNX1T1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000079102
450 SALL4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000101115
451 SBDS URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000126524
452 SDC4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000124145
453 SDHA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000073578
454 SDHAF2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000167985
455 SDHB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000117118
456 SDHC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000143252
457 SDHD URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000204370
458 SET URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000119335
459 SETBP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000152217
460 SETD2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000181555
461 SF3B1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000115524
462 SFPQ URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000116560
463 SFRP4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000106483
464 SH2B3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000111252
465 SH3GL1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000141985
466 SLC34A2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000157765
467 SLC45A3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000158715
468 SMAD2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000175387
469 SMAD3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000166949
470 SMAD4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000141646
471 SMARCA4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000127616
472 SMARCB1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000099956
473 SMARCD1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000066117
474 SMARCE1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000073584
475 SMO URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000128602
476 SND1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000197157
477 SOCS1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000185338
478 SOX2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000181449
479 SPEN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000065526
480 SPOP URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000121067
481 SRC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000197122
482 SRSF3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000112081
483 SS18 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000141380
484 SS18L1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000184402
485 SSX1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000126752
486 SSX2B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000157950
487 SSX4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000204645
488 STAG2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000101972
489 STAT3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000168610
490 STAT5B URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000173757
491 STAT6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000166888
492 STIL URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000123473
493 STK11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000118046
494 STRN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000115808
495 SUFU URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000107882
496 SUZ12 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000178691
497 SYK URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000165025
498 TAF15 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000172660
499 TAL1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000162367
500 TAL2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000186051
501 TBL1XR1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000177565
502 TBX3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000135111
503 TCEA1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000187735
504 TCF12 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000140262
505 TCF3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000071564
506 TCF7L2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000148737
507 TCL1A URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100721
508 TERT URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000164362
509 TET1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000138336
510 TET2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000168769
511 TFE3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000068323
512 TFEB URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000112561
513 TFG URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000114354
514 TGFBR2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000163513
515 TLX1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000107807
516 TLX3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000164438
517 TMEM127 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000135956
518 TMPRSS2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000184012
519 TNFAIP3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000118503
520 TNFRSF14 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000157873
521 TNFRSF17 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000048462
522 TOP1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000198900
523 TP53 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000141510
524 TP63 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000073282
525 TPM3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000143549
526 TPM4 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000167460
527 TPR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000047410
528 TRAF7 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000131653
529 TRIM24 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000122779
530 TRIM27 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000204713
531 TRIM33 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000197323
532 TRIP11 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000100815
533 TRRAP URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000196367
534 TSC1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000165699
535 TSC2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000103197
536 TSHR URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000165409
537 U2AF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000160201
538 UBR5 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000104517
539 USP6 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000129204
540 USP8 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000138592
541 VHL URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000134086
542 WAS URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000015285
543 WHSC1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000109685
544 WHSC1L1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000147548
545 WIF1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000156076
546 WRN URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000165392
547 WT1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000184937
548 WWTR1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000018408
549 XPA URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000136936
550 XPC URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000154767
551 XPO1 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000082898
552 YWHAE URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000108953
553 ZBTB16 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000109906
554 ZFHX3 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000140836
555 ZMYM2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000121741
556 ZNF331 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000130844
557 ZNF384 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000126746
558 ZNF521 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000198795
559 ZRSR2 URL: http://localhost:9000/api/cohortdb/db/geneScore?cohortId=6380&table=expression&attribute=tpm&ensg=ENSG00000169249

data.head()

data[data.columns[20]].name

'A1BG'

Expressions¶

log_data = data.copy(deep=True)
numerics = ['int16', 'int32', 'int64', 'float16', 'float32', 'float64']
for c in [c for c in log_data.iloc[:, 20:].columns if log_data[c].dtype in numerics]:
    log_data[c] = np.log10(log_data[c])

log_data.head()

means = log_data.iloc[:, 20:].mean().dropna().values;
sns.distplot(means)

<matplotlib.axes._subplots.AxesSubplot at 0x7f25c1292e50>

np.percentile(means, 5)

0.17070462214114268

means.shape

(558,)

std = log_data.iloc[:, 20:].std().dropna().values;
sns.distplot(std)

<matplotlib.axes._subplots.AxesSubplot at 0x7f25c1303a90>

np.percentile(std, 5)

0.17441027741362505

TSNE¶

valid_means = log_data.mean().fillna(0)

valid_log_scores = log_data.iloc[:, 20:].fillna(valid_means)

valid_log_scores.isna().describe()

log_data = pd.concat([log_data.iloc[:,:20], valid_log_scores], axis='columns')

sampled_log_data = log_data.sample(frac=0.33, random_state=1)

#tsne data
sampled_log_data.iloc[:, 20:]

start = timer()
scores_embedded = TSNE(n_components=2).fit_transform(sampled_log_data.iloc[:, 20:])
end = timer()
print(end - start) # Time in seconds, e.g. 5.38091952400282

110.77390740000556

scores_embedded.shape

(4070, 2)

df_scores = pd.DataFrame(scores_embedded, columns=['A','B'])
df_scores = pd.concat([df_scores, sampled_log_data["organ"].reset_index(drop=True)], axis='columns')
df_scores

alt.Chart(df_scores).mark_circle(
    opacity=0.6,
    tooltip=alt.TooltipContent('encoding')
).encode(
    x='A',
    y='B',
    color='organ:N'
).properties(
    width=700, # per plot; see https://altair-viz.github.io/user_guide/configuration.html#view-configuration
    height=700
).interactive()

sampled_log_data.iloc[:, 3:19]

db_cols = sampled_log_data.iloc[:, 3:19]
db_means = db_cols.mean()
valid_db_data = db_cols.fillna(db_means)
valid_db_data.isna().describe()

db_data_embedded = TSNE(n_components=2).fit_transform(pd.get_dummies(valid_db_data))

df_data = pd.DataFrame(db_data_embedded, columns=['A','B'])
df_data = pd.concat([df_data, valid_db_data["organ"].reset_index(drop=True)], axis='columns')
df_data

alt.Chart(df_data).mark_circle(
    opacity=0.6,
    tooltip=alt.TooltipContent('encoding')
).encode(
    x='A',
    y='B',
    color='organ:N'
).properties(
    width=700, # per plot; see https://altair-viz.github.io/user_guide/configuration.html#view-configuration
    height=700
).interactive()

UMAP¶

start = timer()
scores_umap = UMAP(n_components=2).fit_transform(sampled_log_data.iloc[:, 20:])
end = timer()

print(end - start) # Time in seconds, e.g. 5.38091952400282

df_umap_scores = pd.DataFrame(scores_umap, columns=['A','B'])
df_umap_scores = pd.concat([df_umap_scores, sampled_log_data["organ"].reset_index(drop=True)], axis='columns')

alt.Chart(df_umap_scores).mark_circle(
    opacity=0.6,
    tooltip=alt.TooltipContent('encoding')
).encode(
    x='A',
    y='B',
    color='organ:N'
).properties(
    width=700, # per plot; see https://altair-viz.github.io/user_guide/configuration.html#view-configuration
    height=700
).interactive()

/home/klaus/anaconda3/envs/va-project/lib/python3.7/site-packages/umap/spectral.py:229: UserWarning: Embedding a total of 2 separate connected components using meta-embedding (experimental)
  n_components

33.652332699995895

start = timer()
db_umap = UMAP(n_components=2).fit_transform(pd.get_dummies(valid_db_data))
end = timer()

print(end - start) # Time in seconds, e.g. 5.38091952400282

df_umap_db = pd.DataFrame(db_umap, columns=['A','B'])
df_umap_db = pd.concat([df_umap_db, sampled_log_data["organ"].reset_index(drop=True)], axis='columns')

alt.Chart(df_umap_db).mark_circle(
    opacity=0.6,
    tooltip=alt.TooltipContent('encoding')
).encode(
    x='A',
    y='B',
    color='organ:N'
).properties(
    width=700, # per plot; see https://altair-viz.github.io/user_guide/configuration.html#view-configuration
    height=700
).interactive()

24.92483219999849

	id	tdpid	tissuename	species	organ	gender	tumortype	tumortype_adjacent	vendorname	race	ethnicity	age	days_to_death	days_to_last_followup	vital_status	height	weight	bmi	tumorpurity	_id
12329	TCGA-ZS-A9CG-01	2675	TCGA-ZS-A9CG-01	human	liver	male	liver hepatocellular carcinoma	None	TCGA	white	not hispanic or latino	55.0	NaN	341.0	1.0	179.0	94.0	29.34	0.8876	12329
12330	TCGA-ZT-A8OM-01	7527	TCGA-ZT-A8OM-01	human	thymus	female	thymoma	None	TCGA	white	not hispanic or latino	73.0	NaN	1398.0	1.0	172.0	70.0	23.66	NaN	12330
12331	TCGA-ZU-A8S4-01	10825	TCGA-ZU-A8S4-01	human	bile duct	male	cholangiocarcinoma	None	TCGA	white	not hispanic or latino	52.0	98.0	NaN	0.0	183.0	122.0	36.43	NaN	12331
12332	TCGA-ZU-A8S4-11	8411	TCGA-ZU-A8S4-11	human	bile duct	male	normal	cholangiocarcinoma	TCGA	white	not hispanic or latino	52.0	98.0	NaN	0.0	183.0	122.0	36.43	NaN	12332
12333	TCGA-ZX-AA5X-01	699	TCGA-ZX-AA5X-01	human	cervix	female	cervical squamous cell carcinoma and endocervi...	None	TCGA	white	not hispanic or latino	64.0	NaN	119.0	1.0	157.0	56.0	22.72	0.6837	12333

	id	tdpid	tissuename	species	organ	gender	tumortype	tumortype_adjacent	vendorname	race	...	XPC	XPO1	YWHAE	ZBTB16	ZFHX3	ZMYM2	ZNF331	ZNF384	ZNF521	ZRSR2
0	TCGA-02-0001-01	1	TCGA-02-0001-01	human	brain	female	glioblastoma multiforme	None	TCGA	white	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	TCGA-02-0003-01	7	TCGA-02-0003-01	human	brain	male	glioblastoma multiforme	None	TCGA	white	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	TCGA-02-0004-01	922	TCGA-02-0004-01	human	brain	male	glioblastoma multiforme	None	TCGA	white	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	TCGA-02-0006-01	923	TCGA-02-0006-01	human	brain	female	glioblastoma multiforme	None	TCGA	white	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	TCGA-02-0007-01	924	TCGA-02-0007-01	human	brain	female	glioblastoma multiforme	None	TCGA	white	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

	id	tdpid	tissuename	species	organ	gender	tumortype	tumortype_adjacent	vendorname	race	...	XPC	XPO1	YWHAE	ZBTB16	ZFHX3	ZMYM2	ZNF331	ZNF384	ZNF521	ZRSR2
0	TCGA-02-0001-01	1	TCGA-02-0001-01	human	brain	female	glioblastoma multiforme	None	TCGA	white	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	TCGA-02-0003-01	7	TCGA-02-0003-01	human	brain	male	glioblastoma multiforme	None	TCGA	white	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	TCGA-02-0004-01	922	TCGA-02-0004-01	human	brain	male	glioblastoma multiforme	None	TCGA	white	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
3	TCGA-02-0006-01	923	TCGA-02-0006-01	human	brain	female	glioblastoma multiforme	None	TCGA	white	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
4	TCGA-02-0007-01	924	TCGA-02-0007-01	human	brain	female	glioblastoma multiforme	None	TCGA	white	...	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

	A1BG	ABI1	ABL1	ABL2	ACKR3	ACSL3	ACVR1	ACVR2A	AFF1	AFF3	...	XPC	XPO1	YWHAE	ZBTB16	ZFHX3	ZMYM2	ZNF331	ZNF384	ZNF521	ZRSR2
count	12334	12334	12334	12334	12334	12334	12334	12334	12334	12334	...	12334	12334	12334	12334	12334	12334	12334	12334	12334	12334
unique	1	1	1	1	1	1	1	1	1	1	...	1	1	1	1	1	1	1	1	1	1
top	False	False	False	False	False	False	False	False	False	False	...	False	False	False	False	False	False	False	False	False	False
freq	12334	12334	12334	12334	12334	12334	12334	12334	12334	12334	...	12334	12334	12334	12334	12334	12334	12334	12334	12334	12334

	id	tdpid	tissuename	species	organ	gender	tumortype	tumortype_adjacent	vendorname	race	...	XPC	XPO1	YWHAE	ZBTB16	ZFHX3	ZMYM2	ZNF331	ZNF384	ZNF521	ZRSR2
618	TCGA-14-1402-01	8916	TCGA-14-1402-01	human	brain	female	glioblastoma multiforme	None	TCGA	white	...	1.321270	1.962861	2.677202	0.489081	0.754765	1.313858	0.934562	1.500814	0.573240	1.128040
6197	TCGA-CV-5435-11	11604	TCGA-CV-5435-11	human	head and neck	male	normal	head and neck squamous cell carcinoma	TCGA	white	...	1.321270	1.962861	2.677202	0.489081	0.754765	1.313858	0.934562	1.500814	0.573240	1.128040
6305	TCGA-CV-7242-01	7331	TCGA-CV-7242-01	human	head and neck	female	head and neck squamous cell carcinoma	None	TCGA	white	...	1.247566	1.890291	2.724314	0.354844	0.839313	1.256164	0.668645	1.518863	0.266479	1.039739
11158	TCGA-S7-A7WT-01	11227	TCGA-S7-A7WT-01	human	adrenal gland	male	pheochromocytoma and paraganglioma	None	TCGA	white	...	1.233560	1.683544	2.604834	1.206402	0.870323	1.479840	2.236028	1.331275	0.229692	0.964542
2438	TCGA-78-7167-01	10368	TCGA-78-7167-01	human	lung	male	lung adenocarcinoma	None	TCGA	white	...	1.481030	2.031150	2.824798	0.920374	1.112226	1.510808	0.943177	1.574731	0.443484	0.981194
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
3418	TCGA-AB-2895-03	9502	TCGA-AB-2895-03	human	peripheral blood	female	acute myeloid leukemia	None	TCGA	white	...	1.738244	2.480922	2.611394	1.587982	0.963709	2.189749	1.300054	1.888210	0.630459	1.348319
1437	TCGA-37-4132-01	3055	TCGA-37-4132-01	human	lung	female	lung squamous cell carcinoma	None	TCGA	white	...	0.780623	2.087813	2.746068	0.094186	0.509034	1.219543	1.122357	1.312315	0.204607	0.819388
4235	TCGA-B0-5096-11	3175	TCGA-B0-5096-11	human	kidney	female	normal	kidney renal clear cell carcinoma	TCGA	white	...	1.321270	1.962861	2.677202	0.489081	0.754765	1.313858	0.934562	1.500814	0.573240	1.128040
2335	TCGA-75-6206-01	2870	TCGA-75-6206-01	human	lung	male	lung adenocarcinoma	None	TCGA	not reported	...	1.469047	1.849137	2.537927	0.808277	1.288605	1.229700	1.272723	1.537175	0.572366	0.966805
5646	TCGA-CA-6718-01	7733	TCGA-CA-6718-01	human	colon	male	colon adenocarcinoma	None	TCGA	asian	...	1.312994	2.267087	2.843293	0.160806	0.701792	1.406201	0.760741	1.581277	0.448898	1.031560

	symbol	ensg
0	A1BG	ENSG00000121410
1	ABI1	ENSG00000136754
2	ABL1	ENSG00000097007
3	ABL2	ENSG00000143322
4	ACKR3	ENSG00000144476

	A1BG	ABI1	ABL1	ABL2	ACKR3	ACSL3	ACVR1	ACVR2A	AFF1	AFF3	...	XPC	XPO1	YWHAE	ZBTB16	ZFHX3	ZMYM2	ZNF331	ZNF384	ZNF521	ZRSR2
618	0.736255	1.504351	1.479685	0.795403	1.331969	1.669417	1.352171	0.734542	1.233694	0.487639	...	1.321270	1.962861	2.677202	0.489081	0.754765	1.313858	0.934562	1.500814	0.573240	1.128040
6197	0.736255	1.504351	1.479685	0.795403	1.331969	1.669417	1.352171	0.734542	1.233694	0.487639	...	1.321270	1.962861	2.677202	0.489081	0.754765	1.313858	0.934562	1.500814	0.573240	1.128040
6305	0.760259	1.916064	1.434342	0.980366	2.251076	1.595925	1.425603	0.875916	1.398624	0.133649	...	1.247566	1.890291	2.724314	0.354844	0.839313	1.256164	0.668645	1.518863	0.266479	1.039739
11158	1.185259	1.113445	1.438281	0.979697	1.056573	1.551003	1.370583	0.917001	1.218165	0.699684	...	1.233560	1.683544	2.604834	1.206402	0.870323	1.479840	2.236028	1.331275	0.229692	0.964542
2438	1.027299	1.566508	1.527195	0.977599	1.761720	1.902916	1.584201	1.000539	1.329563	1.088788	...	1.481030	2.031150	2.824798	0.920374	1.112226	1.510808	0.943177	1.574731	0.443484	0.981194
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
3418	0.978261	1.879450	1.723323	1.386651	1.205662	1.315916	1.436457	0.453311	2.186671	0.423043	...	1.738244	2.480922	2.611394	1.587982	0.963709	2.189749	1.300054	1.888210	0.630459	1.348319
1437	1.026396	1.503036	1.057095	0.549352	0.898873	1.376989	0.920592	0.612535	0.731901	0.038721	...	0.780623	2.087813	2.746068	0.094186	0.509034	1.219543	1.122357	1.312315	0.204607	0.819388
4235	0.736255	1.504351	1.479685	0.795403	1.331969	1.669417	1.352171	0.734542	1.233694	0.487639	...	1.321270	1.962861	2.677202	0.489081	0.754765	1.313858	0.934562	1.500814	0.573240	1.128040
2335	0.278090	1.646069	1.682118	1.038965	1.479063	1.979701	1.595394	0.846119	1.307468	0.760962	...	1.469047	1.849137	2.537927	0.808277	1.288605	1.229700	1.272723	1.537175	0.572366	0.966805
5646	0.224179	1.609212	1.688673	0.661278	1.125439	2.110182	1.399090	0.540899	1.349443	0.047728	...	1.312994	2.267087	2.843293	0.160806	0.701792	1.406201	0.760741	1.581277	0.448898	1.031560

	A	B	organ
0	-0.936326	-1.071267	brain
1	2.316247	7.413433	head and neck
2	-31.938515	-18.825876	head and neck
3	35.467548	25.419355	adrenal gland
4	-33.970394	17.961533	lung
...	...	...	...
4065	49.850655	33.116673	peripheral blood
4066	-26.985703	14.293324	lung
4067	-0.961433	5.469967	kidney
4068	-34.458096	17.643888	lung
4069	-19.754072	40.816601	colon

	species	organ	gender	tumortype	tumortype_adjacent	vendorname	race	ethnicity	age	days_to_death	days_to_last_followup	vital_status	height	weight	bmi	tumorpurity
count	4070	4070	4070	4070	4070	4070	4070	4070	4070	4070	4070	4070	4070	4070	4070	4070
unique	1	2	2	1	2	1	2	2	1	1	1	1	1	1	1	1
top	False	False	False	False	True	False	False	False	False	False	False	False	False	False	False	False
freq	4070	3950	4037	4070	3712	4070	4037	4037	4070	4070	4070	4070	4070	4070	4070	4070

	A	B	organ
0	13.707384	-57.108288	brain
1	-45.887215	44.250481	head and neck
2	9.730805	-9.038572	head and neck
3	37.941456	-28.796152	adrenal gland
4	-53.639278	38.796764	lung
...	...	...	...
4065	0.880062	74.421074	peripheral blood
4066	-17.877579	-11.893339	lung
4067	11.368949	78.822189	kidney
4068	50.367935	-4.404212	lung
4069	28.615072	47.238781	colon