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 = "T", 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, UA, AU, GU, UG, AA, AC, AG, CA, CC, CU, GA, GG, UC, UU, gap, predominant_types, 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

  • T · 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
197 197 16S 1 13 21   v4 U:G No BP       Weak T   0.1 8.8 0.1   88.5 0.1   1.5 0.1     0.1 0.1   0.3 0.5 3890 UA,UG UG,AA
274 274 16S 3 35 549   v4 G:C cWW       Weak T 82.3 0.1 0.3 4.1 10.8     1.2   0.1 0.3   0.1   0.2 0.1 0.3 5420 GC,AU,GU GC,CG,UA,AU
288 288 16S 3 37 547   v4 U:A tWS       Weak T     97.5 0.1   0.7 0.2     0.9     0.2   0.1 0.1 0.3 5551 UA UA,AU
295 295 16S 4 39 403   v4 G:C cWW       Weak T 67.3 0.2 13.1 1.2 1.0 0.2 0.3 0.3   0.6 0.3 0.1 14.2 0.1 0.3 0.6 0.5 5839 GC,UA,GA GC,CG,UA,AU
372 372 16S 5 54 357   v4 C:G cWW       Weak T   99.0 0.3     0.3     0.1 0.1               6225 CG CG,UA
379 379 16S 5 56 356   v4 U:A cWW       Weak T     99.5             0.1     0.1       0.2 6225 UA  
393 393 16S 5 58 354   v4 C:G cWW       Weak T 0.6 98.2       0.3     0.1 0.1 0.2     0.1     0.3 6357 CG GC,CG
407 407 16S 6 62 105   v4 U:G cWW       Weak T 0.1 1.4 1.1 0.2   94.0 0.1 0.2 0.1 0.9 0.5     0.1 0.4 0.2 0.6 6551 UG UG,AC,CA
435 435 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak T 3.1 0.3 13.9 0.7 0.3 0.3 0.2   0.1 0.2     68.8 0.4   0.2 11.6 6584 GC,UA,GA AU,UG,GA
946 946 16S 12 292 308   v4 G:C cWW       Weak T 74.5     6.4 7.4     0.3         0.2   0.1 0.2 10.6 7204 GC,AU,GU GC,AU
1044 1044 16S 14 342 347   v4 C:G cWW       Weak T 0.1 94.9 0.4 0.1   0.6     1.7         0.1   0.1 2.1 7119 CG GC,CG,UA,AU
1079 1079 16S 15 375 388   v4 U:G No BP       Weak T   0.1 0.9     97.8     0.1         0.1 0.1 0.4 0.4 6852 UG  
1114 1114 16S 16 406 436   v4 G:C cWW       Weak T 73.7   0.1 0.5 0.5                 0.1 0.1   24.9 7096 GC GC,UA,AU
1142 1142 16S 16 416 427   v4 G:U cWW       Weak T 12.5   0.4 0.8 56.1     0.7       0.1       1.4 27.8 7239 GC,GU UA,GU,AC
1163 1163 16S 16 419 424   v4 C:G cWW       Weak T 0.2 56.0 0.7 0.4   12.2 0.1   0.1               30.1 7217 CG,UG GC,CG,UA,AU
1422 1422 16S 19.1 571 865   v4 U:A cWW   3°: pseudoknot   Weak T   0.3 98.8 0.1 0.1 0.2 0.1                   0.1 6825 UA CG,UA,GU
1471 1471 16S 20 584 757   v4 G:U cWW       Weak T 0.6   0.3 6.3 88.6   0.5 0.6   0.2 0.2 0.6 0.4   0.2 0.8 0.5 7034 AU,GU UA,GU,AC
1534 1534 16S 21 594 645   v4 U:G cWW       Weak T 0.3 20.2 6.3 1.5   40.2 1.0 0.5 0.3 1.3   0.1 0.1 0.1 0.1 0.5 27.2 7202 CG,UA,UG GC,AU,UG,CA
1548 1548 16S 21 597 643   v4 G:C cWW       Weak T 71.2   0.1 0.1 0.1     0.6     0.1   0.1 0.2 0.1   27.5 7236 GC GC,UA,AU
1604 1604 16S 21 605 633   v4 U:G cWW       Weak T 1.0 0.4 1.1 0.2 0.3 62.5     0.1           1.0 4.7 28.5 7254 UG,UU GC,AU,UG
1611 1611 16S 21 606 632   v4 G:U No BP       Weak T 1.7 1.7 1.4 1.7 47.5 1.7 0.4 0.1 0.4   0.3 0.3 2.0 8.1 1.4 2.4 28.8 7251 GU,GA,GG,UU GU,UG,AA,CC
1688 1688 16S 22 658 748   v4 C:G cWW       Weak T 5.4 6.2 6.5 26.7 6.7 1.2 7.0 1.5 1.6 2.4 0.5 3.6 14.8 1.9 1.1 6.1 6.9 7004 GC,CG,UA,AU,GU,AA,CA,CU,GA,UU CG,AU,GA,UC
1730 1730 16S 22 666 740   v4 G:U cWW       Weak T 1.7 2.8 1.0 3.0 69.7   2.2 0.8 0.9 0.8 0.3 0.7 13.1     0.1 2.7 7111 CG,AU,GU,AA,GA CG,GU,AA
1793 1793 16S 23 677 713   v4 U:G cWW       Weak T 0.2 5.1 28.6 0.4 0.1 51.6 2.2 1.5 0.4 6.4 0.2 0.8 0.3 0.1 1.0 0.5 0.5 7166 CG,UA,UG,AA,CA GU,UG,AC,CA
1842 1842 16S 23 684 706   v4 U:A cWW       Weak T 7.1 1.6 73.8 0.5 9.9 0.8 2.2 0.4   0.4 0.8 0.3 0.1   0.4 1.4 0.2 7176 GC,UA,GU,AA CG,UA,GU,AC
1863 1863 16S 23 690 697   v4 G:U tSH       Weak T 0.1 0.1 4.2 7.5 81.9   0.1     1.6 0.8 0.1 0.1   3.1 0.2 0.1 7180 UA,AU,GU,UC UA,GU,CC
2038 2038 16S 26 832 854   v4 G:U cWW       Weak T 5.7 1.0 0.5 2.8 60.5 0.3 10.8 0.9 0.6     0.1 0.5 1.7 0.1 0.6 13.8 7262 GC,AU,GU,AA CG,GU,AA,UC
2101 2101 16S 26.1 861 868   v4 G:C cWW       Weak T 70.9 2.2 1.6 0.9 5.6 0.1 3.1 0.6   2.4 3.9 0.2 0.2 0.1 0.1 0.4 7.5 6998 GC,CG,GU,AA,CA,CC GC,CG,AA,UU
2192 2192 16S 28 925 1391   v4 G:U cWW       Weak T 10.1 0.5 0.1 0.1 88.5             0.1 0.2 0.1   0.1 0.2 5916 GC,GU CG,UA,GU
2248 2248 16S 28 935 1380   v4 A:U cWW       Weak T   13.5 0.1 84.8 0.1 0.1 0.6 0.1 0.1 0.1 0.1 0.2       0.1 0.2 6264 CG,AU CG,UA,AU
2283 2283 16S 29 942 1341   v4 G:U cWW       Weak T 0.1     0.2 98.1                     0.2 1.3 6607 GU  
2339 2339 16S 30 950 1231   v4 U:G cWW       Weak T   0.3 12.1     86.7       0.1       0.2   0.2 0.3 6649 UA,UG UG,CA
2381 2381 16S 31 960 975   v4 U:A No BP       Weak T     61.8 14.8   22.4 0.2   0.1           0.2 0.2 0.3 6871 UA,AU,UG UA,AU
2388 2388 16S 31 961 974   v4 U:A No BP       Weak T 0.1 0.1 66.4 0.1 0.1 16.8 0.3     0.6 0.2 2.1     8.7 4.1 0.3 6856 UA,UG,CU,UC,UU GC,UA,CU
2619 2619 16S 34 1052 1206   v4 U:G cWW       Weak T   0.2 0.7     95.9     0.1 2.6         0.1 0.1 0.3 6733 UG,CA UG,CA
2626 2626 16S 34 1053 1205   v4 G:U No BP       Weak T 2.6     15.1 81.7     0.1       0.1         0.3 6891 GC,AU,GU GU,AC
2647 2647 16S 34 1058 1199   v4 G:U cWW       Weak T 0.7     0.8 95.5     0.1       0.2       2.4 0.3 6900 GU,UU GU,AC
2899 2899 16S 40 1158 1178   v4 C:G No BP       Weak T   81.2 0.4 0.1   0.5       0.1 1.8 0.2   0.1 0.2 0.1 15.2 7138 CG CG,UA,AU
2906 2906 16S 40 1159 1177   v4 U:G No BP       Weak T   5.5 0.2 0.1   73.5 1.5 0.3 1.5 0.4 0.4 0.1 0.1 0.8   0.4 15.2 7135 CG,UG UG,AA,CC
3018 3018 16S 41 1255 1282   v4 G:C cWW       Weak T 69.5   0.1 0.3 0.8   0.1 0.1         0.1       28.8 7218 GC GC,UA,AU
3186 3186 16S 44 1401 1501   v4 G:C cWW       Weak T 98.1     1.2             0.1   0.1   0.1   0.2 3713 GC GC,AU
3319 3319 16S 44 1425 1475   v4 U:G cWW       Weak T 1.9 4.0 5.4 5.4 9.1 24.2 1.3 0.6 25.9 0.2     3.4 2.2 1.1 0.6 14.6 5415 CG,UA,AU,GU,UG,AG,GA,GG UA,GU,AG
3361 3361 16S 44 1435 1466   v4 G:C cWW       Weak T 64.4 0.9 0.2 5.3 8.6 1.5 0.3 1.9 0.1   0.2 0.1 0.9 0.1 0.1 0.1 15.4 5555 GC,AU,GU GC,AU,UG
3403 3403 16S 44 1442 1460   v4 G:C cWW       Weak T 16.7 1.8 3.3 1.3 0.6 1.2 15.8 0.2 0.4 5.7   0.1 28.7 0.4 0.2 2.1 21.5 5635 GC,UA,AA,CA,GA,UU CG,AC,GA,UU
3445 3445 16S 45 1506 1529   v4 U:G No BP       Weak T   0.6 4.6     93.0               0.2 0.5 0.4 0.7 2260 UA,UG  
3480 3480 16S 45 1511 1524   v4 G:C cWW       Weak T 78.4 1.5 0.2 6.9 8.3 0.1   0.3   0.1 0.3 0.1 0.2 0.5     3.1 2480 GC,AU,GU GC,CG,UA,AU
3487 3487 16S 45 1512 1523   v4 U:G cWW       Weak T   0.6 0.4 0.1   96.0     0.2         0.1 0.6 1.4 0.5 2528 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 1101.311ms