api_results

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

11 rows where query_id = 96836

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
382253 382253 96836 96836 PubChem (substance) 2 181710 181710 1
451295 451295 96836 96836 PubChem (substance) 2 6863 6863 3
489909 489909 96836 96836 PubChem (substance) 2 74989 74989 4
728201 728201 96836 96836 PubChem (substance) 2 245810 245810 8
758954 758954 96836 96836 PubChem (substance) 2 186520 186520 5
767611 767611 96836 96836 PubChem (substance) 2 169683 169683 2
767612 767612 96836 96836 PubChem (substance) 2 189016 189016 6
767613 767613 96836 96836 PubChem (substance) 2 195295 195295 7
767614 767614 96836 96836 PubChem (substance) 2 326824 326824 9
767615 767615 96836 96836 PubChem (substance) 2 327220 327220 10
767616 767616 96836 96836 PubChem (substance) 2 169696 169696 11 
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)
);