Field Operator1 Operator2 Value
Job ID
Chr
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Start AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
End AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Ref AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Alt AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Func_refGene AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Gene_refGene AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
GeneDetail_refGene AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
ExonicFunc_refGene AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
AAChange_refGene AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Func_ensGene AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Gene_ensGene AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
GeneDetail_ensGene AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
ExonicFunc_ensGene AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
AAChange_ensGene AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
phastConsElements46way AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
gwasCatalog AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
cytoband AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
tfbsConsSites AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
wgEncodeRegTfbsClustered AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
wgEncodeRegDnaseClustered AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
evofold AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
snp138 AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2012feb_all AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2012apr_all AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2010nov_all AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2014sep_all AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2014sep_eur AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2014sep_eas AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2014sep_amr AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2014sep_afr AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2014sep_sas AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2012apr_eur AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2012apr_asn AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2012apr_amr AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
1000g2012apr_afr AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
exac03 AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
popfreq_max AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
SIFT_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
SIFT_pred AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Polyphen2_HDIV_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Polyphen2_HDIV_pred AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Polyphen2_HVAR_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
Polyphen2_HVAR_pred AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
LRT_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
LRT_pred AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
MutationTaster_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
MutationTaster_pred AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
MutationAssessor_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
MutationAssessor_pred AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
FATHMM_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
FATHMM_pred AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
RadialSVM_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
RadialSVM_pred AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
LR_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
LR_pred AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
VEST3_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
CADD_raw AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
CADD_phred AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
GERP_RS AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
phyloP46way_placental AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
phyloP100way_vertebrate AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
SiPhy_29way_logOdds AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
cadd AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
caddgt10 AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
avsift AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
esp6500_ea AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
esp6500_aa AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
cosmic67 AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
cg69 AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
clinvar_20140929 AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
rank_score AND OR
=
>
>=
<
<=
!=
LIKE
LIKE %..%
NOT LIKE
REGEXP
REGEXP^...$
NOT REGEXP
IN(..)
NOT IN (..)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL