chip <- read_excel("ChIPseq Trametinib mouse hearts.xlsx");
mib <- read_excel("MIB.xlsx"); #every value is sig for at least one rep
kin <- read.csv("kinase.csv"); #every value here is p <.05
tram <- read.csv("tramet.csv");

#every p val for tram that is p<.05
tram <- tram %>%
    filter(pval < .05) %>%
    filter(!Mean.1 == 0);
  1. 116 significant genes from at least one rep in the MIB data
  2. 5183 significant genes from the trametinib data
overlap <- merge(x=tram, y=mib, by.x=c("Gene"),
    by.y=c("Gene...2"));

overlap <- overlap[,c(1,13,49,51,52,54,55,57)]

#add column of average MIB values
overlap$avg <-apply(overlap[,c(3,5,7)],1,mean);
  1. There are 43 overlapping genes of significance between MIB and tram data, inclusive of all reps of MIB.
#filter out the MIB reps that were not sig
df <- overlap %>%
  filter(!overlap$`Significant?...38`=="no" & !overlap$`Significant?...44`=="no");

#make the rna seq pval numeric
df$pval <- as.numeric(df$pval)
  1. When non-significant MIB reps are removed, there are 26 overlapping significant genes.

Looking at Trametinib RNAseq p-values

#ALL TRAM GENES THAT ARE P<.05
p <- tram %>%
  ggplot( aes(x=as.numeric(pval))) +
    geom_histogram( color="#e9ecef", alpha=0.6, position = 'identity', bins=40, fill = "#404080") +
    #scale_x_continuous(breaks = round(seq(min(df$pval), max(df$pval), by = .01),1)) +
    labs(fill="") + gghisto

#ONLY TRAM GENES THAT OVERLAP WITH MIB
 p0 <- df %>%
  ggplot( aes(x=pval)) +
    geom_histogram( color="#e9ecef", alpha=0.6, position = 'identity', bins=25, fill = "#404080") +
    #scale_x_continuous(breaks = round(seq(min(df$pval), max(df$pval), by = .01),1)) +
    labs(fill="") + gghisto

 grid.arrange(p,p0)

Looking at tram MIB avg values


#for the genes that overlap at least ONE mib rep and the tram RNAseq
p1 <- overlap %>%
  ggplot( aes(x=avg)) +
    geom_histogram( color="#e9ecef", alpha=0.6, position = 'identity', bins=22, fill = "#404080") +
    scale_x_continuous(breaks = round(seq(-6, 2, by = .2),1)) +
    labs(fill="") + ggtitle("Distribution of avg MIB values for at least 1 rep overlapping gene") + gghisto

#for the n=26 genes that overlap RNAseq and all three reps of the MIB data
p2 <- df %>%
  ggplot( aes(x=avg)) +
    geom_histogram( color="#e9ecef", alpha=0.6, position = 'identity', bins=22, fill = "#404080") +
    #scale_x_continuous(breaks = round(seq(min(overlap$avg), max(mib$AVG...36), by = .4),1)) +
    labs(fill="") + ggtitle("Distribution of avg MIB values for ALL reps overlapping genes") + gghisto

grid.arrange(p1,p2)

p3 <- ggplot(df, aes(pval, avg, label=Gene)) + geom_point(aes(color="pink",size=2,alpha=.7)) + ggtitle("RNAseq pval vs MIB avg") + gghisto + theme(legend.position = "none") + 
  geom_label_repel(aes(label = Gene),
                  box.padding   = 0.25, 
                  point.padding = 0.4,
                  segment.color = 'grey50')

p4 <- ggplot(df, aes(avg, pval, label=Gene)) + geom_point(aes(color="pink",size=4,alpha=.7)) + ggtitle("RNAseq pval vs MIB avg") + gghisto + theme(legend.position = "none") + 
  geom_label_repel(aes(label = Gene),
                  box.padding   = 0.25, 
                  point.padding = 0.4,
                  segment.color = 'grey50')

