home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 104698

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124635 124635 104698 104698 PubChem (compound) 1 48072 48072 1
436877 436877 104698 104698 PubChem (substance) 2 99723 99723 6
471531 471531 104698 104698 PubChem (substance) 2 48072 48072 1
481506 481506 104698 104698 PubChem (substance) 2 44486 44486 7
771448 771448 104698 104698 PubChem (substance) 2 136387 136387 2
771451 771451 104698 104698 PubChem (substance) 2 195645 195645 3
771452 771452 104698 104698 PubChem (substance) 2 206831 206831 4
771456 771456 104698 104698 PubChem (substance) 2 240574 240574 17
771458 771458 104698 104698 PubChem (substance) 2 190938 190938 18
771460 771460 104698 104698 PubChem (substance) 2 197870 197870 19
771461 771461 104698 104698 PubChem (substance) 2 189111 189111 5
771462 771462 104698 104698 PubChem (substance) 2 203653 203653 8
771463 771463 104698 104698 PubChem (substance) 2 206231 206231 9
771464 771464 104698 104698 PubChem (substance) 2 197869 197869 10
771465 771465 104698 104698 PubChem (substance) 2 206806 206806 11
771466 771466 104698 104698 PubChem (substance) 2 198589 198589 12
771467 771467 104698 104698 PubChem (substance) 2 195303 195303 13
771468 771468 104698 104698 PubChem (substance) 2 176166 176166 14
771469 771469 104698 104698 PubChem (substance) 2 205558 205558 15
771470 771470 104698 104698 PubChem (substance) 2 201799 201799 16
771471 771471 104698 104698 PubChem (substance) 2 160021 160021 20
1028473 1028473 104698 104698 CAS Common Chemistry 3 48072 48072 1
1231281 1231281 104698 104698 Computational Toxicology and Exposure Data 4 48072 48072 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)
);
Powered by Datasette · Queries took 442.551ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website