consensus_index

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

26 rows where inchi_id = 147884

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
33768 33768 9989 9989 147884 2 0.411872319982836
49041 49041 15075 15075 147884 3 0.415239576400731
121465 121465 42225 42225 147884 2 0.409157984303722
148933 148933 53519 53519 147884 2 0.409157984303722
255890 255890 86839 86839 147884 2 0.409157984303722
303812 303812 102746 102746 147884 4 0.42052772921983
305437 305437 103253 103253 147884 4 0.350440262760282
310317 310317 104787 104787 147884 1 0.153846153846154
466826 466826 168613 168613 147884 1 0.153846153846154
581919 581919 227585 227585 147884 1 0.153846153846154
583684 583684 228104 228104 147884 3 0.418585506714698
587892 587892 229619 229619 147884 4 0.350440262760282
589519 589519 230134 230134 147884 2 0.408628001184222
680855 680855 243244 243244 147884 2 0.409157984303722
759141 759141 266464 266464 147884 1 0.25
759844 759844 266713 266713 147884 1 0.40847646066685
759847 759847 266714 266714 147884 2 0.409157984303722
942095 942095 337169 337169 147884 1 0.40847646066685
1018927 1018927 363080 363080 147884 2 0.409157984303722
1234189 1234189 408664 408664 147884 2 0.409157984303722
1468807 1468807 455358 455358 147884 2 0.409157984303722
1593672 1593672 481052 481052 147884 2 0.409157984303722
1634392 1634392 494079 494079 147884 2 0.409157984303722
1661116 1661116 503486 503486 147884 1 0.153846153846154
1730228 1730228 529887 529887 147884 1 0.40847646066685
1743424 1743424 533962 533962 147884 3 0.42052772921983 
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)
);