The GM_Match table holds one summary row per DNA match in GEDmatch — the kit-to-kit relationship between your kit and another kit, with the shared and largest centimorgan totals and an estimated number of generations. The per-chromosome detail behind these totals lives in GM_Segment.
In this table kita is your (primary) kit — the base kit being gathered — and kitb is the match kit. A match row is written once per kita/kitb pair. Inserts are de-duplicated on that pair, so an existing row is not overwritten on a re-gather.
shared, largest, x_largest, x_shared, and gen, and sets matchdate to the time of the gather. Matches outside the configured minimum/maximum cM range are skipped.shared, largest, and matchdate.icwdate is set on the matching GM_Match row.| Column | Type | Description |
|---|---|---|
| Id | int (PK) | Auto-incrementing primary key |
| kita | string | Your (primary) kit number — the base kit being gathered. References GM_Kit.kit_num. |
| kitb | string | The match kit number. References GM_Kit.kit_num. |
| largest | decimal | Largest shared autosomal segment, in cM. |
| x_largest | decimal | Largest shared X-chromosome segment, in cM. |
| x_shared | decimal | Total shared X-chromosome DNA, in cM. |
| shared | decimal | Total shared autosomal DNA, in cM. |
| gen | decimal | GEDmatch’s estimated number of generations to a common ancestor. |
| matchdate | DateTime | When the match summary was gathered. |
| icwdate | DateTime | When in-common-with data was last gathered for this pair. Set during the ICW stage. |
| segdate | DateTime | Intended to record when segment data was last gathered for this pair. Not assigned by the current gather code. |
segdate exists in the schema but is not written by the current GEDmatch gather code, so it remains at its default value.kita / kitb to names, emails, and haplogroups.icwdate.