home / zeropm-v0-0-4

consensus_index

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

37 rows where inchi_id = 83772

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18938 18938 5557 5557 83772 8 0.625
116785 116785 40732 40732 83772 8 0.625
140392 140392 50019 50019 83772 4 0.5
160222 160222 57610 57610 83772 10 0.631578947368421
216691 216691 75210 75210 83772 8 0.375903614457831
338853 338853 114264 114264 83772 4 0.5
412513 412513 146053 146053 83772 1 0.307692307692308
426795 426795 153918 153918 83772 8 0.375903614457831
477555 477555 174180 174180 83772 4 0.5
514631 514631 206457 206457 83772 8 0.375903614457831
534501 534501 212110 212110 83772 8 0.625
695938 695938 248121 248121 83772 4 0.504859306985452
733481 733481 258657 258657 83772 11 0.634146341463415
786531 786531 274758 274758 83772 4 0.504859306985452
786533 786533 274759 274759 83772 2 0.487728457387774
786535 786535 274760 274760 83772 2 0.487728457387774
853067 853067 295124 295124 83772 8 0.375903614457831
853071 853071 295125 295125 83772 8 0.625
853073 853073 295126 295126 83772 8 0.625
933710 933710 332698 332698 83772 2 0.487728457387774
1171487 1171487 393452 393452 83772 8 0.625
1171489 1171489 393453 393453 83772 8 0.625
1171491 1171491 393454 393454 83772 8 0.625
1171493 1171493 393455 393455 83772 8 0.625
1427191 1427191 445123 445123 83772 8 0.625
1427193 1427193 445124 445124 83772 8 0.625
1427195 1427195 445125 445125 83772 8 0.625
1427197 1427197 445126 445126 83772 8 0.625
1585120 1585120 478612 478612 83772 8 0.625
1585122 1585122 478613 478613 83772 8 0.625
1585124 1585124 478614 478614 83772 8 0.625
1585126 1585126 478615 478615 83772 8 0.625
1606511 1606511 485354 485354 83772 8 0.625
1612255 1612255 486713 486713 83772 8 0.625
1673728 1673728 507950 507950 83772 4 0.504859306985452
1717766 1717766 526081 526081 83772 8 0.625
1751777 1751777 536636 536636 83772 4 0.504859306985452
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 1168.649ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website