home / zeropm-v0-0-4

api_results

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

15 rows where query_id = 147815

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
471269 471269 147815 147815 PubChem (substance) 2 129248 129248 12
475878 475878 147815 147815 PubChem (substance) 2 93557 93557 1
475880 475880 147815 147815 PubChem (substance) 2 137751 137751 4
728180 728180 147815 147815 PubChem (substance) 2 287949 287949 11
775273 775273 147815 147815 PubChem (substance) 2 243597 243597 15
803479 803479 147815 147815 PubChem (substance) 2 207550 207550 2
803482 803482 147815 147815 PubChem (substance) 2 227560 227560 5
803483 803483 147815 147815 PubChem (substance) 2 271323 271323 8
803486 803486 147815 147815 PubChem (substance) 2 280818 280818 9
803489 803489 147815 147815 PubChem (substance) 2 263158 263158 13
803491 803491 147815 147815 PubChem (substance) 2 246032 246032 3
803494 803494 147815 147815 PubChem (substance) 2 139030 139030 6
803495 803495 147815 147815 PubChem (substance) 2 186241 186241 7
803496 803496 147815 147815 PubChem (substance) 2 250893 250893 10
803497 803497 147815 147815 PubChem (substance) 2 329396 329396 14
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 530.065ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website