home / zeropm-v0-0-4

api_results

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

25 rows where inchi_id = 2892

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
30181 30181 14470 14470 PubChem (compound) 1 2892 2892 1
30182 30182 14471 14471 PubChem (compound) 1 2892 2892 1
30183 30183 108165 108165 PubChem (compound) 1 2892 2892 1
30184 30184 319293 319293 PubChem (compound) 1 2892 2892 1
30185 30185 348016 348016 PubChem (compound) 1 2892 2892 1
338457 338457 3890 3890 PubChem (substance) 2 2892 2892 4
338458 338458 14471 14471 PubChem (substance) 2 2892 2892 1
338459 338459 140958 140958 PubChem (substance) 2 2892 2892 2
338460 338460 436640 436640 PubChem (substance) 2 2892 2892 1
338461 338461 140926 140926 PubChem (substance) 2 2892 2892 2
338462 338462 14470 14470 PubChem (substance) 2 2892 2892 1
338463 338463 140959 140959 PubChem (substance) 2 2892 2892 2
338464 338464 164448 164448 PubChem (substance) 2 2892 2892 2
338465 338465 68889 68889 PubChem (substance) 2 2892 2892 1
338466 338466 108165 108165 PubChem (substance) 2 2892 2892 1
338467 338467 319293 319293 PubChem (substance) 2 2892 2892 1
338468 338468 164449 164449 PubChem (substance) 2 2892 2892 2
338469 338469 348016 348016 PubChem (substance) 2 2892 2892 1
338470 338470 356868 356868 PubChem (substance) 2 2892 2892 1
338471 338471 348017 348017 PubChem (substance) 2 2892 2892 1
960400 960400 14471 14471 CAS Common Chemistry 3 2892 2892 1
960401 960401 14470 14470 CAS Common Chemistry 3 2892 2892 1
960402 960402 68889 68889 CAS Common Chemistry 3 2892 2892 1
960403 960403 319293 319293 CAS Common Chemistry 3 2892 2892 1
960404 960404 356868 356868 CAS Common Chemistry 3 2892 2892 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 412.622ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website