consensus_index

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

10 rows where inventory_id = 41462

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
119084 119084 41462 41462 42191 7 0.334695344422135
119085 119085 41462 41462 137012 1 0.167347672211067
119086 119086 41462 41462 164771 1 0.066939068884427
119087 119087 41462 41462 189116 1 0.111565114807378
119088 119088 41462 41462 228237 1 0.0418369180527669
119089 119089 41462 41462 228826 1 0.0836738361055337
119090 119090 41462 41462 257957 1 0.0557825574036891
119091 119091 41462 41462 264426 1 0.0478136206317336
119092 119092 41462 41462 290094 1 0.0334695344422135
119093 119093 41462 41462 309476 1 0.0371883716024594 
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)
);