api_results

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

28 rows where inchi_id = 45398

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
1947 1947 17021 17021 PubChem (compound) 1 45398 45398 1
1948 1948 979 979 PubChem (compound) 1 45398 45398 1
1949 1949 978 978 PubChem (compound) 1 45398 45398 1
1950 1950 231909 231909 PubChem (compound) 1 45398 45398 1
1951 1951 86457 86457 PubChem (compound) 1 45398 45398 1
298302 298302 86457 86457 PubChem (substance) 2 45398 45398 1
298303 298303 978 978 PubChem (substance) 2 45398 45398 1
298304 298304 86073 86073 PubChem (substance) 2 45398 45398 3
298305 298305 979 979 PubChem (substance) 2 45398 45398 1
298306 298306 117361 117361 PubChem (substance) 2 45398 45398 5
298307 298307 788 788 PubChem (substance) 2 45398 45398 3
298308 298308 17021 17021 PubChem (substance) 2 45398 45398 1
298309 298309 399814 399814 PubChem (substance) 2 45398 45398 3
298310 298310 231909 231909 PubChem (substance) 2 45398 45398 1
298311 298311 365865 365865 PubChem (substance) 2 45398 45398 5
298312 298312 346555 346555 PubChem (substance) 2 45398 45398 3
939512 939512 978 978 CAS Common Chemistry 3 45398 45398 1
939513 939513 17021 17021 CAS Common Chemistry 3 45398 45398 1
939514 939514 86457 86457 CAS Common Chemistry 3 45398 45398 1
939515 939515 979 979 CAS Common Chemistry 3 45398 45398 1
939516 939516 231909 231909 CAS Common Chemistry 3 45398 45398 1
1136451 1136451 437745 437745 Computational Toxicology and Exposure Data 4 45398 45398 1
1136452 1136452 978 978 Computational Toxicology and Exposure Data 4 45398 45398 1
1136453 1136453 17021 17021 Computational Toxicology and Exposure Data 4 45398 45398 1
1136454 1136454 86457 86457 Computational Toxicology and Exposure Data 4 45398 45398 1
1136455 1136455 979 979 Computational Toxicology and Exposure Data 4 45398 45398 1
1136456 1136456 231909 231909 Computational Toxicology and Exposure Data 4 45398 45398 1
1136457 1136457 361823 361823 Computational Toxicology and Exposure Data 4 45398 45398 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)
);