MyGenome LOVD - This database is for training purposes only
FANCG (Fanconi anemia, complementation group G)
LOVD v.3.0 Build 30 [
Current LOVD status
]
Log in
Curator:
Johan T. den Dunnen
View all genes
View FANCG gene homepage
View graphs about the FANCG gene database
Create a new gene entry
View all transcripts
View all transcripts of gene FANCG
Create a new transcript information entry
View all variants
View all variants affecting transcripts
View unique variants in gene FANCG
View all variants in gene FANCG
Full data view for gene FANCG
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 FANCG
Create a new data submission
View active custom columns
Enable more custom columns
View all diseases
View all diseases associated with gene FANCG
Create a new disease information entry
View available phenotype columns
View all screenings
View all screenings for gene FANCG
Create a new data submission
View active custom columns
Enable more custom columns
Submit new data
All individuals with variants in gene FANCG
Error: Query (Logged)
/individuals/FANCG 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