consensus_index

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

10 rows where inventory_id = 404431

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1218722 1218722 404431 404431 7026 8 0.295462539570876
1218723 1218723 404431 404431 60356 1 0.0984875131902919
1218724 1218724 404431 404431 133491 1 0.0590925079141752
1218725 1218725 404431 404431 136298 1 0.147731269785438
1218726 1218726 404431 404431 169479 1 0.0422089342244108
1218727 1218727 404431 404431 200989 1 0.147731269785438
1218728 1218728 404431 404431 219773 1 0.0328291710634306
1218729 1218729 404431 404431 220560 1 0.049243756595146
1218730 1218730 404431 404431 258465 1 0.073865634892719
1218731 1218731 404431 404431 326828 1 0.0369328174463595 
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)
);