consensus_index

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

14 rows where inventory_id = 201009

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
502605 502605 201009 201009 83293 4 0.294517329164832
502606 502606 201009 201009 151217 1 0.0226551791665255
502607 502607 201009 201009 160714 2 0.147258664582416
502608 502608 201009 201009 183338 2 0.098172443054944
502609 502609 201009 201009 185144 1 0.073629332291208
502610 502610 201009 201009 195674 2 0.0658560768564246
502611 502611 201009 201009 204271 2 0.0347092001049005
502612 502612 201009 201009 207546 1 0.0210369520832023
502613 502613 201009 201009 237279 2 0.0537712615865842
502614 502614 201009 201009 264237 1 0.036814666145604
502615 502615 201009 201009 291629 2 0.0335633646089772
502616 502616 201009 201009 291982 1 0.0420739041664046
502617 502617 201009 201009 308107 2 0.0347092001049005
502618 502618 201009 201009 309982 1 0.0294517329164832 
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)
);