home / crw2

Base-pair frequencies

predominant_types
Base-pair types shown in bold in the published table (most frequent).
covarying_types
Base-pair types marked * in the published table (involved in a covariation).
header_format
legacy = entry not yet revised to the v4 layout (no type / conformation).

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, GC, CG, AU, GU, UG, AA, AC, AG, CA, CC, CU, GA, GG, UC, UU, gap, covarying_types

conformation 4

  • cWW 36
  • No BP 9
  • tSH 1
  • tWS 1

tertiary_type 2

  • 3°: base pair 1
  • 3°: pseudoknot 1

strength 1

  • Weak · 47 ✖

molecule 1

  • 16S · 47 ✖

header_format 1

  • v4 47

group_code 1

  • M · 47 ✖
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 GC CG UA AU GU UG AA AC AG CA CC CU GA GG UC UU gap Seq predominant_types covarying_types
203 203 16S 1 13 21   v4 U:G No BP       Weak M     50.2 0.1   38.6 0.4   8.1 0.7     0.4 0.1   0.6 0.6 669 UA,UG,AG UA,AG
280 280 16S 3 35 549   v4 G:C cWW       Weak M 12.1 0.4 1.8 31.0 44.2   0.3 8.2   0.4 0.1     0.1 0.5 0.5 0.3 733 GC,AU,GU,AC CG,UA,GU,AC
294 294 16S 3 37 547   v4 U:A tWS       Weak M 0.1 0.1 90.8 0.5   0.5 0.5   0.3 5.3   0.1 0.5   0.1 0.4 0.5 738 UA,CA GC,CG,UA,AU
301 301 16S 4 39 403   v4 G:C cWW       Weak M 8.0 1.3 67.2 6.3 0.8 1.1 1.1 0.4 0.1 4.6 0.8 0.8 0.1 0.1 0.7 5.5 1.1 747 GC,UA,AU,CA,UU GC,CG,UA,AU
378 378 16S 5 54 357   v4 C:G cWW       Weak M   96.6 0.1     2.1 0.1   0.3     0.1         0.6 791 CG,UG CG,AA
385 385 16S 5 56 356   v4 U:A cWW       Weak M     98.6     0.3       0.5             0.6 793 UA  
399 399 16S 5 58 354   v4 C:G cWW       Weak M 0.4 96.1 0.2 0.2   1.6 0.1   0.4         0.1   0.2 0.6 827 CG GC,CG,UA,AU
413 413 16S 6 62 105   v4 U:G cWW       Weak M 1.0 4.7 4.0 1.3   68.2 0.5 1.8 1.0 6.8 3.9 0.1     0.8 1.0 4.7 827 CG,UA,UG,CA,CC UG,AC,CA
441 441 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak M 1.2   0.4 0.7 1.2       0.1       6.9 0.1   0.1 89.2 830 GA AU,GA
952 952 16S 12 292 308   v4 G:C cWW       Weak M 9.6   0.2 0.6   0.2                     89.2 871 GC GC,UA,AU
1050 1050 16S 14 342 347   v4 C:G cWW       Weak M 0.2 69.7 2.8 0.5   1.7 0.4 0.1 14.1     0.1 0.1   0.1 0.4 9.8 831 CG,UA,AG GC,CG,UA,AU
1085 1085 16S 15 375 388   v4 U:G No BP       Weak M 0.2 0.4 5.1     92.9 0.4   0.1         0.2   0.1 0.6 829 UA,UG GC,UG,AA
1120 1120 16S 16 406 436   v4 G:C cWW       Weak M 4.4 0.2 0.4 4.6 1.2               0.2       88.9 833 GC,AU GC,CG,UA,AU
1148 1148 16S 16 416 427   v4 G:U cWW       Weak M 0.4 0.1 3.6 2.5 2.9 0.1 0.2   0.2     0.2         89.6 835 UA,AU,GU UA,GU,AG
1169 1169 16S 16 419 424   v4 C:G cWW       Weak M   2.4 3.0 1.9 0.1 0.6 0.5   0.5   0.1         0.1 90.7 835 CG,UA CG,UA,AU
1428 1428 16S 19.1 571 865   v4 U:A cWW   3°: pseudoknot   Weak M   2.3 93.0 0.7 0.6 0.8 0.7     0.1   0.1 0.1   0.1 0.2 1.3 881 CG,UA CG,UA,AU
1477 1477 16S 20 584 757   v4 G:U cWW       Weak M 3.9   2.5 49.5 14.2 0.3 4.3 4.9 0.2 1.7 1.5 4.4 0.3   1.6 6.5 4.3 883 GC,UA,AU,GU,AA,AC,CU,UU GC,UA,AU
1540 1540 16S 21 594 645   v4 U:G cWW       Weak M 0.1   1.0 1.7   0.3 0.4 0.1   2.1 0.1   0.2 0.1 0.1 2.7 91.2 1021 CA,UU AC,CA,GG,UU
1554 1554 16S 21 597 643   v4 G:C cWW       Weak M 2.9   0.6 0.2       2.6       0.1 0.2   0.4 0.1 92.9 1021 GC,AC GC,UA,AU
1610 1610 16S 21 605 633   v4 U:G cWW       Weak M 0.1   0.5 0.4 0.2 2.4 0.1   0.1     0.1 0.1   0.1 0.2 95.8 1021 UG AU,UG,GA
1617 1617 16S 21 606 632   v4 G:U No BP       Weak M   0.1 0.6 0.2 2.0 0.2 0.4   0.2 0.1     0.1     0.4 95.8 1021 GU UA,GU,AG
1694 1694 16S 22 658 748   v4 C:G cWW       Weak M 0.3 0.8 17.4 1.5 2.1 5.1 1.5 0.6 9.6 2.9 0.2 0.1 0.4 0.3 0.6 1.5 55.3 896 UA,GU,UG,AG,CA UA,GU,AG,CC
1736 1736 16S 22 666 740   v4 G:U cWW       Weak M 0.3 15.7 6.8 7.0 3.5 0.1 17.2 6.5 6.4 6.7 2.6 5.4 0.2     0.8 21.0 897 CG,UA,AU,GU,AA,AC,AG,CA,CC,CU CG,GU,AA
1799 1799 16S 23 677 713   v4 U:G cWW       Weak M 1.8 4.8 12.8 3.6 1.0 8.3 17.2 11.8 3.4 14.0 1.7 2.4 2.0 0.4 7.0 3.8 4.1 901 CG,UA,AU,UG,AA,AC,AG,CA,CU,GA,UC,UU GC,UG,AA,CU
1848 1848 16S 23 684 706   v4 U:A cWW       Weak M 0.7 12.9 43.3 2.9 0.7 6.0 6.1 0.7 0.2 3.1 6.4 1.9 0.2   2.4 11.0 1.6 901 CG,UA,AU,UG,AA,CA,CC,UC,UU GC,CG,UA,AU
1869 1869 16S 23 690 697   v4 G:U tSH       Weak M 0.2 0.4 33.7 5.1 13.8 0.1 0.7 0.2   13.0 6.3 0.1 0.4   24.8 0.8 0.3 901 UA,AU,GU,CA,CC,UC UA,GU,CC
2044 2044 16S 26 832 854   v4 G:U cWW       Weak M 0.3 1.7 1.2 1.6 2.5 0.3               0.1   0.2 92.1 1099 GU CG,UA,GU
2107 2107 16S 26.1 861 868   v4 G:C cWW       Weak M 4.1 2.8 10.3 4.8 0.1 0.5 19.6 0.8 0.1 15.1 1.6 1.4 1.1   0.3 1.0 36.2 1096 GC,CG,UA,AU,AA,CA GC,CG,AA,UU
2198 2198 16S 28 925 1391   v4 G:U cWW       Weak M 66.4 3.6 0.4 0.7 27.7 0.1     0.2     0.2 0.7         899 GC,CG,GU GC,CG,UA,AU
2254 2254 16S 28 935 1380   v4 A:U cWW       Weak M   88.1 0.5 4.6 0.3 0.5 3.4 0.2   0.5 0.3         1.0 0.4 970 CG,AU,AA CG,UA,AU
2289 2289 16S 29 942 1341   v4 G:U cWW       Weak M 0.3   0.3 0.4 99.0                         1129 GU UA,GU
2345 2345 16S 30 950 1231   v4 U:G cWW       Weak M   0.3 0.2     98.3           0.3     0.2 0.7 0.1 1152 UG UG,CU
2387 2387 16S 31 960 975   v4 U:A No BP       Weak M     6.5 89.1   0.6 0.9 0.3 0.6   0.1 0.3     1.0 0.7 0.1 1153 UA,AU UA,AU,CC
2394 2394 16S 31 961 974   v4 U:A No BP       Weak M 0.6   54.6 0.6 0.4 0.1 1.5 0.1   3.3 0.3 12.3 0.1   8.9 17.3   1151 UA,CA,CU,UC,UU GC,UA,CU
2625 2625 16S 34 1052 1206   v4 U:G cWW       Weak M   0.4 3.3     80.4 0.1     14.9         0.2 0.4 0.3 1152 UA,UG,CA UG,CA
2632 2632 16S 34 1053 1205   v4 G:U No BP       Weak M 0.5     90.9 7.8     0.5       0.1       0.1 0.1 1152 AU,GU GC,AU
2653 2653 16S 34 1058 1199   v4 G:U cWW       Weak M 3.7     4.6 76.2     0.7         0.1     14.7 0.1 1150 GC,AU,GU,UU GU,AC
2905 2905 16S 40 1158 1178   v4 C:G No BP       Weak M 0.1 2.5 2.3 0.3     0.2   0.1     0.3   0.2   0.4 93.5 1152 CG,UA GC,CG,UA,AU
2912 2912 16S 40 1159 1177   v4 U:G No BP       Weak M   0.3 0.3 0.2 0.1 2.5 0.1   0.1 0.3 2.0 0.2   0.2   0.4 93.6 1152 UG,CC AU,UG,CC
3024 3024 16S 41 1255 1282   v4 G:C cWW       Weak M 4.3   0.1 1.2 1.7             0.1     0.1 0.1 92.4 1154 GC GC,UA,AU
3192 3192 16S 44 1401 1501   v4 G:C cWW       Weak M 93.4     5.8 0.1                 0.1 0.4   0.1 791 GC,AU GC,AU
3325 3325 16S 44 1425 1475   v4 U:G cWW       Weak M 0.2 0.5 1.6 1.8 0.1 2.7       0.1           2.9 89.9 849 UG,UU GC,CG,UU
3367 3367 16S 44 1435 1466   v4 G:C cWW       Weak M 0.6 0.1   0.7 0.4   0.4 0.1 0.1   0.1   2.2     0.5 94.8 849 GA AU,CC,GA
3409 3409 16S 44 1442 1460   v4 G:C cWW       Weak M 0.1 0.1 0.2 2.8 0.1 0.4 0.2 0.1 0.1       0.1     0.4 95.3 849 AU GC,AU,UG
3451 3451 16S 45 1506 1529   v4 U:G No BP       Weak M     15.6     83.0               0.1 0.1 0.9 0.1 672 UA,UG  
3486 3486 16S 45 1511 1524   v4 G:C cWW       Weak M 53.0 3.6 0.3 25.4 15.6 0.3   0.4 0.1 0.3 0.3   0.1   0.1   0.3 674 GC,CG,AU,GU GC,CG,UA,AU
3493 3493 16S 45 1512 1523   v4 U:G cWW       Weak M   1.6 0.4 0.4   96.4     0.4     0.1   0.1     0.2 675 UG AU,UG

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "basepair_frequency" (
   "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,
   "GC" REAL,
   "CG" REAL,
   "UA" REAL,
   "AU" REAL,
   "GU" REAL,
   "UG" REAL,
   "AA" REAL,
   "AC" REAL,
   "AG" REAL,
   "CA" REAL,
   "CC" REAL,
   "CU" REAL,
   "GA" REAL,
   "GG" REAL,
   "UC" REAL,
   "UU" REAL,
   "gap" REAL,
   "Seq" INTEGER,
   "predominant_types" TEXT,
   "covarying_types" TEXT
);
CREATE INDEX "idx_basepair_frequency_molecule_position_1_position_2"
    ON "basepair_frequency" ("molecule", "position_1", "position_2");
Powered by Datasette · Queries took 800.087ms