I am in the process of building a relational structure for a pedigree (family tree on Ancestry, synched to RM11) to enable efficient DNA IBD (Identical by Descent) segregation analysis (what many call “DNA sharing”). My bioinformatics platform is GENLIB (R) which can deliver kinship coefficients, genetic contribution values from ancestors, and has an amazing gene dropping simulation (gen.simuHaplo). QUESTION FOR RM11 USERS: I will use the RIN from RM11 as the primary key identifier (AncestryPersonID) in my tbl_Person, but what is the best equivalent I can get from Ancestry? I know about Ancestry GUID (which my genea assistant can deliver via a downloaded .csv) but does anyone know what is Ancestry’s best equivalent to RM11’s RIN? I want to avoid copy/paste if possible. Hoping someone has an easy clean solution.
The AncestryTable in the RM database has a link between the RIN and the Ancestry GUID for LinkType = 0. Not sure if there’s any automated way to use that through the RM UI but you may be able to create a fact type for it using some SQL.
I would actually create a unique number and as Keith said create a fact for it ( actually just use the fact Reference #)–which can be upload automatically to Ancestry-- you can get really elaborate with your reference # or just use the RIN # you have in RM 11-- and yes it will take a lot of work to add them all to Ancestry ( I would do it in small batches) BUT a lot less work then having your RIN # change in RM 11 due to a corrupt database etc and having to start all over
The equivalent to the Ancestry UID is the UniqueID column of the Person Table which follows the individual even if their RIN changes during certain operations between databases. Additionally, there’s the rmID and anID columns that are side by side in the Ancestry Table as a result of TreeShare.
Thanks to Keith Stone and Nancy Kessler for such quick replies and helpful suggestions.