consensus_index

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

12 rows where inchi_id = 115009

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
79442 79442 28664 28664 115009 2 0.315789473684211
217907 217907 75575 75575 115009 2 0.249745158554402
427586 427586 154158 154158 115009 2 0.260304909858814
533148 533148 211489 211489 115009 2 0.315789473684211
734975 734975 259270 259270 115009 3 0.250527258177098
856431 856431 296272 296272 115009 2 0.315789473684211
856436 856436 296273 296273 115009 2 0.315789473684211
856442 856442 296274 296274 115009 2 0.249745158554402
856449 856449 296275 296275 115009 2 0.31304347826087
960777 960777 345765 345765 115009 1 0.311688311688312
1613108 1613108 487019 487019 115009 2 0.315789473684211
1718147 1718147 526203 526203 115009 2 0.315789473684211 
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)
);