Family Finder raw results files are comma-separated-variable (CSV) files. We compress them into GZ (zipped) files for storage and portability. To extract the CSV file from the GZ file, you will need compression/decompression software to unzip the file. Many such programs are available at no charge. A few are:

  • 7-Zip (Windows)
  • PeaZip (Windows and Linux)
  • The Unarchiver (MAC)

Once you have extracted a CSV file, you can open it with a text-editing program (Notepad, jEdit, etc.)

RSID,CHROMOSOME,POSITION,RESULT
"rs3131972","1","742584","TT"
"rs12562034","1","758311","CC"
"rs12124819","1","766409","CT"
"rs11240777","1","788822","AG"
"rs6681049","1","789870","TT"
...

or a spreadsheet program (MS Excel, OpenOffice Calc, Gnumeric, Lotus, etc.).

A B C D
1 RSID CHROMOSOME POSITION RESULT
2 rs3131972 1 742584 TT
3 rs12562034 1 758311 CC
4 rs12124819 1 766409 CT
5 rs11240777 1 788822 AG
6 rs6681049 1 789870 TT

 

The results files contain the following four data columns:

  • RSID – The RSID column provides the RS number for the SNP in the NIH dbSNP database.
  • CHROMOSOME – The CHROMOSOME column provides the name of the chromosome where the SNP is located. For an autosomal file, that is 1 through 22. For an X-chromosome file, that is X.
  • POSITION – The POSITION column provides the specific location on the specified chromosome of the SNP.
  • RESULT – The RESULT column provides the allele values for the SNP.

These tables show the possible values for the RESULT column and their meanings. We report results according to each microarray chip maker’s specifications.

Illumina OmniExpress Results
Result* Allele Value Meaning
*For men, the X-chromosome raw data file shows doubled values (DD, II, AA, CC, GG, or TT) as placeholders even though in reality they only have one X chromosome.
DD deletion, deletion There are two copies of the deletion. This is a homozygous value.
II insertion, insertion There are two copies of the insertion. This is a homozygous value.
DI deletion, insertion There is one copy of the deletion and one copy of the insertion variant. This is a heterozygous value.
AA Adenine, Adenine There are two copies of the adenine variant. This is a homozygous value.
CC Cytosine, Cytosine There are two copies of the cytosine variant. This is a homozygous value.
GG Guanine, Guanine There are two copies of the guanine variant. This is a homozygous value.
TT Thymine, Thymine There are two copies of the thymine variant. This is a homozygous value.
CT or TC Cytosine, Thymine There is one copy of the cytosine and one copy of the thymine variant. This is a heterozygous value.
AG or GA Adenine, Guanine There is one copy of the adenine and one copy of the guanine variant. This is a heterozygous value.
no call The results were not clear for this SNP. A small percentage of results like this are expected from microarray chips.