INTRODUCTION
============

Affymetrix 3′ Gene as well as Exon and Gene level microarrays are widely used in gene expression studies. HG-U133A, HG-U133B and HG-U133 Plus 2.0 arrays consist of probe sets developed for each annotated human gene. A probe set is typically a set of 11 25-mer oligonucleotide probes, with a small number of probe sets consisting of more or less than 11 probes.

The majority of Human Exon 1.0 probe sets consist of four probes; these probes are developed to target all known and predicted human exons. The Human Gene 1.0 chip is based on Human Exon 1.0 data combining together all highly expressed probes that are confirmed by the transcriptome data for a particular gene. Thus the number of probes in a probe set depends on the transcript length.

The Affymetrix probes and probe sets remained unchanged for the past several years but our knowledge of their genome and transcriptome context has improved with every paper in this field.

The first annotation of Affymetrix probes was provided by Affymetrix staff in NetAffx database ([@B1]). This database contains information about transcripts that are recognized by the corresponding probe sets and fixes the problem of the absence of representative sequences in new versions of UniGene ([@B2]).

A careful analysis of HG-U133A probes was done by Gautier and colleagues ([@B3]). The authors aligned probe sequences with RefSeq ([@B4]) mRNAs, and found some discrepancies for 64% of the HG-U133A probes.

Using a similar approach, Harbig and colleagues ([@B5]) showed that ∼37% of the probes of the HG-U133 Plus 2.0 array should be redefined and more than 5000 probe sets detect multiple transcripts. Similar analyses for different expression arrays ([@B6; @B7; @B8; @B9; @B10]) brought similar results.

Non-specific hybridization is another big problem of microarray experiments. Several papers showed that the rule that a perfect match probe has a high signal level and a mismatch probe has a low signal level does not work in many cases ([@B11; @B12; @B13]).

In a subsequent paper ([@B14]), Zhang and colleagues developed a model of molecular interaction on short oligonucleotide arrays and applied it in their next work ([@B15]). It was shown that a significant amount of probes could give high signal level by a non-specific hybridization with short 10--16-nucleotide fragments.

Alternative splicing is another source of the inconsistency in microarray experiments. Recent articles showed that up to 93% of human intron-containing genes undergo alternative splicing ([@B16],[@B17]) and up to 90% of the genome sequence is transcribed ([@B18]). An additional source of the inconsistency is the presence of single nucleotide polymorphisms (SNPs) within probe alignment positions.

There are several publicly available databases that contain annotation of the Affymetrix data: the official NetAffx ([@B1]), GeneAnnot ([@B19]), ADAPT ([@B20]) and X:Map ([@B21]) databases.

GeneAnnot and ADAPT align probe sequences to the RefSeq and Ensembl mRNAs, NetAffx additionally considers GenBank ([@B22]) and UniGene ([@B2]) mRNAs. The main problem of the common approach used by these three databases arises when a particular probe, in addition to the original position, recognizes another transcribed region that is absent in the considering mRNA sequences. This results in the incomplete probe set (probe) annotation.

The X:Map and presented here PLANdbAffy databases fix the above shortcoming. The authors of X:Map have aligned probe sequences with the genome and also took into account the ESTs. Unfortunately, X:Map contains data only for exon-level arrays, leaving other widely used arrays (HG-U133A&B and Human Gene 1.0) uncovered.

The interface of X:Map is based on Google Maps API covering the whole chromosome. To obtain the EST transcription state of a particular probe one has to calculate the ESTs manually. This is rather difficult, and becomes much more laborious for the exon-junction probes and probes that are close to splicing sites. Also the X:Map database uses only the Ensembl genome annotation and Ensembl EST accessions, which brings difficulties to the NCBI-oriented users.

Our PLANdbAffy database considers five widely used Affymetrix human microarrays: HG-U133A, HG-U133B, HG-U133 Plus 2.0, Human Exon 1.0 and Human Gene 1.0. Database provides user with information on all alignment places of the individual Affymetrix probes with the genome considering alignments with up to two mismatches, and also support each probe alignment region with all known to-date transcriptome data. Unlike the above databases (except NetAffx), PLANdbAffy also contains data on SNPs. Graphical information about each probe alignment region and gene is implemented as custom tracks to UCSC genome browser. After moving to the UCSC site it becomes possible to utilize the whole set of data and tools provided by the UCSC browser.

DATABASE CONSTRUCTION AND STRUCTURE
===================================

Data source
-----------

