home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 26423

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
57753 57753 26423 26423 PubChem (compound) 1 59839 59839 1
327820 327820 26423 26423 PubChem (substance) 2 8748 8748 13
327836 327836 26423 26423 PubChem (substance) 2 168939 168939 5
375375 375375 26423 26423 PubChem (substance) 2 171178 171178 6
377394 377394 26423 26423 PubChem (substance) 2 59839 59839 1
444895 444895 26423 26423 PubChem (substance) 2 207028 207028 12
708168 708168 26423 26423 PubChem (substance) 2 235027 235027 2
725910 725910 26423 26423 PubChem (substance) 2 230861 230861 3
725912 725912 26423 26423 PubChem (substance) 2 177683 177683 4
725917 725917 26423 26423 PubChem (substance) 2 151331 151331 7
725918 725918 26423 26423 PubChem (substance) 2 261898 261898 8
725919 725919 26423 26423 PubChem (substance) 2 264577 264577 9
725920 725920 26423 26423 PubChem (substance) 2 216055 216055 10
725921 725921 26423 26423 PubChem (substance) 2 231216 231216 11
725925 725925 26423 26423 PubChem (substance) 2 308136 308136 14
725926 725926 26423 26423 PubChem (substance) 2 309544 309544 15
725927 725927 26423 26423 PubChem (substance) 2 334457 334457 16
980457 980457 26423 26423 CAS Common Chemistry 3 59839 59839 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 508.791ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website