consensus_index

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

9 rows where inventory_id = 42335

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
121828 121828 42335 42335 13455 1 0.0616496265884163
121829 121829 42335 42335 50251 2 0.0932054744988256
121830 121830 42335 42335 92795 1 0.246598506353665
121831 121831 42335 42335 131968 4 0.246598506353665
121832 121832 42335 42335 138119 2 0.0636714605538246
121833 121833 42335 42335 190767 2 0.123299253176833
121834 121834 42335 42335 230956 2 0.0711868570125241
121835 121835 42335 42335 254337 2 0.0389906473836543
121836 121836 42335 42335 288007 1 0.0410997510589442 
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)
);