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).

61 rows where group_code = "T", molecule = "23S" and strength = "Weak" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: reference_base_pair, AA, AC, AG, CA, CC, CU, GA, GG, UC, UU, covarying_types

conformation 3

  • cWW 53
  • No BP 6
  • tHS 2

tertiary_type 2

  • 3°: base pair 4
  • 3°: pseudoknot 2

strength 1

  • Weak · 61 ✖

molecule 1

  • 23S · 61 ✖

header_format 1

  • v4 61

group_code 1

  • T · 61 ✖
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
3564 3564 23S 1 8 2895   v4 C:G cWW       Weak T 4.9 21.6 31.6 3.3 0.6 15.5 1.8 0.6   3.0 0.3     0.3   0.6 15.7 329 GC,CG,UA,AU,UG,CA GC,CG,UA,AU
3830 3830 23S 6.1 66 88   v4 C:G cWW   3°: pseudoknot   Weak T 0.1 49.5 1.5 0.5 0.1 0.8 0.1   0.9 0.1 0.3   0.3 0.3 0.3 0.3 44.8 740 CG GC,CG,UA,AU
4040 4040 23S 10 158 168   v4 U:G cWW       Weak T 0.9 1.2 13.2 0.8   36.6 1.2 0.3 2.1 0.9 0.5   0.4 0.1 0.3 0.3 41.1 759 UA,UG,AG GC,UG,AA
4222 4222 23S 16 274 363   v4 C:G cWW       Weak T 2.3 3.7 4.7 0.2 0.3 2.2 1.3 1.9 0.6 0.8 1.3 0.5 0.8 0.1 0.7 2.6 76.1 872 GC,CG,UA,UG,UU GC,CG,UA,AU
4229 4229 23S 18 281 359   v4 C:G cWW       Weak T 6.2 5.6 3.1 7.4 4.5 2.8 1.6 7.5 0.8 0.6 0.9 2.0 0.7 1.5 0.7 2.5 51.7 869 GC,CG,UA,AU,GU,UG,AC,CU,UU CG,UA,GU,AC
4250 4250 23S 18 284 356   v4 U:G cWW       Weak T 5.7 15.1 4.4 6.3 3.4 3.8 2.8 4.3 1.5 1.6 2.1 0.8 0.7 1.4 3.7 4.1 38.3 870 GC,CG,UA,AU,GU,UG,AA,AC,CC,UC,UU GC,CG,UA,AU
4313 4313 23S 18 293 347   v4 U:A cWW       Weak T 6.1 1.4 35.2 2.7 1.1 2.4 2.8 1.1 1.5 2.4 0.6 1.0 1.8 1.5 2.1 1.8 34.7 888 GC,UA,AU,UG,AA,CA,UC GC,CG,UA,AU
4411 4411 23S 20 327 335   v4 G:C cWW       Weak T 71.8 0.2   1.8       0.1             0.3   25.7 891 GC GC,CG,AU
4439 4439 23S 21 378 396   v4 C:G cWW       Weak T 1.2 38.0 1.2 1.1 0.9 32.4     0.2     0.6     0.1   24.3 893 CG,UG GC,CG,UA,AU
4467 4467 23S 21 382 392   v4 A:U cWW       Weak T 2.7 1.1 0.7 22.9 11.3 0.1 0.7 6.9 0.1 0.1   0.2 0.1   0.1 27.4 25.5 894 GC,AU,GU,AC,UU CG,AC,GA,UU
4628 4628 23S 25 538 555   v4 A:G cWW   3°: base pair   Weak T 11.9 0.6 0.3 3.7 6.4 3.1 2.7   43.4     0.1 0.1 0.2   1.4 26.1 881 GC,AU,GU,UG,AA,AG GC,AG,UU
4684 4684 23S 25.1 564 577   v4 C:G cWW       Weak T 0.1 97.6 0.2 0.1 0.1       0.1   0.2 0.2         1.2 888 CG CG,UA,GU
4824 4824 23S 27 600 657   v4 G:U cWW       Weak T 20.1   0.1 1.0 54.1                       24.7 882 GC,GU UA,GU
4922 4922 23S 31 641 647   v4 U:G cWW       Weak T   6.2 2.0     39.9 0.1   0.1     0.2 0.2   0.1 0.2 50.8 883 CG,UA,UG UG,CU,GA
4929 4929 23S 32 671 809   v4 C:G cWW       Weak T   97.6 0.1 1.1 0.1 0.1   0.1                 0.8 845 CG CG,UA,AU
4992 4992 23S 33 687 775   v4 C:G No BP       Weak T   95.8 0.2 0.9   1.2   0.1 0.3 0.1 0.1 0.3 0.1 0.3     0.3 886 CG CG,UA,AU
5048 5048 23S 33 695 767   v4 G:U cWW       Weak T 6.2 0.5 2.3 13.3 74.6 1.8 0.5 0.5               0.5   887 GC,UA,AU,GU CG,UA,GU,AC
5097 5097 23S 34 703 729   v4 U:G No BP       Weak T   15.1 0.1 0.1 0.1 71.4 0.2   5.1 0.1   0.1   0.6     7.1 887 CG,UG,AG GU,UG,AA
5104 5104 23S 34 707 724   v4 G:U cWW       Weak T 0.9 0.2 0.6 3.7 67.6 0.2 0.1 0.2 0.1     0.2       0.1 25.9 887 AU,GU CG,UA,GU,AC
5300 5300 23S 37 826 831   v4 U:G cWW       Weak T   20.1 2.0 0.5 0.1 73.8       0.4       0.1 0.1 0.1 2.8 856 CG,UA,UG AU,UG,CA
5874 5874 23S 42 1051 1108   v4 G:U cWW       Weak T 27.7 5.2 0.6 31.5 13.6 0.1 0.1 0.2 0.2 0.1   0.1 0.2   0.1 0.6 19.4 858 GC,CG,AU,GU GC,CG,UA,AU
6119 6119 23S 46 1215 1234   v4 G:U cWW       Weak T 0.3   0.5 1.4 66.1     3.2     0.1       0.1 1.0 27.2 871 GU,AC UA,GU,AC
6581 6581 23S 54 1415 1587   v4 U:G cWW       Weak T 7.1 6.4 7.6 1.3 3.7 9.8 3.0   0.7 1.3 0.1 0.2 5.5 3.9 0.2 5.8 43.3 857 GC,CG,UA,GU,UG,AA,GA,GG,UU GC,UG,AA,CU
6679 6679 23S 56 1436 1556   v4 G:C cWW       Weak T 37.8 0.7 1.7 3.3 14.4 0.3 2.4 1.7 0.3 0.1 0.1 0.6 2.2 0.2 1.4 0.8 31.7 860 GC,AU,GU,AA,GA GC,CG,UA,AU
6693 6693 23S 56 1440 1551   v4 U:A cWW       Weak T 6.2 11.9 2.8 10.7 17.9 2.9 1.4 1.3 0.7 0.5 0.6 2.3 0.1 0.7 1.3 0.9 37.7 859 GC,CG,UA,AU,GU,UG,CU CG,UA,GU,AC
6728 6728 23S 57 1445 1466   v4 G:U cWW       Weak T 1.5 4.3 0.1 1.6 35.1 3.1 0.1 3.3 0.5 1.0 0.9 0.6 0.2 3.0 0.3 3.1 41.0 861 CG,GU,UG,AC,GG,UU CG,UA,GU,AC
6777 6777 23S 58 1468 1524   v4 U:G cWW       Weak T 7.1 10.6 3.7 2.6 1.0 10.8 4.5 0.5 8.4 0.2 0.2 1.3 4.4 2.9 0.2 4.1 37.4 861 GC,CG,UA,AU,UG,AA,AG,GA,GG,UU GC,UG,AA,CU
6812 6812 23S 58 1478 1513   v4 G:U cWW       Weak T 17.9 2.0 0.9 3.5 22.0 0.8 1.9 0.2 0.5 4.8 1.0   1.6 1.9 0.1   40.8 860 GC,CG,AU,GU,CA GU,UG,AC,CA
6833 6833 23S 58 1481 1510   v4 U:G cWW       Weak T 2.7 3.1 1.2 0.6 1.7 3.7 0.3 0.2 0.1 1.0 0.8 12.3 0.2 0.5   0.5 70.9 861 GC,CG,UG,CU GC,UG,AA,CU
6847 6847 23S 58 1483 1506   v4 G:U cWW       Weak T 18.7 4.2 12.1 2.6 3.8 3.6 0.1 0.2   4.5 0.1 0.1 6.9 2.2 0.1 0.7 40.0 861 GC,CG,UA,AU,GU,UG,CA,GA,GG GC,CG,UA,AU
7155 7155 23S 63 1707 1751   v4 G:U cWW       Weak T 19.0 1.4   7.8 41.4     0.1     0.6   0.4       29.2 833 GC,AU,GU CG,GU,AC
7295 7295 23S 64 1770 1982   v4 G:U cWW       Weak T 10.8 41.4 2.8 4.3 30.8 8.0 0.1   0.1 0.1   0.9 0.2       0.3 809 GC,CG,UA,AU,GU,UG CG,UA,GU
7316 7316 23S 65 1775 1789   v4 U:A tHS       Weak T   1.0 97.3 0.4     0.1               0.5 0.8   842 UA CG,UA,AU
7393 7393 23S 66 1799 1820   v4 G:U No BP       Weak T 22.1   0.1 0.6 73.2     0.1         0.4       3.5 842 GC,GU UA,GU,AC
7407 7407 23S 66 1803 1814   v4 A:G tHS   3°: base pair   Weak T 0.5 0.4 0.6 1.5 20.2 0.1 7.6 2.6 37.5 0.2 0.1 0.1       0.2 28.2 840 GU,AA,AC,AG UA,GU,AG,CC
7463 7463 23S 68 1835 1905   v4 G:C cWW       Weak T 98.1   0.1   0.5               0.1       1.2 851 GC GC,UA
7491 7491 23S 68 1841 1901   v4 U:A cWW       Weak T     98.5       0.2     0.1             1.2 852 UA  
7498 7498 23S 68 1842 1898   v4 G:U cWW       Weak T 0.9       97.3             0.1 0.2 0.1     1.3 852 GU  
7547 7547 23S 68 1851 1891   v4 U:G cWW       Weak T   0.3 1.3     65.5 0.7   0.1 0.2 0.1   0.3 0.2 0.6 0.1 30.4 867 UG UG,AA,CC
7638 7638 23S 69 1907 1923   v4 G:U cWW       Weak T 0.7 0.2   0.1 97.6               0.1       1.2 850 GU CG,GU
7666 7666 23S 69 1911 1919   v4 U:A No BP       Weak T     97.9             0.5           0.1 1.5 852 UA  
7687 7687 23S 71 1945 1961   v4 G:C cWW       Weak T 97.3   0.1 0.1 0.1   0.1 0.2     0.2   1.7       0.1 848 GC GC,AA
7701 7701 23S 71 1947 1959   v4 C:G cWW       Weak T 0.1 84.4 2.6 0.1 0.2 11.9                   0.4 0.2 848 CG,UA,UG CG,UA,GU
7841 7841 23S 73 2056 2612   v4 G:C cWW       Weak T 70.7     18.7     7.6 0.7 0.3   0.1   1.9         726 GC,AU,AA GC,AU
7862 7862 23S 74 2065 2445   v4 C:G cWW       Weak T   98.0 1.1     0.6                     0.3 832 CG CG,UA
7925 7925 23S 74 2075 2434   v4 U:A No BP       Weak T   0.1 97.8     0.4 0.2         0.1     0.2 1.2   845 UA CG,UA
7932 7932 23S 75 2077 2243   v4 A:U cWW       Weak T 0.1     98.6 0.1 0.1 0.1         0.1 0.1     0.4 0.3 845 AU AU,UG,GA
8058 8058 23S 76 2100 2189   v4 G:U cWW       Weak T 7.3 0.6 2.2 4.4 47.9 3.9 0.7         0.2   0.5   0.5 31.7 847 GC,UA,AU,GU,UG GU,UG,AA
8121 8121 23S 76 2109 2180   v4 U:U cWW   3°: base pair   Weak T 18.1   3.9 0.5 0.1 1.2 0.1     0.4   0.4     0.6 42.7 32.0 847 GC,UA,UU GC,CA,UU
8156 8156 23S 77 2120 2178   v4 G:C cWW       Weak T 30.1 0.8 0.7 14.3 21.1               0.1     0.9 31.8 847 GC,AU,GU GC,CG,UA,AU
8212 8212 23S 78 2136 2155   v4 G:U cWW       Weak T 3.4 4.7 2.1 12.3 18.9 0.1 1.2 0.5 0.1 0.7   0.1 1.2 0.2   0.2 54.2 847 GC,CG,UA,AU,GU CG,UA,GU,AC
8261 8261 23S 78 2143 2148   v4 C:G cWW       Weak T   31.7   0.1 0.2 13.1       0.1             54.7 848 CG,UG CG,GU
8359 8359 23S 80 2249 2255   v4 U:G No BP       Weak T     4.1     94.6       0.6       0.4 0.1 0.1 0.1 845 UA,UG UG,CA
8443 8443 23S 83 2291 2341   v4 U:G cWW       Weak T 2.7 6.8 3.7 0.2   54.7     0.1 0.2     0.2   0.1   31.1 848 GC,CG,UA,UG GC,AU,UG,CA
8555 8555 23S 85.1 2328 2387   v4 A:U cWW   3°: pseudoknot   Weak T     0.1 68.4       0.5                 31.0 848 AU UA,AU
8604 8604 23S 86 2351 2366   v4 G:A cWW   3°: base pair   Weak T 4.9 0.8 10.5 4.6 1.1 0.2 26.9 0.8 0.1 1.6   0.1 40.8 0.1 0.6 0.4 6.4 849 GC,UA,AU,AA,GA CG,AU,GA,UC
8730 8730 23S 89 2455 2496   v4 G:C cWW       Weak T 45.7 30.0   3.7 20.3     0.1     0.1     0.1       828 GC,CG,AU,GU GC,CG,AU
8758 8758 23S 89 2460 2490   v4 U:G cWW       Weak T       1.2   81.3 0.2 0.1       0.1     0.1 16.5 0.3 828 UG,UU AU,UG
9017 9017 23S 93 2592 2601   v4 G:C cWW       Weak T 97.3     0.4 0.8           0.3   0.4 0.1 0.1   0.5 734 GC GC,AU
9171 9171 23S 95 2652 2668   v4 C:G cWW       Weak T 1.2 37.4 9.6 7.5 1.0 16.8 0.3 0.3 0.1 12.6 4.2 0.1     7.5 1.1 0.3 736 CG,UA,AU,UG,CA,CC,UC GC,CG,UA,AU
9276 9276 23S 96 2696 2711   v4 U:A cWW       Weak T   2.6 55.4 0.1   8.5       1.4   1.0     0.1 1.5 29.3 727 CG,UA,UG CG,UA,AU

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 1342.918ms