VCF Loader
Overview
VCF Loader ingests Variant Call Format (VCF) files into a database. The input VCF files are loaded into a Parquet-format database that can be queried using Spark SQL.
The input VCF for every run can be a single VCF file or many VCF files, but the merged input must represent a single logical VCF file. In the many-file case, the logical VCF may be partitioned by chromosome, genomic region, sample, or a combination of these strategies. Every input VCF file must be a syntactically correct, sorted VCF file. If the files are partitioned by sample, set is_sample_partitioned to true. If you run VCF Loader through another workflow, confirm the partitioning rules supported by that workflow because they can be more restrictive than the standalone app.
VCF Preprocessing
Although VCF data can be loaded into Apollo databases after the variant call step, the dataset may not be normalized for downstream analyses across large cohorts. In that case, we recommend you complete preprocessing before loading so the data is harmonized for downstream use. To learn more, see VCF Preprocessing.
How to Run VCF Loader
Input:
vcf_manifest: (file) a text file containing a list of file IDs of the VCF files to load (one per line). The referenced file names must be distinct and end in.vcf.gz. If more than one file is specified, then the complete VCF file to load is considered to be partitioned and every specified partition must be a valid VCF file. After the partition-merge step in preprocessing, the complete VCF file must still be valid. If the partitions split the sample set for the same loci, setis_sample_partitionedtotrue.
Required Parameters:
database_name: (string) name of the database into which to load the VCF files.create_mode: (string)strictmode creates a database and tables from scratch andoptimisticmode creates a database and tables if they do not already exist.insert_mode: (string)appendappends data to the end of tables andoverwriteis equivalent to truncating the tables and then appending to them.run_mode: (string)sitemode processes only the site-specific data,genotypemode processes genotype-specific data and other non-site-specific data andallmode processes both types of data.etl_spec_id: (string) Only thegenomics-phenotypeschema choice is supported.is_sample_partitioned: (boolean) set totruewhen the input files are partitioned across different sample subsets for the same logical VCF. Leave this asfalsewhen the files are partitioned only by chromosome or genomic region.
Other Options:
snpeff: (boolean) defaulttrue-- whether to include the SnpEff annotation step in preprocessing withINFO/ANNtags. If you want SnpEff annotations in the database, then either pre-annotate the raw VCF, or include this SnpEff annotation step — it is not necessary to do both.snpeff_human_genome: (string) defaultGRCh38.92-- ID of the SnpEff human genome to use in the SnpEff annotation step in preprocessing.snpeff_opt_no_upstream: (boolean) defaulttrue-- exclude SnpEff upstream gene annotations in the SnpEff annotation step (equivalent to SnpEff's-no-upstreamoption). This option does not filter pre-calculated annotations outside of the SnpEff annotation step.snpeff_opt_no_downstream: (boolean) defaulttrue-- exclude SnpEff downstream gene annotations in the SnpEff annotation step (equivalent to SnpEff's-no-downstreamoption). This option does not filter pre-calculated annotations outside of the SnpEff annotation step.calculate_worst_effects: (boolean) defaulttrue-- whether to include the SnpEff worst-effects annotation step in preprocessing, which adds the SnpEff worst-effects for every alternate-allele--gene combination asINFO/ANN_WORSTtags (Number "A"). This option automatically filters SnpEff annotations to excludefeature_type!=transcript,transcript_biotype!=protein_coding,effect=upstream_gene_variantandeffect=downstream_gene_variant.calculate_locus_frequencies: (boolean) defaulttrue-- whether to include the locus-level frequencies annotation step in preprocessing, which adds locus-level allele and genotype frequencies as INFO tags.snpsift: (boolean) defaulttrue-- whether to include the SnpSift/dbSNP annotation step in preprocessing. The SnpSift/dbSNP annotation step adds dbSNP ID annotations to theINFO/RSIDtag (Number "A"), which is required in the ETL stage. If the raw VCF is already pre-annotated, then this annotation step is not necessary.num_init_partitions: (integer) Number of partitions for the initial VCF-line Spark RDD.
Basic Run
Last updated
Was this helpful?