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 = 159492

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
178738 178738 159492 159492 PubChem (compound) 1 19907 19907 1
178740 178740 159492 159492 PubChem (compound) 1 259489 259489 2
178742 178742 159492 159492 PubChem (compound) 1 171665 171665 3
178743 178743 159492 159492 PubChem (compound) 1 141341 141341 4
178746 178746 159492 159492 PubChem (compound) 1 162521 162521 5
178748 178748 159492 159492 PubChem (compound) 1 326337 326337 8
178749 178749 159492 159492 PubChem (compound) 1 325926 325926 6
178750 178750 159492 159492 PubChem (compound) 1 284643 284643 7
543215 543215 159492 159492 PubChem (substance) 2 19907 19907 1
543218 543218 159492 159492 PubChem (substance) 2 259489 259489 2
543220 543220 159492 159492 PubChem (substance) 2 171665 171665 3
543222 543222 159492 159492 PubChem (substance) 2 141341 141341 5
543223 543223 159492 159492 PubChem (substance) 2 162521 162521 4
543226 543226 159492 159492 PubChem (substance) 2 326337 326337 12
543227 543227 159492 159492 PubChem (substance) 2 325926 325926 7
543228 543228 159492 159492 PubChem (substance) 2 284643 284643 11
811628 811628 159492 159492 PubChem (substance) 2 188336 188336 6
811629 811629 159492 159492 PubChem (substance) 2 200380 200380 8
811630 811630 159492 159492 PubChem (substance) 2 200001 200001 9
811631 811631 159492 159492 PubChem (substance) 2 190475 190475 10
811632 811632 159492 159492 PubChem (substance) 2 182830 182830 13
1069429 1069429 159492 159492 CAS Common Chemistry 3 19907 19907 1
1270898 1270898 159492 159492 Computational Toxicology and Exposure Data 4 19907 19907 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 444.418ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website