consensus_index

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

14 rows where inchi_id = 197987

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
43 43 10 10 197987 1 0.194805194805195
194762 194762 69123 69123 197987 1 0.241935483870968
199218 199218 70865 70865 197987 1 0.194805194805195
320346 320346 107968 107968 197987 1 0.238095238095238
470249 470249 170210 170210 197987 1 0.238095238095238
528195 528195 209875 209875 197987 1 0.239130434782609
528198 528198 209876 209876 197987 1 0.239130434782609
575421 575421 225407 225407 197987 1 0.3125
661126 661126 236720 236720 197987 1 0.238095238095238
688069 688069 245400 245400 197987 1 0.241935483870968
772677 772677 270323 270323 197987 1 0.239130434782609
772680 772680 270324 270324 197987 1 0.3125
892615 892615 313146 313146 197987 1 0.3
1747739 1747739 535316 535316 197987 1 0.3125 
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)
);