home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 118590

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
41987 41987 118590 118590 PubChem (compound) 1 190604 190604 1
355456 355456 118590 118590 PubChem (substance) 2 190604 190604 1
439989 439989 118590 118590 PubChem (substance) 2 32522 32522 6
440109 440109 118590 118590 PubChem (substance) 2 54850 54850 2
462969 462969 118590 118590 PubChem (substance) 2 44588 44588 13
490401 490401 118590 118590 PubChem (substance) 2 77668 77668 16
506888 506888 118590 118590 PubChem (substance) 2 33226 33226 7
512233 512233 118590 118590 PubChem (substance) 2 42873 42873 12
565114 565114 118590 118590 PubChem (substance) 2 41566 41566 10
571009 571009 118590 118590 PubChem (substance) 2 49379 49379 14
670773 670773 118590 118590 PubChem (substance) 2 119200 119200 9
670788 670788 118590 118590 PubChem (substance) 2 34905 34905 5
762714 762714 118590 118590 PubChem (substance) 2 157440 157440 8
783785 783785 118590 118590 PubChem (substance) 2 179119 179119 3
783786 783786 118590 118590 PubChem (substance) 2 171026 171026 4
783787 783787 118590 118590 PubChem (substance) 2 251573 251573 11
783788 783788 118590 118590 PubChem (substance) 2 177456 177456 15
968883 968883 118590 118590 CAS Common Chemistry 3 74879 74879 1
1171035 1171035 118590 118590 Computational Toxicology and Exposure Data 4 133426 133426 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 441.506ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website