annotate kinatestid_r/Kinatest-R.R @ 7:231e41a2d167 draft

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