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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
3270 3270 364053 364053 PubChem (compound) 1 53042 53042 1
300070 300070 364053 364053 PubChem (substance) 2 53042 53042 1
373147 373147 364053 364053 PubChem (substance) 2 52588 52588 3
550882 550882 364053 364053 PubChem (substance) 2 27568 27568 14
694648 694648 364053 364053 PubChem (substance) 2 259234 259234 2
694649 694649 364053 364053 PubChem (substance) 2 181574 181574 4
694656 694656 364053 364053 PubChem (substance) 2 232008 232008 5
694664 694664 364053 364053 PubChem (substance) 2 232009 232009 6
694669 694669 364053 364053 PubChem (substance) 2 232032 232032 7
694678 694678 364053 364053 PubChem (substance) 2 232033 232033 8
694683 694683 364053 364053 PubChem (substance) 2 232034 232034 9
694689 694689 364053 364053 PubChem (substance) 2 149542 149542 10
694694 694694 364053 364053 PubChem (substance) 2 232035 232035 11
694697 694697 364053 364053 PubChem (substance) 2 167932 167932 12
694700 694700 364053 364053 PubChem (substance) 2 137664 137664 13
940473 940473 364053 364053 CAS Common Chemistry 3 53042 53042 1
1137643 1137643 364053 364053 Computational Toxicology and Exposure Data 4 53042 53042 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 1112.539ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website