home / zeropm-v0-0-4

consensus_index

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

8 rows where inchi_id = 2473

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
302943 302943 102530 102530 2473 7 0.476190476190476
543043 543043 214862 214862 2473 1 0.0195485243618341
586233 586233 228910 228910 2473 1 0.0147057085907794
678364 678364 242584 242584 2473 1 0.0147057085907794
755139 755139 265409 265409 2473 1 0.0146873881418976
820399 820399 284778 284778 2473 1 0.243864228693887
1656166 1656166 501847 501847 2473 8 0.625
1743010 1743010 533848 533848 2473 8 0.625
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 2101.577ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website