api_results

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

13 rows where query_id = 143514

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
163621 163621 143514 143514 PubChem (compound) 1 68826 68826 1
322129 322129 143514 143514 PubChem (substance) 2 136466 136466 6
471816 471816 143514 143514 PubChem (substance) 2 51333 51333 3
523043 523043 143514 143514 PubChem (substance) 2 68826 68826 1
523046 523046 143514 143514 PubChem (substance) 2 282988 282988 4
523049 523049 143514 143514 PubChem (substance) 2 140392 140392 2
523050 523050 143514 143514 PubChem (substance) 2 200350 200350 8
523053 523053 143514 143514 PubChem (substance) 2 207529 207529 5
523054 523054 143514 143514 PubChem (substance) 2 228364 228364 10
800944 800944 143514 143514 PubChem (substance) 2 276014 276014 7
800945 800945 143514 143514 PubChem (substance) 2 308313 308313 9
1057923 1057923 143514 143514 CAS Common Chemistry 3 68826 68826 1
1260492 1260492 143514 143514 Computational Toxicology and Exposure Data 4 68826 68826 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)
);