Load all GREGoR VCFs

[quinnwai]

Some work, even if just "waiting", to load each GREGoR VCF. Will need to actually load all of the VCFs into the node. Mainly to ensure we can do this 20-or-so times and also that we're not tripped up by edge cases. Could likely also front-load any problems here by just generally checking the consistency of each VCFs format across GREGoR.

Could be lumped into the load VCF epic as final testing step or separate.

Acceptance Criteria

For 5-10 variants in each VCFs...

• Able to query the variants in non-VRS format (gnomad) and get a VRS hit in db
• When ask for CAF for variant expressed as gnomad, get response that matches the annotation in original VCF
• -When ask for CAF for variant expressed as VRS, get response that matches the annotation in original VCF

[korikuzma]

In the GREGoR meeting, I believe we discussed that loading chr22 + chrY was acceptable for MVP. I know @jsstevenson was working on doing this, James assuming this is the corresponding ticket, would you assign yourself to this? Otherwise, disregard

[korikuzma]

From dev meeting: @jsstevenson says we have everything from chr3 onward. He's creating dumps and plans on storing this in a bucket

First load RDS instances from dump file. Once this is live, on a dev instance we can try putting up long running process to load the aws instance

[jsstevenson]

theoretically, when the dumps need to be loaded:

createdb anyvar_gregor
pg_restore -d anyvar_gregor -v anyvar_db_2026-01-23-allbutchr1,2.dump

[jsstevenson]

This is done btw