api_results

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

14 rows where query_id = 13323

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22419 22419 13323 13323 PubChem (compound) 1 136302 136302 1
27215 27215 13323 13323 PubChem (compound) 1 138100 138100 2
327850 327850 13323 13323 PubChem (substance) 2 136302 136302 1
334505 334505 13323 13323 PubChem (substance) 2 138100 138100 2
334521 334521 13323 13323 PubChem (substance) 2 91910 91910 4
334525 334525 13323 13323 PubChem (substance) 2 218160 218160 11
710909 710909 13323 13323 PubChem (substance) 2 47902 47902 3
710915 710915 13323 13323 PubChem (substance) 2 253221 253221 12
710920 710920 13323 13323 PubChem (substance) 2 191920 191920 5
710924 710924 13323 13323 PubChem (substance) 2 198142 198142 6
710933 710933 13323 13323 PubChem (substance) 2 198143 198143 7
710941 710941 13323 13323 PubChem (substance) 2 206967 206967 8
710948 710948 13323 13323 PubChem (substance) 2 206968 206968 9
710954 710954 13323 13323 PubChem (substance) 2 207043 207043 10 
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)
);