api_results

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

14 rows where query_id = 301473

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
257998 257998 301473 301473 PubChem (compound) 1 33460 33460 1
641906 641906 301473 301473 PubChem (substance) 2 33460 33460 1
659090 659090 301473 301473 PubChem (substance) 2 241699 241699 11
739253 739253 301473 301473 PubChem (substance) 2 136588 136588 2
845930 845930 301473 301473 PubChem (substance) 2 253755 253755 3
845932 845932 301473 301473 PubChem (substance) 2 239009 239009 5
845935 845935 301473 301473 PubChem (substance) 2 210396 210396 4
845938 845938 301473 301473 PubChem (substance) 2 237581 237581 6
845941 845941 301473 301473 PubChem (substance) 2 310001 310001 10
845942 845942 301473 301473 PubChem (substance) 2 316804 316804 7
845943 845943 301473 301473 PubChem (substance) 2 314986 314986 8
845944 845944 301473 301473 PubChem (substance) 2 275020 275020 9
1112458 1112458 301473 301473 CAS Common Chemistry 3 33460 33460 1
1323210 1323210 301473 301473 Computational Toxicology and Exposure Data 4 33460 33460 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)
);