sither
PALB2 (partner and localizer of BRCA2)
LOVD v.3.0 Build 29 [
Current LOVD status
]
Log in
Curator:
Instituto Nacional del Cancer
View all genes
View PALB2 gene homepage
View graphs about the PALB2 gene database
Create a new gene entry
View all transcripts
View all transcripts of gene PALB2
Create a new transcript information entry
View all variants
View all variants affecting transcripts
View unique variants in gene PALB2
View all variants in gene PALB2
Full data view for gene PALB2
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 PALB2
Create a new data submission
View active custom columns
Enable more custom columns
View all diseases
View all diseases associated with gene PALB2
Create a new disease information entry
View available phenotype columns
View all screenings
View all screenings for gene PALB2
Create a new data submission
View active custom columns
Enable more custom columns
Submit new data
Full data view for gene PALB2
The variants shown are described using the
NM_024675.3
NM_024675.4
transcript reference sequence.
Error: Query
/view/PALB2?search_VariantOnGenome%2FDBID=%3D%22PALB2_000018%22 returned error in code block Custom_ViewList::viewList().
Query : SELECT CONCAT(CAST(MIN(vog.id) AS UNSIGNED), IFNULL(CONCAT(":", CAST(MIN(vot.transcriptid) AS UNSIGNED)), "")) AS row_id, vot.id AS votid, vot.transcriptid, vot.position_c_start, vot.position_c_start_intron, vot.position_c_end, vot.position_c_end_intron, et.name as vot_effect, `VariantOnTranscript/Exon`, `VariantOnTranscript/DNA`, `VariantOnTranscript/Protein`, `VariantOnTranscript/Gene_Dosage`, `VariantOnTranscript/Co_ocurrence`, `VariantOnTranscript/RNA`, `VariantOnTranscript/Reference`, vog.id AS vogid, vog.chromosome, a.name AS allele_, dsg.id AS var_statusid, dsg.name AS var_status, `VariantOnGenome/DNA`, `VariantOnGenome/Reference`, `VariantOnGenome/DBID`, `VariantOnGenome/dbSNP`, `VariantOnGenome/Remarks`, GROUP_CONCAT(DISTINCT `Screening/Template` ORDER BY s.id SEPARATOR ";") AS `Screening/Template`, GROUP_CONCAT(DISTINCT `Screening/Technique` ORDER BY s.id SEPARATOR ";") AS `Screening/Technique`, GROUP_CONCAT(DISTINCT `Screening/Date_of_test` ORDER BY s.id SEPARATOR ";") AS `Screening/Date_of_test`, GROUP_CONCAT(DISTINCT `Screening/Lab` ORDER BY s.id SEPARATOR ";") AS `Screening/Lab`, GROUP_CONCAT(DISTINCT `Screening/Remarks` ORDER BY s.id SEPARATOR ";") AS `Screening/Remarks`, GROUP_CONCAT(DISTINCT `Screening/type_of_test` ORDER BY s.id SEPARATOR ";") AS `Screening/type_of_test`, i.id AS iid, i.panel_size, i.owned_by, 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_, uo.name AS owned_by_, CONCAT_WS(";", uo.id, uo.name, uo.email, uo.institute, uo.department, IFNULL(uo.countryid, "")) AS _owner, dsi.id AS ind_statusid, dsi.name AS ind_status, `Individual/Origin/Ethnic`, `Individual/Reference`, `Individual/Remarks`, `Individual/cuadro/familiar` FROM lovd_variants_on_transcripts AS vot LEFT OUTER JOIN lovd_variant_effect AS et ON (vot.effectid = et.id) LEFT OUTER JOIN lovd_variants AS vog FORCE INDEX FOR JOIN (PRIMARY) ON (vot.id = vog.id) LEFT OUTER JOIN lovd_alleles AS a ON (vog.allele = a.id) LEFT OUTER JOIN lovd_data_status AS dsg ON (vog.statusid = dsg.id) LEFT OUTER JOIN lovd_screenings2variants AS s2v ON (vog.id = s2v.variantid) LEFT OUTER JOIN lovd_screenings AS s ON (s2v.screeningid = s.id) LEFT OUTER JOIN lovd_individuals AS i ON (s.individualid = i.id AND (i.statusid >= 7)) 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_users AS uo ON (i.owned_by = uo.id) LEFT OUTER JOIN lovd_data_status AS dsi ON (i.statusid = dsi.id) WHERE (vog.statusid >= 7) AND (vot.transcriptid LIKE ?) AND (vog.`VariantOnGenome/DBID` = ?) GROUP BY vot.id ORDER BY position_c_start ASC, position_c_start_intron ASC, position_c_end ASC, position_c_end_intron ASC, `VariantOnTranscript/DNA` 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