consensus_index

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

13 rows where inventory_id = 220014

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
559163 559163 220014 220014 44226 11 0.258038488095921
559164 559164 220014 220014 138015 3 0.0805384874867869
559165 559165 220014 220014 147385 1 0.041813755465084
559166 559166 220014 220014 166742 5 0.151406479810296
559167 559167 220014 220014 176389 1 0.041813755465084
559168 559168 220014 220014 186342 1 0.0487827147092647
559169 559169 220014 220014 188910 5 0.0820980266653403
559170 559170 220014 220014 190981 2 0.0413935060507318
559171 559171 220014 220014 191884 2 0.0398309197684873
559172 559172 220014 220014 216644 5 0.0883090508193236
559173 559173 220014 220014 217178 4 0.0413111305061149
559174 559174 220014 220014 218194 3 0.04709919320404
559175 559175 220014 220014 334231 2 0.0312015291653598 
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)
);