Loading required namespace: GenomicFiles Using local VCF. File already tabix-indexed. Finding empty VCF columns based on first 10,000 rows. 1 sample detected: EBI-a-GCST005848 Constructing ScanVcfParam object. VCF contains: 14,615,800 variant(s) x 1 sample(s) Reading VCF file: multi-threaded (4 threads) Renaming ID as SNP. VCF file has -log10 P-values; these will be converted to unadjusted p-values in the 'P' column. No INFO (SI) column detected. Standardising column headers. First line of summary statistics file: SNP chr BP end REF ALT FILTER ReverseComplementedAlleles ES LP SE P Summary statistics report: - 14,596,801 rows - 14,576,268 unique variants - 4,050 genome-wide significant variants (P<5e-8) - 22 chromosomes Checking for multi-GWAS. Checking for multiple RSIDs on one row. Inferring genome build. Loading SNPlocs data. Loading reference genome data. Preprocessing RSIDs. Validating RSIDs of 10,000 SNPs using BSgenome::snpsById... Loading required package: BiocGenerics Attaching package: ‘BiocGenerics’ The following objects are masked from ‘package:stats’: IQR, mad, sd, var, xtabs The following objects are masked from ‘package:base’: anyDuplicated, aperm, append, as.data.frame, basename, cbind, colnames, dirname, do.call, duplicated, eval, evalq, Filter, Find, get, grep, grepl, intersect, is.unsorted, lapply, Map, mapply, match, mget, order, paste, pmax, pmax.int, pmin, pmin.int, Position, rank, rbind, Reduce, rownames, sapply, setdiff, sort, table, tapply, union, unique, unsplit, which.max, which.min Loading required package: S4Vectors Loading required package: stats4 Attaching package: ‘S4Vectors’ The following objects are masked from ‘package:base’: expand.grid, I, unname BSgenome::snpsById done in 27 seconds. Loading SNPlocs data. Loading reference genome data. Preprocessing RSIDs. Validating RSIDs of 10,000 SNPs using BSgenome::snpsById... BSgenome::snpsById done in 35 seconds. Inferred genome build: GRCH37 Checking SNP RSIDs. Checking for merged allele column. Checking A1 is uppercase Checking A2 is uppercase Checking for incorrect base-pair positions Ensuring all SNPs are on the reference genome. Loading SNPlocs data. Loading reference genome data. Preprocessing RSIDs. Validating RSIDs of 14,576,268 SNPs using BSgenome::snpsById... BSgenome::snpsById done in 369 seconds. 97,989 SNPs are not on the reference genome. These will be corrected from the reference genome. Loading SNPlocs data. Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/logs/snp_not_found_from_chr_bp.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. Loading SNPlocs data. Loading reference genome data. Preprocessing RSIDs. Validating RSIDs of 14,501,425 SNPs using BSgenome::snpsById... BSgenome::snpsById done in 275 seconds. Checking for correct direction of A1 (reference) and A2 (alternative allele). There are 395 SNPs where neither A1 nor A2 match the reference genome. These will be removed. Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/logs/alleles_dont_match_ref_gen.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. There are 151 SNPs where A1 doesn't match the reference genome. These will be flipped with their effect columns. Reordering so first three column headers are SNP, CHR and BP in this order. Reordering so the fourth and fifth columns are A1 and A2. Checking for missing data. Checking for duplicate columns. Checking for duplicate SNPs from SNP ID. 20,323 RSIDs are duplicated in the sumstats file. These duplicates will be removed Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/logs/dup_snp_id.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. Checking for SNPs with duplicated base-pair positions. 3 base-pair positions are duplicated in the sumstats file. These duplicates will be removed. Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/logs/dup_base_pair_position.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. INFO column not available. Skipping INFO score filtering step. Filtering SNPs, ensuring SE>0. Ensuring all SNPs have N<5 std dev above mean. Checking for bi-allelic SNPs. 390,487 SNPs are non-biallelic. These will be removed. Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/logs/snp_bi_allelic.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. Computing Z-score from P using formula: `sign(BETA)*sqrt(stats::qchisq(P,1,lower=FALSE)` Warning: When method is an integer, must be >0. Sorting coordinates with 'data.table'. Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/ebi-a-GCST005848.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Loading required namespace: GenomicFiles Using local VCF. File already tabix-indexed. Finding empty VCF columns based on first 10,000 rows. 1 sample detected: EBI-a-GCST005848 Constructing ScanVcfParam object. VCF contains: 14,615,800 variant(s) x 1 sample(s) Reading VCF file: multi-threaded (4 threads) Renaming ID as SNP. VCF file has -log10 P-values; these will be converted to unadjusted p-values in the 'P' column. No INFO (SI) column detected. Standardising column headers. First line of summary statistics file: SNP chr BP end REF ALT FILTER ReverseComplementedAlleles ES LP SE P Summary statistics report: - 14,596,801 rows - 14,576,268 unique variants - 4,050 genome-wide significant variants (P<5e-8) - 22 chromosomes Checking for multi-GWAS. Checking for multiple RSIDs on one row. Inferring genome build. Loading SNPlocs data. Loading reference genome data. Preprocessing RSIDs. Validating RSIDs of 10,000 SNPs using BSgenome::snpsById... Loading required package: BiocGenerics Attaching package: ‘BiocGenerics’ The following objects are masked from ‘package:stats’: IQR, mad, sd, var, xtabs The following objects are masked from ‘package:base’: anyDuplicated, aperm, append, as.data.frame, basename, cbind, colnames, dirname, do.call, duplicated, eval, evalq, Filter, Find, get, grep, grepl, intersect, is.unsorted, lapply, Map, mapply, match, mget, order, paste, pmax, pmax.int, pmin, pmin.int, Position, rank, rbind, Reduce, rownames, sapply, setdiff, sort, table, tapply, union, unique, unsplit, which.max, which.min Loading required package: S4Vectors Loading required package: stats4 Attaching package: ‘S4Vectors’ The following objects are masked from ‘package:base’: expand.grid, I, unname BSgenome::snpsById done in 96 seconds. Loading SNPlocs data. Loading reference genome data. Preprocessing RSIDs. Validating RSIDs of 10,000 SNPs using BSgenome::snpsById... BSgenome::snpsById done in 65 seconds. Inferred genome build: GRCH37 Checking SNP RSIDs. Checking for merged allele column. Checking A1 is uppercase Checking A2 is uppercase Checking for incorrect base-pair positions Ensuring all SNPs are on the reference genome. Loading SNPlocs data. Loading reference genome data. Preprocessing RSIDs. Validating RSIDs of 14,576,268 SNPs using BSgenome::snpsById... BSgenome::snpsById done in 154 seconds. 97,989 SNPs are not on the reference genome. These will be corrected from the reference genome. Loading SNPlocs data. Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/logs/snp_not_found_from_chr_bp.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. Loading SNPlocs data. Loading reference genome data. Preprocessing RSIDs. Validating RSIDs of 14,501,425 SNPs using BSgenome::snpsById... BSgenome::snpsById done in 249 seconds. Checking for correct direction of A1 (reference) and A2 (alternative allele). There are 395 SNPs where neither A1 nor A2 match the reference genome. These will be removed. Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/logs/alleles_dont_match_ref_gen.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. There are 151 SNPs where A1 doesn't match the reference genome. These will be flipped with their effect columns. Reordering so first three column headers are SNP, CHR and BP in this order. Reordering so the fourth and fifth columns are A1 and A2. Checking for missing data. Checking for duplicate columns. Checking for duplicate SNPs from SNP ID. 20,323 RSIDs are duplicated in the sumstats file. These duplicates will be removed Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/logs/dup_snp_id.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. Checking for SNPs with duplicated base-pair positions. 3 base-pair positions are duplicated in the sumstats file. These duplicates will be removed. Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/logs/dup_base_pair_position.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. INFO column not available. Skipping INFO score filtering step. Filtering SNPs, ensuring SE>0. Ensuring all SNPs have N<5 std dev above mean. Checking for bi-allelic SNPs. 390,487 SNPs are non-biallelic. These will be removed. Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/logs/snp_bi_allelic.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. Computing Z-score from P using formula: `sign(BETA)*sqrt(stats::qchisq(P,1,lower=FALSE)` Sorting coordinates with 'data.table'. Sorting coordinates with 'data.table'. Writing in tabular format ==> /rds/general/project/neurogenomics-lab/ephemeral/MAGMA_Files_Public/data/GWAS_munged/ebi-a-GCST005848/ebi-a-GCST005848.tsv Writing uncompressed instead of gzipped to enable tabix indexing. Converting full summary stats file to tabix format for fast querying... Reading header. Ensuring file is bgzipped. Tabix-indexing file. Removing temporary .tsv file. Summary statistics report: - 14,110,540 rows (96.7% of original 14,596,801 rows) - 14,110,540 unique variants - 3,875 genome-wide significant variants (P<5e-8) - 22 chromosomes Done munging in 31.378 minutes. Successfully finished preparing sumstats file, preview: Reading header. SNP CHR BP A1 A2 END FILTER REVERSECOMPLEMENTEDALLELES 1: rs575961614 1 15850 G A 15850 PASS FALSE 2: rs555382915 1 15893 T C 15893 PASS FALSE 3: rs10399793 1 49298 T C 49298 PASS FALSE 4: rs2462492 1 54676 C T 54676 PASS FALSE 5: rs3107975 1 55326 T C 55326 PASS FALSE BETA LP SE P Z 1: 0.06586440 1.698970 0.02835080 0.0200000 2.3263479 2: 0.00928998 0.537602 0.00886345 0.2900000 1.0581216 3: 0.01249890 0.657577 0.01025970 0.2200002 1.2265277 4: -0.00529986 0.214670 0.01026180 0.6100002 -0.5100731 5: 0.02368760 0.187087 0.05248910 0.6499995 0.4537629