Base-pair collective (covariation) scores

460 rows where conformation = "cWW", group_code = "C" and molecule = "16S" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: reference_base_pair, tertiary_type, Xch, Ych, PE, DfDel

strength 4

molecule 1

  • 16S · 460 ✖

group_code 1

conformation 1

  • cWW · 460 ✖
Link rowid molecule helix_number position_1 ▼ position_2 pair_note header_format reference_base_pair conformation ai_code tertiary_type header_extra strength group_code Xch Ych PE PES Cov1 Cov3 C1+C3 WC WCGU XCons YCons DfDel PNuc Seq
5 5 16S 1 9 25   v4 G:C cWW       Strong C 2 0 0 0.0 0.0 0.0 0.0 0.98 0.98 1.81 2.0 0.0 0.68 123
12 12 16S 1 10 24   v4 A:U cWW       Strong C 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.68 124
19 19 16S 1 11 23   v4 G:C cWW       Strong C 1 0 0 0.0 0.0 0.0 0.0 0.99 0.99 1.93 2.0 0.0 0.69 125
26 26 16S 1 12 22   v4 U:G cWW       Strong C 1 0 0 0.0 0.0 0.0 0.0 0.0 0.99 1.93 2.0 0.0 0.69 126
40 40 16S 2 17 918   v4 U:A cWW   3°: pseudoknot   Strong C 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 1.93 0.01 0.64 117
47 47 16S 2 18 917   v4 C:G cWW   3°: pseudoknot   Strong C 1 1 0 0.0 0.0 0.0 0.0 0.99 0.99 1.94 1.93 0.01 0.65 118
54 54 16S 2 19 916   v4 A:U cWW   3°: pseudoknot   Strong C 5 2 1 0.29 0.0 0.0 0.0 0.92 0.92 1.4 1.93 0.0 0.64 117
61 61 16S 3 27 556   v4 G:C cWW       Strong C 0 1 0 0.0 0.67 0.99 1.66 0.99 1.0 1.89 1.87 0.0 0.72 132
68 68 16S 3 28 555   v4 A:U cWW       Strong C 5 6 2 0.36 0.62 0.98 1.6 0.98 0.99 1.68 1.61 0.0 0.73 133
75 75 16S 3 29 554   v4 U:A cWW       Strong C 3 1 1 0.5 0.22 0.95 1.17 0.95 0.98 1.61 1.91 0.0 0.74 134
82 82 16S 3 30 553   v4 U:A cWW       Strong C 4 3 1 0.29 0.5 0.96 1.46 0.96 0.97 1.49 1.68 0.0 0.74 134
89 89 16S 3 32 552   v4 A:U cWW       Strong C 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.74 135
96 96 16S 3 33 551   v4 A:U cWW       Strong C 1 0 0 0.0 0.67 0.99 1.66 0.99 0.99 1.83 1.91 0.0 0.74 135
103 103 16S 3 34 550   v4 C:G cWW       Strong C 1 1 0 0.0 0.0 0.0 0.0 0.98 0.99 1.94 1.95 0.0 0.75 136
110 110 16S 3 35 549   v4 G:C cWW       Weak C 0 6 0 0.0 0.0 0.0 0.0 0.87 1.0 2.0 1.43 0.0 0.75 136
117 117 16S 3 36 548   v4 C:G cWW       Strong C 1 0 0 0.0 0.0 0.0 0.0 0.99 0.99 1.95 2.0 0.0 0.83 152
131 131 16S 4 39 403   v4 G:C cWW       Weak C 1 3 1 0.5 0.33 0.99 1.32 0.99 0.99 1.89 1.81 0.0 0.85 154
138 138 16S 4 40 402   v4 C:G cWW       Strong C 3 5 2 0.5 0.33 0.97 1.31 0.98 0.98 1.73 1.74 0.0 0.85 155
145 145 16S 4 41 401   v4 G:C cWW       Strong C 5 5 4 0.8 0.64 0.97 1.61 0.97 0.98 1.61 1.67 0.0 0.85 154
152 152 16S 4 42 400   v4 G:C cWW       Strong C 3 4 2 0.57 0.62 0.98 1.61 0.98 0.99 1.71 1.7 0.0 0.85 155
159 159 16S 4 43 399   v4 C:G cWW       Strong C 9 9 7 0.78 0.95 0.98 1.94 0.98 0.99 0.93 0.98 0.0 0.86 156
166 166 16S 4 44 398   v4 A:U cWW       Strong C 5 4 2 0.44 0.79 0.98 1.77 0.98 0.98 1.53 1.58 0.0 0.86 156
173 173 16S 4 45 396   v4 G:C cWW       Strong C 2 5 2 0.57 0.1 0.0 0.1 0.94 1.0 1.95 1.62 0.0 0.86 156
180 180 16S 4 46 395   v4 G:C cWW       Strong C 2 4 2 0.67 0.75 0.99 1.74 0.99 0.99 1.86 1.78 0.0 0.86 156
187 187 16S 5 47 361   v4 C:G cWW   3°: base pair   Strong C 1 1 0 0.0 0.0 0.0 0.0 0.97 0.97 1.88 1.85 0.01 0.85 156
194 194 16S 5 52 359   v4 C:G cWW       Strong C 2 3 2 0.8 0.8 0.99 1.79 0.99 0.99 1.83 1.74 0.01 0.85 156
201 201 16S 5 53 358   v4 A:U cWW       Strong C 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.87 158
208 208 16S 5 54 357   v4 C:G cWW       Weak C 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.87 158
215 215 16S 5 56 356   v4 U:A cWW       Weak C 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.87 158
222 222 16S 5 57 355   v4 G:C cWW       Strong C 1 0 0 0.0 0.0 0.0 0.0 0.99 0.99 1.95 2.0 0.0 0.86 157
229 229 16S 5 58 354   v4 C:G cWW       Weak C 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.87 158
236 236 16S 6 61 106   v4 G:C cWW       Strong C 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.83 1.84 0.0 0.89 162
243 243 16S 6 62 105   v4 U:G cWW       Weak C 0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 2.0 1.94 0.01 0.89 162
250 250 16S 6 63 104   v4 C:G cWW       Strong C 9 8 4 0.47 0.48 0.93 1.4 0.93 0.99 1.43 1.6 0.0 0.89 162
257 257 16S 6 66 103   v4 A:U cWW       Strong C 1 1 1 1.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.9 163
264 264 16S 6 67 102   v4 C:G cWW       Strong C 2 4 1 0.33 0.57 0.98 1.55 0.98 0.98 1.78 1.69 0.0 0.9 163
271 271 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak C 4 5 1 0.22 0.08 0.0 0.08 0.05 0.06 1.78 1.65 0.0 0.9 164
278 278 16S 6 69 99   v4 G:C cWW       Strong C 20 20 5 0.25 0.46 0.63 1.09 0.63 0.75 0.59 0.31 0.0 0.9 164
285 285 16S 6 70 98   v4 U:A cWW       Strong C 18 18 7 0.39 0.61 0.76 1.36 0.76 0.91 0.52 0.41 0.01 0.87 163
292 292 16S 6 73 97   v4 C:G cWW       Strong C 2 2 0 0.0 0.27 0.45 0.72 0.45 0.55 -0.51 -0.49 0.02 0.11 164
299 299 16S 6 74 96   v4 A:U cWW       Strong C 4 1 0 0.0 0.44 0.57 1.01 0.29 0.33 -0.53 -0.52 0.02 0.12 164
306 306 16S 6 75 95   v4 G:C cWW       Strong C 4 3 0 0.0 0.5 0.65 1.15 0.56 0.61 -0.65 -0.57 0.06 0.13 164
313 313 16S 6 76 93   v4 G:U cWW       Strong C 9 9 5 0.56 0.67 0.81 1.47 0.81 0.88 -0.8 -0.83 0.03 0.31 164
320 320 16S 6 77 92   v4 A:U cWW       Strong C 9 9 6 0.67 0.78 0.89 1.67 0.89 0.95 -0.8 -0.74 0.03 0.34 164
327 327 16S 6 78 91   v4 A:U cWW       Strong C 7 8 4 0.53 0.47 0.7 1.18 0.69 0.94 -0.85 -0.84 0.02 0.37 165
334 334 16S 6 79 90   v4 G:C cWW       Strong C 15 14 7 0.48 0.73 0.87 1.6 0.87 0.96 -0.81 -0.69 0.02 0.55 165
341 341 16S 6 80 89   v4 A:U cWW       Strong C 17 18 16 0.91 0.89 0.95 1.84 0.95 0.97 0.0 -0.08 0.02 0.86 165
348 348 16S 6 81 88   v4 A:U cWW       Strong C 20 17 9 0.49 0.65 0.77 1.41 0.77 0.98 0.03 0.04 0.0 0.89 165
355 355 16S 6 82 87   v4 G:C cWW       Strong C 20 21 15 0.73 0.6 0.72 1.33 0.72 0.98 0.05 0.04 0.01 0.89 165
362 362 16S 6.1 113 314   v4 G:C cWW       Strong C 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.95 1.95 0.0 0.9 164
369 369 16S 6.1 114 313   v4 U:A cWW       Strong C 1 0 0 0.0 0.0 0.0 0.0 0.99 0.99 1.95 2.0 0.0 0.9 164
376 376 16S 6.1 115 312   v4 G:C cWW       Strong C 1 0 0 0.0 0.0 0.0 0.0 0.99 0.99 1.95 2.0 0.0 0.9 164
383 383 16S 7 122 239   v4 G:U cWW       Strong C 12 11 3 0.26 0.3 0.69 1.0 0.19 0.75 1.01 0.87 0.01 0.92 168
390 390 16S 7 123 238   v4 U:A cWW       Strong C 5 4 4 0.89 1.0 1.0 2.0 1.0 1.0 1.58 1.56 0.01 0.91 167
397 397 16S 7 124 237   v4 C:G cWW       Strong C 7 6 6 0.92 1.0 1.0 2.0 1.0 1.0 1.62 1.56 0.01 0.91 167
404 404 16S 7 125 236   v4 U:A cWW       Strong C 0 8 0 0.0 0.0 0.0 0.0 0.12 1.0 2.0 1.38 0.01 0.9 166
411 411 16S 7 126 235   v4 G:C cWW       Strong C 6 9 4 0.53 0.58 0.79 1.37 0.79 0.81 1.1 0.94 0.01 0.91 167
418 418 16S 7 127 234   v4 G:C cWW       Strong C 4 3 3 0.86 0.67 0.99 1.66 0.99 1.0 1.87 1.84 0.01 0.91 167
425 425 16S 7 128 233   v4 G:C cWW       Strong C 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.87 1.75 0.01 0.91 167
432 432 16S 7 129 232   v4 A:G cWW   3°: base pair   Strong C 6 6 1 0.17 0.07 0.0 0.07 0.05 0.07 1.75 1.57 0.01 0.91 167
439 439 16S 7 131 231   v4 A:U cWW       Strong C 7 7 7 1.0 0.99 0.99 1.98 0.99 0.99 0.95 0.94 0.01 0.91 166
446 446 16S 7 132 230   v4 C:G cWW       Strong C 12 9 7 0.67 0.85 0.98 1.82 0.98 0.99 1.27 1.27 0.01 0.91 166
453 453 16S 7 136 227   v4 C:G cWW       Strong C 8 9 7 0.82 0.7 0.96 1.66 0.96 0.97 1.34 1.34 0.0 0.92 167
460 460 16S 7 137 226   v4 U:G cWW       Strong C 10 9 8 0.84 0.93 0.97 1.9 0.97 0.97 0.93 0.91 0.0 0.92 167
467 467 16S 7 138 225   v4 G:C cWW       Strong C 11 17 6 0.43 0.31 0.79 1.1 0.79 0.96 1.4 0.92 0.0 0.92 167
474 474 16S 7 139 224   v4 A:U cWW       Strong C 8 13 5 0.48 0.16 0.0 0.16 0.72 0.96 1.43 0.91 0.0 0.92 167
481 481 16S 7 140 223   v4 U:A cWW       Strong C 14 16 11 0.73 0.85 0.91 1.76 0.91 0.97 0.2 0.32 0.01 0.91 167
488 488 16S 7 141 222   v4 G:C cWW       Strong C 5 5 5 1.0 0.8 0.99 1.79 0.99 0.99 1.63 1.62 0.0 0.92 167
495 495 16S 7 142 221   v4 G:C cWW       Strong C 5 6 5 0.91 0.69 0.98 1.67 0.98 0.99 1.54 1.57 0.0 0.92 167
502 502 16S 8 144 178   v4 G:C cWW       Strong C 11 13 10 0.83 0.71 0.94 1.65 0.94 0.96 0.89 0.88 0.02 0.9 168
509 509 16S 8 145 177   v4 G:G cWW   3°: base pair   Strong C 9 16 7 0.56 0.71 0.93 1.64 0.93 0.94 1.09 0.91 0.02 0.9 168
516 516 16S 8 146 176   v4 G:C cWW       Strong C 8 8 7 0.88 0.87 0.98 1.84 0.98 0.99 1.14 1.2 0.01 0.91 168
523 523 16S 8 147 175   v4 G:C cWW       Strong C 3 3 0 0.0 0.33 0.96 1.3 0.97 0.98 1.66 1.58 0.0 0.92 168
537 537 16S 8 153 168   v4 C:G cWW       Strong C 3 3 2 0.67 0.11 0.0 0.11 0.95 0.97 1.56 1.51 0.02 0.9 168
544 544 16S 8 154 167   v4 U:A cWW       Strong C 14 15 7 0.48 0.64 0.91 1.55 0.91 0.92 0.83 0.99 0.01 0.91 168
551 551 16S 8 155 166   v4 A:U cWW       Strong C 19 22 7 0.34 0.57 0.76 1.33 0.76 0.9 0.44 0.47 0.01 0.9 166
558 558 16S 8 156 165   v4 C:G cWW       Strong C 19 18 11 0.59 0.73 0.89 1.61 0.89 0.95 0.59 0.72 0.0 0.91 167
565 565 16S 8 157 164   v4 U:G cWW       Strong C 9 12 5 0.48 0.31 0.85 1.16 0.15 0.99 1.17 0.96 0.0 0.92 168
572 572 16S 8 158 163   v4 G:C cWW       Strong C 8 9 6 0.71 0.69 0.97 1.66 0.97 0.98 1.4 1.38 0.0 0.92 168
579 579 16S 9 184 193   v4 G:C cWW       Strong C 6 5 0 0.0 0.1 0.0 0.1 0.46 0.99 1.17 0.69 0.0 0.92 169
586 586 16S 9 185 192   v4 U:A cWW       Strong C 6 6 6 1.0 0.87 0.99 1.85 0.99 0.99 1.39 1.39 0.0 0.92 169
593 593 16S 9 186 191   v4 C:G cWW       Strong C 9 9 7 0.78 0.74 0.94 1.68 0.94 0.99 1.09 0.99 0.0 0.91 168
600 600 16S 10 198 219   v4 G:U cWW       Strong C 17 19 8 0.44 0.66 0.88 1.54 0.88 0.94 0.64 0.48 0.01 0.9 169
607 607 16S 10 199 218   v4 A:U cWW       Strong C 10 11 5 0.48 0.8 0.93 1.73 0.93 0.97 0.75 0.7 0.01 0.9 169
614 614 16S 10 200 217   v4 G:C cWW       Strong C 12 10 7 0.64 0.74 0.93 1.67 0.93 0.94 0.07 0.17 0.02 0.78 169
621 621 16S 10 201 216   v4 G:U cWW       Strong C 3 2 0 0.0 0.67 0.77 1.43 0.77 0.9 -0.62 -0.68 0.01 0.17 169
628 628 16S 10 202 215   v4 G:C cWW       Strong C 1 3 1 0.5 0.01 0.0 0.01 0.08 0.09 -0.33 -0.41 0.0 0.0 169
635 635 16S 10 203 214   v4 G:C cWW       Strong C 2 1 0 0.0 0.03 0.0 0.03 0.05 0.06 -0.37 -0.36 0.0 0.0 169
642 642 16S 10 206 213   v4 C:G cWW       Strong C 0 0 0 0.0 0.01 0.0 0.01 0.03 0.03 -0.17 -0.29 0.0 0.0 169
649 649 16S 10 207 212   v4 C:G cWW       Strong C 1 1 1 1.0 0.01 0.0 0.01 0.03 0.03 -0.19 -0.25 0.0 0.0 169
656 656 16S 11 240 286   v4 G:C cWW       Strong C 2 3 2 0.8 0.67 0.99 1.66 0.99 0.99 1.84 1.81 0.01 0.92 169
663 663 16S 11 241 285   v4 G:C cWW       Strong C 3 2 2 0.8 0.67 0.99 1.66 0.99 0.99 1.79 1.87 0.01 0.92 169
670 670 16S 11 242 284   v4 G:C cWW       Strong C 2 2 2 1.0 0.75 0.99 1.74 0.99 0.99 1.81 1.82 0.01 0.92 169
677 677 16S 11 245 283   v4 U:U cWW   3°: base pair   Strong C 1 0 0 0.0 0.0 0.0 0.0 0.0 0.01 1.95 1.95 0.0 0.93 170
684 684 16S 11 247 277   v4 G:C cWW       Strong C 1 2 0 0.0 0.2 0.0 0.2 0.98 1.0 1.95 1.81 0.0 0.93 170
691 691 16S 11 248 276   v4 C:G cWW       Strong C 5 3 3 0.75 0.62 0.98 1.61 0.98 1.0 1.73 1.81 0.0 0.93 170
698 698 16S 11 249 275   v4 U:G cWW       Strong C 1 1 1 1.0 1.0 1.0 2.0 0.0 0.98 1.84 1.84 0.0 0.93 170
705 705 16S 11 252 274   v4 U:A cWW       Strong C 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.84 1.84 0.0 0.93 170
712 712 16S 11 253 273   v4 A:U cWW       Strong C 1 2 1 0.67 0.0 0.0 0.0 0.99 1.0 2.0 1.95 0.0 0.93 170
719 719 16S 11 254 272   v4 G:C cWW       Strong C 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.91 1.91 0.0 0.93 170

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "basepair_collective_score" (
   "molecule" TEXT,
   "helix_number" TEXT,
   "position_1" INTEGER,
   "position_2" INTEGER,
   "pair_note" TEXT,
   "header_format" TEXT,
   "reference_base_pair" TEXT,
   "conformation" TEXT,
   "ai_code" TEXT,
   "tertiary_type" TEXT,
   "header_extra" TEXT,
   "strength" TEXT,
   "group_code" TEXT,
   "Xch" INTEGER,
   "Ych" INTEGER,
   "PE" INTEGER,
   "PES" REAL,
   "Cov1" REAL,
   "Cov3" REAL,
   "C1+C3" REAL,
   "WC" REAL,
   "WCGU" REAL,
   "XCons" REAL,
   "YCons" REAL,
   "DfDel" REAL,
   "PNuc" REAL,
   "Seq" INTEGER
);
CREATE INDEX "idx_basepair_collective_score_molecule_position_1_position_2"
    ON "basepair_collective_score" ("molecule", "position_1", "position_2");