home / zeropm-v0-0-4

api_results

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

26 rows where query_id = 56884

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
96298 96298 56884 56884 PubChem (compound) 1 33625 33625 1
96301 96301 56884 56884 PubChem (compound) 1 275453 275453 2
431734 431734 56884 56884 PubChem (substance) 2 33625 33625 1
431738 431738 56884 56884 PubChem (substance) 2 275453 275453 6
747487 747487 56884 56884 PubChem (substance) 2 136744 136744 2
747490 747490 56884 56884 PubChem (substance) 2 185884 185884 3
747491 747491 56884 56884 PubChem (substance) 2 200908 200908 4
747494 747494 56884 56884 PubChem (substance) 2 200483 200483 5
747495 747495 56884 56884 PubChem (substance) 2 258838 258838 7
747497 747497 56884 56884 PubChem (substance) 2 297594 297594 8
747500 747500 56884 56884 PubChem (substance) 2 202991 202991 9
747501 747501 56884 56884 PubChem (substance) 2 148642 148642 10
747504 747504 56884 56884 PubChem (substance) 2 276386 276386 11
747505 747505 56884 56884 PubChem (substance) 2 247265 247265 12
747507 747507 56884 56884 PubChem (substance) 2 160388 160388 13
747508 747508 56884 56884 PubChem (substance) 2 223370 223370 14
747509 747509 56884 56884 PubChem (substance) 2 191748 191748 15
747510 747510 56884 56884 PubChem (substance) 2 261709 261709 16
747512 747512 56884 56884 PubChem (substance) 2 204337 204337 17
747513 747513 56884 56884 PubChem (substance) 2 309925 309925 18
747515 747515 56884 56884 PubChem (substance) 2 254897 254897 19
747518 747518 56884 56884 PubChem (substance) 2 323929 323929 20
747519 747519 56884 56884 PubChem (substance) 2 187778 187778 21
747522 747522 56884 56884 PubChem (substance) 2 334598 334598 22
1009481 1009481 56884 56884 CAS Common Chemistry 3 33625 33625 1
1211502 1211502 56884 56884 Computational Toxicology and Exposure Data 4 33625 33625 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 480.65ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website