consensus_index

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

10 rows where inchi_id = 39880

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
147343 147343 53015 53015 39880 1 0.173228346456693
231772 231772 79291 79291 39880 1 0.111553784860558
352978 352978 119380 119380 39880 8 0.521739130434783
354661 354661 120050 120050 39880 1 0.257142857142857
436027 436027 156456 156456 39880 1 0.111553784860558
700206 700206 249479 249479 39880 1 0.11214953271028
794746 794746 277350 277350 39880 1 0.172413793103448
794749 794749 277351 277351 39880 1 0.168674698795181
891251 891251 312453 312453 39880 1 0.168674698795181
1622617 1622617 489933 489933 39880 1 0.173228346456693 
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)
);