annotate ST Kinatest/test-data/ST_Kinatest.R @ 0:b0493d923404 draft

Uploaded
author jfb
date Wed, 27 Jun 2018 11:53:32 -0400
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
b0493d923404 Uploaded
jfb
parents:
diff changeset
1 ImportedSubstrateList<- read.csv("input1", stringsAsFactors=FALSE,header = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
2 NegativeSubstrateList<- read.csv("input2", stringsAsFactors=FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
3 SubstrateBackgroundFrequency<- read.csv("input3", stringsAsFactors=FALSE, header = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
4
b0493d923404 Uploaded
jfb
parents:
diff changeset
5 ScreenerFilename<-"screenerST.csv"
b0493d923404 Uploaded
jfb
parents:
diff changeset
6
b0493d923404 Uploaded
jfb
parents:
diff changeset
7
b0493d923404 Uploaded
jfb
parents:
diff changeset
8
b0493d923404 Uploaded
jfb
parents:
diff changeset
9 FILENAME<-"output1"
b0493d923404 Uploaded
jfb
parents:
diff changeset
10 FILENAME2<-"output2"
b0493d923404 Uploaded
jfb
parents:
diff changeset
11 FILENAME3<-"output3"
b0493d923404 Uploaded
jfb
parents:
diff changeset
12 FILENAME4<-"output4"
b0493d923404 Uploaded
jfb
parents:
diff changeset
13 FILENAME5<-"output5"
b0493d923404 Uploaded
jfb
parents:
diff changeset
14
b0493d923404 Uploaded
jfb
parents:
diff changeset
15
b0493d923404 Uploaded
jfb
parents:
diff changeset
16 SubstrateBackgroundFrequency<-t(SubstrateBackgroundFrequency)
b0493d923404 Uploaded
jfb
parents:
diff changeset
17 # number<-nrow(SubstrateBackgroundFrequency)-1
b0493d923404 Uploaded
jfb
parents:
diff changeset
18 SubstrateBackgroundFrequency<-SubstrateBackgroundFrequency[2:nrow(SubstrateBackgroundFrequency),]
b0493d923404 Uploaded
jfb
parents:
diff changeset
19 Sub<-na.omit(SubstrateBackgroundFrequency)
b0493d923404 Uploaded
jfb
parents:
diff changeset
20 SubstrateBackgroundFrequency<-Sub
b0493d923404 Uploaded
jfb
parents:
diff changeset
21
b0493d923404 Uploaded
jfb
parents:
diff changeset
22 args = commandArgs(trailingOnly=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
23 TodaysKinase<-"AKT"
b0493d923404 Uploaded
jfb
parents:
diff changeset
24
b0493d923404 Uploaded
jfb
parents:
diff changeset
25 #as.character(args[1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
26
b0493d923404 Uploaded
jfb
parents:
diff changeset
27
b0493d923404 Uploaded
jfb
parents:
diff changeset
28
b0493d923404 Uploaded
jfb
parents:
diff changeset
29
b0493d923404 Uploaded
jfb
parents:
diff changeset
30
b0493d923404 Uploaded
jfb
parents:
diff changeset
31
b0493d923404 Uploaded
jfb
parents:
diff changeset
32 OutputMatrix<-"KinaseMatrix.csv"
b0493d923404 Uploaded
jfb
parents:
diff changeset
33 CharacterizationTable<-"CharacterizationTableForThisKinase.csv"
b0493d923404 Uploaded
jfb
parents:
diff changeset
34 SDtable<-"SDtableforthisKinase"
b0493d923404 Uploaded
jfb
parents:
diff changeset
35 SiteSelectivityTable<-"SiteSelectivityForThisKinase"
b0493d923404 Uploaded
jfb
parents:
diff changeset
36
b0493d923404 Uploaded
jfb
parents:
diff changeset
37
b0493d923404 Uploaded
jfb
parents:
diff changeset
38
b0493d923404 Uploaded
jfb
parents:
diff changeset
39 substrates<-matrix(rep("A",times=((nrow(ImportedSubstrateList)-1)*15)),ncol = 15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
40 #SeqsToBeScored<-"asdasd"
b0493d923404 Uploaded
jfb
parents:
diff changeset
41
b0493d923404 Uploaded
jfb
parents:
diff changeset
42 for (i in 2:nrow(ImportedSubstrateList))
b0493d923404 Uploaded
jfb
parents:
diff changeset
43 {
b0493d923404 Uploaded
jfb
parents:
diff changeset
44 substratemotif<-ImportedSubstrateList[i,4:18]
b0493d923404 Uploaded
jfb
parents:
diff changeset
45 T_or_S<-unlist(strsplit(as.character(substratemotif[8]),split = ""))
b0493d923404 Uploaded
jfb
parents:
diff changeset
46 substratemotif[8]<-T_or_S[2]
b0493d923404 Uploaded
jfb
parents:
diff changeset
47 #substratemotif<-paste(substratemotif,sep = "",collapse = "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
48 j=i-1
b0493d923404 Uploaded
jfb
parents:
diff changeset
49 substratemotif<-unlist(substratemotif)
b0493d923404 Uploaded
jfb
parents:
diff changeset
50 substrates[j,1:15]<-substratemotif
b0493d923404 Uploaded
jfb
parents:
diff changeset
51 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
52
b0493d923404 Uploaded
jfb
parents:
diff changeset
53 # SpacesToOs<-c(""="O",)
b0493d923404 Uploaded
jfb
parents:
diff changeset
54 # substrates<-SpacesToOs[substrates]
b0493d923404 Uploaded
jfb
parents:
diff changeset
55
b0493d923404 Uploaded
jfb
parents:
diff changeset
56 #SubstrateBackgroundFrequency[nrow(SubstrateBackgroundFrequency),2]
b0493d923404 Uploaded
jfb
parents:
diff changeset
57
b0493d923404 Uploaded
jfb
parents:
diff changeset
58 if(2==2){
b0493d923404 Uploaded
jfb
parents:
diff changeset
59 Amean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),2]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
60 Cmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),3]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
61 Dmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),4]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
62 Emean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),5]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
63 Fmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),6]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
64 Gmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),7]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
65 Hmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),8]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
66 Imean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),9]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
67 Kmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),10]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
68 Lmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),11]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
69 Mmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),12]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
70 Nmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),13]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
71 Pmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),14]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
72 Qmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),15]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
73 Rmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),16]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
74 Smean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),17]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
75 Tmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),18]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
76 Vmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),19]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
77 Wmean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),20]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
78 Ymean<-mean(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),21]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
79
b0493d923404 Uploaded
jfb
parents:
diff changeset
80 AllMeans<-c(Amean,Cmean,Dmean,Emean,Fmean,Gmean,Hmean,Imean,Kmean,Lmean,Mmean,Nmean,Pmean,Qmean,Rmean,Smean,Tmean,Vmean,Wmean,Ymean)
b0493d923404 Uploaded
jfb
parents:
diff changeset
81
b0493d923404 Uploaded
jfb
parents:
diff changeset
82 Asd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),2]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
83 Csd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),3]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
84 Dsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),4]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
85 Esd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),5]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
86 Fsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),6]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
87 Gsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),7]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
88 Hsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),8]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
89 Isd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),9]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
90 Ksd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),10]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
91 Lsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),11]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
92 Msd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),12]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
93 Nsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),13]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
94 Psd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),14]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
95 Qsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),15]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
96 Rsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),16]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
97 Ssd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),17]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
98 Tsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),18]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
99 Vsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),19]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
100 Wsd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),20]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
101 Ysd<-sd(as.numeric(SubstrateBackgroundFrequency[1:(nrow(SubstrateBackgroundFrequency)),21]), na.rm=TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
102 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
103 AllSDs<-c(Asd,Csd,Dsd,Esd,Fsd,Gsd,Hsd,Isd,Ksd,Lsd,Msd,Nsd,Psd,Qsd,Rsd,Ssd,Tsd,Vsd,Wsd,Ysd)
b0493d923404 Uploaded
jfb
parents:
diff changeset
104 #this is subbackfreq SDs
b0493d923404 Uploaded
jfb
parents:
diff changeset
105
b0493d923404 Uploaded
jfb
parents:
diff changeset
106 SBF_statisticalvalues<-cbind(AllMeans,AllSDs)
b0493d923404 Uploaded
jfb
parents:
diff changeset
107
b0493d923404 Uploaded
jfb
parents:
diff changeset
108 #create the percent table
b0493d923404 Uploaded
jfb
parents:
diff changeset
109 if (1==1){
b0493d923404 Uploaded
jfb
parents:
diff changeset
110 Column1<-substrates[,1]
b0493d923404 Uploaded
jfb
parents:
diff changeset
111 Column2<-substrates[,2]
b0493d923404 Uploaded
jfb
parents:
diff changeset
112 Column3<-substrates[,3]
b0493d923404 Uploaded
jfb
parents:
diff changeset
113 Column4<-substrates[,4]
b0493d923404 Uploaded
jfb
parents:
diff changeset
114 Column5<-substrates[,5]
b0493d923404 Uploaded
jfb
parents:
diff changeset
115 Column6<-substrates[,6]
b0493d923404 Uploaded
jfb
parents:
diff changeset
116 Column7<-substrates[,7]
b0493d923404 Uploaded
jfb
parents:
diff changeset
117 Column8<-substrates[,8]
b0493d923404 Uploaded
jfb
parents:
diff changeset
118 Column9<-substrates[,9]
b0493d923404 Uploaded
jfb
parents:
diff changeset
119 Column10<-substrates[,10]
b0493d923404 Uploaded
jfb
parents:
diff changeset
120 Column11<-substrates[,11]
b0493d923404 Uploaded
jfb
parents:
diff changeset
121 Column12<-substrates[,12]
b0493d923404 Uploaded
jfb
parents:
diff changeset
122 Column13<-substrates[,13]
b0493d923404 Uploaded
jfb
parents:
diff changeset
123 Column14<-substrates[,14]
b0493d923404 Uploaded
jfb
parents:
diff changeset
124 Column15<-substrates[,15]
b0493d923404 Uploaded
jfb
parents:
diff changeset
125
b0493d923404 Uploaded
jfb
parents:
diff changeset
126 spaces1<-sum((Column1%in% ""))
b0493d923404 Uploaded
jfb
parents:
diff changeset
127 spaces2<-sum(Column2%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
128 spaces3<-sum(Column3%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
129 spaces4<-sum(Column4%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
130 spaces5<-sum(Column5%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
131 spaces6<-sum(Column6%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
132 spaces7<-sum(Column7%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
133 spaces8<-sum(Column8%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
134 spaces9<-sum(Column9%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
135 spaces10<-sum(Column10%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
136 spaces11<-sum(Column11%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
137 spaces12<-sum(Column12%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
138 spaces13<-sum(Column13%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
139 spaces14<-sum(Column14%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
140 spaces15<-sum(Column15%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
141
b0493d923404 Uploaded
jfb
parents:
diff changeset
142 A1<-sum(Column1 %in% "A")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
143 A2<-sum(Column2 %in% "A")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
144 A3<-sum(Column3 %in% "A")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
145 A4<-sum(Column4 %in% "A")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
146 A5<-sum(Column5 %in% "A")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
147 A6<-sum(Column6 %in% "A")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
148 A7<-sum(Column7 %in% "A")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
149 A8<-sum(Column8 %in% "A")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
150 A9<-sum(Column9 %in% "A")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
151 A10<-sum(Column10 %in% "A")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
152 A11<-sum(Column11 %in% "A")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
153 A12<-sum(Column12 %in% "A")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
154 A13<-sum(Column13 %in% "A")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
155 A14<-sum(Column14 %in% "A")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
156 A15<-sum(Column15 %in% "A")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
157 AllAs<-cbind(A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
158
b0493d923404 Uploaded
jfb
parents:
diff changeset
159 C1<-sum(Column1 %in% "C")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
160 C2<-sum(Column2 %in% "C")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
161 C3<-sum(Column3 %in% "C")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
162 C4<-sum(Column4 %in% "C")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
163 C5<-sum(Column5 %in% "C")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
164 C6<-sum(Column6 %in% "C")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
165 C7<-sum(Column7 %in% "C")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
166 C8<-sum(Column8 %in% "C")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
167 C9<-sum(Column9 %in% "C")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
168 C10<-sum(Column10 %in% "C")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
169 C11<-sum(Column11 %in% "C")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
170 C12<-sum(Column12 %in% "C")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
171 C13<-sum(Column13 %in% "C")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
172 C14<-sum(Column14 %in% "C")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
173 C15<-sum(Column15 %in% "C")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
174 CllCs<-cbind(C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13,C14,C15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
175
b0493d923404 Uploaded
jfb
parents:
diff changeset
176 D1<-sum(Column1 %in% "D")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
177 D2<-sum(Column2 %in% "D")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
178 D3<-sum(Column3 %in% "D")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
179 D4<-sum(Column4 %in% "D")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
180 D5<-sum(Column5 %in% "D")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
181 D6<-sum(Column6 %in% "D")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
182 D7<-sum(Column7 %in% "D")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
183 D8<-sum(Column8 %in% "D")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
184 D9<-sum(Column9 %in% "D")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
185 D10<-sum(Column10 %in% "D")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
186 D11<-sum(Column11 %in% "D")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
187 D12<-sum(Column12 %in% "D")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
188 D13<-sum(Column13 %in% "D")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
189 D14<-sum(Column14 %in% "D")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
190 D15<-sum(Column15 %in% "D")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
191 DllDs<-cbind(D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12,D13,D14,D15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
192
b0493d923404 Uploaded
jfb
parents:
diff changeset
193 E1<-sum(Column1 %in% "E")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
194 E2<-sum(Column2 %in% "E")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
195 E3<-sum(Column3 %in% "E")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
196 E4<-sum(Column4 %in% "E")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
197 E5<-sum(Column5 %in% "E")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
198 E6<-sum(Column6 %in% "E")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
199 E7<-sum(Column7 %in% "E")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
200 E8<-sum(Column8 %in% "E")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
201 E9<-sum(Column9 %in% "E")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
202 E10<-sum(Column10 %in% "E")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
203 E11<-sum(Column11 %in% "E")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
204 E12<-sum(Column12 %in% "E")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
205 E13<-sum(Column13 %in% "E")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
206 E14<-sum(Column14 %in% "E")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
207 E15<-sum(Column15 %in% "E")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
208 EllEs<-cbind(E1,E2,E3,E4,E5,E6,E7,E8,E9,E10,E11,E12,E13,E14,E15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
209
b0493d923404 Uploaded
jfb
parents:
diff changeset
210
b0493d923404 Uploaded
jfb
parents:
diff changeset
211 F1<-sum(Column1 %in% "F")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
212 F2<-sum(Column2 %in% "F")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
213 F3<-sum(Column3 %in% "F")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
214 F4<-sum(Column4 %in% "F")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
215 F5<-sum(Column5 %in% "F")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
216 F6<-sum(Column6 %in% "F")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
217 F7<-sum(Column7 %in% "F")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
218 F8<-sum(Column8 %in% "F")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
219 F9<-sum(Column9 %in% "F")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
220 F10<-sum(Column10 %in% "F")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
221 F11<-sum(Column11 %in% "F")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
222 F12<-sum(Column12 %in% "F")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
223 F13<-sum(Column13 %in% "F")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
224 F14<-sum(Column14 %in% "F")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
225 F15<-sum(Column15 %in% "F")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
226 FllFs<-cbind(F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
227
b0493d923404 Uploaded
jfb
parents:
diff changeset
228
b0493d923404 Uploaded
jfb
parents:
diff changeset
229 G1<-sum(Column1 %in% "G")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
230 G2<-sum(Column2 %in% "G")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
231 G3<-sum(Column3 %in% "G")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
232 G4<-sum(Column4 %in% "G")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
233 G5<-sum(Column5 %in% "G")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
234 G6<-sum(Column6 %in% "G")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
235 G7<-sum(Column7 %in% "G")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
236 G8<-sum(Column8 %in% "G")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
237 G9<-sum(Column9 %in% "G")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
238 G10<-sum(Column10 %in% "G")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
239 G11<-sum(Column11 %in% "G")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
240 G12<-sum(Column12 %in% "G")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
241 G13<-sum(Column13 %in% "G")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
242 G14<-sum(Column14 %in% "G")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
243 G15<-sum(Column15 %in% "G")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
244 GllGs<-cbind(G1,G2,G3,G4,G5,G6,G7,G8,G9,G10,G11,G12,G13,G14,G15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
245
b0493d923404 Uploaded
jfb
parents:
diff changeset
246
b0493d923404 Uploaded
jfb
parents:
diff changeset
247 H1<-sum(Column1 %in% "H")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
248 H2<-sum(Column2 %in% "H")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
249 H3<-sum(Column3 %in% "H")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
250 H4<-sum(Column4 %in% "H")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
251 H5<-sum(Column5 %in% "H")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
252 H6<-sum(Column6 %in% "H")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
253 H7<-sum(Column7 %in% "H")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
254 H8<-sum(Column8 %in% "H")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
255 H9<-sum(Column9 %in% "H")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
256 H10<-sum(Column10 %in% "H")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
257 H11<-sum(Column11 %in% "H")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
258 H12<-sum(Column12 %in% "H")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
259 H13<-sum(Column13 %in% "H")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
260 H14<-sum(Column14 %in% "H")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
261 H15<-sum(Column15 %in% "H")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
262 HllHs<-cbind(H1,H2,H3,H4,H5,H6,H7,H8,H9,H10,H11,H12,H13,H14,H15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
263
b0493d923404 Uploaded
jfb
parents:
diff changeset
264
b0493d923404 Uploaded
jfb
parents:
diff changeset
265 I1<-sum(Column1 %in% "I")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
266 I2<-sum(Column2 %in% "I")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
267 I3<-sum(Column3 %in% "I")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
268 I4<-sum(Column4 %in% "I")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
269 I5<-sum(Column5 %in% "I")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
270 I6<-sum(Column6 %in% "I")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
271 I7<-sum(Column7 %in% "I")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
272 I8<-sum(Column8 %in% "I")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
273 I9<-sum(Column9 %in% "I")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
274 I10<-sum(Column10 %in% "I")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
275 I11<-sum(Column11 %in% "I")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
276 I12<-sum(Column12 %in% "I")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
277 I13<-sum(Column13 %in% "I")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
278 I14<-sum(Column14 %in% "I")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
279 I15<-sum(Column15 %in% "I")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
280 IllIs<-cbind(I1,I2,I3,I4,I5,I6,I7,I8,I9,I10,I11,I12,I13,I14,I15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
281
b0493d923404 Uploaded
jfb
parents:
diff changeset
282
b0493d923404 Uploaded
jfb
parents:
diff changeset
283 K1<-sum(Column1 %in% "K")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
284 K2<-sum(Column2 %in% "K")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
285 K3<-sum(Column3 %in% "K")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
286 K4<-sum(Column4 %in% "K")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
287 K5<-sum(Column5 %in% "K")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
288 K6<-sum(Column6 %in% "K")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
289 K7<-sum(Column7 %in% "K")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
290 K8<-sum(Column8 %in% "K")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
291 K9<-sum(Column9 %in% "K")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
292 K10<-sum(Column10 %in% "K")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
293 K11<-sum(Column11 %in% "K")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
294 K12<-sum(Column12 %in% "K")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
295 K13<-sum(Column13 %in% "K")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
296 K14<-sum(Column14 %in% "K")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
297 K15<-sum(Column15 %in% "K")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
298 KllKs<-cbind(K1,K2,K3,K4,K5,K6,K7,K8,K9,K10,K11,K12,K13,K14,K15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
299
b0493d923404 Uploaded
jfb
parents:
diff changeset
300
b0493d923404 Uploaded
jfb
parents:
diff changeset
301 L1<-sum(Column1 %in% "L")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
302 L2<-sum(Column2 %in% "L")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
303 L3<-sum(Column3 %in% "L")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
304 L4<-sum(Column4 %in% "L")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
305 L5<-sum(Column5 %in% "L")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
306 L6<-sum(Column6 %in% "L")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
307 L7<-sum(Column7 %in% "L")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
308 L8<-sum(Column8 %in% "L")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
309 L9<-sum(Column9 %in% "L")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
310 L10<-sum(Column10 %in% "L")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
311 L11<-sum(Column11 %in% "L")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
312 L12<-sum(Column12 %in% "L")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
313 L13<-sum(Column13 %in% "L")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
314 L14<-sum(Column14 %in% "L")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
315 L15<-sum(Column15 %in% "L")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
316 LllLs<-cbind(L1,L2,L3,L4,L5,L6,L7,L8,L9,L10,L11,L12,L13,L14,L15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
317
b0493d923404 Uploaded
jfb
parents:
diff changeset
318
b0493d923404 Uploaded
jfb
parents:
diff changeset
319 M1<-sum(Column1 %in% "M")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
320 M2<-sum(Column2 %in% "M")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
321 M3<-sum(Column3 %in% "M")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
322 M4<-sum(Column4 %in% "M")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
323 M5<-sum(Column5 %in% "M")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
324 M6<-sum(Column6 %in% "M")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
325 M7<-sum(Column7 %in% "M")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
326 M8<-sum(Column8 %in% "M")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
327 M9<-sum(Column9 %in% "M")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
328 M10<-sum(Column10 %in% "M")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
329 M11<-sum(Column11 %in% "M")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
330 M12<-sum(Column12 %in% "M")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
331 M13<-sum(Column13 %in% "M")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
332 M14<-sum(Column14 %in% "M")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
333 M15<-sum(Column15 %in% "M")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
334 MllMs<-cbind(M1,M2,M3,M4,M5,M6,M7,M8,M9,M10,M11,M12,M13,M14,M15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
335
b0493d923404 Uploaded
jfb
parents:
diff changeset
336
b0493d923404 Uploaded
jfb
parents:
diff changeset
337 N1<-sum(Column1 %in% "N")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
338 N2<-sum(Column2 %in% "N")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
339 N3<-sum(Column3 %in% "N")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
340 N4<-sum(Column4 %in% "N")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
341 N5<-sum(Column5 %in% "N")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
342 N6<-sum(Column6 %in% "N")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
343 N7<-sum(Column7 %in% "N")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
344 N8<-sum(Column8 %in% "N")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
345 N9<-sum(Column9 %in% "N")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
346 N10<-sum(Column10 %in% "N")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
347 N11<-sum(Column11 %in% "N")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
348 N12<-sum(Column12 %in% "N")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
349 N13<-sum(Column13 %in% "N")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
350 N14<-sum(Column14 %in% "N")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
351 N15<-sum(Column15 %in% "N")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
352 NllNs<-cbind(N1,N2,N3,N4,N5,N6,N7,N8,N9,N10,N11,N12,N13,N14,N15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
353
b0493d923404 Uploaded
jfb
parents:
diff changeset
354
b0493d923404 Uploaded
jfb
parents:
diff changeset
355 P1<-sum(Column1 %in% "P")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
356 P2<-sum(Column2 %in% "P")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
357 P3<-sum(Column3 %in% "P")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
358 P4<-sum(Column4 %in% "P")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
359 P5<-sum(Column5 %in% "P")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
360 P6<-sum(Column6 %in% "P")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
361 P7<-sum(Column7 %in% "P")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
362 P8<-sum(Column8 %in% "P")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
363 P9<-sum(Column9 %in% "P")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
364 P10<-sum(Column10 %in% "P")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
365 P11<-sum(Column11 %in% "P")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
366 P12<-sum(Column12 %in% "P")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
367 P13<-sum(Column13 %in% "P")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
368 P14<-sum(Column14 %in% "P")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
369 P15<-sum(Column15 %in% "P")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
370 PllPs<-cbind(P1,P2,P3,P4,P5,P6,P7,P8,P9,P10,P11,P12,P13,P14,P15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
371
b0493d923404 Uploaded
jfb
parents:
diff changeset
372
b0493d923404 Uploaded
jfb
parents:
diff changeset
373 Q1<-sum(Column1 %in% "Q")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
374 Q2<-sum(Column2 %in% "Q")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
375 Q3<-sum(Column3 %in% "Q")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
376 Q4<-sum(Column4 %in% "Q")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
377 Q5<-sum(Column5 %in% "Q")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
378 Q6<-sum(Column6 %in% "Q")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
379 Q7<-sum(Column7 %in% "Q")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
380 Q8<-sum(Column8 %in% "Q")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
381 Q9<-sum(Column9 %in% "Q")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
382 Q10<-sum(Column10 %in% "Q")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
383 Q11<-sum(Column11 %in% "Q")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
384 Q12<-sum(Column12 %in% "Q")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
385 Q13<-sum(Column13 %in% "Q")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
386 Q14<-sum(Column14 %in% "Q")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
387 Q15<-sum(Column15 %in% "Q")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
388 QllQs<-cbind(Q1,Q2,Q3,Q4,Q5,Q6,Q7,Q8,Q9,Q10,Q11,Q12,Q13,Q14,Q15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
389
b0493d923404 Uploaded
jfb
parents:
diff changeset
390
b0493d923404 Uploaded
jfb
parents:
diff changeset
391 R1<-sum(Column1 %in% "R")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
392 R2<-sum(Column2 %in% "R")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
393 R3<-sum(Column3 %in% "R")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
394 R4<-sum(Column4 %in% "R")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
395 R5<-sum(Column5 %in% "R")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
396 R6<-sum(Column6 %in% "R")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
397 R7<-sum(Column7 %in% "R")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
398 R8<-sum(Column8 %in% "R")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
399 R9<-sum(Column9 %in% "R")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
400 R10<-sum(Column10 %in% "R")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
401 R11<-sum(Column11 %in% "R")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
402 R12<-sum(Column12 %in% "R")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
403 R13<-sum(Column13 %in% "R")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
404 R14<-sum(Column14 %in% "R")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
405 R15<-sum(Column15 %in% "R")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
406 RllRs<-cbind(R1,R2,R3,R4,R5,R6,R7,R8,R9,R10,R11,R12,R13,R14,R15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
407
b0493d923404 Uploaded
jfb
parents:
diff changeset
408
b0493d923404 Uploaded
jfb
parents:
diff changeset
409 S1<-sum(Column1 %in% "S")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
410 S2<-sum(Column2 %in% "S")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
411 S3<-sum(Column3 %in% "S")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
412 S4<-sum(Column4 %in% "S")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
413 S5<-sum(Column5 %in% "S")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
414 S6<-sum(Column6 %in% "S")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
415 S7<-sum(Column7 %in% "S")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
416 S8<-sum(Column8 %in% "S")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
417 S9<-sum(Column9 %in% "S")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
418 S10<-sum(Column10 %in% "S")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
419 S11<-sum(Column11 %in% "S")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
420 S12<-sum(Column12 %in% "S")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
421 S13<-sum(Column13 %in% "S")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
422 S14<-sum(Column14 %in% "S")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
423 S15<-sum(Column15 %in% "S")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
424 SllSs<-cbind(S1,S2,S3,S4,S5,S6,S7,S8,S9,S10,S11,S12,S13,S14,S15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
425
b0493d923404 Uploaded
jfb
parents:
diff changeset
426
b0493d923404 Uploaded
jfb
parents:
diff changeset
427 T1<-sum(Column1 %in% "T")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
428 T2<-sum(Column2 %in% "T")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
429 T3<-sum(Column3 %in% "T")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
430 T4<-sum(Column4 %in% "T")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
431 T5<-sum(Column5 %in% "T")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
432 T6<-sum(Column6 %in% "T")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
433 T7<-sum(Column7 %in% "T")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
434 T8<-sum(Column8 %in% "T")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
435 T9<-sum(Column9 %in% "T")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
436 T10<-sum(Column10 %in% "T")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
437 T11<-sum(Column11 %in% "T")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
438 T12<-sum(Column12 %in% "T")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
439 T13<-sum(Column13 %in% "T")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
440 T14<-sum(Column14 %in% "T")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
441 T15<-sum(Column15 %in% "T")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
442 TllTs<-cbind(T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
443
b0493d923404 Uploaded
jfb
parents:
diff changeset
444
b0493d923404 Uploaded
jfb
parents:
diff changeset
445 V1<-sum(Column1 %in% "V")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
446 V2<-sum(Column2 %in% "V")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
447 V3<-sum(Column3 %in% "V")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
448 V4<-sum(Column4 %in% "V")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
449 V5<-sum(Column5 %in% "V")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
450 V6<-sum(Column6 %in% "V")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
451 V7<-sum(Column7 %in% "V")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
452 V8<-sum(Column8 %in% "V")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
453 V9<-sum(Column9 %in% "V")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
454 V10<-sum(Column10 %in% "V")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
455 V11<-sum(Column11 %in% "V")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
456 V12<-sum(Column12 %in% "V")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
457 V13<-sum(Column13 %in% "V")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
458 V14<-sum(Column14 %in% "V")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
459 V15<-sum(Column15 %in% "V")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
460 VllVs<-cbind(V1,V2,V3,V4,V5,V6,V7,V8,V9,V10,V11,V12,V13,V14,V15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
461
b0493d923404 Uploaded
jfb
parents:
diff changeset
462
b0493d923404 Uploaded
jfb
parents:
diff changeset
463 W1<-sum(Column1 %in% "W")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
464 W2<-sum(Column2 %in% "W")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
465 W3<-sum(Column3 %in% "W")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
466 W4<-sum(Column4 %in% "W")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
467 W5<-sum(Column5 %in% "W")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
468 W6<-sum(Column6 %in% "W")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
469 W7<-sum(Column7 %in% "W")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
470 W8<-sum(Column8 %in% "W")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
471 W9<-sum(Column9 %in% "W")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
472 W10<-sum(Column10 %in% "W")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
473 W11<-sum(Column11 %in% "W")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
474 W12<-sum(Column12 %in% "W")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
475 W13<-sum(Column13 %in% "W")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
476 W14<-sum(Column14 %in% "W")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
477 W15<-sum(Column15 %in% "W")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
478 WllWs<-cbind(W1,W2,W3,W4,W5,W6,W7,W8,W9,W10,W11,W12,W13,W14,W15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
479
b0493d923404 Uploaded
jfb
parents:
diff changeset
480
b0493d923404 Uploaded
jfb
parents:
diff changeset
481 Y1<-sum(Column1 %in% "Y")/(length(Column1)-spaces1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
482 Y2<-sum(Column2 %in% "Y")/(length(Column2)-spaces2)
b0493d923404 Uploaded
jfb
parents:
diff changeset
483 Y3<-sum(Column3 %in% "Y")/(length(Column3)-spaces3)
b0493d923404 Uploaded
jfb
parents:
diff changeset
484 Y4<-sum(Column4 %in% "Y")/(length(Column4)-spaces4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
485 Y5<-sum(Column5 %in% "Y")/(length(Column5)-spaces5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
486 Y6<-sum(Column6 %in% "Y")/(length(Column6)-spaces6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
487 Y7<-sum(Column7 %in% "Y")/(length(Column7)-spaces7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
488 Y8<-sum(Column8 %in% "Y")/(length(Column8)-spaces8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
489 Y9<-sum(Column9 %in% "Y")/(length(Column9)-spaces9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
490 Y10<-sum(Column10 %in% "Y")/(length(Column10)-spaces10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
491 Y11<-sum(Column11 %in% "Y")/(length(Column11)-spaces11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
492 Y12<-sum(Column12 %in% "Y")/(length(Column12)-spaces12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
493 Y13<-sum(Column13 %in% "Y")/(length(Column13)-spaces13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
494 Y14<-sum(Column14 %in% "Y")/(length(Column14)-spaces14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
495 Y15<-sum(Column15 %in% "Y")/(length(Column15)-spaces15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
496 YllYs<-cbind(Y1,Y2,Y3,Y4,Y5,Y6,Y7,Y8,Y9,Y10,Y11,Y12,Y13,Y14,Y15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
497 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
498 #this is substrate percents
b0493d923404 Uploaded
jfb
parents:
diff changeset
499
b0493d923404 Uploaded
jfb
parents:
diff changeset
500 #A C D E F G H I K L N P Q R S T V W Y
b0493d923404 Uploaded
jfb
parents:
diff changeset
501
b0493d923404 Uploaded
jfb
parents:
diff changeset
502 PercentTable<-rbind(AllAs,CllCs,DllDs,EllEs,FllFs,GllGs,HllHs,IllIs,KllKs,LllLs,MllMs,NllNs,PllPs,QllQs,RllRs,SllSs,TllTs,VllVs,WllWs,YllYs)
b0493d923404 Uploaded
jfb
parents:
diff changeset
503 PercentTable<-PercentTable*100
b0493d923404 Uploaded
jfb
parents:
diff changeset
504
b0493d923404 Uploaded
jfb
parents:
diff changeset
505 #create the SD table
b0493d923404 Uploaded
jfb
parents:
diff changeset
506 SDtable<-matrix(data = rep(1,times=(nrow(PercentTable)*ncol(PercentTable))),nrow = nrow(PercentTable),ncol = ncol(PercentTable))
b0493d923404 Uploaded
jfb
parents:
diff changeset
507 #for every row, a percertage minus the same mean over the same SD
b0493d923404 Uploaded
jfb
parents:
diff changeset
508 if(1==1){
b0493d923404 Uploaded
jfb
parents:
diff changeset
509 SDtable[1,]<-(PercentTable[1,]-Amean)/Asd
b0493d923404 Uploaded
jfb
parents:
diff changeset
510 SDtable[2,]<-(PercentTable[2,]-Cmean)/Csd
b0493d923404 Uploaded
jfb
parents:
diff changeset
511 SDtable[3,]<-(PercentTable[3,]-Dmean)/Dsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
512 SDtable[4,]<-(PercentTable[4,]-Emean)/Esd
b0493d923404 Uploaded
jfb
parents:
diff changeset
513 SDtable[5,]<-(PercentTable[5,]-Fmean)/Fsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
514 SDtable[6,]<-(PercentTable[6,]-Gmean)/Gsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
515 SDtable[7,]<-(PercentTable[7,]-Hmean)/Hsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
516 SDtable[8,]<-(PercentTable[8,]-Imean)/Isd
b0493d923404 Uploaded
jfb
parents:
diff changeset
517 SDtable[9,]<-(PercentTable[9,]-Kmean)/Ksd
b0493d923404 Uploaded
jfb
parents:
diff changeset
518 SDtable[10,]<-(PercentTable[10,]-Lmean)/Lsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
519 SDtable[11,]<-(PercentTable[11,]-Mmean)/Msd
b0493d923404 Uploaded
jfb
parents:
diff changeset
520 SDtable[12,]<-(PercentTable[12,]-Nmean)/Nsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
521 SDtable[13,]<-(PercentTable[13,]-Pmean)/Psd
b0493d923404 Uploaded
jfb
parents:
diff changeset
522 SDtable[14,]<-(PercentTable[14,]-Qmean)/Qsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
523 SDtable[15,]<-(PercentTable[15,]-Rmean)/Rsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
524 SDtable[16,]<-(PercentTable[16,]-Smean)/Ssd
b0493d923404 Uploaded
jfb
parents:
diff changeset
525 SDtable[17,]<-(PercentTable[17,]-Tmean)/Tsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
526 SDtable[18,]<-(PercentTable[18,]-Vmean)/Vsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
527 SDtable[19,]<-(PercentTable[19,]-Wmean)/Wsd
b0493d923404 Uploaded
jfb
parents:
diff changeset
528 SDtable[20,]<-(PercentTable[20,]-Ymean)/Ysd
b0493d923404 Uploaded
jfb
parents:
diff changeset
529 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
530
b0493d923404 Uploaded
jfb
parents:
diff changeset
531
b0493d923404 Uploaded
jfb
parents:
diff changeset
532 SetOfAAs<-c("Letter","A","C","D","E","F","G","H","I","K","L","M","N","P","Q","R","S","T","V","W","Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
533
b0493d923404 Uploaded
jfb
parents:
diff changeset
534 SumOfSigmaAAs<-c(1:15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
535
b0493d923404 Uploaded
jfb
parents:
diff changeset
536 for (i in 1:15){
b0493d923404 Uploaded
jfb
parents:
diff changeset
537 SumOfSigmasValue<-0
b0493d923404 Uploaded
jfb
parents:
diff changeset
538 for (j in 1:20){
b0493d923404 Uploaded
jfb
parents:
diff changeset
539 value<-0
b0493d923404 Uploaded
jfb
parents:
diff changeset
540 if (SDtable[j,i]>2){
b0493d923404 Uploaded
jfb
parents:
diff changeset
541 q=j+1
b0493d923404 Uploaded
jfb
parents:
diff changeset
542 value<-sum(substrates[,i]==SetOfAAs[q])
b0493d923404 Uploaded
jfb
parents:
diff changeset
543 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
544 SumOfSigmasValue<-SumOfSigmasValue+value
b0493d923404 Uploaded
jfb
parents:
diff changeset
545 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
546 SumOfSigmaAAs[i]<-SumOfSigmasValue
b0493d923404 Uploaded
jfb
parents:
diff changeset
547 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
548
b0493d923404 Uploaded
jfb
parents:
diff changeset
549 AAs1<-length(substrates[,1])-sum(substrates[,1]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
550 AAs2<-length(substrates[,2])-sum(substrates[,2]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
551 AAs3<-length(substrates[,3])-sum(substrates[,3]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
552 AAs4<-length(substrates[,4])-sum(substrates[,4]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
553 AAs5<-length(substrates[,5])-sum(substrates[,5]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
554 AAs6<-length(substrates[,6])-sum(substrates[,6]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
555 AAs7<-length(substrates[,7])-sum(substrates[,7]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
556 AAs8<-length(substrates[,8])-sum(substrates[,8]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
557 AAs9<-length(substrates[,9])-sum(substrates[,9]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
558 AAs10<-length(substrates[,10])-sum(substrates[,10]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
559 AAs11<-length(substrates[,11])-sum(substrates[,11]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
560 AAs12<-length(substrates[,12])-sum(substrates[,12]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
561 AAs13<-length(substrates[,13])-sum(substrates[,13]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
562 AAs14<-length(substrates[,14])-sum(substrates[,14]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
563 AAs15<-length(substrates[,15])-sum(substrates[,15]=="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
564
b0493d923404 Uploaded
jfb
parents:
diff changeset
565 AAsAtPositions<-c(AAs1,AAs2,AAs3,AAs4,AAs5,AAs6,AAs7,AAs8,AAs9,AAs10,AAs11,AAs12,AAs13,AAs14,AAs15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
566 # AAsAtPositions<-c(length(substrates[,1]),length(substrates[,2]),length(substrates[,3]),length(substrates[,4]),
b0493d923404 Uploaded
jfb
parents:
diff changeset
567 # length(substrates[,5]),length(substrates[,6]),length(substrates[,7]),length(substrates[,8]),
b0493d923404 Uploaded
jfb
parents:
diff changeset
568 # length(substrates[,9]))
b0493d923404 Uploaded
jfb
parents:
diff changeset
569
b0493d923404 Uploaded
jfb
parents:
diff changeset
570 SumOfExpectedSigmaAAs<-c(1:15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
571 for (i in 1:15){
b0493d923404 Uploaded
jfb
parents:
diff changeset
572 ExpectedValue<-0
b0493d923404 Uploaded
jfb
parents:
diff changeset
573 for (j in 1:20){
b0493d923404 Uploaded
jfb
parents:
diff changeset
574 value<-0
b0493d923404 Uploaded
jfb
parents:
diff changeset
575 if (SDtable[j,i]>2){
b0493d923404 Uploaded
jfb
parents:
diff changeset
576 value<-AllMeans[j]
b0493d923404 Uploaded
jfb
parents:
diff changeset
577 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
578 ExpectedValue<-ExpectedValue+value
b0493d923404 Uploaded
jfb
parents:
diff changeset
579 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
580 SumOfExpectedSigmaAAs[i]<-ExpectedValue*(length(substrates[,i])-sum(substrates[,i]%in% ""))/100
b0493d923404 Uploaded
jfb
parents:
diff changeset
581 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
582
b0493d923404 Uploaded
jfb
parents:
diff changeset
583 #SelectivityRow<-SumOfSigmaAAs/SumOfExpectedSigmaAAs
b0493d923404 Uploaded
jfb
parents:
diff changeset
584
b0493d923404 Uploaded
jfb
parents:
diff changeset
585 SelectivityRow<-rep(0,times=15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
586
b0493d923404 Uploaded
jfb
parents:
diff changeset
587 for (q in 1:15) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
588 SelectivityRow[q]<-(SumOfSigmaAAs[q]/SumOfExpectedSigmaAAs[q])*(SumOfSigmaAAs[q]/AAsAtPositions[q])
b0493d923404 Uploaded
jfb
parents:
diff changeset
589 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
590
b0493d923404 Uploaded
jfb
parents:
diff changeset
591 SelectivitySheet<-rbind(SumOfSigmaAAs,SumOfExpectedSigmaAAs,SelectivityRow)
b0493d923404 Uploaded
jfb
parents:
diff changeset
592
b0493d923404 Uploaded
jfb
parents:
diff changeset
593 SetOfAAs<-matrix(data = SetOfAAs,ncol = 1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
594 SDtableu<-SDtable
b0493d923404 Uploaded
jfb
parents:
diff changeset
595 HeaderSD<-c(-7:7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
596 SDtable<-rbind(HeaderSD,SDtableu)
b0493d923404 Uploaded
jfb
parents:
diff changeset
597 row.names(SDtable)<-NULL
b0493d923404 Uploaded
jfb
parents:
diff changeset
598 SDtable<-data.frame(SetOfAAs,SDtable)
b0493d923404 Uploaded
jfb
parents:
diff changeset
599
b0493d923404 Uploaded
jfb
parents:
diff changeset
600 PercentTable<-rbind(HeaderSD,PercentTable)
b0493d923404 Uploaded
jfb
parents:
diff changeset
601 row.names(PercentTable)<-NULL
b0493d923404 Uploaded
jfb
parents:
diff changeset
602 PercentTable<-data.frame(SetOfAAs,PercentTable)
b0493d923404 Uploaded
jfb
parents:
diff changeset
603 numberofY<-as.numeric(SubstrateBackgroundFrequency[,34])
b0493d923404 Uploaded
jfb
parents:
diff changeset
604 numberofY<-numberofY[!is.na(numberofY)]
b0493d923404 Uploaded
jfb
parents:
diff changeset
605
b0493d923404 Uploaded
jfb
parents:
diff changeset
606 numberofPY<-as.numeric(SubstrateBackgroundFrequency[,35])
b0493d923404 Uploaded
jfb
parents:
diff changeset
607 numberofPY<-numberofPY[!is.na(numberofPY)]
b0493d923404 Uploaded
jfb
parents:
diff changeset
608
b0493d923404 Uploaded
jfb
parents:
diff changeset
609 NormalizationScore<-sum(numberofPY)/sum(numberofY)
b0493d923404 Uploaded
jfb
parents:
diff changeset
610
b0493d923404 Uploaded
jfb
parents:
diff changeset
611 # positions<-matrix(data = NA, nrow=20,ncol = 15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
612 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
613 # #column1
b0493d923404 Uploaded
jfb
parents:
diff changeset
614 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
615 # for (q in 1:15) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
616 # sA<-sum(substrates[,i]=="A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
617 # positions[1,i]<-sA
b0493d923404 Uploaded
jfb
parents:
diff changeset
618 # sC<-sum(substrates[,i]=="C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
619 # positions[2,i]<-sC
b0493d923404 Uploaded
jfb
parents:
diff changeset
620 # sD<-sum(substrates[,i]=="D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
621 # positions[3,i]<-sD
b0493d923404 Uploaded
jfb
parents:
diff changeset
622 # sE<-sum(substrates[,i]=="E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
623 # positions[4,i]<-sE
b0493d923404 Uploaded
jfb
parents:
diff changeset
624 # sF<-sum(substrates[,i]=="F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
625 # sG<-sum(substrates[,i]=="G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
626 # sH<-sum(substrates[,i]=="H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
627 # sI<-sum(substrates[,i]=="I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
628 # sK<-sum(substrates[,i]=="K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
629 # sL<-sum(substrates[,i]=="L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
630 # sM<-sum(substrates[,i]=="M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
631 # sN<-sum(substrates[,i]=="N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
632 # sP<-sum(substrates[,i]=="P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
633 # sQ<-sum(substrates[,i]=="Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
634 # sR<-sum(substrates[,i]=="R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
635 # sS<-sum(substrates[,i]=="S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
636 # sT<-sum(substrates[,i]=="T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
637 # sV<-sum(substrates[,i]=="V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
638 # sW<-sum(substrates[,i]=="W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
639 # sY<-sum(substrates[,i]=="Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
640 # positions[5,i]<-sF
b0493d923404 Uploaded
jfb
parents:
diff changeset
641 # positions[6,i]<-sG
b0493d923404 Uploaded
jfb
parents:
diff changeset
642 # positions[7,i]<-sH
b0493d923404 Uploaded
jfb
parents:
diff changeset
643 # positions[8,i]<-sI
b0493d923404 Uploaded
jfb
parents:
diff changeset
644 # positions[9,i]<-sK
b0493d923404 Uploaded
jfb
parents:
diff changeset
645 # positions[10,i]<-sL
b0493d923404 Uploaded
jfb
parents:
diff changeset
646 # positions[11,i]<-sM
b0493d923404 Uploaded
jfb
parents:
diff changeset
647 # positions[12,i]<-sN
b0493d923404 Uploaded
jfb
parents:
diff changeset
648 # positions[13,i]<-sP
b0493d923404 Uploaded
jfb
parents:
diff changeset
649 # positions[14,i]<-sQ
b0493d923404 Uploaded
jfb
parents:
diff changeset
650 # positions[15,i]<-sR
b0493d923404 Uploaded
jfb
parents:
diff changeset
651 # positions[16,i]<-sS
b0493d923404 Uploaded
jfb
parents:
diff changeset
652 # positions[17,i]<-sT
b0493d923404 Uploaded
jfb
parents:
diff changeset
653 # positions[18,i]<-sV
b0493d923404 Uploaded
jfb
parents:
diff changeset
654 # positions[19,i]<-sW
b0493d923404 Uploaded
jfb
parents:
diff changeset
655 # positions[20,i]<-sY
b0493d923404 Uploaded
jfb
parents:
diff changeset
656 # }
b0493d923404 Uploaded
jfb
parents:
diff changeset
657
b0493d923404 Uploaded
jfb
parents:
diff changeset
658 #here I create the positions table which is needed for the endogenous prob matrix and is simply "how many times did an AA show up in this spot?
b0493d923404 Uploaded
jfb
parents:
diff changeset
659 if (6==6){
b0493d923404 Uploaded
jfb
parents:
diff changeset
660 Column1<-substrates[,1]
b0493d923404 Uploaded
jfb
parents:
diff changeset
661 Column2<-substrates[,2]
b0493d923404 Uploaded
jfb
parents:
diff changeset
662 Column3<-substrates[,3]
b0493d923404 Uploaded
jfb
parents:
diff changeset
663 Column4<-substrates[,4]
b0493d923404 Uploaded
jfb
parents:
diff changeset
664 Column5<-substrates[,5]
b0493d923404 Uploaded
jfb
parents:
diff changeset
665 Column6<-substrates[,6]
b0493d923404 Uploaded
jfb
parents:
diff changeset
666 Column7<-substrates[,7]
b0493d923404 Uploaded
jfb
parents:
diff changeset
667 Column8<-substrates[,8]
b0493d923404 Uploaded
jfb
parents:
diff changeset
668 Column9<-substrates[,9]
b0493d923404 Uploaded
jfb
parents:
diff changeset
669 Column10<-substrates[,10]
b0493d923404 Uploaded
jfb
parents:
diff changeset
670 Column11<-substrates[,11]
b0493d923404 Uploaded
jfb
parents:
diff changeset
671 Column12<-substrates[,12]
b0493d923404 Uploaded
jfb
parents:
diff changeset
672 Column13<-substrates[,13]
b0493d923404 Uploaded
jfb
parents:
diff changeset
673 Column14<-substrates[,14]
b0493d923404 Uploaded
jfb
parents:
diff changeset
674 Column15<-substrates[,15]
b0493d923404 Uploaded
jfb
parents:
diff changeset
675
b0493d923404 Uploaded
jfb
parents:
diff changeset
676 spaces1<-sum((Column1%in% ""))
b0493d923404 Uploaded
jfb
parents:
diff changeset
677 spaces2<-sum(Column2%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
678 spaces3<-sum(Column3%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
679 spaces4<-sum(Column4%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
680 spaces5<-sum(Column5%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
681 spaces6<-sum(Column6%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
682 spaces7<-sum(Column7%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
683 spaces8<-sum(Column8%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
684 spaces9<-sum(Column9%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
685 spaces10<-sum(Column10%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
686 spaces11<-sum(Column11%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
687 spaces12<-sum(Column12%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
688 spaces13<-sum(Column13%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
689 spaces14<-sum(Column14%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
690 spaces15<-sum(Column15%in% "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
691
b0493d923404 Uploaded
jfb
parents:
diff changeset
692 A1<-sum(Column1 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
693 A2<-sum(Column2 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
694 A3<-sum(Column3 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
695 A4<-sum(Column4 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
696 A5<-sum(Column5 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
697 A6<-sum(Column6 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
698 A7<-sum(Column7 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
699 A8<-sum(Column8 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
700 A9<-sum(Column9 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
701 A10<-sum(Column10 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
702 A11<-sum(Column11 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
703 A12<-sum(Column12 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
704 A13<-sum(Column13 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
705 A14<-sum(Column14 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
706 A15<-sum(Column15 %in% "A")
b0493d923404 Uploaded
jfb
parents:
diff changeset
707 AllAs<-cbind(A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
708
b0493d923404 Uploaded
jfb
parents:
diff changeset
709 C1<-sum(Column1 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
710 C2<-sum(Column2 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
711 C3<-sum(Column3 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
712 C4<-sum(Column4 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
713 C5<-sum(Column5 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
714 C6<-sum(Column6 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
715 C7<-sum(Column7 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
716 C8<-sum(Column8 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
717 C9<-sum(Column9 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
718 C10<-sum(Column10 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
719 C11<-sum(Column11 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
720 C12<-sum(Column12 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
721 C13<-sum(Column13 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
722 C14<-sum(Column14 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
723 C15<-sum(Column15 %in% "C")
b0493d923404 Uploaded
jfb
parents:
diff changeset
724 CllCs<-cbind(C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,C11,C12,C13,C14,C15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
725
b0493d923404 Uploaded
jfb
parents:
diff changeset
726 D1<-sum(Column1 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
727 D2<-sum(Column2 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
728 D3<-sum(Column3 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
729 D4<-sum(Column4 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
730 D5<-sum(Column5 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
731 D6<-sum(Column6 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
732 D7<-sum(Column7 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
733 D8<-sum(Column8 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
734 D9<-sum(Column9 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
735 D10<-sum(Column10 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
736 D11<-sum(Column11 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
737 D12<-sum(Column12 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
738 D13<-sum(Column13 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
739 D14<-sum(Column14 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
740 D15<-sum(Column15 %in% "D")
b0493d923404 Uploaded
jfb
parents:
diff changeset
741 DllDs<-cbind(D1,D2,D3,D4,D5,D6,D7,D8,D9,D10,D11,D12,D13,D14,D15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
742
b0493d923404 Uploaded
jfb
parents:
diff changeset
743 E1<-sum(Column1 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
744 E2<-sum(Column2 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
745 E3<-sum(Column3 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
746 E4<-sum(Column4 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
747 E5<-sum(Column5 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
748 E6<-sum(Column6 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
749 E7<-sum(Column7 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
750 E8<-sum(Column8 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
751 E9<-sum(Column9 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
752 E10<-sum(Column10 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
753 E11<-sum(Column11 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
754 E12<-sum(Column12 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
755 E13<-sum(Column13 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
756 E14<-sum(Column14 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
757 E15<-sum(Column15 %in% "E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
758 EllEs<-cbind(E1,E2,E3,E4,E5,E6,E7,E8,E9,E10,E11,E12,E13,E14,E15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
759
b0493d923404 Uploaded
jfb
parents:
diff changeset
760 F1<-sum(Column1 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
761 F2<-sum(Column2 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
762 F3<-sum(Column3 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
763 F4<-sum(Column4 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
764 F5<-sum(Column5 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
765 F6<-sum(Column6 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
766 F7<-sum(Column7 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
767 F8<-sum(Column8 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
768 F9<-sum(Column9 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
769 F10<-sum(Column10 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
770 F11<-sum(Column11 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
771 F12<-sum(Column12 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
772 F13<-sum(Column13 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
773 F14<-sum(Column14 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
774 F15<-sum(Column15 %in% "F")
b0493d923404 Uploaded
jfb
parents:
diff changeset
775 FllFs<-cbind(F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
776
b0493d923404 Uploaded
jfb
parents:
diff changeset
777 G1<-sum(Column1 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
778 G2<-sum(Column2 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
779 G3<-sum(Column3 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
780 G4<-sum(Column4 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
781 G5<-sum(Column5 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
782 G6<-sum(Column6 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
783 G7<-sum(Column7 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
784 G8<-sum(Column8 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
785 G9<-sum(Column9 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
786 G10<-sum(Column10 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
787 G11<-sum(Column11 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
788 G12<-sum(Column12 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
789 G13<-sum(Column13 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
790 G14<-sum(Column14 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
791 G15<-sum(Column15 %in% "G")
b0493d923404 Uploaded
jfb
parents:
diff changeset
792 GllGs<-cbind(G1,G2,G3,G4,G5,G6,G7,G8,G9,G10,G11,G12,G13,G14,G15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
793
b0493d923404 Uploaded
jfb
parents:
diff changeset
794 H1<-sum(Column1 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
795 H2<-sum(Column2 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
796 H3<-sum(Column3 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
797 H4<-sum(Column4 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
798 H5<-sum(Column5 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
799 H6<-sum(Column6 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
800 H7<-sum(Column7 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
801 H8<-sum(Column8 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
802 H9<-sum(Column9 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
803 H10<-sum(Column10 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
804 H11<-sum(Column11 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
805 H12<-sum(Column12 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
806 H13<-sum(Column13 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
807 H14<-sum(Column14 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
808 H15<-sum(Column15 %in% "H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
809 HllHs<-cbind(H1,H2,H3,H4,H5,H6,H7,H8,H9,H10,H11,H12,H13,H14,H15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
810
b0493d923404 Uploaded
jfb
parents:
diff changeset
811 I1<-sum(Column1 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
812 I2<-sum(Column2 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
813 I3<-sum(Column3 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
814 I4<-sum(Column4 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
815 I5<-sum(Column5 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
816 I6<-sum(Column6 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
817 I7<-sum(Column7 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
818 I8<-sum(Column8 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
819 I9<-sum(Column9 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
820 I10<-sum(Column10 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
821 I11<-sum(Column11 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
822 I12<-sum(Column12 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
823 I13<-sum(Column13 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
824 I14<-sum(Column14 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
825 I15<-sum(Column15 %in% "I")
b0493d923404 Uploaded
jfb
parents:
diff changeset
826 IllIs<-cbind(I1,I2,I3,I4,I5,I6,I7,I8,I9,I10,I11,I12,I13,I14,I15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
827
b0493d923404 Uploaded
jfb
parents:
diff changeset
828 K1<-sum(Column1 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
829 K2<-sum(Column2 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
830 K3<-sum(Column3 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
831 K4<-sum(Column4 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
832 K5<-sum(Column5 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
833 K6<-sum(Column6 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
834 K7<-sum(Column7 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
835 K8<-sum(Column8 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
836 K9<-sum(Column9 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
837 K10<-sum(Column10 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
838 K11<-sum(Column11 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
839 K12<-sum(Column12 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
840 K13<-sum(Column13 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
841 K14<-sum(Column14 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
842 K15<-sum(Column15 %in% "K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
843 KllKs<-cbind(K1,K2,K3,K4,K5,K6,K7,K8,K9,K10,K11,K12,K13,K14,K15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
844
b0493d923404 Uploaded
jfb
parents:
diff changeset
845 L1<-sum(Column1 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
846 L2<-sum(Column2 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
847 L3<-sum(Column3 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
848 L4<-sum(Column4 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
849 L5<-sum(Column5 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
850 L6<-sum(Column6 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
851 L7<-sum(Column7 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
852 L8<-sum(Column8 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
853 L9<-sum(Column9 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
854 L10<-sum(Column10 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
855 L11<-sum(Column11 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
856 L12<-sum(Column12 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
857 L13<-sum(Column13 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
858 L14<-sum(Column14 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
859 L15<-sum(Column15 %in% "L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
860 LllLs<-cbind(L1,L2,L3,L4,L5,L6,L7,L8,L9,L10,L11,L12,L13,L14,L15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
861
b0493d923404 Uploaded
jfb
parents:
diff changeset
862 M1<-sum(Column1 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
863 M2<-sum(Column2 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
864 M3<-sum(Column3 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
865 M4<-sum(Column4 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
866 M5<-sum(Column5 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
867 M6<-sum(Column6 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
868 M7<-sum(Column7 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
869 M8<-sum(Column8 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
870 M9<-sum(Column9 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
871 M10<-sum(Column10 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
872 M11<-sum(Column11 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
873 M12<-sum(Column12 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
874 M13<-sum(Column13 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
875 M14<-sum(Column14 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
876 M15<-sum(Column15 %in% "M")
b0493d923404 Uploaded
jfb
parents:
diff changeset
877 MllMs<-cbind(M1,M2,M3,M4,M5,M6,M7,M8,M9,M10,M11,M12,M13,M14,M15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
878
b0493d923404 Uploaded
jfb
parents:
diff changeset
879 N1<-sum(Column1 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
880 N2<-sum(Column2 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
881 N3<-sum(Column3 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
882 N4<-sum(Column4 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
883 N5<-sum(Column5 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
884 N6<-sum(Column6 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
885 N7<-sum(Column7 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
886 N8<-sum(Column8 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
887 N9<-sum(Column9 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
888 N10<-sum(Column10 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
889 N11<-sum(Column11 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
890 N12<-sum(Column12 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
891 N13<-sum(Column13 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
892 N14<-sum(Column14 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
893 N15<-sum(Column15 %in% "N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
894 NllNs<-cbind(N1,N2,N3,N4,N5,N6,N7,N8,N9,N10,N11,N12,N13,N14,N15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
895
b0493d923404 Uploaded
jfb
parents:
diff changeset
896 P1<-sum(Column1 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
897 P2<-sum(Column2 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
898 P3<-sum(Column3 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
899 P4<-sum(Column4 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
900 P5<-sum(Column5 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
901 P6<-sum(Column6 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
902 P7<-sum(Column7 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
903 P8<-sum(Column8 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
904 P9<-sum(Column9 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
905 P10<-sum(Column10 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
906 P11<-sum(Column11 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
907 P12<-sum(Column12 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
908 P13<-sum(Column13 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
909 P14<-sum(Column14 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
910 P15<-sum(Column15 %in% "P")
b0493d923404 Uploaded
jfb
parents:
diff changeset
911 PllPs<-cbind(P1,P2,P3,P4,P5,P6,P7,P8,P9,P10,P11,P12,P13,P14,P15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
912
b0493d923404 Uploaded
jfb
parents:
diff changeset
913 Q1<-sum(Column1 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
914 Q2<-sum(Column2 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
915 Q3<-sum(Column3 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
916 Q4<-sum(Column4 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
917 Q5<-sum(Column5 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
918 Q6<-sum(Column6 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
919 Q7<-sum(Column7 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
920 Q8<-sum(Column8 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
921 Q9<-sum(Column9 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
922 Q10<-sum(Column10 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
923 Q11<-sum(Column11 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
924 Q12<-sum(Column12 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
925 Q13<-sum(Column13 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
926 Q14<-sum(Column14 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
927 Q15<-sum(Column15 %in% "Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
928 QllQs<-cbind(Q1,Q2,Q3,Q4,Q5,Q6,Q7,Q8,Q9,Q10,Q11,Q12,Q13,Q14,Q15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
929
b0493d923404 Uploaded
jfb
parents:
diff changeset
930 R1<-sum(Column1 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
931 R2<-sum(Column2 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
932 R3<-sum(Column3 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
933 R4<-sum(Column4 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
934 R5<-sum(Column5 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
935 R6<-sum(Column6 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
936 R7<-sum(Column7 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
937 R8<-sum(Column8 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
938 R9<-sum(Column9 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
939 R10<-sum(Column10 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
940 R11<-sum(Column11 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
941 R12<-sum(Column12 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
942 R13<-sum(Column13 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
943 R14<-sum(Column14 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
944 R15<-sum(Column15 %in% "R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
945 RllRs<-cbind(R1,R2,R3,R4,R5,R6,R7,R8,R9,R10,R11,R12,R13,R14,R15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
946
b0493d923404 Uploaded
jfb
parents:
diff changeset
947 S1<-sum(Column1 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
948 S2<-sum(Column2 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
949 S3<-sum(Column3 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
950 S4<-sum(Column4 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
951 S5<-sum(Column5 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
952 S6<-sum(Column6 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
953 S7<-sum(Column7 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
954 S8<-sum(Column8 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
955 S9<-sum(Column9 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
956 S10<-sum(Column10 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
957 S11<-sum(Column11 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
958 S12<-sum(Column12 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
959 S13<-sum(Column13 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
960 S14<-sum(Column14 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
961 S15<-sum(Column15 %in% "S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
962 SllSs<-cbind(S1,S2,S3,S4,S5,S6,S7,S8,S9,S10,S11,S12,S13,S14,S15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
963
b0493d923404 Uploaded
jfb
parents:
diff changeset
964 T1<-sum(Column1 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
965 T2<-sum(Column2 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
966 T3<-sum(Column3 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
967 T4<-sum(Column4 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
968 T5<-sum(Column5 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
969 T6<-sum(Column6 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
970 T7<-sum(Column7 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
971 T8<-sum(Column8 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
972 T9<-sum(Column9 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
973 T10<-sum(Column10 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
974 T11<-sum(Column11 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
975 T12<-sum(Column12 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
976 T13<-sum(Column13 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
977 T14<-sum(Column14 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
978 T15<-sum(Column15 %in% "T")
b0493d923404 Uploaded
jfb
parents:
diff changeset
979 TllTs<-cbind(T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
980
b0493d923404 Uploaded
jfb
parents:
diff changeset
981 V1<-sum(Column1 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
982 V2<-sum(Column2 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
983 V3<-sum(Column3 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
984 V4<-sum(Column4 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
985 V5<-sum(Column5 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
986 V6<-sum(Column6 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
987 V7<-sum(Column7 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
988 V8<-sum(Column8 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
989 V9<-sum(Column9 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
990 V10<-sum(Column10 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
991 V11<-sum(Column11 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
992 V12<-sum(Column12 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
993 V13<-sum(Column13 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
994 V14<-sum(Column14 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
995 V15<-sum(Column15 %in% "V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
996 VllVs<-cbind(V1,V2,V3,V4,V5,V6,V7,V8,V9,V10,V11,V12,V13,V14,V15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
997
b0493d923404 Uploaded
jfb
parents:
diff changeset
998 W1<-sum(Column1 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
999 W2<-sum(Column2 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1000 W3<-sum(Column3 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1001 W4<-sum(Column4 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1002 W5<-sum(Column5 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1003 W6<-sum(Column6 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1004 W7<-sum(Column7 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1005 W8<-sum(Column8 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1006 W9<-sum(Column9 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1007 W10<-sum(Column10 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1008 W11<-sum(Column11 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1009 W12<-sum(Column12 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1010 W13<-sum(Column13 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1011 W14<-sum(Column14 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1012 W15<-sum(Column15 %in% "W")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1013 WllWs<-cbind(W1,W2,W3,W4,W5,W6,W7,W8,W9,W10,W11,W12,W13,W14,W15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1014
b0493d923404 Uploaded
jfb
parents:
diff changeset
1015 Y1<-sum(Column1 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1016 Y2<-sum(Column2 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1017 Y3<-sum(Column3 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1018 Y4<-sum(Column4 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1019 Y5<-sum(Column5 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1020 Y6<-sum(Column6 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1021 Y7<-sum(Column7 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1022 Y8<-sum(Column8 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1023 Y9<-sum(Column9 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1024 Y10<-sum(Column10 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1025 Y11<-sum(Column11 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1026 Y12<-sum(Column12 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1027 Y13<-sum(Column13 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1028 Y14<-sum(Column14 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1029 Y15<-sum(Column15 %in% "Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1030 YllYs<-cbind(Y1,Y2,Y3,Y4,Y5,Y6,Y7,Y8,Y9,Y10,Y11,Y12,Y13,Y14,Y15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1031 PositionTable<-rbind(AllAs,CllCs,DllDs,EllEs,FllFs,GllGs,HllHs,IllIs,KllKs,LllLs,MllMs,NllNs,PllPs,QllQs,RllRs,SllSs,TllTs,VllVs,WllWs,YllYs)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1032 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1033 #endogenous prob matrix is AA position over subbackfreqmean
b0493d923404 Uploaded
jfb
parents:
diff changeset
1034 dim(PositionTable)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1035 EPMtable<-PositionTable
b0493d923404 Uploaded
jfb
parents:
diff changeset
1036 # EPMtable[1,]<-(PositionTable[1,]/(PositionTable[1,]*.01*Amean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1037 # EPMtable[2,]<-(PositionTable[2,]/(PositionTable[2,]*.01*Cmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1038 # EPMtable[3,]<-(PositionTable[3,]/(PositionTable[3,]*.01*Dmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1039 # EPMtable[4,]<-(PositionTable[4,]/(PositionTable[4,]*.01*Emean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1040 # EPMtable[5,]<-(PositionTable[5,]/(PositionTable[5,]*.01*Fmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1041 # EPMtable[6,]<-(PositionTable[6,]/(PositionTable[6,]*.01*Gmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1042 # EPMtable[7,]<-(PositionTable[7,]/(PositionTable[7,]*.01*Hmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1043 # EPMtable[8,]<-(PositionTable[8,]/(PositionTable[8,]*.01*Imean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1044 # EPMtable[9,]<-(PositionTable[9,]/(PositionTable[9,]*.01*Kmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1045 # EPMtable[10,]<-(PositionTable[10,]/(PositionTable[10,]*.01*Lmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1046 # EPMtable[11,]<-(PositionTable[11,]/(PositionTable[11,]*.01*Mmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1047 # EPMtable[12,]<-(PositionTable[12,]/(PositionTable[12,]*.01*Nmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1048 # EPMtable[13,]<-(PositionTable[13,]/(PositionTable[13,]*.01*Pmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1049 # EPMtable[14,]<-(PositionTable[14,]/(PositionTable[14,]*.01*Qmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1050 # EPMtable[15,]<-(PositionTable[15,]/(PositionTable[15,]*.01*Rmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1051 # EPMtable[16,]<-(PositionTable[16,]/(PositionTable[16,]*.01*Smean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1052 # EPMtable[17,]<-(PositionTable[17,]/(PositionTable[17,]*.01*Tmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1053 # EPMtable[18,]<-(PositionTable[18,]/(PositionTable[18,]*.01*Vmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1054 # EPMtable[19,]<-(PositionTable[19,]/(PositionTable[19,]*.01*Wmean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1055 # EPMtable[20,]<-(PositionTable[20,]/(PositionTable[20,]*.01*Ymean))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1056
b0493d923404 Uploaded
jfb
parents:
diff changeset
1057 columns<-c(length(Column1)-sum(Column1==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1058 length(Column2)-sum(Column2==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1059 length(Column3)-sum(Column3==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1060 length(Column4)-sum(Column4==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1061 length(Column5)-sum(Column5==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1062 length(Column6)-sum(Column6==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1063 length(Column7)-sum(Column7==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1064 length(Column8)-sum(Column8==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1065 length(Column9)-sum(Column9==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1066 length(Column10)-sum(Column10==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1067 length(Column11)-sum(Column11==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1068 length(Column12)-sum(Column12==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1069 length(Column13)-sum(Column13==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1070 length(Column14)-sum(Column14==""),
b0493d923404 Uploaded
jfb
parents:
diff changeset
1071 length(Column15)-sum(Column15==""))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1072
b0493d923404 Uploaded
jfb
parents:
diff changeset
1073 for (z in 1:15) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1074 for (y in 1:20) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1075 if (PositionTable[y,z]>0){
b0493d923404 Uploaded
jfb
parents:
diff changeset
1076 EPMtable[y,z]<-PositionTable[y,z]/((columns[z]*.01*AllMeans[y]))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1077 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1078 if (PositionTable[y,z]==0){
b0493d923404 Uploaded
jfb
parents:
diff changeset
1079 EPMtable[y,z]<-(1/columns[z])/((columns[z]*.01*AllMeans[y]))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1080 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1081 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1082 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1083 #here I created the endogenous probability matrix
b0493d923404 Uploaded
jfb
parents:
diff changeset
1084 #now all I need to do is make the program automatically determine which SDs are >2, and then make it perform screener and sorter on those SDs
b0493d923404 Uploaded
jfb
parents:
diff changeset
1085
b0493d923404 Uploaded
jfb
parents:
diff changeset
1086
b0493d923404 Uploaded
jfb
parents:
diff changeset
1087
b0493d923404 Uploaded
jfb
parents:
diff changeset
1088
b0493d923404 Uploaded
jfb
parents:
diff changeset
1089
b0493d923404 Uploaded
jfb
parents:
diff changeset
1090 # write.xlsx(SDtable,file=FILENAME, sheetName = "Standard Deviation Table",col.names = FALSE,row.names = FALSE,append = TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1091 # write.xlsx(PercentTable,file = FILENAME,sheetName = "Percent Table",col.names = FALSE,row.names = FALSE,append = TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1092 # write.xlsx(SelectivitySheet,file = FILENAME,sheetName = "Site Selectivity",col.names = FALSE,row.names = FALSE,append = TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1093 # write.xlsx(EPMtable,file=FILENAME,sheetName = "Endogenous Probability Matrix",col.names = FALSE,row.names = FALSE,append = TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1094 # write.xlsx(NormalizationScore,file = FILENAME,sheetName = "Normalization Score",col.names = FALSE,row.names = FALSE,append = TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1095
b0493d923404 Uploaded
jfb
parents:
diff changeset
1096 NormalizationScore<-c("Normalization Score",NormalizationScore)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1097
b0493d923404 Uploaded
jfb
parents:
diff changeset
1098 write.table(x=c("SD Table"),file=FILENAME,append = TRUE,sep=",", row.names = FALSE, col.names = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1099 write.table(SDtable,file=FILENAME,append = TRUE,sep=",", row.names = FALSE, col.names = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1100 write.table(x=c("Percent Table"),file=FILENAME,append = TRUE,sep=",", row.names = FALSE, col.names = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1101 write.table(PercentTable,file=FILENAME, append = TRUE,sep=",",row.names = FALSE, col.names = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1102
b0493d923404 Uploaded
jfb
parents:
diff changeset
1103 EPMtableu<-EPMtable
b0493d923404 Uploaded
jfb
parents:
diff changeset
1104 HeaderSD<-c(-7:7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1105 EPMtableu<-rbind(HeaderSD,EPMtableu)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1106 row.names(EPMtableu)<-NULL
b0493d923404 Uploaded
jfb
parents:
diff changeset
1107 EPMtableu<-data.frame(SetOfAAs,EPMtableu)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1108
b0493d923404 Uploaded
jfb
parents:
diff changeset
1109 write.table("Site Selectivity Matrix", file = FILENAME2, append = TRUE, sep = ",", row.names = FALSE, col.names = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1110 SelectivityHeader=matrix(data = c("Position",-7,-6,-5,-4,-3,-2,-1,0,1,2,3,4,5,6,7),nrow = 1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1111 head<-matrix(data=rep(" ",times=16),nrow = 1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1112 SelectivityHeader<-rbind(head,SelectivityHeader)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1113
b0493d923404 Uploaded
jfb
parents:
diff changeset
1114 write.table(SelectivityHeader, file = FILENAME2, append = TRUE, sep = ",", row.names = FALSE, col.names = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1115 #colnames(SelectivitySheet)<-c("-7","-6","-5","-4","-3","-2","-1","0","1","2","3","4","5","6","7")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1116 write.table(SelectivitySheet,file = FILENAME2, append = TRUE,sep = ",",row.names = TRUE, col.names = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1117 write.table(x=c("Endogenous Probability Matrix"),file=FILENAME2,append = TRUE,sep=",", row.names = FALSE, col.names = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1118 write.table(EPMtableu,file = FILENAME2, append = TRUE,sep = ",",row.names = FALSE, col.names = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1119 write.table(NormalizationScore, file = FILENAME2, append = TRUE,sep = ",",row.names = FALSE, col.names = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1120
b0493d923404 Uploaded
jfb
parents:
diff changeset
1121
b0493d923404 Uploaded
jfb
parents:
diff changeset
1122
b0493d923404 Uploaded
jfb
parents:
diff changeset
1123
b0493d923404 Uploaded
jfb
parents:
diff changeset
1124
b0493d923404 Uploaded
jfb
parents:
diff changeset
1125
b0493d923404 Uploaded
jfb
parents:
diff changeset
1126
b0493d923404 Uploaded
jfb
parents:
diff changeset
1127
b0493d923404 Uploaded
jfb
parents:
diff changeset
1128
b0493d923404 Uploaded
jfb
parents:
diff changeset
1129
b0493d923404 Uploaded
jfb
parents:
diff changeset
1130
b0493d923404 Uploaded
jfb
parents:
diff changeset
1131
b0493d923404 Uploaded
jfb
parents:
diff changeset
1132
b0493d923404 Uploaded
jfb
parents:
diff changeset
1133
b0493d923404 Uploaded
jfb
parents:
diff changeset
1134
b0493d923404 Uploaded
jfb
parents:
diff changeset
1135
b0493d923404 Uploaded
jfb
parents:
diff changeset
1136
b0493d923404 Uploaded
jfb
parents:
diff changeset
1137
b0493d923404 Uploaded
jfb
parents:
diff changeset
1138
b0493d923404 Uploaded
jfb
parents:
diff changeset
1139
b0493d923404 Uploaded
jfb
parents:
diff changeset
1140
b0493d923404 Uploaded
jfb
parents:
diff changeset
1141
b0493d923404 Uploaded
jfb
parents:
diff changeset
1142
b0493d923404 Uploaded
jfb
parents:
diff changeset
1143
b0493d923404 Uploaded
jfb
parents:
diff changeset
1144
b0493d923404 Uploaded
jfb
parents:
diff changeset
1145
b0493d923404 Uploaded
jfb
parents:
diff changeset
1146
b0493d923404 Uploaded
jfb
parents:
diff changeset
1147
b0493d923404 Uploaded
jfb
parents:
diff changeset
1148
b0493d923404 Uploaded
jfb
parents:
diff changeset
1149
b0493d923404 Uploaded
jfb
parents:
diff changeset
1150 #test myself: this script should take in amino acids for each of the 9 positions and give out every single combination of those AAs
b0493d923404 Uploaded
jfb
parents:
diff changeset
1151
b0493d923404 Uploaded
jfb
parents:
diff changeset
1152 #need to do following: fix it so that the accession numbers stay with the substrates,
b0493d923404 Uploaded
jfb
parents:
diff changeset
1153 #also the neg false constant is totaly unphos'd Ys found by FASTA-2-CSV system# uniprot
b0493d923404 Uploaded
jfb
parents:
diff changeset
1154
b0493d923404 Uploaded
jfb
parents:
diff changeset
1155 #HOW MANY: IF THERE'S two aas in each position you get 2^9, so I assume the numbers are:
b0493d923404 Uploaded
jfb
parents:
diff changeset
1156 #(number in position-4)*(number in position -3)*(number in position -2)...=total
b0493d923404 Uploaded
jfb
parents:
diff changeset
1157 # require(rJava)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1158 # require(xlsxjars)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1159 # require(xlsx)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1160 # # require(readxl)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1161
b0493d923404 Uploaded
jfb
parents:
diff changeset
1162 #View(SDtable)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1163 bareSDs<-SDtable[2:21,2:16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1164 goodones<-bareSDs>2
b0493d923404 Uploaded
jfb
parents:
diff changeset
1165
b0493d923404 Uploaded
jfb
parents:
diff changeset
1166 # Positionm7<-which(goodones[,1] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1167 # if (length(Positionm7)<1){Positionm7<-which(bareSDs[,1]==max(bareSDs[,1]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1168 # Positionm6<-which(goodones[,2] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1169 # if (length(Positionm6)<1){Positionm6<-which(bareSDs[,2]==max(bareSDs[,2]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1170 # Positionm5<-which(goodones[,3] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1171 # if (length(Positionm5)<1){Positionm5<-which(bareSDs[,3]==max(bareSDs[,3]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1172 # Positionm4<-which(goodones[,4] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1173 # if (length(Positionm4)<2){Positionm4<-bareSDs[,4][order(bareSDs[,4])[1:2]]}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1174 # Positionm3<-which(goodones[,5] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1175 # if (length(Positionm3)<2){Positionm3<-bareSDs[,5][order(bareSDs[,5])[1:2]]}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1176 # Positionm2<-which(goodones[,6] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1177 # if (length(Positionm2)<2){Positionm2<-bareSDs[,6][order(bareSDs[,6])[1:2]]}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1178 # Positionm1<-which(goodones[,7] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1179 # if (length(Positionm1)<2){Positionm1<-bareSDs[,7][order(bareSDs[,7])[1:2]]}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1180 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1181 # Positiond0<-which(goodones[,8] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1182 # if (length(Positiond0)<1){Positiond0<-which(bareSDs[,8]==max(bareSDs[,8]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1183 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1184 # Positionp1<-which(goodones[,9] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1185 # if (length(Positionp1)<2){Positionp1<-bareSDs[,9][order(bareSDs[,9])[1:2]]}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1186 # Positionp2<-which(goodones[,10] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1187 # if (length(Positionp2)<2){Positionp2<-bareSDs[,10][order(bareSDs[,10])[1:2]]}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1188 # Positionp3<-which(goodones[,11] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1189 # if (length(Positionp3)<2){Positionp3<-bareSDs[,11][order(bareSDs[,11])[1:2]]}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1190 # Positionp4<-which(goodones[,12] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1191 # if (length(Positionp4)<2){Positionp4<-bareSDs[,12][order(bareSDs[,12])[1:2]]}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1192 # Positionp5<-which(goodones[,13] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1193 # if (length(Positionp5)<1){Positionp5<-which(bareSDs[,13]==max(bareSDs[,13]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1194 # Positionp6<-which(goodones[,14] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1195 # if (length(Positionp6)<1){Positionp6<-which(bareSDs[,14]==max(bareSDs[,14]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1196 # Positionp7<-which(goodones[,15] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1197 # if (length(Positionp7)<1){Positionp7<-which(bareSDs[,15]==max(bareSDs[,15]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1198
b0493d923404 Uploaded
jfb
parents:
diff changeset
1199
b0493d923404 Uploaded
jfb
parents:
diff changeset
1200
b0493d923404 Uploaded
jfb
parents:
diff changeset
1201
b0493d923404 Uploaded
jfb
parents:
diff changeset
1202 # Positionm7<-which(goodones[,1] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1203 # if (length(Positionm7)<1){Positionm7<-which(bareSDs[,1]==max(bareSDs[,1]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1204 # Positionm6<-which(goodones[,2] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1205 # if (length(Positionm6)<1){Positionm6<-which(bareSDs[,2]==max(bareSDs[,2]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1206 # Positionm5<-which(goodones[,3] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1207 # if (length(Positionm5)<1){Positionm5<-which(bareSDs[,3]==max(bareSDs[,3]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1208 # Positionm4<-which(goodones[,4] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1209 # if (length(Positionm4)<1){Positionm4<-which(bareSDs[,4]==max(bareSDs[,4]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1210 # Positionm3<-which(goodones[,5] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1211 # if (length(Positionm3)<1){Positionm3<-which(bareSDs[,5]==max(bareSDs[,5]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1212 # Positionm2<-which(goodones[,6] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1213 # if (length(Positionm2)<1){Positionm2<-which(bareSDs[,6]==max(bareSDs[,6]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1214 # Positionm1<-which(goodones[,7] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1215 # if (length(Positionm1)<1){Positionm1<-which(bareSDs[,7]==max(bareSDs[,7]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1216 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1217 # Positiond0<-which(goodones[,8] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1218 # if (length(Positiond0)<1){Positiond0<-which(bareSDs[,8]==max(bareSDs[,8]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1219 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1220 # Positionp1<-which(goodones[,9] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1221 # if (length(Positionp1)<1){Positionp1<-which(bareSDs[,9]==max(bareSDs[,9]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1222 # Positionp2<-which(goodones[,10] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1223 # if (length(Positionp2)<1){Positionp2<-which(bareSDs[,10]==max(bareSDs[,10]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1224 # Positionp3<-which(goodones[,11] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1225 # if (length(Positionp3)<1){Positionp3<-which(bareSDs[,11]==max(bareSDs[,11]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1226 # Positionp4<-which(goodones[,12] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1227 # if (length(Positionp4)<1){Positionp4<-which(bareSDs[,12]==max(bareSDs[,12]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1228 # Positionp5<-which(goodones[,13] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1229 # if (length(Positionp5)<1){Positionp5<-which(bareSDs[,13]==max(bareSDs[,13]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1230 # Positionp6<-which(goodones[,14] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1231 # if (length(Positionp6)<1){Positionp6<-which(bareSDs[,14]==max(bareSDs[,14]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1232 # Positionp7<-which(goodones[,15] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1233 # if (length(Positionp7)<1){Positionp7<-which(bareSDs[,15]==max(bareSDs[,15]))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1234
b0493d923404 Uploaded
jfb
parents:
diff changeset
1235 match(c(bareSDs[,2][order(bareSDs[,2])[1:2]]),bareSDs[,2])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1236
b0493d923404 Uploaded
jfb
parents:
diff changeset
1237 Positionm7<-which(goodones[,1] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1238 if (length(Positionm7)<3){Positionm7<-match(c(bareSDs[,1][order(bareSDs[,1])[19:20]]),bareSDs[,1])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1239 Positionm6<-which(goodones[,2] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1240 if (length(Positionm6)<3){Positionm6<-match(c(bareSDs[,2][order(bareSDs[,2])[19:20]]),bareSDs[,2])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1241 Positionm5<-which(goodones[,3] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1242 if (length(Positionm5)<3){Positionm5<-match(c(bareSDs[,3][order(bareSDs[,3])[19:20]]),bareSDs[,3])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1243 Positionm4<-which(goodones[,4] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1244 if (length(Positionm4)<3){Positionm4<-match(c(bareSDs[,4][order(bareSDs[,4])[19:20]]),bareSDs[,4])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1245 Positionm3<-which(goodones[,5] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1246 if (length(Positionm3)<3){Positionm3<-match(c(bareSDs[,5][order(bareSDs[,5])[19:20]]),bareSDs[,5])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1247 Positionm2<-which(goodones[,6] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1248 if (length(Positionm2)<3){Positionm2<-match(c(bareSDs[,6][order(bareSDs[,6])[19:20]]),bareSDs[,6])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1249 Positionm1<-which(goodones[,7] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1250 if (length(Positionm1)<3){Positionm1<-match(c(bareSDs[,7][order(bareSDs[,7])[19:20]]),bareSDs[,7])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1251
b0493d923404 Uploaded
jfb
parents:
diff changeset
1252 Positiond0<-which(goodones[,8] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1253 #if (length(Positiond0)<3){Positiond0<-bareSDs[,8][order(bareSDs[,8])[1:2]]}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1254
b0493d923404 Uploaded
jfb
parents:
diff changeset
1255 Positionp1<-which(goodones[,9] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1256 if (length(Positionp1)<3){Positionp1<-match(c(bareSDs[,9][order(bareSDs[,9])[19:20]]),bareSDs[,9])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1257 Positionp2<-which(goodones[,10] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1258 if (length(Positionp2)<3){Positionp2<-match(c(bareSDs[,10][order(bareSDs[,10])[19:20]]),bareSDs[,10])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1259 Positionp3<-which(goodones[,11] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1260 if (length(Positionp3)<3){Positionp3<-match(c(bareSDs[,11][order(bareSDs[,11])[19:20]]),bareSDs[,11])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1261 Positionp4<-which(goodones[,12] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1262 if (length(Positionp4)<3){Positionp4<-match(c(bareSDs[,12][order(bareSDs[,12])[19:20]]),bareSDs[,12])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1263 Positionp5<-which(goodones[,13] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1264 if (length(Positionp5)<3){Positionp5<-match(c(bareSDs[,13][order(bareSDs[,13])[19:20]]),bareSDs[,13])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1265 Positionp6<-which(goodones[,14] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1266 if (length(Positionp6)<3){Positionp6<-match(c(bareSDs[,14][order(bareSDs[,14])[19:20]]),bareSDs[,14])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1267 Positionp7<-which(goodones[,15] %in% TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1268 if (length(Positionp7)<3){Positionp7<-match(c(bareSDs[,15][order(bareSDs[,15])[19:20]]),bareSDs[,15])}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1269
b0493d923404 Uploaded
jfb
parents:
diff changeset
1270
b0493d923404 Uploaded
jfb
parents:
diff changeset
1271 aa_props2 <- c("1"="A", "2"="C", "3"="D", "4"="E", "5"="F", "6"="G", "7"="H", "8"="I", "9"="K", "10"="L", "11"="M", "12"="N",
b0493d923404 Uploaded
jfb
parents:
diff changeset
1272 "13"="P", "14"="Q", "15"="R", "16"="S", "17"="T", "18"="V", "19"="W", "20"="Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1273
b0493d923404 Uploaded
jfb
parents:
diff changeset
1274 Positionm7<-sapply(Positionm7, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1275 Positionm6<-sapply(Positionm6, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1276 Positionm5<-sapply(Positionm5, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1277 Positionm4<-sapply(Positionm4, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1278 Positionm3<-sapply(Positionm3, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1279 Positionm2<-sapply(Positionm2, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1280 Positionm1<-sapply(Positionm1, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1281 Positiond0<-sapply(Positiond0, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1282 Positionp1<-sapply(Positionp1, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1283 Positionp2<-sapply(Positionp2, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1284 Positionp3<-sapply(Positionp3, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1285 Positionp4<-sapply(Positionp4, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1286 Positionp5<-sapply(Positionp5, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1287 Positionp6<-sapply(Positionp6, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1288 Positionp7<-sapply(Positionp7, function (x) aa_props2[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1289
b0493d923404 Uploaded
jfb
parents:
diff changeset
1290
b0493d923404 Uploaded
jfb
parents:
diff changeset
1291 # Positionm7<-c("D","H","N","V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1292 # Positionm6<-c("E","V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1293 # Positionm5<-c("D","H")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1294 # Positionm4<-c("D","N")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1295 # Positionm3<-c("D","E","F","Q")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1296 # Positionm2<-c("D","N","Q","S")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1297 # Positionm1<-c("F","I","L")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1298 # Positiond0<-c("Y")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1299 # Positionp1<-c("A","E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1300 # Positionp2<-c("T","S","Q","E")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1301 # Positionp3<-c("V")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1302 # Positionp4<-c("K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1303 # Positionp5<-c("K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1304 # Positionp6<-c("K")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1305 # Positionp7<-c("R")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1306 #this is where the amino acids for each position are given. m means minus, p mean plus
b0493d923404 Uploaded
jfb
parents:
diff changeset
1307 ########################################
b0493d923404 Uploaded
jfb
parents:
diff changeset
1308 # ScreenerFilename<-"C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls"
b0493d923404 Uploaded
jfb
parents:
diff changeset
1309
b0493d923404 Uploaded
jfb
parents:
diff changeset
1310
b0493d923404 Uploaded
jfb
parents:
diff changeset
1311
b0493d923404 Uploaded
jfb
parents:
diff changeset
1312
b0493d923404 Uploaded
jfb
parents:
diff changeset
1313
b0493d923404 Uploaded
jfb
parents:
diff changeset
1314
b0493d923404 Uploaded
jfb
parents:
diff changeset
1315
b0493d923404 Uploaded
jfb
parents:
diff changeset
1316
b0493d923404 Uploaded
jfb
parents:
diff changeset
1317
b0493d923404 Uploaded
jfb
parents:
diff changeset
1318
b0493d923404 Uploaded
jfb
parents:
diff changeset
1319
b0493d923404 Uploaded
jfb
parents:
diff changeset
1320 screaner<-read.csv(ScreenerFilename, header = FALSE, stringsAsFactors = FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1321
b0493d923404 Uploaded
jfb
parents:
diff changeset
1322
b0493d923404 Uploaded
jfb
parents:
diff changeset
1323 AKT<-screaner[2:25,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1324 AMPK<-screaner[27:50,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1325 CDK1<-screaner[52:75,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1326 CHK1<-screaner[77:100,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1327 CK2A1<-screaner[102:125,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1328 LKB1<-screaner[127:150,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1329 MAPK3<-screaner[152:175,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1330 MAPK13<-screaner[177:200,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1331 MTOR<-screaner[202:225,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1332 # Pyk2<-screaner[227:250,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1333 # Src<-screaner[252:275,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1334 # Syk<-screaner[277:300,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1335 # Yes<-screaner[302:325,]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1336
b0493d923404 Uploaded
jfb
parents:
diff changeset
1337 #two questions: why are we doing CDK1 when we already have a bioninformatics page about it?
b0493d923404 Uploaded
jfb
parents:
diff changeset
1338 #two I reran everything and only get 96 positions of interest in the SD table
b0493d923404 Uploaded
jfb
parents:
diff changeset
1339
b0493d923404 Uploaded
jfb
parents:
diff changeset
1340
b0493d923404 Uploaded
jfb
parents:
diff changeset
1341
b0493d923404 Uploaded
jfb
parents:
diff changeset
1342
b0493d923404 Uploaded
jfb
parents:
diff changeset
1343
b0493d923404 Uploaded
jfb
parents:
diff changeset
1344
b0493d923404 Uploaded
jfb
parents:
diff changeset
1345
b0493d923404 Uploaded
jfb
parents:
diff changeset
1346
b0493d923404 Uploaded
jfb
parents:
diff changeset
1347
b0493d923404 Uploaded
jfb
parents:
diff changeset
1348 #Do_You_want_An_Excel_Output_Questionmark<-"NO"
b0493d923404 Uploaded
jfb
parents:
diff changeset
1349 GeneratedPeptidesFile<-"GeneratedPeptidesFile.csv"
b0493d923404 Uploaded
jfb
parents:
diff changeset
1350
b0493d923404 Uploaded
jfb
parents:
diff changeset
1351
b0493d923404 Uploaded
jfb
parents:
diff changeset
1352 # AKT<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 4)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1353 # AMPK<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 5)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1354 # CDK1<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 6)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1355 # CHK1<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1356 # CK2A1<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 8)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1357 # LKB1<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 9)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1358 # MAPK3<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 10)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1359 # MAPK13<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 11)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1360 # MTOR<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 12)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1361 # Pyk2<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 13)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1362 # Src<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 14)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1363 # Syk<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1364 # Yes<-read.xlsx("C:/Users/User Name/Desktop/UMN 2017 Spring/Parker Lab/Kinatest ID/Screener.xls", sheetIndex = 16)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1365 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1366
b0493d923404 Uploaded
jfb
parents:
diff changeset
1367
b0493d923404 Uploaded
jfb
parents:
diff changeset
1368 "A"=1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1369 "C"=2
b0493d923404 Uploaded
jfb
parents:
diff changeset
1370 "D"=3
b0493d923404 Uploaded
jfb
parents:
diff changeset
1371 "E"=4
b0493d923404 Uploaded
jfb
parents:
diff changeset
1372 "F"=5
b0493d923404 Uploaded
jfb
parents:
diff changeset
1373 "G"=6
b0493d923404 Uploaded
jfb
parents:
diff changeset
1374 "H"=7
b0493d923404 Uploaded
jfb
parents:
diff changeset
1375 "I"=8
b0493d923404 Uploaded
jfb
parents:
diff changeset
1376 "K"=9
b0493d923404 Uploaded
jfb
parents:
diff changeset
1377 "L"=10
b0493d923404 Uploaded
jfb
parents:
diff changeset
1378 "M"=11
b0493d923404 Uploaded
jfb
parents:
diff changeset
1379 "N"=12
b0493d923404 Uploaded
jfb
parents:
diff changeset
1380 "P"=13
b0493d923404 Uploaded
jfb
parents:
diff changeset
1381 "Q"=14
b0493d923404 Uploaded
jfb
parents:
diff changeset
1382 "R"=15
b0493d923404 Uploaded
jfb
parents:
diff changeset
1383 "S"=16
b0493d923404 Uploaded
jfb
parents:
diff changeset
1384 "T"=17
b0493d923404 Uploaded
jfb
parents:
diff changeset
1385 "V"=18
b0493d923404 Uploaded
jfb
parents:
diff changeset
1386 "W"=19
b0493d923404 Uploaded
jfb
parents:
diff changeset
1387 "Y"=20
b0493d923404 Uploaded
jfb
parents:
diff changeset
1388
b0493d923404 Uploaded
jfb
parents:
diff changeset
1389 aa_props <- c("A"=A, "C"=C, "D"=D, "E"=E, "F"=F,"G"=G,"H"=H,"I"=I,"K"=K,"L"=L,"M"=M,"N"=N,"P"=P,"Q"=Q,"R"=R,
b0493d923404 Uploaded
jfb
parents:
diff changeset
1390 "S"=S,"T"=T,"V"=V,"W"=W,"Y"=Y,"xY"=Y,"O"=21)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1391
b0493d923404 Uploaded
jfb
parents:
diff changeset
1392 number15<-sapply(Positionm7, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1393 number14<-sapply(Positionm6, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1394 number13<-sapply(Positionm5, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1395 number1 <- sapply(Positionm4, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1396 number2 <- sapply(Positionm3, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1397 number3 <- sapply(Positionm2, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1398 number4 <- sapply(Positionm1, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1399 number5 <- sapply(Positiond0, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1400 number6 <- sapply(Positionp1, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1401 number7 <- sapply(Positionp2, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1402 number8 <- sapply(Positionp3, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1403 number9 <- sapply(Positionp4, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1404 number10<-sapply(Positionp5, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1405 number11<-sapply(Positionp6, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1406 number12<-sapply(Positionp7, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1407
b0493d923404 Uploaded
jfb
parents:
diff changeset
1408 # number1<-Positionm4
b0493d923404 Uploaded
jfb
parents:
diff changeset
1409 # number2<-Positionm3
b0493d923404 Uploaded
jfb
parents:
diff changeset
1410 # number3<-Positionm2
b0493d923404 Uploaded
jfb
parents:
diff changeset
1411 # number4<-Positionm1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1412 # number5<-Positiond0
b0493d923404 Uploaded
jfb
parents:
diff changeset
1413 # number6<-Positionp1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1414 # number7<-Positionp2
b0493d923404 Uploaded
jfb
parents:
diff changeset
1415 # number8<-Positionp3
b0493d923404 Uploaded
jfb
parents:
diff changeset
1416 # number9<-Positionp4
b0493d923404 Uploaded
jfb
parents:
diff changeset
1417
b0493d923404 Uploaded
jfb
parents:
diff changeset
1418 #############################
b0493d923404 Uploaded
jfb
parents:
diff changeset
1419 ########################################
b0493d923404 Uploaded
jfb
parents:
diff changeset
1420
b0493d923404 Uploaded
jfb
parents:
diff changeset
1421
b0493d923404 Uploaded
jfb
parents:
diff changeset
1422 total=length(Positionp7)*length(Positionp6)*length(Positionp5)*length(Positionp4)*length(Positionp3)*(length(Positionp2))*length(Positionp1)*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1423 length(Positiond0)*length(Positionm1)*length(Positionm2)*length(Positionm3)*length(Positionm4)*length(Positionm5)*length(Positionm6)*length(Positionm7)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1424 #this is just a way to doublecheck that the length of the generated peptides vector is correct
b0493d923404 Uploaded
jfb
parents:
diff changeset
1425
b0493d923404 Uploaded
jfb
parents:
diff changeset
1426 GeneratedPeptides<-rep(NA, times=total*15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1427 GeneratedPeptides<-matrix(data = GeneratedPeptides,ncol = 15)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1428
b0493d923404 Uploaded
jfb
parents:
diff changeset
1429 NumeratedPeptides<-GeneratedPeptides
b0493d923404 Uploaded
jfb
parents:
diff changeset
1430 #create an empty vector of correct length by finding the number of each AAs per position and multiplying them
b0493d923404 Uploaded
jfb
parents:
diff changeset
1431 count<-0
b0493d923404 Uploaded
jfb
parents:
diff changeset
1432 for (t in 1:length(Positionm7)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1433 for (s in 1:length(Positionm6)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1434 for (r in 1:length(Positionm5)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1435 for (i in 1:length(Positionm4)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1436 for (j in 1:length(Positionm3)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1437 for (k in 1:length(Positionm2)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1438 for (l in 1:length(Positionm1)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1439 for (m in 1:length(Positiond0)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1440 for (n in 1:length(Positionp1)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1441 for (o in 1:length(Positionp2)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1442 for (p in 1:length(Positionp3)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1443 for (q in 1:length(Positionp4)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1444 for (u in 1:length(Positionp5)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1445 for (v in 1:length(Positionp6)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1446 for (w in 1:length(Positionp7)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1447 # i=1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1448 # j=1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1449 # k=1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1450 # l=1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1451 # m=1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1452 # n=1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1453 # o=1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1454 # p=1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1455 # q=1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1456 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1457 #for every single position, increment the count number, create a peptide using the AAs at that position
b0493d923404 Uploaded
jfb
parents:
diff changeset
1458 #then put them together into the generated peptides sequencex
b0493d923404 Uploaded
jfb
parents:
diff changeset
1459 count<-count+1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1460 tabulation<-c(Positionm7[t],Positionm6[s],Positionm5[r],Positionm4[i],Positionm3[j],Positionm2[k],Positionm1[l],Positiond0[m],Positionp1[n],
b0493d923404 Uploaded
jfb
parents:
diff changeset
1461 Positionp2[o],Positionp3[p],Positionp4[q],Positionp5[u],Positionp6[v],Positionp7[w])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1462 numeration<-c(number15[t],number14[s],number13[r],number1[i],number2[j],number3[k],number4[l],number5[m],number6[n],number7[o],number8[p],number9[q],number10[u],number11[v],
b0493d923404 Uploaded
jfb
parents:
diff changeset
1463 number12[w])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1464 #tabulation<-paste(tabulation, sep="", collapse="")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1465 GeneratedPeptides[count,1:15]<-tabulation
b0493d923404 Uploaded
jfb
parents:
diff changeset
1466 NumeratedPeptides[count,1:15]<-numeration
b0493d923404 Uploaded
jfb
parents:
diff changeset
1467 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1468 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1469 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1470 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1471 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1472 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1473 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1474 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1475 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1476 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1477 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1478 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1479 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1480 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1481 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1482 ####################################################################
b0493d923404 Uploaded
jfb
parents:
diff changeset
1483 #now here I use the Endogenous Probabilty matrix from the previous script, which is called EMPtable
b0493d923404 Uploaded
jfb
parents:
diff changeset
1484 #to score the created peptides
b0493d923404 Uploaded
jfb
parents:
diff changeset
1485 ThisKinTable<-EPMtableu#[1:nrow(SDtable),]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1486 TKTcolumn<-c(data=rep(1,times=21))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1487 TKTcolumn<-as.matrix(TKTcolumn,ncol=1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1488 ThisKinTable<-cbind(TKTcolumn,ThisKinTable)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1489
b0493d923404 Uploaded
jfb
parents:
diff changeset
1490 ThisKinGeneratedScores<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1491 ThisKinGenWeirdScore<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1492
b0493d923404 Uploaded
jfb
parents:
diff changeset
1493 for (x in 1:nrow(GeneratedPeptides)){
b0493d923404 Uploaded
jfb
parents:
diff changeset
1494 Scoringpeptide<-NumeratedPeptides[x,1:15]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1495 Scoringpeptide<-Scoringpeptide+1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1496 ThisKinTableScore<-as.numeric(ThisKinTable[Scoringpeptide[1],3])*ThisKinTable[as.numeric(Scoringpeptide[2]),4]*ThisKinTable[as.numeric(Scoringpeptide[3]),5]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1497 ThisKinTable[as.numeric(Scoringpeptide[4]),6]*ThisKinTable[as.numeric(Scoringpeptide[5]),7]*ThisKinTable[as.numeric(Scoringpeptide[6]),8]*ThisKinTable[as.numeric(Scoringpeptide[7]),9]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1498 #ThisKinTable[as.numeric(Scoringpeptide[8]),10]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1499 ThisKinTable[as.numeric(Scoringpeptide[9]),11]*ThisKinTable[as.numeric(Scoringpeptide[10]),12]*ThisKinTable[as.numeric(Scoringpeptide[11]),13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1500 ThisKinTable[as.numeric(Scoringpeptide[12]),14]*ThisKinTable[as.numeric(Scoringpeptide[13]),15]*ThisKinTable[as.numeric(Scoringpeptide[14]),16]*ThisKinTable[as.numeric(Scoringpeptide[15]),17]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1501 ThisKinGeneratedScores[x]<-ThisKinTableScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1502 ThisKinTableScore<-(ThisKinTableScore/(ThisKinTableScore+1/as.numeric(NormalizationScore[2])))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1503 ThisKinGenWeirdScore[x]<-ThisKinTableScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1504 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1505
b0493d923404 Uploaded
jfb
parents:
diff changeset
1506 AKTGeneratedScores<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1507 AMPKGeneratedScores<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1508 CDK1GeneratedScores<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1509 CHK1GeneratedScores<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1510 CK2A1GeneratedScores<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1511 LKB1GeneratedScores<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1512 MAPK3GeneratedScores<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1513 MAPK13GeneratedScores<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1514 MTORGeneratedScores<-rep(NA,times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1515
b0493d923404 Uploaded
jfb
parents:
diff changeset
1516 for (x in 1:nrow(GeneratedPeptides)){
b0493d923404 Uploaded
jfb
parents:
diff changeset
1517 Scoringpeptide<-NumeratedPeptides[x,1:15]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1518 AKTScore<-AKT[Scoringpeptide[1],2]*AKT[Scoringpeptide[2],3]*AKT[Scoringpeptide[3],4]*AKT[Scoringpeptide[4],5]*AKT[Scoringpeptide[5],6]*AKT[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1519 AKT[Scoringpeptide[7],8]*AKT[Scoringpeptide[9],10]*AKT[Scoringpeptide[10],11]*AKT[Scoringpeptide[11],12]*AKT[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1520 AKT[Scoringpeptide[13],14]*AKT[Scoringpeptide[14],15]*AKT[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1521 AKTGeneratedScores[x]<-AKTScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1522
b0493d923404 Uploaded
jfb
parents:
diff changeset
1523 AMPKScore<-AMPK[Scoringpeptide[1],2]*AMPK[Scoringpeptide[2],3]*AMPK[Scoringpeptide[3],4]*AMPK[Scoringpeptide[4],5]*AMPK[Scoringpeptide[5],6]*AMPK[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1524 AMPK[Scoringpeptide[7],8]*AMPK[Scoringpeptide[9],10]*AMPK[Scoringpeptide[10],11]*AMPK[Scoringpeptide[11],12]*AMPK[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1525 AMPK[Scoringpeptide[13],14]*AMPK[Scoringpeptide[14],15]*AMPK[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1526 AMPKGeneratedScores[x]<-AMPKScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1527
b0493d923404 Uploaded
jfb
parents:
diff changeset
1528 CDK1Score<-CDK1[Scoringpeptide[1],2]*CDK1[Scoringpeptide[2],3]*CDK1[Scoringpeptide[3],4]*CDK1[Scoringpeptide[4],5]*CDK1[Scoringpeptide[5],6]*CDK1[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1529 CDK1[Scoringpeptide[7],8]*CDK1[Scoringpeptide[9],10]*CDK1[Scoringpeptide[10],11]*CDK1[Scoringpeptide[11],12]*CDK1[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1530 CDK1[Scoringpeptide[13],14]*CDK1[Scoringpeptide[14],15]*CDK1[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1531 CDK1GeneratedScores[x]<-CDK1Score
b0493d923404 Uploaded
jfb
parents:
diff changeset
1532
b0493d923404 Uploaded
jfb
parents:
diff changeset
1533 CHK1Score<-CHK1[Scoringpeptide[1],2]*CHK1[Scoringpeptide[2],3]*CHK1[Scoringpeptide[3],4]*CHK1[Scoringpeptide[4],5]*CHK1[Scoringpeptide[5],6]*CHK1[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1534 CHK1[Scoringpeptide[7],8]*CHK1[Scoringpeptide[9],10]*CHK1[Scoringpeptide[10],11]*CHK1[Scoringpeptide[11],12]*CHK1[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1535 CHK1[Scoringpeptide[13],14]*CHK1[Scoringpeptide[14],15]*CHK1[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1536 CHK1GeneratedScores[x]<-CHK1Score
b0493d923404 Uploaded
jfb
parents:
diff changeset
1537
b0493d923404 Uploaded
jfb
parents:
diff changeset
1538 CK2A1Score<-CK2A1[Scoringpeptide[1],2]*CK2A1[Scoringpeptide[2],3]*CK2A1[Scoringpeptide[3],4]*CK2A1[Scoringpeptide[4],5]*CK2A1[Scoringpeptide[5],6]*CK2A1[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1539 CK2A1[Scoringpeptide[7],8]*CK2A1[Scoringpeptide[9],10]*CK2A1[Scoringpeptide[10],11]*CK2A1[Scoringpeptide[11],12]*CK2A1[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1540 CK2A1[Scoringpeptide[13],14]*CK2A1[Scoringpeptide[14],15]*CK2A1[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1541 CK2A1GeneratedScores[x]<-CK2A1Score
b0493d923404 Uploaded
jfb
parents:
diff changeset
1542
b0493d923404 Uploaded
jfb
parents:
diff changeset
1543 LKB1Score<-LKB1[Scoringpeptide[1],2]*LKB1[Scoringpeptide[2],3]*LKB1[Scoringpeptide[3],4]*LKB1[Scoringpeptide[4],5]*LKB1[Scoringpeptide[5],6]*LKB1[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1544 LKB1[Scoringpeptide[7],8]*LKB1[Scoringpeptide[9],10]*LKB1[Scoringpeptide[10],11]*LKB1[Scoringpeptide[11],12]*LKB1[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1545 LKB1[Scoringpeptide[13],14]*LKB1[Scoringpeptide[14],15]*LKB1[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1546 LKB1GeneratedScores[x]<-LKB1Score
b0493d923404 Uploaded
jfb
parents:
diff changeset
1547
b0493d923404 Uploaded
jfb
parents:
diff changeset
1548 MAPK3Score<-MAPK3[Scoringpeptide[1],2]*MAPK3[Scoringpeptide[2],3]*MAPK3[Scoringpeptide[3],4]*MAPK3[Scoringpeptide[4],5]*MAPK3[Scoringpeptide[5],6]*MAPK3[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1549 MAPK3[Scoringpeptide[7],8]*MAPK3[Scoringpeptide[9],10]*MAPK3[Scoringpeptide[10],11]*MAPK3[Scoringpeptide[11],12]*MAPK3[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1550 MAPK3[Scoringpeptide[13],14]*MAPK3[Scoringpeptide[14],15]*MAPK3[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1551 MAPK3GeneratedScores[x]<-MAPK3Score
b0493d923404 Uploaded
jfb
parents:
diff changeset
1552
b0493d923404 Uploaded
jfb
parents:
diff changeset
1553 MAPK13Score<-MAPK13[Scoringpeptide[1],2]*MAPK13[Scoringpeptide[2],3]*MAPK13[Scoringpeptide[3],4]*MAPK13[Scoringpeptide[4],5]*MAPK13[Scoringpeptide[5],6]*MAPK13[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1554 MAPK13[Scoringpeptide[7],8]*MAPK13[Scoringpeptide[9],10]*MAPK13[Scoringpeptide[10],11]*MAPK13[Scoringpeptide[11],12]*MAPK13[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1555 MAPK13[Scoringpeptide[13],14]*MAPK13[Scoringpeptide[14],15]*MAPK13[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1556 MAPK13GeneratedScores[x]<-MAPK13Score
b0493d923404 Uploaded
jfb
parents:
diff changeset
1557
b0493d923404 Uploaded
jfb
parents:
diff changeset
1558 MTORScore<-MTOR[Scoringpeptide[1],2]*MTOR[Scoringpeptide[2],3]*MTOR[Scoringpeptide[3],4]*MTOR[Scoringpeptide[4],5]*MTOR[Scoringpeptide[5],6]*MTOR[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1559 MTOR[Scoringpeptide[7],8]*MTOR[Scoringpeptide[9],10]*MTOR[Scoringpeptide[10],11]*MTOR[Scoringpeptide[11],12]*MTOR[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1560 MTOR[Scoringpeptide[13],14]*MTOR[Scoringpeptide[14],15]*MTOR[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1561 MTORGeneratedScores[x]<-MTORScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1562
b0493d923404 Uploaded
jfb
parents:
diff changeset
1563 # Pyk2Score<-Pyk2[Scoringpeptide[1],2]*Pyk2[Scoringpeptide[2],3]*Pyk2[Scoringpeptide[3],4]*Pyk2[Scoringpeptide[4],5]*Pyk2[Scoringpeptide[5],6]*Pyk2[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1564 # Pyk2[Scoringpeptide[7],8]*Pyk2[Scoringpeptide[9],10]*Pyk2[Scoringpeptide[10],11]*Pyk2[Scoringpeptide[11],12]*Pyk2[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1565 # Pyk2[Scoringpeptide[13],14]*Pyk2[Scoringpeptide[14],15]*Pyk2[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1566 # Pyk2GeneratedScores[x]<-Pyk2Score
b0493d923404 Uploaded
jfb
parents:
diff changeset
1567 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1568 # SrcScore<-Src[Scoringpeptide[1],2]*Src[Scoringpeptide[2],3]*Src[Scoringpeptide[3],4]*Src[Scoringpeptide[4],5]*Src[Scoringpeptide[5],6]*Src[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1569 # Src[Scoringpeptide[7],8]*Src[Scoringpeptide[9],10]*Src[Scoringpeptide[10],11]*Src[Scoringpeptide[11],12]*Src[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1570 # Src[Scoringpeptide[13],14]*Src[Scoringpeptide[14],15]*Src[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1571 # SrcGeneratedScores[x]<-SrcScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1572 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1573 # SykScore<-Syk[Scoringpeptide[1],2]*Syk[Scoringpeptide[2],3]*Syk[Scoringpeptide[3],4]*Syk[Scoringpeptide[4],5]*Syk[Scoringpeptide[5],6]*Syk[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1574 # Syk[Scoringpeptide[7],8]*Syk[Scoringpeptide[9],10]*Syk[Scoringpeptide[10],11]*Syk[Scoringpeptide[11],12]*Syk[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1575 # Syk[Scoringpeptide[13],14]*Syk[Scoringpeptide[14],15]*Syk[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1576 # SykGeneratedScores[x]<-SykScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1577 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1578 # YesScore<-Yes[Scoringpeptide[1],2]*Yes[Scoringpeptide[2],3]*Yes[Scoringpeptide[3],4]*Yes[Scoringpeptide[4],5]*Yes[Scoringpeptide[5],6]*Yes[Scoringpeptide[6],7]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1579 # Yes[Scoringpeptide[7],8]*Yes[Scoringpeptide[9],10]*Yes[Scoringpeptide[10],11]*Yes[Scoringpeptide[11],12]*Yes[Scoringpeptide[12],13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1580 # Yes[Scoringpeptide[13],14]*Yes[Scoringpeptide[14],15]*Yes[Scoringpeptide[15],16]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1581 # YesGeneratedScores[x]<-YesScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1582
b0493d923404 Uploaded
jfb
parents:
diff changeset
1583 # ThisKinTableScore<-ThisKinTable[as.numeric(Scoringpeptide[1]),3]*ThisKinTable[as.numeric(Scoringpeptide[2]),4]*ThisKinTable[as.numeric(Scoringpeptide[3]),5]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1584 # ThisKinTable[as.numeric(Scoringpeptide[4]),6]*ThisKinTable[as.numeric(Scoringpeptide[6]),8]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1585 # ThisKinTable[as.numeric(Scoringpeptide[7]),9]*ThisKinTable[as.numeric(Scoringpeptide[8]),10]*ThisKinTable[as.numeric(Scoringpeptide[9]),11]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1586 # ThisKinGeneratedScores[x]<-ThisKinTableScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1587 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1588
b0493d923404 Uploaded
jfb
parents:
diff changeset
1589
b0493d923404 Uploaded
jfb
parents:
diff changeset
1590
b0493d923404 Uploaded
jfb
parents:
diff changeset
1591 AKTNorm<-1/as.numeric(AKT[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1592 AKTThresh<-as.numeric(AKT[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1593 AKTTrueThresh<-((AKTThresh*AKTNorm)/(100-AKTThresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1594 AKTActive<-unlist(AKTGeneratedScores)>AKTTrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1595 if (TodaysKinase=="AKT"){AKTActive<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1596
b0493d923404 Uploaded
jfb
parents:
diff changeset
1597 AMPKNorm<-1/as.numeric(AMPK[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1598 AMPKThresh<-as.numeric(AMPK[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1599 AMPKTrueThresh<-((AMPKThresh*AMPKNorm)/(100-AMPKThresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1600 AMPKActive<-unlist(AMPKGeneratedScores)>AMPKTrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1601 if (TodaysKinase=="AMPK"){AMPKActive<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1602
b0493d923404 Uploaded
jfb
parents:
diff changeset
1603 CDK1Norm<-1/as.numeric(CDK1[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1604 CDK1Thresh<-as.numeric(CDK1[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1605 CDK1TrueThresh<-((CDK1Thresh*CDK1Norm)/(100-CDK1Thresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1606 CDK1Active<-unlist(CDK1GeneratedScores)>CDK1TrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1607 if (TodaysKinase=="CDK1"){CDK1Active<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1608
b0493d923404 Uploaded
jfb
parents:
diff changeset
1609 CHK1Norm<-1/as.numeric(CHK1[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1610 CHK1Thresh<-as.numeric(CHK1[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1611 CHK1TrueThresh<-((CHK1Thresh*CHK1Norm)/(100-CHK1Thresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1612 CHK1Active<-(CHK1GeneratedScores)>CHK1TrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1613 if (TodaysKinase=="CHK1"){CHK1Active<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1614
b0493d923404 Uploaded
jfb
parents:
diff changeset
1615 CK2A1Norm<-1/as.numeric(CK2A1[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1616 CK2A1Thresh<-as.numeric(CK2A1[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1617 CK2A1TrueThresh<-((CK2A1Thresh*CK2A1Norm)/(100-CK2A1Thresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1618 CK2A1Active<-unlist(CK2A1GeneratedScores)>CK2A1TrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1619 if (TodaysKinase=="CK2A1"){CK2A1Active<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1620
b0493d923404 Uploaded
jfb
parents:
diff changeset
1621 LKB1Norm<-1/as.numeric(LKB1[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1622 LKB1Thresh<-as.numeric(LKB1[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1623 LKB1TrueThresh<-((LKB1Thresh*LKB1Norm)/(100-LKB1Thresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1624 LKB1Active<-unlist(LKB1GeneratedScores)>LKB1TrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1625 if (TodaysKinase=="LKB1"){LKB1Active<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1626
b0493d923404 Uploaded
jfb
parents:
diff changeset
1627 MAPK3Norm<-1/as.numeric(MAPK3[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1628 MAPK3Thresh<-as.numeric(MAPK3[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1629 MAPK3TrueThresh<-((MAPK3Thresh*MAPK3Norm)/(100-MAPK3Thresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1630 MAPK3Active<-unlist(MAPK3GeneratedScores)>MAPK3TrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1631 if (TodaysKinase=="MAPK3"){MAPK3Active<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1632
b0493d923404 Uploaded
jfb
parents:
diff changeset
1633 MAPK13Norm<-1/as.numeric(MAPK13[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1634 MAPK13Thresh<-as.numeric(MAPK13[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1635 MAPK13TrueThresh<-((MAPK13Thresh*MAPK13Norm)/(100-MAPK13Thresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1636 MAPK13Active<-unlist(MAPK13GeneratedScores)>MAPK13TrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1637 if (TodaysKinase=="MAPK13"){MAPK13Active<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1638
b0493d923404 Uploaded
jfb
parents:
diff changeset
1639 MTORNorm<-1/as.numeric(MTOR[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1640 MTORThresh<-as.numeric(MTOR[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1641 MTORTrueThresh<-((MTORThresh*MTORNorm)/(100-MTORThresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1642 MTORActive<-unlist(MTORGeneratedScores)>MTORTrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1643 if (TodaysKinase=="MTOR"){MTORActive<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1644
b0493d923404 Uploaded
jfb
parents:
diff changeset
1645 # Pyk2Norm<-1/as.numeric(Pyk2[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1646 # Pyk2Thresh<-as.numeric(Pyk2[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1647 # Pyk2TrueThresh<-((Pyk2Thresh*Pyk2Norm)/(100-Pyk2Thresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1648 # Pyk2Active<-unlist(Pyk2GeneratedScores)>Pyk2TrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1649 # if (TodaysKinase=="PYK2"){Pyk2Active<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1650 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1651 # SrcNorm<-1/as.numeric(Src[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1652 # SrcThresh<-as.numeric(Src[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1653 # SrcTrueThresh<-((SrcThresh*SrcNorm)/(100-SrcThresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1654 # SrcActive<-unlist(SrcGeneratedScores)>SrcTrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1655 # if (TodaysKinase=="SRC"){SrcActive<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1656 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1657 # SykNorm<-1/as.numeric(Syk[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1658 # SykThresh<-as.numeric(Syk[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1659 # SykTrueThresh<-((SykThresh*SykNorm)/(100-SykThresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1660 # SykActive<-unlist(SykGeneratedScores)>SykTrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1661 # if (TodaysKinase=="SYK"){SykActive<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1662 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1663 # YesNorm<-1/as.numeric(Yes[22,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1664 # YesThresh<-as.numeric(Yes[24,1])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1665 # YesTrueThresh<-((YesThresh*YesNorm)/(100-YesThresh))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1666 # YesActive<-unlist(YesGeneratedScores)>YesTrueThresh
b0493d923404 Uploaded
jfb
parents:
diff changeset
1667 # if (TodaysKinase=="YES"){YesActive<-rep(0,times=nrow(GeneratedPeptides))}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1668
b0493d923404 Uploaded
jfb
parents:
diff changeset
1669 AllActive<-AKTActive+AMPKActive+CDK1Active+CHK1Active+CK2A1Active+LKB1Active+MAPK3Active+MAPK13Active+MTORActive
b0493d923404 Uploaded
jfb
parents:
diff changeset
1670
b0493d923404 Uploaded
jfb
parents:
diff changeset
1671 Scores<-ThisKinGeneratedScores
b0493d923404 Uploaded
jfb
parents:
diff changeset
1672 ThresholdValues<-ThisKinGenWeirdScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1673
b0493d923404 Uploaded
jfb
parents:
diff changeset
1674 FullMotifs<-rep("Z",times=nrow(GeneratedPeptides))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1675 for (i in 1:nrow(GeneratedPeptides)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1676 motif<-GeneratedPeptides[i,1:15]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1677 motif<-paste(motif,sep = "", collapse = "")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1678 FullMotifs[i]<-motif
b0493d923404 Uploaded
jfb
parents:
diff changeset
1679 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1680
b0493d923404 Uploaded
jfb
parents:
diff changeset
1681 PeptidesWithRanks<-cbind.data.frame(FullMotifs,GeneratedPeptides,Scores,ThresholdValues)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1682 PeptidesWithRanks<-cbind.data.frame(PeptidesWithRanks,AllActive,AKTActive,AMPKActive,CDK1Active,CHK1Active,CK2A1Active,LKB1Active,MAPK3Active,MAPK13Active,MTORActive)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1683 RanksPeptides<-PeptidesWithRanks[order(PeptidesWithRanks$ThresholdValues,decreasing = FALSE),]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1684 # PepRankHead<-c(1:9,"Sequence","RPMS","PMS")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1685 # RanksPeptides<-rbind.data.frame(PepRankHead,PeptidesWithRanks)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1686 #head(RanksPeptides)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1687
b0493d923404 Uploaded
jfb
parents:
diff changeset
1688
b0493d923404 Uploaded
jfb
parents:
diff changeset
1689 #now I have to score the negative sequences... for some reason
b0493d923404 Uploaded
jfb
parents:
diff changeset
1690 #write up how we transfect with lipofectamine
b0493d923404 Uploaded
jfb
parents:
diff changeset
1691 #3,4,5 questions
b0493d923404 Uploaded
jfb
parents:
diff changeset
1692
b0493d923404 Uploaded
jfb
parents:
diff changeset
1693 #PAUSED EHRE AT 4:50, HOPING THAT FIXING MINERVOTHING SO THAT LEFT SPACES WORKS FIXES A THING. OTHERWISE
b0493d923404 Uploaded
jfb
parents:
diff changeset
1694 #I FUCKED WITH THE MCC TABLE AND NEED TO FINISH IT
b0493d923404 Uploaded
jfb
parents:
diff changeset
1695
b0493d923404 Uploaded
jfb
parents:
diff changeset
1696 ThisKinBlanks<-rep(1,times=17)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1697 #indx <- sapply(breast, is.factor)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1698 #ThisKinTable[indx] <- lapply(ThisKinTable[indx], function(x) as.character(x))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1699 ThisKinTable$SetOfAAs<-as.character(ThisKinTable$SetOfAAs)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1700
b0493d923404 Uploaded
jfb
parents:
diff changeset
1701 #ThisKinTest<-rbind.data.frame(ThisKinTable,ThisKinBlanks)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1702 ThisKinTable<-rbind.data.frame(ThisKinTable,ThisKinBlanks)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1703
b0493d923404 Uploaded
jfb
parents:
diff changeset
1704 NegativeScores<-rep(NA,times=nrow(NegativeSubstrateList))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1705 NegativeWeirdScores<-rep(NA,times=nrow(NegativeSubstrateList))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1706 for (v in 1:nrow(NegativeSubstrateList)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1707 motif<-NegativeSubstrateList[v,2]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1708 motif<-unlist(strsplit(motif,""))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1709 #if (length(motif)<9){print(v)}}
b0493d923404 Uploaded
jfb
parents:
diff changeset
1710 # motif[1] <- sapply(motif[1], function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1711 # motif[2] <- sapply(motif[2], function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1712 # motif[3] <- sapply(motif[3], function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1713 # motif[4] <- sapply(motif[4], function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1714 # motif[5] <- sapply(motif[5], function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1715 # motif[6] <- sapply(motif[6], function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1716 # motif[7] <- sapply(motif[7], function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1717 # motif[8] <- sapply(motif[8], function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1718 # motif[9] <- sapply(motif[9], function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1719 motif<- gsub(" ","O",motif)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1720 motif <- sapply(motif, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1721 Scoringpeptide<-motif
b0493d923404 Uploaded
jfb
parents:
diff changeset
1722 Scoringpeptide<-Scoringpeptide+1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1723 ThisKinTableScore<-as.numeric(ThisKinTable[Scoringpeptide[1],3])*ThisKinTable[as.numeric(Scoringpeptide[2]),4]*ThisKinTable[as.numeric(Scoringpeptide[3]),5]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1724 ThisKinTable[as.numeric(Scoringpeptide[4]),6]*ThisKinTable[as.numeric(Scoringpeptide[5]),7]*ThisKinTable[as.numeric(Scoringpeptide[6]),8]*ThisKinTable[as.numeric(Scoringpeptide[7]),9]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1725 #ThisKinTable[as.numeric(Scoringpeptide[8]),10]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1726 ThisKinTable[as.numeric(Scoringpeptide[9]),11]*ThisKinTable[as.numeric(Scoringpeptide[10]),12]*ThisKinTable[as.numeric(Scoringpeptide[11]),13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1727 ThisKinTable[as.numeric(Scoringpeptide[12]),14]*ThisKinTable[as.numeric(Scoringpeptide[13]),15]*ThisKinTable[as.numeric(Scoringpeptide[14]),16]*ThisKinTable[as.numeric(Scoringpeptide[15]),17]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1728 NegativeScores[v]<-ThisKinTableScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1729 ThisKinTableScore<-(ThisKinTableScore/(ThisKinTableScore+1/as.numeric(NormalizationScore[2])))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1730 NegativeWeirdScores[v]<-ThisKinTableScore*100
b0493d923404 Uploaded
jfb
parents:
diff changeset
1731 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1732
b0493d923404 Uploaded
jfb
parents:
diff changeset
1733 negativesubstrates<-NegativeSubstrateList[,2]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1734 NegativeWithScores<-cbind(negativesubstrates,as.character(NegativeScores),as.character(NegativeWeirdScores))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1735
b0493d923404 Uploaded
jfb
parents:
diff changeset
1736
b0493d923404 Uploaded
jfb
parents:
diff changeset
1737 #NEED TO HAVE THE NEGATIVE SUBSTRATES BE OUTPUTTED
b0493d923404 Uploaded
jfb
parents:
diff changeset
1738
b0493d923404 Uploaded
jfb
parents:
diff changeset
1739 PositiveScores<-rep(NA,times=nrow(ImportedSubstrateList))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1740 PositiveWeirdScores<-rep(NA,times=nrow(ImportedSubstrateList))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1741
b0493d923404 Uploaded
jfb
parents:
diff changeset
1742 for (v in 1:nrow(ImportedSubstrateList)) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1743 motif<-ImportedSubstrateList[v,4:18]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1744 motif<-unlist(motif)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1745 motif<- gsub("^$","O",motif)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1746 motif <- sapply(motif, function (x) aa_props[x])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1747 Scoringpeptide<-motif
b0493d923404 Uploaded
jfb
parents:
diff changeset
1748 Scoringpeptide<-Scoringpeptide+1
b0493d923404 Uploaded
jfb
parents:
diff changeset
1749 ThisKinTableScore<-as.numeric(ThisKinTable[Scoringpeptide[1],3])*ThisKinTable[as.numeric(Scoringpeptide[2]),4]*ThisKinTable[as.numeric(Scoringpeptide[3]),5]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1750 ThisKinTable[as.numeric(Scoringpeptide[4]),6]*ThisKinTable[as.numeric(Scoringpeptide[5]),7]*ThisKinTable[as.numeric(Scoringpeptide[6]),8]*ThisKinTable[as.numeric(Scoringpeptide[7]),9]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1751 #ThisKinTable[as.numeric(Scoringpeptide[8]),10]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1752 ThisKinTable[as.numeric(Scoringpeptide[9]),11]*ThisKinTable[as.numeric(Scoringpeptide[10]),12]*ThisKinTable[as.numeric(Scoringpeptide[11]),13]*
b0493d923404 Uploaded
jfb
parents:
diff changeset
1753 ThisKinTable[as.numeric(Scoringpeptide[12]),14]*ThisKinTable[as.numeric(Scoringpeptide[13]),15]*ThisKinTable[as.numeric(Scoringpeptide[14]),16]*ThisKinTable[as.numeric(Scoringpeptide[15]),17]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1754
b0493d923404 Uploaded
jfb
parents:
diff changeset
1755 PositiveScores[v]<-ThisKinTableScore
b0493d923404 Uploaded
jfb
parents:
diff changeset
1756 ThisKinTableScore<-(ThisKinTableScore/(ThisKinTableScore+1/as.numeric(NormalizationScore[2])))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1757 PositiveWeirdScores[v]<-ThisKinTableScore*100
b0493d923404 Uploaded
jfb
parents:
diff changeset
1758 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1759
b0493d923404 Uploaded
jfb
parents:
diff changeset
1760 positivesubstrates<-ImportedSubstrateList[,4:18]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1761 positivewithscores<-cbind.data.frame(positivesubstrates,PositiveScores,PositiveWeirdScores)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1762
b0493d923404 Uploaded
jfb
parents:
diff changeset
1763
b0493d923404 Uploaded
jfb
parents:
diff changeset
1764 #write down the transient transfection SOP and what we will be doing with them
b0493d923404 Uploaded
jfb
parents:
diff changeset
1765 #write down the vector names I will be using
b0493d923404 Uploaded
jfb
parents:
diff changeset
1766 #write down something about transforming bacteria and with what
b0493d923404 Uploaded
jfb
parents:
diff changeset
1767
b0493d923404 Uploaded
jfb
parents:
diff changeset
1768 #90% whatevernness
b0493d923404 Uploaded
jfb
parents:
diff changeset
1769 # TPninetyone<-length(PositiveWeirdScores[PositiveWeirdScores>=0.91])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1770 # Senseninetyone<-TPninetyone/nrow(positivesubstrates)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1771 #
b0493d923404 Uploaded
jfb
parents:
diff changeset
1772 # TNninetyone<-length(NegativeWeirdScores[NegativeWeirdScores<91])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1773 # Specninetyone<-TNninetyone/100
b0493d923404 Uploaded
jfb
parents:
diff changeset
1774
b0493d923404 Uploaded
jfb
parents:
diff changeset
1775 #create the MCC table
b0493d923404 Uploaded
jfb
parents:
diff changeset
1776
b0493d923404 Uploaded
jfb
parents:
diff changeset
1777 threshold<-c(1:100,(1:9)/10,(1:9)/100,0,-.1)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1778 threshold<-threshold[order(threshold,decreasing = TRUE)]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1779 threshold
b0493d923404 Uploaded
jfb
parents:
diff changeset
1780
b0493d923404 Uploaded
jfb
parents:
diff changeset
1781 Truepositives<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1782 Falsenegatives<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1783 Sensitivity<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1784 TrueNegatives<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1785 FalsePositives<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1786 One_Minus_Specificity<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1787 Accuracy<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1788 MCC<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1789 EER<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1790 FalsePositiveRate<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1791 Precision<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1792 F_One_Half<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1793 F_One<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1794 F_Two<-c(1:120)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1795
b0493d923404 Uploaded
jfb
parents:
diff changeset
1796 #MAKE DAMN SURE THAT THE ACCESSION NUMBERS FOLLOW THE MOTIFS
b0493d923404 Uploaded
jfb
parents:
diff changeset
1797
b0493d923404 Uploaded
jfb
parents:
diff changeset
1798 for (z in 1:120) {
b0493d923404 Uploaded
jfb
parents:
diff changeset
1799 thres<-threshold[z]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1800 Truepositives[z]<-length(PositiveWeirdScores[PositiveWeirdScores>=(thres)])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1801 Falsenegatives[z]<-nrow(positivesubstrates)-Truepositives[z]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1802 Sensitivity[z]<-Truepositives[z]/(Falsenegatives[z]+Truepositives[z])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1803 TrueNegatives[z]<-length(NegativeWeirdScores[NegativeWeirdScores<(thres)])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1804 # at thresh 100 this should be 0, because it is total minus true negatives
b0493d923404 Uploaded
jfb
parents:
diff changeset
1805 FalsePositives[z]<-nrow(NegativeSubstrateList)-TrueNegatives[z]
b0493d923404 Uploaded
jfb
parents:
diff changeset
1806 One_Minus_Specificity[z]<-1-(TrueNegatives[z]/(FalsePositives[z]+TrueNegatives[z]))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1807 Accuracy[z]<-100*(Truepositives[z]+TrueNegatives[z])/(Falsenegatives[z]+FalsePositives[z]+TrueNegatives[z]+Truepositives[z])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1808 MCC[z]<-((Truepositives[z]*TrueNegatives[z])-(Falsenegatives[z]*FalsePositives[z]))/sqrt(round(round(Truepositives[z]+Falsenegatives[z])*round(TrueNegatives[z]+FalsePositives[z])*round(Truepositives[z]+FalsePositives[z])*round(TrueNegatives[z]+Falsenegatives[z])))
b0493d923404 Uploaded
jfb
parents:
diff changeset
1809 EER[z]<-(FalsePositives[z]+Falsenegatives[z])/(Truepositives[z]+TrueNegatives[z]+FalsePositives[z]+Falsenegatives[z])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1810 Precision[z]<-Truepositives[z]/(Truepositives[z]+FalsePositives[z])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1811 F_One_Half[z]<-(1.5*Precision[z]*Sensitivity[z])/(.25*Precision[z]+Sensitivity[z])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1812 F_One<-(1*Precision[z]*Sensitivity[z])/(Precision[z]+Sensitivity[z])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1813 F_Two<-(5*Precision[z]*Sensitivity[z])/(4*Precision[z]+Sensitivity[z])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1814 FalsePositiveRate[z]<-FalsePositives[z]/(TrueNegatives[z]+FalsePositives[z])
b0493d923404 Uploaded
jfb
parents:
diff changeset
1815 }
b0493d923404 Uploaded
jfb
parents:
diff changeset
1816 Characterization<-cbind.data.frame(threshold,Truepositives,Falsenegatives,Sensitivity,TrueNegatives,FalsePositives,One_Minus_Specificity,MCC,EER,Precision,FalsePositiveRate,F_One_Half,F_One,F_Two)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1817
b0493d923404 Uploaded
jfb
parents:
diff changeset
1818 positiveheader<-c(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"RPMS","PMS")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1819 positivewithscores<-rbind.data.frame(positiveheader,positivewithscores)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1820
b0493d923404 Uploaded
jfb
parents:
diff changeset
1821 negativeheader<-c("Substrate","RPMS","PMS")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1822 colnames(NegativeWithScores)<-negativeheader
b0493d923404 Uploaded
jfb
parents:
diff changeset
1823
b0493d923404 Uploaded
jfb
parents:
diff changeset
1824 # write.xlsx(NegativeWithScores,file = FILENAME, sheetName = "Negative Sequences Scored",col.names = TRUE,row.names = FALSE,append = TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1825 # write.xlsx(Characterization,file = FILENAME,sheetName = "Characterization Table",col.names = TRUE,row.names = FALSE,append = TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1826 # write.xlsx(RanksPeptides,file = FILENAME,sheetName = "Ranked Generated Peptides",col.names = FALSE,row.names = FALSE,append = TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1827 # write.xlsx(positivewithscores,file = FILENAME, sheetName = "Positive Sequences Scored",col.names = FALSE,row.names = FALSE,append = TRUE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1828 write.table(x=c("Characterzation Table"),file = FILENAME2, col.names = FALSE,row.names = FALSE, append = TRUE,sep = ",")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1829 header<-colnames(Characterization)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1830 Characterization<-rbind.data.frame(header,Characterization)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1831 write.table(Characterization,file = FILENAME2, col.names = FALSE,row.names = FALSE, append = TRUE,sep = ",")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1832
b0493d923404 Uploaded
jfb
parents:
diff changeset
1833 # header<-colnames(RanksPeptides)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1834 # RanksPeptides<-rbind.data.frame(header,RanksPeptides)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1835 write.table(x="Off Target Kinase activity (your kinase of interest should have zeros here because it is ON-target)",file = FILENAME3,append = FALSE,row.names = FALSE,col.names = TRUE,sep = ",")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1836 write.table(RanksPeptides,file = FILENAME3,append = FALSE,row.names = FALSE,col.names = TRUE,sep = ",")
b0493d923404 Uploaded
jfb
parents:
diff changeset
1837
b0493d923404 Uploaded
jfb
parents:
diff changeset
1838
b0493d923404 Uploaded
jfb
parents:
diff changeset
1839 PositivesWithScores<-as.data.frame(ImportedSubstrateList)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1840 PositiveOutput<-cbind(PositivesWithScores,PositiveWeirdScores)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1841 write.table(PositiveOutput, file = FILENAME4, sep = ",", na="",row.names=FALSE)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1842
b0493d923404 Uploaded
jfb
parents:
diff changeset
1843 NegativeOutput<-as.data.frame(NegativeSubstrateList)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1844 NegativeOutput<-cbind(NegativeOutput,NegativeWeirdScores)
b0493d923404 Uploaded
jfb
parents:
diff changeset
1845 write.table(NegativeOutput,file = FILENAME5,sep = ",",na="",row.names = FALSE)