consensus_index

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

14 rows where inventory_id = 77781

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
225581 225581 77781 77781 1639 6 0.237846082121886
225582 225582 77781 77781 7040 1 0.237846082121886
225583 225583 77781 77781 16464 2 0.0237846082121886
225584 225584 77781 77781 43799 3 0.0597744816661301
225585 225585 77781 77781 137983 2 0.0233227271917517
225586 225586 77781 77781 140143 3 0.0607545653959509
225587 225587 77781 77781 140401 3 0.0943892802416991
225588 225588 77781 77781 159132 3 0.0380108259981625
225589 225589 77781 77781 169009 3 0.0482209305107016
225590 225590 77781 77781 170702 2 0.0594615205304714
225591 225591 77781 77781 195795 2 0.0239044306743743
225592 225592 77781 77781 208656 1 0.0198205068434905
225593 225593 77781 77781 218754 2 0.039641013686981
225594 225594 77781 77781 290984 1 0.0264273424579873 
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)
);