home / zeropm-v0-0-4

consensus_index

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

9 rows where inventory_id = 533803

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1742835 1742835 533803 533803 1823 10 0.297923566329117
1742836 1742836 533803 533803 163789 1 0.0456917832291635
1742837 1742837 533803 533803 178330 5 0.210663774026599
1742838 1742838 533803 533803 209452 1 0.091383566458327
1742839 1742839 533803 533803 241614 1 0.041537984753785
1742840 1742840 533803 533803 243007 3 0.0809246083161748
1742841 1742841 533803 533803 248102 3 0.0735248861190981
1742842 1742842 533803 533803 248999 1 0.0761529720486058
1742843 1742843 533803 533803 332351 1 0.0652739760416621
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)
);
Powered by Datasette · Queries took 1106.02ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website