api_results

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

17 rows where query_id = 78203

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
110964 110964 78203 78203 PubChem (compound) 1 4325 4325 1
301544 301544 78203 78203 PubChem (substance) 2 22313 22313 3
437722 437722 78203 78203 PubChem (substance) 2 45752 45752 10
452288 452288 78203 78203 PubChem (substance) 2 4325 4325 1
485674 485674 78203 78203 PubChem (substance) 2 92885 92885 13
759573 759573 78203 78203 PubChem (substance) 2 139437 139437 2
759575 759575 78203 78203 PubChem (substance) 2 170023 170023 4
759577 759577 78203 78203 PubChem (substance) 2 138845 138845 5
759578 759578 78203 78203 PubChem (substance) 2 138223 138223 6
759579 759579 78203 78203 PubChem (substance) 2 206042 206042 7
759580 759580 78203 78203 PubChem (substance) 2 211353 211353 8
759581 759581 78203 78203 PubChem (substance) 2 273616 273616 9
759582 759582 78203 78203 PubChem (substance) 2 221102 221102 11
759583 759583 78203 78203 PubChem (substance) 2 280031 280031 12
759584 759584 78203 78203 PubChem (substance) 2 243977 243977 14
1019376 1019376 78203 78203 CAS Common Chemistry 3 4325 4325 1
1221782 1221782 78203 78203 Computational Toxicology and Exposure Data 4 4325 4325 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)
);