consensus_index

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

12 rows where inventory_id = 33001

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
92661 92661 33001 33001 81173 7 0.311136515118536
92662 92662 33001 33001 136607 1 0.0518560858530893
92663 92663 33001 33001 238390 3 0.0679506953684208
92664 92664 33001 33001 313743 2 0.0695722398087437
92665 92665 33001 33001 313782 2 0.155568257559268
92666 92666 33001 33001 314223 2 0.0463814932058292
92667 92667 33001 33001 314493 2 0.0449086876896022
92668 92668 33001 33001 315455 1 0.103712171706179
92669 92669 33001 33001 316306 1 0.0444480735883623
92670 92670 33001 33001 317428 2 0.0354572966205512
92671 92671 33001 33001 317468 1 0.0311136515118536
92672 92672 33001 33001 317880 1 0.0259280429265447 
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)
);