api_results

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

12 rows where query_id = 138783

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
158957 158957 138783 138783 PubChem (compound) 1 51434 51434 1
476711 476711 138783 138783 PubChem (substance) 2 7045 7045 3
516890 516890 138783 138783 PubChem (substance) 2 51434 51434 1
797693 797693 138783 138783 PubChem (substance) 2 173292 173292 2
797696 797696 138783 138783 PubChem (substance) 2 287895 287895 5
797698 797698 138783 138783 PubChem (substance) 2 308342 308342 6
797700 797700 138783 138783 PubChem (substance) 2 309515 309515 7
797702 797702 138783 138783 PubChem (substance) 2 326540 326540 8
797703 797703 138783 138783 PubChem (substance) 2 278082 278082 4
797704 797704 138783 138783 PubChem (substance) 2 279716 279716 9
1054452 1054452 138783 138783 CAS Common Chemistry 3 51434 51434 1
1257193 1257193 138783 138783 Computational Toxicology and Exposure Data 4 51434 51434 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)
);