consensus_index

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

12 rows where inventory_id = 271159

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
775300 775300 271159 271159 9396 2 0.0488164596148645
775301 775301 271159 271159 19122 4 0.101059672527735
775302 775302 271159 271159 97492 6 0.267378761086012
775303 775303 271159 271159 130832 1 0.0267378761086012
775304 775304 271159 271159 183457 1 0.0445631268476687
775305 775305 271159 271159 190126 2 0.133689380543006
775306 775306 271159 271159 207250 1 0.0334223451357515
775307 775307 271159 271159 227544 1 0.0891262536953374
775308 775308 271159 271159 277353 2 0.0597877085527999
775309 775309 271159 271159 320177 1 0.0297087512317791
775310 775310 271159 271159 329468 2 0.0545784610598551
775311 775311 271159 271159 332601 4 0.101581962129232 
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)
);