HelpDatabase Reference › GM_Kit

GM_Kit Table

The GM_Kit table is the kit registry for GEDmatch data. Each row is one DNA kit known to the database — the base kit you are gathering for as well as every kit it matches. It stores the human-readable details for a kit (name, sex, email, haplogroups) and any WikiTree linkage, so that the kit numbers stored in the match, segment, ICW, and triangulation tables can be resolved back to people.

GEDmatch gathering is currently unavailable in the Client and is expected to return in a future update. This page documents the schema and the behavior of the existing gather code as written.

How It Is Populated

A kit row is created the first time a kit number is encountered during a gather. Inserts are de-duplicated on kit_num — if a row already exists for that kit number, the new record is ignored rather than overwriting the stored values. Kits are written from several stages:

  • Match list — the richest source. Populates kit_num, name, sex, email, mtHaplo, YHaplo, Source, WTId, WTNameID, and k2. The base (your) kit is added with just kit_num, name, and email.
  • Segment search — adds match kits with kit_num, name, email, and sex.
  • AutoSegment / cluster nodes — adds match kits with kit_num, name, and email only.

If a kit has no name, the email address is stored in name as a fallback.

Column Reference

ColumnTypeDescription
Idint (PK)Auto-incrementing primary key
kit_numstringThe GEDmatch kit number (e.g., “A555520”). This is the value referenced as kita / kitb in the other GEDmatch tables.
namestringDisplay name for the kit. Falls back to the email address when no name is available.
sexstringReported sex of the kit owner.
WTIdintWikiTree numeric ID. Used to link the kit to a WikiTree profile. 0 when not linked.
WTNameIDstringWikiTree name ID (the WikiTree profile slug). Drives optional WikiTree tree gathering.
emailstringContact email for the kit owner.
id_gedstringGEDCOM identifier for the kit. Not assigned by the current gather code.
mtHaplostringMitochondrial (maternal) haplogroup.
YHaplostringY-chromosome (paternal) haplogroup. Populated only for male kits that report one.
familyIDintFamily identifier. Not assigned by the current gather code.
gedIDintGEDCOM record identifier. Not assigned by the current gather code.
k2intGEDmatch internal kit flag carried through from the match list response.
kittypeintKit type code. Not assigned by the current gather code.
SourcestringThe originating testing company / upload source reported by GEDmatch for this kit.
Columns id_ged, familyID, gedID, and kittype exist in the schema but are not written by the current GEDmatch gather code, so they remain at their default values (empty / 0).

Related Tables

  • GM_Match — match-level summary between two kits; kita and kitb reference GM_Kit.kit_num.
  • GM_Segment — shared DNA segments between two kits.
  • GM_ICW — in-common-with links between kits.