api_results

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

10 rows where query_id = 102993

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
60920 60920 102993 102993 PubChem (compound) 1 185090 185090 1
60925 60925 102993 102993 PubChem (compound) 1 274758 274758 2
60927 60927 102993 102993 PubChem (compound) 1 308113 308113 3
382102 382102 102993 102993 PubChem (substance) 2 195799 195799 4
382124 382124 102993 102993 PubChem (substance) 2 185090 185090 1
382126 382126 102993 102993 PubChem (substance) 2 230324 230324 2
382132 382132 102993 102993 PubChem (substance) 2 274758 274758 5
382134 382134 102993 102993 PubChem (substance) 2 308113 308113 7
728064 728064 102993 102993 PubChem (substance) 2 237632 237632 3
728088 728088 102993 102993 PubChem (substance) 2 239092 239092 6 
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)
);