home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 86767

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
15813 15813 86767 86767 PubChem (compound) 1 193953 193953 1
15816 15816 86767 86767 PubChem (compound) 1 203374 203374 2
15817 15817 86767 86767 PubChem (compound) 1 185686 185686 3
15821 15821 86767 86767 PubChem (compound) 1 140049 140049 5
15822 15822 86767 86767 PubChem (compound) 1 233722 233722 4
15825 15825 86767 86767 PubChem (compound) 1 153187 153187 6
15827 15827 86767 86767 PubChem (compound) 1 270647 270647 8
115315 115315 86767 86767 PubChem (compound) 1 261512 261512 7
317850 317850 86767 86767 PubChem (substance) 2 193953 193953 1
317861 317861 86767 86767 PubChem (substance) 2 203374 203374 2
317867 317867 86767 86767 PubChem (substance) 2 185686 185686 3
317875 317875 86767 86767 PubChem (substance) 2 140049 140049 5
317884 317884 86767 86767 PubChem (substance) 2 233722 233722 4
317894 317894 86767 86767 PubChem (substance) 2 153187 153187 10
317896 317896 86767 86767 PubChem (substance) 2 270647 270647 8
458429 458429 86767 86767 PubChem (substance) 2 261512 261512 7
703485 703485 86767 86767 PubChem (substance) 2 237518 237518 9
763401 763401 86767 86767 PubChem (substance) 2 262142 262142 6
763402 763402 86767 86767 PubChem (substance) 2 239002 239002 11
949978 949978 86767 86767 CAS Common Chemistry 3 78154 78154 1
1148809 1148809 86767 86767 Computational Toxicology and Exposure Data 4 78154 78154 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)
);
Powered by Datasette · Queries took 445.197ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website