home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 104971

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21805 21805 104971 104971 PubChem (compound) 1 53075 53075 1
326869 326869 104971 104971 PubChem (substance) 2 53075 53075 1
627835 627835 104971 104971 PubChem (substance) 2 136294 136294 2
695878 695878 104971 104971 PubChem (substance) 2 315679 315679 8
707730 707730 104971 104971 PubChem (substance) 2 123838 123838 4
707732 707732 104971 104971 PubChem (substance) 2 192012 192012 3
707738 707738 104971 104971 PubChem (substance) 2 186248 186248 11
707742 707742 104971 104971 PubChem (substance) 2 195204 195204 5
707746 707746 104971 104971 PubChem (substance) 2 226433 226433 19
707750 707750 104971 104971 PubChem (substance) 2 173408 173408 6
707755 707755 104971 104971 PubChem (substance) 2 195512 195512 16
707759 707759 104971 104971 PubChem (substance) 2 204661 204661 12
709558 709558 104971 104971 PubChem (substance) 2 315681 315681 9
709570 709570 104971 104971 PubChem (substance) 2 315682 315682 10
740758 740758 104971 104971 PubChem (substance) 2 142095 142095 7
772288 772288 104971 104971 PubChem (substance) 2 197731 197731 13
772290 772290 104971 104971 PubChem (substance) 2 201913 201913 14
772293 772293 104971 104971 PubChem (substance) 2 195364 195364 15
772294 772294 104971 104971 PubChem (substance) 2 206648 206648 17
772296 772296 104971 104971 PubChem (substance) 2 250668 250668 18
772299 772299 104971 104971 PubChem (substance) 2 249567 249567 20
772301 772301 104971 104971 PubChem (substance) 2 215298 215298 21
954291 954291 104971 104971 CAS Common Chemistry 3 53075 53075 1
1153861 1153861 104971 104971 Computational Toxicology and Exposure Data 4 123838 123838 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 519.336ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website