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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
141419 141419 121502 121502 PubChem (compound) 1 44577 44577 1
493903 493903 121502 121502 PubChem (substance) 2 44577 44577 1
697712 697712 121502 121502 PubChem (substance) 2 168866 168866 5
762811 762811 121502 121502 PubChem (substance) 2 227562 227562 7
786005 786005 121502 121502 PubChem (substance) 2 3864 3864 3
786006 786006 121502 121502 PubChem (substance) 2 216952 216952 2
786009 786009 121502 121502 PubChem (substance) 2 184424 184424 11
786012 786012 121502 121502 PubChem (substance) 2 240614 240614 6
786014 786014 121502 121502 PubChem (substance) 2 291132 291132 12
786015 786015 121502 121502 PubChem (substance) 2 199578 199578 13
786018 786018 121502 121502 PubChem (substance) 2 307716 307716 14
786020 786020 121502 121502 PubChem (substance) 2 323771 323771 15
786021 786021 121502 121502 PubChem (substance) 2 169624 169624 4
786022 786022 121502 121502 PubChem (substance) 2 199578 199578 8
786023 786023 121502 121502 PubChem (substance) 2 194305 194305 9
786024 786024 121502 121502 PubChem (substance) 2 44577 44577 10
1041289 1041289 121502 121502 CAS Common Chemistry 3 3864 3864 1
1041290 1041290 121502 121502 CAS Common Chemistry 3 44577 44577 2
1244248 1244248 121502 121502 Computational Toxicology and Exposure Data 4 44577 44577 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 442.713ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website