The variable pval gives the p-value from the trametinib RNAseq analysis. The variable avg takes the average value from the three replicates of the MIB data. Here, these two valyes are correlated.

#grid.arrange(p1,p2,nrow=1)
p3;p4

correlation

cor(df$pval,df$avg)
[1] -0.03682366

There appears to be no relationship between protein average and RNAseq p-value.

LS0tCnRpdGxlOiAia2luYXNlIGNhcmRpb3RveGljaXR5IHYyIgpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sKLS0tCgpgYGB7cixlY2hvPUZBTFNFLCBtZXNzYWdlPUZBTFNFfQpsaWJyYXJ5KGdncHVicik7bGlicmFyeShyZWFkeGwpO2xpYnJhcnkoZ2dwbG90Mik7bGlicmFyeSh0eGltcG9ydCk7bGlicmFyeShkcGx5cik7bGlicmFyeShncmlkRXh0cmEpO2xpYnJhcnkoZ2dyZXBlbCkKYGBgCgpgYGB7ciAsZWNobz1GQUxTRSwgbWVzc2FnZT1GQUxTRX0KI3Bsb3QgZWxlbWVudHMKZ2doaXN0byA8LSBsaXN0KAogIHRoZW1lKGF4aXMudGV4dC54ID0gZWxlbWVudF90ZXh0KGZhY2U9ImJvbGQiLCBjb2xvcj0icm95YWxibHVlNCIsIHNpemU9MTIpLAogICAgICAgICAgYXhpcy50ZXh0LnkgPSBlbGVtZW50X3RleHQoZmFjZT0iYm9sZCIsIGNvbG9yPSJyb3lhbGJsdWU0IiwgCiAgICAgICAgICBzaXplPTEyLCBhbmdsZT0yNSksCiAgICAgICAgICBheGlzLnRpdGxlPWVsZW1lbnRfdGV4dChzaXplPTE0LGZhY2U9Iml0YWxpYyIpLAogICAgICAgICAgcGxvdC50aXRsZSA9IGVsZW1lbnRfdGV4dChzaXplPTE0LGZhY2U9ImJvbGQiKSkpCmBgYAoKYGBge3IsIG1lc3NhZ2U9RkFMU0V9CmNoaXAgPC0gcmVhZF9leGNlbCgiQ2hJUHNlcSBUcmFtZXRpbmliIG1vdXNlIGhlYXJ0cy54bHN4Iik7Cm1pYiA8LSByZWFkX2V4Y2VsKCJNSUIueGxzeCIpOyAjZXZlcnkgdmFsdWUgaXMgc2lnIGZvciBhdCBsZWFzdCBvbmUgcmVwCmtpbiA8LSByZWFkLmNzdigia2luYXNlLmNzdiIpOyAjZXZlcnkgdmFsdWUgaGVyZSBpcyBwIDwuMDUKdHJhbSA8LSByZWFkLmNzdigidHJhbWV0LmNzdiIpOwoKI2V2ZXJ5IHAgdmFsIGZvciB0cmFtIHRoYXQgaXMgcDwuMDUKdHJhbSA8LSB0cmFtICU+JQogICAgZmlsdGVyKHB2YWwgPCAuMDUpICU+JQogICAgZmlsdGVyKCFNZWFuLjEgPT0gMCk7CmBgYAoKMS4gMTE2IHNpZ25pZmljYW50IGdlbmVzIGZyb20gYXQgbGVhc3Qgb25lIHJlcCBpbiB0aGUgTUlCIGRhdGEKMi4gNTE4MyBzaWduaWZpY2FudCBnZW5lcyBmcm9tIHRoZSB0cmFtZXRpbmliIGRhdGEKCgpgYGB7ciwgbWVzc2FnZT1GQUxTRSx3YXJuaW5nPUZBTFNFfQpvdmVybGFwIDwtIG1lcmdlKHg9dHJhbSwgeT1taWIsIGJ5Lng9YygiR2VuZSIpLAogICAgYnkueT1jKCJHZW5lLi4uMiIpKTsKCm92ZXJsYXAgPC0gb3ZlcmxhcFssYygxLDEzLDQ5LDUxLDUyLDU0LDU1LDU3KV0KCiNhZGQgY29sdW1uIG9mIGF2ZXJhZ2UgTUlCIHZhbHVlcwpvdmVybGFwJGF2ZyA8LWFwcGx5KG92ZXJsYXBbLGMoMyw1LDcpXSwxLG1lYW4pOwpgYGAKMS4gVGhlcmUgYXJlIDQzIG92ZXJsYXBwaW5nIGdlbmVzIG9mIHNpZ25pZmljYW5jZSBiZXR3ZWVuIE1JQiBhbmQgdHJhbSBkYXRhLCBpbmNsdXNpdmUgb2YgYWxsIHJlcHMgb2YgTUlCLgoKCmBgYHtyLCBtZXNzYWdlPUZBTFNFLHdhcm5pbmc9RkFMU0V9CiNmaWx0ZXIgb3V0IHRoZSBNSUIgcmVwcyB0aGF0IHdlcmUgbm90IHNpZwpkZiA8LSBvdmVybGFwICU+JQogIGZpbHRlcighb3ZlcmxhcCRgU2lnbmlmaWNhbnQ/Li4uMzhgPT0ibm8iICYgIW92ZXJsYXAkYFNpZ25pZmljYW50Py4uLjQ0YD09Im5vIik7CgojbWFrZSB0aGUgcm5hIHNlcSBwdmFsIG51bWVyaWMKZGYkcHZhbCA8LSBhcy5udW1lcmljKGRmJHB2YWwpCmBgYAoxLiBXaGVuIG5vbi1zaWduaWZpY2FudCBNSUIgcmVwcyBhcmUgcmVtb3ZlZCwgdGhlcmUgYXJlIDI2IG92ZXJsYXBwaW5nIHNpZ25pZmljYW50IGdlbmVzLiAKCiMjIyMgTG9va2luZyBhdCBUcmFtZXRpbmliIFJOQXNlcSBwLXZhbHVlcwpgYGB7ciwgbWVzc2FnZT1GQUxTRSx3YXJuaW5nPUZBTFNFfQojQUxMIFRSQU0gR0VORVMgVEhBVCBBUkUgUDwuMDUKcCA8LSB0cmFtICU+JQogIGdncGxvdCggYWVzKHg9YXMubnVtZXJpYyhwdmFsKSkpICsKICAgIGdlb21faGlzdG9ncmFtKCBjb2xvcj0iI2U5ZWNlZiIsIGFscGhhPTAuNiwgcG9zaXRpb24gPSAnaWRlbnRpdHknLCBiaW5zPTQwLCBmaWxsID0gIiM0MDQwODAiKSArCiAgICAjc2NhbGVfeF9jb250aW51b3VzKGJyZWFrcyA9IHJvdW5kKHNlcShtaW4oZGYkcHZhbCksIG1heChkZiRwdmFsKSwgYnkgPSAuMDEpLDEpKSArCiAgICBsYWJzKGZpbGw9IiIpICsgZ2d0aXRsZSgiQUxMIFRSQU0gR0VORVMgVEhBVCBBUkUgUDwuMDUiKSArIGdnaGlzdG8KCiNPTkxZIFRSQU0gR0VORVMgVEhBVCBPVkVSTEFQIFdJVEggTUlCCiBwMCA8LSBkZiAlPiUKICBnZ3Bsb3QoIGFlcyh4PXB2YWwpKSArCiAgICBnZW9tX2hpc3RvZ3JhbSggY29sb3I9IiNlOWVjZWYiLCBhbHBoYT0wLjYsIHBvc2l0aW9uID0gJ2lkZW50aXR5JywgYmlucz0yOCwgZmlsbCA9ICIjNDA0MDgwIikgKwogICAgI3NjYWxlX3hfY29udGludW91cyhicmVha3MgPSByb3VuZChzZXEobWluKGRmJHB2YWwpLCBtYXgoZGYkcHZhbCksIGJ5ID0gLjAxKSwxKSkgKwogICAgbGFicyhmaWxsPSIiKSsgZ2d0aXRsZSgiT05MWSBUUkFNIEdFTkVTIFRIQVQgT1ZFUkxBUCBXSVRIIE1JQiIpICsgZ2doaXN0bwoKIGdyaWQuYXJyYW5nZShwLHAwKQpgYGAKCgpMb29raW5nIGF0IHRyYW0gTUlCIGF2ZyB2YWx1ZXMgCmBgYHtyLCBtZXNzYWdlPUZBTFNFLHdhcm5pbmc9RkFMU0V9CgojZm9yIHRoZSBnZW5lcyB0aGF0IG92ZXJsYXAgYXQgbGVhc3QgT05FIG1pYiByZXAgYW5kIHRoZSB0cmFtIFJOQXNlcQpwMSA8LSBvdmVybGFwICU+JQogIGdncGxvdCggYWVzKHg9YXZnKSkgKwogICAgZ2VvbV9oaXN0b2dyYW0oIGNvbG9yPSIjZTllY2VmIiwgYWxwaGE9MC42LCBwb3NpdGlvbiA9ICdpZGVudGl0eScsIGJpbnM9MjQsIGZpbGwgPSAiIzQwNDA4MCIpICsKICAgIHNjYWxlX3hfY29udGludW91cyhicmVha3MgPSByb3VuZChzZXEoLTYsIDIsIGJ5ID0gLjIpLDEpKSArCiAgICBsYWJzKGZpbGw9IiIpICsgZ2d0aXRsZSgiRGlzdHJpYnV0aW9uIG9mIGF2ZyBNSUIgdmFsdWVzIGZvciBhdCBsZWFzdCAxIHJlcCBvdmVybGFwcGluZyBnZW5lIikgKyBnZ2hpc3RvCgojZm9yIHRoZSBuPTI2IGdlbmVzIHRoYXQgb3ZlcmxhcCBSTkFzZXEgYW5kIGFsbCB0aHJlZSByZXBzIG9mIHRoZSBNSUIgZGF0YQpwMiA8LSBkZiAlPiUKICBnZ3Bsb3QoIGFlcyh4PWF2ZykpICsKICAgIGdlb21faGlzdG9ncmFtKCBjb2xvcj0iI2U5ZWNlZiIsIGFscGhhPTAuNiwgcG9zaXRpb24gPSAnaWRlbnRpdHknLCBiaW5zPTI0LCBmaWxsID0gIiM0MDQwODAiKSArCiAgICAjc2NhbGVfeF9jb250aW51b3VzKGJyZWFrcyA9IHJvdW5kKHNlcShtaW4ob3ZlcmxhcCRhdmcpLCBtYXgobWliJEFWRy4uLjM2KSwgYnkgPSAuNCksMSkpICsKICAgIGxhYnMoZmlsbD0iIikgKyBnZ3RpdGxlKCJEaXN0cmlidXRpb24gb2YgYXZnIE1JQiB2YWx1ZXMgZm9yIEFMTCByZXBzIG92ZXJsYXBwaW5nIGdlbmVzIikgKyBnZ2hpc3RvCgpncmlkLmFycmFuZ2UocDEscDIpCmBgYAoKYGBge3IsIG1lc3NhZ2U9RkFMU0Usd2FybmluZz1GQUxTRX0KcDMgPC0gZ2dwbG90KGRmLCBhZXMocHZhbCwgYXZnLCBsYWJlbD1HZW5lKSkgKyBnZW9tX3BvaW50KGFlcyhjb2xvcj0icGluayIsc2l6ZT0yLGFscGhhPS43KSkgKyBnZ3RpdGxlKCJSTkFzZXEgcHZhbCB2cyBNSUIgYXZnIikgKyBnZ2hpc3RvICsgdGhlbWUobGVnZW5kLnBvc2l0aW9uID0gIm5vbmUiKSArIAogIGdlb21fbGFiZWxfcmVwZWwoYWVzKGxhYmVsID0gR2VuZSksCiAgICAgICAgICAgICAgICAgIGJveC5wYWRkaW5nICAgPSAwLjI1LCAKICAgICAgICAgICAgICAgICAgcG9pbnQucGFkZGluZyA9IDAuNCwKICAgICAgICAgICAgICAgICAgc2VnbWVudC5jb2xvciA9ICdncmV5NTAnKQoKcDQgPC0gZ2dwbG90KGRmLCBhZXMoYXZnLCBwdmFsLCBsYWJlbD1HZW5lKSkgKyBnZW9tX3BvaW50KGFlcyhjb2xvcj0icGluayIsc2l6ZT00LGFscGhhPS43KSkgKyBnZ3RpdGxlKCJSTkFzZXEgcHZhbCB2cyBNSUIgYXZnIikgKyBnZ2hpc3RvICsgdGhlbWUobGVnZW5kLnBvc2l0aW9uID0gIm5vbmUiKSArIAogIGdlb21fbGFiZWxfcmVwZWwoYWVzKGxhYmVsID0gR2VuZSksCiAgICAgICAgICAgICAgICAgIGJveC5wYWRkaW5nICAgPSAwLjI1LCAKICAgICAgICAgICAgICAgICAgcG9pbnQucGFkZGluZyA9IDAuNCwKICAgICAgICAgICAgICAgICAgc2VnbWVudC5jb2xvciA9ICdncmV5NTAnKQoKYGBgCgpUaGUgdmFyaWFibGUgYHB2YWxgIGdpdmVzIHRoZSBwLXZhbHVlIGZyb20gdGhlIHRyYW1ldGluaWIgUk5Bc2VxIGFuYWx5c2lzLiBUaGUgdmFyaWFibGUgYGF2Z2AgdGFrZXMgdGhlIGF2ZXJhZ2UgdmFsdWUgZnJvbSB0aGUgdGhyZWUgcmVwbGljYXRlcyBvZiB0aGUgTUlCIGRhdGEuIEhlcmUsIHRoZXNlIHR3byB2YWx5ZXMgYXJlIGNvcnJlbGF0ZWQuCgpgYGB7ciwgbWVzc2FnZT1GQUxTRSx3YXJuaW5nPUZBTFNFLCBmaWcuaGVpZ2h0PTQsIGZpZy53aWR0aD01fQojZ3JpZC5hcnJhbmdlKHAxLHAyLG5yb3c9MSkKcDM7cDQKYGBgCgpjb3JyZWxhdGlvbgpgYGB7ciwgbWVzc2FnZT1GQUxTRSx3YXJuaW5nPUZBTFNFfQpjb3IoZGYkcHZhbCxkZiRhdmcpCmBgYApUaGVyZSBhcHBlYXJzIHRvIGJlIG5vIHJlbGF0aW9uc2hpcCBiZXR3ZWVuIHByb3RlaW4gYXZlcmFnZSBhbmQgUk5Bc2VxIHAtdmFsdWUuCgoKYGBge3IsIG1lc3NhZ2U9RkFMU0Usd2FybmluZz1GQUxTRX0KYGBgCgpgYGB7ciwgZWNobz1GQUxTRSwgaW5jbHVkZT1GQUxTRX0KI2RmIDwtIHJlYWQuY3N2KCJhbGxvY2F0aW9ucyAtIFNoZWV0MS5jc3YiKQoKI2RmJFBvcHVsYXRpb24uQmFzZWQuLi4uIDwtIGFzLm51bWVyaWMoZGYkUG9wdWxhdGlvbi5CYXNlZC4uLi4pCmBgYAoKCgoK