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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
139584 139584 119809 119809 PubChem (compound) 1 84396 84396 1
139587 139587 119809 119809 PubChem (compound) 1 313798 313798 2
139588 139588 119809 119809 PubChem (compound) 1 315698 315698 3
139589 139589 119809 119809 PubChem (compound) 1 318233 318233 4
488675 488675 119809 119809 PubChem (substance) 2 61820 61820 7
491585 491585 119809 119809 PubChem (substance) 2 84396 84396 1
491588 491588 119809 119809 PubChem (substance) 2 313798 313798 2
491591 491591 119809 119809 PubChem (substance) 2 315698 315698 4
491592 491592 119809 119809 PubChem (substance) 2 318233 318233 10
655636 655636 119809 119809 PubChem (substance) 2 171486 171486 6
784617 784617 119809 119809 PubChem (substance) 2 316304 316304 3
784619 784619 119809 119809 PubChem (substance) 2 313737 313737 5
784621 784621 119809 119809 PubChem (substance) 2 238413 238413 8
784622 784622 119809 119809 PubChem (substance) 2 147734 147734 9
784623 784623 119809 119809 PubChem (substance) 2 238413 238413 11
1039851 1039851 119809 119809 CAS Common Chemistry 3 84396 84396 1
1242837 1242837 119809 119809 Computational Toxicology and Exposure Data 4 84396 84396 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 475.222ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website