home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 108861

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
128083 128083 108861 108861 PubChem (compound) 1 5215 5215 1
476255 476255 108861 108861 PubChem (substance) 2 5215 5215 1
496199 496199 108861 108861 PubChem (substance) 2 137291 137291 2
655307 655307 108861 108861 PubChem (substance) 2 189142 189142 11
775527 775527 108861 108861 PubChem (substance) 2 291237 291237 18
775530 775530 108861 108861 PubChem (substance) 2 154319 154319 3
775532 775532 108861 108861 PubChem (substance) 2 181663 181663 4
775533 775533 108861 108861 PubChem (substance) 2 201640 201640 5
775535 775535 108861 108861 PubChem (substance) 2 169552 169552 6
775536 775536 108861 108861 PubChem (substance) 2 200368 200368 7
775537 775537 108861 108861 PubChem (substance) 2 202941 202941 8
775540 775540 108861 108861 PubChem (substance) 2 170098 170098 9
775541 775541 108861 108861 PubChem (substance) 2 180020 180020 10
775542 775542 108861 108861 PubChem (substance) 2 195257 195257 12
775543 775543 108861 108861 PubChem (substance) 2 199822 199822 13
775544 775544 108861 108861 PubChem (substance) 2 140298 140298 14
775545 775545 108861 108861 PubChem (substance) 2 200249 200249 15
775546 775546 108861 108861 PubChem (substance) 2 200464 200464 16
775547 775547 108861 108861 PubChem (substance) 2 228247 228247 17
1031050 1031050 108861 108861 CAS Common Chemistry 3 5215 5215 1
1233910 1233910 108861 108861 Computational Toxicology and Exposure Data 4 5215 5215 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 472.261ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website