api_results

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

12 rows where query_id = 375532

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
4815 4815 375532 375532 PubChem (compound) 1 47438 47438 3
4828 4828 375532 375532 PubChem (compound) 1 62974 62974 4
110862 110862 375532 375532 PubChem (compound) 1 62145 62145 1
268680 268680 375532 375532 PubChem (compound) 1 209628 209628 2
302255 302255 375532 375532 PubChem (substance) 2 47438 47438 3
302279 302279 375532 375532 PubChem (substance) 2 62974 62974 6
452142 452142 375532 375532 PubChem (substance) 2 62145 62145 1
658114 658114 375532 375532 PubChem (substance) 2 209628 209628 2
917894 917894 375532 375532 PubChem (substance) 2 209629 209629 4
917895 917895 375532 375532 PubChem (substance) 2 295338 295338 5
1117699 1117699 375532 375532 CAS Common Chemistry 3 70506 70506 1
1329197 1329197 375532 375532 Computational Toxicology and Exposure Data 4 70506 70506 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)
);