Exercise 10 of 17

Amino acid insertions

Fixed training server

List the 20 most common amino acid insertions in the S protein. For each insertion, show its position, inserted symbols and the number of sequences carrying it, with the most common first.

The output should have this shape:

position | insertedSymbols | count
-------- | --------------- | -----
214      | EPE             | 1234
215      | R               | 987

Write a query and run it. The result is compared with the reference answer without considering row order.

Loading query editor…

Explanation

Use aminoAcidInsertions to count insertions in the S protein. Project the requested columns, order the rows by count and use the inserted symbols and position to order ties, then keep the first 20.

Sequence insertions aminoAcidInsertions

Reference answer

default
  .aminoAcidInsertions(sequenceNames:={S})
  .project({position, insertedSymbols, count})
  .orderBy({count.desc(), insertedSymbols, position})
  .limit(20)