Fix get sequencing groups by analysis IDs

[illusional]

• Add test to model failure case
• Change inner to left join to catch (most common) case where sequencing groups doesn't have any external ID.

[codecov-commenter]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 80.19%. Comparing base (59848bb) to head (b530aef). Report is 1 commits behind head on dev.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## dev #850 +/- ## ========================================== + Coverage 80.02% 80.19% +0.17% ========================================== Files 169 169 Lines 14326 14338 +12 ========================================== + Hits 11465 11499 +34 + Misses 2861 2839 -22 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.