annotate kinatestid_r/Kinatest-R.R @ 2:00e1ca8f787c draft

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