consensus_index

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

10 rows where inventory_id = 5427

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18536 18536 5427 5427 5512 1 0.147731269785438
18537 18537 5427 5427 9860 8 0.295462539570876
18538 18538 5427 5427 20084 1 0.049243756595146
18539 18539 5427 5427 21698 1 0.147731269785438
18540 18540 5427 5427 75772 1 0.0369328174463595
18541 18541 5427 5427 87504 1 0.0422089342244108
18542 18542 5427 5427 87505 1 0.0984875131902919
18543 18543 5427 5427 138865 1 0.0590925079141752
18544 18544 5427 5427 157901 1 0.073865634892719
18545 18545 5427 5427 207744 1 0.0328291710634306 
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)
);