consensus_index

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

14 rows where inventory_id = 498796

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1647300 1647300 498796 498796 50468 8 0.29005199950331
1647301 1647301 498796 498796 93345 1 0.0207179999645222
1647302 1647302 498796 498796 141801 3 0.060535709279528
1647303 1647303 498796 498796 179868 1 0.0414359999290443
1647304 1647304 498796 498796 186646 2 0.118413232942852
1647305 1647305 498796 498796 200506 1 0.145025999751655
1647306 1647306 498796 498796 233063 1 0.0193367999668874
1647307 1647307 498796 498796 250404 2 0.0837307999961127
1647308 1647308 498796 498796 258877 1 0.0362564999379138
1647309 1647309 498796 498796 260204 1 0.0322279999448123
1647310 1647310 498796 498796 270212 1 0.029005199950331
1647311 1647311 498796 498796 294485 1 0.0483419999172184
1647312 1647312 498796 498796 307680 2 0.0418653999980564
1647313 1647313 498796 498796 309900 1 0.0223116922694854 
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)
);