[Genome] Overlap between refSeq, known_gene and all_mRNA tables

[Alessandro Guffanti]

Dear Genome support:

I would like to know which is the extent of overlap between the following
UCSC db tables:

knownGene
all_mrna
refGene

I understand that RefSeq sequences are NOT included in all_mrna:

mysql> select * from all_mrna where qName LIKE 'NM_%';
Empty set (0.00 sec)

Q1) are all the refGene sequences contained in knwonGene ?
Q2) to obtain the total coverage of the human genome in terms of 
(redundant) transcripts, shall I query
all_mrna AND refGene ? or all_mrna and knownGene ?

Best wishes and thanks in advance,

Alessandro G

-- 
Alessandro Guffanti – Nanotechnologies Group
CNR – Institute of Biomedical Technologies
c/o CISI - Via Fantoli, 16/15 – 20138 Milano, Italy
Ph.: +39-0250320918 Fax: +39-0250320919
Email: alessandro.guffanti at itb.cnr.it