home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 103731

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
16482 16482 103731 103731 PubChem (compound) 1 110715 110715 1
16489 16489 103731 103731 PubChem (compound) 1 137669 137669 2
16493 16493 103731 103731 PubChem (compound) 1 184225 184225 4
16495 16495 103731 103731 PubChem (compound) 1 70938 70938 3
16499 16499 103731 103731 PubChem (compound) 1 110715 110715 5
16501 16501 103731 103731 PubChem (compound) 1 313995 313995 6
124232 124232 103731 103731 PubChem (compound) 1 315663 315663 7
318917 318917 103731 103731 PubChem (substance) 2 110715 110715 1
318922 318922 103731 103731 PubChem (substance) 2 137669 137669 2
318929 318929 103731 103731 PubChem (substance) 2 184225 184225 9
318933 318933 103731 103731 PubChem (substance) 2 70938 70938 4
318936 318936 103731 103731 PubChem (substance) 2 110715 110715 11
318941 318941 103731 103731 PubChem (substance) 2 313995 313995 5
470935 470935 103731 103731 PubChem (substance) 2 315663 315663 6
670454 670454 103731 103731 PubChem (substance) 2 111206 111206 8
703899 703899 103731 103731 PubChem (substance) 2 198726 198726 3
703901 703901 103731 103731 PubChem (substance) 2 187167 187167 10
770526 770526 103731 103731 PubChem (substance) 2 195006 195006 7
770527 770527 103731 103731 PubChem (substance) 2 232932 232932 12
950462 950462 103731 103731 CAS Common Chemistry 3 70938 70938 1
1149393 1149393 103731 103731 Computational Toxicology and Exposure Data 4 110715 110715 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 444.35ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website