home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 340534

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
1361 1361 340534 340534 PubChem (compound) 1 152808 152808 3
124762 124762 340534 340534 PubChem (compound) 1 173809 173809 1
265040 265040 340534 340534 PubChem (compound) 1 228988 228988 2
297456 297456 340534 340534 PubChem (substance) 2 152808 152808 6
308363 308363 340534 340534 PubChem (substance) 2 149856 149856 14
308400 308400 340534 340534 PubChem (substance) 2 137100 137100 10
471711 471711 340534 340534 PubChem (substance) 2 137613 137613 3
471720 471720 340534 340534 PubChem (substance) 2 138513 138513 8
471736 471736 340534 340534 PubChem (substance) 2 173809 173809 1
471750 471750 340534 340534 PubChem (substance) 2 195482 195482 15
652136 652136 340534 340534 PubChem (substance) 2 256855 256855 11
652481 652481 340534 340534 PubChem (substance) 2 228988 228988 5
771706 771706 340534 340534 PubChem (substance) 2 140396 140396 2
912757 912757 340534 340534 PubChem (substance) 2 208683 208683 4
912761 912761 340534 340534 PubChem (substance) 2 195165 195165 7
912763 912763 340534 340534 PubChem (substance) 2 260076 260076 9
912766 912766 340534 340534 PubChem (substance) 2 175450 175450 12
912767 912767 340534 340534 PubChem (substance) 2 256273 256273 13
912768 912768 340534 340534 PubChem (substance) 2 295048 295048 16
912769 912769 340534 340534 PubChem (substance) 2 309407 309407 17
912771 912771 340534 340534 PubChem (substance) 2 320669 320669 18
1115552 1115552 340534 340534 CAS Common Chemistry 3 54136 54136 1
1327373 1327373 340534 340534 Computational Toxicology and Exposure Data 4 106751 106751 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)
);
Powered by Datasette · Queries took 682.671ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website