home / zeropm-v0-0-4

consensus_index

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

9 rows where inventory_id = 472001

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1552345 1552345 472001 472001 12564 1 0.0412144047989601
1552346 1552346 472001 472001 13600 2 0.117779972111628
1552347 1552347 472001 472001 73642 8 0.28850083359272
1552348 1552348 472001 472001 75388 1 0.0961669445309068
1552349 1552349 472001 472001 115518 1 0.14425041679636
1552350 1552350 472001 472001 149476 2 0.0588899860558138
1552351 1552351 472001 472001 151680 1 0.14425041679636
1552352 1552352 472001 472001 188880 1 0.0577001667185441
1552353 1552353 472001 472001 256405 1 0.03606260419909
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 1136.563ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website