home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 13322

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22412 22412 13322 13322 PubChem (compound) 1 136302 136302 3
27213 27213 13322 13322 PubChem (compound) 1 138100 138100 1
27220 27220 13322 13322 PubChem (compound) 1 91910 91910 2
27224 27224 13322 13322 PubChem (compound) 1 218160 218160 4
27225 27225 13322 13322 PubChem (compound) 1 231795 231795 5
27226 27226 13322 13322 PubChem (compound) 1 298020 298020 6
327849 327849 13322 13322 PubChem (substance) 2 136302 136302 4
327896 327896 13322 13322 PubChem (substance) 2 167483 167483 5
334504 334504 13322 13322 PubChem (substance) 2 138100 138100 1
334512 334512 13322 13322 PubChem (substance) 2 91910 91910 3
334524 334524 13322 13322 PubChem (substance) 2 218160 218160 6
334528 334528 13322 13322 PubChem (substance) 2 231795 231795 15
334529 334529 13322 13322 PubChem (substance) 2 298020 298020 9
710908 710908 13322 13322 PubChem (substance) 2 47902 47902 2
710913 710913 13322 13322 PubChem (substance) 2 253221 253221 7
710919 710919 13322 13322 PubChem (substance) 2 191920 191920 8
710926 710926 13322 13322 PubChem (substance) 2 198142 198142 10
710931 710931 13322 13322 PubChem (substance) 2 198143 198143 11
710938 710938 13322 13322 PubChem (substance) 2 206967 206967 12
710946 710946 13322 13322 PubChem (substance) 2 206968 206968 13
710952 710952 13322 13322 PubChem (substance) 2 207043 207043 14
958140 958140 13322 13322 CAS Common Chemistry 3 47902 47902 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 1849.724ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website