The HAND Database: Help


How do I search the database?

There is a search field on the top, left-hand side of the database page. Enter the text you are looking for and click on the magnifying glass next to the text field to select those sequences with that text associated with them. To clear the search, click on the magnifying glass with the minus sign.

How do I filter data?

Filters can be set either by column, or by using the “create filter” tool on the bottom, left-hand side of the database page. To filter manually by column, first select a filtering condition for column of interest by clicking on the “abc” dropdown menu for that column. Enter the text you would like to filter by into the text field. Once text has been entered, hit the escape/return button to apply filter. Filters can be set on one or on multiple columns, and can be cleared by clicking on the filter icon with the minus sign, located on the left-hand side of the filter row.

In order to assist in filtering, a spreadsheet is available for download with all entries listed for certain non-numeric columns.

We recommend use of web browser Google Chrome for optimal filtering. Please note that if using Safari on Mac, in order for the filter to work properly “Always allow” must be selected under Safari>Preferences>Privacy.

How do I download data?

Download all data – Data can be exported by first clicking on the arrow next to the “Export” tool at the top of the database page, and next selecting desired output file type.

Download data selection – After a database search or filter procedure (see above), data can be exported by first clicking on the arrow next to the “Export” tool at the top of the database page, and next selecting desired output file type.

Available file types include Excel, CSV, XML, and printer-friendly formatting.

Additional database features

The database can be sorted by column of interest by clicking on the arrow next to the column name.

Database entries can be viewed individually by clicking on “View” under the “Detailed Record” column for that entry of interest. Additional data including “Patient Age at Sampling”, “Patient Health at Sampling”, and “Sequence Length in Nucleotides” can be found here. Of note, additional annotations contained in “View” are also available for export.

The database is automatically set to display 10 entries at one time. This limit, however, can be changed by clicking on the “Define Page Size” tool located on the bottom, left-hand side of the database.

Overview of HAND terms

In general, minor cognitive motor disorder (MCMD) refers to the mild impairment of cognitive and motor functionalities in the HAND individual. AIDS dementia complex (ADC), HIV-associated dementia (HAD), and HIV-associated encephalopathy (HIVE) are all terms that refer to more severe forms of HAND typically associated with later stages of HIV and AIDS. These last three terms are sometimes used interchangeably, and have evolved along with our understanding of HAND development in the HIV individual.

HAND types included in our database are reported as we found listed in the originating data source. Please note that, as such, HAND symptoms associated with each term may vary across study. We advise you to refer to the PMID provided alongside each sequence entry for more detailed information regarding patient HAND diagnosis.

Database Annotations and Examples

CategoryAnnotationExampleDetailed Example
Patient Patient: Code SUBJECT_4 The originating publication ID for this patient was “SUBJECT_4”
Patient: HAND Status HIVE + ADC This patient had two forms of HAND: HIVE and ADC
Patient: Sex M This patient was male
Patient: Risk Factor IV Drug User This patient may have contracted the HIV virus through IV drug use
Patient: Viral Load At Sampling Unknown Viral Load Information on this patient’s viral load at time of sampling could not be found
Patient: CD4 Count At Sampling 5 cells / mm3 This patient had a CD4 count of 5 cells / mm3 at time of sampling
Patient: HIV Therapy Status AZT This patient received AZT therapy prior to sampling
Patient: HIV Therapy Months 20 This patient received HIV therapy for 20 months prior to sampling
Patient: Age At Sampling 29 This patient was 29 years of age at sampling
Patient: Health At Sampling** AIDS This patient had AIDS at time of sampling
Sampling Sampling: Country (City) Japan (unknown) This sample was obtained in an unknown city in the country of Japan
Sampling: Year 1993 This sample was obtained in the year 1993
Sampling: Tissue Spleen This sample was obtained from spleen tissue
Sequence Sequence: Polyprotein (Protein) Tat (gp160) This sequence segment covers the Tat polyprotein and the gp160 protein
Sequence: Genotyping Information B (B) * This sequence was listed by the originating data source as a B subtype sequence. JPHMM testing confirmed this subtype. Recombination testing detected recombination events in this sequence.
Sequence: Accession Number U82096 The sequence accession number for this sequence is U82096
Sequence: PMID*** 10076507 The PubMed ID for this sequence is 10076507
Sequence: Length (nucleotides)** 150 This sequence segment is 150 nucleotides in total length
HIV Sequence cccaaat… The nucleotide sequence for this sequence entry is “cccaaat…”

**These annotations are available through the “View” and “Export” database tools

***Sequence may be associated with additional data sources


Ming Zhang Group, University of Georgia