The latest Lasair update adds a new function and new attributes. For the objects table, your filter can SELECT like this example:
objects.diaObjectId,
flux2mag(objects.g_psfFlux) AS mag,
objects.nPosDiaSources, objects.nPosDiaSourcesNights
Users have been annoyed at being forced to think in flux after a lifetime with magnitudes, so the flux2mag function converts flux in nJ to magnitudes.
Users looking for explosions have been annoyed by objects that were bright when template images were taken, but are no longer, resulting in a negative difference flux. The objects.nPosDiaSources is the number of sources in the lightcurve with positive flux, that can be compared with objects.nDiaSources, the total number of points.
The attribute objects.nPosDiaSourcesNights is the number of observation nights when positive difference flux was measured.
Many extragalactic sources come with a host galaxy, whose distance can establish absolute magnitude, as reported by the objects.absMag. Extra detail is provided in the revised Sherlock schema, that now has:
sherlock_classifications.best_distance,
sherlock_classifications.best_distance_flag,
sherlock_classifications.best_distance_source
The first is the best distance estimate in Mpc, and the last is the provenance of that estimate, for example “SDSS DR12 PhotoObjAll Table”. The flag is about how the distance was determined, it can be
-
ddfor Direct distance (dd) -
szfor Spectroscopic Redshift -
pzfor Photometric Redshift