get_direct_ancestors: Get direct ancestors for supplied IDs.

In rmsharp/animalr: Provides Useful Functions for the SNPRC Animal Database

Description

Get direct ancestors for supplied IDs.

Usage

get_direct_ancestors(conn, ids)

Arguments

conn	database connection object
ids	character vector of individual ids

Value

A dataframe with all direct ancestors for Ids provided.

Takes a database connection and a character vector of animal Ids and retrieves the direct ancestors for each id. All returned rows represent a unique individual. The SQL gets animals until there are no new parents. That is the sires and dams are NULL for the progenitors. gets immediate parents for one individual : –SELECT * FROM dbo.f_get_pedigree(' 30145')

rmsharp/animalr documentation built on March 10, 2021, 1:12 p.m.