home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 154190

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
137659 137659 154190 154190 PubChem (compound) 1 91913 91913 1
382013 382013 154190 154190 PubChem (substance) 2 169214 169214 2
459330 459330 154190 154190 PubChem (substance) 2 37598 37598 11
489071 489071 154190 154190 PubChem (substance) 2 66350 66350 1
489076 489076 154190 154190 PubChem (substance) 2 149807 149807 3
489092 489092 154190 154190 PubChem (substance) 2 91913 91913 4
522141 522141 154190 154190 PubChem (substance) 2 141906 141906 12
537942 537942 154190 154190 PubChem (substance) 2 135616 135616 13
674485 674485 154190 154190 PubChem (substance) 2 136365 136365 5
674497 674497 154190 154190 PubChem (substance) 2 169518 169518 6
750596 750596 154190 154190 PubChem (substance) 2 195844 195844 10
808149 808149 154190 154190 PubChem (substance) 2 138618 138618 7
808151 808151 154190 154190 PubChem (substance) 2 148770 148770 8
808152 808152 154190 154190 PubChem (substance) 2 195843 195843 9
1038378 1038378 154190 154190 CAS Common Chemistry 3 66350 66350 2
1065561 1065561 154190 154190 CAS Common Chemistry 3 13261 13261 1
1241362 1241362 154190 154190 Computational Toxicology and Exposure Data 4 66350 66350 2
1267347 1267347 154190 154190 Computational Toxicology and Exposure Data 4 13261 13261 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 542.823ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website