api_results

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

13 rows where query_id = 391373

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
458993 458993 391373 391373 PubChem (substance) 2 48090 48090 8
928511 928511 391373 391373 PubChem (substance) 2 181581 181581 1
928512 928512 391373 391373 PubChem (substance) 2 272724 272724 2
928513 928513 391373 391373 PubChem (substance) 2 40897 40897 3
928514 928514 391373 391373 PubChem (substance) 2 229040 229040 4
928515 928515 391373 391373 PubChem (substance) 2 261045 261045 5
928516 928516 391373 391373 PubChem (substance) 2 277417 277417 6
928517 928517 391373 391373 PubChem (substance) 2 181582 181582 7
928518 928518 391373 391373 PubChem (substance) 2 295315 295315 9
928519 928519 391373 391373 PubChem (substance) 2 309909 309909 10
928520 928520 391373 391373 PubChem (substance) 2 227034 227034 11
1122674 1122674 391373 391373 CAS Common Chemistry 3 40897 40897 1
1336690 1336690 391373 391373 Computational Toxicology and Exposure Data 4 40897 40897 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)
);