api_results

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

14 rows where query_id = 437837

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22415 22415 437837 437837 PubChem (compound) 1 136302 136302 1
27218 27218 437837 437837 PubChem (compound) 1 138100 138100 2
327846 327846 437837 437837 PubChem (substance) 2 136302 136302 1
334510 334510 437837 437837 PubChem (substance) 2 138100 138100 2
334514 334514 437837 437837 PubChem (substance) 2 91910 91910 4
334527 334527 437837 437837 PubChem (substance) 2 218160 218160 11
710912 710912 437837 437837 PubChem (substance) 2 47902 47902 3
710914 710914 437837 437837 PubChem (substance) 2 253221 253221 12
710921 710921 437837 437837 PubChem (substance) 2 191920 191920 5
710930 710930 437837 437837 PubChem (substance) 2 198142 198142 6
710936 710936 437837 437837 PubChem (substance) 2 198143 198143 7
710943 710943 437837 437837 PubChem (substance) 2 206967 206967 8
710951 710951 437837 437837 PubChem (substance) 2 206968 206968 9
710957 710957 437837 437837 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)
);