Official websites use .gov
A
.gov website belongs to an official
government organization in the United States.
Secure .gov websites use HTTPS
A lock (
) or https:// means you've safely
connected to the .gov website. Share sensitive
information only on official, secure websites.
ND Genotypes materialized view implementation. Mview_ndg_variants (left) contains all variant locations providing support for multiple genome assemblies without duplicating the allele data stored in mview_ndg_calls (right). Both these materialized views pull data from several Chado tables (center, blue) to prevent table joins in user-triggered queries. There are numerous foreign keys in these materialized views to allow retrieval of infrequently required metadata.
