home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 301468

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
636 636 301468 301468 PubChem (compound) 1 208689 208689 1
639 639 301468 301468 PubChem (compound) 1 136630 136630 2
648 648 301468 301468 PubChem (compound) 1 157922 157922 3
652 652 301468 301468 PubChem (compound) 1 140148 140148 4
656 656 301468 301468 PubChem (compound) 1 232227 232227 5
660 660 301468 301468 PubChem (compound) 1 281132 281132 6
130032 130032 301468 301468 PubChem (compound) 1 284638 284638 7
296456 296456 301468 301468 PubChem (substance) 2 208689 208689 1
296463 296463 301468 301468 PubChem (substance) 2 136630 136630 2
296476 296476 301468 301468 PubChem (substance) 2 157922 157922 3
296478 296478 301468 301468 PubChem (substance) 2 140148 140148 4
296484 296484 301468 301468 PubChem (substance) 2 232227 232227 5
296488 296488 301468 301468 PubChem (substance) 2 281132 281132 6
305315 305315 301468 301468 PubChem (substance) 2 7599 7599 7
308757 308757 301468 301468 PubChem (substance) 2 137995 137995 8
478907 478907 301468 301468 PubChem (substance) 2 284638 284638 11
777627 777627 301468 301468 PubChem (substance) 2 157923 157923 9
777629 777629 301468 301468 PubChem (substance) 2 334645 334645 10
938572 938572 301468 301468 CAS Common Chemistry 3 32583 32583 1
1135261 1135261 301468 301468 Computational Toxicology and Exposure Data 4 32583 32583 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 596.274ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website