Base-pair collective (covariation) scores

3,220 rows where conformation = "cWW" and molecule = "16S" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: reference_base_pair, tertiary_type, DfDel

group_code 7

  • 3 460
  • A 460
  • B 460
  • C 460
  • E 460
  • M 460
  • T 460

strength 4

molecule 1

  • 16S · 3,220 ✖

conformation 1

  • cWW · 3,220 ✖
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
1 1 16S 1 9 25   v4 G:C cWW       Strong T 32 27 12 0.41 0.94 0.97 1.91 0.97 0.98 0.52 0.64 0.0 0.43 3661
2 2 16S 1 9 25   v4 G:C cWW       Strong 3 16 9 3 0.24 0.94 0.98 1.92 0.98 0.99 0.93 1.03 0.0 0.4 2878
3 3 16S 1 9 25   v4 G:C cWW       Strong B 13 7 1 0.1 0.02 0.0 0.02 0.97 0.98 1.86 1.85 0.0 0.33 1946
4 4 16S 1 9 25   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.99 1.0 1.94 2.0 0.0 0.56 148
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
6 6 16S 1 9 25   v4 G:C cWW       Strong E 3 2 2 0.8 0.14 0.0 0.14 0.99 0.99 1.73 1.95 0.02 0.73 784
7 7 16S 1 9 25   v4 G:C cWW       Strong M 14 18 9 0.56 0.69 0.95 1.65 0.95 0.96 1.3 1.28 0.0 0.57 662
8 8 16S 1 10 24   v4 A:U cWW       Strong T 33 22 8 0.29 0.93 0.97 1.9 0.97 0.99 0.44 0.56 0.0 0.44 3741
9 9 16S 1 10 24   v4 A:U cWW       Strong 3 20 12 5 0.31 0.92 0.97 1.89 0.97 0.99 0.76 0.96 0.0 0.41 2956
10 10 16S 1 10 24   v4 A:U cWW       Strong B 14 8 1 0.09 0.01 0.0 0.01 0.96 0.99 1.73 1.9 0.0 0.34 2016
11 11 16S 1 10 24   v4 A:U cWW       Strong A 3 2 2 0.8 0.97 0.99 1.97 0.99 1.0 1.17 1.21 0.0 0.56 147
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
13 13 16S 1 10 24   v4 A:U cWW       Strong E 3 2 2 0.8 0.9 0.99 1.9 0.99 0.99 1.5 1.63 0.01 0.74 793
14 14 16S 1 10 24   v4 A:U cWW       Strong M 13 10 3 0.26 0.78 0.96 1.74 0.96 0.98 1.26 1.26 0.0 0.57 663
15 15 16S 1 11 23   v4 G:C cWW       Strong T 23 16 10 0.51 0.26 0.96 1.21 0.96 0.96 1.61 1.84 0.0 0.45 3799
16 16 16S 1 11 23   v4 G:C cWW       Strong 3 7 4 1 0.18 0.23 1.0 1.23 1.0 1.0 1.91 1.95 0.0 0.42 3010
17 17 16S 1 11 23   v4 G:C cWW       Strong B 6 4 1 0.2 0.27 0.99 1.26 0.99 0.99 1.91 1.94 0.0 0.35 2053
18 18 16S 1 11 23   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.57 151
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
20 20 16S 1 11 23   v4 G:C cWW       Strong E 1 0 0 0.0 0.0 0.0 0.0 1.0 1.0 1.89 1.99 0.01 0.76 806
21 21 16S 1 11 23   v4 G:C cWW       Strong M 15 12 9 0.67 0.26 0.77 1.03 0.77 0.78 0.91 1.45 0.0 0.57 666
22 22 16S 1 12 22   v4 U:G cWW       Strong T 35 31 9 0.27 0.89 0.97 1.86 0.25 0.93 0.79 0.88 0.0 0.46 3888
23 23 16S 1 12 22   v4 U:G cWW       Strong 3 11 13 6 0.5 0.93 0.98 1.91 0.3 0.98 0.95 1.07 0.0 0.43 3095
24 24 16S 1 12 22   v4 U:G cWW       Strong B 6 6 1 0.17 0.08 0.0 0.08 0.01 0.99 1.88 1.91 0.0 0.36 2131
25 25 16S 1 12 22   v4 U:G cWW       Strong A 2 3 2 0.8 0.86 0.99 1.84 0.91 0.99 1.57 1.53 0.0 0.56 149
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
27 27 16S 1 12 22   v4 U:G cWW       Strong E 3 4 3 0.86 0.11 0.0 0.11 0.95 0.95 1.63 1.91 0.0 0.77 815
28 28 16S 1 12 22   v4 U:G cWW       Strong M 23 18 3 0.15 0.75 0.91 1.66 0.07 0.69 0.97 0.99 0.0 0.57 669
36 36 16S 2 17 918   v4 U:A cWW   3°: pseudoknot   Strong T 13 16 7 0.48 0.15 0.0 0.15 0.99 0.99 1.92 1.9 0.0 0.46 3912
37 37 16S 2 17 918   v4 U:A cWW   3°: pseudoknot   Strong 3 3 6 1 0.22 0.05 0.0 0.05 0.99 0.99 1.94 1.92 0.0 0.43 3123
38 38 16S 2 17 918   v4 U:A cWW   3°: pseudoknot   Strong B 1 3 0 0.0 0.07 0.0 0.07 0.99 0.99 1.95 1.96 0.0 0.37 2163
39 39 16S 2 17 918   v4 U:A cWW   3°: pseudoknot   Strong A 0 1 0 0.0 0.0 0.0 0.0 0.99 1.0 2.0 1.93 0.0 0.56 148
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
41 41 16S 2 17 918   v4 U:A cWW   3°: pseudoknot   Strong E 2 2 1 0.5 0.04 0.0 0.04 0.97 0.99 1.91 1.81 0.0 0.77 812
42 42 16S 2 17 918   v4 U:A cWW   3°: pseudoknot   Strong M 10 10 6 0.6 0.38 0.98 1.36 0.98 0.99 1.82 1.83 0.0 0.58 672
43 43 16S 2 18 917   v4 C:G cWW   3°: pseudoknot   Strong T 44 41 21 0.49 0.62 0.97 1.6 0.97 0.98 1.62 1.59 0.0 0.46 3930
44 44 16S 2 18 917   v4 C:G cWW   3°: pseudoknot   Strong 3 27 23 11 0.44 0.56 0.97 1.53 0.97 0.98 1.68 1.66 0.0 0.44 3137
45 45 16S 2 18 917   v4 C:G cWW   3°: pseudoknot   Strong B 24 18 10 0.48 0.64 0.98 1.62 0.98 0.99 1.7 1.75 0.0 0.37 2163
46 46 16S 2 18 917   v4 C:G cWW   3°: pseudoknot   Strong A 1 0 0 0.0 0.0 0.0 0.0 0.99 1.0 1.94 1.96 0.0 0.56 149
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
48 48 16S 2 18 917   v4 C:G cWW   3°: pseudoknot   Strong E 2 5 1 0.29 0.5 0.93 1.43 0.93 0.93 1.58 1.34 0.0 0.78 825
49 49 16S 2 18 917   v4 C:G cWW   3°: pseudoknot   Strong M 16 17 10 0.61 0.86 0.99 1.85 0.99 0.99 1.39 1.35 0.0 0.58 675
50 50 16S 2 19 916   v4 A:U cWW   3°: pseudoknot   Strong T 49 31 7 0.17 0.71 0.96 1.67 0.96 0.96 1.38 1.41 0.0 0.46 3959
51 51 16S 2 19 916   v4 A:U cWW   3°: pseudoknot   Strong 3 32 16 1 0.04 0.72 0.96 1.68 0.96 0.96 1.39 1.41 0.0 0.44 3166
52 52 16S 2 19 916   v4 A:U cWW   3°: pseudoknot   Strong B 32 13 1 0.04 0.72 0.94 1.66 0.94 0.95 1.29 1.34 0.0 0.37 2190
53 53 16S 2 19 916   v4 A:U cWW   3°: pseudoknot   Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 1.96 0.0 0.57 150
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
55 55 16S 2 19 916   v4 A:U cWW   3°: pseudoknot   Strong E 0 3 0 0.0 0.83 0.99 1.83 0.99 0.99 1.82 1.79 0.0 0.78 826
56 56 16S 2 19 916   v4 A:U cWW   3°: pseudoknot   Strong M 12 13 5 0.4 0.75 0.98 1.73 0.98 0.98 1.46 1.52 0.0 0.58 676
57 57 16S 3 27 556   v4 G:C cWW       Strong T 50 80 26 0.4 0.85 0.96 1.81 0.96 0.96 0.83 0.96 0.0 0.52 4476
58 58 16S 3 27 556   v4 G:C cWW       Strong 3 16 13 8 0.55 0.94 0.99 1.93 0.99 0.99 1.09 1.28 0.0 0.51 3638
59 59 16S 3 27 556   v4 G:C cWW       Strong B 3 1 1 0.5 0.0 0.0 0.0 0.99 0.99 1.92 1.98 0.0 0.44 2600
60 60 16S 3 27 556   v4 G:C cWW       Strong A 5 3 2 0.5 0.87 0.95 1.83 0.95 0.95 0.84 1.0 0.0 0.58 155
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
62 62 16S 3 27 556   v4 G:C cWW       Strong E 8 9 5 0.59 0.9 0.97 1.86 0.97 0.97 0.83 0.98 0.0 0.84 883
63 63 16S 3 27 556   v4 G:C cWW       Strong M 34 66 18 0.36 0.71 0.8 1.51 0.8 0.81 0.2 0.04 0.01 0.6 708
64 64 16S 3 28 555   v4 A:U cWW       Strong T 69 103 33 0.38 0.7 0.82 1.53 0.82 0.97 0.51 0.55 0.0 0.58 4977
65 65 16S 3 28 555   v4 A:U cWW       Strong 3 25 29 8 0.3 0.68 0.82 1.5 0.82 0.99 0.89 0.9 0.0 0.57 4137
66 66 16S 3 28 555   v4 A:U cWW       Strong B 12 12 5 0.42 0.97 0.99 1.96 0.99 1.0 0.95 0.97 0.0 0.53 3080
67 67 16S 3 28 555   v4 A:U cWW       Strong A 4 5 2 0.44 0.7 0.87 1.57 0.87 0.99 0.9 0.61 0.01 0.62 168
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
69 69 16S 3 28 555   v4 A:U cWW       Strong E 9 12 1 0.1 0.03 0.0 0.03 0.26 0.98 1.63 1.19 0.0 0.84 889
70 70 16S 3 28 555   v4 A:U cWW       Strong M 39 68 23 0.43 0.61 0.78 1.39 0.78 0.83 0.36 0.21 0.0 0.61 709
71 71 16S 3 29 554   v4 U:A cWW       Strong T 103 125 48 0.42 0.9 0.94 1.84 0.94 0.96 0.39 0.48 0.01 0.59 5079
72 72 16S 3 29 554   v4 U:A cWW       Strong 3 43 48 27 0.59 0.97 0.98 1.95 0.98 0.99 0.43 0.55 0.01 0.58 4239
73 73 16S 3 29 554   v4 U:A cWW       Strong B 28 31 19 0.64 0.97 0.99 1.96 0.99 0.99 0.76 0.79 0.0 0.54 3182
74 74 16S 3 29 554   v4 U:A cWW       Strong A 13 11 6 0.5 0.69 0.87 1.56 0.87 0.97 0.62 1.06 0.01 0.66 177
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
76 76 16S 3 29 554   v4 U:A cWW       Strong E 2 6 2 0.5 0.35 0.99 1.34 0.99 0.99 1.5 1.82 0.04 0.79 880
77 77 16S 3 29 554   v4 U:A cWW       Strong M 57 76 20 0.3 0.46 0.71 1.17 0.71 0.77 0.32 0.25 0.0 0.61 708
78 78 16S 3 30 553   v4 U:A cWW       Strong T 98 108 65 0.63 0.96 0.97 1.93 0.97 0.99 0.14 0.21 0.0 0.6 5157
79 79 16S 3 30 553   v4 U:A cWW       Strong 3 55 60 37 0.64 0.96 0.97 1.93 0.97 0.99 0.35 0.41 0.0 0.6 4314
80 80 16S 3 30 553   v4 U:A cWW       Strong B 41 47 27 0.61 0.95 0.98 1.93 0.98 0.99 0.94 0.96 0.0 0.55 3238
81 81 16S 3 30 553   v4 U:A cWW       Strong A 8 8 6 0.75 0.88 0.94 1.81 0.94 0.99 0.45 0.48 0.0 0.67 178
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
83 83 16S 3 30 553   v4 U:A cWW       Strong E 6 5 4 0.73 0.36 0.98 1.34 0.98 0.99 1.72 1.85 0.01 0.85 898
84 84 16S 3 30 553   v4 U:A cWW       Strong M 39 45 27 0.64 0.93 0.96 1.89 0.96 0.98 0.52 0.58 0.0 0.61 711
85 85 16S 3 32 552   v4 A:U cWW       Strong T 23 28 12 0.47 0.95 0.99 1.94 0.99 0.99 1.0 1.09 0.0 0.61 5253
86 86 16S 3 32 552   v4 A:U cWW       Strong 3 13 14 5 0.37 0.94 0.99 1.92 0.99 0.99 1.15 1.25 0.0 0.61 4408
87 87 16S 3 32 552   v4 A:U cWW       Strong B 6 7 1 0.15 0.14 0.0 0.14 0.99 0.99 1.89 1.92 0.0 0.57 3333
88 88 16S 3 32 552   v4 A:U cWW       Strong A 1 1 1 1.0 0.67 0.99 1.66 0.99 0.99 1.87 1.93 0.0 0.67 178
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
90 90 16S 3 32 552   v4 A:U cWW       Strong E 6 6 3 0.5 0.47 0.97 1.44 0.97 0.97 1.56 1.61 0.01 0.84 897
91 91 16S 3 32 552   v4 A:U cWW       Strong M 10 14 7 0.58 0.89 0.98 1.87 0.98 0.98 1.27 1.33 0.0 0.61 712
92 92 16S 3 33 551   v4 A:U cWW       Strong T 20 22 11 0.52 0.96 0.99 1.96 0.99 1.0 1.17 1.25 0.0 0.62 5282
93 93 16S 3 33 551   v4 A:U cWW       Strong 3 11 10 5 0.48 0.92 1.0 1.92 1.0 1.0 1.65 1.72 0.0 0.62 4439
94 94 16S 3 33 551   v4 A:U cWW       Strong B 4 1 0 0.0 0.0 0.0 0.0 1.0 1.0 1.96 1.97 0.0 0.57 3361
95 95 16S 3 33 551   v4 A:U cWW       Strong A 5 6 3 0.55 0.98 0.99 1.98 0.99 0.99 1.16 1.17 0.0 0.69 183
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
97 97 16S 3 33 551   v4 A:U cWW       Strong E 2 3 2 0.8 0.4 1.0 1.4 1.0 1.0 1.87 1.94 0.01 0.84 895
98 98 16S 3 33 551   v4 A:U cWW       Strong M 8 12 6 0.6 0.94 0.98 1.92 0.98 0.99 0.55 0.62 0.0 0.6 712
99 99 16S 3 34 550   v4 C:G cWW       Strong T 68 55 28 0.46 0.38 0.81 1.19 0.81 0.99 0.74 1.37 0.0 0.63 5366
100 100 16S 3 34 550   v4 C:G cWW       Strong 3 22 12 5 0.29 0.03 0.0 0.03 0.79 0.99 1.18 1.9 0.0 0.63 4520
101 101 16S 3 34 550   v4 C:G cWW       Strong B 8 8 3 0.38 0.29 0.99 1.28 0.99 0.99 1.89 1.92 0.0 0.59 3444
102 102 16S 3 34 550   v4 C:G cWW       Strong A 4 0 0 0.0 0.0 0.0 0.0 0.29 1.0 1.13 2.0 0.0 0.69 183
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
104 104 16S 3 34 550   v4 C:G cWW       Strong E 10 4 2 0.29 0.02 0.0 0.02 0.12 0.99 1.36 1.78 0.01 0.84 893
105 105 16S 3 34 550   v4 C:G cWW       Strong M 45 42 23 0.53 0.74 0.93 1.66 0.93 0.96 0.76 0.91 0.0 0.61 714
106 106 16S 3 35 549   v4 G:C cWW       Weak T 75 71 20 0.27 0.26 0.87 1.13 0.87 0.98 1.57 1.35 0.0 0.63 5420
107 107 16S 3 35 549   v4 G:C cWW       Weak 3 14 10 4 0.33 0.03 0.0 0.03 0.94 0.99 1.89 1.68 0.0 0.63 4555

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");