consensus_index

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

12 rows where inventory_id = 73676

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
208218 208218 73676 73676 44238 1 0.0500006816836108
208219 208219 73676 73676 45314 8 0.300004090101665
208220 208220 73676 73676 136973 2 0.150002045050833
208221 208221 73676 73676 137586 2 0.0866037210890925
208222 208222 73676 73676 140560 2 0.0566954439079443
208223 208223 73676 73676 206906 2 0.044721969266353
208224 208224 73676 73676 217175 2 0.0474348116043819
208225 208225 73676 73676 219404 2 0.0300004090101665
208226 208226 73676 73676 251623 1 0.100001363367222
208227 208227 73676 73676 257420 1 0.0500006816836108
208228 208228 73676 73676 291666 2 0.0400897328496889
208229 208229 73676 73676 310735 1 0.0333337877890739 
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)
);