api_results

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

11 rows where query_id = 79321

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
28524 28524 79321 79321 PubChem (compound) 1 64 64 1
336259 336259 79321 79321 PubChem (substance) 2 64 64 1
760418 760418 79321 79321 PubChem (substance) 2 223915 223915 8
760423 760423 79321 79321 PubChem (substance) 2 148760 148760 2
760425 760425 79321 79321 PubChem (substance) 2 202884 202884 3
760426 760426 79321 79321 PubChem (substance) 2 206447 206447 4
760427 760427 79321 79321 PubChem (substance) 2 203321 203321 5
760428 760428 79321 79321 PubChem (substance) 2 185174 185174 6
760429 760429 79321 79321 PubChem (substance) 2 240525 240525 7
959121 959121 79321 79321 CAS Common Chemistry 3 64 64 1
1159597 1159597 79321 79321 Computational Toxicology and Exposure Data 4 64 64 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)
);