home / zeropm-v0-0-4

api_results

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

25 rows where inchi_id = 138123

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
114329 114329 361931 361931 PubChem (compound) 1 138123 138123 5
114330 114330 440707 440707 PubChem (compound) 1 138123 138123 1
114331 114331 118951 118951 PubChem (compound) 1 138123 138123 5
114332 114332 84877 84877 PubChem (compound) 1 138123 138123 7
114333 114333 372150 372150 PubChem (compound) 1 138123 138123 7
456947 456947 59249 59249 PubChem (substance) 2 138123 138123 3
456948 456948 9875 9875 PubChem (substance) 2 138123 138123 2
456949 456949 84877 84877 PubChem (substance) 2 138123 138123 6
456950 456950 118492 118492 PubChem (substance) 2 138123 138123 2
456951 456951 83579 83579 PubChem (substance) 2 138123 138123 15
456952 456952 9877 9877 PubChem (substance) 2 138123 138123 5
456953 456953 118951 118951 PubChem (substance) 2 138123 138123 4
456954 456954 104841 104841 PubChem (substance) 2 138123 138123 16
456955 456955 59248 59248 PubChem (substance) 2 138123 138123 3
456956 456956 59246 59246 PubChem (substance) 2 138123 138123 2
456957 456957 9878 9878 PubChem (substance) 2 138123 138123 2
456958 456958 438409 438409 PubChem (substance) 2 138123 138123 3
456959 456959 114553 114553 PubChem (substance) 2 138123 138123 4
456960 456960 372150 372150 PubChem (substance) 2 138123 138123 6
456961 456961 361931 361931 PubChem (substance) 2 138123 138123 5
456962 456962 118493 118493 PubChem (substance) 2 138123 138123 3
456963 456963 59247 59247 PubChem (substance) 2 138123 138123 2
456964 456964 104560 104560 PubChem (substance) 2 138123 138123 5
456965 456965 351110 351110 PubChem (substance) 2 138123 138123 15
456966 456966 440707 440707 PubChem (substance) 2 138123 138123 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 1682.624ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website