Visualization of Golm Database Results

NAMESRETENTION INFOSDISTANCE SCORESIDs
N° SpectresSpectrumAnalyteRetention IndexRI DiscrepancyDot productEuclideanJaccardHammings12 Gower-LegendreSpectrum idMetabolite idAnalyte id
N° SpectreSpectrumAnalyteRetention IndexRI DiscrepancyDot productEuclideanJaccardHammings12 Gower-LegendreSpectrum idMetabolite idAnalyte id
1Glucose (1MEOX) (5TMS) BP [A191001-ambient-na-12]Glucose (1MEOX) (5TMS) BP1899.054931.0549530.4861830.0871580.8515621090.784043833ab58c-a8fa-4389-8b42-95e618cafb9168513255-fc44-4041-bc4b-4fd2fae7541d0a2b3536-2245-4c0e-bdbc-495766eeec67
1Galactose (1MEOX) (5TMS) BP [A191002-ambient-DL--6]Galactose (1MEOX) (5TMS) BP1902.422124.4221190.4875460.0869420.8527131100.7849976e056b61-4da9-46e3-970b-680a22e4afd0dd3ea070-54a6-4ea7-b99b-a6e975fdd2041c3ad0aa-ee78-4542-93b3-aa9fdf07add1
1Idose (1MEOX) (5TMS) BP [A191005-ambient-na-1]Idose (1MEOX) (5TMS) BP1897.254390.7456054690.4901550.0861780.8560611130.787786d00de57d-6fab-49d0-9aee-25e259da9180ab025068-f464-4bc6-9c92-994c29387db26f4e926f-d7ef-47b6-a52c-91ff88ca567a
1Allantoin (5TMS) [A188009-ambient-na-5]Allantoin (5TMS)1896.998291.0017090.4914570.0941010.855856950.804233817f2a03-9df5-46e3-973c-b2a9675109cfa999f0d6-0285-41d9-a6ba-b705987b663c65bb54d2-6bf7-4a53-aa22-8abf71240005
1Glucose, U-13C- (1MEOX) (5TMS) BP [A191001-13C-na-2]Glucose, U-13C- (1MEOX) (5TMS) BP1901.633.630.4972270.0910340.8500001020.78832227d4dcdd-d351-4976-8ef9-76a0cc53f631441faccb-2631-4e7d-b6ca-99437265ccb896441b61-2891-4e81-93dc-d0fc0ad175d4
2no results
3Glucose (1MEOX) (5TMS) BP [A191001-ambient-na-12]Glucose (1MEOX) (5TMS) BP1899.054931.0549530.4870520.0868980.8604651110.796870833ab58c-a8fa-4389-8b42-95e618cafb9168513255-fc44-4041-bc4b-4fd2fae7541d0a2b3536-2245-4c0e-bdbc-495766eeec67
3Galactose (1MEOX) (5TMS) BP [A191002-ambient-DL--6]Galactose (1MEOX) (5TMS) BP1902.422124.4221190.4883620.0866790.8615381120.7977596e056b61-4da9-46e3-970b-680a22e4afd0dd3ea070-54a6-4ea7-b99b-a6e975fdd2041c3ad0aa-ee78-4542-93b3-aa9fdf07add1
3Idose (1MEOX) (5TMS) BP [A191005-ambient-na-1]Idose (1MEOX) (5TMS) BP1897.254390.7456054690.4911380.0859390.8646621150.800359d00de57d-6fab-49d0-9aee-25e259da9180ab025068-f464-4bc6-9c92-994c29387db26f4e926f-d7ef-47b6-a52c-91ff88ca567a
3Allantoin (5TMS) [A188009-ambient-na-5]Allantoin (5TMS)1896.998291.0017090.4918880.0937220.866071970.817843817f2a03-9df5-46e3-973c-b2a9675109cfa999f0d6-0285-41d9-a6ba-b705987b663c65bb54d2-6bf7-4a53-aa22-8abf71240005
3Glucose, U-13C- (1MEOX) (5TMS) BP [A191001-13C-na-2]Glucose, U-13C- (1MEOX) (5TMS) BP1901.633.630.4982810.0907530.8595041040.80154927d4dcdd-d351-4976-8ef9-76a0cc53f631441faccb-2631-4e7d-b6ca-99437265ccb896441b61-2891-4e81-93dc-d0fc0ad175d4
4no results
print
copy
export


What can the table do ?

  • filter_list By default, the spectra numbers (N° Spectra) are ordered by ascending values. You can manage your data ordering as you wish. You can even order data according to multiple columns: SHIFT + LEFT CLICK on column headers. This will order by the first column clicked, then the second, etc. You can sort data specifically by clicking on any entry in boxes under each columns.
  • delete_sweep You can delete multiple entries that are selected: Select wanted entries and click on the button DELETE SELECTED ROWS.
  • remove_red_eye You have the possibility to toggle columns by clicking on SHOW MORE.
  • save You can print, copy, or export to excel and csv the table on its actual state, with the three buttons right above the table.

Distances scores

S12Gower-Legendre Distance The distance measure S12GowLeg = sqrt(1 - s12) is derived from the S12 coefficient of Gower & Legendre defined as s12 = a / sqrt((a + b)(a + c)), with "a" representing the number of positions at which both spectra are in "on-state" and "b" respectively "c" representing the number of positions at which only the query spectrum or the hit spectrum are in "on-state".
Hamming Distance In information theory, the Hamming distance between two strings of equal length is the number of positions for which the corresponding symbols are different. Put another way, it measures the minimum number of substitutions required to change one into the other, or the number of errors that transformed one string into the other.
Jaccard DistanceNumber of matches (a mass with appropriate intensity in both spectra) divided by the sum of matches and mismatches (a mass where only one of both spectra has a intensity). The jaccard distance is a binary distance.
Dotproduct DistanceThe Dotproduct distance is summing the multiplied intensities over all matching peaks within both spectra. Here, to satisfy the conditions of a metric I) non-negativity, II) identity of indiscernibles, III) symmetry and IV) subadditivity / triangle inequality, we use 1-Dotproduct. Both spectra are normalised prior to the spectral vector norm in that way, that the absolute value of the squared intensities is equal to 1.
Euclidean DistanceThe Euclid is the square root of the sum of the squared differences over all matching peaks.