Hello,
In the document
ftp://ftp.ebi.ac.uk/pub/software/biomart/user-docs.pdf
Figure 5.4.1 shows the reversed star schema of the hsapiens_gene_ensembl
gene and transcript tables.
I'm wondering why the gene__main table is at all necessary. It appears
that all its information is present, an can be fetched from, the
transcript__main table.
The figure also appears to have the following errors:
gene__main.chrom_start -> gene__main.gene_chrom_start
gene__main.chrom_end -> gene__main.gene_chrom_end
transcript__main.gene_stable_id (missing)
Also it reads "gene_id_key (PK)". This is erroneous for the transcript
table. For the gene table, it make sense, but I noticed that in the
actual tables on the ensembldb server, the primary key is not defined.
Cheers
Alexandre
--
Alexandre Gattiker
Swiss Institute of Bioinformatics, Genome Bioinformatics Group
Biozentrum Tel. +41 61 267 1579
Klingelbergstrasse 50 Fax +41 61 267 1585
4056 Basel [EMAIL PROTECTED]
Switzerland http://www.biozentrum.unibas.ch/primig
