MyGenome LOVD - This database is for training purposes only
ABCG4 (ATP-binding cassette, sub-family G (WHITE), ...)
LOVD v.3.0 Build 30 [
Current LOVD status
]
Log in
Curator:
Johan T. den Dunnen
View all genes
View ABCG4 gene homepage
View graphs about the ABCG4 gene database
Create a new gene entry
View all transcripts
View all transcripts of gene ABCG4
Create a new transcript information entry
View all variants
View all variants affecting transcripts
View unique variants in gene ABCG4
View all variants in gene ABCG4
Full data view for gene ABCG4
Create a new data submission
View active genomic custom columns
Enable more genomic custom columns
View all individuals
View all individuals with variants in gene ABCG4
Create a new data submission
View active custom columns
Enable more custom columns
View all diseases
View all diseases associated with gene ABCG4
Create a new disease information entry
View available phenotype columns
View all screenings
View all screenings for gene ABCG4
Create a new data submission
View active custom columns
Enable more custom columns
Submit new data
All individuals with variants in gene ABCG4
Error: Query (Logged)
/individuals/ABCG4 returned error in code block Individual::viewList().
Query : SELECT SQL_CALC_FOUND_ROWS i.*, i.id AS individualid, GROUP_CONCAT(DISTINCT d.id) AS diseaseids, GROUP_CONCAT(DISTINCT IF(CASE d.symbol WHEN "-" THEN "" ELSE d.symbol END = "", d.name, d.symbol) ORDER BY (d.symbol != "" AND d.symbol != "-") DESC, d.symbol, d.name SEPARATOR ", ") AS diseases_, GROUP_CONCAT(DISTINCT s2g.geneid ORDER BY s2g.geneid SEPARATOR ", ") AS genes_screened_, COUNT(DISTINCT vog.id) AS variants_, uo.name AS owned_by_, CONCAT_WS(";", uo.id, uo.name, uo.email, uo.institute, uo.department, IFNULL(uo.countryid, "")) AS _owner, ds.name AS status, GROUP_CONCAT(DISTINCT p.`Phenotype/Additional` ORDER BY p.`Phenotype/Additional` SEPARATOR ", ") AS phenotypes_ FROM lovd_v3_individuals AS i LEFT OUTER JOIN lovd_v3_individuals2diseases AS i2d ON (i.id = i2d.individualid) LEFT OUTER JOIN lovd_v3_diseases AS d ON (i2d.diseaseid = d.id) LEFT OUTER JOIN lovd_v3_screenings AS s ON (i.id = s.individualid) LEFT OUTER JOIN lovd_v3_screenings2variants AS s2v ON (s2v.screeningid = s.id) LEFT OUTER JOIN lovd_v3_variants AS vog ON (s2v.variantid = vog.id AND (vog.statusid >= 7)) LEFT OUTER JOIN lovd_v3_screenings2genes AS s2g ON (s.id = s2g.screeningid) LEFT OUTER JOIN lovd_v3_variants_on_transcripts AS vot ON (vog.id = vot.id) LEFT OUTER JOIN lovd_v3_users AS uo ON (i.owned_by = uo.id) LEFT OUTER JOIN lovd_v3_data_status AS ds ON (i.statusid = ds.id) LEFT OUTER JOIN lovd_v3_phenotypes AS p ON (i.id = p.individualid AND (p.statusid >= 7)) WHERE (i.statusid >= 7) AND (t.geneid = ?) GROUP BY i.id ORDER BY i.id ASC LIMIT 0
Error : Error in PDOStatement::execute() while executing prepared query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.geneid' in 'WHERE'
Powered by
LOVD v.3.0
Build 30
LOVD software ©2004-2024
Leiden University Medical Center