In this document we explore the Tableau dashboard we created earlier from many gene study analysis extracting top genes by fold change from gastrointestinal tract (GIT) pathologies strictly associated with Epstein-Barr Virus (EBV) compared to the top fold change genes we extracted from the Acute Infectious Mono (AIM) and Chronic Active Epstein-Barr Virus (CAEBV). These are all found in gene studies on the National Center for Bioinformatics Information or NCBI database online. We took 5 stimulated genes and 5 inhibited genes in the top genes of the AIM and CAEBV study under GSE85599 to compare to the 5 GIT studies on NPC with mutated LMP1 gene under GSE271486, NPC metastatic compared to normal and non-metastatic GSE299775, Gastric carcinoma or stomach cancer GSE308231 compared to peritoneal metastatic gastric carcinoma, colorectal cancer compared to knockout of the AURKA gene GSE302491, and intrahepatic cholangiocarcinoma or biliary duct cancer with hypoxic state and hypoxic state knocking out the SLC2A1 gene in GSE316921.

We compared gene relations using the filter to select the most up and down regulated or simulated and inhibited genes by foldchange values using the top genes in the pathology dataset from GSE85599 in the top middle right side of the dashboard and compared those results per selected gene of which five up and five down that are also in all the studies’ datasets. There are five studies comparing these GIT EBV associated pathology genes with.

Results:

GIT EBV associated pathology gene relationships to AIM & CAEBV

Now for five genes that are inhibited greatly in AIM or CAEBV.

Now we want to read in all six total data sets of these gene studies that we found genes after filtering and combining with other genes in some of those studies.

library(rmarkdown)
library(randomForest)
## randomForest 4.7-1.2
## Type rfNews() to see new features/changes/bug fixes.

Lets read in the AIM & CAEBV.

pathMono <- "path to this file on AIM and CAEBV"
setwd(pathMono)

monoCAEBV <- read.csv("CAEBV_genes_32670_FCs.csv")
paged_table(monoCAEBV[1:10,]) # 32670X24

Now lets read in the NPC with LMP1 mutation data.

pathNPC_LMP1 <- "path to this file on NPC with LMP1 mutation"
setwd(pathNPC_LMP1)

NPC_LMP1 <- read.csv("NPCEBV_filtered.csv")

paged_table(NPC_LMP1) # 21932 X 19

Now lets read in the NPC metastatic compared to normal and NPC without metastasis.

pathNPC_metastatic <- "path to this file of NPC metastasis compared to normal and non-metastatic"
setwd(pathNPC_metastatic)

NPC_metastatic <- read.csv("EBV_nasopharyngealCarcinoma_NPC_GSE299775_foldchanges.csv")
# 18677 X 35

paged_table(NPC_metastatic[1:10,])

Now read in the gastric carcinoma peritoneal metastasis dataset.

pathGCPM <- "path to your file on the GCPM dataset"
setwd(pathGCPM)

GCPM <- read.csv("allGenes_ready_GCPM_23552k_noNaNsInfs_ordered.csv")
# 23552 X 10

paged_table(GCPM[1:10,])

Now lets read in the colorectal carcinoma with the short hairpin knockout of the AURKA gene as shAURKA.

pathCRC <- "path to your CRC file"
setwd(pathCRC)

CRC <- read.csv("colorectal cancer GSE302491 all genes/Data1_allGenesAndFCs.csv")
# 16122 X 28

paged_table(CRC[1:10,])

And now for the biliary tract cancer or ICC for intrahepatic cholangiocarcinoma.

pathICC <- "your path to the ICC file"
setwd(pathICC)

ICC <- read.csv("allData_FCs_36242X19.csv")
# 36242 X 19

paged_table(ICC[1:10,])

Lets make a character string vector of the 10 genes we want to extract from each of these data sets.

relationalGenes <- c(
  "ASPM", "KIF11","MKI67","TOP2A","CCNA2",
  "GPR84","IL1A","OLR1","PI3","PLAU"
)

