Now let me build the matchup matrices for the top archetypes in each format. I'll focus on Modern first (top 8), then do Standard, Pioneer, and Legacy in parallel.
The match-level join isn't resolving individual matchup results, likely because matches are stored with an entry_id and opponent_entry_id but the mirror=0 filter may be blocking it. Let me try using the dedicated matchup tool instead, and also check match data structure.
Good, opponent_entry_id is populated. The issue was the JOIN condition on tournaments - let me fix the query to join through the correct entry's tournament.
All four matchup matrices are in. Now let me grab sources for each format.
Here is the full consolidated metagame snapshot from May 18 to July 28, 2026, covering Modern, Standard, Pioneer, and Legacy. All matchup matrices show winrate % from the row archetype's perspective (mirrors excluded).
MODERN (189 tournaments, 5,592 entries across top 20 archetypes)
META SHARE & WINRATE (top 8, excl. mirrors)
Archetype | Presence | WR%
Boros Energy | 10.42% | 50.4%
Affinity | 9.04% | 50.9%
Goryo Reanimator | 6.85% | 48.9%
Prowess | 6.29% | 50.9%
Broodscale | 6.17% | 53.5%
Tron | 5.81% | 48.6%
Azorius Control | 4.60% | 51.1%
Ruby Storm | 4.01% | 49.4%
MATCHUP MATRIX - MODERN (row vs column, winrate %)
Row \ Col | Affin | Az Ctrl | Bor En | Brood | Goryo | Prowss | Ruby | Tron
Affinity | --- | 54.9 | 45.3 | 32.7 | 58.4 | 59.8 | 36.1 | 50.4
Azorius Ctrl | 45.1 | --- | 53.7 | 50.0 | 50.7 | 38.2 | 73.9 | 55.8
Boros Energy | 54.7 | 46.3 | --- | 53.6 | 42.3 | 37.5 | 52.1 | 60.1
Broodscale | 67.3 | 50.0 | 46.4 | --- | 52.8 | 50.0 | 41.9 | 56.0
Goryo Reanim | 41.6 | 49.3 | 57.7 | 47.2 | --- | 53.9 | 60.7 | 43.3
Prowess | 40.2 | 61.8 | 62.5 | 50.0 | 46.1 | --- | 63.5 | 32.9
Ruby Storm | 63.9 | 26.1 | 47.9 | 58.1 | 39.3 | 36.5 | --- | 39.3
Tron | 49.6 | 44.2 | 39.9 | 44.0 | 56.7 | 67.1 | 60.7 | ---
Key Modern takeaways: Broodscale is the clearest overperformer relative to meta share, crushing Affinity (67.3%) while holding its own elsewhere. Prowess punishes Boros Energy hard (62.5%) and Tron absolutely hates Prowess (67.1% for Tron). Azorius Control is the natural Prowess foil (61.8%) but gets dominated by Ruby Storm (only 26.1%). Ruby Storm is a liability into Azorius Control and struggles with Prowess, but crushes Affinity (63.9%).
STANDARD (121 tournaments, 5,107 entries across top 20 archetypes)
META SHARE & WINRATE (top 8, excl. mirrors)
Archetype | Presence | WR%
Izzet Prowess | 23.33% | 52.3%
Jeskai Control | 9.52% | 47.6%
Mono Green Landfall | 7.38% | 54.5%
Izzet Spellementals | 6.89% | 51.3%
Dimir Excruciator | 6.54% | 48.2%
Jeskai Lessons | 5.10% | 54.5%
Azorius Momo | 4.74% | 49.6%
Mardu Discard | 4.32% | 49.0%
MATCHUP MATRIX - STANDARD (row vs column, winrate %)
Row \ Col | Az Momo | Dim Exc | Iz Prws | Iz Spl | Jsk Ctrl | Jsk Les | Mrd Dis | MG Land
Azorius Momo | --- | 44.7 | 56.1 | 39.7 | 36.4 | 27.9 | 72.6 | 44.8
Dimir Excruciator| 55.3 | --- | 44.9 | 58.4 | 51.8 | 42.0 | 41.5 | 42.2
Izzet Prowess | 43.9 | 55.1 | --- | 49.6 | 60.1 | 44.3 | 55.3 | 44.8
Izzet Spellementals| 60.3 | 41.6 | 50.4 | --- | 46.9 | 44.4 | 50.0 | 56.2
Jeskai Control | 63.6 | 48.2 | 39.9 | 53.1 | --- | 39.5 | 36.4 | 31.1
Jeskai Lessons | 72.1 | 58.0 | 55.7 | 55.6 | 60.5 | --- | 53.1 | 44.2
Mardu Discard | 27.4 | 58.5 | 44.7 | 50.0 | 63.6 | 46.9 | --- | 44.8
Mono G Landfall | 55.2 | 57.8 | 55.2 | 43.8 | 68.9 | 55.8 | 55.2 | ---
Key Standard takeaways: Izzet Prowess at 23% presence is the clear pillars of the format but faces real pressure from Mono Green Landfall (55.2% against it) and Jeskai Lessons (55.7%). Jeskai Lessons has the best overall matrix - winning into nearly everything except Mono Green and Mardu. Mono Green Landfall is the boogeyman, thrashing Jeskai Control (68.9%) and being broadly positive across 6 of 7 matchups. Jeskai Control is badly positioned, losing to both top green decks heavily.
PIONEER (79 tournaments, 1,940 entries across top 20 archetypes)
META SHARE & WINRATE (top 8, excl. mirrors)
Archetype | Presence | WR%
Golgari Midrange | 11.65% | 51.0%
Mono Red Aggro | 10.53% | 46.8%
Izzet Prowess | 8.34% | 51.4%
Azorius Control | 7.36% | 50.2%
Phoenix | 6.86% | 51.9%
Dimir Ninjas | 6.85% | 51.8%
Abzan Greasefang | 6.05% | 52.7%
Orzhov Greasefang | 4.84% | 50.1%
MATCHUP MATRIX - PIONEER (row vs column, winrate %)
Row \ Col | Ab GF | Az Ctrl | Dim Nin | GB Mid | Iz Prws | MR Agg | Orz GF | Phoenix
Abzan Greasefang| --- | 60.6 | 58.3 | 47.5 | 52.6 | 53.6 | 60.0 | 51.4
Azorius Control | 39.4 | --- | 28.3 | 51.8 | 50.0 | 67.1 | 45.2 | 53.0
Dimir Ninjas | 41.7 | 71.7 | --- | 54.8 | 62.0 | 58.8 | 58.6 | 42.2
Golgari Midrange| 52.5 | 48.2 | 45.2 | --- | 59.6 | 54.0 | 58.7 | 35.5
Izzet Prowess | 47.4 | 50.0 | 38.0 | 40.4 | --- | 61.9 | 52.8 | 59.0
Mono Red Aggro | 46.4 | 32.9 | 41.3 | 46.0 | 38.1 | --- | 37.9 | 57.6
Orzhov Greasefang| 40.0 | 54.8 | 41.4 | 41.3 | 47.2 | 62.1 | --- | 52.8
Phoenix | 48.6 | 47.0 | 57.8 | 64.5 | 41.0 | 42.4 | 47.2 | ---
Key Pioneer takeaways: Abzan Greasefang is the standout - positive vs 6 of 7 matchups with only Golgari Midrange giving it trouble. Dimir Ninjas has an absurd Azorius Control matchup (71.7%) and is broadly positive against the field except Phoenix (42.2%) and Abzan GF. Phoenix is the Golgari Midrange predator (64.5%), which is relevant given GB Mid's top meta-share position. Mono Red Aggro is the format punching bag: negative in 6 of 7 tracked matchups.
LEGACY (94 tournaments, 1,269 entries across top 20 archetypes)
META SHARE & WINRATE (top 8, excl. mirrors)
Archetype | Presence | WR%
Show and Tell | 6.97% | 50.4%
Izzet Delver | 6.59% | 47.0%
Dimir Tempo | 6.56% | 50.8%
Tron | 6.53% | 51.7%
Energy | 5.98% | 49.3%
Doomsday | 5.09% | 55.6%
Grixis Reanimator | 5.07% | 52.2%
Azorius Midrange | 4.36% | 53.2%
MATCHUP MATRIX - LEGACY (row vs column, winrate %)
Row \ Col | Az Mid | Dim Tmp | Doomsd | Energy | Grx Rea | Iz Dlvr | Show&Tell | Tron
Azorius Midrange| --- | 41.3 | 50.0 | 45.2 | 52.6 | 54.5 | 61.5 | 62.5
Dimir Tempo | 58.7 | --- | 62.2 | 42.9 | 64.7 | 65.9 | 56.8 | 40.0
Doomsday | 50.0 | 37.8 | --- | 73.5 | 56.3 | 55.6 | 61.1 | 57.1
Energy | 54.8 | 57.1 | 26.5 | --- | 46.4 | 64.8 | 36.4 | 41.9
Grixis Reanimat.| 47.4 | 35.3 | 43.8 | 53.6 | --- | 64.3 | 61.0 | 54.3
Izzet Delver | 45.5 | 34.1 | 44.4 | 35.2 | 35.7 | --- | 47.6 | 53.3
Show and Tell | 38.5 | 43.2 | 38.9 | 63.6 | 39.0 | 52.4 | --- | 47.8
Tron | 37.5 | 60.0 | 42.9 | 58.1 | 45.7 | 46.7 | 52.2 | ---
Key Legacy takeaways: Doomsday is heavily underrepresented relative to its winrate (55.6%), punishing Energy with a 73.5% winrate. Dimir Tempo is a nightmare for fair decks (64.7% vs Grixis Reanim, 65.9% vs Izzet Delver) but collapses vs Doomsday and Tron. Izzet Delver is struggling across the board - it is negative into 5 of 7 matchups and has the lowest overall winrate at 47.0%. Energy is a good Izzet Delver killer (64.8%) but is nearly unplayable vs Doomsday (26.5%).
SOURCES
Modern (189 tournaments, 64.6% MTGO / 35.4% Melee):
https://www.mtgo.com/decklist/modern-challenge-64-2026-07-2612848217
https://melee.gg/Decklist/View/645c1234-0fd4-4678-88cb-b492016441f7
Standard (121 tournaments, 66.1% MTGO / 33.9% Melee):
https://www.mtgo.com/decklist/standard-challenge-32-2026-07-2612848225
https://melee.gg/Decklist/View/2f7ca232-72d9-4ace-bf29-b49300734c71
Pioneer (79 tournaments, 86.1% MTGO / 13.9% Melee):
https://www.mtgo.com/decklist/pioneer-challenge-32-2026-07-2612848219
https://melee.gg/Decklist/View/942bbcf8-8900-4efd-be79-b4930079896b
Legacy (94 tournaments, 54.3% MTGO / 45.7% Melee):
https://www.mtgo.com/decklist/legacy-challenge-32-2026-07-2612848220
https://melee.gg/Decklist/View/e6051623-1250-4f72-a400-b49201035ad5