api_results

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

13 rows where query_id = 190010

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
207620 207620 190010 190010 PubChem (compound) 1 61205 61205 1
207623 207623 190010 190010 PubChem (compound) 1 210296 210296 2
207624 207624 190010 190010 PubChem (compound) 1 244407 244407 3
207625 207625 190010 190010 PubChem (compound) 1 140351 140351 4
207626 207626 190010 190010 PubChem (compound) 1 210297 210297 5
580525 580525 190010 190010 PubChem (substance) 2 61205 61205 1
580527 580527 190010 190010 PubChem (substance) 2 210296 210296 2
580529 580529 190010 190010 PubChem (substance) 2 244407 244407 3
580530 580530 190010 190010 PubChem (substance) 2 140351 140351 4
580531 580531 190010 190010 PubChem (substance) 2 210297 210297 6
828110 828110 190010 190010 PubChem (substance) 2 210295 210295 5
1089094 1089094 190010 190010 CAS Common Chemistry 3 61205 61205 1
1290817 1290817 190010 190010 Computational Toxicology and Exposure Data 4 61205 61205 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)
);