relationalGenes
##  [1] "ASPM"  "KIF11" "MKI67" "TOP2A" "CCNA2" "GPR84" "IL1A"  "OLR1"  "PI3"  
## [10] "PLAU"

Get these 10 genes from each dataset.

monoCAEBV10 <- monoCAEBV[which(monoCAEBV$gene %in% relationalGenes),] #10X24

NPC_metastatic10 <- NPC_metastatic[which(NPC_metastatic$ID_REF %in% relationalGenes),] #10X35

NPC_LMP1_10 <- NPC_LMP1[which(NPC_LMP1$gene_name %in% relationalGenes),] #10X19

ICC10 <- ICC[which(ICC$Gene %in% relationalGenes),] #10X19

GCPM10 <- GCPM[which(GCPM$Gene_ID %in% relationalGenes),] #10X10

CRC10 <- CRC[which(CRC$Gene_Symbol %in% relationalGenes),] #10X28

Next we want only the gene symbol ID and the actual samples. We will do this to each of these datasets of 10 genes by removing all other columns like the means and fold changes and for the CRC dataset selecting only the counts, tpm, or fpkm samples that were used. We used all for CRC but lets just select one since they run the same in magnitude for the most part, we will choose the fpkm for fragments per kilomillion.

colnames(CRC10)
##  [1] "Gene_Symbol"         "fpkm_PL1"            "fpkm_PL2"           
##  [4] "fpkm_PL3"            "fpkm_SH1"            "fpkm_SH2"           
##  [7] "fpkm_SH3"            "tpm_PL1"             "tpm_PL2"            
## [10] "tpm_PL3"             "tpm_SH1"             "tpm_SH2"            
## [13] "tpm_SH3"             "read_count_PL1"      "read_count_PL2"     
## [16] "read_count_PL3"      "read_count_SH1"      "read_count_SH2"     
## [19] "read_count_SH3"      "fpkm_baseline_mean"  "fpkm_AURKA_ko_mean" 
## [22] "tpm_baseline_mean"   "tpm_AURKA_ko_mean"   "count_baseline_mean"
## [25] "count_AURKA_ko_mean" "fpkm_FC"             "tpm_FC"             
## [28] "counts_FC"
CRC10_a <- CRC10[,c(1:7)]

paged_table(CRC10_a)
colnames(GCPM10)
##  [1] "GC1"           "GC2"           "GC3"           "PM1"          
##  [5] "PM2"           "PM3"           "Gene_ID"       "GC_mean"      
##  [9] "PM_mean"       "FC_PM_over_GC"
GCPM10_a <- GCPM10[,c(1:7)]

paged_table(GCPM10_a)
colnames(ICC10)
##  [1] "Gene"                    "CAFSHNCCTRL_1"          
##  [3] "CAFSHNCCTRL_2"           "CAFSHNCCTRL_3"          
##  [5] "CAFSHNCHYPO_1"           "CAFSHNCHYPO_2"          
##  [7] "CAFSHNCHYPO_3"           "CAFSHSLCCTRL_1"         
##  [9] "CAFSHSLCCTRL_2"          "CAFSHSLCCTRL_3"         
## [11] "CAFSHSLCHYPO_1"          "CAFSHSLCHYPO_2"         
## [13] "CAFSHSLCHYPO_3"          "WT_noHypoxia_Mean"      
## [15] "WT_Hypoxia_Mean"         "shSLC2A1_noHypoxia_Mean"
## [17] "shSLC2A1_Hypoxia_Mean"   "WT_Foldchange"          
## [19] "shSLC2A1_Foldchange"
ICC10_a <- ICC[,c(1:13)]

