Base-pair statistics by molecule and position

Enter a molecule (5S, 16S or 23S) and a nucleotide position. Returns every base pair that includes that position, with frequencies, covariation scores and one row per taxonomic group. Groups: T = all sequences, 3 = three domains, B = Bacteria, A = Archaea, C = Chloroplast, E = Eukarya, M = Mitochondria (5S has no C/M rows and no collective scores).

Custom SQL query (hide) 

select *
from basepair_combined
where molecule = :molecule
  and (position_1 = :position or position_2 = :position)
order by position_1,
         case group_code when 'T' then 1 when '3' then 2 when 'B' then 3
                         when 'A' then 4 when 'C' then 5 when 'E' then 6
                         when 'M' then 7 else 8 end

Query parameters

Edit SQL

0 results