consensus_index

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

26 rows where inventory_id = 62819

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
176018 176018 62819 62819 27781 2 0.0582049488156445
176019 176019 62819 62819 37157 1 0.0107346094014212
176020 176020 62819 62819 45328 12 0.225426797429846
176021 176021 62819 62819 53515 1 0.0450853594859692
176022 176022 62819 62819 60779 1 0.0225426797429846
176023 176023 62819 62819 60780 1 0.0150284531619897
176024 176024 62819 62819 67516 1 0.0375711329049744
176025 176025 62819 62819 132347 1 0.0125237109683248
176026 176026 62819 62819 133252 1 0.0187855664524872
176027 176027 62819 62819 136336 3 0.112713398714923
176028 176028 62819 62819 136341 1 0.0563566993574615
176029 176029 62819 62819 138168 1 0.0322038282042637
176030 176030 62819 62819 141957 3 0.0492321116156951
176031 176031 62819 62819 147391 2 0.0195469823449314
176032 176032 62819 62819 148630 1 0.0204933452208951
176033 176033 62819 62819 152494 1 0.0140891748393654
176034 176034 62819 62819 199857 1 0.0161019141021319
176035 176035 62819 62819 200280 1 0.0112713398714923
176036 176036 62819 62819 200653 1 0.0173405228792189
176037 176037 62819 62819 203745 1 0.0132603998488145
176038 176038 62819 62819 205666 1 0.0250474219366496
176039 176039 62819 62819 215571 1 0.0281783496787308
176040 176040 62819 62819 232146 1 0.0450853594859692
176041 176041 62819 62819 259539 3 0.0351402002656258
176042 176042 62819 62819 276661 1 0.0375711329049744
176043 176043 62819 62819 309924 2 0.0156682455262824 
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)
);