Evo2 Variant Effect Database

Database & SQL — inspect the same scored variants and original fields used throughout Evo2VED.

evo2

Data license: Apache License 2.0

Custom SQL query

Queries

Tables

allele_age

rsid, geva, age_median, sds

5,022,171 rows

gwas_assoc

study_id, rsid, p_value

31,410,052 rows

gwas_import_log

study_id, source_file, total_variants, matched_variants, unmatched_variants, matched_rate, min_p, n_p_lt_5e_8, n_p_lt_1e_5, import_time, status, message

4,772 rows

gwas_studies

study_id, cohort, trait_name, trait_file_name, phenotype_category, description, sample_size, case_number, control_number, ancestry, pmid, publication, publication_year, source_zip_file, notes

4,772 rows

region_sets

set_name, chrom, start, end

2,734 rows

screen_annotation_metadata

key, value

15 rows

variants

Variant_ID, RSID, Chromosome, Position, Reference_Allele, Alternate_Allele, Joint_AF, African_AF, Admixed_American_AF, Ashkenazi_Jewish_AF, East_Asian_AF, Finnish_AF, Middle_Eastern_AF, Non_Finnish_European_AF, South_Asian_AF, ENCODE_cCRE_Annotation, Repeat_Name, Repeat_Class, Repeat_Family, Functional_Annotation, Gene, Gene_Detail, Exonic_Function, Amino_Acid_Change, PhastCons_100way, PhyloP_100way, Evo2_7B_NoRC_Ref, Evo2_7B_NoRC_Alt, Evo2_7B_NoRC_Delta, Evo2_7B_AvgRC_Ref, Evo2_7B_AvgRC_Alt, Evo2_7B_AvgRC_Delta, Evo2_7B_WeightedRC_Ref, Evo2_7B_WeightedRC_Alt, Evo2_7B_WeightedRC_Delta, Evo2_40B_NoRC_Ref, Evo2_40B_NoRC_Alt, Evo2_40B_NoRC_Delta, Evo2_40B_AvgRC_Ref, Evo2_40B_AvgRC_Alt, Evo2_40B_AvgRC_Delta, Evo2_40B_WeightedRC_Ref, Evo2_40B_WeightedRC_Alt, Evo2_40B_WeightedRC_Delta, MAF_tier, AF_bin, SCREEN_V4_Classes, SCREEN_V4_Accessions, SCREEN_V4_Overlap_Count

6,475,578 rows

... and 6 hidden tables