consensus_index

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

14 rows where inchi_id = 31649

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
58571 58571 18486 18486 31649 6 0.382978723404255
79863 79863 28829 28829 31649 6 0.382978723404255
143430 143430 51130 51130 31649 3 0.375
342547 342547 115617 115617 31649 5 0.380952380952381
479256 479256 175161 175161 31649 5 0.380952380952381
502075 502075 200342 200342 31649 2 0.630993034743972
565700 565700 222155 222155 31649 5 0.380952380952381
697475 697475 248660 248660 31649 6 0.382978723404255
789927 789927 275875 275875 31649 3 0.375
789930 789930 275876 275876 31649 3 0.375
789933 789933 275877 275877 31649 3 0.375
909090 909090 321031 321031 31649 3 0.375
1675343 1675343 508563 508563 31649 6 0.384615384615385
1752739 1752739 536965 536965 31649 6 0.382978723404255 
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)
);