Genomic Variant Frequency Clustering Algorithm

Create an advanced SQL query that performs hierarchical clustering of genetic variants using Euclidean distance metrics. The analysis should process large-scale genomic datasets from multiple research populations, calculate variant frequencies, and generate dendrograms. Implement recursive common table expressions (CTEs) to handle complex genetic inheritance patterns and produce a normalized frequency matrix with statistical significance thresholds.