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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21861 21861 20398 20398 PubChem (compound) 1 54003 54003 1
326212 326212 20398 20398 PubChem (substance) 2 49220 49220 19
326969 326969 20398 20398 PubChem (substance) 2 54003 54003 1
360123 360123 20398 20398 PubChem (substance) 2 1073 1073 2
707855 707855 20398 20398 PubChem (substance) 2 208893 208893 18
707863 707863 20398 20398 PubChem (substance) 2 176824 176824 3
709559 709559 20398 20398 PubChem (substance) 2 315681 315681 8
709566 709566 20398 20398 PubChem (substance) 2 315682 315682 9
719897 719897 20398 20398 PubChem (substance) 2 309510 309510 21
719901 719901 20398 20398 PubChem (substance) 2 177231 177231 4
719910 719910 20398 20398 PubChem (substance) 2 195195 195195 5
719917 719917 20398 20398 PubChem (substance) 2 175623 175623 6
719919 719919 20398 20398 PubChem (substance) 2 84323 84323 7
719921 719921 20398 20398 PubChem (substance) 2 186533 186533 10
719923 719923 20398 20398 PubChem (substance) 2 204708 204708 11
719928 719928 20398 20398 PubChem (substance) 2 137627 137627 12
719932 719932 20398 20398 PubChem (substance) 2 208894 208894 13
719934 719934 20398 20398 PubChem (substance) 2 204867 204867 14
719939 719939 20398 20398 PubChem (substance) 2 197883 197883 15
719943 719943 20398 20398 PubChem (substance) 2 202593 202593 16
719946 719946 20398 20398 PubChem (substance) 2 200002 200002 17
719949 719949 20398 20398 PubChem (substance) 2 212779 212779 20
1153876 1153876 20398 20398 Computational Toxicology and Exposure Data 4 53081 53081 2
1153886 1153886 20398 20398 Computational Toxicology and Exposure Data 4 54003 54003 3
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 1555.045ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website