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 = "E", molecule = "23S" and strength = "Weak" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: reference_base_pair, GC, CG, UA, AU, GU, UG, AC, AG, CA, CU, GA, GG, UC, UU, gap, Seq, 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

  • E · 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
3569 3569 23S 1 8 2895   v4 C:G cWW       Weak E   2.4                             97.4 41 CG  
3835 3835 23S 6.1 66 88   v4 C:G cWW   3°: pseudoknot   Weak E                   0.8             99.1 118    
4045 4045 23S 10 158 168   v4 U:G cWW       Weak E 4.2 2.5 73.3 0.8   0.8 1.7           2.5     0.8 13.3 120 GC,CG,UA,GA GC,CG,UA,AU
4227 4227 23S 16 274 363   v4 C:G cWW       Weak E 0.5 2.9 15.7 0.5 1.0   3.4 7.8 1.0 2.9 4.4 2.0 0.5 0.5 0.5 9.8 46.6 204 CG,UA,AA,AC,CA,CC,CU,UU CG,UA,GU,AC
4234 4234 23S 18 281 359   v4 C:G cWW       Weak E 8.8 3.4   1.0 1.0         1.5 1.5 5.9   2.5   0.5 74.0 204 GC,CG,CU,GG GC,CU
4255 4255 23S 18 284 356   v4 U:G cWW       Weak E 4.4 5.4 1.0 12.7 11.8 1.0 1.5 2.9 2.9 0.5 6.4   1.5 4.4 9.3 3.4 30.9 204 GC,CG,AU,GU,AC,AG,CC,GG,UC,UU CG,AU,GA,UC
4318 4318 23S 18 293 347   v4 U:A cWW       Weak E 24.5 2.3 10.5 3.6 1.8 0.9 0.9 3.2 3.6 3.6 2.3 3.6 1.8 1.8 8.6 4.1 22.9 220 GC,CG,UA,AU,AC,AG,CA,CC,CU,UC,UU GC,UA,AG,CU
4416 4416 23S 20 327 335   v4 G:C cWW       Weak E 91.4 0.9   6.4       0.5             0.5   0.5 220 GC,AU GC,CG,AU
4444 4444 23S 21 378 396   v4 C:G cWW       Weak E   19.5 2.7 0.9   76.5                 0.5     221 CG,UA,UG AU,UG
4472 4472 23S 21 382 392   v4 A:U cWW       Weak E           0.5           0.9     0.5 97.7 0.5 221 UU  
4633 4633 23S 25 538 555   v4 A:G cWW   3°: base pair   Weak E 38.2 2.4   9.2 20.8 13.0               0.5   5.8 10.1 207 GC,CG,AU,GU,UG,UU GC,AU,UG
4689 4689 23S 25.1 564 577   v4 C:G cWW       Weak E   100.0                               207 CG  
4829 4829 23S 27 600 657   v4 G:U cWW       Weak E 83.6   0.5 0.5 14.9                       0.5 201 GC,GU GC,UA,AU
4927 4927 23S 31 641 647   v4 U:G cWW       Weak E                                 100.0 203    
4934 4934 23S 32 671 809   v4 C:G cWW       Weak E   100.0                               204 CG  
4997 4997 23S 33 687 775   v4 C:G No BP       Weak E   98.5                       1.0     0.5 205 CG  
5053 5053 23S 33 695 767   v4 G:U cWW       Weak E 5.9       93.2 0.5   0.5                   205 GC,GU GU,UG,AC
5102 5102 23S 34 703 729   v4 U:G No BP       Weak E   49.3       50.2       0.5               205 CG,UG UG,CA
5109 5109 23S 34 707 724   v4 G:U cWW       Weak E 0.5       98.0             0.5         1.0 205 GU  
5305 5305 23S 37 826 831   v4 U:G cWW       Weak E   75.6       23.5                 0.5   0.5 213 CG,UG CG,UC
5879 5879 23S 42 1051 1108   v4 G:U cWW       Weak E 98.0     0.5       1.0                 0.5 205 GC GC,AU
6124 6124 23S 46 1215 1234   v4 G:U cWW       Weak E 1.6       80.7     14.6               2.6 0.5 192 GU,AC,UU GU,AC
6586 6586 23S 54 1415 1587   v4 U:G cWW       Weak E 24.9 0.6 2.8 4.0 13.6 0.6 8.5   1.1 1.1 0.6 1.1 2.8 6.2 0.6 25.4 6.3 177 GC,UA,AU,GU,AA,GA,GG,UU GC,CG,AA,UU
6684 6684 23S 56 1436 1556   v4 G:C cWW       Weak E 65.7 3.4 0.6 14.6 8.4   2.2 1.1         0.6 1.1 2.2     178 GC,CG,AU,GU,AA,UC GC,CG,UA,AU
6698 6698 23S 56 1440 1551   v4 U:A cWW       Weak E 3.9 7.8   5.6 1.7 1.7                 0.6   78.8 179 GC,CG,AU GC,CG,AU
6733 6733 23S 57 1445 1466   v4 G:U cWW       Weak E 1.7 1.1   2.2 70.6       2.2 5.0     0.6 14.4 1.1 0.6 0.6 180 AU,GU,AG,CA,GG GU,AG,CA,UC
6782 6782 23S 58 1468 1524   v4 U:G cWW       Weak E     3.9 5.6 0.6 8.9 16.1 1.1 35.6       12.2 11.1     5.1 180 UA,AU,UG,AA,AG,GA,GG AG,GA
6817 6817 23S 58 1478 1513   v4 G:U cWW       Weak E 15.6 3.3 5.0 21.1 1.7   3.9   0.6 22.2 2.2   1.1 7.2 1.1   15.1 180 GC,CG,UA,AU,AA,CA,CC,GG GC,AU,CA
6838 6838 23S 58 1481 1510   v4 U:G cWW       Weak E 2.8 20.7 7.8 38.5 3.9 3.4 0.6     0.6 1.7 4.5   0.6 3.9 1.1 10.1 179 GC,CG,UA,AU,GU,UG,CU,UC GC,CG,UA,AU
6852 6852 23S 58 1483 1506   v4 G:U cWW       Weak E 2.8 57.2 13.9 10.6 5.6 3.3       1.1   0.6 0.6 0.6 0.6   3.4 180 GC,CG,UA,AU,GU,UG GC,CG,UA,AU
7160 7160 23S 63 1707 1751   v4 G:U cWW       Weak E 1.9     1.3 96.1                       0.6 155 GU  
7300 7300 23S 64 1770 1982   v4 G:U cWW       Weak E   99.4 0.6                             155 CG CG,UA
7321 7321 23S 65 1775 1789   v4 U:A tHS       Weak E     97.4                       2.6     156 UA,UC  
7398 7398 23S 66 1799 1820   v4 G:U No BP       Weak E 97.4       0.6     0.6                 1.2 155 GC  
7412 7412 23S 66 1803 1814   v4 A:G tHS   3°: base pair   Weak E 2.6 1.9 0.6 1.9 89.1     0.6                 3.2 156 GC,GU CG,UA,GU,AC
7468 7468 23S 68 1835 1905   v4 G:C cWW       Weak E 99.4       0.6                         155 GC  
7496 7496 23S 68 1841 1901   v4 U:A cWW       Weak E     100.0                             155 UA  
7503 7503 23S 68 1842 1898   v4 G:U cWW       Weak E         99.4             0.6           155 GU  
7552 7552 23S 68 1851 1891   v4 U:G cWW       Weak E           100.0                       155 UG  
7643 7643 23S 69 1907 1923   v4 G:U cWW       Weak E         100.0                         155 GU  
7671 7671 23S 69 1911 1919   v4 U:A No BP       Weak E     99.4                         0.6   155 UA  
7692 7692 23S 71 1945 1961   v4 G:C cWW       Weak E 99.4                               0.6 155 GC  
7706 7706 23S 71 1947 1959   v4 C:G cWW       Weak E   99.4                             0.6 155 CG  
7846 7846 23S 73 2056 2612   v4 G:C cWW       Weak E       100.0                           135 AU  
7867 7867 23S 74 2065 2445   v4 C:G cWW       Weak E   98.6                             1.4 144 CG  
7930 7930 23S 74 2075 2434   v4 U:A No BP       Weak E     98.1                         1.9   155 UA  
7937 7937 23S 75 2077 2243   v4 A:U cWW       Weak E       99.4                         0.6 155 AU  
8063 8063 23S 76 2100 2189   v4 G:U cWW       Weak E 13.5   2.6 12.3 70.3             0.6         0.6 155 GC,UA,AU,GU UA,GU
8126 8126 23S 76 2109 2180   v4 U:U cWW   3°: base pair   Weak E 96.1     0.6   2.6                     0.6 155 GC,UG GC,AU,UG
8161 8161 23S 77 2120 2178   v4 G:C cWW       Weak E 11.0 3.2   65.2 20.0                       0.6 155 GC,CG,AU,GU GC,CG,AU
8217 8217 23S 78 2136 2155   v4 G:U cWW       Weak E       0.6                         99.3 155    
8266 8266 23S 78 2143 2148   v4 C:G cWW       Weak E         0.6                       99.2 155    
8364 8364 23S 80 2249 2255   v4 U:G No BP       Weak E           98.1               1.9       155 UG  
8448 8448 23S 83 2291 2341   v4 U:G cWW       Weak E 14.2 33.5 12.3 0.6   37.4     0.6 1.3               155 GC,CG,UA,UG GC,AU,UG,CA
8560 8560 23S 85.1 2328 2387   v4 A:U cWW   3°: pseudoknot   Weak E       97.4       2.6                   155 AU,AC  
8609 8609 23S 86 2351 2366   v4 G:A cWW   3°: base pair   Weak E 16.1 3.9 3.9 2.6 1.9 1.3             70.3         155 GC,CG,UA,AU,GA CG,AU,GA
8735 8735 23S 89 2455 2496   v4 G:C cWW       Weak E         100.0                         138 GU  
8763 8763 23S 89 2460 2490   v4 U:G cWW       Weak E                               99.3 0.7 138 UU  
9022 9022 23S 93 2592 2601   v4 G:C cWW       Weak E 98.6                               1.4 139 GC  
9176 9176 23S 95 2652 2668   v4 C:G cWW       Weak E 4.3 0.7 22.3 3.6 3.6 1.4       2.2 22.3       39.6     139 GC,UA,AU,GU,CA,CC,UC AU,CA,UC
9281 9281 23S 96 2696 2711   v4 U:A cWW       Weak E   12.2 24.5     44.6       7.2   5.0       6.5   139 CG,UA,UG,CA,CU,UU UG,CA

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