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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
130667 130667 111616 111616 PubChem (compound) 1 37203 37203 1
130668 130668 111616 111616 PubChem (compound) 1 159294 159294 2
130670 130670 111616 111616 PubChem (compound) 1 177873 177873 3
130671 130671 111616 111616 PubChem (compound) 1 140634 140634 4
130672 130672 111616 111616 PubChem (compound) 1 255295 255295 5
130673 130673 111616 111616 PubChem (compound) 1 309686 309686 6
130674 130674 111616 111616 PubChem (compound) 1 334564 334564 7
479725 479725 111616 111616 PubChem (substance) 2 37203 37203 1
479727 479727 111616 111616 PubChem (substance) 2 159294 159294 2
479730 479730 111616 111616 PubChem (substance) 2 177873 177873 3
479732 479732 111616 111616 PubChem (substance) 2 140634 140634 5
479735 479735 111616 111616 PubChem (substance) 2 255295 255295 6
479736 479736 111616 111616 PubChem (substance) 2 309686 309686 9
479737 479737 111616 111616 PubChem (substance) 2 334564 334564 10
559799 559799 111616 111616 PubChem (substance) 2 36291 36291 7
778144 778144 111616 111616 PubChem (substance) 2 223695 223695 4
778146 778146 111616 111616 PubChem (substance) 2 246802 246802 8
1032973 1032973 111616 111616 CAS Common Chemistry 3 37203 37203 1
1235903 1235903 111616 111616 Computational Toxicology and Exposure Data 4 135859 135859 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 2407.29ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website