annotate all stuff/Difference finderMADE 7 TO 7 1-15-2019.R @ 2:beba4066121e draft

Uploaded
author jfb
date Wed, 16 Jan 2019 14:33:39 -0500
parents 110a74dff8e1
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
23eea82f5192 Uploaded
jfb
parents:
diff changeset
1 #I should make an SOP for this. Problems we encountered: no x in the xY motif, and the kilodemon
23eea82f5192 Uploaded
jfb
parents:
diff changeset
2 #the output files have both Y and xY, they shouldn't why is that happening? make it not happen
23eea82f5192 Uploaded
jfb
parents:
diff changeset
3 #make sure that accession numbers stay locked to each motif, somehow
23eea82f5192 Uploaded
jfb
parents:
diff changeset
4 #output should look just like the KALIP input
23eea82f5192 Uploaded
jfb
parents:
diff changeset
5
23eea82f5192 Uploaded
jfb
parents:
diff changeset
6 #ff you want ONLY FULL MOTIFS, put "YES" here, please use all caps
23eea82f5192 Uploaded
jfb
parents:
diff changeset
7 FullMotifsOnly_questionmark<-"NO"
23eea82f5192 Uploaded
jfb
parents:
diff changeset
8 #If you want ONLY TRUNCATED MOTIFS, put "YES" here, please use all caps
23eea82f5192 Uploaded
jfb
parents:
diff changeset
9 TruncatedMotifsOnly_questionmark<-"NO"
23eea82f5192 Uploaded
jfb
parents:
diff changeset
10 #if you want to find the overlap, put a "YES" here (all caps), if you want to find the non-overlap, put "NO" (all caps)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
11 Are_You_Looking_For_Commonality<-"NO"
23eea82f5192 Uploaded
jfb
parents:
diff changeset
12
23eea82f5192 Uploaded
jfb
parents:
diff changeset
13
23eea82f5192 Uploaded
jfb
parents:
diff changeset
14 #put the names of your input files here
23eea82f5192 Uploaded
jfb
parents:
diff changeset
15 FirstSubstrateSet<- read.csv("S1.csv", stringsAsFactors=FALSE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
16 Firstsubbackfreq<- read.csv("SBF1.csv", header=FALSE, stringsAsFactors=FALSE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
17
23eea82f5192 Uploaded
jfb
parents:
diff changeset
18 SecondSubstrateSet<- read.csv("S2.csv", stringsAsFactors=FALSE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
19 Secondsubbackfreq<- read.csv("SBF2.csv", header=FALSE, stringsAsFactors=FALSE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
20
23eea82f5192 Uploaded
jfb
parents:
diff changeset
21 # ThirdSubstrateSet<- read.csv("Galaxy69-BTK_PLUS_R3_Substrates.csv", stringsAsFactors=FALSE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
22 # Thirdsubbackfreq<- read.csv("Galaxy70-BTK_PLUS_R3_SubstrateBackgroundFrequency.csv", header=FALSE, stringsAsFactors=FALSE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
23
23eea82f5192 Uploaded
jfb
parents:
diff changeset
24 #then put the names of your output files here
23eea82f5192 Uploaded
jfb
parents:
diff changeset
25 # Shared_motifs_table<-"180719_GALAXY-BTK-plus-rep-OVLP-7to7-substrates.csv"
23eea82f5192 Uploaded
jfb
parents:
diff changeset
26 # Shared_subbackfreq_table<-"180719_GALAXY-BTK-plus-rep-OVLP-7to7-SubBackFreq.csv"
23eea82f5192 Uploaded
jfb
parents:
diff changeset
27
23eea82f5192 Uploaded
jfb
parents:
diff changeset
28 # Shared_motifs_table<-"Shared motifs 7-27-17.csv"
23eea82f5192 Uploaded
jfb
parents:
diff changeset
29 # Shared_subbackfreq_table<-"SubstrateBackgrounFrequency-for-shared-motifs 4 7-27-17.csv"
23eea82f5192 Uploaded
jfb
parents:
diff changeset
30
2
beba4066121e Uploaded
jfb
parents: 1
diff changeset
31 First_unshared_motifs_table<-"1RS.csv"
beba4066121e Uploaded
jfb
parents: 1
diff changeset
32 First_unshared_subbackfreq<-"1RSBF.csv"
0
23eea82f5192 Uploaded
jfb
parents:
diff changeset
33
2
beba4066121e Uploaded
jfb
parents: 1
diff changeset
34 Second_unshared_motifs_table<-"2RS.csv"
beba4066121e Uploaded
jfb
parents: 1
diff changeset
35 Second_unshared_subbackfreq<-"2RSBF.csv"
0
23eea82f5192 Uploaded
jfb
parents:
diff changeset
36
23eea82f5192 Uploaded
jfb
parents:
diff changeset
37 # Third_unshared_motifs_table<-"R3 subs.csv"
23eea82f5192 Uploaded
jfb
parents:
diff changeset
38 # Third_unshared_subbackfreq<-"R3 SBF.csv"
23eea82f5192 Uploaded
jfb
parents:
diff changeset
39
23eea82f5192 Uploaded
jfb
parents:
diff changeset
40 #final note, this code is going to be unworkable if you want to make a Venn diagram of more than 3 circles. I think I'll poke around
23eea82f5192 Uploaded
jfb
parents:
diff changeset
41 #other languages to see if any of them can do it.
23eea82f5192 Uploaded
jfb
parents:
diff changeset
42 ####################################################################################################################################
23eea82f5192 Uploaded
jfb
parents:
diff changeset
43
23eea82f5192 Uploaded
jfb
parents:
diff changeset
44
23eea82f5192 Uploaded
jfb
parents:
diff changeset
45
23eea82f5192 Uploaded
jfb
parents:
diff changeset
46
23eea82f5192 Uploaded
jfb
parents:
diff changeset
47
23eea82f5192 Uploaded
jfb
parents:
diff changeset
48 # grepl(pattern = "S", x=asdf, ignore.case = TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
49
23eea82f5192 Uploaded
jfb
parents:
diff changeset
50 FirstCentralLetters<-FirstSubstrateSet[,11]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
51 SecondCentralLetters<-SecondSubstrateSet[,11]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
52
23eea82f5192 Uploaded
jfb
parents:
diff changeset
53 FirstEsses<-sapply(FirstCentralLetters, grepl, pattern="S", ignore.case=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
54 FirstTees<-sapply(FirstCentralLetters, grepl, pattern="T", ignore.case=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
55 FirstWys<-sapply(FirstCentralLetters, grepl, pattern="Y", ignore.case=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
56
1
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
57 SecondEsses<-sapply(SecondCentralLetters, grepl, pattern="S", ignore.case=TRUE)
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
58 SecondTees<-sapply(SecondCentralLetters, grepl, pattern="T", ignore.case=TRUE)
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
59 SecondWys<-sapply(SecondCentralLetters, grepl, pattern="Y", ignore.case=TRUE)
0
23eea82f5192 Uploaded
jfb
parents:
diff changeset
60
23eea82f5192 Uploaded
jfb
parents:
diff changeset
61 FirstCentralLetters<-replace(FirstCentralLetters,FirstEsses,"xS")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
62 FirstCentralLetters<-replace(FirstCentralLetters,FirstTees,"xT")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
63 FirstCentralLetters<-replace(FirstCentralLetters,FirstWys,"xY")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
64
1
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
65 SecondCentralLetters<-replace(SecondCentralLetters,SecondEsses,"xS")
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
66 SecondCentralLetters<-replace(SecondCentralLetters,SecondTees,"xT")
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
67 SecondCentralLetters<-replace(SecondCentralLetters,SecondWys,"xY")
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
68
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
69 FirstCentralLetters->FirstSubstrateSet[,11]
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
70 SecondCentralLetters->SecondSubstrateSet[,11]
0
23eea82f5192 Uploaded
jfb
parents:
diff changeset
71
23eea82f5192 Uploaded
jfb
parents:
diff changeset
72 ####################################################################################################################################
23eea82f5192 Uploaded
jfb
parents:
diff changeset
73 ####################################################################################################################################
23eea82f5192 Uploaded
jfb
parents:
diff changeset
74 # better version of this code written in C: what happens when two kinases share a motif, but they found that motif in two
23eea82f5192 Uploaded
jfb
parents:
diff changeset
75 # separate proteins thus two separate accession numbers?
23eea82f5192 Uploaded
jfb
parents:
diff changeset
76 # It should actually output the shared motif and BOTH accession numbers. Right now it does not, it only maps out the second
23eea82f5192 Uploaded
jfb
parents:
diff changeset
77 # accession number. So that needs to be fixed BUT you need to keep the commonality between a motif and its accession number
23eea82f5192 Uploaded
jfb
parents:
diff changeset
78 ####################################################################################################################################
23eea82f5192 Uploaded
jfb
parents:
diff changeset
79 ####################################################################################################################################
23eea82f5192 Uploaded
jfb
parents:
diff changeset
80 ####################################################################################################################################
23eea82f5192 Uploaded
jfb
parents:
diff changeset
81 ####################################################################################################################################
23eea82f5192 Uploaded
jfb
parents:
diff changeset
82
23eea82f5192 Uploaded
jfb
parents:
diff changeset
83 #Create the motif sets, deciding wether or not you're looking for truncated or full here
23eea82f5192 Uploaded
jfb
parents:
diff changeset
84 #full only
23eea82f5192 Uploaded
jfb
parents:
diff changeset
85
23eea82f5192 Uploaded
jfb
parents:
diff changeset
86
23eea82f5192 Uploaded
jfb
parents:
diff changeset
87 if (Are_You_Looking_For_Commonality=="NO"){
23eea82f5192 Uploaded
jfb
parents:
diff changeset
88
23eea82f5192 Uploaded
jfb
parents:
diff changeset
89 ###############################################
23eea82f5192 Uploaded
jfb
parents:
diff changeset
90 #ALL motifs, full and truncated
23eea82f5192 Uploaded
jfb
parents:
diff changeset
91
23eea82f5192 Uploaded
jfb
parents:
diff changeset
92 if (FullMotifsOnly_questionmark!="YES"&&TruncatedMotifsOnly_questionmark!="YES"){
23eea82f5192 Uploaded
jfb
parents:
diff changeset
93 FTLwtmotifs=matrix(,nrow = nrow(FirstSubstrateSet),ncol=1)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
94 FTLwtAccessionNumbers=matrix(,nrow = nrow(FirstSubstrateSet),ncol=1)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
95
23eea82f5192 Uploaded
jfb
parents:
diff changeset
96 for (i in 1:nrow(FirstSubstrateSet)){
23eea82f5192 Uploaded
jfb
parents:
diff changeset
97 FTLwtletters<-FirstSubstrateSet[i,4:18]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
98 FTLwtletters<-FTLwtletters[FTLwtletters !="XXXXX"]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
99 FTLwtletters<-paste(FTLwtletters, sep="", collapse="")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
100 leftspaces<-c()
23eea82f5192 Uploaded
jfb
parents:
diff changeset
101 rightspaces<-c()
23eea82f5192 Uploaded
jfb
parents:
diff changeset
102
23eea82f5192 Uploaded
jfb
parents:
diff changeset
103 YYYmotif <- unlist(strsplit(FTLwtletters, split = ""))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
104 YYYposition <- match(x = "x", table = YYYmotif)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
105 #position itself tells me how much is to the left of that X by what it's number is. x at position 4 tells me that there are
23eea82f5192 Uploaded
jfb
parents:
diff changeset
106 #just 3 letters to the left of x
23eea82f5192 Uploaded
jfb
parents:
diff changeset
107
23eea82f5192 Uploaded
jfb
parents:
diff changeset
108 YYYLettersToTheLeft <- YYYposition - 1
23eea82f5192 Uploaded
jfb
parents:
diff changeset
109 #how many letters to the right SHOULD just be length(motif)-position-1 if it's 5 long and x is at 3 then Y is at 4 and there is
23eea82f5192 Uploaded
jfb
parents:
diff changeset
110 #just 1 spot to the right of Y so LettersToTheRight<-1 because 5-3-1=1
23eea82f5192 Uploaded
jfb
parents:
diff changeset
111 YYYLettersToTheRight <- length(YYYmotif) - YYYposition - 1
23eea82f5192 Uploaded
jfb
parents:
diff changeset
112 #then sanity check, we're currently looking only at +/-4, but this spot allows for up to +/- 7 as well, just depends on what the
23eea82f5192 Uploaded
jfb
parents:
diff changeset
113 #variable the user puts in is
23eea82f5192 Uploaded
jfb
parents:
diff changeset
114
23eea82f5192 Uploaded
jfb
parents:
diff changeset
115
23eea82f5192 Uploaded
jfb
parents:
diff changeset
116 if (YYYLettersToTheLeft < 7 | YYYLettersToTheRight < 7) {
23eea82f5192 Uploaded
jfb
parents:
diff changeset
117 leftspaces<-rep(" ",times=(7-YYYLettersToTheLeft))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
118 rightspaces<-rep(" ",times=7-(YYYLettersToTheRight))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
119 #add blank spaces if the motif has less than 4 letters to the left/right
23eea82f5192 Uploaded
jfb
parents:
diff changeset
120 motif<-c(leftspaces,YYYmotif,rightspaces)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
121 #save that motif, which is the Y and +/- 4 amino acids, including truncation
23eea82f5192 Uploaded
jfb
parents:
diff changeset
122 motif<-motif[!motif %in% "x"]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
123 motif<-paste(motif, sep="", collapse="")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
124 FTLwtletters<-motif
23eea82f5192 Uploaded
jfb
parents:
diff changeset
125 FTLwtmotifs[i,1]<-FTLwtletters
23eea82f5192 Uploaded
jfb
parents:
diff changeset
126 FTLwtAccessionNumbers[i,1]<-FirstSubstrateSet[i,3]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
127 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
128
23eea82f5192 Uploaded
jfb
parents:
diff changeset
129 if(YYYLettersToTheLeft>6 && YYYLettersToTheRight>6){
23eea82f5192 Uploaded
jfb
parents:
diff changeset
130 motif<-YYYmotif
23eea82f5192 Uploaded
jfb
parents:
diff changeset
131 #add blank spaces if the motif has less than 4 letters to the left/right
23eea82f5192 Uploaded
jfb
parents:
diff changeset
132 motif<-c(leftspaces,YYYmotif,rightspaces)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
133 #save that motif, which is the Y and +/- 4 amino acids, including truncation
23eea82f5192 Uploaded
jfb
parents:
diff changeset
134 motif<-motif[!motif %in% "x"]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
135 motif<-paste(motif, sep="", collapse="")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
136 FTLwtletters<-motif
23eea82f5192 Uploaded
jfb
parents:
diff changeset
137 FTLwtmotifs[i,1]<-FTLwtletters
23eea82f5192 Uploaded
jfb
parents:
diff changeset
138 FTLwtAccessionNumbers[i,1]<-FirstSubstrateSet[i,3]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
139
23eea82f5192 Uploaded
jfb
parents:
diff changeset
140
23eea82f5192 Uploaded
jfb
parents:
diff changeset
141 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
142
23eea82f5192 Uploaded
jfb
parents:
diff changeset
143 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
144
23eea82f5192 Uploaded
jfb
parents:
diff changeset
145 D835Ymotifs=matrix(,nrow = nrow(SecondSubstrateSet),ncol=1)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
146 D835YAccessionNumbers<-matrix(,nrow = nrow(SecondSubstrateSet),ncol = 1)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
147
23eea82f5192 Uploaded
jfb
parents:
diff changeset
148 for (i in 1:nrow(SecondSubstrateSet)){
23eea82f5192 Uploaded
jfb
parents:
diff changeset
149 D835letters<-SecondSubstrateSet[i,4:18]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
150 D835letters<-D835letters[D835letters !="XXXXX"]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
151 D835letters<-paste(D835letters, sep="", collapse="")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
152 leftspaces<-c()
23eea82f5192 Uploaded
jfb
parents:
diff changeset
153 rightspaces<-c()
23eea82f5192 Uploaded
jfb
parents:
diff changeset
154
23eea82f5192 Uploaded
jfb
parents:
diff changeset
155 YYYmotif <- unlist(strsplit(D835letters, split = ""))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
156 YYYposition <- match(x = "x", table = YYYmotif)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
157 #position itself tells me how much is to the left of that X by what it's number is. x at position 4 tells me that there are
23eea82f5192 Uploaded
jfb
parents:
diff changeset
158 #just 3 letters to the left of x
23eea82f5192 Uploaded
jfb
parents:
diff changeset
159
23eea82f5192 Uploaded
jfb
parents:
diff changeset
160 YYYLettersToTheLeft <- YYYposition - 1
23eea82f5192 Uploaded
jfb
parents:
diff changeset
161 #how many letters to the right SHOULD just be length(motif)-position-1 if it's 5 long and x is at 3 then Y is at 4 and there is
23eea82f5192 Uploaded
jfb
parents:
diff changeset
162 #just 1 spot to the right of Y so LettersToTheRight<-1 because 5-3-1=1
23eea82f5192 Uploaded
jfb
parents:
diff changeset
163 YYYLettersToTheRight <- length(YYYmotif) - YYYposition - 1
23eea82f5192 Uploaded
jfb
parents:
diff changeset
164 #then sanity check, we're currently looking only at +/-4, but this spot allows for up to +/- 7 as well, just depends on what the
23eea82f5192 Uploaded
jfb
parents:
diff changeset
165 #variable the user puts in is
23eea82f5192 Uploaded
jfb
parents:
diff changeset
166 if (YYYLettersToTheLeft < 7 | YYYLettersToTheRight < 7) {
23eea82f5192 Uploaded
jfb
parents:
diff changeset
167 leftspaces<-rep(" ",times=(7-YYYLettersToTheLeft))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
168 rightspaces<-rep(" ",times=7-(YYYLettersToTheRight))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
169 #add blank spaces if the motif has less than 4 letters to the left/right
23eea82f5192 Uploaded
jfb
parents:
diff changeset
170 motif<-c(leftspaces,YYYmotif,rightspaces)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
171 #save that motif, which is the Y and +/- 4 amino acids, including truncation
23eea82f5192 Uploaded
jfb
parents:
diff changeset
172 motif<-motif[!motif %in% "x"]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
173 motif<-paste(motif, sep="", collapse="")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
174 D835letters<-motif
23eea82f5192 Uploaded
jfb
parents:
diff changeset
175 D835Ymotifs[i,1]<-D835letters
23eea82f5192 Uploaded
jfb
parents:
diff changeset
176 D835YAccessionNumbers[i,1]<-FirstSubstrateSet[i,3]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
177 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
178
23eea82f5192 Uploaded
jfb
parents:
diff changeset
179 if(YYYLettersToTheLeft>6 && YYYLettersToTheRight>6){
23eea82f5192 Uploaded
jfb
parents:
diff changeset
180 motif<-YYYmotif
23eea82f5192 Uploaded
jfb
parents:
diff changeset
181 #add blank spaces if the motif has less than 4 letters to the left/right
23eea82f5192 Uploaded
jfb
parents:
diff changeset
182 motif<-c(leftspaces,YYYmotif,rightspaces)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
183 #save that motif, which is the Y and +/- 4 amino acids, including truncation
23eea82f5192 Uploaded
jfb
parents:
diff changeset
184 motif<-motif[!motif %in% "x"]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
185 motif<-paste(motif, sep="", collapse="")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
186 D835letters<-motif
23eea82f5192 Uploaded
jfb
parents:
diff changeset
187 D835Ymotifs[i,1]<-D835letters
23eea82f5192 Uploaded
jfb
parents:
diff changeset
188 D835YAccessionNumbers[i,1]<-FirstSubstrateSet[i,3]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
189 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
190 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
191
23eea82f5192 Uploaded
jfb
parents:
diff changeset
192 names(FTLwtmotifs)<-FTLwtAccessionNumbers
23eea82f5192 Uploaded
jfb
parents:
diff changeset
193 names(D835Ymotifs)<-D835YAccessionNumbers
23eea82f5192 Uploaded
jfb
parents:
diff changeset
194
23eea82f5192 Uploaded
jfb
parents:
diff changeset
195 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
196
23eea82f5192 Uploaded
jfb
parents:
diff changeset
197
23eea82f5192 Uploaded
jfb
parents:
diff changeset
198 FTLwtmotifsFINAL<-FTLwtmotifs[!FTLwtmotifs %in% D835Ymotifs]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
199 FTLwtmotifsFINAL<-FTLwtmotifsFINAL[!duplicated(FTLwtmotifsFINAL)]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
200
23eea82f5192 Uploaded
jfb
parents:
diff changeset
201 D835YmotifsFINAL<-D835Ymotifs[!D835Ymotifs %in% FTLwtmotifs]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
202 D835YmotifsFINAL<-D835YmotifsFINAL[!duplicated(D835YmotifsFINAL)]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
203
23eea82f5192 Uploaded
jfb
parents:
diff changeset
204
23eea82f5192 Uploaded
jfb
parents:
diff changeset
205 columnalheader<-c(rep(NA,36))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
206 FTLFinalMatrix<-matrix(data =columnalheader,nrow = 1)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
207
23eea82f5192 Uploaded
jfb
parents:
diff changeset
208 for (k in 1:length(FTLwtmotifsFINAL)) {
23eea82f5192 Uploaded
jfb
parents:
diff changeset
209 AN<-00000
23eea82f5192 Uploaded
jfb
parents:
diff changeset
210 #I don't remember why, but I felt it necessary to destroy the accession number multiple times to ensure it is
23eea82f5192 Uploaded
jfb
parents:
diff changeset
211 #destroyed immediately after use
23eea82f5192 Uploaded
jfb
parents:
diff changeset
212 for (m in 1:ncol(Firstsubbackfreq)) {
23eea82f5192 Uploaded
jfb
parents:
diff changeset
213 AN <- as.character(Firstsubbackfreq[1, m])
23eea82f5192 Uploaded
jfb
parents:
diff changeset
214 if (grepl(pattern = AN,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
215 x = names(FTLwtmotifsFINAL[k]),
23eea82f5192 Uploaded
jfb
parents:
diff changeset
216 fixed = TRUE) == TRUE) {
23eea82f5192 Uploaded
jfb
parents:
diff changeset
217 outputmatrix <- as.character(Firstsubbackfreq[, m])
23eea82f5192 Uploaded
jfb
parents:
diff changeset
218 outputmatrix <- matrix(outputmatrix, nrow = 1)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
219 #with that accession number, find a match in the subbackfreq file and save it here
23eea82f5192 Uploaded
jfb
parents:
diff changeset
220 FTLFinalMatrix<-rbind(FTLFinalMatrix,outputmatrix)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
221 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
222 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
223 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
224 FTLFinalMatrix<-FTLFinalMatrix[!duplicated(FTLFinalMatrix),]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
225 FTLFinalMatrix<-FTLFinalMatrix[2:nrow(FTLFinalMatrix),]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
226
23eea82f5192 Uploaded
jfb
parents:
diff changeset
227 columnalheader<-c(rep(NA,36))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
228 D835YFinalMatrix<-matrix(data =columnalheader,nrow = 1)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
229
23eea82f5192 Uploaded
jfb
parents:
diff changeset
230 for (k in 1:length(D835YmotifsFINAL)) {
23eea82f5192 Uploaded
jfb
parents:
diff changeset
231 #I don't remember why, but I felt it necessary to destroy the accession number multiple times to ensure it is
23eea82f5192 Uploaded
jfb
parents:
diff changeset
232 #destroyed immediately after use
23eea82f5192 Uploaded
jfb
parents:
diff changeset
233 for (m in 1:ncol(Secondsubbackfreq)) {
23eea82f5192 Uploaded
jfb
parents:
diff changeset
234 AN <- as.character(Secondsubbackfreq[1, m])
23eea82f5192 Uploaded
jfb
parents:
diff changeset
235 if (grepl(pattern = AN,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
236 x = names(D835YmotifsFINAL[k]),
23eea82f5192 Uploaded
jfb
parents:
diff changeset
237 fixed = TRUE) == TRUE) {
23eea82f5192 Uploaded
jfb
parents:
diff changeset
238 outputmatrix <- as.character(Secondsubbackfreq[, m])
23eea82f5192 Uploaded
jfb
parents:
diff changeset
239 outputmatrix <- matrix(outputmatrix, nrow = 1)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
240 #with that accession number, find a match in the subbackfreq file and save it here
23eea82f5192 Uploaded
jfb
parents:
diff changeset
241 D835YFinalMatrix<-rbind(D835YFinalMatrix,outputmatrix)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
242 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
243 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
244 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
245 D835YFinalMatrix<-D835YFinalMatrix[!duplicated(D835YFinalMatrix),]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
246 D835YFinalMatrix<-D835YFinalMatrix[2:nrow(D835YFinalMatrix),]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
247
23eea82f5192 Uploaded
jfb
parents:
diff changeset
248 FTLoutputmatrix<-matrix(data=c(FTLwtmotifsFINAL,names(FTLwtmotifsFINAL)),ncol = 2)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
249
23eea82f5192 Uploaded
jfb
parents:
diff changeset
250
23eea82f5192 Uploaded
jfb
parents:
diff changeset
251 FLTheader<-c("Substrate","Species","Reference","-7","-6","-5","-4","-3","-2","-1","0","1","2","3","4","5","6","7","Phosphite")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
252 # FLTheader<-unlist(FLTheader)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
253 lefthandFLT<-matrix(data = rep(NA,times=2*nrow(FTLoutputmatrix)),nrow=nrow(FTLoutputmatrix))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
254 righthandFLT<-matrix(data = rep(NA,times=1*nrow(FTLoutputmatrix)),nrow=nrow(FTLoutputmatrix))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
255 FLTaccessionset<-FTLoutputmatrix[,2]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
256 FTLmeat<-sapply(FTLoutputmatrix[,1], strsplit, "")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
257 FTLmeat<-sapply(FTLmeat, unlist)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
258 colnames(FTLmeat)<-NULL
23eea82f5192 Uploaded
jfb
parents:
diff changeset
259 FTLmeat<-t(FTLmeat)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
260
23eea82f5192 Uploaded
jfb
parents:
diff changeset
261 FTLoutputmatrix2<-cbind(lefthandFLT,FLTaccessionset,FTLmeat,righthandFLT)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
262 colnames(FTLoutputmatrix2)<-NULL
23eea82f5192 Uploaded
jfb
parents:
diff changeset
263 rownames(FTLoutputmatrix2)<-NULL
23eea82f5192 Uploaded
jfb
parents:
diff changeset
264 colnames(FLTheader)<-NULL
23eea82f5192 Uploaded
jfb
parents:
diff changeset
265 rownames(FLTheader)<-NULL
23eea82f5192 Uploaded
jfb
parents:
diff changeset
266
23eea82f5192 Uploaded
jfb
parents:
diff changeset
267
23eea82f5192 Uploaded
jfb
parents:
diff changeset
268 FirstCentralLettersAGAIN<-FTLoutputmatrix2[,11]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
269
23eea82f5192 Uploaded
jfb
parents:
diff changeset
270 FirstEsses<-sapply(FirstCentralLettersAGAIN, grepl, pattern="S", ignore.case=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
271 FirstTees<-sapply(FirstCentralLettersAGAIN, grepl, pattern="T", ignore.case=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
272 FirstWys<-sapply(FirstCentralLettersAGAIN, grepl, pattern="Y", ignore.case=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
273
23eea82f5192 Uploaded
jfb
parents:
diff changeset
274 FirstCentralLettersAGAIN<-replace(FirstCentralLettersAGAIN,FirstEsses,"xS")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
275 FirstCentralLettersAGAIN<-replace(FirstCentralLettersAGAIN,FirstTees,"xT")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
276 FirstCentralLettersAGAIN<-replace(FirstCentralLettersAGAIN,FirstWys,"xY")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
277
23eea82f5192 Uploaded
jfb
parents:
diff changeset
278 FirstCentralLettersAGAIN->FTLoutputmatrix2[,11]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
279
23eea82f5192 Uploaded
jfb
parents:
diff changeset
280 FTLoutputmatrix2<-rbind(FLTheader,FTLoutputmatrix2)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
281
23eea82f5192 Uploaded
jfb
parents:
diff changeset
282 write.table(x=FTLoutputmatrix2,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
283 file=First_unshared_motifs_table,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
284 quote=FALSE, sep=",",
23eea82f5192 Uploaded
jfb
parents:
diff changeset
285 row.names=FALSE,col.names = FALSE, na="", append=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
286
23eea82f5192 Uploaded
jfb
parents:
diff changeset
287 columnalheader<-c("Accession Numbers",as.character(Firstsubbackfreq[1:35,1]))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
288 columnalheader<-matrix(columnalheader,nrow = 1)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
289 write.table(x=columnalheader,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
290 file=First_unshared_subbackfreq,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
291 quote=FALSE, sep=",",
23eea82f5192 Uploaded
jfb
parents:
diff changeset
292 row.names=FALSE,col.names = FALSE, na="", append=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
293
23eea82f5192 Uploaded
jfb
parents:
diff changeset
294 write.table(x=FTLFinalMatrix,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
295 file=First_unshared_subbackfreq,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
296 quote=FALSE, sep=",",
23eea82f5192 Uploaded
jfb
parents:
diff changeset
297 row.names=FALSE,col.names = FALSE, na="", append=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
298
23eea82f5192 Uploaded
jfb
parents:
diff changeset
299 ############################################################################################################
23eea82f5192 Uploaded
jfb
parents:
diff changeset
300
23eea82f5192 Uploaded
jfb
parents:
diff changeset
301 D835Youtputmatrix<-matrix(data=c(D835YmotifsFINAL,names(D835YmotifsFINAL)),ncol = 2)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
302
23eea82f5192 Uploaded
jfb
parents:
diff changeset
303 D835Yheader<-c("Substrate","Species","Reference","-7","-6","-5","-4","-3","-2","-1","0","1","2","3","4","5","6","7","Phosphite")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
304 # D835Yheader<-unlist(D835Yheader)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
305 lefthandD835<-matrix(data = rep(NA,times=2*nrow(D835Youtputmatrix)),nrow=nrow(D835Youtputmatrix))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
306 righthandD835<-matrix(data = rep(NA,times=1*nrow(D835Youtputmatrix)),nrow=nrow(D835Youtputmatrix))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
307 D835Yaset<-D835Youtputmatrix[,2]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
308 D835meat<-sapply(D835Youtputmatrix[,1], strsplit, "")
23eea82f5192 Uploaded
jfb
parents:
diff changeset
309 D835meat<-sapply(D835meat, unlist)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
310 colnames(D835meat)<-NULL
23eea82f5192 Uploaded
jfb
parents:
diff changeset
311 D835meat<-t(D835meat)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
312
23eea82f5192 Uploaded
jfb
parents:
diff changeset
313 D835Youtputmatrix2<-cbind(lefthandD835,D835Yaset,D835meat,righthandD835)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
314 colnames(D835Youtputmatrix2)<-NULL
23eea82f5192 Uploaded
jfb
parents:
diff changeset
315 rownames(D835Youtputmatrix2)<-NULL
23eea82f5192 Uploaded
jfb
parents:
diff changeset
316 colnames(D835Yheader)<-NULL
23eea82f5192 Uploaded
jfb
parents:
diff changeset
317 rownames(D835Yheader)<-NULL
23eea82f5192 Uploaded
jfb
parents:
diff changeset
318
23eea82f5192 Uploaded
jfb
parents:
diff changeset
319
23eea82f5192 Uploaded
jfb
parents:
diff changeset
320 SecondCentralLettersAGAIN<-D835Youtputmatrix2[,11]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
321
23eea82f5192 Uploaded
jfb
parents:
diff changeset
322 SecondEsses<-sapply(SecondCentralLettersAGAIN, grepl, pattern="S", ignore.case=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
323 SecondTees<-sapply(SecondCentralLettersAGAIN, grepl, pattern="T", ignore.case=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
324 SecondWys<-sapply(SecondCentralLettersAGAIN, grepl, pattern="Y", ignore.case=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
325
1
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
326 SecondCentralLettersAGAIN<-replace(SecondCentralLettersAGAIN,SecondEsses,"xS")
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
327 SecondCentralLettersAGAIN<-replace(SecondCentralLettersAGAIN,SecondTees,"xT")
110a74dff8e1 Uploaded
jfb
parents: 0
diff changeset
328 SecondCentralLettersAGAIN<-replace(SecondCentralLettersAGAIN,SecondWys,"xY")
0
23eea82f5192 Uploaded
jfb
parents:
diff changeset
329
23eea82f5192 Uploaded
jfb
parents:
diff changeset
330 SecondCentralLettersAGAIN->D835Youtputmatrix2[,11]
23eea82f5192 Uploaded
jfb
parents:
diff changeset
331
23eea82f5192 Uploaded
jfb
parents:
diff changeset
332 D835Youtputmatrix2<-rbind(D835Yheader,D835Youtputmatrix2)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
333
23eea82f5192 Uploaded
jfb
parents:
diff changeset
334 write.table(x=D835Youtputmatrix2,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
335 file=Second_unshared_motifs_table,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
336 quote=FALSE, sep=",",
23eea82f5192 Uploaded
jfb
parents:
diff changeset
337 row.names=FALSE,col.names = FALSE, na="", append=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
338
23eea82f5192 Uploaded
jfb
parents:
diff changeset
339 columnalheader<-c("Accession Numbers",as.character(Firstsubbackfreq[1:35,1]))
23eea82f5192 Uploaded
jfb
parents:
diff changeset
340 columnalheader<-matrix(columnalheader,nrow = 1)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
341 write.table(x=columnalheader,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
342 file=Second_unshared_subbackfreq,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
343 quote=FALSE, sep=",",
23eea82f5192 Uploaded
jfb
parents:
diff changeset
344 row.names=FALSE,col.names = FALSE, na="", append=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
345
23eea82f5192 Uploaded
jfb
parents:
diff changeset
346 write.table(x=D835YFinalMatrix,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
347 file=Second_unshared_subbackfreq,
23eea82f5192 Uploaded
jfb
parents:
diff changeset
348 quote=FALSE, sep=",",
23eea82f5192 Uploaded
jfb
parents:
diff changeset
349 row.names=FALSE,col.names = FALSE, na="", append=TRUE)
23eea82f5192 Uploaded
jfb
parents:
diff changeset
350 }
23eea82f5192 Uploaded
jfb
parents:
diff changeset
351