home / zeropm-v0-0-4

api_results

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

17 rows where query_id = 104927

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
3261 3261 104927 104927 PubChem (compound) 1 53042 53042 1
300066 300066 104927 104927 PubChem (substance) 2 53042 53042 1
373143 373143 104927 104927 PubChem (substance) 2 52588 52588 3
550879 550879 104927 104927 PubChem (substance) 2 27568 27568 14
694647 694647 104927 104927 PubChem (substance) 2 259234 259234 2
694650 694650 104927 104927 PubChem (substance) 2 181574 181574 4
694655 694655 104927 104927 PubChem (substance) 2 232008 232008 5
694662 694662 104927 104927 PubChem (substance) 2 232009 232009 6
694665 694665 104927 104927 PubChem (substance) 2 232032 232032 7
694671 694671 104927 104927 PubChem (substance) 2 232033 232033 8
694679 694679 104927 104927 PubChem (substance) 2 232034 232034 9
694685 694685 104927 104927 PubChem (substance) 2 149542 149542 10
694692 694692 104927 104927 PubChem (substance) 2 232035 232035 11
694695 694695 104927 104927 PubChem (substance) 2 167932 167932 12
694699 694699 104927 104927 PubChem (substance) 2 137664 137664 13
940475 940475 104927 104927 CAS Common Chemistry 3 53042 53042 1
1137636 1137636 104927 104927 Computational Toxicology and Exposure Data 4 53042 53042 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 455.051ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website