api_results

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

12 rows where query_id = 378281

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
271303 271303 378281 378281 PubChem (compound) 1 27854 27854 1
313190 313190 378281 378281 PubChem (substance) 2 27891 27891 9
351870 351870 378281 378281 PubChem (substance) 2 157286 157286 2
648786 648786 378281 378281 PubChem (substance) 2 177447 177447 10
661395 661395 378281 378281 PubChem (substance) 2 27854 27854 1
716859 716859 378281 378281 PubChem (substance) 2 179616 179616 5
921451 921451 378281 378281 PubChem (substance) 2 177818 177818 3
921452 921452 378281 378281 PubChem (substance) 2 247412 247412 4
921453 921453 378281 378281 PubChem (substance) 2 203234 203234 6
921454 921454 378281 378281 PubChem (substance) 2 209611 209611 7
921455 921455 378281 378281 PubChem (substance) 2 225425 225425 8
1118621 1118621 378281 378281 CAS Common Chemistry 3 27854 27854 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)
);