Base-pair statistics (frequencies and scores together) (view)

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).
sequences
Number of sequences in the group.

35 rows where conformation = "tHS" and molecule = "23S" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: helix_number, position_1, position_2, reference_base_pair, CG, UA, AU, GU, UG, AA, AC, CA, CC, CU, gap, sequences, predominant_types, covarying_types, Xch, Ych, PE, PES, Cov1, Cov3, C1_C3, WC, WCGU, XCons, YCons, DfDel, PNuc

group_code 7

strength 3

tertiary_type 1

molecule 1

  • 23S · 35 ✖

conformation 1

  • tHS · 35 ✖
molecule helix_number position_1 ▼ position_2 reference_base_pair conformation tertiary_type strength group_code GC CG UA AU GU UG AA AC AG CA CC CU GA GG UC UU gap sequences predominant_types covarying_types Xch Ych PE PES Cov1 Cov3 C1_C3 WC WCGU XCons YCons DfDel PNuc
23S 5 53 117 A:G tHS 3°: base pair Significant T   0.4 1.5 2.1     0.8 0.3 66.2         0.1   0.3 28.1 719 AU,AG UA,AG 12 11 6 0.52 0.28 0.94 1.22 0.06 0.06 0.42 0.29 0.01 0.49
23S 5 53 117 A:G tHS 3°: base pair Significant 3   0.5   1.5         97.5         0.2     0.2 405 AG   2 2 0 0.0 0.0 0.0 0.0 0.02 0.02 1.9 1.86 0.0 0.64
23S 5 53 117 A:G tHS 3°: base pair Significant B                 100.0                 252 AG   0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 2.0 0.0 0.77
23S 5 53 117 A:G tHS 3°: base pair Significant A   5.6   11.1         83.3                 36 CG,AU,AG   1 1 0 0.0 0.0 0.0 0.0 0.17 0.17 1.69 1.5 0.0 0.88
23S 5 53 117 A:G tHS 3°: base pair Significant C             6.2   93.8                 81 AA,AG   0 2 0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 1.71 0.0 0.79
23S 5 53 117 A:G tHS 3°: base pair Significant E       1.7         96.6         0.9     0.9 117 AG   1 1 0 0.0 0.0 0.0 0.0 0.02 0.02 1.84 1.79 0.0 0.44
23S 5 53 117 A:G tHS 3°: base pair Significant M   0.4 4.7 3.9     0.4 0.9 2.1             0.9 86.6 233 UA,AU,AG CG,UA,AU 10 7 6 0.71 0.5 0.68 1.18 0.68 0.68 -0.51 -0.56 0.02 0.1
23S 59 1528 1543 A:G tHS 3°: base pair Strong T 5.7 7.2 4.7 11.2 0.6 1.0 0.9 0.2 21.4 0.2 0.1 0.1       1.5 44.9 859 GC,CG,UA,AU,AG GC,UA,AG,CU 18 21 12 0.61 0.31 0.58 0.89 0.52 0.55 -0.74 -0.81 0.0 0.45
23S 59 1528 1543 A:G tHS 3°: base pair Strong 3 10.1 12.2 7.5 19.3 1.0 1.0 0.6 0.4 36.2               11.5 483 GC,CG,UA,AU,AG GC,UA,AG 13 17 12 0.8 0.34 0.61 0.95 0.56 0.58 -0.04 -0.14 0.01 0.68
23S 59 1528 1543 A:G tHS 3°: base pair Strong B 5.3 0.4 12.1   1.1 1.5 1.1 0.8 65.5               12.1 264 GC,UA,AG GC,UA,AG 5 5 3 0.6 0.78 0.94 1.72 0.2 0.23 0.4 0.35 0.0 0.71
23S 59 1528 1543 A:G tHS 3°: base pair Strong A 10.3 61.5     2.6                       25.6 39 GC,CG,GU GC,CG 2 3 3 1.0 0.8 0.97 1.77 0.97 1.0 0.17 0.03 0.0 0.71
23S 59 1528 1543 A:G tHS 3°: base pair Strong C   3.0 4.0 3.0   4.0 5.0   9.0 2.0   1.0       13.0 56.0 100 CG,UA,AU,UG,AA,AG,CA,UU AG,CA,UU 5 4 0 0.0 0.35 0.55 0.9 0.23 0.32 -0.68 -0.83 0.1 0.43
23S 59 1528 1543 A:G tHS 3°: base pair Strong E 17.2 18.9 2.2 51.7 0.6 0.6     1.1               7.8 180 GC,CG,UA,AU GC,CG,UA,AU 6 9 6 0.8 0.94 0.98 1.92 0.98 0.99 0.05 0.14 0.01 0.63
23S 59 1528 1543 A:G tHS 3°: base pair Strong M                     0.4           99.7 276     0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 -0.03 -0.06 0.0 0.0
23S 62 1690 1697 A:G tHS 3°: base pair Strong T       0.4 0.4   10.8   53.5 2.9   0.4 0.1     3.9 27.7 836 AA,AG,CA,UU AG,CA,UU 15 36 10 0.39 0.36 0.83 1.2 0.01 0.01 0.15 -0.16 0.0 0.58
23S 62 1690 1697 A:G tHS 3°: base pair Strong 3         0.7   7.9   80.1 3.1   0.7 0.2     7.2 0.2 458 AA,AG,CA,UU AG,CA,UU 11 19 7 0.47 0.52 0.91 1.43 0.0 0.01 1.33 1.06 0.0 0.72
23S 62 1690 1697 A:G tHS 3°: base pair Strong B             11.1   74.8 2.3           11.5 0.4 262 AA,AG,CA,UU AG,CA,UU 5 11 2 0.25 0.55 0.89 1.44 0.0 0.0 1.33 0.9 0.0 0.8
23S 62 1690 1697 A:G tHS 3°: base pair Strong A         4.9       63.4 17.1   4.9 2.4     7.3   41 GU,AG,CA,CU,GA,UU AG,CA,UU 4 4 4 1.0 0.67 0.88 1.54 0.0 0.05 0.55 0.69 0.0 1.0
23S 62 1690 1697 A:G tHS 3°: base pair Strong C       1.0     46.5   50.5 1.0             1.0 101 AA,AG AG,CA 1 10 1 0.18 0.02 0.0 0.02 0.01 0.01 1.82 0.84 0.0 0.97
23S 62 1690 1697 A:G tHS 3°: base pair Strong E         0.6   4.5   93.5 0.6   0.6           155 AA,AG GU,AG,CA 2 4 1 0.33 0.2 0.0 0.2 0.0 0.01 1.84 1.61 0.0 0.59
23S 62 1690 1697 A:G tHS 3°: base pair Strong M       0.7     2.5   10.5 3.2             83.0 277 AA,AG,CA AG,CA 3 7 2 0.4 0.5 0.81 1.31 0.04 0.04 -0.44 -0.51 0.0 0.15
23S 65 1775 1789 U:A tHS   Weak T   1.0 97.3 0.4     0.1               0.5 0.8   842 UA CG,UA,AU 3 7 1 0.2 0.48 0.99 1.46 0.99 0.99 1.88 1.79 0.0 0.81
23S 65 1775 1789 U:A tHS   Weak 3     98.9       0.2               0.9     458 UA   1 2 0 0.0 0.0 0.0 0.0 0.99 0.99 1.98 1.93 0.0 0.73
23S 65 1775 1789 U:A tHS   Weak B     99.6       0.4                     261 UA   1 0 0 0.0 0.0 0.0 0.0 1.0 1.0 1.96 2.0 0.0 0.8
23S 65 1775 1789 U:A tHS   Weak A     100.0                             41 UA   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 1.0
23S 65 1775 1789 U:A tHS   Weak C     100.0                             101 UA   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.98
23S 65 1775 1789 U:A tHS   Weak E     97.4                       2.6     156 UA,UC   0 2 0 0.0 0.0 0.0 0.0 0.97 0.97 2.0 1.83 0.0 0.59
23S 65 1775 1789 U:A tHS   Weak M   2.8 93.6 1.1                       2.5   283 CG,UA,UU CG,UA,AU 2 5 1 0.29 0.61 0.97 1.59 0.97 0.97 1.73 1.59 0.0 0.91
23S 66 1803 1814 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 9 27 4 0.22 0.61 0.81 1.43 0.04 0.33 -0.16 -0.58 0.02 0.58
23S 66 1803 1814 A:G tHS 3°: base pair Weak 3 0.9 0.7 0.2 0.9 37.3   0.2 2.0 55.9   0.2         0.4 1.3 456 GU,AC,AG UA,GU,AG,CC 6 9 1 0.13 0.88 0.95 1.83 0.03 0.4 0.82 0.69 0.0 0.71
23S 66 1803 1814 A:G tHS 3°: base pair Weak B       0.4     0.4 0.4 98.5               0.4 259 AG   0 3 0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 1.85 0.0 0.79
23S 66 1803 1814 A:G tHS 3°: base pair Weak A         75.6     17.1     2.4         4.9   41 GU,AC,CC,UU GU,AC 2 1 0 0.0 0.7 0.93 1.63 0.0 0.76 0.92 1.29 0.0 1.0
23S 66 1803 1814 A:G tHS 3°: base pair Weak C       4.0     53.5 11.9 29.7               1.0 101 AU,AA,AC,AG   0 10 0 0.0 0.0 0.0 0.0 0.04 0.04 2.0 0.36 0.01 0.97
23S 66 1803 1814 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 4 5 1 0.22 0.42 0.95 1.37 0.07 0.99 1.37 1.3 0.0 0.57
23S 66 1803 1814 A:G tHS 3°: base pair Weak M     1.4 1.8   0.4 3.2 0.4 10.6 0.7   0.4         81.3 283 AA,AG UA,AG,CU 3 8 3 0.55 0.22 0.66 0.88 0.17 0.19 -0.46 -0.57 0.06 0.17

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW basepair_combined as
select f.molecule, f.helix_number, f.position_1, f.position_2,
       f.reference_base_pair, f.conformation, f.tertiary_type, f.strength, f.group_code,
       f.GC, f.CG, f.UA, f.AU, f.GU, f.UG, f.AA, f.AC, f.AG, f.CA, f.CC, f.CU, f.GA, f.GG, f.UC, f.UU, f.gap, f.Seq as sequences,
       f.predominant_types, f.covarying_types,
       s.Xch, s.Ych, s.PE, s.PES, s.Cov1, s.Cov3, s."C1+C3" as C1_C3,
       s.WC, s.WCGU, s.XCons, s.YCons, s.DfDel, s.PNuc
from basepair_frequency f
left join basepair_collective_score s
  on s.molecule = f.molecule and s.position_1 = f.position_1
 and s.position_2 = f.position_2 and s.group_code = f.group_code;