Table With Snornabase Information?

Question

[Leandro Lima]

Hello!

I have a list of snoRNABase ids (https://www-snorna.biotoul.fr/browse.php?sno=CDBox), and I need to get the information available in the pages like this:

https://www-snorna.biotoul.fr/plus.php?id=SNORD125

I'm writing a program to get it, but... I was wondering if someone here has already done it.

[Istvan Albert]

thanks for following up and posting the solution

Answer 1

[Leandro Lima]

The code, in Python.

# download_snoRNABase_info.py
# Created in: Jan 16, 2013
# Last modified in: Jan 16, 2013
# Leandro Lima <[e-mail]>

from lxml.html import parse, document_fromstring
from twill.commands import *
import twill
from StringIO import StringIO
twill.set_output(StringIO())

output = open('snoRNA_info.csv', 'w')
output.write('name\tsno_id\tdescription\tbiotype\n')
link = 'snoRNABase_CDBox.html'
page = parse(link).getroot()
tr = page.find_class('traitbleu')
for td in tr[0].getchildren():
    # Reading ids
    for a in td.cssselect('a'):
        name = a.text
        link = 'https://www-snorna.biotoul.fr/plus.php?id=' + name
        x = go(link)
        text = show()
        page2 = document_fromstring(text)
        table = page2.find_class('tablecadre')[1]
        tr2 = table.getchildren()[2]
        sno_id = tr2[0].getchildren()[0].text
        description = tr2[1].text
        print name, sno_id, description
        output.write('%s\t%s\t%s\t%s\n' % (name, sno_id, description, 'snoRNA'))

Answer 2

[Leandro Lima]

Solved.

=)

The result, in case you need:

www.vision.ime.usp.br/~llima/snoRNA_info.csv