consensus_index

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

11 rows where inventory_id = 485731

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1607908 1607908 485731 485731 46112 2 0.283307215921649
1607909 1607909 485731 485731 137087 1 0.0944357386405497
1607910 1607910 485731 485731 137595 2 0.0817837486878638
1607911 1607911 485731 485731 148027 1 0.0236089346601374
1607912 1607912 485731 485731 192035 3 0.131499560990385
1607913 1607913 485731 485731 242118 3 0.165679064943721
1607914 1607914 485731 485731 247642 1 0.0314785795468499
1607915 1607915 485731 485731 255507 1 0.0708268039804123
1607916 1607916 485731 485731 263384 1 0.0354134019902061
1607917 1607917 485731 485731 263385 1 0.0404724594173784
1607918 1607918 485731 485731 309145 1 0.0257552014474226 
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)
);