consensus_index

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

16 rows where inchi_id = 31514

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27321 27321 7928 7928 31514 1 0.115384615384615
58512 58512 18469 18469 31514 6 0.382978723404255
178410 178410 63581 63581 31514 3 0.375
230961 230961 79055 79055 31514 1 0.115727002967359
319508 319508 107668 107668 31514 1 0.236842105263158
342335 342335 115541 115541 31514 6 0.382978723404255
479168 479168 175112 175112 31514 5 0.382978723404255
565813 565813 222186 222186 31514 6 0.382978723404255
698084 698084 248847 248847 31514 1 0.115727002967359
791078 791078 276184 276184 31514 1 0.115384615384615
791082 791082 276185 276185 31514 1 0.113207547169811
920085 920085 326417 326417 31514 1 0.113207547169811
931489 931489 331713 331713 31514 3 0.375
1622251 1622251 489812 489812 31514 1 0.116022099447514
1724002 1724002 527933 527933 31514 1 0.113207547169811
1752698 1752698 536953 536953 31514 6 0.384615384615385 
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)
);