api_results

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

13 rows where query_id = 27227

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
59236 59236 27227 27227 PubChem (compound) 1 73580 73580 1
368547 368547 27227 27227 PubChem (substance) 2 37225 37225 10
379486 379486 27227 27227 PubChem (substance) 2 73580 73580 1
382391 382391 27227 27227 PubChem (substance) 2 274 274 9
649695 649695 27227 27227 PubChem (substance) 2 21097 21097 6
691097 691097 27227 27227 PubChem (substance) 2 21011 21011 8
726657 726657 27227 27227 PubChem (substance) 2 201516 201516 3
726660 726660 27227 27227 PubChem (substance) 2 170329 170329 2
726662 726662 27227 27227 PubChem (substance) 2 284669 284669 4
726664 726664 27227 27227 PubChem (substance) 2 265921 265921 5
726666 726666 27227 27227 PubChem (substance) 2 287435 287435 7
981630 981630 27227 27227 CAS Common Chemistry 3 73580 73580 1
1184486 1184486 27227 27227 Computational Toxicology and Exposure Data 4 73580 73580 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)
);