sither
NBAS (NBAS subunit of NRZ tethering complex)
LOVD v.3.0 Build 29 [
Current LOVD status
]
Log in
Curator:
Instituto Nacional del Cancer
View all genes
View NBAS gene homepage
View graphs about the NBAS gene database
Create a new gene entry
View all transcripts
View all transcripts of gene NBAS
Create a new transcript information entry
View all variants
View all variants affecting transcripts
View unique variants in gene NBAS
View all variants in gene NBAS
Full data view for gene NBAS
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 NBAS
Create a new data submission
View active custom columns
Enable more custom columns
View all diseases
View all diseases associated with gene NBAS
Create a new disease information entry
View available phenotype columns
View all screenings
View all screenings for gene NBAS
Create a new data submission
View active custom columns
Enable more custom columns
Submit new data
All individuals with variants in gene NBAS
Error: Query (Logged)
/individuals/NBAS returned error in code block Individual::viewList().
Query : SELECT 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_, GROUP_CONCAT(DISTINCT t.geneid ORDER BY t.geneid SEPARATOR ", ") AS variants_in_genes_, 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_individuals AS i LEFT OUTER JOIN lovd_individuals2diseases AS i2d ON (i.id = i2d.individualid) LEFT OUTER JOIN lovd_diseases AS d ON (i2d.diseaseid = d.id) LEFT OUTER JOIN lovd_screenings AS s ON (i.id = s.individualid) LEFT OUTER JOIN lovd_screenings2variants AS s2v ON (s2v.screeningid = s.id) LEFT OUTER JOIN lovd_variants AS vog ON (s2v.variantid = vog.id AND (vog.statusid >= 7)) LEFT OUTER JOIN lovd_screenings2genes AS s2g ON (s.id = s2g.screeningid) LEFT OUTER JOIN lovd_variants_on_transcripts AS vot ON (vog.id = vot.id) LEFT OUTER JOIN lovd_transcripts AS t ON (t.id = vot.transcriptid) LEFT OUTER JOIN lovd_users AS uo ON (i.owned_by = uo.id) LEFT OUTER JOIN lovd_data_status AS ds ON (i.statusid = ds.id) LEFT OUTER JOIN lovd_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 100 OFFSET 0
Error : Error in PDOStatement::execute() while executing prepared query: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine
Powered by
LOVD v.3.0
Build 29
LOVD software ©2004-2023
Leiden University Medical Center