Legend

Please note that a short description of a certain column can be displayed when you move your mouse cursor over the column's header and hold it still. Below, a more detailed description is shown per column.

Phenotype details: additional information on the phenotype of the individual, preferably use HPO terms only (http://www.human-phenotype-ontology.org/)

Diagnosis/Initial: initial diagnosis, before molecular testing

Diagnosis/Definite: phenotype individual after molecular testing (OMIM abbreviation)

Inheritance: Indicates the inheritance of the phenotype in the family; unknown, familial (autosomal/X-linked, dominant/ recessive), paternal (Y-linked), maternal (mitochondrial), isolated (sporadic) or complex
All options:

• Unknown
• Familial
• Familial, autosomal dominant
• Familial, autosomal recessive
• Familial, X-linked
• Familial, X-linked dominant
• Familial, X-linked dominant, male sparing
• Familial, X-linked recessive
• Paternal, Y-linked
• Maternal, mitochondrial
• Isolated (sporadic)
• Di-genic
• Complex
• - = Not applicable

Age/Examination: age at which the individual was examined.

• 35y = 35 years
• 04y08m = 4 years and 8 months
• 00y00m01d12h = 1 day and 12 hours
• 18y? = around 18 years
• 30y-40y = between 30 and 40 years
• >54y = older than 54
• ? = unknown

Age/Diagnosis: age diagnosis was confirmed

Age/Onset: Age first symptoms disease appeared in individual:

• 35y = 35 years
• 04y08m = 4 years and 8 months
• 00y00m01d12h = 1 day and 12 hours
• 18y? = around 18 years
• 30y-40y = between 30 and 40 years
• >54y = older than 54
• ? = unknown

Phenotype/Onset: individual's phenotype at Age/Onset described using HPO

Growth: does the individual have abnormal growth (pre- and post-natal)
All options:

• normal = normal growth
• abnormal = growth abnormality (HP:0001507)
• delayed = delayed (HP:00001510)
• overgrowth = overgrowth (HP:0001548)
• overgrowth prenatal = prenatal overgrowth (HP:0001548)
• overgrowth postnatal = postnatal overgrowth (HP:0001548)
• retardation prenatal = prenatal growth retardation (HP:0001511, IUGR)
• no retardation prenatal = no prenatal growth retardation (-HP:0001511)
• retardation prenatal mild = mild prenatal growth retardation (HP:0008883)
• retardation prenatal moderate = moderate prenatal growth retardation (HP:0011408)
• retardation prenatal severe = severe prenatal growth retardation (HP:0008846)
• retardation postnatal = postnatal growth retardation (HP:0008897)
• retardation postnatal mild = mild postnatal growth retardation (HP:0001530)
• retardation postnatal moderate = moderate postnatal growth retardation (HP:0008855)
• retardation postnatal severe = severe postnatal growth retardation (HP:0008850)
• ? = unknown
• n/a = not analysed

Head/Size: individual has abnormal size of the head
All options:

• macrocephaly = macrocephaly (HP:0000256)
• no macrocephaly = no macrocephaly (-HP:0000256)
• macrocephaly congenital = congenital macrocephaly (HP:0004488)
• no macrocephaly congenital = no congenital macrocephaly (-HP:0004488)
• macrocephaly postnatal = postnatal macrocephaly (HP:0005490)
• macrocephaly progressive = progressive macrocephaly (HP:0004481)
• macrocephaly relative = relative macrocephaly (HPO_0004482)
• microcephaly = microcephaly (yes <3rd centile, HP:0000252)
• no = no microcephaly (-HP:0000252, -)
• congenital = congenital microcephaly (HP:0011451)
• microcephaly mild = mild microcephaly (HP:0040196)
• postnatal = postnatal microcephaly (HP:0005484)
• progressive = postnatal progressive microcephaly (HP:0000253)
• ? = unknown
• nr = not reported
• n/a = not applicable

MotorSkills: development motor skills; age head control (in months), age sitting (without support, in months), age walking (without support, in months); head:7m, sit:10m, walk:24m, delayed gross motor development (HP:0002194), delayed fine motor development (HP:0010862)

Speech: does the individual have normal speech and language development
All options:

• - = no speech delay
• speech delayed (HP:0000750)
• mild = mild speech delayed (HP:0000750)
• mild-moderate = mild-moderate speech delayed (HP:0000750)
• moderate = speech delayed (HP:0000750)
• moderate-severe = moderate-severe speech delayed (HP:0000750),
• severe =severe speech delayed (HP:0000750)
• no speech = no speech (HP:0001344)
• loss of speech = loss of speech (HP:0002371)
• poor speech = poor speech (HP:0002465)
• nasal = nasal speech (HP:0001611)
• nasal/dysarthic =nasal, dysarthic speech (HP:0008376)
• hyponasal = hyponasal speech (HP:0100271)
• articulation difficulties = articulation difficulties (HP:0009088)
• dysarthria = dysarthria (HP:0001260)
• grammar-specific = grammar-specific speech disorder (HP:0006977)
• incomprehensible = incomprehensible speech (HP:0002546)
• scanning = scanning speech (HP:0002168)
• slurred = slurred speech (HP:0001350)
• slowed slurred = slowed slurred speech (HP:0007164)
• apraxia = speech apraxia (HP:0011098)
• ? = unknown
• n/a = not analysed

Cleft: does the individual have a facial cleft (please specify)
All options:

• - = no cleft
• chin = cleft chin (HP:0011323)
• face = cleft facial (HP:0002006)
• face midline = cleft facial midline (HP:0100629)
• face transverse = cleft facial transverse (HP:0100731)
• lip bilateral = cleft lip bilateral (HP:0100336)
• lip unilateral = cleft lip unilateral (HP:0100333)
• lip lower = cleft lip lower (HP:0010281)
• lip median = cleft lip median (HP:0000161)
• lip non-mdiline = cleft lip non-mdiline (HP:0100335)
• lip upper = cleft lip upper (HP:0000204)
• lip upper incomplete = cleft lip upper incomplete (HP:0011340)
• lip submucous = cleft lip submucous (HP:0009101)
• lip/palate bilateral = cleft lip/palate bilateral (HP:0002744)
• lip/palate median = cleft lip/palate median (HP:0008501)
• mandible = cleft mandible (HP:0010752)
• oral = cleft oral (HP:0000202)
• palate = cleft palate (HP:0000175)
• palate bilateral = cleft palate bilateral (HP:0100337)
• palate unilateral = cleft palate unilateral (HP:0100334)
• palate median = cleft palate median (HP:0009099)
• palate non-mdiline = cleft palate non-mdiline (HP:0100338)
• palate hard = cleft palate hard (HP:0410005)
• palate hard submucous = cleft palate hard submucous (HP:0000176)
• palate soft = cleft palate soft (HP:0000185)
• palate soft submucous = cleft palate soft submucous (HP:0011819)
• palate primary = cleft palate primary (HP:0410003)
• palate secondary = cleft palate secondary (HP:0410004)
• palate hard = cleft palate hard (HP:0410005)
• ? = unknown
• n/a = not analysed

Protein: result from protein staining

Abnormality: abnormality specific organ/tissue
All options:

• abdomen = abdomen (HP:0001438)
• blood/blood forming tissue = blood/blood forming tissue (HP:0001871)
• breast = breast (HP:0000769)
• cardiovascular = cardiovascular system (HP:0001626)
• heart = abnormal cardiac morphology (HP:0001627)
• vascular = abnormal vasculature (HP:0002597)
• connective = connective tissue (HP:0003549)
• endocrine = endocrine system (HP:0000818)
• genitourinary = genitourinary system (HP:0000119)
• genital = genital system (HP:0000078)
• urinary= urinary system (HP:0000079)
• head/neck = head (face) or neck (HP:0000152)
• ear = ear (HP:0000598)
• eye = eye (HP:0000478)
• face = face (HP:0000271)
• immune = immune system (HP:0002715)
• integument = integument (HP:0001574)
• limbs = limbs (HP:0040064)
• metabolism/homeostasis = metabolism/homeostasis (HP:0001939)
• musculature = musculature (HP:0003011)
• neoplasm = neoplasm (HP:0002664)
• nervous = nervous system (HP:0000707)
• respiratory = respiratory system (HP:0002086)
• skeletal = skeletal system (HP:0000924)
• thoracic cavity = thoracic cavity (HP:0045027)
• voice = voice (HP:0001608)
• no = no abnormality
• ? = unknown
• n/a = not analysed

Hirsutism: individual has hirsutism (excessive hair growth), please specify
All options:

• hirsutism = hirsutism (HP:0001007)
• facial = facial hirsutism (HP:0009937)
• forehead = frontal hirsutism (HP:0011335)
• generalized = generalized hirsutism (HP:0002230)
• localized = localized hirsutism (HP:0009889)
• lumbosacral = lumbosacral hirsutism (HP:0009747)
• no = no hirsutism
• ? = unknown
• n/a = not analysed

Intellectual_dis: individual has intellectual disability (intellectual disability (mental retardation), HP:0001249,mental retardation); please specify
All options:

• yes = intellectual disability (HP:0001249, IQ below 70)
• borderline = intellectual disability, borderline (HP:0006889, IQ 70-79)
• mild = intellectual disability, mild (HP:0001256, IQ 50-69)
• moderate = intellectual disability, moderate (HP:0002342, IQ 35-49)
• profound = intellectual disability, profound (HP:0002187, IQ below 20)
• severe = intellectual disability, severe (HP:0010864, IQ 20-34)
• progressive = intellectual disability, progressive (HP:0006887)
• no = no intellectual disability (IQ above 79, -)
• ? = unknown
• n/a = not analysed

How to query this table

All list views have search fields which can be used to search data. You can search for a complete word or you can search for a part of a search term. If you enclose two or more words in double quotes, LOVD will search for the combination of those words only exactly in the order you specify. Note that search terms are case-insensitive and that wildcards such as * are treated as normal text! For all options, like "and", "or", and "not" searches, or searching for prefixes or suffixes, see the table below.

Operator	Column type	Example	Matches
	Text	Arg	all entries containing 'Arg'
space	Text	Arg Ser	all entries containing 'Arg' and 'Ser'
|	Text	Arg|Ser	all entries containing 'Arg' or 'Ser'
!	Text	!fs	all entries not containing 'fs'
^	Text	^p.(Arg	all entries beginning with 'p.(Arg'
$	Text	Ser)$	all entries ending with 'Ser)'
=""	Text	=""	all entries with this field empty
=""	Text	="p.0"	all entries exactly matching 'p.0'
!=""	Text	!=""	all entries with this field not empty
!=""	Text	!="p.0"	all entries not exactly matching 'p.0?'
combination	Text	*|Ter !fs	all entries containing '*' or 'Ter' but not containing 'fs'
	Date	2020	all entries matching the year 2020
|	Date	2020-03|2020-04	all entries matching March or April, 2020
!	Date	!2020-03	all entries not matching March, 2020
<	Date	<2020	all entries before the year 2020
<=	Date	<=2020-06	all entries in or before June, 2020
>	Date	>2020-06	all entries after June, 2020
>=	Date	>=2020-06-15	all entries on or after June 15th, 2020
combination	Date	2019|2020 <2020-03	all entries in 2019 or 2020, and before March, 2020
	Numeric	23	all entries exactly matching 23
|	Numeric	23|24	all entries exactly matching 23 or 24
!	Numeric	!23	all entries not exactly matching 23
<	Numeric	<23	all entries lower than 23
<=	Numeric	<=23	all entries lower than, or equal to, 23
>	Numeric	>23	all entries higher than 23
>=	Numeric	>=23	all entries higher than, or equal to, 23
combination	Numeric	>=20 <30 !23	all entries with values from 20 to 29, but not equal to 23

Some more advanced examples:

Example	Matches
Asian	all entries containing 'Asian', 'asian', including 'Caucasian', 'caucasian', etc.
Asian !Caucasian	all entries containing 'Asian' but not containing 'Caucasian'
Asian|African !Caucasian	all entries containing 'Asian' or 'African', but not containing 'Caucasian'
"South Asian"	all entries containing 'South Asian', but not containing 'South East Asian'

To sort on a certain column, click on the column header or on the arrows. If that column is already selected to sort on, the sort order will be swapped. The column currently sorted on has a darker blue background color than the other columns. The up and down arrows next to the column name indicate the current sorting direction. When sorting on any field other than the default, LOVD will sort secondarily on the default sort column.