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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
60973 60973 28375 28375 PubChem (compound) 1 141047 141047 1
60974 60974 28375 28375 PubChem (compound) 1 224958 224958 2
300456 300456 28375 28375 PubChem (substance) 2 31905 31905 12
347465 347465 28375 28375 PubChem (substance) 2 38144 38144 15
382206 382206 28375 28375 PubChem (substance) 2 141047 141047 1
382208 382208 28375 28375 PubChem (substance) 2 224958 224958 2
472468 472468 28375 28375 PubChem (substance) 2 110552 110552 4
665329 665329 28375 28375 PubChem (substance) 2 129484 129484 13
728150 728150 28375 28375 PubChem (substance) 2 184020 184020 6
728152 728152 28375 28375 PubChem (substance) 2 159052 159052 5
728153 728153 28375 28375 PubChem (substance) 2 309827 309827 14
728155 728155 28375 28375 PubChem (substance) 2 182196 182196 3
728156 728156 28375 28375 PubChem (substance) 2 204031 204031 7
728157 728157 28375 28375 PubChem (substance) 2 168965 168965 8
728158 728158 28375 28375 PubChem (substance) 2 169117 169117 9
728159 728159 28375 28375 PubChem (substance) 2 199807 199807 10
728160 728160 28375 28375 PubChem (substance) 2 197802 197802 11
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 563.853ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website