consensus_index

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

26 rows where inchi_id = 45294

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3560 3560 991 991 45294 17 0.947368421052632
40164 40164 12158 12158 45294 2 0.0752850516648181
107559 107559 37821 37821 45294 1 0.0708981822094335
179130 179130 63887 63887 45294 12 0.378001989484155
200958 200958 71381 71381 45294 17 0.947368421052632
208130 208130 73659 73659 45294 8 0.9
213039 213039 74278 74278 45294 1 0.0180926664794926
281478 281478 95467 95467 45294 2 0.0752850516648181
345003 345003 116534 116534 45294 2 0.0748305676619903
421617 421617 153003 153003 45294 7 0.888888888888889
511198 511198 205854 205854 45294 5 0.857142857142857
511199 511199 205855 205855 45294 4 0.833333333333333
511200 511200 205856 205856 45294 4 0.833333333333333
543146 543146 214867 214867 45294 1 0.0151780462460869
558443 558443 219833 219833 45294 8 0.376007162041182
564466 564466 221747 221747 45294 2 0.0748305676619903
662782 662782 237641 237641 45294 5 0.857142857142857
792805 792805 276754 276754 45294 1 0.074572280843635
792810 792810 276755 276755 45294 1 0.0717788263794283
803862 803862 280215 280215 45294 7 0.888888888888889
803863 803863 280216 280216 45294 5 0.857142857142857
834925 834925 289679 289679 45294 1 0.0180926664794926
915297 915297 324248 324248 45294 1 0.0708981822094335
1607694 1607694 485693 485693 45294 7 0.888888888888889
1646060 1646060 498370 498370 45294 2 0.0300053553000996
1714278 1714278 525327 525327 45294 4 0.833333333333333 
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)
);