consensus_index

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

22 rows where inchi_id = 84922

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
32031 32031 9410 9410 84922 8 0.478260869565217
89690 89690 32030 32030 84922 8 0.478260869565217
162669 162669 58255 58255 84922 16 0.454189008800558
249515 249515 84852 84852 84922 7 0.625
252370 252370 85750 85750 84922 1 0.125301204819277
442643 442643 158661 158661 84922 7 0.625
478903 478903 174953 174953 84922 1 0.599254417849115
504492 504492 201795 201795 84922 1 0.125301204819277
533464 533464 211622 211622 84922 8 0.462908011869436
734598 734598 259156 259156 84922 12 0.445942358985011
855757 855757 296015 296015 84922 8 0.478260869565217
855759 855759 296016 296016 84922 5 0.608695652173913
1173406 1173406 393917 393917 84922 8 0.478260869565217
1173409 1173409 393918 393918 84922 8 0.478260869565217
1428898 1428898 445541 445541 84922 8 0.478260869565217
1428901 1428901 445542 445542 84922 8 0.478260869565217
1586310 1586310 478905 478905 84922 8 0.478260869565217
1586313 1586313 478906 478906 84922 8 0.478260869565217
1606849 1606849 485460 485460 84922 8 0.478260869565217
1631251 1631251 492984 492984 84922 8 0.478260869565217
1632450 1632450 493412 493412 84922 1 0.153846153846154
1728425 1728425 529309 529309 84922 8 0.478260869565217 
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)
);