consensus_index

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

10 rows where inventory_id = 360078

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1007436 1007436 360078 360078 7026 8 0.295462539570876
1007437 1007437 360078 360078 60356 1 0.0984875131902919
1007438 1007438 360078 360078 133491 1 0.0590925079141752
1007439 1007439 360078 360078 136298 1 0.147731269785438
1007440 1007440 360078 360078 169479 1 0.0422089342244108
1007441 1007441 360078 360078 200989 1 0.147731269785438
1007442 1007442 360078 360078 219773 1 0.0328291710634306
1007443 1007443 360078 360078 220560 1 0.049243756595146
1007444 1007444 360078 360078 258465 1 0.073865634892719
1007445 1007445 360078 360078 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)
);