home / zeropm-v0-0-4

consensus_index

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

28 rows where inchi_id = 37162

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
12968 12968 3993 3993 37162 1 0.0460612522807635
27240 27240 7914 7914 37162 1 0.0460612522807635
112179 112179 39236 39236 37162 1 0.0460612522807635
192745 192745 68500 68500 37162 1 0.0467876467307787
230659 230659 78998 78998 37162 1 0.0460612522807635
349454 349454 118059 118059 37162 7 0.620689655172414
435702 435702 156368 156368 37162 1 0.0460612522807635
565554 565554 222114 222114 37162 1 0.0482246212765473
662112 662112 237278 237278 37162 1 0.0460612522807635
697664 697664 248739 248739 37162 1 0.0458448459420533
790308 790308 275978 275978 37162 1 0.0484761857060301
790317 790317 275979 275979 37162 1 0.0483988387468527
790326 790326 275980 275980 37162 1 0.0460612522807635
872235 872235 301094 301094 37162 4 0.6
887839 887839 309551 309551 37162 1 0.0483988387468527
1049933 1049933 371437 371437 37162 1 0.0460612522807635
1049942 1049942 371438 371438 37162 1 0.0460612522807635
1049951 1049951 371439 371439 37162 1 0.0460612522807635
1271932 1271932 418512 418512 37162 1 0.0460612522807635
1271941 1271941 418513 418513 37162 1 0.0460612522807635
1271950 1271950 418514 418514 37162 1 0.0460612522807635
1491753 1491753 461571 461571 37162 1 0.0460612522807635
1491762 1491762 461572 461572 37162 1 0.0460612522807635
1491771 1491771 461573 461573 37162 1 0.0460612522807635
1598242 1598242 482715 482715 37162 1 0.0460612522807635
1622092 1622092 489786 489786 37162 1 0.0460612522807635
1678714 1678714 509837 509837 37162 1 0.192307692307692
1723850 1723850 527911 527911 37162 1 0.0483988387468527
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)
);
Powered by Datasette · Queries took 731.667ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website