api_results

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

6 rows where query_id = 148857

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
679825 679825 148857 148857 PubChem (substance) 2 147781 147781 1
804260 804260 148857 148857 PubChem (substance) 2 143581 143581 2
804262 804262 148857 148857 PubChem (substance) 2 218245 218245 4
804263 804263 148857 148857 PubChem (substance) 2 254333 254333 3
1061574 1061574 148857 148857 CAS Common Chemistry 3 6155 6155 1
1263849 1263849 148857 148857 Computational Toxicology and Exposure Data 4 109713 109713 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)
);