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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
122082 122082 99329 99329 PubChem (compound) 1 55999 55999 1
428367 428367 99329 99329 PubChem (substance) 2 48804 48804 6
467791 467791 99329 99329 PubChem (substance) 2 55999 55999 1
477158 477158 99329 99329 PubChem (substance) 2 8461 8461 10
497410 497410 99329 99329 PubChem (substance) 2 14307 14307 12
500299 500299 99329 99329 PubChem (substance) 2 21020 21020 5
515613 515613 99329 99329 PubChem (substance) 2 49036 49036 11
654685 654685 99329 99329 PubChem (substance) 2 90371 90371 9
679153 679153 99329 99329 PubChem (substance) 2 55999 55999 2
701433 701433 99329 99329 PubChem (substance) 2 173397 173397 16
768809 768809 99329 99329 PubChem (substance) 2 168394 168394 3
768810 768810 99329 99329 PubChem (substance) 2 155181 155181 4
768811 768811 99329 99329 PubChem (substance) 2 223126 223126 7
768812 768812 99329 99329 PubChem (substance) 2 222981 222981 8
768813 768813 99329 99329 PubChem (substance) 2 156336 156336 13
768814 768814 99329 99329 PubChem (substance) 2 223261 223261 14
768815 768815 99329 99329 PubChem (substance) 2 181491 181491 15
1026943 1026943 99329 99329 CAS Common Chemistry 3 55999 55999 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 436.339ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website