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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
65640 65640 31391 31391 PubChem (compound) 1 117830 117830 1
65642 65642 31391 31391 PubChem (compound) 1 332463 332463 2
65643 65643 31391 31391 PubChem (compound) 1 13573 13573 3
65645 65645 31391 31391 PubChem (compound) 1 274648 274648 4
65646 65646 31391 31391 PubChem (compound) 1 13573 13573 5
65647 65647 31391 31391 PubChem (compound) 1 117830 117830 6
65648 65648 31391 31391 PubChem (compound) 1 117830 117830 7
65649 65649 31391 31391 PubChem (compound) 1 117830 117830 8
389281 389281 31391 31391 PubChem (substance) 2 117830 117830 1
389285 389285 31391 31391 PubChem (substance) 2 332463 332463 2
389286 389286 31391 31391 PubChem (substance) 2 13573 13573 3
389291 389291 31391 31391 PubChem (substance) 2 274648 274648 4
389292 389292 31391 31391 PubChem (substance) 2 13573 13573 5
389293 389293 31391 31391 PubChem (substance) 2 117830 117830 8
389294 389294 31391 31391 PubChem (substance) 2 117830 117830 9
389296 389296 31391 31391 PubChem (substance) 2 117830 117830 7
731774 731774 31391 31391 PubChem (substance) 2 285347 285347 6
986523 986523 31391 31391 CAS Common Chemistry 3 13573 13573 1
1189439 1189439 31391 31391 Computational Toxicology and Exposure Data 4 117830 117830 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 462.025ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website