consensus_index

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

23 rows where inchi_id = 49412

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
7731 7731 2329 2329 49412 5 0.382978723404255
29069 29069 8417 8417 49412 6 0.384615384615385
91239 91239 32550 32550 49412 6 0.384615384615385
154736 154736 55659 55659 49412 9 0.294478527607362
202531 202531 71784 71784 49412 5 0.382978723404255
238568 238568 81177 81177 49412 5 0.382978723404255
291785 291785 98818 98818 49412 1 0.241379310344828
437998 437998 157009 157009 49412 5 0.382978723404255
516986 516986 207023 207023 49412 1 0.188976377952756
521443 521443 208091 208091 49412 5 0.382978723404255
521446 521446 208092 208092 49412 3 0.375
521449 521449 208093 208093 49412 3 0.375
555346 555346 218920 218920 49412 5 0.382978723404255
596851 596851 235233 235233 49412 3 0.336
663051 663051 237733 237733 49412 7 0.199424431904355
710169 710169 251953 251953 49412 7 0.260835786863045
744327 744327 261962 261962 49412 1 0.187951807228916
809251 809251 281742 281742 49412 6 0.384615384615385
809254 809254 281743 281743 49412 3 0.375
809258 809258 281744 281744 49412 4 0.210163533342795
809263 809263 281745 281745 49412 3 0.375
1625351 1625351 490817 490817 49412 6 0.384615384615385
1725770 1725770 528416 528416 49412 4 0.378378378378378 
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)
);