consensus_index

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

20 rows where inchi_id = 138063

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28473 28473 8258 8258 138063 2 0.0882383654608782
101639 101639 35867 35867 138063 2 0.0882383654608782
166695 166695 59643 59643 138063 1 0.0299740960563447
236371 236371 80587 80587 138063 2 0.048828563811216
437330 437330 156814 156814 138063 2 0.0608371991624832
521244 521244 208032 208032 138063 3 0.0429733905112683
557923 557923 219684 219684 138063 2 0.0608339846897344
707166 707166 251229 251229 138063 2 0.0608371991624832
804557 804557 280422 280422 138063 2 0.0608371991624832
804570 804570 280423 280423 138063 2 0.0882383654608782
804583 804583 280424 280424 138063 3 0.0429733905112683
1058573 1058573 374125 374125 138063 2 0.0608371991624832
1058586 1058586 374126 374126 138063 2 0.0608371991624832
1282512 1282512 421817 421817 138063 2 0.0608371991624832
1282525 1282525 421818 421818 138063 2 0.0608371991624832
1498339 1498339 463626 463626 138063 2 0.0608371991624832
1498352 1498352 463627 463627 138063 2 0.0608371991624832
1600049 1600049 483356 483356 138063 2 0.0608371991624832
1624357 1624357 490520 490520 138063 2 0.0608371991624832
1725189 1725189 528265 528265 138063 3 0.0429733905112683 
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)
);