jodyphelan

from collections import defaultdict
import os
from pathogenprofiler import filecheck
import csv
import pathogenprofiler as pp
from tqdm import tqdm
import json
import ntm_profiler as ntmp
from ntm_profiler.models import ProfileResult, SpeciesResult

jodyphelan

SELECT *, 
row_number() OVER(PARTITION BY QcVariantConsensusID ORDER BY CASE WHEN NCount IS NULL THEN 1 ELSE 0 END, NCount ASC, DateSequencing ASC) AS [rn] 
FROM [Casper].[CTE_exercise]