consensus_index

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

10 rows where inventory_id = 85627

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
252018 252018 85627 85627 2805 4 0.192924147833593
252019 252019 85627 85627 29279 1 0.075485652224534
252020 252020 85627 85627 73622 1 0.0335491787664596
252021 252021 85627 85627 91474 2 0.123267553900863
252022 252022 85627 85627 115465 6 0.301942608898136
252023 252023 85627 85627 136947 1 0.0431346584140195
252024 252024 85627 85627 182864 1 0.0603885217796272
252025 252025 85627 85627 248524 2 0.0675164198799865
252026 252026 85627 85627 261982 2 0.0503237681496894
252027 252027 85627 85627 290889 1 0.037742826112267 
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)
);