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 = 138538

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
158733 158733 138538 138538 PubChem (compound) 1 50468 50468 1
158735 158735 138538 138538 PubChem (compound) 1 186646 186646 2
158736 158736 138538 138538 PubChem (compound) 1 250404 250404 3
158737 158737 138538 138538 PubChem (compound) 1 307680 307680 4
472474 472474 138538 138538 PubChem (substance) 2 179868 179868 7
516591 516591 138538 138538 PubChem (substance) 2 50468 50468 1
516598 516598 138538 138538 PubChem (substance) 2 186646 186646 3
516600 516600 138538 138538 PubChem (substance) 2 250404 250404 4
516602 516602 138538 138538 PubChem (substance) 2 307680 307680 12
682865 682865 138538 138538 PubChem (substance) 2 93345 93345 14
708485 708485 138538 138538 PubChem (substance) 2 260204 260204 9
797484 797484 138538 138538 PubChem (substance) 2 200506 200506 2
797486 797486 138538 138538 PubChem (substance) 2 141801 141801 5
797488 797488 138538 138538 PubChem (substance) 2 294485 294485 6
797489 797489 138538 138538 PubChem (substance) 2 258877 258877 8
797491 797491 138538 138538 PubChem (substance) 2 270212 270212 10
797492 797492 138538 138538 PubChem (substance) 2 141801 141801 11
797493 797493 138538 138538 PubChem (substance) 2 309900 309900 13
797494 797494 138538 138538 PubChem (substance) 2 233063 233063 15
1054281 1054281 138538 138538 CAS Common Chemistry 3 50468 50468 1
1257025 1257025 138538 138538 Computational Toxicology and Exposure Data 4 50468 50468 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 1544.76ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website