[ensembl-dev] how to calculate transcript length ?

[陈岗]

Hi All

I wondering how to calculate transcript length within Ensembl database.
I try to sum exon's length:

SELECT tp.stable_id, SUM( e.seq_region_end ) - SUM( e.seq_region_start )
FROM gene g
JOIN transcript tp ON ( g.gene_id = tp.gene_id )
JOIN exon_transcript et ON ( et.transcript_id = tp.transcript_id )
JOIN exon e ON ( e.exon_id = et.exon_id )
WHERE g.stable_id = 'ENSG00000089234'
GROUP BY tp.stable_id

But the result is inconsistent with Ensembl official data:

http://asia.ensembl.org/Homo_sapiens/Gene/Summary?g=ENSG00000089234;r=12:112080797-112123790

If you know how to dig out the datas of
variation,orthologue,paralogue,regulation.
please also tell me.


Thanks million
-- 
Gang Chen
TILSI
Taicang Institute For Life Science Information
Address: A2/162, Renmin South Road, Taicang, 215400, Jiangsu Province,
P.R.China
Phone:（+86）512-82782588
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20120731/610abb6a/attachment.html>