Base-pair collective (covariation) scores

47 rows where group_code = "M", molecule = "16S" and strength = "Weak" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: helix_number, reference_base_pair, Xch, Ych, PE, Cov1, Cov3, C1+C3, WC, WCGU, DfDel, PNuc

conformation 4

strength 1

  • Weak · 47 ✖

molecule 1

  • 16S · 47 ✖

group_code 1

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
35 35 16S 1 13 21   v4 U:G No BP       Weak M 10 59 2 0.06 0.16 0.0 0.16 0.51 0.9 1.4 0.89 0.0 0.57 669
112 112 16S 3 35 549   v4 G:C cWW       Weak M 61 55 16 0.28 0.19 0.0 0.19 0.45 0.9 0.77 1.11 0.0 0.63 733
126 126 16S 3 37 547   v4 U:A tWS       Weak M 27 15 5 0.24 0.09 0.0 0.09 0.92 0.93 1.48 1.78 0.0 0.63 738
133 133 16S 4 39 403   v4 G:C cWW       Weak M 70 60 21 0.32 0.49 0.84 1.33 0.84 0.86 0.76 0.62 0.0 0.64 747
210 210 16S 5 54 357   v4 C:G cWW       Weak M 6 4 1 0.2 0.04 0.0 0.04 0.97 0.99 1.74 1.91 0.0 0.68 791
217 217 16S 5 56 356   v4 U:A cWW       Weak M 2 2 1 0.5 0.0 0.0 0.0 0.99 0.99 1.89 1.91 0.0 0.68 793
231 231 16S 5 58 354   v4 C:G cWW       Weak M 7 5 1 0.17 0.26 0.98 1.24 0.98 0.99 1.69 1.82 0.0 0.71 827
245 245 16S 6 62 105   v4 U:G cWW       Weak M 56 47 16 0.31 0.32 0.81 1.13 0.12 0.83 0.51 0.67 0.04 0.68 827
273 273 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak M 8 13 7 0.67 0.01 0.0 0.01 0.02 0.04 -0.33 -0.42 0.0 0.0 830
784 784 16S 12 292 308   v4 G:C cWW       Weak M 4 4 4 1.0 0.01 0.0 0.01 0.1 0.11 -0.31 -0.37 0.0 0.0 871
882 882 16S 14 342 347   v4 C:G cWW       Weak M 27 11 7 0.37 0.17 0.0 0.17 0.81 0.83 0.51 1.02 0.02 0.65 831
917 917 16S 15 375 388   v4 U:G No BP       Weak M 7 8 3 0.4 0.09 0.0 0.09 0.06 0.99 1.82 0.84 0.11 0.71 829
952 952 16S 16 406 436   v4 G:C cWW       Weak M 23 6 3 0.21 0.05 0.0 0.05 0.1 0.11 -0.75 -0.43 0.0 0.0 833
980 980 16S 16 416 427   v4 G:U cWW       Weak M 11 7 4 0.44 0.03 0.0 0.03 0.07 0.1 -0.46 -0.42 0.0 0.0 835
1001 1001 16S 16 419 424   v4 C:G cWW       Weak M 7 3 2 0.4 0.04 0.0 0.04 0.07 0.08 -0.42 -0.41 0.0 0.0 835
1260 1260 16S 19.1 571 865   v4 U:A cWW   3°: pseudoknot   Weak M 13 15 2 0.14 0.52 0.97 1.49 0.97 0.99 1.63 1.55 0.01 0.75 881
1309 1309 16S 20 584 757   v4 G:U cWW       Weak M 69 62 11 0.17 0.14 0.0 0.14 0.58 0.73 -0.24 0.71 0.11 0.73 883
1372 1372 16S 21 594 645   v4 U:G cWW       Weak M 12 13 7 0.56 0.02 0.0 0.02 0.03 0.03 -0.41 -0.38 0.0 0.0 1021
1386 1386 16S 21 597 643   v4 G:C cWW       Weak M 7 10 2 0.23 0.01 0.0 0.01 0.04 0.04 -0.34 -0.32 0.0 0.0 1021
1442 1442 16S 21 605 633   v4 U:G cWW       Weak M 8 7 3 0.4 0.01 0.0 0.01 0.01 0.04 -0.24 -0.24 0.0 0.0 1021
1449 1449 16S 21 606 632   v4 G:U No BP       Weak M 7 5 1 0.17 0.01 0.0 0.01 0.01 0.03 -0.25 -0.23 0.0 0.0 1021
1526 1526 16S 22 658 748   v4 C:G cWW       Weak M 70 45 10 0.17 0.43 0.65 1.09 0.45 0.61 -0.69 -0.81 0.08 0.35 896
1568 1568 16S 22 666 740   v4 G:U cWW       Weak M 45 76 11 0.18 0.31 0.46 0.77 0.38 0.42 0.24 -0.61 0.12 0.61 897
1631 1631 16S 23 677 713   v4 U:G cWW       Weak M 82 96 21 0.24 0.16 0.0 0.16 0.24 0.34 0.18 -0.05 0.03 0.74 901
1680 1680 16S 23 684 706   v4 U:A cWW       Weak M 67 78 21 0.29 0.3 0.61 0.9 0.61 0.67 0.64 0.17 0.01 0.77 901
1701 1701 16S 23 690 697   v4 G:U tSH       Weak M 78 27 7 0.13 0.3 0.54 0.84 0.4 0.54 0.43 0.43 0.0 0.77 901
1876 1876 16S 26 832 854   v4 G:U cWW       Weak M 12 11 5 0.43 0.03 0.0 0.03 0.05 0.08 -0.4 -0.37 0.0 0.0 1099
1939 1939 16S 26.1 861 868   v4 G:C cWW       Weak M 98 61 10 0.13 0.18 0.0 0.18 0.35 0.36 -0.79 -0.02 0.18 0.6 1096
2030 2030 16S 28 925 1391   v4 G:U cWW       Weak M 7 24 1 0.07 0.14 0.0 0.14 0.71 0.99 1.71 0.84 0.0 0.78 899
2086 2086 16S 28 935 1380   v4 A:U cWW       Weak M 12 18 3 0.2 0.45 0.94 1.39 0.94 0.94 1.47 1.32 0.0 0.83 970
2121 2121 16S 29 942 1341   v4 G:U cWW       Weak M 4 3 0 0.0 0.27 0.99 1.27 0.01 1.0 1.93 1.95 0.0 0.97 1129
2177 2177 16S 30 950 1231   v4 U:G cWW       Weak M 5 11 0 0.0 0.16 0.0 0.16 0.01 0.99 1.94 1.89 0.0 0.99 1152
2219 2219 16S 31 960 975   v4 U:A No BP       Weak M 9 16 1 0.08 0.61 0.96 1.56 0.96 0.96 1.53 1.43 0.0 0.99 1153
2226 2226 16S 31 961 974   v4 U:A No BP       Weak M 43 61 4 0.08 0.28 0.67 0.96 0.56 0.56 1.14 0.69 0.0 0.99 1151
2457 2457 16S 34 1052 1206   v4 U:G cWW       Weak M 15 6 0 0.0 0.77 0.96 1.73 0.04 0.84 1.36 1.23 0.0 0.99 1152
2464 2464 16S 34 1053 1205   v4 G:U No BP       Weak M 5 6 0 0.0 0.06 0.0 0.06 0.92 0.99 1.55 1.9 0.0 0.99 1152
2485 2485 16S 34 1058 1199   v4 G:U cWW       Weak M 14 10 2 0.17 0.03 0.0 0.03 0.08 0.84 1.1 1.71 0.0 0.99 1150
2737 2737 16S 40 1158 1178   v4 C:G No BP       Weak M 5 145 3 0.04 0.03 0.0 0.03 0.05 0.05 -0.32 0.02 0.0 0.0 1152
2744 2744 16S 40 1159 1177   v4 U:G No BP       Weak M 8 148 4 0.05 0.02 0.0 0.02 0.01 0.03 -0.32 0.0 0.0 0.0 1152
2856 2856 16S 41 1255 1282   v4 G:C cWW       Weak M 6 4 1 0.2 0.01 0.0 0.01 0.06 0.07 -0.31 -0.32 0.0 0.0 1154
3024 3024 16S 44 1401 1501   v4 G:C cWW       Weak M 4 3 1 0.29 0.9 0.99 1.9 0.99 0.99 1.65 1.65 0.0 0.68 791
3157 3157 16S 44 1425 1475   v4 U:G cWW       Weak M 8 10 6 0.67 0.01 0.0 0.01 0.04 0.07 -0.4 -0.44 0.0 0.0 849
3199 3199 16S 44 1435 1466   v4 G:C cWW       Weak M 11 9 4 0.4 0.01 0.0 0.01 0.01 0.02 -0.27 -0.28 0.0 0.0 849
3241 3241 16S 44 1442 1460   v4 G:C cWW       Weak M 9 6 5 0.67 0.01 0.0 0.01 0.03 0.04 -0.25 -0.24 0.0 0.0 849
3283 3283 16S 45 1506 1529   v4 U:G No BP       Weak M 1 10 0 0.0 0.0 0.0 0.0 0.16 0.99 1.99 1.27 0.0 0.58 672
3318 3318 16S 45 1511 1524   v4 G:C cWW       Weak M 27 45 10 0.28 0.63 0.83 1.45 0.83 0.98 0.83 0.75 0.0 0.58 674
3325 3325 16S 45 1512 1523   v4 U:G cWW       Weak M 12 5 2 0.23 0.14 0.0 0.14 0.03 0.99 1.76 1.89 0.0 0.58 675

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