home / zeropm-v0-0-4

api_results

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

16 rows where query_id = 120465

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
140339 140339 120465 120465 PubChem (compound) 1 90299 90299 1
492560 492560 120465 120465 PubChem (substance) 2 90299 90299 1
664971 664971 120465 120465 PubChem (substance) 2 93124 93124 3
785085 785085 120465 120465 PubChem (substance) 2 136377 136377 2
785087 785087 120465 120465 PubChem (substance) 2 154315 154315 4
785088 785088 120465 120465 PubChem (substance) 2 191994 191994 5
785090 785090 120465 120465 PubChem (substance) 2 170073 170073 6
785092 785092 120465 120465 PubChem (substance) 2 170043 170043 7
785093 785093 120465 120465 PubChem (substance) 2 292521 292521 8
785094 785094 120465 120465 PubChem (substance) 2 239275 239275 9
785096 785096 120465 120465 PubChem (substance) 2 254062 254062 10
785097 785097 120465 120465 PubChem (substance) 2 227706 227706 11
785099 785099 120465 120465 PubChem (substance) 2 220851 220851 12
785101 785101 120465 120465 PubChem (substance) 2 247103 247103 13
1040417 1040417 120465 120465 CAS Common Chemistry 3 90299 90299 1
1243400 1243400 120465 120465 Computational Toxicology and Exposure Data 4 90299 90299 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 443.246ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website