consensus_index

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

11 rows where inchi_id = 30755

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27147 27147 7894 7894 30755 8 0.628571428571429
135978 135978 48192 48192 30755 4 0.391304347826087
166135 166135 59521 59521 30755 2 0.0748388431679032
230362 230362 78927 78927 30755 8 0.628571428571429
306959 306959 103738 103738 30755 2 0.162869590856186
678820 678820 242697 242697 30755 2 0.162869590856186
697006 697006 248475 248475 30755 8 0.628571428571429
739132 739132 260480 260480 30755 2 0.144452389313862
789027 789027 275574 275574 30755 8 0.628571428571429
789029 789029 275575 275575 30755 5 0.608695652173913
875902 875902 303025 303025 30755 4 0.6 
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)
);