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.).
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.
|*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.|