class Pfamseq(Base): pfamseq_acc = db.Column( db.String(10), primary_key=True) pfamseq_id = db.Column( db.String(16), index=True)
class PfamAPfamseq(db.Model): __tablename__ = 'pfamA_pfamseq' pfamseq_id = db.Column(db.String(40), index=True) pfamA_acc = db.Column(db.String(7), index=True) pfamseq_acc = db.Column(db.String(10), index=True) has_pdb = db.Column(db.Boolean, default=False) __table_args__ = ( PrimaryKeyConstraint('pfamseq_id', 'pfamA_acc', 'pfamseq_acc'), {}, )
class Pdb(db.Model): pdb_id = db.Column(db.String(5), primary_key=True) title = db.Column(db.UnicodeText) method = db.Column(db.UnicodeText) resolution = db.Column(db.Numeric) author = db.Column(db.UnicodeText) date = db.Column(db.UnicodeText)
class PfamARegFullSignificant(db.Model): __tablename__ = 'pfamA_reg_full_significant' pfamA_acc = db.Column( db.String(7), index=True) pfamseq_acc = db.Column( db.String(10), index=True) seq_start = db.Column( db.Integer, index=True) seq_end = db.Column( db.Integer) in_full = db.Column( db.Integer, index=True) __table_args__ = ( PrimaryKeyConstraint('pfamA_acc', 'pfamseq_acc', 'seq_start', 'in_full'), {}, )
class UniprotRegFull(db.Model): auto_uniprot_reg_full = db.Column(INTEGER(unsigned=True), primary_key=True) pfamA_acc = db.Column(db.String(7), db.ForeignKey('pfamA.pfamA_acc')) pfamA = db.relationship('PfamA', backref=db.backref('uniprots')) uniprot_acc = db.Column(db.String(10), db.ForeignKey('uniprot.uniprot_acc')) uniprot = db.relationship('Uniprot', backref=db.backref('pfams')) seq_start = db.Column(db.Integer, index=True) seq_end = db.Column(db.Integer) in_full = db.Column(db.Integer, index=True) __table_args__ = ( PrimaryKeyConstraint('pfamA_acc', 'uniprot_acc', 'seq_start', 'in_full'), {}, )
class PdbPfamAReg(db.Model): __tablename__ = 'pdb_pfamA_reg' # auto_pfamA_reg_full = db.Column( # db.Integer, # primary_key=True) auto_uniprot_reg_full = db.Column( INTEGER(unsigned=True), db.ForeignKey('uniprot_reg_full.auto_uniprot_reg_full')) uniprot_reg_full = db.relationship('UniprotRegFull', backref=db.backref('pdbs')) pdb_id = db.Column(db.String(5), db.ForeignKey('pdb.pdb_id')) pdb = db.relationship('Pdb', backref=db.backref('pfams')) chain = db.Column(db.String(4), index=True) pfamA_acc = db.Column(db.String(7), index=True) pfamseq_acc = db.Column(db.String(10), index=True) pdb_res_start = db.Column(db.Integer, index=True) pdb_res_end = db.Column(db.Integer, index=True) __table_args__ = ( PrimaryKeyConstraint('auto_uniprot_reg_full', 'pdb_id'), {}, )
class PfamA(Base): pfamA_acc = db.Column(db.String(7), primary_key=True) pfamA_id = db.Column(db.String(16), index=True, unique=True) description = db.Column(db.UnicodeText) num_full = db.Column(db.Integer)
class Uniprot(Base): uniprot_acc = db.Column(db.String(10), primary_key=True) uniprot_id = db.Column(db.String(16), index=True, unique=True) description = db.Column(db.UnicodeText)