home / zeropm-v0-0-4

api_results

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

29 rows where query_id = 308067

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21893 21893 308067 308067 PubChem (compound) 1 54021 54021 2
22085 22085 308067 308067 PubChem (compound) 1 58694 58694 1
36053 36053 308067 308067 PubChem (compound) 1 35894 35894 3
326323 326323 308067 308067 PubChem (substance) 2 51328 51328 18
327032 327032 308067 308067 PubChem (substance) 2 54021 54021 2
327329 327329 308067 308067 PubChem (substance) 2 58694 58694 1
347249 347249 308067 308067 PubChem (substance) 2 35894 35894 3
505460 505460 308067 308067 PubChem (substance) 2 30747 30747 20
707924 707924 308067 308067 PubChem (substance) 2 54021 54021 10
707933 707933 308067 308067 PubChem (substance) 2 58694 58694 5
749589 749589 308067 308067 PubChem (substance) 2 169733 169733 16
751056 751056 308067 308067 PubChem (substance) 2 169448 169448 19
846944 846944 308067 308067 PubChem (substance) 2 188331 188331 4
846945 846945 308067 308067 PubChem (substance) 2 169599 169599 6
846948 846948 308067 308067 PubChem (substance) 2 188328 188328 7
846949 846949 308067 308067 PubChem (substance) 2 188329 188329 8
846951 846951 308067 308067 PubChem (substance) 2 169602 169602 9
846953 846953 308067 308067 PubChem (substance) 2 188330 188330 11
846955 846955 308067 308067 PubChem (substance) 2 169723 169723 12
846958 846958 308067 308067 PubChem (substance) 2 149567 149567 13
846960 846960 308067 308067 PubChem (substance) 2 193582 193582 14
846962 846962 308067 308067 PubChem (substance) 2 281330 281330 15
846964 846964 308067 308067 PubChem (substance) 2 241507 241507 17
846967 846967 308067 308067 PubChem (substance) 2 329660 329660 21
846968 846968 308067 308067 PubChem (substance) 2 330490 330490 22
846971 846971 308067 308067 PubChem (substance) 2 188330 188330 23
954340 954340 308067 308067 CAS Common Chemistry 3 54021 54021 1
954505 954505 308067 308067 CAS Common Chemistry 3 58694 58694 2
1153927 1153927 308067 308067 Computational Toxicology and Exposure Data 4 132670 132670 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 483.404ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website