api_results

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

13 rows where query_id = 56708

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
83431 83431 56708 56708 PubChem (compound) 1 83226 83226 1
96003 96003 56708 56708 PubChem (compound) 1 136986 136986 2
96004 96004 56708 56708 PubChem (compound) 1 186858 186858 3
413746 413746 56708 56708 PubChem (substance) 2 83226 83226 1
431275 431275 56708 56708 PubChem (substance) 2 136986 136986 3
431276 431276 56708 56708 PubChem (substance) 2 186858 186858 4
739900 739900 56708 56708 PubChem (substance) 2 185712 185712 2
739902 739902 56708 56708 PubChem (substance) 2 173307 173307 5
747207 747207 56708 56708 PubChem (substance) 2 267129 267129 6
747208 747208 56708 56708 PubChem (substance) 2 261015 261015 7
747209 747209 56708 56708 PubChem (substance) 2 199647 199647 8
1009272 1009272 56708 56708 CAS Common Chemistry 3 83226 83226 1
1211314 1211314 56708 56708 Computational Toxicology and Exposure Data 4 83226 83226 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)
);