api_results

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

11 rows where query_id = 297179

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
257080 257080 297179 297179 PubChem (compound) 1 229731 229731 1
380502 380502 297179 297179 PubChem (substance) 2 75300 75300 8
453080 453080 297179 297179 PubChem (substance) 2 229501 229501 6
640830 640830 297179 297179 PubChem (substance) 2 229731 229731 1
692809 692809 297179 297179 PubChem (substance) 2 51838 51838 2
845572 845572 297179 297179 PubChem (substance) 2 270862 270862 3
845573 845573 297179 297179 PubChem (substance) 2 246755 246755 4
845574 845574 297179 297179 PubChem (substance) 2 239296 239296 5
845575 845575 297179 297179 PubChem (substance) 2 266974 266974 7
1112161 1112161 297179 297179 CAS Common Chemistry 3 51838 51838 1
1309920 1309920 297179 297179 Computational Toxicology and Exposure Data 4 51838 51838 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)
);