blob: d0d18ff518105ecd0c65e80a01591d4cb80dc561 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
import sys
import os
import MySQLdb
import time
db='db_webqtl_leiyan'
author="megan memphis"
con = MySQLdb.Connect(db=db,user='webqtlupd',passwd='webqtl', host="localhost")
cursor = con.cursor()
cursor.execute('select PhenotypeId, Locus, DataId, Phenotype.Post_publication_description from PublishXRef, Phenotype where PublishXRef.PhenotypeId = Phenotype.Id and InbredSetId=%s'%InbredSetId)
PublishXRefInfos = cursor.fetchall()
|
