#! /usr/bin/python import cgi, pg, re, string from pg import DB buche=pg.DB(dbname='buche_4.8', user='postgres') numeri=['1','2','3','4','5','6','7','8','9','0'] def header(title): print 'Content-Type: text/html\n' print '\n\n%s\n\n\n\n\n' % (title) def footer(): print '' form=cgi.FieldStorage() formkeys=form.keys() header('Verify PDB code') print '

' for k in formkeys: #### controlla validita' del codice immesso #### if form[k].value=='submit': pdbcode=string.strip(k) elif k=='pdbcode': link='http://www.rcsb.org/pdb/cgi/explore.cgi?pid=208991029170421&page=0&pdbId='+string.upper(form[k].value) print '

The submitted code is ',form[k].value,'

' pdbcode=form[k].value else: break if len(pdbcode)!=4 or pdbcode[0] not in numeri: print '

Please, check the PDB code

' chain_id='errore' print '

Retry

' else: check=buche.query('select pdb.oid, pdb.header, pdb.compnd, pdb.source, pdb.author, pdb.title, pdb.keywds from pdb where pdb.name=\''+pdbcode+'\'').getresult() if check: print '' if check[0][1]: print '' if check[0][2]: print '' if check[0][3]: print '' if check[0][4]: print '' if check[0][5]: print '' if check[0][6]: print '' # print '
Header:

',re.sub(';','
',(re.sub('\$','',check[0][1]))),'

Compound:

',re.sub(';','
',(re.sub('\$','',check[0][2]))),'

Source:

',re.sub(';','
',(re.sub('\$','',check[0][3]))),'

Author:

',re.sub(';','
',(re.sub('\$','',check[0][4]))),'

Title:

',re.sub(';','
',(re.sub('\$','',check[0][5]))),'

Keywords:

',re.sub(';','
',(re.sub('\$','',check[0][6]))),'

' if check[0][0]: pdboid=check[0][0] catene=buche.query('select chains.name, chains.oid from chains where chains.pdb_id=\''+"%s"%(pdboid)+'\' order by chains.name').getresult() if not catene: print '

Something wrong happened, sorry


' print 'Try a different PDB code
' else: technique=buche.query('select chains.exp, chains.rid1 where chains.pdb_id='+"%s"%(pdboid)+' and chains.name=\''+string.strip(catene[0][0])+'\'').getresult() if technique[0][0]=='X': print 'Experimental Technique:

X-RAY DIFFRACTION

' print '' elif technique[0][0]=='N': print 'Experimental Technique:

NMR

' print '' print '

' print '' for i in range(len(catene)): # print check[0][0],catene[i][0],pdboid print '' catena=buche.query('select chains.groupid1, chains.rid1, chains.oid, chains.exp, chains.type from chains where chains.pdb_id='+"%s"%(pdboid)+' and chains.name=\''+string.strip(catene[i][0])+'\'').getresult() # catene=buche.query('select chains.groupid1, chains.rid1, chains.oid from chains where chains.pdb_id='+"%s"%(pdboid)+' and chains.name=\''+catena+'\'').getresult() if catena[0][1]=='f': print '' scelta=buche.query('select pdb.name, chains.pdb_id, chains.name, chains.rid1, chains.oid from pdb, chains where chains.rid1=\'t\' and chains.groupid1=\''+catena[0][0]+'\' and pdb.oid=chains.pdb_id and chains.exp!=\'N\'').getresult() if scelta: print '' check=buche.query('select pdb.oid, pdb.name, pdb.header, pdb.compnd, pdb.source, pdb.author, pdb.title, pdb.keywds from pdb where pdb.name=\''+scelta[0][0]+'\'').getresult() chain_id=catene[i][1] print '' print '' print '' print '' print '' print '' print '' else: print '' else: print '' chain_id=catene[i][1] print '' print '' print '' print '' print '' print '' print '' # if catena[0][4]=='int': # print '' # chain_id=catene[i][1] # print '' # print '' # print '' # print '' # print '' # print '' # print '' # else: # print '' # elif technique[0][0]=='N' and technique[0][1]=='f': # print '' # print '
ChainRedundancyRepresentative redundancy group memberSubmit
',catene[i][0],'Not representative','',scelta[0][0],'',scelta[0][2],'
No representative member availableRepresentative',pdbcode,'',catene[i][0]+'
Interesting
Experimental Technique:

NMR

' # print '

' print '

' else: print '

The submitted code is not present in the used PDB release

' print '

Try a different PDB code

' print '
' print 'mail to: surface@cbm.bio.uniroma2.it' print '

' print 'go to the home page ' print '

' footer()