paged_table(ICC10_a)
colnames(monoCAEBV10)
##  [1] "ID"                 "gene"               "GSM2279022_AIM"    
##  [4] "GSM2279023_AIM"     "GSM2279024_AIM"     "GSM2279025_CAEBV"  
##  [7] "GSM2279026_AIM"     "GSM2279027_CAEBV"   "GSM2279028_CAEBV"  
## [10] "GSM2279029_CAEBV"   "GSM2279030_CAEBV"   "GSM2279031_healthy"
## [13] "GSM2279032_healthy" "GSM2279033_healthy" "GSM2279034_healthy"
## [16] "GSM2279035_healthy" "GSM2279036_healthy" "GSM2279037_AIM"    
## [19] "GSM2279038_AIM"     "AIM_mean"           "CAEBV_mean"        
## [22] "healthy_mean"       "FC_AIM_healthy"     "FC_CAEBV_healthy"
monoCAEBV10_a <- monoCAEBV10[,c(2:19)]

paged_table(monoCAEBV10_a)
colnames(NPC_LMP1_10)
##  [1] "gene_id"                "gene_name"              "description"           
##  [4] "locus"                  "HNE_1_MUT_LMP1_1_count" "HNE_1_MUT_LMP1_2_count"
##  [7] "HNE_1_MUT_LMP1_3_count" "HNE_1_WT_LMP1_1_count"  "HNE_1_WT_LMP1_2_count" 
## [10] "HNE_1_WT_LMP1_3_count"  "HNE_1_MUT_LMP1_1_FPKM"  "HNE_1_MUT_LMP1_2_FPKM" 
## [13] "HNE_1_MUT_LMP1_3_FPKM"  "HNE_1_WT_LMP1_1_FPKM"   "HNE_1_WT_LMP1_2_FPKM"  
## [16] "HNE_1_WT_LMP1_3_FPKM"   "EBV_mean"               "baseline_mean"         
## [19] "FoldchangeEBV_baseline"

Also, only use fpkm samples in the NPC mutated LMP1 gene.

NPC_LMP1_10_a <- NPC_LMP1_10[,c(2,11:16)]

paged_table(NPC_LMP1_10_a)
colnames(NPC_metastatic10)
##  [1] "ID_REF"                   "GSM9045905_MET"          
##  [3] "GSM9045906_MET"           "GSM9045909_MET"          
##  [5] "GSM9045910_MET"           "GSM9045911_MET"          
##  [7] "GSM9045912_MET"           "GSM9045913_MET"          
##  [9] "GSM9045914_MET"           "GSM9045915_MET"          
## [11] "GSM9045918_MET"           "GSM9045919_MET"          
## [13] "GSM9045928_MET"           "GSM9045929_MET"          
## [15] "GSM9045930_MET"           "GSM9045907_nonMET"       
## [17] "GSM9045908_nonMET"        "GSM9045916_nonMET"       
## [19] "GSM9045917_nonMET"        "GSM9045923_nonMET"       
## [21] "GSM9045924_nonMET"        "GSM9045926_nonMET"       
## [23] "GSM9045927_nonMET"        "GSM9045931_nonMET"       
## [25] "GSM9045932_nonMET"        "GSM9045920_Normal"       
## [27] "GSM9045921_Normal"        "GSM9045922_Normal"       
## [29] "GSM9045925_Normal"        "MET_mean"                
## [31] "nonMET_mean"              "Normal_mean"             
## [33] "MET_Normal_FoldChange"    "nonMET_Normal_FoldChange"
## [35] "MET_nonMET_FoldChange"
NPC_metastatic10_a <- NPC_metastatic10[,c(1:29)]

paged_table(NPC_metastatic10_a)

We are going to stop here due to the timing of this project but it will be resaved, this was 3 hours to find genes on Tableau dashboard and prepare the document this much. We will return to this document later and make the matrices of each of these data tables of 10 genes and order the genes alphabetically, and then test the accuracy in prediction of class of each of these study classes including grouping all normal or healthy samples together. After combining all matrices together with row bind after alphabatized and adding a class feature to those matrices adjusting names of the healthy or normal samples where we had them available. We will see if some of these pathologies using these 10 genes of 5 stimulated and 5 inhibited in common with the AIM and CAEBV data shows shifting in classification towards other pathologies or one other pathology or only to itself or healthy. We will break down the samples in each class for each dataset as well to see how balanced these samples will be when classifying.

Thanks so much.