home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 101313

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
10464 10464 101313 101313 PubChem (compound) 1 76691 76691 1
310441 310441 101313 101313 PubChem (substance) 2 76691 76691 1
366020 366020 101313 101313 PubChem (substance) 2 28000 28000 5
409811 409811 101313 101313 PubChem (substance) 2 62069 62069 13
505566 505566 101313 101313 PubChem (substance) 2 30917 30917 6
651131 651131 101313 101313 PubChem (substance) 2 133202 133202 8
699996 699996 101313 101313 PubChem (substance) 2 208795 208795 2
699998 699998 101313 101313 PubChem (substance) 2 174812 174812 3
700000 700000 101313 101313 PubChem (substance) 2 176667 176667 4
700002 700002 101313 101313 PubChem (substance) 2 176715 176715 7
700004 700004 101313 101313 PubChem (substance) 2 247122 247122 9
700006 700006 101313 101313 PubChem (substance) 2 176765 176765 10
700009 700009 101313 101313 PubChem (substance) 2 198105 198105 11
700010 700010 101313 101313 PubChem (substance) 2 186062 186062 12
700012 700012 101313 101313 PubChem (substance) 2 220398 220398 14
700015 700015 101313 101313 PubChem (substance) 2 249392 249392 15
700016 700016 101313 101313 PubChem (substance) 2 245315 245315 16
700018 700018 101313 101313 PubChem (substance) 2 202524 202524 17
700020 700020 101313 101313 PubChem (substance) 2 198098 198098 18
945903 945903 101313 101313 CAS Common Chemistry 3 76691 76691 1
1143925 1143925 101313 101313 Computational Toxicology and Exposure Data 4 76691 76691 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 903.064ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website