api_results

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

18 rows where query_id = 93652

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
319241 319241 93652 93652 PubChem (substance) 2 4023 4023 3
364636 364636 93652 93652 PubChem (substance) 2 26807 26807 14
428004 428004 93652 93652 PubChem (substance) 2 37927 37927 8
432390 432390 93652 93652 PubChem (substance) 2 40956 40956 1
463853 463853 93652 93652 PubChem (substance) 2 78268 78268 2
663454 663454 93652 93652 PubChem (substance) 2 140460 140460 4
663456 663456 93652 93652 PubChem (substance) 2 136881 136881 5
704141 704141 93652 93652 PubChem (substance) 2 163558 163558 13
766588 766588 93652 93652 PubChem (substance) 2 169363 169363 6
766589 766589 93652 93652 PubChem (substance) 2 169418 169418 7
766590 766590 93652 93652 PubChem (substance) 2 184594 184594 9
766591 766591 93652 93652 PubChem (substance) 2 234435 234435 10
766592 766592 93652 93652 PubChem (substance) 2 234436 234436 11
766593 766593 93652 93652 PubChem (substance) 2 234434 234434 12
950627 950627 93652 93652 CAS Common Chemistry 3 4023 4023 1
964834 964834 93652 93652 CAS Common Chemistry 3 43680 43680 2
1025093 1025093 93652 93652 CAS Common Chemistry 3 78268 78268 3
1189138 1189138 93652 93652 Computational Toxicology and Exposure Data 4 94316 94316 1 
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);