home / zeropm-v0-0-4

consensus_index

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

21 rows where inchi_id = 173738

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15186 15186 4715 4715 173738 1 0.230769230769231
46994 46994 14390 14390 173738 1 0.0750562917915282
61036 61036 19505 19505 173738 1 0.105633802816901
92330 92330 32923 32923 173738 1 0.230769230769231
123910 123910 42989 42989 173738 1 0.0750562917915282
209250 209250 73818 73818 173738 1 0.229965156794425
299506 299506 101219 101219 173738 1 0.0750562917915282
422110 422110 153079 153079 173738 1 0.187951807228916
536723 536723 213002 213002 173738 1 0.0750562917915282
703127 703127 250388 250388 173738 1 0.105633802816901
730716 730716 257771 257771 173738 1 0.0750562917915282
799452 799452 278898 278898 173738 1 0.0740907049842838
799457 799457 278899 278899 173738 1 0.105633802816901
809883 809883 281939 281939 173738 1 0.230769230769231
809888 809888 281940 281940 173738 2 0.159284692360696
848759 848759 293613 293613 173738 1 0.0750562917915282
868022 868022 299474 299474 173738 1 0.226415094339623
926385 926385 329432 329432 173738 1 0.104408352668213
1608128 1608128 485764 485764 173738 1 0.230769230769231
1741476 1741476 533350 533350 173738 1 0.0750562917915282
1754953 1754953 537800 537800 173738 1 0.105633802816901
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 1051.983ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website