api_results

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

14 rows where query_id = 341012

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
94960 94960 341012 341012 PubChem (compound) 1 248549 248549 2
94970 94970 341012 341012 PubChem (compound) 1 248621 248621 4
265188 265188 341012 341012 PubChem (compound) 1 248617 248617 1
265191 265191 341012 341012 PubChem (compound) 1 248661 248661 3
429790 429790 341012 341012 PubChem (substance) 2 248549 248549 2
429800 429800 341012 341012 PubChem (substance) 2 248621 248621 5
652732 652732 341012 341012 PubChem (substance) 2 248617 248617 1
652738 652738 341012 341012 PubChem (substance) 2 248661 248661 4
746316 746316 341012 341012 PubChem (substance) 2 248925 248925 3
746332 746332 341012 341012 PubChem (substance) 2 279014 279014 7
912923 912923 341012 341012 PubChem (substance) 2 339858 339858 6
912925 912925 341012 341012 PubChem (substance) 2 255373 255373 8
1115618 1115618 341012 341012 CAS Common Chemistry 3 56750 56750 1
1327458 1327458 341012 341012 Computational Toxicology and Exposure Data 4 56750 56750 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)
);