create table human_bioactivity select compound_structures.molregno, compound_structures.canonical_smiles, activities.standard_value, activities.standard_units, activities.standard_type, activities.standard_relation, target_dictionary.tid from target_dictionary,assays,activities,molecule_dictionary,compound_structures where compound_structures.molregno = molecule_dictionary.molregno and molecule_dictionary.molregno = activities.molregno and activities.assay_id = assays.assay_id and assays.tid = target_dictionary.tid and target_dictionary.organism = 'Homo sapiens' and target_dictionary.target_type = 'SINGLE PROTEIN' and activities.standard_value is not null and activities.standard_units = 'nM' and assays.confidence_score >= 8 and activities.standard_value <= 10000 and ( activities.standard_relation = '<' or activities.standard_relation = '<=' or activities.standard_relation = '=' ) and ( activities.standard_type = 'IC50' or activities.standard_type = 'pIC50' or activities.standard_type = 'Ki' or activities.standard_type = 'pKi' or activities.standard_type = 'Kd' or activities.standard_type = 'EC50' or activities.standard_type = 'pEC50' or activities.standard_type = 'pKd' ) ;