consensus_index

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

27 rows where inchi_id = 13346

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
26906 26906 7840 7840 13346 8 0.42368278109723
96106 96106 34062 34062 13346 1 0.00892089375806501
97285 97285 34510 34510 13346 8 0.42368278109723
135047 135047 47863 47863 13346 12 0.400365583002849
135151 135151 47899 47899 13346 1 0.113207547169811
229520 229520 78707 78707 13346 8 0.398128433216536
255696 255696 86768 86768 13346 2 0.330995405619376
256997 256997 87055 87055 13346 1 0.00892089375806501
292451 292451 99043 99043 13346 1 0.115384615384615
435394 435394 156297 156297 13346 8 0.398128433216536
445665 445665 159626 159626 13346 1 0.00892089375806501
458356 458356 164748 164748 13346 1 0.115384615384615
545895 545895 216010 216010 13346 1 0.115384615384615
577738 577738 226347 226347 13346 8 0.398128433216536
579781 579781 226971 226971 13346 1 0.00892089375806501
683749 683749 244031 244031 13346 1 0.00892089375806501
685972 685972 244631 244631 13346 8 0.42368278109723
759366 759366 266525 266525 13346 1 0.297965672868055
765541 765541 268149 268149 13346 1 0.00892089375806501
769759 769759 269274 269274 13346 8 0.42368278109723
769764 769764 269275 269275 13346 6 0.348837209302326
1621613 1621613 489672 489672 13346 8 0.42368278109723
1634983 1634983 494236 494236 13346 1 0.00892089375806501
1650517 1650517 499869 499869 13346 1 0.115384615384615
1723546 1723546 527820 527820 13346 8 0.42368278109723
1730913 1730913 530042 530042 13346 1 0.00892089375806501
1738519 1738519 532532 532532 13346 1 0.115384615384615 
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)
);