home / zeropm-v0-0-4

api_results

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

17 rows where query_id = 333642

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
145211 145211 333642 333642 PubChem (compound) 1 18193 18193 1
326457 326457 333642 333642 PubChem (substance) 2 27434 27434 4
353385 353385 333642 333642 PubChem (substance) 2 56950 56950 2
391291 391291 333642 333642 PubChem (substance) 2 16874 16874 14
499040 499040 333642 333642 PubChem (substance) 2 18193 18193 1
500775 500775 333642 333642 PubChem (substance) 2 21767 21767 13
717284 717284 333642 333642 PubChem (substance) 2 188266 188266 3
788841 788841 333642 333642 PubChem (substance) 2 202189 202189 5
788843 788843 333642 333642 PubChem (substance) 2 202354 202354 6
788845 788845 333642 333642 PubChem (substance) 2 201583 201583 7
788848 788848 333642 333642 PubChem (substance) 2 169860 169860 8
788850 788850 333642 333642 PubChem (substance) 2 169872 169872 9
788852 788852 333642 333642 PubChem (substance) 2 201491 201491 10
788855 788855 333642 333642 PubChem (substance) 2 205063 205063 11
788856 788856 333642 333642 PubChem (substance) 2 201652 201652 12
1044018 1044018 333642 333642 CAS Common Chemistry 3 18193 18193 1
1231422 1231422 333642 333642 Computational Toxicology and Exposure Data 4 18193 18193 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 440.818ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website