hscellor_virbase4

SELECT * FROM virbase_baseinfo WHERE virbase='VHID00544169';

SELECT * FROM virbase_idlink WHERE virbase='VHID00544169';

SELECT * FROM virbase_alias WHERE id='' AND (spe='' or strain_spe='');

SELECT * FROM virbase_alias WHERE id='' AND (spe='' or strain_spe='');

SELECT * FROM virbase_editing1 WHERE id='';

SELECT * FROM virbase_editing1 WHERE id='';

SELECT * FROM virbase_editing2 WHERE id='';

SELECT * FROM virbase_editing2 WHERE id='';

SELECT * FROM virbase_editing3 WHERE id='';

SELECT * FROM virbase_editing3 WHERE id='';

SELECT * FROM virbase_drug1 WHERE id=''ORDER BY cid DESC;

SELECT * FROM virbase_drug1 WHERE id=''ORDER BY cid DESC;

SELECT * FROM virbase_drug2 WHERE id=''ORDER BY cid DESC;

SELECT * FROM virbase_drug2 WHERE id=''ORDER BY cid DESC;

SELECT * FROM virbase_drug3 WHERE id=''ORDER BY cid DESC;

SELECT * FROM virbase_drug3 WHERE id=''ORDER BY cid DESC;

SELECT * FROM virbase_drug4 WHERE id=''ORDER BY cid DESC;

SELECT * FROM virbase_drug4 WHERE id=''ORDER BY cid DESC;

SELECT * FROM virbase_location WHERE id='' order by location asc;

SELECT * FROM virbase_location WHERE id='' order by location asc;

SELECT * FROM virbase_modification WHERE id='';

SELECT * FROM virbase_modification WHERE id='';

SELECT * FROM virbase_snp1 WHERE geneid='';

SELECT * FROM virbase_snp1 WHERE geneid='';

SELECT * FROM virbase_snp2 WHERE geneid='';

SELECT * FROM virbase_snp2 WHERE geneid='';

SELECT * FROM virbase_supple WHERE virbase='VHID00544169';

( SELECT virbase,actor1,cate1,spe1,actor2,cate2,spe2,Score FROM virbase_baseinfo WHERE binary actor1 = '' AND spe1='' ) union ( SELECT virbase,actor1,cate1,spe1,actor2,cate2,spe2,Score FROM virbase_baseinfo WHERE binary actor2 = '' AND spe2 = '' ) order by Score DESC,virbase DESC LIMIT 0,100;

( SELECT virbase,actor1,cate1,spe1,actor2,cate2,spe2,Score FROM virbase_baseinfo WHERE binary actor1 = '' AND spe1='' ) union ( SELECT virbase,actor1,cate1,spe1,actor2,cate2,spe2,Score FROM virbase_baseinfo WHERE binary actor2 = '' AND spe2 = '' ) order by Score DESC,virbase DESC LIMIT 0,100;

SELECT * FROM virbase_desc WHERE virbase='VHID00544169';

SELECT geneid,seq from virbase_seq_rna WHERE geneid=''

SELECT geneid,seq from virbase_seq_rna WHERE geneid=''