By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| AnimalId | MarkerId | Allele1 | Allele2 |
|---|---|---|---|
| 1 | OAR1 | A | G |
| 1 | OAR2 | C | C |
| 1 | OAR3 | T | G |
| 2 | OAR1 | A | C |
| 2 | OAR2 | C | C |
| 2 | OAR3 | A | C |
| 3 | OAR1 | A | G |
| 3 | OAR2 | C | G |
| AnimalIdPair | MarkerId | MatchPercentage |
|---|---|---|
| 1-2 | OAR1 | 50 |
| 1-2 | OAR2 | 100 |
| 1-2 | OAR3 | 0 |
| 1-3 | OAR1 | 100 |
| 1-3 | OAR2 | 50 |
| 1-3 | OAR3 | 0 |
| 2-3 | OAR1 | 50 |
| 2-3 | OAR2 | 50 |
| 2-3 | OAR3 | 0 |