consensus_index

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

20 rows where inchi_id = 153647

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
186814 186814 66560 66560 153647 2 0.147337115814866
420885 420885 152056 152056 153647 1 0.467520617081764
464722 464722 167049 167049 153647 2 0.106720337776639
677448 677448 242016 242016 153647 3 0.131013530783387
947328 947328 339558 339558 153647 1 0.0932521387285678
1002662 1002662 358972 358972 153647 2 0.106720337776639
1002666 1002666 358973 358973 153647 2 0.106720337776639
1002670 1002670 358974 358974 153647 2 0.106720337776639
1002674 1002674 358975 358975 153647 2 0.106720337776639
1214002 1214002 403438 403438 153647 2 0.106720337776639
1214006 1214006 403439 403439 153647 2 0.106720337776639
1214010 1214010 403440 403440 153647 2 0.106720337776639
1214014 1214014 403441 403441 153647 2 0.106720337776639
1456689 1456689 452334 452334 153647 2 0.106720337776639
1456693 1456693 452335 452335 153647 2 0.106720337776639
1456697 1456697 452336 452336 153647 2 0.106720337776639
1456701 1456701 452337 452337 153647 2 0.106720337776639
1592522 1592522 480704 480704 153647 2 0.106720337776639
1658935 1658935 502711 502711 153647 2 0.106720337776639
1744139 1744139 534133 534133 153647 2 0.106720337776639 
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)
);