home / zeropm-v0-0-4

api_results

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

29 rows where query_id = 101339

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
33653 33653 101339 101339 PubChem (compound) 1 101857 101857 1
295857 295857 101339 101339 PubChem (substance) 2 60357 60357 4
343701 343701 101339 101339 PubChem (substance) 2 101857 101857 1
375842 375842 101339 101339 PubChem (substance) 2 103259 103259 2
432270 432270 101339 101339 PubChem (substance) 2 69414 69414 23
590051 590051 101339 101339 PubChem (substance) 2 131665 131665 24
595909 595909 101339 101339 PubChem (substance) 2 7365 7365 26
607736 607736 101339 101339 PubChem (substance) 2 101769 101769 25
690392 690392 101339 101339 PubChem (substance) 2 225375 225375 3
694803 694803 101339 101339 PubChem (substance) 2 232062 232062 5
694808 694808 101339 101339 PubChem (substance) 2 232063 232063 6
694829 694829 101339 101339 PubChem (substance) 2 232064 232064 7
694836 694836 101339 101339 PubChem (substance) 2 232065 232065 8
694874 694874 101339 101339 PubChem (substance) 2 232068 232068 9
694906 694906 101339 101339 PubChem (substance) 2 232072 232072 10
694917 694917 101339 101339 PubChem (substance) 2 232073 232073 11
694933 694933 101339 101339 PubChem (substance) 2 232074 232074 12
694956 694956 101339 101339 PubChem (substance) 2 232076 232076 13
725280 725280 101339 101339 PubChem (substance) 2 179947 179947 20
762195 762195 101339 101339 PubChem (substance) 2 232142 232142 14
762290 762290 101339 101339 PubChem (substance) 2 232180 232180 16
762306 762306 101339 101339 PubChem (substance) 2 232188 232188 19
763109 763109 101339 101339 PubChem (substance) 2 232143 232143 15
763124 763124 101339 101339 PubChem (substance) 2 232184 232184 17
763132 763132 101339 101339 PubChem (substance) 2 232185 232185 18
769542 769542 101339 101339 PubChem (substance) 2 174976 174976 21
769543 769543 101339 101339 PubChem (substance) 2 174977 174977 22
962683 962683 101339 101339 CAS Common Chemistry 3 7365 7365 1
1163969 1163969 101339 101339 Computational Toxicology and Exposure Data 4 101857 101857 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 823.193ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website