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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
269117 269117 375866 375866 PubChem (compound) 1 43070 43070 1
478007 478007 375866 375866 PubChem (substance) 2 12661 12661 8
658655 658655 375866 375866 PubChem (substance) 2 43070 43070 1
918517 918517 375866 375866 PubChem (substance) 2 183658 183658 2
918518 918518 375866 375866 PubChem (substance) 2 242809 242809 3
918519 918519 375866 375866 PubChem (substance) 2 240666 240666 4
918520 918520 375866 375866 PubChem (substance) 2 234803 234803 5
918521 918521 375866 375866 PubChem (substance) 2 270321 270321 6
918522 918522 375866 375866 PubChem (substance) 2 282126 282126 7
918523 918523 375866 375866 PubChem (substance) 2 287971 287971 9
918524 918524 375866 375866 PubChem (substance) 2 289567 289567 10
918525 918525 375866 375866 PubChem (substance) 2 323957 323957 11
918526 918526 375866 375866 PubChem (substance) 2 256413 256413 12
918527 918527 375866 375866 PubChem (substance) 2 320410 320410 13
918528 918528 375866 375866 PubChem (substance) 2 309406 309406 14
918529 918529 375866 375866 PubChem (substance) 2 309933 309933 15
918530 918530 375866 375866 PubChem (substance) 2 320741 320741 16
918531 918531 375866 375866 PubChem (substance) 2 334562 334562 17
1117840 1117840 375866 375866 CAS Common Chemistry 3 43070 43070 1
1329398 1329398 375866 375866 Computational Toxicology and Exposure Data 4 43070 43070 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 1337.364ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website