home / zeropm-v0-0-4

api_results

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

22 rows where inchi_id = 138338

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
44585 44585 122753 122753 PubChem (compound) 1 138338 138338 1
44586 44586 19969 19969 PubChem (compound) 1 138338 138338 1
44587 44587 20243 20243 PubChem (compound) 1 138338 138338 1
44588 44588 91823 91823 PubChem (compound) 1 138338 138338 1
44589 44589 438984 438984 PubChem (compound) 1 138338 138338 1
44590 44590 441196 441196 PubChem (compound) 1 138338 138338 1
44591 44591 441197 441197 PubChem (compound) 1 138338 138338 1
359091 359091 19969 19969 PubChem (substance) 2 138338 138338 1
359092 359092 578 578 PubChem (substance) 2 138338 138338 1
359093 359093 20244 20244 PubChem (substance) 2 138338 138338 1
359094 359094 438984 438984 PubChem (substance) 2 138338 138338 1
359095 359095 579 579 PubChem (substance) 2 138338 138338 1
359096 359096 351113 351113 PubChem (substance) 2 138338 138338 1
359097 359097 351114 351114 PubChem (substance) 2 138338 138338 1
359098 359098 122753 122753 PubChem (substance) 2 138338 138338 1
359099 359099 20243 20243 PubChem (substance) 2 138338 138338 1
359100 359100 91822 91822 PubChem (substance) 2 138338 138338 1
359101 359101 441196 441196 PubChem (substance) 2 138338 138338 1
359102 359102 323900 323900 PubChem (substance) 2 138338 138338 1
359103 359103 441197 441197 PubChem (substance) 2 138338 138338 1
359104 359104 91823 91823 PubChem (substance) 2 138338 138338 1
359105 359105 351203 351203 PubChem (substance) 2 138338 138338 3
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 1063.198ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website