home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 63051

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
103373 103373 63051 63051 PubChem (compound) 1 144849 144849 1
442100 442100 63051 63051 PubChem (substance) 2 32364 32364 7
442106 442106 63051 63051 PubChem (substance) 2 144849 144849 1
442184 442184 63051 63051 PubChem (substance) 2 52389 52389 14
648199 648199 63051 63051 PubChem (substance) 2 8571 8571 3
753599 753599 63051 63051 PubChem (substance) 2 198250 198250 9
753602 753602 63051 63051 PubChem (substance) 2 198251 198251 10
753603 753603 63051 63051 PubChem (substance) 2 198252 198252 11
753608 753608 63051 63051 PubChem (substance) 2 198253 198253 12
753609 753609 63051 63051 PubChem (substance) 2 202232 202232 2
753610 753610 63051 63051 PubChem (substance) 2 206106 206106 4
753611 753611 63051 63051 PubChem (substance) 2 204450 204450 5
753612 753612 63051 63051 PubChem (substance) 2 206194 206194 6
753613 753613 63051 63051 PubChem (substance) 2 206584 206584 8
753614 753614 63051 63051 PubChem (substance) 2 205534 205534 13
753615 753615 63051 63051 PubChem (substance) 2 198479 198479 15
753616 753616 63051 63051 PubChem (substance) 2 198480 198480 16
753617 753617 63051 63051 PubChem (substance) 2 198481 198481 17
753618 753618 63051 63051 PubChem (substance) 2 197568 197568 18
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 747.39ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website