The files containing information about Affymetrix microarrays were downloaded from the official Affymetrix site (<http://www.affymetrix.com/products_services/index.affx>). For this analysis we selected three 3′ Gene arrays, Affymetrix HG-U133A, HG-U133B and HG-U133 Plus 2.0, and two Exon&Gene level arrays, Human Gene 1.0 and Human Exon 1.0.

The NCBI36 (hg18) genome assembly was download from UCSC ftp site. Also, we have downloaded EST and mRNA exon--intron structures (<http://hgdownload.cse.ucsc.edu/goldenPath/hg18/database/> all_mrna.txt.gz and all_est.txt.gz files) that were obtained by Blat ([@B23]) alignment of the corresponding sequences with the genome. We used the NCBI annotation of the genome sequences. Refseq ([@B4]) and Unigene ([@B2]) were used to assign mRNA and EST sequences to the genes.

We used dbSNP ([@B24]) build 130 as a source of SNPs, the human readable text files were downloaded from the ftp site (<ftp://ftp.ncbi.nih.gov/snp/organisms/human_9606/ASN1_flat/>) and parsed.

Database development
--------------------

Each probe and probe set within five chips under consideration was assigned a unique ID. It was done because some probe sets in different chips have the same identification numbers. The Affimetrix numbers were also stored and could be used to search the database.

Probe sequences were mapped to the genome using Blat ([@B23]). We allowed alignments with no more than two mismatches and required 40- and more nucleotide introns for potential exon-junction probes. The hits found ('probe alignment regions') were stored and subjected to further analysis.

We assigned a probe to a particular gene ('the probe match the gene') if the probe alignment region intersected with the annotated gene region and was in the correct orientation. We also took into account possible mistakes in the gene annotation extending the 3′-end of each gene by 1000 nucleotides.

We annotated each probe alignment region using the mRNA and EST alignments provided by UCSC, considering only the sequences that were present in UniGene (219 build) for corresponding genes.

For each probe alignment region, we have calculated the number of mRNA and EST that either support (mrna_in, spliced_est_in, unspliced_est_in fields) or do not support (mrna_out, spliced_est_out fields) occurrence of the probe alignment region in an exon (see the database web site for further explanation).

To present the quality of a probe we divided all probes into four classes, and assigned a color to each class ([Figure 1](#F1){ref-type="fig"}). Green probes (the best ones) are the probes meeting three conditions. First, the probe is aligned to the target gene without mismatches. Second, there are no matches of the probe to other genes. Third, there are no perfect alignments of the probe to non-coding regions. Unlike the green probes, a yellow probe has a perfect match to uncoding region. The yellow probes still have a perfect match to the target gene and no matches with other genes. The red probes are the probes that have a perfect match to the target gene and at least one alignment to other genes with no more than one mismatch. Finally, a black probe is aligned to the target gene with at least one mismatch. Figure 1.Examples of textual (**A**) and graphical (**B**) interface of the PLANdbAffy database. The textual interface of the database consists of three sections. The first section (left five columns) contains the original information about the probes from Affymetrix and probe status (highlighted by green), the second section (6--8th columns) describes the probe alignment and the last section (rightmost five columns) describes the numbers of the ESTs and mRNAs either supporting or not supporting the occurrence of the probe in an exon (see 'Database development' section). An example of graphical interface was manually processed to reduce the image size.

Human-readable text files of dbSNP contain information about the SNP genome position, orientation and allelic variants. We have selected SNPs that were located in probe alignment regions and mapped them onto the probe sequences.

Database interface
------------------

The database is available at <http://affymetrix2.bioinf.fbb.msu.ru>. Text files containing the information about the mapping and annotation of the good (green) probes can be downloaded from web site.

The title page contains several search boxes. One may either search the database with an Affymetrix probe set identifier, or get all probes for the particular gene using the gene search boxes. The EntrezGene, HUGO and Ensembl identifiers, the gene symbol, a word or a phrase in the gene name can be used. It must be noted, however, that since our database is based on the RefSeq annotations, some of the Ensembl and HUGO identifiers could be missed.

Querying a probe set or a gene one could see the textual part of the database interface ([Figure 1](#F1){ref-type="fig"}A). The textual part of the interface consists of probe information section, probe alignment section and transcription state section. The probe information section has four fields presenting the probe name ('text'), the probe position on the chip ('X', 'Y', 'inter pos') and the color representation of the probe's quality status ('sts'), see Database development section.

The probe alignment section contains information about the probe alignment and its mismatches. Positions of SNPs within the probe alignment region are marked and supported by the links to their descriptions in dbSNP.

For each probe, the information about EST and mRNA sequences that cover the probe alignment region is available at the transcription state section. The explanation of the corresponding fields for the exon and exon-junction probes is given in the 'Database development' section.

Each gene and each probe alignment region are supported by the graphical part of the database interface. It is organized as custom tracks to UCSC genome browser ([Figure 1](#F1){ref-type="fig"}B), that allows one to utilize all information that is offered by UCSC browser for the corresponding region.

Data analysis
-------------

In the [Figure 2](#F2){ref-type="fig"}, we present frequencies of each type of probes for all five arrays. Among the 3′ gene arrays HG-U133A has the highest frequency (70%) of good (green) probes. HG-U133B array has ∼53% of good probes and HG-U133 Plus 2.0 array that was designed basically by combining the HG-U133A and HG-U133B arrays data is located in between and has 59% of good probes. Figure 2.Frequencies of probes with different alignment and cross-hybridization state for all five considered Affymetrix arrays. See colours' definitions in the text.

[Table 1](#T1){ref-type="table"} contains summary information about the transcriptome annotation for good (green) probes. Probe is marked as 'exon' if it is confirmed by more than 90% of mRNA and EST sequences that cover this region. It is marked as 'intron' if it is confirmed by \<10% of the sequences, whereas the probes that are in between are marked as 'exon/intron' ones. Table 1.Genome and transcriptome annotation for good (green) probesHG-U133AHG-U133BHG-U133_Plus2HuGeneHuExExon142 42773 148236 427436 548915 886Exon/intron19 56720 19850 15481 189288 217Intron12 37438 68070 60567 6191 271 110SNP19 24911 38034 72470 525274 208Total genes16 48011 69723 25524 01030 915

The HG-U133A array contains the lowest amount of intron and exon/intron probes (18.3%). Considerably greater amount of such probes was observed for HG-U133B (44.6%) and HG-U133 Plus 2.0 (33.8%) arrays.

As Human Exon 1.0 chip was designed to recognize all potential transcribed segments, it contains the greatest amount of the intron and exon/intron probes (63.0%). The Human Gene 1.0 array has a similar to the HG-U133A array level of the intron and exon/intron probes (25.4%). All five arrays have almost an equal amount of SNPs (8--12%) in probe align region of good (green) probes.

Similar results were described in different research and database papers. Zhang and colleagues ([@B7]) have shown that HG-U133A array contains 12.1 and 8.0% of non-specific and mistargeted probes, respectively. GeneAnnot database summary ([@B19]) reports that ∼16% of HG-U133A array probe sets recognize multiple genes. ADAPT database summary ([@B20]) reports ∼23.1% of HG-U133 Plus 2.0 array probe sets, which match more than one RefSeq transcript.

X:Map database publication ([@B21]) contains detailed statistics for Human Exon 1.0 chip. The authors observed 9% of multitarget probe sets and 45% of intergenic probe sets. Very similar values were observed in PLANdbAffy database: 9.1% of multitarget (red and yellow) probes and 45.2% of intergenic (black) probes. X:Map annotates 21 and 23% of all studied probe sets as exon and intron ones respectively, and the similar values is observed in PLANdbAffy ([Table 1](#T1){ref-type="table"}).

DATABASE USAGE
==============

The database can be used for interpretation of results of gene expression experiments, and also to perform the delicate analysis of expression in certain areas of genome. For example, it is a common situation that different probe sets of one gene demonstrate quite different expression values and it is not clear what is true. Careful analysis of the genomic probe alignment regions can help to explain the difference. It may appear due to some discrepancies in microarray design, the probe can be aligned into the spliced region of a gene, existence of SNPs in probe align regions may cause the decrease of probe signal intensity. In contrast, much more often observed cross-hybridization of a probe will increase the probe signal.

PLANdbAffy textual summary page of particular probe set or gene contains the information on transcription, cross-hybridization and SNP status for each probe. From this page one can move to UCSC Genome Browser and see the considered Affymetrix probes as a custom track. This browser contains different annotations for corresponding genome regions, e.g. mapping and sequencing annotation, phenotype and disease annotation, gene, protein, mRNA and EST annotation, etc. This information allows one to perform a qualitative analysis of microarray results and may suit as a good starting point for additional molecular studies.

FUTURE PLANS
============

We are planning to move our data from hg18 to hg19 version of human genome and update it twice a year by the new mRNA and EST alignments. We also are planning to perform this analysis for the mouse and rat exon-level arrays.

FUNDING
=======

Open Access charges were waived by Oxford University Press.

*Conflict of interest statement*. None declared.

The authors thank Alexander Favorov and Alexander Poliakov for valuable technical advises and Mikhail Roytberg for helpful discussion.

[^1]: Present address: Ramil N. Nurtdinov, INSERM U563, Pole des Neurosciences, University of Toulouse, BP 3048, CHU Purpan, Toulouse 3, 31024, France.
