api_results

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

17 rows where inchi_id = 137983

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
33461 33461 17140 17140 PubChem (compound) 1 137983 137983 8
33462 33462 15698 15698 PubChem (compound) 1 137983 137983 8
33463 33463 301510 301510 PubChem (compound) 1 137983 137983 7
33464 33464 16797 16797 PubChem (compound) 1 137983 137983 4
33465 33465 361999 361999 PubChem (compound) 1 137983 137983 7
33466 33466 102261 102261 PubChem (compound) 1 137983 137983 8
343384 343384 15698 15698 PubChem (substance) 2 137983 137983 13
343385 343385 240944 240944 PubChem (substance) 2 137983 137983 2
343386 343386 301510 301510 PubChem (substance) 2 137983 137983 8
343387 343387 17140 17140 PubChem (substance) 2 137983 137983 12
343388 343388 16797 16797 PubChem (substance) 2 137983 137983 4
343389 343389 112586 112586 PubChem (substance) 2 137983 137983 2
343390 343390 102261 102261 PubChem (substance) 2 137983 137983 16
343391 343391 16798 16798 PubChem (substance) 2 137983 137983 2
343392 343392 361999 361999 PubChem (substance) 2 137983 137983 8
343393 343393 338765 338765 PubChem (substance) 2 137983 137983 2
343394 343394 437663 437663 PubChem (substance) 2 137983 137983 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)
);