

In [1]:

    
# This changes the current directory to the base saga directory - make sure to run this first!
# This is necessary to be able to import the py files and use the right directories,
# while keeping all the notebooks in their own directory.
import os
import sys

if 'saga_base_dir' not in locals():
    saga_base_dir = os.path.abspath('..')

if saga_base_dir not in sys.path:
    os.chdir(saga_base_dir)



In [48]:

    
from __future__ import print_function, division

import numpy as np
from scipy import interpolate

from astropy import units as u
from astropy import constants as cnst
from astropy.time import Time
from astropy.table import Table
from astropy.coordinates import SkyCoord
from astropy.stats import sigma_clip
from astropy import modeling

import astroplan



In [3]:

    
%matplotlib inline
from matplotlib import pyplot as plt
from matplotlib import rcParams

rcParams['image.interpolation'] = 'none'
rcParams['figure.figsize'] = (16, 10)
plt.rcParams['image.cmap'] = 'viridis'

Find all of the sats that are in SAGA hosts



In [4]:

    
ls -lt SAGADropbox/data/*_spectra*









    



-rwxrw-rw- 1 erik erik 34596512 Sep 22 21:12 SAGADropbox/data/saga_spectra_clean.fits.gz*



In [5]:

    
t = table.Table.read('SAGADropbox/data/saga_spectra_clean.fits.gz')



In [6]:

    
t[(t['TELNAME']=='NSA')&(t['SATS']==1)]









    Out[6]:




<Table masked=True length=130>

OBJID RA DEC PHOTPTYPE PHOT_SG FLAGS clean SATURATED BAD_COUNTS_ERROR BINNED1 TOO_FEW_GOOD_DETECTIONS u g r i z u_err g_err r_err i_err z_err MODELMAGERR_U MODELMAGERR_G MODELMAGERR_R MODELMAGERR_I MODELMAGERR_Z EXTINCTION_U EXTINCTION_G EXTINCTION_R EXTINCTION_I EXTINCTION_Z DERED_U DERED_G DERED_R DERED_I DERED_Z PETRORAD_U PETRORAD_G PETRORAD_R PETRORAD_I PETRORAD_Z PETRORADERR_U PETRORADERR_G PETRORADERR_R PETRORADERR_I PETRORADERR_Z DEVRAD_U DEVRADERR_U DEVRAD_G DEVRADERR_G DEVRAD_R DEVRADERR_R DEVRAD_I DEVRADERR_I DEVRAD_Z DEVRADERR_Z DEVAB_U DEVAB_G DEVAB_R DEVAB_I DEVAB_Z CMODELMAG_U CMODELMAGERR_U CMODELMAG_G CMODELMAGERR_G CMODELMAG_R CMODELMAGERR_R CMODELMAG_I CMODELMAGERR_I CMODELMAG_Z CMODELMAGERR_Z PSFMAG_U PSFMAGERR_U PSFMAG_G PSFMAGERR_G PSFMAG_R PSFMAGERR_R PSFMAG_I PSFMAGERR_I PSFMAG_Z PSFMAGERR_Z FIBERMAG_U FIBERMAGERR_U FIBERMAG_G FIBERMAGERR_G FIBERMAG_R FIBERMAGERR_R FIBERMAG_I FIBERMAGERR_I FIBERMAG_Z FIBERMAGERR_Z FRACDEV_U FRACDEV_G FRACDEV_R FRACDEV_I FRACDEV_Z Q_U U_U Q_G U_G Q_R U_R Q_I U_I Q_Z U_Z EXPAB_U EXPRAD_U EXPPHI_U EXPAB_G EXPRAD_G EXPPHI_G EXPAB_R EXPRAD_R EXPPHI_R EXPAB_I EXPRAD_I EXPPHI_I EXPAB_Z EXPRAD_Z EXPPHI_Z FIBER2MAG_R FIBER2MAGERR_R EXPMAG_R EXPMAGERR_R PETROR50_R PETROR90_R PETROMAG_R SB_EXP_R SB_PETRO_R J JERR H HERR K KERR SPEC_Z SPEC_Z_ERR SPEC_Z_WARN PHOTOZ PHOTOZ_ERR W1 W1ERR W2 W2ERR HOST_RA HOST_DEC HOST_DIST HOST_VHOST HOST_MK HOST_NSAID HOST_FLAG HOST_SAGA_NAME RHOST_ARCM RHOST_KPC OBJ_NSAID SATS PROBABILITY_CLASS1 RESCALED_PROBABILITY_CLASS1 REMOVE TELNAME MASKNAME ZQUALITY SPEC_CLASS SPECOBJID SPEC_REPEAT
int64 float64 float64 int16 str40 int64 int32 int64 int64 int64 int64 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float64 float64 float32 float32 float32 float32 float32 float32 float32 float32 int32 float32 float32 float64 float64 float64 float64 float64 float64 float64 float64 float64 int64 int64 str48 float64 float64 int64 int64 float64 float64 int64 str6 str48 int64 str2 str48 str48
1237648722289295527 145.320962664 0.771102651396 3 GALAXY 68988043776 1 0 0 268435456 0 18.7395 17.6063 17.1605 16.9516 16.7769 0.0283063 0.00646028 0.00594115 0.00720908 0.0171965 0.0273266 0.0062947 0.00570953 0.00689574 0.0178854 0.608006 0.447365 0.324466 0.246033 0.174441 18.2627 17.2831 16.9258 16.7912 16.6819 3.77931 4.4029 4.98527 5.1239 24.9092 0.217144 0.111835 0.141186 0.116695 8.51344 2.57427 0.425552 3.45923 0.0851165 4.06205 0.12706 4.24132 0.119345 5.17283 0.379126 0.670546 0.681586 0.688063 0.712973 0.707609 18.9483 0.0272871 17.6245 0.00638381 17.0989 0.00582051 16.8696 0.00705032 16.6378 0.0185209 20.0718 0.0352348 19.106 0.0140474 18.602 0.0193119 18.4885 0.0157263 18.4235 0.0277232 20.0572 0.0323801 18.96 0.00819829 18.549 0.00751242 18.3379 0.00918833 18.148 0.024217 0.251249 0.395446 0.344743 0.334241 0.323474 0.0608646 0.0327015 0.0777924 0.0654216 0.0742687 0.0610308 0.0632748 0.0512498 0.0413077 0.105914 0.71549 1.59726 14.1018 0.710982 1.90739 21.88 0.731562 2.04755 20.5199 0.758912 2.02837 20.178 0.737766 2.04899 30.4873 19.2578 0.010051 17.2503 0.00570953 2.23696 5.74052 17.1605 20.8019040859 20.9041968097 16.638 0.145 16.03 0.2 15.33 9999.0 0.00658949 6.01168e-06 0 0.017868 0.006357 -1.0 -1.0 -1.0 -1.0 145.514 0.336452 30.0374 1912.35 -23.5403116898 32 0 28.5362969176 249.333758002 30 1 0.666416895163 -1.0 -1 NSA sdss 4 1.23764872229e+18 NSA
1237653612647678107 139.49713703 52.7427116605 3 GALAXY 105656464052312 0 0 0 268435456 0 15.9736 14.8912 14.4537 14.2214 14.0957 0.0146398 0.00471771 0.0461497 0.0023442 0.00891875 0.0149247 0.00332935 0.00335232 0.00394758 0.0118248 0.0700311 0.0515282 0.0373726 0.0283385 0.0200923 16.3897 15.0769 14.6336 14.3843 14.305 19.8463 24.4874 23.7626 23.2343 20.3614 1.00869 1.96718 2.17022 1.82488 1.39401 29.6691 1.39908 29.6811 0.204404 29.6806 0.519559 29.6909 0.807684 29.6769 1.41787 0.503872 0.532021 0.501362 0.530124 0.492683 16.4666 0.0149241 15.0965 0.00332673 14.671 0.00335232 14.4141 0.00394777 14.3644 0.0118063 20.2212 0.0698294 19.3131 0.0166888 18.7949 0.0219506 18.5116 0.0242411 18.5845 0.03897 20.5047 0.0685074 19.2191 0.0120617 18.7225 0.00962553 18.4587 0.0104538 18.2787 0.0303292 0.0 0.0 0.0 0.0 0.0 -0.261544 -0.00132623 -0.258105 -0.00814401 -0.262315 -0.00958174 -0.256495 -0.0125349 -0.290762 -0.0151937 0.383497 15.8793 71.9599 0.390633 16.3734 70.2695 0.383483 15.9691 70.5642 0.37952 16.0024 70.806 0.35889 15.6147 70.397 19.5716 0.0140277 14.671 0.00335232 10.4718 23.3738 14.7451 22.6828336855 21.8406624612 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00784852 1.10209e-05 0 0.01555 0.007905 -1.0 -1.0 -1.0 -1.0 139.416 52.993 36.2141 2274.04 -23.3883884825 16235 0 15.3071601868 161.248990967 16242 1 0.838893311133 -1.0 -1 NSA sdss 4 1.23765361265e+18 NSA
1237653613184680084 139.44430792 53.2935206629 3 GALAXY 105555565871120 1 0 0 268435456 0 16.6658 15.7208 15.4323 15.2741 15.1524 0.0139382 0.00301873 0.00342679 0.00504487 0.0588319 0.224526 0.0267989 0.027004 0.0319874 0.125845 0.079182 0.0582614 0.042256 0.0320415 0.0227178 21.855 20.2264 19.8335 19.6385 19.7003 1.68306 1.59926 1.62416 1.52557 1.60032 1.5113 0.0503589 0.0521055 0.071807 0.453671 0.36649 2.05729 0.236029 0.065414 0.23625 0.0549392 0.317591 0.0937302 0.52313 1.13303 0.259253 0.668257 0.819082 0.823623 0.847132 21.9067 0.781104 20.2957 0.0267861 19.8758 0.027004 19.6106 0.0338507 19.5537 0.237065 22.0595 0.322107 20.4211 0.086609 20.0201 0.0889908 19.8619 0.0850723 19.9473 0.165663 20.7537 0.0978331 19.6555 0.0420921 19.3308 0.0427019 19.127 0.0439952 19.0318 0.081404 0.0 0.0 0.0 0.0 0.0 -0.0275073 -0.00578819 -0.00171337 -0.00332499 0.0108761 0.00965585 0.0183231 0.0196789 0.0410074 0.019253 0.370165 0.534264 -7.79206 0.744048 0.3789 104.479 0.877404 0.379294 121.647 0.885477 0.472141 -23.7637 0.935289 0.588303 -0.700703 20.1955 0.0631348 19.8758 0.027004 0.845911 1.37723 20.0937 19.7661037933 21.7258138691 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00754025 -1.0 0 0.095635 0.049909 -1.0 -1.0 -1.0 -1.0 139.416 52.993 36.2141 2274.04 -23.3883884825 16235 0 18.0292303883 189.923633914 16265 1 0.146734888189 -1.0 -1 NSA sdss 4 1.23765361318e+18 NSA
1237654381982777375 154.231241268 58.3949131454 3 GALAXY 1161121054724184 0 0 0 268435456 0 15.8787 15.1285 14.939 14.8546 14.8655 0.0113269 0.00242546 0.0028305 0.00403012 0.0142265 0.0116545 0.00338663 0.00383601 0.00458371 0.0183108 0.0492185 0.0362145 0.0262658 0.0199166 0.0141211 16.2678 15.3373 15.1262 15.0205 15.2443 18.2447 23.0718 21.4317 22.2034 17.3019 0.673451 2.14628 1.45466 1.55369 0.554916 29.6714 1.27172 29.6742 0.266767 29.6734 0.710614 29.674 0.544587 29.6697 2.54586 0.574496 0.65075 0.703629 0.791788 0.637573 16.3339 0.0118528 15.3473 0.00341309 15.1411 0.00385898 15.0142 0.00458085 15.3825 0.0184029 19.8522 0.0464501 19.3812 0.025835 19.3349 0.0266619 19.4574 0.0365136 19.5265 0.0636252 19.8239 0.0352038 19.2142 0.0214475 19.0999 0.0198397 19.199 0.0229381 19.1258 0.0556786 0.142589 0.0595947 0.0355276 0.0 0.0575883 -0.145451 0.00719412 -0.120104 0.00890526 -0.111458 0.00929654 -0.102879 0.0093793 -0.141793 0.0168834 0.549937 13.4465 35.7284 0.499992 15.6295 30.1459 0.505991 15.3413 29.8997 0.528992 15.412 28.328 0.54996 12.6994 34.186 19.8805 0.0269105 15.1525 0.00383601 10.7567 25.9381 15.1818 23.0772237238 22.3356177192 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00752522 5.10935e-06 0 0.055724 0.076186 -1.0 -1.0 -1.0 -1.0 154.888 58.2058 34.4951 2099.41 -23.2197870414 16559 0 23.6164183441 236.970422511 136957 1 -1.0 -1.0 -1 NSA ned 4 1.23765438198e+18 NSA
1237654381982777687 154.300660995 58.5392741055 3 GALAXY 105555532321368 0 0 0 268435456 0 18.5376 17.7102 17.4582 17.3738 17.3917 0.0229088 0.00697469 0.00625486 0.0494695 0.0358835 0.0411633 0.009732 0.0122612 0.0165264 0.0531301 0.0483243 0.0355565 0.0257886 0.0195547 0.0138645 18.5118 17.6441 17.4211 17.3075 17.3424 7.90489 9.45046 9.96037 9.65947 22.9486 0.766706 0.454416 0.413069 0.390776 1.45836 15.3519 2.2732 19.1247 0.681015 19.9777 0.936011 20.5993 1.35518 29.6687 7.49384 0.376179 0.417696 0.450004 0.450095 0.423683 18.707 0.0406958 17.7192 0.0097158 17.4468 0.0122612 17.3313 0.016522 17.2564 0.0529603 21.0796 0.0767127 20.5252 0.0289076 20.3916 0.0330139 20.4217 0.0425738 20.4987 0.132979 20.9373 0.0681592 20.2588 0.0225183 20.0833 0.0252898 20.0455 0.0290579 19.99 0.110548 0.0209734 0.0 0.0 0.0 0.0 -0.12473 0.133176 -0.178947 0.0665444 -0.160778 0.0599701 -0.165203 0.0797821 -0.260787 0.0912758 0.400006 5.64074 34.3992 0.44426 6.4434 37.9929 0.481337 6.56775 38.6094 0.47123 6.59417 36.8409 0.462135 7.26794 42.4106 20.9163 0.0364413 17.4468 0.0122612 4.6359 9.56048 17.5112 23.5293768298 22.8373312519 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.007625 -1.0 0 0.024138 0.011549 -1.0 -1.0 -1.0 -1.0 154.888 58.2058 34.4951 2099.41 -23.2197870414 16559 0 27.2435409018 273.364762957 16572 1 0.414566374504 -1.0 -1 NSA sdss 4 1.23765438198e+18 NSA
1237655368744632621 155.66592215 58.0900769045 3 GALAXY 35255507619888 1 0 0 268435456 0 18.1088 17.2602 16.9617 16.7779 16.8152 0.13591 0.015449 0.00657507 0.0085953 0.0337375 0.0318773 0.00865825 0.0116869 0.0143658 0.0504644 0.0500261 0.0368087 0.0266968 0.0202434 0.0143528 18.3153 17.4147 17.1797 17.0181 16.9609 8.09863 9.57642 10.1302 10.7851 9.6585 0.938483 0.593751 0.604083 0.49888 0.866765 19.1752 2.31815 19.1161 0.612509 22.9234 1.23091 23.8143 1.37182 22.1677 5.17094 0.35321 0.370475 0.379092 0.420371 0.352961 18.4411 0.0323945 17.5031 0.00865351 17.2064 0.0116869 16.9953 0.0143518 16.9701 0.0521838 20.8103 0.06398 20.0821 0.0220376 20.0657 0.0269211 19.8806 0.0329196 19.8584 0.103907 20.879 0.0621806 20.1041 0.0173513 19.9364 0.0217418 19.8087 0.0290553 19.6882 0.098768 0.0546165 0.0 0.0 0.0 0.0 0.337432 0.0442225 0.272525 0.0527048 0.273914 0.0432047 0.254312 0.0318912 0.263629 0.034161 0.389009 6.18766 -19.0674 0.434478 6.49304 -18.1126 0.425633 6.89964 -17.9583 0.455078 7.01333 -17.2175 0.418459 6.97079 -15.4312 20.7577 0.031078 17.2064 0.0116869 4.78958 10.7203 17.2472 23.396000288 22.6441662566 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00675755 5.85553e-06 0 0.036006 0.011221 -1.0 -1.0 -1.0 -1.0 154.888 58.2058 34.4951 2099.41 -23.2197870414 16559 0 25.6075439048 256.949297839 16544 1 0.577171762731 -1.0 -1 NSA sdss 4 1.23765536874e+18 NSA
1237657607497515484 123.649897556 36.4343553979 3 GALAXY 35219000397912 0 0 0 268435456 0 17.6626 16.9239 16.5202 16.3665 16.3185 0.0455763 0.00937477 0.0104596 0.0156836 0.0379105 0.0445142 0.0108243 0.0107398 0.0126143 0.0407962 0.285853 0.210328 0.152547 0.115672 0.0820128 18.2104 17.504 17.1596 17.0493 16.9558 11.4262 12.2075 12.9355 12.6973 12.6384 2.739 1.25131 1.29702 0.645978 1.49627 21.6314 4.00815 21.3209 0.987101 23.818 1.0741 26.588 1.4568 26.4563 4.66992 0.349964 0.381352 0.423702 0.428574 0.459274 18.058 0.0447614 17.6139 0.0112459 17.1619 0.0112734 17.0445 0.013078 16.9674 0.0413383 21.0901 0.0906867 20.4688 0.031174 20.341 0.0556895 20.3394 0.16922 20.2464 0.242179 21.1363 0.0807739 20.3599 0.0263112 19.9941 0.0461221 19.9514 0.142904 19.8772 0.230886 0.69824 0.175011 0.159932 0.0717808 0.0241759 0.39012 0.0510213 0.274547 0.0114167 0.242638 0.00287352 0.244007 -0.00444624 0.139981 -0.0289948 0.362422 7.09198 128.95 0.415298 7.29842 123.724 0.456505 7.37626 122.734 0.464873 7.66787 122.621 0.530588 7.15116 125.609 20.7296 0.0569446 17.3121 0.0107398 5.53535 12.4334 17.3092 23.6467102942 23.020403753 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00821139 8.11993e-06 0 0.015452 0.006704 -1.0 -1.0 -1.0 -1.0 123.241 36.2546 37.7379 2469.7 -23.4768886466 33446 0 StarTrek 22.5115852828 247.119389352 33448 1 0.673408280977 -1.0 -1 NSA sdss 4 1.2376576075e+18 NSA
1237657607497318756 123.243173206 36.198359966 3 GALAXY 35221147877464 0 0 0 268435456 0 17.0102 15.9737 15.5962 15.3805 15.2124 0.0149297 0.00303814 0.00303846 0.00452418 0.00876429 0.0168938 0.00411193 0.0041772 0.00657538 0.0201789 0.359776 0.26472 0.191997 0.145585 0.103222 16.7781 15.8109 15.4825 15.3434 15.283 11.9335 12.3445 12.5388 12.3528 11.26 0.747773 0.509558 0.506007 0.457721 0.504848 22.3252 1.59252 19.8711 0.266748 22.5553 0.383635 19.2597 0.362845 19.9295 1.21126 0.356391 0.449938 0.455954 0.499809 0.448981 17.2644 0.0167353 16.1089 0.00410651 15.6745 0.0041772 15.4842 0.00656445 15.403 0.0201486 20.2841 0.0501853 19.2806 0.0174014 19.0122 0.0335117 19.2813 0.0261314 18.9874 0.0393772 19.9874 0.0368224 18.988 0.00837371 18.669 0.00870647 18.4646 0.0103734 18.315 0.0273005 0.0 0.0 0.0 0.0 0.0 -0.099913 -0.127407 -0.090796 -0.116202 -0.0781184 -0.0959727 -0.0678528 -0.0927406 -0.0646098 -0.0855914 0.352588 7.3933 76.4076 0.426767 7.66431 80.3409 0.432268 8.11663 79.4671 0.482528 7.8065 80.363 0.449453 7.71702 81.7983 19.5017 0.0126292 15.6745 0.0041772 5.88205 13.523 15.6621 22.2168339858 21.5052126839 15.604 9999.0 15.026 9999.0 15.257 0.168 0.00830376 6.30124e-06 0 0.013712 0.007986 -1.0 -1.0 -1.0 -1.0 123.241 36.2546 37.7379 2469.7 -23.4768886466 33446 0 StarTrek 3.38005468389 37.1045785534 33445 1 0.638412701658 -1.0 -1 NSA sdss 4 1.2376576075e+18 NSA
1237661388673450210 193.611593257 58.3970837387 3 GALAXY 217768264008 1 0 0 268435456 0 19.0165 17.8991 17.4474 17.1968 17.3519 0.125698 0.0125096 0.0123071 0.0133375 0.0597954 0.0781058 0.0144837 0.015272 0.0245902 0.0564163 0.0445614 0.0327879 0.0237805 0.018032 0.0127849 19.1158 18.0326 17.5692 17.368 17.2749 43.7759 12.9252 12.6081 12.0432 14.7965 -1000.0 0.867226 0.894883 0.710297 2.39718 27.5096 8.81971 15.3503 0.765435 16.1178 0.894346 13.7993 1.28733 15.4664 3.32466 0.80045 0.862427 0.930354 0.918557 0.881083 18.1665 0.0802095 17.9101 0.0152661 17.4625 0.0160358 17.3553 0.0246672 17.0616 0.0654432 21.6386 0.137302 20.8402 0.034864 20.6519 0.0387687 20.3953 0.0395743 20.2173 0.102979 21.7141 0.145999 20.6685 0.026083 20.2769 0.0264594 20.0875 0.0319293 19.8535 0.0890657 0.650902 0.213638 0.133797 0.0115946 0.237941 -0.0774613 0.0269212 -0.0256153 0.0123646 0.00247932 0.00128537 -0.0357358 0.0234121 -0.0212871 -0.00672982 0.775427 6.89491 50.148 0.884519 4.87536 124.223 0.94284 4.98933 144.898 0.943253 5.1785 115.38 0.855053 5.43731 136.224 21.1021 0.0379066 17.593 0.015272 5.69971 15.7413 17.458 23.0786662103 23.2326844549 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00878943 5.71257e-05 0 0.035333 0.019721 -1.0 -1.0 -1.0 -1.0 193.841 58.3442 38.4771 2490.64 -23.8790116602 52773 0 7.87601091324 88.1524482774 142501 1 0.127083973093 -1.0 -1 NSA ned 4 1.23766138867e+18 NSA
1237658310795591687 193.681402422 58.776488573 3 GALAXY 1161189774200848 1 0 0 268435456 0 15.3383 14.2577 13.7301 13.4802 13.2264 0.00531298 0.00117809 0.00105314 0.00223073 0.00249419 0.00584177 0.00239732 0.00218882 0.00224412 0.00359698 0.0465629 0.0342605 0.0248486 0.0188419 0.0133592 15.4861 14.4788 13.8948 13.6118 13.3422 25.8569 25.3554 24.8091 24.6588 21.8471 3.71087 3.85666 4.25528 4.24202 3.50113 29.6733 0.244515 29.6642 0.361917 29.6647 0.260606 29.6731 0.133411 29.6802 0.250315 0.267166 0.250133 0.251118 0.257865 0.250512 15.496 0.00578574 14.5116 0.00239559 13.9149 0.00219917 13.6139 0.00225647 13.3246 0.00360768 19.1159 0.030984 17.9277 0.0179099 17.2595 0.0179012 16.9059 0.0112818 16.7865 0.0212477 19.3374 0.0211653 18.1142 0.00502271 17.4513 0.00383558 17.0964 0.00394633 16.7622 0.00779663 0.0 0.0 0.0625958 0.107085 0.0898007 -0.0961777 0.0627406 -0.0977185 0.0728041 -0.0947371 0.0750529 -0.0961925 0.0741838 -0.0857836 0.0845554 0.199966 16.1698 59.4915 0.195793 15.8797 61.5641 0.196769 15.8786 61.7066 0.194595 15.8804 61.2845 0.190627 15.9473 60.0688 18.2233 0.00543039 13.9197 0.00218882 11.1515 25.7678 13.7505 21.9192052147 20.9825751698 13.895 9999.0 13.722 0.134 12.607 9999.0 0.00838915 1.26961e-05 0 0.019423 0.006037 -1.0 -1.0 -1.0 -1.0 193.841 58.3442 38.4771 2490.64 -23.8790116602 52773 0 26.4092178949 295.583180188 142510 1 0.72734780837 -1.0 -1 NSA ned 4 1.2376583108e+18 NSA
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1237651821636550953 217.970758535 3.38004139202 3 GALAXY 123216437837840 1 0 0 268435456 0 18.6396 17.9913 17.663 17.4976 17.3524 0.133013 0.0134416 0.0393519 0.0226675 0.0663362 0.0619141 0.0151717 0.0163819 0.0215855 0.0755113 0.146831 0.108037 0.0783574 0.059416 0.0421267 18.7764 18.1722 17.801 17.6793 17.528 6.04882 8.6966 9.17358 9.58891 9.51645 0.475891 0.38305 0.346888 0.48912 1.31787 5.49805 1.55859 9.53792 0.755014 14.2307 1.02356 17.6061 1.72959 25.825 8.26012 0.556563 0.585685 0.550767 0.531034 0.375834 18.9431 0.057845 18.2216 0.0154508 17.6834 0.0170771 17.6405 0.0215901 17.4578 0.0860119 20.4834 0.0684414 20.223 0.0283766 20.1966 0.0310576 20.4476 0.0481403 20.1387 0.153868 20.7358 0.0717247 20.3107 0.0233528 20.107 0.0255048 20.1125 0.0400106 19.9514 0.136959 1.0 0.392932 0.259175 0.00457115 0.0 -0.117176 0.0192165 -0.0998446 -0.0459651 -0.0754748 -0.0538675 -0.10194 -0.0432527 -0.166162 -0.193757 0.648258 2.83592 115.896 0.629306 4.04114 118.181 0.595013 5.08608 120.397 0.589151 5.59748 121.94 0.431827 6.60348 122.035 20.8215 0.0318789 17.8793 0.0163819 4.46079 9.26586 17.8716 23.4066936153 23.1141130448 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00510138 5.85959e-06 0 0.064351 0.033994 -1.0 -1.0 -1.0 -1.0 217.418 3.23331 24.9139 1622.0 -23.7412085847 165082 0 34.2616031493 248.295200582 18026 1 0.789587186574 -1.0 -1 NSA sdss 4 1.23765182164e+18 NSA
1237651822173290812 217.700609655 3.79639167904 3 GALAXY 316730517885200 0 0 0 268435456 281474976710656 18.4127 17.5311 17.2207 17.0974 16.8151 0.0535548 0.0157259 0.0121553 0.0173116 0.0525928 0.469609 0.370279 0.636048 0.815461 0.978744 0.148716 0.109424 0.0793635 0.060179 0.0426676 22.7462 23.2934 24.001 24.3016 22.7842 1.08091 2.96978 2.97022 2.97025 2.97142 0.931006 -1000.0 -1000.0 -1000.0 -1000.0 0.00113295 29.7514 0.222337 7.861 0.261056 12.3031 0.00212994 0.0 0.0396189 0.0008073 0.106466 0.079085 0.0739216 0.0674949 0.05 22.8949 2.47232 23.346 0.593975 24.0166 1.72075 24.3618 1.0157 22.8269 245.208 22.855 0.595919 23.3995 0.396004 24.079 0.788068 24.3616 1.24615 22.8272 1.45009 21.3743 0.167337 20.5807 0.040347 20.3668 0.0481667 20.3146 0.0760592 20.2524 0.228507 1.0 0.0 0.0 1.0 0.0 -0.143212 0.0866458 0.0146165 -0.0919682 -0.0608859 0.0878284 -2.41229 -0.0345478 -2.41202 -0.0318182 0.05 0.00471635 44.2274 0.05 0.331645 18.8638 0.210152 0.328007 87.1251 0.0593754 0.00264176 141.409 0.05 0.0396189 122.087 21.2223 0.0708182 24.0166 1.72075 0.672841 1.19184 24.0313 23.5914552359 25.1662857829 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00559654 -1.0 0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 217.418 3.23331 24.9139 1622.0 -23.7412085847 165082 0 37.8161337013 274.05403465 18046 1 -1.0 -1.0 -1 NSA sdss 4 1.23765182217e+18 NSA
1237651822173093898 217.232775133 3.85156150737 3 GALAXY 105656463917400 0 0 0 268435456 0 18.6651 17.4272 16.8034 16.5024 16.464 0.0782342 0.0109217 0.00994039 0.0127686 0.0452137 0.122116 0.0122805 0.0121535 0.0128821 0.0552232 0.149515 0.110012 0.0797898 0.0605022 0.0428968 19.5432 17.8402 17.2153 16.953 16.8987 4.97517 9.80098 18.024 8.96857 8.69176 4.82861 0.332498 -1000.0 0.414124 0.605058 12.2367 9.77026 16.3078 0.837338 18.683 1.14024 19.1287 0.951763 12.3262 2.65169 0.327982 0.599962 0.550037 0.527907 0.666195 20.0377 0.156054 17.9119 0.0122736 17.2951 0.0121535 17.058 0.0128721 17.0183 0.0637259 21.9394 0.195021 20.3982 0.0534879 20.132 0.0394532 19.959 0.0390162 19.5576 0.10112 21.9089 0.199033 20.4538 0.0502459 19.8211 0.030723 19.5256 0.0306669 19.3719 0.0898793 0.0 0.0 0.0 0.0 0.0 -0.227942 0.286034 -0.132269 0.0432754 -0.130055 0.0590146 -0.155186 0.0617361 -0.103724 0.0499351 0.415619 4.249 68.1177 0.628741 5.53508 68.4436 0.598098 5.45949 67.8256 0.575125 5.32734 66.4188 0.644272 4.78124 71.1975 20.6077 0.0424641 17.2951 0.0121535 4.15165 8.71886 17.3858 22.9762985582 22.4723895485 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00559871 9.61518e-05 0 0.044152 0.030196 -1.0 -1.0 -1.0 -1.0 217.418 3.23331 24.9139 1622.0 -23.7412085847 165082 0 38.7192545903 280.598690475 18057 1 0.312917851718 -1.0 -1 NSA sdss 4 1.23765182217e+18 NSA
1237655369832267945 217.94533575 58.0087096127 3 GALAXY 193617394274392 0 0 0 268435456 0 16.9431 15.8456 15.3844 15.1581 15.007 0.029921 0.00384011 0.0037566 0.0175066 0.0171543 0.0222966 0.00448064 0.00444744 0.00579007 0.0181076 0.0545957 0.040171 0.0291354 0.0220925 0.0156638 17.4537 16.2423 15.7784 15.56 15.4076 17.6822 16.4561 17.0361 17.4601 14.5501 4.23944 0.712906 0.87078 0.709129 0.681601 29.6653 3.37899 29.6624 0.649263 29.6634 0.662435 29.6704 0.816306 29.6697 1.34272 0.417996 0.458523 0.502005 0.522656 0.455553 17.4405 0.0233947 16.2283 0.00460892 15.7429 0.00457053 15.5172 0.00590213 15.4561 0.0180968 20.4419 0.0519092 19.525 0.0237949 19.076 0.0189971 19.0009 0.0243701 18.7541 0.0539807 20.6442 0.0530855 19.5373 0.0111511 19.1165 0.0106199 18.9296 0.0145816 18.7006 0.0445885 0.178629 0.0841764 0.0762156 0.0500963 0.0 0.218122 -0.0402224 0.192776 -0.040409 0.182827 -0.0356188 0.170378 -0.0315868 0.209678 -0.0367132 0.439044 9.2111 192.164 0.490161 9.63764 193.227 0.519688 9.58259 193.389 0.525929 9.80462 192.961 0.494661 9.47722 191.421 19.9402 0.0153148 15.8075 0.00444744 7.66509 18.4114 15.7927 22.7103600833 22.2107608668 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00611507 1.2363e-05 0 0.024297 0.008166 -1.0 -1.0 -1.0 -1.0 218.023 57.9215 31.0085 1898.39 -24.1804037913 165153 0 5.7799144977 52.1348447726 28287 1 0.639401594006 -1.0 -1 NSA sdss 4 1.23765536983e+18 NSA
1237661416603975998 219.422236629 51.4573597124 3 GALAXY 1161118907240792 0 0 0 268435456 0 18.2185 17.362 17.0581 16.7373 17.1395 0.0661197 0.00922372 0.0257468 0.0157318 0.0737486 0.0516653 0.0119501 0.0119401 0.0204845 0.0658386 0.0593883 0.0436974 0.031693 0.0240318 0.0170389 18.3433 17.3623 17.091 16.9813 17.0313 27.9202 14.7743 14.0185 13.9105 12.3449 -1000.0 0.745001 0.918336 0.632386 7.03076 24.8521 5.1198 29.67 0.605304 29.6674 2.17118 29.67 2.56336 29.6737 3.71673 0.450017 0.452521 0.426134 0.463031 0.359644 18.1542 0.053245 17.3674 0.0119238 17.1227 0.0119401 16.9983 0.0204721 17.1926 0.06549 20.9214 0.0782221 21.0013 0.0348452 20.7192 0.0374862 20.6595 0.0554374 20.2197 0.134008 21.8376 0.158515 20.8963 0.0297843 20.5136 0.0314866 20.3904 0.047907 20.2204 0.125176 0.470677 0.0 0.0 0.0 0.0 -0.0444235 -0.110984 -0.0699825 -0.0814082 -0.0870474 -0.0760725 -0.0804063 -0.0724967 -0.133558 -0.0743927 0.5 8.29469 163.296 0.466608 10.2322 153.782 0.42386 10.2323 152.151 0.462533 9.80962 152.216 0.400112 8.99078 156.244 21.2922 0.0412377 17.1227 0.0119401 6.23428 12.3422 17.2643 24.1680487226 23.2337182696 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00692239 1.48419e-05 0 0.02227 0.012131 -1.0 -1.0 -1.0 -1.0 219.378 51.5619 33.578 2184.17 -23.1992741239 165316 0 6.4864122566 63.3556326403 53405 1 0.627598847146 -1.0 -1 NSA sdss 4 1.2376614166e+18 NSA
1237661416603910425 219.190054522 51.4603182194 3 GALAXY 35219000397912 0 0 0 268435456 0 16.4842 15.5695 15.2115 14.9816 14.9091 0.0190174 0.00338852 0.00335294 0.00866088 0.0129808 0.0148548 0.00353067 0.00427982 0.00567 0.0149917 0.0553454 0.0407226 0.0295354 0.0223958 0.0158789 16.7142 15.7719 15.4235 15.251 15.1261 16.5922 18.5848 19.2419 18.0837 19.0548 0.916015 0.462223 0.502823 0.209168 0.854855 25.769 1.47312 23.826 0.268994 26.416 0.408838 26.142 0.537933 29.6733 1.42819 0.449978 0.665655 0.71787 0.756545 0.734676 16.7927 0.0152026 15.7356 0.00364359 15.371 0.00442707 15.2208 0.00581058 15.0899 0.0153633 19.7721 0.0389595 19.0812 0.0239487 19.1432 0.0227528 19.0734 0.0292546 18.8506 0.046295 19.9108 0.0349197 19.083 0.00912351 18.8289 0.0120859 18.6706 0.0160515 18.582 0.0364531 0.167559 0.156484 0.0986585 0.0613139 0.0443098 -0.210879 -0.0417524 -0.139909 -0.0235069 -0.125238 -0.0173254 -0.0948538 -0.0144265 -0.10114 -0.00980445 0.466432 8.71964 120.442 0.625541 8.91088 117.323 0.683852 8.97287 116.9 0.737528 8.69893 114.876 0.699494 8.93505 113.981 19.6664 0.0175806 15.4531 0.00427982 8.22979 18.8973 15.3909 22.2131847581 21.963247753 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.0078426 7.41597e-06 0 0.02144 0.007168 -1.0 -1.0 -1.0 -1.0 219.378 51.5619 33.578 2184.17 -23.1992741239 165316 0 9.29735359929 90.8112724418 53422 1 0.682822370786 -1.0 -1 NSA sdss 4 1.2376614166e+18 NSA
1237661386533175309 219.969004509 51.4346141811 3 GALAXY 105622104309848 0 0 0 268435456 0 17.6419 16.594 16.2219 16.0006 15.909 0.0228516 0.00394549 0.00406594 0.0180674 0.0119827 0.0211033 0.00500522 0.0072348 0.00632027 0.0173404 0.0735295 0.0541023 0.0392395 0.0297541 0.0210961 17.669 16.6136 16.2818 16.0895 15.9703 8.47011 10.1434 8.69926 9.67301 9.10431 1.56911 5.80283 5.02639 5.40042 5.09581 15.7486 1.23233 16.5922 0.314533 14.0542 0.385947 15.8604 0.326024 16.2323 1.05794 0.256759 0.275968 0.301889 0.326158 0.327402 17.7349 0.0210929 16.5806 0.00503907 16.3207 0.00723598 16.0561 0.00642962 15.9897 0.0177835 20.2261 0.0913924 19.1338 0.227704 19.0215 0.593719 18.9178 0.61427 18.7016 0.553493 20.0529 0.0877576 19.0176 0.220008 18.6161 0.470989 18.4084 0.458573 18.2925 0.467328 0.0 0.0390057 0.000765389 0.0704905 0.0 -0.357335 -0.0154293 -0.369466 -0.0413106 -0.37124 -0.04472 -0.329478 -0.0360798 -0.315916 -0.0366128 0.300004 6.27787 124.017 0.302423 6.74232 123.586 0.33638 5.89532 124.819 0.356755 5.92325 124.286 0.353088 5.81414 125.127 19.4026 0.635796 16.321 0.00723479 4.0559 10.6539 16.3277 22.169008274 21.3636059276 16.501 0.164 15.17 9999.0 14.827 9999.0 0.00733604 9.07693e-06 0 0.029898 0.007703 -1.0 -1.0 -1.0 -1.0 219.378 51.5619 33.578 2184.17 -23.1992741239 165316 0 23.3590314058 228.15628179 53402 1 0.566610702571 -1.0 -1 NSA sdss 4 1.23766138653e+18 NSA
1237661385996304558 219.746469375 51.1207294493 3 GALAXY 1161118907240464 1 0 0 268435456 0 16.2739 14.9401 14.1672 13.7726 13.4781 0.0158723 0.00386341 0.00150707 0.00144601 0.00392446 0.01229 0.00299554 0.0025278 0.00250468 0.0043339 0.0918041 0.0675486 0.0489919 0.037149 0.0263391 16.3013 14.93 14.2152 13.8339 13.5704 32.5007 28.6351 27.3927 27.5291 23.6354 10.7959 6.69078 6.78224 6.6706 5.61223 29.6707 1.32139 29.6668 0.689916 29.6683 0.390709 29.6704 0.344739 29.6757 0.327495 0.310805 0.272998 0.290023 0.292361 0.221219 16.2047 0.0122126 14.9456 0.00301529 14.2451 0.00255124 13.8566 0.00252822 13.6261 0.00438636 20.2391 0.0426739 18.6957 0.0204522 18.1611 0.0121724 17.7114 0.0190451 17.2968 0.0222477 20.0652 0.0341115 18.5716 0.00643389 17.7882 0.00489462 17.3732 0.00458956 17.0529 0.00949204 0.0330692 0.128521 0.188184 0.232002 0.205618 -0.247824 0.049361 -0.23869 0.0549395 -0.245208 0.0599471 -0.23527 0.0582414 -0.245678 0.0603007 0.16326 23.2964 88.297 0.175382 19.5681 88.4036 0.179135 18.2818 88.4124 0.179559 17.8477 88.4096 0.173328 16.8425 88.3188 18.5611 0.00687529 14.2642 0.0025278 11.6022 30.1789 14.2464 22.5696929853 21.5645481146 15.001 0.093 13.393 9999.0 13.186 9999.0 0.00734741 1.90168e-05 0 0.031587 0.010282 -1.0 -1.0 -1.0 -1.0 219.378 51.5619 33.578 2184.17 -23.1992741239 165316 0 29.8588089669 291.640585681 53401 1 0.664789585763 -1.0 -1 NSA sdss 4 1.237661386e+18 NSA
1237654399164219640 222.900268358 58.9548243013 3 GALAXY 246359626223888 1 0 0 268435456 0 16.2135 15.1842 14.7287 14.4799 14.4513 0.0154728 0.00279794 0.00767134 0.00670861 0.0144831 0.210223 0.0882673 0.121128 0.342634 0.959964 0.0548832 0.0403825 0.0292888 0.0222088 0.0157463 21.9276 21.6504 21.613 22.3322 22.6891 1.83095 1.75025 1.74511 1.68808 2.96916 1.66173 0.24476 0.248078 1.5542 -1000.0 0.337506 2.09944 0.401679 0.583806 0.431972 0.961352 0.705991 3.33649 0.134463 73.1454 0.05 0.0764256 0.0824584 0.176216 0.258864 22.001 0.520797 21.6971 0.15291 21.6421 0.189304 22.257 0.436593 22.707 0.922095 22.1033 0.293623 21.837 0.128953 21.7961 0.222059 22.5285 0.463727 22.712 5.07529 21.1163 0.107122 20.2019 0.0270996 19.7614 0.0320023 19.5866 0.0380276 19.4949 0.159366 0.0 0.0 0.0 0.0 1.0 -0.0389645 -0.174367 -0.0410459 -0.0748844 -0.0336627 -0.0888288 0.0331918 -0.108366 -15.2944 -24.5698 0.0629588 0.531296 157.596 0.060991 0.591963 160.692 0.0647532 0.605801 162.538 0.298209 0.799616 149.101 0.356118 0.0840602 140.143 20.6099 0.0466588 21.6421 0.189304 0.952501 1.6271 21.7996 22.5492279537 23.6893571698 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00735609 -1.0 0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 222.824 58.9781 33.4978 2142.61 -23.4190814263 165707 0 2.73418185588 26.6421797248 19647 1 -1.0 -1.0 -1 NSA sdss 4 1.23765439916e+18 NSA
1237665565541728490 234.132926177 16.4404552908 3 GALAXY 105589892059224 0 0 0 268435456 0 16.1647 14.9855 14.4259 14.1387 13.9433 0.0158673 0.00259635 0.00209654 0.00186889 0.00660086 0.0225006 0.00533662 0.00365586 0.00515775 0.0165636 0.265727 0.19552 0.141807 0.107528 0.0762387 16.1973 14.9169 14.3988 14.165 14.0913 22.802 26.5905 26.6271 25.7355 24.102 0.922541 0.993555 1.08189 0.981544 0.73939 29.6735 1.06105 29.6712 0.344343 29.6666 0.649634 29.6739 0.269091 29.6667 2.45438 0.72939 0.628225 0.726929 0.617838 0.544187 16.5156 0.0224544 15.1144 0.00533579 14.5406 0.00365586 14.299 0.00515002 14.221 0.0163856 21.2198 0.0895723 20.184 0.0213354 19.6587 0.023881 19.3987 0.022902 19.0766 0.0414875 20.9411 0.0918039 19.6351 0.0120631 19.0204 0.0106331 18.7119 0.0116012 18.519 0.0291054 0.0 0.0 0.0 0.0 0.0 0.277716 -0.0105282 0.241218 -0.00404015 0.237909 -0.0061111 0.233472 -0.00943407 0.257519 -0.00772755 0.449939 17.3926 188.744 0.449997 18.5222 186.685 0.461628 18.3583 186.446 0.46783 17.2205 186.139 0.449999 16.2165 187.286 19.8695 0.0154952 14.5406 0.00365586 12.4745 25.4727 14.6318 22.8552192249 22.1073501623 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.0063225 2.50655e-05 0 0.017646 0.008486 -1.0 -1.0 -1.0 -1.0 234.132 16.6078 28.0204 1967.37 -23.7233716534 166313 0 Gilgamesh 10.0451514042 81.8759433532 166312 1 0.754674971471 -1.0 -1 NSA sdss 4 1.23766556554e+18 NSA



In [7]:

    
sagamasks = ~((t['TELNAME']=='SDSS')|(t['TELNAME']=='NSA')|(t['TELNAME']=='GAMA'))
sagaids = np.array(np.unique(t['HOST_NSAID'][sagamasks]))
sagaspectra = t[np.in1d(t['HOST_NSAID'], sagaids)]



In [8]:

    
complete_hosts = [147100,166313,165536,61945,149781,33446,150887,132339,85746,140594,161174,13927,137625,129237,145729]
incompletes = sagaids[~np.in1d(sagaids, complete_hosts)]
complete_hosts_spectra = t[np.in1d(t['HOST_NSAID'], complete_hosts)]

incompletes









    Out[8]:





array([ 63326, 150307, 153017])



In [9]:

    
sats = sagaspectra[sagaspectra['SATS']==1]
sats['COMPLETE_HOST'] = np.in1d(sats['HOST_NSAID'], complete_hosts)
sats.show_in_notebook()









    Out[9]:




<Table masked=True length=49>

idx OBJID RA DEC PHOTPTYPE PHOT_SG FLAGS clean SATURATED BAD_COUNTS_ERROR BINNED1 TOO_FEW_GOOD_DETECTIONS u g r i z u_err g_err r_err i_err z_err MODELMAGERR_U MODELMAGERR_G MODELMAGERR_R MODELMAGERR_I MODELMAGERR_Z EXTINCTION_U EXTINCTION_G EXTINCTION_R EXTINCTION_I EXTINCTION_Z DERED_U DERED_G DERED_R DERED_I DERED_Z PETRORAD_U PETRORAD_G PETRORAD_R PETRORAD_I PETRORAD_Z PETRORADERR_U PETRORADERR_G PETRORADERR_R PETRORADERR_I PETRORADERR_Z DEVRAD_U DEVRADERR_U DEVRAD_G DEVRADERR_G DEVRAD_R DEVRADERR_R DEVRAD_I DEVRADERR_I DEVRAD_Z DEVRADERR_Z DEVAB_U DEVAB_G DEVAB_R DEVAB_I DEVAB_Z CMODELMAG_U CMODELMAGERR_U CMODELMAG_G CMODELMAGERR_G CMODELMAG_R CMODELMAGERR_R CMODELMAG_I CMODELMAGERR_I CMODELMAG_Z CMODELMAGERR_Z PSFMAG_U PSFMAGERR_U PSFMAG_G PSFMAGERR_G PSFMAG_R PSFMAGERR_R PSFMAG_I PSFMAGERR_I PSFMAG_Z PSFMAGERR_Z FIBERMAG_U FIBERMAGERR_U FIBERMAG_G FIBERMAGERR_G FIBERMAG_R FIBERMAGERR_R FIBERMAG_I FIBERMAGERR_I FIBERMAG_Z FIBERMAGERR_Z FRACDEV_U FRACDEV_G FRACDEV_R FRACDEV_I FRACDEV_Z Q_U U_U Q_G U_G Q_R U_R Q_I U_I Q_Z U_Z EXPAB_U EXPRAD_U EXPPHI_U EXPAB_G EXPRAD_G EXPPHI_G EXPAB_R EXPRAD_R EXPPHI_R EXPAB_I EXPRAD_I EXPPHI_I EXPAB_Z EXPRAD_Z EXPPHI_Z FIBER2MAG_R FIBER2MAGERR_R EXPMAG_R EXPMAGERR_R PETROR50_R PETROR90_R PETROMAG_R SB_EXP_R SB_PETRO_R J JERR H HERR K KERR SPEC_Z SPEC_Z_ERR SPEC_Z_WARN PHOTOZ PHOTOZ_ERR W1 W1ERR W2 W2ERR HOST_RA HOST_DEC HOST_DIST HOST_VHOST HOST_MK HOST_NSAID HOST_FLAG HOST_SAGA_NAME RHOST_ARCM RHOST_KPC OBJ_NSAID SATS PROBABILITY_CLASS1 RESCALED_PROBABILITY_CLASS1 REMOVE TELNAME MASKNAME ZQUALITY SPEC_CLASS SPECOBJID SPEC_REPEAT COMPLETE_HOST
0 1237651735757259099 180.636494306 1.95802947978 3 GALAXY 281543964623104 0 0 0 268435456 281474976710656 26.9357 19.2637 18.6728 18.9803 26.7732 3.48973 0.0899796 0.0839212 0.173803 0.658678 3.48973 0.0899796 0.0839212 0.173803 0.658678 0.115032 0.0846394 0.0613876 0.0465483 0.0330033 26.8206 19.1791 18.6114 18.9337 26.7402 2.97098 2.97006 258.374 2.96948 2.97022 -1000.0 -1000.0 -1000.0 -1000.0 -1000.0 2.12566 3.65126 29.6753 2.31745 27.1824 8.31657 29.6695 2.53441 0.00358716 27.1103 0.05 0.623367 0.999923 0.952344 0.0501283 21.8828 0.386924 19.1192 0.0916567 17.2244 0.0721443 18.0551 0.166074 22.1379 0.697607 22.5648 0.410591 22.7915 0.178714 22.782 0.271717 23.0981 0.472571 22.0059 0.635566 23.3443 0.69363 22.7732 0.188145 22.6497 0.264579 22.8432 0.479258 22.1462 0.862093 1.0 0.337854 0.301263 0.0654641 1.0 -0.191439 0.930425 -0.0791527 0.00684313 -0.136734 0.142043 0.126804 0.243481 -0.424756 -3.02252 0.05 3.41202 63.378 0.344957 17.0706 153.516 0.374638 57.5764 150.554 0.679342 24.642 146.598 0.300015 0.000382415 90.4881 23.3621 0.323969 16.9897 0.0668231 3.80096 5.55442 20.4335 27.7863323159 25.3284160846 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00696 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 180.676 1.9768 29.5168 1961.14 -23.607346363 13927 0 Sopranos 2.62303147771 22.5215797356 -1 1 0.224393357319 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2016.0316_1.zlog 4 88.0 MMT True
1 1237657607497515484 123.649897556 36.4343553979 3 GALAXY 35219000397912 0 0 0 268435456 0 17.6626 16.9239 16.5202 16.3665 16.3185 0.0455763 0.00937477 0.0104596 0.0156836 0.0379105 0.0445142 0.0108243 0.0107398 0.0126143 0.0407962 0.285853 0.210328 0.152547 0.115672 0.0820128 18.2104 17.504 17.1596 17.0493 16.9558 11.4262 12.2075 12.9355 12.6973 12.6384 2.739 1.25131 1.29702 0.645978 1.49627 21.6314 4.00815 21.3209 0.987101 23.818 1.0741 26.588 1.4568 26.4563 4.66992 0.349964 0.381352 0.423702 0.428574 0.459274 18.058 0.0447614 17.6139 0.0112459 17.1619 0.0112734 17.0445 0.013078 16.9674 0.0413383 21.0901 0.0906867 20.4688 0.031174 20.341 0.0556895 20.3394 0.16922 20.2464 0.242179 21.1363 0.0807739 20.3599 0.0263112 19.9941 0.0461221 19.9514 0.142904 19.8772 0.230886 0.69824 0.175011 0.159932 0.0717808 0.0241759 0.39012 0.0510213 0.274547 0.0114167 0.242638 0.00287352 0.244007 -0.00444624 0.139981 -0.0289948 0.362422 7.09198 128.95 0.415298 7.29842 123.724 0.456505 7.37626 122.734 0.464873 7.66787 122.621 0.530588 7.15116 125.609 20.7296 0.0569446 17.3121 0.0107398 5.53535 12.4334 17.3092 23.6467102942 23.020403753 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00821139 8.11993e-06 0 0.015452 0.006704 -1.0 -1.0 -1.0 -1.0 123.241 36.2546 37.7379 2469.7 -23.4768886466 33446 0 StarTrek 22.5115852828 247.119389352 33448 1 0.673408280977 -1.0 -1 NSA sdss 4 1.2376576075e+18 NSA True
2 1237657607497318756 123.243173206 36.198359966 3 GALAXY 35221147877464 0 0 0 268435456 0 17.0102 15.9737 15.5962 15.3805 15.2124 0.0149297 0.00303814 0.00303846 0.00452418 0.00876429 0.0168938 0.00411193 0.0041772 0.00657538 0.0201789 0.359776 0.26472 0.191997 0.145585 0.103222 16.7781 15.8109 15.4825 15.3434 15.283 11.9335 12.3445 12.5388 12.3528 11.26 0.747773 0.509558 0.506007 0.457721 0.504848 22.3252 1.59252 19.8711 0.266748 22.5553 0.383635 19.2597 0.362845 19.9295 1.21126 0.356391 0.449938 0.455954 0.499809 0.448981 17.2644 0.0167353 16.1089 0.00410651 15.6745 0.0041772 15.4842 0.00656445 15.403 0.0201486 20.2841 0.0501853 19.2806 0.0174014 19.0122 0.0335117 19.2813 0.0261314 18.9874 0.0393772 19.9874 0.0368224 18.988 0.00837371 18.669 0.00870647 18.4646 0.0103734 18.315 0.0273005 0.0 0.0 0.0 0.0 0.0 -0.099913 -0.127407 -0.090796 -0.116202 -0.0781184 -0.0959727 -0.0678528 -0.0927406 -0.0646098 -0.0855914 0.352588 7.3933 76.4076 0.426767 7.66431 80.3409 0.432268 8.11663 79.4671 0.482528 7.8065 80.363 0.449453 7.71702 81.7983 19.5017 0.0126292 15.6745 0.0041772 5.88205 13.523 15.6621 22.2168339858 21.5052126839 15.604 9999.0 15.026 9999.0 15.257 0.168 0.00830376 6.30124e-06 0 0.013712 0.007986 -1.0 -1.0 -1.0 -1.0 123.241 36.2546 37.7379 2469.7 -23.4768886466 33446 0 StarTrek 3.38005468389 37.1045785534 33445 1 0.638412701658 -1.0 -1 NSA sdss 4 1.2376576075e+18 NSA True
3 1237666408439939282 354.350599991 0.390802769345 3 GALAXY 105622137868560 1 0 0 268435456 0 15.1358 14.2132 13.7674 13.5022 13.3059 0.0148853 0.00366039 0.00139232 0.00184906 0.00720118 0.637764 0.256827 0.23078 0.204547 0.663073 0.198159 0.145803 0.105749 0.080186 0.0568529 25.5859 23.2043 22.6819 22.2968 22.77 2.96947 1.10608 1.01528 1.09387 2.96944 -1000.0 0.920549 0.2037 0.263809 -1000.0 1.46939e-05 0.736064 0.00227931 5.28588 0.140282 2.08994 0.243399 1.589 9.69633e-05 0.0 0.05 0.678691 0.402311 0.445205 0.221564 25.7786 1.89505 23.4055 0.937787 22.7877 0.930622 22.2796 0.890513 22.8269 2.76739 25.8145 0.864015 23.4131 0.32647 22.8832 0.306443 22.5238 0.294845 22.827 0.978495 22.5494 1.0401 20.8082 0.0441761 20.2414 0.0427232 19.9283 0.0472968 19.8821 0.203089 0.0 1.0 0.0 0.0 1.0 0.272005 1.10971 0.0361724 0.0160089 0.0210821 -0.000634836 0.0354403 -0.00163676 -2.3935 0.0258882 0.0504574 4.94051e-07 130.675 0.704317 0.00453047 59.3902 0.533418 0.214349 140.678 0.545466 0.327764 165.426 0.0821784 4.84968e-05 63.8694 21.0891 0.0622125 22.7877 0.930622 0.553129 0.924279 22.961 21.4387517213 23.67053752 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00887051 -1.0 0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 14.3221211837 144.845303859 5541 1 -1.0 -1.0 -1 NSA sdss 4 1.23766640844e+18 NSA True
4 1237663277925204111 354.195229736 0.62342377148 3 GALAXY 193514315059288 0 0 0 268435456 0 17.2096 16.1591 15.7093 15.4802 15.3143 0.0141356 0.00253371 0.00258019 0.00344502 0.00955682 0.0332091 0.0065437 0.0117326 0.0288206 0.0260572 0.17593 0.129448 0.0938862 0.0711911 0.0504754 17.4327 16.3483 15.9147 15.7823 15.6964 19.6363 19.9971 20.4682 19.2061 17.2435 1.39175 0.348307 0.430858 9.68542 8.90673 26.8261 3.43616 29.6696 0.511033 28.0882 1.22865 23.8191 2.07604 29.6746 1.12772 0.552452 0.732989 0.736646 0.693684 0.783456 17.3208 0.0328345 16.4122 0.00662894 16.0086 0.0117326 15.8685 0.0286715 15.788 0.025914 21.1822 0.0792113 20.539 0.0914372 20.4745 0.221568 20.759 0.391027 20.0538 0.314924 20.715 0.0565932 20.1267 0.0730835 19.7495 0.172945 19.6649 0.239339 19.5539 0.220719 0.697009 0.0546467 0.0 0.0 0.0 -0.0606216 -0.0243309 -0.0678425 -0.0194522 -0.0648828 -0.0169603 -0.0680197 -0.0122782 -0.11418 -0.0100415 0.539726 9.53908 116.834 0.660911 11.3093 121.072 0.755666 10.4549 129.287 0.745519 10.1142 134.738 0.62908 10.8376 118.437 20.5387 0.238487 16.0086 0.0117326 9.4994 18.4506 16.0004 23.1006695397 22.8843792421 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.008825 5.42653e-06 0 0.016315 0.007464 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 19.9450255233 201.711422154 5538 1 0.766548234467 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2014.1123_4.zlog 4 133.0 MMT True
5 1237666408439677694 353.778805283 0.301058523211 3 GALAXY 105624251793680 1 0 0 268435456 0 23.2978 22.7803 21.3615 20.7518 20.2966 0.789328 0.19007 0.088862 0.0698596 0.198622 0.789328 0.19007 0.088862 0.0698596 0.198622 0.155789 0.114628 0.0831378 0.0630409 0.0446968 23.142 22.6657 21.2784 20.6888 20.2519 2.97023 2.96945 1.60272 27.9179 2.96194 -1000.0 -1000.0 0.207728 -1000.0 2.79432 26.5587 95.5347 1.03802 1.54675 1.06593 0.826578 0.815049 0.391987 4.26067 4.68436 0.0999967 0.05 0.575213 0.471984 0.450205 21.1634 0.497052 22.7275 0.209454 21.3615 0.11098 20.6826 0.0679602 19.2072 0.211422 24.6238 0.932713 23.2563 0.187823 22.0784 0.0988037 21.382 0.0746557 21.0034 0.218604 23.1739 0.638409 23.3019 0.199021 21.9254 0.127747 21.4125 0.115932 20.7142 0.257394 0.0 0.0 0.0 1.0 1.0 0.200722 -0.300259 0.253568 -0.0448014 0.0316865 0.0346528 0.156639 0.0524408 -0.00289464 -0.00966111 0.192363 6.59778 127.85 0.05 1.08482 178.659 0.659945 0.765609 27.9016 0.449997 0.597335 176.337 0.6 1.70905 1.71239 22.5082 0.145289 21.3615 0.11098 0.865011 1.49212 21.4707 22.7769801426 23.1512713234 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.008 -1.0 -1 0.452667 0.091632 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 21.1326207762 213.721865283 -1 1 -1.0 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2014.0925_1.zlog 3 100.0 MMT True
6 1237664338780029261 149.687168865 32.7202654623 3 GALAXY 140954719879496 1 0 0 268435456 0 23.2605 21.129 20.6923 20.5158 20.9515 1.28666 0.0963448 0.103341 0.163678 0.809637 1.28666 0.0963448 0.103341 0.163678 0.809637 0.0716136 0.0526926 0.0382171 0.0289788 0.0205464 23.1889 21.0763 20.6541 20.4868 20.931 2.97054 2.96966 2.97052 3.01507 2.97092 -1000.0 -1000.0 -1000.0 0.245671 -1000.0 0.0621855 10.5916 6.37373 2.60696 7.82645 4.80234 1.01286 1.20302 2.58529 10.6079 0.980254 0.57148 0.250008 0.271985 0.165852 23.77 0.722813 21.0994 0.0928087 20.6775 0.103741 21.0194 0.157523 20.987 0.692705 23.7512 1.57993 22.7244 0.137 22.4141 0.149041 21.4561 0.134165 22.4519 0.72529 24.1814 0.898936 22.6503 0.132222 22.283 0.154798 21.7122 0.161038 22.2792 0.701675 0.0 0.0 0.0367419 1.0 0.0 0.179925 0.222624 0.0454472 -0.0705241 0.130594 -0.0993337 0.0396096 -0.0226019 0.0878009 -0.441671 0.984256 0.0736848 24.8054 0.678882 2.65692 126.038 0.300197 3.75416 134.799 0.318421 1.01407 -12.9386 0.251038 3.06488 154.126 22.9894 0.193419 20.6923 0.103341 2.20775 4.60116 20.8596 25.56033787 24.574793298 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.004987 -1.0 -1 0.068964 0.0577 -1.0 -1.0 -1.0 -1.0 149.588 32.3699 25.1343 1451.33 -23.1023339723 85746 0 MobyDick 21.6120163628 158.010278529 -1 1 0.00183130239327 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.0218_2.zlog 3 234.0 MMT True
7 1237678602387521791 20.5363426909 17.5281428748 3 GALAXY 105658611401048 0 0 0 268435456 0 20.9781 19.6612 19.2133 19.2418 18.8889 0.205292 0.0290554 0.0314241 0.058891 0.133825 0.205292 0.0290554 0.0314241 0.058891 0.133825 0.552172 0.406283 0.29467 0.22344 0.158421 20.4259 19.2549 18.9186 19.0184 18.7305 2.97033 4.56925 5.10008 6.16897 18.0189 -1000.0 0.35361 0.347732 0.967759 -1000.0 2.91939 3.14891 6.68343 0.782368 9.02299 1.36221 11.4054 3.07672 9.89129 5.30089 0.100008 0.398488 0.372631 0.278086 0.199944 21.3856 0.213625 19.8 0.0288308 19.2133 0.0314241 19.0439 0.0603118 18.6338 0.153826 22.273 0.200717 21.5454 0.0551484 21.3352 0.058765 21.5498 0.0998875 20.7916 0.181315 22.1946 0.223801 21.2585 0.0504381 20.8936 0.052257 20.9118 0.0861796 20.6087 0.219344 0.448183 0.0 0.0 0.167467 0.536647 -0.109825 0.597835 -0.00640917 0.32018 0.040621 0.162352 0.0164351 0.191044 0.019472 0.646098 0.05 1.9387 51.8061 0.417173 2.87575 46.9578 0.468869 3.32237 46.8222 0.350004 4.03994 42.1969 0.180653 4.30451 50.8232 21.6502 0.0702134 19.2133 0.0314241 2.37822 4.5701 19.3164 23.8159870457 23.1931394021 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.008651 -1.0 -1 0.104474 0.067257 -1.0 -1.0 -1.0 -1.0 20.449 17.5922 38.6531 2518.0 -23.5559216515 129237 0 HarryPotter 6.30360930448 70.8760477473 -1 1 0.351658668013 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.1217_1.zlog 4 247.0 MMT True
8 1237678602387456130 20.2852690118 17.6022357532 3 GALAXY 35253360136208 1 0 0 268435456 0 19.1794 18.0412 17.5387 17.3254 17.1087 0.0739959 0.0122204 0.0122819 0.0168908 0.0483221 0.0739959 0.0122204 0.0122819 0.0168908 0.0483221 0.521506 0.383719 0.278305 0.21103 0.149623 18.6579 17.6575 17.2604 17.1144 16.9591 9.98158 9.89871 10.9136 10.8699 9.09193 1.52826 0.288358 0.580488 0.507249 1.13348 7.09102 2.00908 12.9984 0.592921 17.227 0.918761 16.9507 1.22249 15.2237 3.62855 0.380035 0.572724 0.537567 0.554433 0.611987 19.265 0.0656454 17.8655 0.0125208 17.3232 0.0128294 17.0865 0.0174902 16.9309 0.0503608 21.208 0.0820169 20.4372 0.0246184 20.1449 0.0280381 20.0515 0.0339695 19.8492 0.0780249 21.2591 0.0996155 20.3766 0.0182657 20.0318 0.0241954 19.8474 0.0336561 19.6325 0.0934219 1.0 0.459459 0.278458 0.279666 0.366924 -0.251941 -0.00568754 -0.156324 -0.0216558 -0.173142 -0.0257438 -0.140674 -0.0249612 -0.124482 -0.0393145 0.417213 3.61481 110.704 0.607075 5.07406 107.449 0.555864 6.12076 105.383 0.577281 6.33599 108.413 0.668517 4.98891 107.822 20.7201 0.0310453 17.5387 0.0122819 5.04294 11.1888 17.5217 23.4682172468 23.0305868938 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00822 -1.0 -1 0.021761 0.007784 -1.0 -1.0 -1.0 -1.0 20.449 17.5922 38.6531 2518.0 -23.5559216515 129237 0 HarryPotter 9.38349488064 105.50536144 -1 1 0.579303160766 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.1217_1.zlog 4 84.0 MMT True
9 1237678602387456305 20.3284666123 17.7539390491 3 GALAXY 176027389263960 0 0 0 268435456 0 20.8783 20.3294 19.8126 21.6045 20.9719 0.196505 0.0522925 0.0545213 0.472273 0.917232 0.196505 0.0522925 0.0545213 0.472273 0.917232 0.441747 0.325033 0.235741 0.178755 0.12674 20.4366 20.0044 19.5768 21.4258 20.8451 4.11348 4.82534 4.25263 1.63333 1.08374 3.94425 0.258036 0.254638 1.52617 1.01367 29.0475 24.8957 12.3212 2.8459 9.87288 3.12201 1.22935 3.63071 1.36943 5.27649 0.208951 0.741644 0.649993 0.05 0.05 19.4038 0.169706 19.9417 0.0554374 19.6916 0.0570896 22.1809 0.49077 21.5792 0.654745 22.3368 0.195846 22.3307 0.0950491 21.8199 0.095881 22.878 0.414276 22.2292 0.762285 22.338 0.243113 21.8962 0.0772601 21.3842 0.0775077 21.4871 0.176949 21.248 0.665927 1.0 0.179362 0.116482 1.0 0.0378206 -0.249118 -0.110976 -0.210569 -0.02416 -0.0942411 0.142081 0.151148 0.052522 -0.385474 -0.407533 0.360154 2.09061 86.1088 0.730185 3.45458 111.085 0.724449 2.90221 77.4793 0.181603 0.876419 21.4964 0.05 0.957772 107.282 22.1631 0.105623 19.8126 0.0545213 2.50645 6.18583 19.8871 24.1216827031 23.8778056779 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.008245 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 20.449 17.5922 38.6531 2518.0 -23.5559216515 129237 0 HarryPotter 11.9019221346 133.821743744 -1 1 0.23330211787 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.1217_1.zlog 4 123.0 MMT True
10 1237679169841725673 20.7768903825 17.8914501798 3 GALAXY 35255507620112 1 0 0 268435456 0 18.7268 17.6239 17.3036 17.1213 17.1842 0.0812353 0.0308127 0.0165309 0.0244908 0.15902 0.0812353 0.0308127 0.0165309 0.0244908 0.15902 0.433778 0.31917 0.231489 0.175531 0.124454 18.293 17.3048 17.0721 16.9457 17.0598 2.97062 13.034 12.3946 10.8766 12.5528 -1000.0 0.415204 0.607536 0.465203 7.60632 29.6811 2.39459 20.2712 1.83363 27.8184 2.03367 26.6701 2.76461 20.693 13.1852 0.6269 0.535191 0.488858 0.450045 0.418031 18.527 0.0790981 17.6098 0.030637 17.3036 0.0165309 17.1462 0.0244712 17.2157 0.219865 21.5836 0.172137 21.2406 0.0406829 20.6645 0.0409956 20.4561 0.0552773 20.4826 0.156338 21.7713 0.209996 20.6788 0.0276571 20.314 0.0327567 20.1452 0.0442682 19.9013 0.113796 0.0 0.0 0.0 0.0 0.0 -0.155095 -0.0477329 -0.154621 0.0443423 -0.164015 0.0384647 -0.18665 0.0464484 -0.104109 0.0170964 0.652729 8.21619 95.3965 0.550006 7.7727 67.1391 0.529588 7.57387 73.2208 0.498592 7.54207 75.0994 0.531737 7.08154 69.4524 21.1371 0.0467687 17.3036 0.0165309 5.6057 11.9276 17.3355 23.6956193731 23.0740855034 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.008477 -1.0 -1 0.023525 0.016051 -1.0 -1.0 -1.0 -1.0 20.449 17.5922 38.6531 2518.0 -23.5559216515 129237 0 HarryPotter 25.951574436 291.789751049 -1 1 0.382515821226 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.1217_1.zlog 4 286.0 MMT True
11 1237678881574814166 39.5361613388 -1.39669557972 3 GALAXY 68988043520 1 0 0 268435456 0 21.0221 20.2741 20.1799 19.9211 20.0539 0.252832 0.0533493 0.084259 0.108021 0.425061 0.252832 0.0533493 0.084259 0.108021 0.425061 0.152551 0.112245 0.0814098 0.0617306 0.0437677 20.8695 20.1618 20.0985 19.8593 20.0101 7.36175 4.37384 7.36056 3.72476 2.97064 -1000.0 0.354126 -1000.0 0.270393 -1000.0 15.3478 25.1734 5.86131 1.78858 9.46292 4.95093 3.52963 2.01672 29.6754 11.1489 0.175136 0.478479 0.600053 0.449987 0.312654 20.1585 0.261982 20.5076 0.0546179 20.1799 0.0940121 20.2523 0.113398 18.3538 0.424052 22.5205 0.265634 21.9889 0.0756667 21.9932 0.121236 21.5536 0.121797 22.2208 0.624404 22.5666 0.25179 21.8879 0.0739897 21.8981 0.13193 21.4461 0.141899 21.5603 0.506618 1.0 0.0 0.0 0.201239 1.0 -0.302683 -0.197594 -0.233479 -0.16147 -0.0965025 -0.198262 0.347981 -0.231285 -0.430572 -0.0371152 0.201468 3.57067 109.928 0.599986 2.24993 110.586 0.679317 2.90029 122.697 0.598259 1.7239 148.993 0.205078 4.25022 112.254 22.6176 0.168925 20.1799 0.0940122 2.40113 4.03315 20.3354 24.4875278346 24.2328882586 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00845 -1.0 -1 0.05692 0.06884 -1.0 -1.0 -1.0 -1.0 39.5482 -1.31876 37.155 2629.0 -23.5160863282 132339 0 Narnia 4.73156308336 51.138487672 -1 1 0.0091964301348 -1.0 -1 AAT /Spectra/Final/AAT/Narnia2016_1_MG.mz 3 147.0 AAT True
12 1237678881574944900 39.9254642529 -1.41874190874 3 GALAXY 35221147746392 0 0 0 268435456 0 18.4598 17.4318 17.0487 16.8524 16.7106 0.0277267 0.00580764 0.00611628 0.00771296 0.0208244 0.0277267 0.00580764 0.00611628 0.00771296 0.0208244 0.164066 0.120718 0.0875549 0.0663902 0.0470715 18.2957 17.311 16.9611 16.786 16.6636 5.94692 5.78954 5.8101 6.10412 8.13439 1.61669 0.459588 0.296069 0.309807 1.59931 6.90868 0.693817 6.49148 0.129512 7.941 0.192888 8.195 0.220718 8.648 0.698182 0.321585 0.343541 0.373177 0.396727 0.458332 18.3807 0.028239 17.3989 0.00588447 17.0029 0.00620007 16.7724 0.00781339 16.5684 0.0214998 20.0676 0.0457668 19.1308 0.0288124 18.949 0.0185238 18.7441 0.0191707 18.736 0.0395431 20.1394 0.0450851 19.0483 0.0088225 18.6946 0.0093916 18.5305 0.0120535 18.3647 0.0323954 0.287915 0.175185 0.0843779 0.0787185 0.166817 -0.00533116 0.30208 0.0217417 0.288053 0.0272412 0.261217 0.0257407 0.237115 0.0407884 0.192146 0.315749 3.46637 42.0592 0.375191 3.34285 41.625 0.406981 3.46684 41.023 0.413525 3.57124 40.173 0.467324 3.33899 39.6647 19.4311 0.0127096 17.0487 0.00611628 2.66691 6.30181 17.029 21.7437827417 21.1544597121 17.221 0.24 16.199 0.19 15.209 9999.0 0.008789 -1.0 -1 0.02636 0.008083 -1.0 -1.0 -1.0 -1.0 39.5482 -1.31876 37.155 2629.0 -23.5160863282 132339 0 Narnia 23.4110321372 253.023341686 -1 1 0.398241051845 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.1210_1.zlog 4 212.0 MMT True
13 1237667255616274560 158.351768341 28.5529137267 3 GALAXY 35255507615832 0 0 0 268435456 0 19.1139 18.1848 17.867 17.6759 17.6822 0.0586541 0.0105148 0.0171487 0.0193226 0.139896 0.0586541 0.0105148 0.0171487 0.0193226 0.139896 0.14522 0.106851 0.0774976 0.0587641 0.0416645 18.9687 18.078 17.7895 17.6172 17.6406 6.25306 6.59615 6.40049 6.6182 6.21694 0.544808 0.182929 0.210106 0.253199 0.464102 9.78001 3.10434 9.89307 0.385626 9.89154 0.598489 11.0057 0.893645 6.37471 3.25019 0.555736 0.552741 0.581588 0.570767 0.674217 19.1034 0.0574147 18.2003 0.0105126 17.867 0.0171487 17.6634 0.0193208 17.6936 0.208499 21.2635 0.0963484 20.4797 0.0409652 20.6466 0.0321736 20.3684 0.0411536 20.0384 0.1009 21.0486 0.0817019 20.2248 0.0175588 19.9099 0.0202852 19.7182 0.0262008 19.6395 0.0761235 0.0 0.0 0.0 0.0 0.0 0.0462818 -0.0178712 0.11593 -0.123213 0.120301 -0.131137 0.118367 -0.1244 0.0533799 -0.0952571 0.676583 3.54509 167.004 0.59495 3.7439 142.185 0.603718 3.79536 139.519 0.601681 3.86778 140.161 0.645107 3.41147 125.091 20.715 0.028652 17.867 0.0171487 3.04117 6.43513 17.9022 22.7587021059 22.312876252 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.004288 -1.0 -1 0.056475 0.025313 -1.0 -1.0 -1.0 -1.0 158.231 28.5118 24.4117 1408.0 -23.020990121 137625 0 Oz 6.82727776292 48.4809842377 -1 1 0.128758183912 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2016.0304_1.zlog 4 294.0 MMT True
14 1237667255616143540 158.088519499 28.4198533568 3 GALAXY 105624251798032 1 0 0 268435456 0 18.5509 17.3116 16.814 16.6059 16.33 0.0606933 0.00772032 0.00761748 0.0112616 0.0265244 0.0519692 0.00996925 0.0149639 0.0187032 0.032791 0.121646 0.0895062 0.0649174 0.0492249 0.0349011 18.4926 17.3048 16.824 16.5556 16.3618 14.1469 12.0334 12.7143 12.7146 23.5876 5.19487 0.309294 0.45199 0.362009 3.92129 22.978 5.62197 19.9665 0.69317 20.5393 0.994847 20.1813 1.14849 29.6739 4.62715 0.550876 0.63112 0.637435 0.656595 0.612062 18.7034 0.0538862 17.4485 0.00994674 16.8889 0.0149639 16.5751 0.0186775 16.2281 0.0387167 21.7739 0.136177 20.742 0.0358616 20.6757 0.0338257 20.4803 0.0394258 19.9891 0.091638 21.3351 0.114484 20.2935 0.0196016 19.8463 0.0205189 19.627 0.0241245 19.4039 0.0646691 0.0708081 0.0 0.0 0.0 0.0246128 -0.0386052 0.120146 -0.105884 0.0649579 -0.116685 0.0549089 -0.104875 0.0399083 -0.0748609 0.0369515 0.600153 5.82937 38.0113 0.634968 6.51383 51.5738 0.639341 6.95218 55.0992 0.661143 7.19194 57.2614 0.592467 8.38887 47.2387 20.6907 0.0298874 16.8889 0.0149639 5.50607 12.2015 16.9149 23.0949720383 22.6145467756 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00541094 -1.0 0 0.048241 0.013996 -1.0 -1.0 -1.0 -1.0 158.231 28.5118 24.4117 1408.0 -23.020990121 137625 0 Oz 9.3230541028 66.2036316332 107745 1 0.207615778458 -1.0 -1 NSA sdss 4 1.23766725562e+18 NSA True
15 1237667255616143515 158.04324634 28.4830569538 3 GALAXY 35253360136208 1 0 0 268435456 0 17.013 15.778 15.2572 15.0015 14.8558 0.0170949 0.00292895 0.00271152 0.00308863 0.0093593 0.0156095 0.00308509 0.00323044 0.00362345 0.0077356 0.126724 0.093242 0.0676269 0.0512794 0.0363577 16.6775 15.4369 14.9379 14.6895 14.5585 12.0641 13.7331 13.4218 13.9722 13.3025 0.73687 0.32453 0.266555 0.288073 0.3749 8.81573 0.57779 10.6821 0.112501 12.0842 0.158565 12.8398 0.146858 13.2144 0.392262 0.711225 0.72479 0.716899 0.725108 0.734595 17.0317 0.0155178 15.7579 0.00315412 15.229 0.00331122 14.9398 0.00372913 14.804 0.00807385 19.5378 0.0317838 18.5365 0.0262702 18.3669 0.0166978 18.1754 0.017552 17.8133 0.0239326 19.4813 0.0263539 18.3441 0.00494042 17.8647 0.00441844 17.632 0.00492007 17.4651 0.0125644 1.0 0.607343 0.466677 0.451998 0.463931 -0.0926509 0.00549161 -0.0963445 0.0127015 -0.107296 0.014463 -0.106864 0.0181526 -0.0871349 0.0115481 0.734527 3.72169 67.5715 0.684105 5.43897 68.5751 0.706868 5.54839 68.2481 0.703888 5.53929 68.2431 0.739036 4.6911 70.9739 18.619 0.00598923 15.4712 0.0032538 5.53539 14.9459 15.3397 21.1874616185 21.0509255632 15.758 0.09 15.322 0.12 15.077 0.127 0.00527656 1.02568e-05 0 0.022518 0.007448 -1.0 -1.0 -1.0 -1.0 158.231 28.5118 24.4117 1408.0 -23.020990121 137625 0 Oz 10.0488242208 71.3573597037 107759 1 0.623969353339 -1.0 -1 NSA sdss 4 1.23766725562e+18 NSA True
16 1237665367429677221 158.712397798 28.6638533288 3 GALAXY 263953926197264 1 0 0 268435456 0 17.1231 15.9749 15.5648 15.3427 15.2778 0.0431814 0.00434419 0.010883 0.0108864 0.0164429 0.0403234 0.00589711 0.00774727 0.010346 0.0543278 0.154184 0.113447 0.0822815 0.0623916 0.0442364 17.2089 15.9807 15.5833 15.3734 15.4099 16.0925 16.35 16.9694 17.3155 14.6685 1.128 0.469963 0.370798 0.348461 0.533638 29.6737 2.17965 29.6751 0.307379 28.8778 0.860677 28.7236 1.13166 15.6752 2.65815 0.666012 0.716943 0.750125 0.749991 0.878032 17.3432 0.0400693 16.1224 0.00588608 15.6656 0.00774727 15.431 0.0103452 15.485 0.0532177 21.2251 0.091784 20.1027 0.0212797 19.9395 0.0242773 19.7649 0.035874 19.5045 0.0733235 20.9976 0.0846628 19.768 0.0145711 19.3862 0.0138823 19.1702 0.0187483 19.0428 0.0552399 0.0196445 0.0 0.0 0.0 0.0 0.0627842 0.0271819 0.00799835 0.0248413 0.00391972 0.0201323 0.00921427 0.0166036 -0.00162989 0.0172545 0.534845 10.2626 26.4636 0.671496 9.27015 29.6733 0.730502 9.33377 28.3476 0.732283 9.404 29.1817 0.749994 8.09221 28.9914 20.2372 0.0201445 15.6656 0.00774727 7.83666 17.7277 15.6692 22.5112889895 22.1353459894 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00441311 2.32353e-05 0 0.020946 0.009412 -1.0 -1.0 -1.0 -1.0 158.231 28.5118 24.4117 1408.0 -23.020990121 137625 0 Oz 26.9809883401 191.59207325 107942 1 0.621661007221 -1.0 -1 NSA sdss 4 1.23766536743e+18 NSA True
17 1237667287812735027 157.778274298 28.7966447953 3 GALAXY 35253360136208 1 0 0 268435456 0 14.7459 13.626 12.9873 12.7495 12.4502 0.00442894 0.00144368 0.00170083 0.00114915 0.00206249 0.00415598 0.00179026 0.00172687 0.00174706 0.00223248 0.123642 0.0909745 0.0659823 0.0500324 0.0354736 14.8161 13.6826 13.0575 12.7812 12.527 10.8517 13.8503 14.073 14.9468 13.8779 0.534943 0.404023 0.378962 0.383556 0.361574 5.63745 0.0823326 7.56283 0.0419185 7.94539 0.0278324 9.33297 0.0507758 10.7161 0.0733924 0.653718 0.678861 0.69489 0.706605 0.673492 15.0986 0.00411675 13.8129 0.00180607 13.1448 0.0017465 12.765 0.00175897 12.4355 0.00224586 16.6806 0.0346138 15.8902 0.023146 15.3254 0.0243053 15.1636 0.0217422 15.2337 0.0298665 17.0762 0.0067135 16.0806 0.00211047 15.5412 0.00180144 15.3287 0.00176873 15.008 0.00258908 1.0 0.868553 0.794032 0.754907 0.74773 -0.122522 -0.0211382 -0.130445 -0.0171094 -0.127409 -0.0220195 -0.126608 -0.0213968 -0.136288 -0.0273102 0.666786 3.62226 79.8068 0.6874 6.26741 73.5729 0.722569 6.316 74.9538 0.727747 6.47539 75.6718 0.672029 6.00601 78.2974 16.2389 0.00238357 13.2315 0.0018288 6.12162 16.7952 13.1609 19.2291623734 19.0907247096 12.789 0.047 12.136 0.048 11.953 0.049 0.0047453 7.54079e-06 0 0.022903 0.005899 -1.0 -1.0 -1.0 -1.0 158.231 28.5118 24.4117 1408.0 -23.020990121 137625 0 Oz 29.334281312 208.302423875 107764 1 0.641915844719 -1.0 -1 NSA sdss 4 1.23766728781e+18 NSA True
18 1237650372092690464 180.29544216 -1.2976838319 3 GALAXY 1319448581640280 0 0 0 268435456 0 14.7549 13.8569 13.5133 13.3363 13.2712 0.0172778 0.00179243 0.00124483 0.00155082 0.00551567 0.00616112 0.00218275 0.00221878 0.00297785 0.00571236 0.18759 0.138027 0.100109 0.0759093 0.0538207 14.8969 13.9875 13.6394 13.7364 13.3717 22.799 26.679 27.8643 28.5132 28.3939 0.657716 0.817655 1.00603 1.14355 1.25816 29.671 0.433278 29.6708 0.262799 29.673 0.123082 29.672 0.316657 29.6785 0.225082 0.97345 0.890842 0.877747 0.982633 0.704003 15.1005 0.00621076 14.1603 0.00219262 13.7404 0.00222592 13.6246 0.00292769 13.3712 0.00570735 18.8473 0.0207265 18.5106 0.0207906 18.2253 0.0169116 18.7404 0.0171923 17.9455 0.0284186 18.9308 0.016362 18.3925 0.00866009 18.1215 0.00878149 18.0368 0.0112534 17.8986 0.021555 0.0833092 0.0438304 0.031261 0.0 0.0 0.0170487 0.00362903 0.0851047 0.00612026 0.098443 0.00416241 0.109622 0.00320081 0.103699 0.00487993 0.632492 16.6946 50.0944 0.647036 16.7749 35.3922 0.649944 17.4003 30.9759 0.699971 19.9324 26.8613 0.62162 18.7986 31.0283 18.8384 0.0111272 13.7395 0.00221878 13.7661 29.692 13.7032 21.9377742876 21.3926642507 16.481 0.203 14.687 9999.0 14.353 9999.0 0.00489 -1.0 0 0.022047 0.007053 -1.0 -1.0 -1.0 -1.0 180.098 -1.10008 23.2487 1465.0 -24.5109933671 140594 0 Alice 16.7327056701 113.159038238 171514 1 0.789819001401 -1.0 -1 GAMA 144491 4 1.0 GAMA True
19 1237674648855118180 180.419076868 -1.20276655787 3 GALAXY 474989325325072 0 0 0 268435456 281474976710656 20.3662 22.0993 21.8131 21.9411 23.4239 0.220456 0.460901 0.502235 0.826543 3.10923 0.220456 0.460901 0.502235 0.826543 3.10923 0.167062 0.122923 0.0891537 0.0676025 0.047931 20.1992 21.9764 21.724 21.8735 23.376 1.69592 2.96962 2.96978 2.96967 0.202526 1.00709 -1000.0 -1000.0 -1000.0 0.00838064 20.8879 27.1257 1.16625 2.85393 1.27227 3.65408 1.94085 13.9458 0.0040296 259.179 0.444967 0.386202 0.0575622 0.05 0.144526 20.0409 0.23984 22.9381 0.388594 22.6485 0.385951 22.64 1.07939 22.8433 2.24257 21.9816 0.502139 23.4712 0.318574 23.3487 0.355994 23.5008 0.501256 22.8006 0.669516 22.4195 0.724487 22.6285 0.204932 22.2339 0.174502 22.172 0.257501 21.4896 0.459594 0.269574 0.0 1.0 0.897077 0.0 -0.321766 -0.261438 -0.0153599 0.036544 0.230627 -0.0956909 0.300264 -0.271437 -0.657166 1.81269 0.487406 5.63945 179.969 0.460466 0.981862 41.9232 0.133717 0.967 11.6778 0.05 1.41629 160.186 0.0500355 0.00729201 134.011 23.07 0.234369 22.7798 0.380227 0.961827 1.98659 22.7975 24.7024068675 24.7084395451 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.005044 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 180.098 -1.10008 23.2487 1465.0 -24.5109933671 140594 0 Alice 20.2221567193 136.75706064 -1 1 -1.0 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2016.0205_1.zlog 3 218.0 MMT True
20 1237650762927308814 179.69172842 -1.46194133403 3 GALAXY 1153238168554049552 1 262144 0 268435456 281474976710656 15.5663 14.4205 13.9884 13.6253 13.6721 0.0115363 0.00364846 0.00326905 0.00524258 0.025514 0.0703909 0.0260287 0.0102239 0.0311884 0.0438919 0.133882 0.0985089 0.0714469 0.054176 0.0384115 19.9626 19.7046 18.1052 18.7507 17.9965 2.44641 2.85645 2.69312 2.55184 4.69894 0.142318 0.0185944 0.0232917 0.0520932 2.52093 3.29675 1.4776 15.3494 1.03493 1.40593 0.078973 4.10637 0.486262 0.817225 0.314706 0.380747 0.0540444 0.877246 0.266352 0.903142 19.8947 0.0836794 18.6906 0.0178562 18.1767 0.0102239 18.4046 0.0285066 18.2039 0.0432746 20.8891 0.0803739 20.5657 1.08548 18.9002 0.0455938 19.5466 0.112714 18.6719 0.0668373 20.567 0.0690704 19.3683 1.08568 18.9269 0.0330057 18.6042 0.0413801 18.6259 0.0570257 0.0 0.0 0.0 0.0 0.00156207 -0.0295862 -0.0856345 -0.0420412 -0.00552304 -0.0379529 -0.0200157 -0.0361029 -0.0415385 -0.647101 -0.115936 0.450003 1.98032 109.407 0.249948 4.32815 100.892 0.922989 1.13723 104.026 0.33044 2.55576 87.8065 0.979636 0.762346 112.326 19.7685 0.0478008 18.1767 0.0102239 1.46814 2.3565 18.2896 20.451347583 21.1188713328 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.005 -1.0 0 0.289731 0.067923 -1.0 -1.0 -1.0 -1.0 180.098 -1.10008 23.2487 1465.0 -24.5109933671 140594 0 Alice 32.6395144778 220.73030104 140542 1 -1.0 -1.0 -1 GAMA 185266 4 1.0 GAMA True
21 1237655693015056396 224.532617519 -1.31259609568 3 GALAXY 35253360398352 0 262144 0 268435456 0 17.3497 16.089 15.4546 15.1464 14.9615 0.0211109 0.00390518 0.00300402 0.00330182 0.00836157 0.0416732 0.00498512 0.00534471 0.00545955 0.0135447 0.32708 0.240662 0.174548 0.132355 0.0938412 17.1418 15.8741 15.3876 15.0828 14.9173 12.9075 13.4682 13.1628 13.8231 13.8238 0.738636 0.710056 0.803463 0.78797 0.894669 21.15 3.11296 24.4211 0.411017 23.5287 0.513989 23.8198 0.408222 24.1926 1.04576 0.449992 0.465957 0.446009 0.475622 0.467311 17.477 0.0415375 16.0842 0.00498177 15.5622 0.00534471 15.1929 0.00545646 15.0088 0.0135404 21.1691 0.0788425 19.6741 0.0184681 19.4228 0.0195905 19.0933 0.019701 18.8251 0.037165 20.6698 0.0618124 19.3683 0.0111833 18.7532 0.0087296 18.4167 0.00977192 18.174 0.0217943 0.0 0.0 0.0 0.0 0.0 0.0862015 -0.015842 0.139541 -0.0327954 0.14517 -0.0385242 0.135794 -0.034536 0.133919 -0.0334079 0.508928 8.21412 149.518 0.479386 8.81146 151.674 0.473689 8.55776 152.901 0.487392 8.70547 151.876 0.495454 8.42529 152.167 19.5874 0.0125185 15.5622 0.00534471 6.02391 13.3899 15.5966 22.2194214691 21.4913916271 15.174 9999.0 15.71 0.248 14.45 9999.0 0.0064927 2.15047e-05 0 0.048351 0.009503 -1.0 -1.0 -1.0 -1.0 224.594 -1.09102 28.4038 1922.0 -24.5738822299 145729 0 13.7934861167 113.96603527 35536 1 -1.0 -1.0 -1 NSA sdss 4 1.23765569302e+18 NSA True
22 1237648702984683605 225.005401226 -1.09130226734 3 GALAXY 1161121054724696 0 0 0 268435456 0 16.0611 15.3154 14.9987 14.8723 14.7438 0.00785547 0.00232775 0.00219184 0.0324554 0.00698128 0.00790307 0.00274512 0.00320407 0.00445661 0.00904204 0.327712 0.241128 0.174886 0.132611 0.0940226 15.997 15.1689 14.8268 14.7113 14.6349 40.986 12.9685 13.7948 14.3383 13.7471 1.52479 0.171283 0.158666 0.162538 0.28877 10.7435 0.29789 14.1078 0.139925 15.0666 0.189859 16.1199 0.217477 19.1789 0.55349 0.763178 0.837018 0.889757 0.903721 0.889412 16.1489 0.00772101 15.3572 0.00280809 14.9363 0.00327976 14.7643 0.00451928 14.6683 0.00921106 18.9691 0.0220671 18.7247 0.0217491 18.3088 0.0183036 18.6214 0.0184466 18.4012 0.0271797 18.6917 0.0133083 18.1511 0.00473336 17.9322 0.00489516 17.876 0.00606622 17.7374 0.015826 0.707669 0.186364 0.135334 0.0759754 0.0475266 0.049303 0.0401041 0.0350942 0.0156222 0.021055 0.00853904 0.0190857 0.00764772 0.0257252 0.000878967 0.766903 4.61793 19.3252 0.859923 6.01446 14.5641 0.9152 6.17972 15.5966 0.893827 6.821 16.265 0.896596 6.48962 17.5049 18.7455 0.00700653 15.0017 0.00320407 6.3164 15.0252 14.9831 20.9519645872 20.980901535 16.079 0.2 14.286 9999.0 14.022 9999.0 0.00629765 5.12096e-06 0 0.006898 0.006885 -1.0 -1.0 -1.0 -1.0 224.594 -1.09102 28.4038 1922.0 -24.5738822299 145729 0 24.6830181721 203.937501653 35574 1 0.829859715605 -1.0 -1 NSA sdss 4 1.23764870298e+18 NSA True
23 1237662698115432783 248.152079686 19.8102591366 3 GALAXY 35255507620112 1 0 0 268435456 0 19.0546 18.1465 17.7914 17.4775 17.4055 0.0773064 0.0153358 0.0324549 0.0447302 0.0495881 0.0773064 0.0153358 0.0324549 0.0447302 0.0495881 0.321538 0.236585 0.171591 0.130112 0.0922513 18.733 17.91 17.6199 17.3473 17.3133 27.9232 13.26 11.3084 13.663 12.5394 -1000.0 1.56712 1.13767 1.24345 0.93737 29.6684 10.0073 29.6659 2.38082 20.0567 2.13676 20.5013 3.19524 29.6724 2.74852 0.300101 0.339056 0.250093 0.426776 0.39382 18.9129 0.0858178 17.9843 0.015207 17.7914 0.0324549 17.4134 0.0438632 17.0337 0.0480685 22.349 0.151786 21.5928 0.0463609 21.4042 0.0473423 21.3677 0.0656774 20.9306 0.136512 21.7786 0.108005 21.003 0.0322103 20.6449 0.0350855 20.446 0.0446029 20.4499 0.0978158 0.0 0.0 0.0 0.0 0.0 -0.101475 -0.087617 -0.161841 -0.0574748 -0.155894 -0.0680441 -0.144072 -0.0446031 -0.11951 -0.0761048 0.314416 9.88051 153.814 0.33923 9.70399 152.274 0.345074 8.2159 154.02 0.439105 8.21484 152.819 0.399924 10.6261 154.092 21.4225 0.0482299 17.7914 0.0324549 5.00132 9.54644 17.9565 24.3601194323 23.4474214826 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.007628 -1.0 -1 0.100253 0.016293 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 3.79902294828 37.9266042086 -1 1 0.472151412184 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2014.0524_2.zlog 4 277.0 MMT True
24 1237662698115433445 248.16342684 19.792207594 3 GALAXY 68988043520 1 0 0 268435456 0 21.9272 20.7542 20.4952 21.0372 20.1334 0.337207 0.0595209 0.0632088 0.172284 0.226826 0.337207 0.0595209 0.0632088 0.172284 0.226826 0.319494 0.23508 0.1705 0.129285 0.0916646 21.6077 20.5191 20.3247 20.9079 20.0418 2.47683 2.53433 2.73037 2.96995 11.3065 2.32464 0.247054 0.468995 -1000.0 -1000.0 1.36901 3.37194 2.98911 1.09826 2.57976 1.08891 1.09917 1.22612 4.61122 7.06543 0.05 0.286305 0.593586 0.709626 0.201978 22.3717 0.274758 21.1237 0.0837607 20.6654 0.0684319 22.0797 0.170996 19.9567 0.314474 23.1138 0.290078 22.2433 0.0715595 22.0843 0.0774982 22.5434 0.169221 21.6142 0.240339 22.8765 0.266649 21.9373 0.0734351 21.7503 0.0870193 22.1554 0.196553 21.3419 0.293773 0.0 0.00588068 0.571528 0.0 1.0 -0.211595 0.463231 0.179063 0.0192751 0.153765 0.084652 0.122622 0.146394 0.0269623 0.169794 0.05 1.4164 107.149 0.396039 1.5701 37.7569 0.657768 1.20396 37.1019 0.999862 0.319924 75.496 0.21524 2.78156 41.6863 22.3825 0.10407 20.944 0.0656707 1.38253 4.08204 20.8234 23.3425458071 23.5222017793 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.007471 -1.0 -1 0.565977 0.13087 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 4.77720374104 47.6920241181 -1 1 0.0140341939762 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2013.0508.zlog 4 300.0 MMT True
25 1237662698115432544 248.051339587 19.6957396993 3 GALAXY 35253360136208 1 0 0 268435456 0 18.39 17.2268 16.7923 16.5862 16.4482 0.0361621 0.00689268 0.00642301 0.00810959 0.0214018 0.0361621 0.00689268 0.00642301 0.00810959 0.0214018 0.282299 0.207713 0.150651 0.114234 0.0809933 18.1078 17.0191 16.6417 16.472 16.3672 11.1511 10.1407 11.1996 10.6336 11.1857 1.1568 0.868418 0.975513 0.652731 0.790883 18.6393 3.31978 20.0065 0.511471 24.4883 0.577931 24.7002 0.755514 26.3428 2.38606 0.323826 0.349996 0.366897 0.380471 0.35856 18.3972 0.0373924 17.2697 0.00700105 16.7715 0.00649422 16.5852 0.0081082 16.4373 0.0213948 21.2325 0.0713356 20.2848 0.0214501 20.144 0.0220527 20.0908 0.0267829 19.7956 0.0555509 20.8726 0.0668245 19.836 0.0141702 19.5035 0.0138868 19.3394 0.0156301 19.1838 0.0463774 0.21793 0.0569599 0.0214208 0.0 0.0 0.324528 -0.0615758 0.34314 -0.0256334 0.308859 -0.0192973 0.298457 -0.0143887 0.263823 -0.0136436 0.358003 6.31581 205.237 0.375317 6.86973 208.969 0.390081 7.52481 207.947 0.404861 7.41172 208.301 0.411529 7.41452 208.519 20.2686 0.0191559 16.7923 0.00642302 5.16195 12.366 16.8133 23.1702759032 22.3727912602 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00834 -1.0 -1 0.02302 0.010124 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 8.0940897869 80.8052814659 -1 1 0.525459360418 -1.0 -1 AAT /Spectra/Final/AAT/Odyssey_1_MG.mz 4 117.0 AAT True
26 1237662224092496776 248.195368592 19.8670126788 3 GALAXY 281692140995328 0 0 0 268435456 281474976710656 20.1782 19.039 18.7417 18.5248 18.5186 0.113563 0.0297564 0.0592249 0.104794 0.109641 0.113563 0.0297564 0.0592249 0.104794 0.109641 0.342584 0.25207 0.182822 0.138629 0.0982894 19.8357 18.7869 18.5589 18.3862 18.4203 18.0217 7.54995 11.3072 6.83061 10.334 -1000.0 0.325394 -1000.0 0.367595 10.2352 23.3424 12.9877 11.3891 1.41266 12.3211 2.87446 6.37491 2.27289 12.3216 6.23607 0.414964 0.661828 0.500035 0.93329 0.994926 19.6529 0.129527 18.9434 0.0295811 18.7417 0.0592249 18.4936 0.123962 18.3358 0.126201 22.5768 0.207017 21.8703 0.0531562 21.9215 0.0704263 21.7306 0.0910289 21.5864 0.279894 22.112 0.189613 21.0959 0.0359665 20.7875 0.0414972 20.5884 0.0553344 20.47 0.182447 0.16889 0.0 0.0 0.0 0.0 0.375722 0.0462939 0.161216 -0.0166673 0.175791 -0.0197048 0.0768385 -0.0118422 0.0191785 -0.00310534 0.450055 5.69095 204.184 0.689143 4.02619 212.41 0.7082 3.51102 210.173 0.845678 3.4113 208.247 0.792416 3.93522 214.988 21.604 0.0588265 18.7417 0.0592249 3.09963 5.80399 18.7214 23.4642938115 23.1734135002 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00824 -1.0 -1 0.057825 0.031165 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 6.58348326206 65.7245469675 -1 1 0.247434499231 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2014.0524_1.zlog 3 194.0 MMT True
27 1237662224092364842 247.877387573 20.0936248407 3 GALAXY 105622104314128 1 0 0 268435456 0 18.4211 17.4923 17.175 16.9614 17.2141 0.0612094 0.0123969 0.0146603 0.0203313 0.0885459 0.0612094 0.0123969 0.0146603 0.0203313 0.0885459 0.334959 0.246459 0.178753 0.135543 0.0961016 18.0861 17.2459 16.9963 16.8259 17.118 2.96909 17.8568 27.9154 17.2416 15.2482 -1000.0 1.79072 -1000.0 0.788306 15.1016 29.664 2.66948 29.6632 0.756037 29.662 1.64767 29.6613 2.28189 29.6581 12.8597 0.300907 0.390314 0.416011 0.525979 0.323685 18.4004 0.0610326 17.5077 0.0123912 17.175 0.0146603 16.8574 0.0201531 17.2245 0.0885079 22.0529 0.146454 21.6277 0.0429321 21.5693 0.0543466 21.7516 0.102399 21.1052 0.18694 21.9593 0.132235 21.1691 0.0329312 20.931 0.0479699 20.8766 0.0690983 20.679 0.21903 0.0 0.0 0.0 0.0 0.068081 -0.714633 0.0796629 -0.513179 0.0187286 -0.521572 0.00783503 -0.446478 0.0142803 -0.674835 0.0471937 0.200001 17.9843 119.433 0.261381 15.8768 123.823 0.265846 15.9824 125.106 0.352486 15.4539 127.245 0.250031 15.8766 118.722 21.6809 0.0641757 17.175 0.0146603 8.25063 15.0494 17.3796 25.1886963988 23.9575303748 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.008288 6.53467e-06 0 0.029097 0.019761 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 19.9202150755 198.867458571 -1 1 0.834964455314 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2013.0510_5.zlog 4 120.0 MMT True
28 1237662662147571761 248.393225697 19.9461400824 3 GALAXY 35221147877392 1 0 0 268435456 0 17.2713 16.2777 15.8096 15.6313 15.421 0.015701 0.00351709 0.00319217 0.00374437 0.0079568 0.0138057 0.00351746 0.0032581 0.00380921 0.00915628 0.337488 0.248321 0.180103 0.136566 0.0968273 16.8768 15.9042 15.4673 15.3237 15.1465 5.0196 6.0576 6.43384 6.5614 6.45146 0.463876 0.228561 0.183038 0.173252 0.192427 3.9141 0.259694 4.28204 0.0452493 5.06069 0.0695218 5.41447 0.0686793 6.37333 0.229363 0.549982 0.730983 0.769428 0.797376 0.736579 17.5592 0.0137314 16.3763 0.0035553 15.8051 0.00330137 15.6027 0.00387001 15.356 0.00943835 19.2782 0.0238842 18.4317 0.0200707 18.1497 0.0128241 18.1508 0.0158701 17.8719 0.022275 19.0021 0.0193606 17.9999 0.00663679 17.5609 0.00659977 17.3907 0.00604423 17.1737 0.0125517 0.642943 0.562627 0.501951 0.453728 0.468208 -0.0671512 0.155682 -0.0472502 0.103902 -0.0411469 0.0896721 -0.0296909 0.073277 -0.0376632 0.0742117 0.576737 2.15384 88.8657 0.682035 2.59826 89.7951 0.713795 2.86715 90.4864 0.734169 2.81693 91.0498 0.72742 2.52935 91.1484 18.279 0.00874504 15.9911 0.00326786 2.85375 7.86262 15.8763 20.2738440396 20.1488039442 15.698 0.128 15.075 0.153 14.752 0.119 0.00813 5.23156e-06 0 0.014449 0.006264 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 18.7117533384 186.803268321 68553 1 0.615210919586 -1.0 -1 AAT /Spectra/Final/AAT/Odyssey_1_MG.mz 4 373.0 AAT True
29 1237662224092299404 247.84002995 20.1840758135 3 GALAXY 105553418387472 1 0 0 268435456 0 15.3276 14.1278 13.4728 13.1338 12.8465 0.00545575 0.000819347 0.000661574 0.000659763 0.00162599 0.149566 0.0533453 0.0591594 0.152787 0.204625 0.325711 0.239655 0.173818 0.131801 0.0934483 21.3629 21.0668 20.9231 21.7007 20.691 1.03902 1.09234 1.01523 0.95932 1.0109 0.142708 0.304254 0.121949 0.132924 0.239727 0.161604 1.2061 0.161739 0.207761 0.243348 0.311363 0.240208 0.593892 0.243854 1.29622 0.099355 0.0999971 0.0998729 0.098764 0.0990847 21.7085 0.274485 21.3411 0.136173 21.097 0.0805963 21.8372 0.167169 20.7723 0.350916 21.7438 0.231724 21.4381 0.164097 21.2931 0.201783 22.0491 0.473376 20.9749 0.35304 20.1594 0.0745482 19.2168 0.0335725 18.6293 0.0305352 18.3377 0.0294007 17.958 0.0391027 0.0 0.0 0.0 0.0 0.0 -0.0704102 0.112537 -0.0352527 0.0303944 -0.0236143 0.0711803 -0.0191234 0.0489327 0.0530379 0.154301 0.115559 0.262029 90.0359 0.13272 0.248605 80.7212 0.0994679 0.323958 84.8148 0.0977078 0.318274 90.5193 0.0831614 0.344568 82.457 19.4696 0.0441674 21.097 0.0805963 0.525616 0.995122 21.2268 20.6448591601 21.8256213673 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00855347 -1.0 0 0.248635 0.132598 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 25.5804231974 255.373511506 68560 1 0.169138729211 -1.0 -1 NSA sdss 4 1.23766222409e+18 NSA True
30 1237662662147310256 247.825892241 20.2108787761 3 GALAXY 144150441435988240 1 0 0 268435456 0 18.5302 17.4866 17.0808 16.7995 16.7162 0.0543209 0.00780888 0.00882494 0.0235797 0.0317634 0.0637883 0.0134011 0.0175635 0.0264901 0.0705378 0.32604 0.239897 0.173994 0.131934 0.0935429 18.5602 17.5652 17.1926 16.9752 16.8771 10.3517 11.6391 12.2614 13.1801 43.7708 2.39014 0.665512 0.583794 0.710174 -1000.0 16.6588 4.25039 19.0591 1.08395 20.5064 1.16405 25.5917 2.15249 29.6736 4.52562 0.313447 0.400056 0.507904 0.468319 0.444598 19.0871 0.0634775 17.8979 0.0132651 17.3582 0.0176442 16.8987 0.0276153 16.5376 0.0846964 21.7942 0.117902 21.214 0.0354882 21.0707 0.0388833 20.8715 0.0517485 20.6095 0.133947 21.4815 0.113573 20.5265 0.0205777 20.2309 0.0253003 20.0298 0.0308139 19.7508 0.0993126 0.138685 0.0 0.0123652 0.190607 0.308288 0.345641 -0.0737061 0.225695 -0.0343325 0.164382 -0.0240769 0.138398 -0.0266203 0.171156 -0.0638738 0.382305 5.91328 205.337 0.42063 7.02308 194.047 0.515083 7.37528 191.959 0.513112 8.16828 186.545 0.42548 9.44492 193.497 21.0348 0.0356667 17.3666 0.0175635 5.67808 12.3314 17.3673 23.7008958229 23.1337744376 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00822 4.25059e-07 0 0.042567 0.014763 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 27.3638674437 273.177560754 147082 1 0.459613790263 -1.0 -1 AAT /Spectra/Final/AAT/Odyssey_1_MG.mz 4 258.0 AAT True
31 1237662662147703369 248.58079685 19.7200349023 3 GALAXY 72163216142237968 0 0 0 268435456 0 22.769 19.855 19.4478 18.6953 20.7014 1.57506 0.121909 0.0646117 0.0518438 1.10676 1.57506 0.121909 0.0646117 0.0518438 1.10676 0.342449 0.251971 0.18275 0.138574 0.0982506 22.4266 19.6031 19.2651 18.5567 20.6031 2.96976 2.96972 2.9699 9.07924 18.0202 -1000.0 -1000.0 -1000.0 0.480341 -1000.0 0.000602435 2.02706 10.7123 4.77749 15.3465 4.57391 23.8227 5.12076 29.5932 0.000678259 0.0818159 0.449944 0.506143 0.439117 0.149984 23.2295 0.583118 19.9258 0.133498 19.4479 0.0656473 18.5346 0.051177 19.4919 2.20492 22.9095 0.363325 22.8167 0.131705 22.499 0.239732 22.0783 0.213364 22.4871 0.654032 23.4872 0.798793 21.97 0.0888195 21.473 0.134704 21.1046 0.151605 21.8694 0.803027 1.0 0.0 0.0 0.0 0.611217 -0.923901 0.222587 -0.0198017 0.00904723 0.00187803 0.0229546 -0.03303 0.0385256 -0.481807 -0.414128 0.05 0.00759311 140.894 0.599996 4.45402 129.152 0.569894 5.29264 122.189 0.493846 6.59374 128.142 0.0999805 35.4536 146.599 22.294 0.187989 19.4479 0.0656473 3.21934 5.31272 19.7877 25.0616777745 24.3219776243 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00825 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 28.6019909932 285.537653364 -1 1 0.0407410051245 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2013.0509_3.zlog 3 242.0 MMT True
32 1237680192048857102 336.048161241 -3.48293869003 3 GALAXY 1301856395596120 0 0 0 268435456 0 15.1842 14.155 13.6814 13.4328 13.2987 0.0158139 0.0019919 0.00382091 0.00267506 0.0111406 0.0319244 0.00335078 0.00335315 0.00383953 0.0106237 0.339045 0.249466 0.180934 0.137196 0.097274 16.3544 14.8588 14.3283 14.127 14.0421 18.2212 42.6283 68.2942 39.5053 32.2769 2.19692 1.18145 -1000.0 0.67679 0.916118 29.0358 4.07535 29.6633 0.330295 29.6629 0.783516 29.6652 0.957751 29.655 1.56683 0.463336 0.997495 0.802911 0.937585 0.801699 16.8315 0.0302842 14.8661 0.00330046 14.47 0.00340389 14.2157 0.00390975 14.2148 0.0108544 19.8775 0.102708 19.2084 0.0779058 19.0299 0.111636 18.6517 0.0940428 18.3401 0.0375598 20.5056 0.0848216 19.3404 0.0808781 18.8364 0.0988851 18.5789 0.0864217 18.3823 0.0299696 0.65089 0.0 0.264468 0.278317 0.323613 -0.524991 0.238041 -0.0328263 0.0193736 -0.0139409 0.0189475 -0.0109689 0.0188772 -0.0547123 0.0223408 0.467096 12.6432 56.7188 0.71666 21.3439 50.4573 0.646094 17.7821 45.8293 0.670076 17.056 44.546 0.617999 14.4662 44.1117 19.6412 0.135147 14.5091 0.00335314 16.4146 36.1924 14.4268 22.7544794271 22.4983876931 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00944989 -1.0 0 0.015025 0.008092 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 8.65693859167 98.652700373 149792 1 0.727741305486 -1.0 -1 NSA ned 4 1.23768019205e+18 NSA True
33 1237679996084617517 335.97997618 -3.27054858631 3 GALAXY 35253360136208 1 0 0 268435456 0 18.0722 16.7761 16.1176 15.7984 15.5278 0.0319183 0.00560385 0.00556567 0.00720208 0.0162931 0.0319183 0.00560385 0.00556567 0.00720208 0.0162931 0.38982 0.286826 0.20803 0.157743 0.111842 17.6824 16.4893 15.9096 15.6406 15.416 8.77722 9.55545 10.0355 10.0405 9.34256 0.69777 0.965088 1.02297 0.943868 0.700754 16.9633 2.38275 17.9139 0.408571 17.4071 0.383287 17.1563 0.465679 19.6993 1.10534 0.325858 0.299958 0.343914 0.349915 0.326825 18.1324 0.0318615 16.7877 0.00559458 16.1176 0.00556567 15.8009 0.00720039 15.5395 0.0162904 20.6494 0.0673888 19.5726 0.0198295 19.3233 0.0175721 19.1628 0.0224865 18.7236 0.0378534 20.4828 0.0611485 19.2907 0.0103299 18.6677 0.00930057 18.3571 0.00959109 18.0977 0.0265974 0.0 0.0 0.0 0.0 0.0 0.228284 0.146689 0.193066 0.152995 0.189136 0.153573 0.180822 0.152672 0.191898 0.141564 0.334823 6.34871 30.6269 0.31675 6.76321 31.6429 0.342891 6.7639 31.3008 0.348525 6.71773 31.8533 0.348171 6.65854 30.7537 19.4674 0.013178 16.1176 0.00556567 4.5408 10.2699 16.1368 22.2640420858 21.4178880947 16.262 0.181 14.656 9999.0 14.092 9999.0 0.00951 -1.0 -1 0.026025 0.010681 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 10.4666191628 119.275391561 -1 1 0.460594315315 -1.0 -1 AAT /Spectra/Final/AAT/OBrother_1_MG.mz 4 325.0 AAT True
34 1237680066954264778 335.836305444 -3.65980264084 3 GALAXY 1161187626717272 0 0 0 268435456 0 17.0046 15.6753 15.0443 14.7221 14.4928 0.0288532 0.00282775 0.00242301 0.00291929 0.00755235 0.0210611 0.00694559 0.00353522 0.00537731 0.00903184 0.338641 0.249169 0.180718 0.137033 0.0971581 16.6639 15.4302 14.854 14.5817 14.3529 20.5503 19.5759 19.903 20.4865 18.0165 5.90852 3.45514 2.97036 2.86375 2.76436 29.6803 1.19676 29.6709 0.42911 29.6725 0.291663 29.6632 0.322614 29.6728 0.935928 0.263879 0.23622 0.300218 0.278097 0.271325 16.981 0.0210608 15.6994 0.00696893 15.0309 0.00354181 14.7121 0.00538891 14.4626 0.00902431 20.348 0.064077 19.2005 0.0278779 18.7605 0.0413223 18.5908 0.0551308 18.1514 0.0554188 20.4334 0.06486 19.1336 0.0188019 18.4798 0.0350662 18.1654 0.0443384 17.937 0.0476628 0.0 0.0 0.0113774 0.0104458 0.0 0.182208 -0.0569483 0.160366 -0.0709205 0.151844 -0.0756079 0.146496 -0.0786804 0.136992 -0.0761568 0.215093 14.7725 148.649 0.221535 13.8241 149.387 0.213481 14.4369 148.507 0.215159 14.4891 148.617 0.21784 14.068 148.191 19.2979 0.0496999 15.0347 0.00353522 9.013 21.3675 15.0281 22.8274793074 21.7978985303 16.37 0.212 14.283 9999.0 14.149 9999.0 0.0102104 -1.0 0 0.024955 0.006209 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 14.4370023033 164.520813715 149774 1 0.676663312119 -1.0 -1 NSA ned 4 1.23768006695e+18 NSA True
35 1237680066954330699 335.953849494 -3.70119481833 3 GALAXY 2416187539712 1 0 0 268435456 0 20.9076 19.8552 19.6137 19.5017 19.6485 0.266706 0.0402099 0.0531935 0.0743656 0.305885 0.266706 0.0402099 0.0531935 0.0743656 0.305885 0.323618 0.238115 0.172701 0.130954 0.0928478 20.584 19.6171 19.441 19.3707 19.5556 11.3114 5.72792 5.91189 6.46398 4.10081 -1000.0 0.358941 0.716817 6.31466 4.0043 21.587 32.9674 9.89484 1.74671 11.2983 3.15061 12.3245 4.39676 12.3387 17.9068 0.300153 0.495558 0.444156 0.515727 0.160027 20.6329 0.260776 19.8427 0.0401766 19.6137 0.0614257 19.3635 0.0939437 19.5577 0.328489 22.7402 0.450355 21.6825 0.0663518 21.6661 0.0894565 21.5052 0.122922 21.5431 0.434509 22.9341 0.505396 21.7079 0.0671694 21.4394 0.0835186 21.3801 0.128503 21.5995 0.51849 0.0 0.0 0.0 0.0 0.0 0.164441 -0.257937 0.265311 0.1305 0.260081 0.125287 0.178229 0.0724077 0.0458143 0.080209 0.446701 4.83752 20.6192 0.555322 3.42731 20.3386 0.502423 3.50926 18.5939 0.53693 3.91745 22.0509 0.653712 3.41157 182.405 22.2111 0.113029 19.6137 0.0614257 2.63738 4.91178 19.6958 24.3351928552 23.7971284289 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00936 -1.0 -1 0.08726 0.060236 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 16.3554594917 186.382962752 -1 1 0.133487786004 -1.0 -1 AAT /Spectra/Final/AAT/OBrother_1_MG.mz 4 68.0 AAT True
36 1237679005021831220 348.643816258 4.4984434911 3 GALAXY 1319448581640280 0 0 0 268435456 0 14.9188 13.6412 12.8953 12.5241 12.1801 0.00476049 0.00295811 0.000863827 0.000930394 0.00172733 0.0054975 0.0019702 0.00182255 0.00191394 0.00257564 0.344736 0.253653 0.18397 0.139499 0.0989067 14.8636 13.5048 12.8427 12.5616 12.2852 35.0806 27.2206 23.2385 22.2793 19.3009 5.37453 5.47105 4.30377 3.96652 3.35778 29.6665 0.617914 29.6715 0.261643 29.6646 0.224178 27.3174 0.185757 29.6678 0.322667 0.595111 0.375292 0.334003 0.345779 0.370325 14.7795 0.0052118 13.6833 0.00198517 12.9924 0.00184687 12.6973 0.00194331 12.3075 0.00263684 19.5776 0.0429697 17.6713 0.0180023 17.0731 0.0179714 16.642 0.0237852 16.1863 0.0156312 18.9869 0.0198945 17.3697 0.00960246 16.5174 0.0086738 16.0701 0.0079633 15.6936 0.0044605 0.0 0.17564 0.236378 0.311414 0.365622 -0.316013 -0.00719184 -0.296181 -0.00113476 -0.308108 0.00301164 -0.303949 0.00799961 -0.314698 0.0101114 0.349922 20.9716 83.2536 0.346333 15.2835 82.083 0.337947 14.1287 82.7048 0.375765 12.322 82.4284 0.366885 11.5815 82.3569 17.3001 0.0115104 13.0266 0.00182255 10.2559 30.8981 13.0068 20.7725914311 20.0571096307 12.848 9999.0 12.16 9999.0 12.006 0.067 0.00891952 -1.0 0 0.021633 0.006931 -1.0 -1.0 -1.0 -1.0 348.683 4.53406 37.019 2689.0 -24.5151234146 150887 0 Catch22 3.17157144251 34.1527152531 150882 1 0.704963341199 -1.0 -1 NSA ned 4 1.23767900502e+18 NSA True
37 1237679005021831801 348.621488524 4.50717078054 3 GALAXY 35289867358552 0 0 0 268435456 0 19.9698 18.5939 17.9776 17.7286 17.4885 0.166413 0.019834 0.0218395 0.0239921 0.0786458 0.166413 0.019834 0.0218395 0.0239921 0.0786458 0.345486 0.254205 0.184371 0.139803 0.0991219 19.6243 18.3397 17.7932 17.5888 17.3893 68.3019 9.07348 10.4586 11.0168 5.06478 -1000.0 0.497547 0.493644 1.03798 0.967123 29.6673 9.31377 13.5299 1.14155 17.9032 1.68961 22.0151 2.24066 11.9877 4.87695 0.9903 0.75642 0.869218 0.790518 0.874089 18.4108 0.172325 18.728 0.0196997 17.9066 0.0226242 17.5693 0.0250645 17.6446 0.078065 22.7518 0.334796 21.4391 0.0456551 21.3247 0.0527458 21.0484 0.0632179 20.5713 0.163905 22.6672 0.327745 21.2269 0.0376755 20.716 0.040171 20.5246 0.0531354 20.1893 0.160003 1.0 0.0 0.0666485 0.0700974 0.0 0.188191 -0.0476519 0.0543417 0.0126822 0.0638354 -0.013357 0.0663568 0.00347911 0.0662435 0.00582315 0.527912 26.9183 84.6977 0.785269 4.77767 4.31259 0.827666 5.44512 169.454 0.827023 5.79082 9.79324 0.843173 4.55842 160.296 21.5147 0.0561009 17.9776 0.0218395 5.24948 12.4292 17.9513 23.6531062516 23.5473234357 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00862 -1.0 -1 0.053637 0.028585 -1.0 -1.0 -1.0 -1.0 348.683 4.53406 37.019 2689.0 -24.5151234146 150887 0 Catch22 4.01739620528 43.2608816731 -1 1 0.273166321675 -1.0 -1 AAT /Spectra/Final/AAT/Catch22_2016_1_MG.mz 3 152.0 AAT True
38 1237678777399443498 348.696648891 4.63995487019 3 GALAXY 1319489383829520 1 0 0 268435456 0 16.2589 15.4118 15.1461 15.151 15.0711 0.0133954 0.00337096 0.00372528 0.00503585 0.016996 0.0133954 0.00337096 0.00372528 0.00503585 0.016996 0.351228 0.258431 0.187435 0.142127 0.10077 15.9077 15.1534 14.9587 15.0089 14.9703 7.85677 14.8216 16.9723 17.4592 16.198 0.416085 0.592362 0.532695 0.583627 1.59642 6.14038 0.393122 12.945 0.147697 16.5576 0.230838 21.2875 0.428442 19.2748 1.18488 0.560836 0.633022 0.652968 0.666818 0.642156 16.9274 0.0125958 15.7663 0.00344334 15.3667 0.00384934 15.3186 0.00525219 15.3894 0.0176961 18.5668 0.029266 18.1765 0.0167651 18.0176 0.0157614 18.2427 0.0372806 18.2684 0.0444522 18.9126 0.0201894 18.3965 0.00815896 18.2763 0.0112054 18.4189 0.0330912 18.2789 0.0329746 1.0 0.597977 0.542913 0.330933 0.278819 0.141098 0.0580611 0.153493 0.0330052 0.137907 0.0216559 0.138105 0.00822253 0.117644 0.00515801 0.609136 3.06036 18.444 0.642587 5.92036 2.27256 0.66175 6.76683 -0.102134 0.688367 7.1676 177.606 0.712223 6.22386 0.764634 19.0283 0.0151085 15.7049 0.0037812 7.17402 20.2725 15.5139 21.8522300022 21.7881904536 15.78 9999.0 16.041 0.226 14.706 9999.0 0.009556 -1.0 -1 0.003487 0.006943 -1.0 -1.0 -1.0 -1.0 348.683 4.53406 37.019 2689.0 -24.5151234146 150887 0 Catch22 6.4059165842 68.9813719874 -1 1 0.71936968144 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.0918_1.zlog 4 130.0 MMT True
39 1237678776862572690 348.776907636 4.373197012 3 GALAXY 35287719870552 0 0 0 268435456 0 17.4923 16.41 15.7936 15.5333 15.3104 0.0165465 0.00372222 0.00344489 0.00377388 0.00878984 0.0165465 0.00372222 0.00344489 0.00377388 0.00878984 0.344205 0.253263 0.183687 0.139284 0.0987544 17.1481 16.1567 15.61 15.394 15.2116 7.62093 8.3958 8.64694 8.96763 8.06784 0.453697 0.299889 0.233456 0.224426 0.256739 8.64291 0.655824 9.17482 0.154656 9.47676 0.151941 10.3585 0.148844 12.3224 0.477552 0.641116 0.600725 0.635376 0.633174 0.575303 17.4534 0.0168635 16.3584 0.00378929 15.7422 0.00349726 15.4608 0.00384048 15.3094 0.00895384 19.1839 0.0395789 18.2793 0.0184401 17.7089 0.0185088 17.5538 0.0242889 17.4182 0.0234522 19.6395 0.0302976 18.5769 0.00647879 18.007 0.00562229 17.778 0.00627079 17.5437 0.0156731 0.209068 0.150357 0.107163 0.10302 0.0534356 0.0462194 0.0952906 0.120548 0.0926142 0.111436 0.0719139 0.118829 0.0712098 0.134764 0.0651188 0.673148 3.68838 37.9826 0.589448 4.36894 18.3407 0.629836 4.40322 16.1759 0.630388 4.46986 16.9562 0.624288 4.23508 15.9658 18.8015 0.00799872 15.7936 0.00344489 3.95892 9.4873 15.7704 21.0079422762 20.7537062149 15.851 0.147 15.35 0.193 14.787 0.126 0.008904 -1.0 -1 0.014681 0.005572 -1.0 -1.0 -1.0 -1.0 348.683 4.53406 37.019 2689.0 -24.5151234146 150887 0 Catch22 11.1674755393 120.255527082 -1 1 0.0725685128346 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.0918_1.zlog 4 216.0 MMT True
40 1237678777399509170 348.874199097 4.61326147472 3 GALAXY 1231558551928920 0 0 0 268435456 0 22.3159 20.6245 20.0919 19.8157 19.8534 0.392078 0.0384179 0.0380788 0.0441104 0.174327 0.392078 0.0384179 0.0380788 0.0441104 0.174327 0.36957 0.271926 0.197224 0.149549 0.106032 21.9463 20.3526 19.8947 19.6662 19.7474 1.95797 1.99565 2.01321 2.02483 1.8149 1.93142 0.0813015 0.0957039 0.105237 0.358533 0.265189 3.5427 0.642317 0.204892 0.724754 0.169696 0.811098 0.297318 0.760209 2.14911 0.05 0.321801 0.349964 0.468359 0.908478 22.444 0.88795 20.6447 0.0383888 20.0919 0.0380788 19.7884 0.0452603 19.8116 0.384388 22.4742 0.436096 20.9267 0.0832394 20.4237 0.0811642 20.2096 0.0797042 20.2421 0.224996 21.8964 0.212424 20.8685 0.064047 20.33 0.0632852 20.0446 0.0613541 19.8139 0.142679 1.0 0.0 0.0 0.0 0.0 -0.120885 -0.0855743 0.0668041 0.0570649 0.0603744 0.0741286 0.035677 0.045153 0.138897 0.00216901 0.0852328 0.472005 37.6751 0.449965 0.837724 21.6701 0.457291 0.91242 27.6023 0.580493 0.900982 23.6142 0.999772 0.720122 80.1315 21.1625 0.0908233 20.0919 0.0380788 1.14993 1.76627 20.2737 21.8883004344 22.5725191946 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.009029 -1.0 -1 0.106661 0.049037 -1.0 -1.0 -1.0 -1.0 348.683 4.53406 37.019 2689.0 -24.5151234146 150887 0 Catch22 12.3834987085 133.350062655 -1 1 0.0891206695302 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.0918_1.zlog 3 170.0 MMT True
41 1237679005558702536 348.554591739 4.91500326962 3 GALAXY 281709320863744 1 0 0 268435456 281474976710656 21.8086 21.1719 20.8844 21.2739 21.8306 0.298188 0.0626813 0.0784184 0.171063 1.14879 0.298188 0.0626813 0.0784184 0.171063 1.14879 0.366988 0.270026 0.195845 0.148504 0.105291 21.4416 20.9019 20.6886 21.1254 21.7253 0.0919122 3.73425 2.50511 2.60216 0.296803 0.0355574 0.512303 0.200675 2.44569 0.573581 4.10667 7.80763 5.11608 1.79423 4.10601 1.98431 3.44767 3.13092 9.89341 22.9986 0.05 0.386332 0.286519 0.349938 0.05 21.7812 0.261212 20.8884 0.0862551 20.8844 0.0784184 21.229 0.169298 20.5753 0.538098 22.6219 0.314224 22.2987 0.0842459 22.1766 0.107121 22.5841 0.216634 22.3292 0.686211 22.4601 0.295083 22.1081 0.0816971 21.8215 0.106536 22.1516 0.224618 22.1408 0.794124 0.0 0.134992 0.0 0.0 0.0514384 0.221975 0.180526 0.144255 -0.208483 0.140232 -0.171469 0.27856 -0.126487 1.75578 52.5333 0.158749 1.76448 3.19697 0.431437 2.24219 156.353 0.400215 1.76425 156.326 0.449628 1.75905 173.702 0.05 3.41105 50.522 22.5329 0.135876 20.8844 0.0784184 1.29802 1.95693 21.1057 24.1126576875 23.6675736433 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.009368 -1.0 -1 0.13515 0.050588 -1.0 -1.0 -1.0 -1.0 348.683 4.53406 37.019 2689.0 -24.5151234146 150887 0 Catch22 24.1118295796 259.64347008 -1 1 0.193589248151 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.0918_1.zlog 4 109.0 MMT True
42 1237668298203202132 182.848206846 20.0632227672 3 GALAXY 35191083106832 1 0 0 268435456 0 21.1227 20.1145 20.008 19.8726 19.4657 0.200869 0.0343099 0.0587202 0.078248 0.186034 0.200869 0.0343099 0.0587202 0.078248 0.186034 0.174705 0.128547 0.0932327 0.0706955 0.050124 20.948 19.986 19.9148 19.8019 19.4155 2.65322 4.44146 4.52623 3.89658 3.8835 2.6068 0.484254 1.32849 0.282203 3.72444 7.3078 3.50662 4.67095 0.878666 4.96264 1.64587 3.47721 1.10666 4.30776 3.79971 0.472522 0.594722 0.491823 0.999906 0.755632 20.3615 0.201266 20.0545 0.0359994 20.008 0.0762655 19.7272 0.0821986 19.4046 0.179177 22.5209 0.247984 21.5618 0.056281 21.7679 0.0775694 21.8565 0.108736 21.2512 0.262478 22.1971 0.259816 21.3603 0.0435997 21.1737 0.065764 21.0293 0.0863021 20.5899 0.252217 0.88867 0.0253526 0.0 0.0 0.0 -1.18349 -0.800236 -0.159502 -0.0800225 -0.181125 -0.286501 0.0273503 0.0947882 0.182807 -0.120085 0.416509 1.38122 -0.703747 0.677198 1.98208 112.895 0.599783 1.98112 118.455 0.768695 2.06379 90.2972 0.700144 1.88798 52.5759 21.8941 0.0854396 20.008 0.0762655 1.64732 3.43852 20.0778 23.4880455291 23.1571251533 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.007782 -1.0 -1 0.009855 0.09731 -1.0 -1.0 -1.0 -1.0 182.792 20.1757 36.3129 2448.24 -23.0663046684 161174 0 ScoobyDoo 7.45463101585 78.7431642049 -1 1 0.0324325443425 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2016.0310_1.zlog 4 162.0 MMT True
43 1237668298203267092 182.990666509 20.0278486922 3 GALAXY 1161153266978832 1 0 0 268435456 0 15.8828 14.8758 14.4876 14.2848 14.1206 0.00954302 0.00206305 0.00191848 0.00217663 0.00591532 0.00868713 0.00244257 0.00242592 0.0028437 0.00635386 0.166119 0.122229 0.0886505 0.067221 0.0476605 15.9776 14.9743 14.5782 14.4174 14.2559 11.0348 12.2224 12.4214 13.1245 12.7824 0.46172 0.548525 0.491611 0.41526 0.445747 13.853 0.444026 10.9555 0.0841372 12.3227 0.0837728 12.4667 0.0978454 14.9637 0.406184 0.564896 0.648127 0.664197 0.679885 0.657577 15.8954 0.00889622 14.9582 0.00246198 14.5063 0.00246108 14.2816 0.00288835 14.0743 0.00661391 18.9156 0.0242769 17.8459 0.0131848 17.7523 0.0210637 17.792 0.0232707 17.5206 0.0224153 18.5083 0.0155606 17.4996 0.0033799 17.1539 0.00319241 16.9559 0.00333816 16.7993 0.010505 0.458708 0.428622 0.409873 0.439733 0.387692 -0.165666 0.0115026 -0.150692 0.0278864 -0.13657 0.0226562 -0.125194 0.0308981 -0.125737 0.0312213 0.611598 6.00453 79.4146 0.630992 6.03778 77.712 0.64346 6.009 77.6615 0.665945 5.99506 76.8733 0.660764 5.59107 76.3105 17.9043 0.00433811 14.6669 0.00242592 5.68529 14.9503 14.5817 20.5563529437 20.3508717254 15.248 0.142 14.771 0.172 14.442 0.133 0.00800182 1.16984e-05 0 0.01492 0.006863 -1.0 -1.0 -1.0 -1.0 182.792 20.1757 36.3129 2448.24 -23.0663046684 161174 0 ScoobyDoo 14.2804185494 150.843547809 118414 1 0.612725020773 -1.0 -1 NSA sdss 4 1.2376682982e+18 NSA True
44 1237668298203070473 182.428044304 20.0469187602 3 GALAXY 246359594504540 0 262144 0 268435456 0 17.969 17.2377 16.8337 16.5412 18.0671 0.0537586 0.0124537 0.0129866 0.0223096 0.254136 0.0537586 0.0124537 0.0129866 0.0223096 0.254136 0.18599 0.136849 0.0992547 0.0752618 0.0533615 17.783 17.1009 16.7345 16.466 18.0137 2.97041 19.5046 17.8969 18.2615 43.7864 -1000.0 0.632189 0.525841 0.690824 -1000.0 29.6715 6.75804 29.6688 1.91326 29.6728 2.66976 29.6789 3.70482 0.0662469 0.499819 0.819387 0.662117 0.86335 0.984939 0.952798 17.2315 0.0503212 17.2605 0.0124383 16.8337 0.0129866 16.5601 0.0222924 22.0406 0.495234 21.548 0.121405 21.5207 0.0575958 21.3666 0.0654683 21.4862 0.147275 22.2603 0.340441 21.4563 0.140734 20.9553 0.0390609 20.5869 0.045303 20.4397 0.0708237 20.8775 0.273438 0.225479 0.0 0.0 0.0 0.773152 -0.0415744 -0.0107133 0.139899 -0.0183358 0.104515 -0.00503905 0.060371 -0.00465939 -0.184623 -0.220856 0.499826 22.5062 123.371 0.614624 10.8067 151.154 0.67295 10.6368 153.414 0.654293 10.5384 157.24 0.947399 0.0759167 14.6156 21.3835 0.0591498 16.8337 0.0129866 8.18865 16.1744 16.933 23.963234403 23.4944884206 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.008231 -1.0 -1 0.055147 0.050069 -1.0 -1.0 -1.0 -1.0 182.792 20.1757 36.3129 2448.24 -23.0663046684 161174 0 ScoobyDoo 21.9133215945 231.468726484 -1 1 -1.0 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2016.0310_1.zlog 4 243.0 MMT True
45 1237668298740007188 182.689815229 20.5929282759 3 GALAXY 105624251662608 1 0 0 268435456 0 19.403 18.6405 18.319 18.2342 18.339 0.0863532 0.0206977 0.0417838 0.0608542 0.126956 0.0863532 0.0206977 0.0417838 0.0608542 0.126956 0.133348 0.0981162 0.0711621 0.0539601 0.0382584 19.2696 18.5424 18.2478 18.1802 18.3008 6.95807 7.74496 7.90907 11.6778 18.0187 0.741644 0.2772 0.605597 8.08308 -1000.0 21.1617 6.70641 15.1931 1.68054 12.3246 1.79133 17.0547 3.57564 29.6637 20.6985 0.548912 0.749738 0.83182 0.749779 0.548246 18.3525 0.0803704 18.6354 0.0206721 18.319 0.0426848 17.917 0.0640602 18.1559 0.125157 21.7491 0.127241 21.4111 0.0482136 21.4156 0.0610886 21.4674 0.0954107 22.134 0.420858 21.6852 0.152615 21.0104 0.0388067 20.7578 0.045151 20.6655 0.067455 20.8974 0.278184 1.0 0.0 0.0 0.141921 0.0 0.0954469 -0.228143 0.065382 -0.0412044 0.0311266 -0.0125363 0.0679096 -0.0385851 -0.00851043 0.0573078 0.571801 4.65803 136.49 0.784572 4.49858 152.497 0.864558 4.31249 162.183 0.768407 5.83677 160.735 0.799616 5.29299 9.58301 21.5494 0.0626212 18.319 0.0426848 3.95675 8.16799 18.3488 23.4880558544 23.3309108387 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.008433 -1.0 -1 0.103337 0.04012 -1.0 -1.0 -1.0 -1.0 182.792 20.1757 36.3129 2448.24 -23.0663046684 161174 0 ScoobyDoo 25.684925387 271.307199673 -1 1 0.568075619287 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2016.0310_1.zlog 4 78.0 MMT True
46 1237648721248845970 221.316115836 -0.159937082521 3 GALAXY 105587744575576 0 0 0 268435456 0 16.5779 15.4534 14.9999 14.748 14.6104 0.0132031 0.00307767 0.00244978 0.00311895 0.00910513 0.0146661 0.00419994 0.00439184 0.00559093 0.17522 0.193776 0.142579 0.10341 0.0784126 0.0555955 16.603 15.4781 15.0073 14.8393 15.5281 14.8841 15.0175 17.0154 15.7295 13.1781 0.566606 0.415441 0.441515 0.367411 0.347179 23.8172 1.15182 25.356 0.350364 29.6632 0.529713 29.6622 0.69457 13.5356 9.47236 0.715968 0.629328 0.64502 0.59692 0.422398 16.8917 0.0149555 15.6725 0.00417691 15.1107 0.00439184 14.938 0.00558602 15.4109 0.253963 20.394 0.0570104 19.6403 0.0194839 19.4335 0.0209814 19.1559 0.0217439 19.2875 0.0562016 20.1335 0.0347685 19.1235 0.00861023 18.7472 0.00822442 18.5638 0.0100939 18.4445 0.0323903 0.08505 0.0 0.0 0.0 0.0 0.0433737 -0.0172328 0.0648738 -0.00681728 0.0495119 -0.00851707 0.0577374 -0.00952559 0.0486287 -0.0101198 0.752951 7.38484 146.237 0.650006 9.01963 143.582 0.653908 10.0704 140.209 0.649841 9.658 141.969 0.605148 8.21325 141.068 19.6061 0.012202 15.1107 0.00439184 7.96924 18.9362 15.1211 22.12139684 21.6236680132 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00563 1.43632e-05 0 0.062095 0.033155 -1.0 -1.0 -1.0 -1.0 221.546 -0.222942 25.3928 1659.36 -23.5995529604 165536 0 Dune 14.3220507622 105.789036487 2579 1 0.728516178787 -1.0 -1 AAT /Spectra/Final/AAT/Dune_1_MG.mz 4 201.0 AAT True
47 1237665565541728490 234.132926177 16.4404552908 3 GALAXY 105589892059224 0 0 0 268435456 0 16.1647 14.9855 14.4259 14.1387 13.9433 0.0158673 0.00259635 0.00209654 0.00186889 0.00660086 0.0225006 0.00533662 0.00365586 0.00515775 0.0165636 0.265727 0.19552 0.141807 0.107528 0.0762387 16.1973 14.9169 14.3988 14.165 14.0913 22.802 26.5905 26.6271 25.7355 24.102 0.922541 0.993555 1.08189 0.981544 0.73939 29.6735 1.06105 29.6712 0.344343 29.6666 0.649634 29.6739 0.269091 29.6667 2.45438 0.72939 0.628225 0.726929 0.617838 0.544187 16.5156 0.0224544 15.1144 0.00533579 14.5406 0.00365586 14.299 0.00515002 14.221 0.0163856 21.2198 0.0895723 20.184 0.0213354 19.6587 0.023881 19.3987 0.022902 19.0766 0.0414875 20.9411 0.0918039 19.6351 0.0120631 19.0204 0.0106331 18.7119 0.0116012 18.519 0.0291054 0.0 0.0 0.0 0.0 0.0 0.277716 -0.0105282 0.241218 -0.00404015 0.237909 -0.0061111 0.233472 -0.00943407 0.257519 -0.00772755 0.449939 17.3926 188.744 0.449997 18.5222 186.685 0.461628 18.3583 186.446 0.46783 17.2205 186.139 0.449999 16.2165 187.286 19.8695 0.0154952 14.5406 0.00365586 12.4745 25.4727 14.6318 22.8552192249 22.1073501623 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.0063225 2.50655e-05 0 0.017646 0.008486 -1.0 -1.0 -1.0 -1.0 234.132 16.6078 28.0204 1967.37 -23.7233716534 166313 0 Gilgamesh 10.0451514042 81.8759433532 166312 1 0.754674971471 -1.0 -1 NSA sdss 4 1.23766556554e+18 NSA True
48 1237665566078402826 233.787037531 16.8704375988 3 GALAXY 35255507619856 1 0 0 268435456 0 17.0431 15.957 15.531 15.3251 15.2011 0.0523063 0.00369042 0.00387899 0.00559496 0.0152938 0.0245222 0.032043 0.0117344 0.0174938 0.0631772 0.2423 0.178282 0.129305 0.0980482 0.0695174 17.0067 16.0834 15.6201 15.5189 15.5281 17.97 19.171 18.8152 17.9914 16.3511 0.861229 0.657451 0.610941 0.464012 0.572605 29.6659 3.83181 19.1207 1.63408 29.6635 1.26729 29.5521 2.07357 29.5319 8.06556 0.814723 0.498891 0.522315 0.449782 0.38877 17.1638 0.0244375 16.2299 0.0313349 15.7494 0.0117344 15.6486 0.0173854 15.6222 0.0616617 21.0277 0.0762207 20.6851 0.0273775 20.5808 0.0329151 20.359 0.0406918 20.3094 0.0995726 20.8808 0.0687915 20.1612 0.0171456 19.792 0.018344 19.6193 0.0251379 19.5235 0.0716609 0.0 0.0 0.0 0.0 0.0 -0.000846283 0.00930696 -0.038169 -0.000383598 -0.0540185 -0.00157497 -0.0603573 -0.00171284 -0.0774855 -0.00411408 0.599599 12.5904 147.871 0.599976 10.2795 144.707 0.549999 12.0037 143.908 0.599964 10.4472 143.947 0.589558 10.233 141.954 20.6351 0.0264381 15.7494 0.0117344 8.92572 17.5942 15.7627 23.1414298816 22.5113834966 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.006671 7.46778e-06 0 0.007259 0.007794 -1.0 -1.0 -1.0 -1.0 234.132 16.6078 28.0204 1967.37 -23.7233716534 166313 0 Gilgamesh 25.3587294294 206.692157819 124222 1 0.770648809036 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2014.0530_1.zlog 4 135.0 MMT True



In [10]:

    
np.sum(complete_hosts_spectra['SATS']==1),np.sum(sagaspectra['SATS']==1)









    Out[10]:





(49, 49)



In [11]:

    
np.sum(t[np.in1d(t['HOST_NSAID'], incompletes)]['SATS']==1)









    Out[11]:





0

Looks like there's no difference between the "complete" and "regular" set

Functions/numbers useful for below



In [12]:

    
palomar_A = 1.76e5 * u.cm**2



In [13]:

    
# see the section at the bottom for how the relations were derived
u_fibmag_to_haflux = lambda mag: (10**(mag*-0.5447 - 3.4666))*u.erg/u.s * u.cm**-2
r_fibmag_to_haflux = lambda mag: (10**(mag*-0.5075 - 5.1159))*u.erg/u.s * u.cm**-2

u_haflux_sats = u_fibmag_to_haflux(sats['FIBERMAG_U'])
r_haflux_sats = r_fibmag_to_haflux(sats['FIBERMAG_R'])
haflux_sats = (u_haflux_sats + r_haflux_sats)/2



In [14]:

    
typical_ha_linewidth = 5*u.angstrom

CWI

From Jeremy:

Since you have spectra already, this should be pretty straight-forward. I use 20 minute exposures. Sometimes I combine two 20 minute exposures. The staff recommends sticking to this observing strategy. For the 20 minute exposures, the typical noise per pixel in a given spaxel is about 7x10^-18 erg/s/cm^2 (+/- 1x10^-18 erg/s/cm^2). This is pretty consistent across the entire bandwidth and across the CCD. I have found you can measure line centers down to a S/N of 5. I have not done mosaics but I know others have. The spatial resolution is about 2.7" by whatever your seeing is. You can rotate the FOV 90 degrees and co-add to get seeing limited data but rotation is not a simple task. The FOV is 60" by 40" but the edges of the field are a little wonky. The nod-and-shuffle mask limits the bandwidth range but is fine for H-alpha and both NII lines.

For a great detection, the SDSS h-alpha flux is 1.4e-13 [erg/s/cm^2].

For a typical detection, the SDSS h-alpha flux is 5.0e-15 [erg/s/cm^2].

For a so-so detection, the SDSS h-alpha flux is 1.0e-15 [erg/s/cm^2]. I would integrate for 40 min here or below.

For the smallest detection, the SDSS h-alpha flux is 2.0e-16 [erg/s/cm^2]. I don't really trust this.

I gave you the correct noise figure but let me make clear the units are "per pixel", meaning the typical noise is 7x10^-18 (+/-1x10^-18) erg/s/cm^2/Angstrom for an average galaxy in my sample in the emission line. I just wanted to be more specific.

The CWI web site says "Estimated Efficiency: ~10^-18 ergs/cm2 /s/arcsec2 after 3 hours on target and 3 hours on background"



In [15]:

    
plt.hist(np.log10(haflux_sats.value))









    Out[15]:





(array([ 3.,  6.,  9.,  7.,  7.,  8.,  4.,  4.,  0.,  1.]),
 array([-16.51836014, -16.15350571, -15.78865128, -15.42379684,
        -15.05894241, -14.69408798, -14.32923355, -13.96437912,
        -13.59952469, -13.23467026, -12.86981583]),
 <a list of 10 Patch objects>)



In [16]:

    
cwi_noise_20min = 7e-18 * u.erg/u.s*u.cm**-2
cwi_noise_3hr = 1e-18 * u.erg/u.s*u.cm**-2

fib_to_cwi_spaxel = 2.5/(np.pi*3**2)  # area of a spaxel vs. area of SDSS fiber
fluxperspaxel = haflux_sats*fib_to_cwi_spaxel/4 # /4 for ~4 pixels width



In [17]:

    
# the *2 is because of the need to do on/off
timeto5 = (5*cwi_noise_20min/fluxperspaxel/2)**2 *(20*u.min) * 2 #/2 is Jeremy's correction

timeto5_2 = (5*cwi_noise_3hr/fluxperspaxel)**2 *(3*u.hr) * 2

np.sum(timeto5).to(u.hour), np.sum(timeto5_2).to(u.hour)









    Out[17]:





(<Quantity 1064.2498697916667 h>, <Quantity 781.8978271484375 h>)



In [18]:

    
timeper = (np.max([timeto5_2.to(u.min), [40]*len(timeto5_2)*u.min],axis=0)*u.min).to(u.hour)
timeper









    Out[18]:





$[150.7889,~0.66666667,~0.66666667,~3.5633982,~0.66666667,~63.98501,~334.06794,~5.5875707,~0.66666667,~10.636771,~1.7063151,~22.555245,~0.66666667,~0.66666667,~0.66666667,~0.66666667,~0.66666667,~0.66666667,~0.66666667,~19.728499,~0.66666667,~0.66666667,~0.66666667,~2.3453494,~34.632454,~0.66666667,~4.466747,~3.9715238,~0.66666667,~0.66666667,~1.0264648,~53.217863,~0.66666667,~0.66666667,~0.66666667,~27.637842,~0.66666667,~8.1363719,~0.66666667,~0.66666667,~2.0567083,~17.649266,~7.141865,~0.66666667,~1.2923238,~2.1816457,~0.66666667,~0.66666667,~0.66666667] \; \mathrm{h}$

Alternative Formulation using Jeremy's empirical approach



In [19]:

    
sats[np.argsort(haflux_sats)]['RA', 'DEC', 'ZQUALITY', 'FIBERMAG_R', 'r']









    Out[19]:




<Table masked=True length=49>

RA DEC ZQUALITY FIBERMAG_R r
float64 float64 int64 float32 float32
149.687168865 32.7202654623 3 22.283 20.6923
180.636494306 1.95802947978 4 22.6497 18.6728
353.778805283 0.301058523211 3 21.9254 21.3615
248.58079685 19.7200349023 3 21.473 19.4478
248.16342684 19.792207594 4 21.7503 20.4952
335.953849494 -3.70119481833 4 21.4394 19.6137
39.5361613388 -1.39669557972 3 21.8981 20.1799
180.419076868 -1.20276655787 3 22.2339 21.8131
348.554591739 4.91500326962 4 21.8215 20.8844
20.3284666123 17.7539390491 4 21.3842 19.8126
... ... ... ... ...
123.243173206 36.198359966 4 18.669 15.5962
348.776907636 4.373197012 4 18.007 15.7936
158.04324634 28.4830569538 4 17.8647 15.2572
348.696648891 4.63995487019 4 18.2763 15.1461
180.29544216 -1.2976838319 4 18.1215 13.5133
248.393225697 19.9461400824 4 17.5609 15.8096
225.005401226 -1.09130226734 4 17.9322 14.9987
182.990666509 20.0278486922 4 17.1539 14.4876
348.643816258 4.4984434911 4 16.5174 12.8953
157.778274298 28.7966447953 4 15.5412 12.9873



In [20]:

    
# above 1e-15 we need 20 min, otherwise we take the flux ratio to be the S/N improvement needed 
snover20 = 1e-15*u.erg/(u.s*u.cm**2)/haflux_sats
snover20[snover20<1] = 1

timeper2 = (snover20**2 * 20*u.min* 2).to(u.hour)
np.sort(timeper2)









    Out[20]:





$[0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.66666669,~0.84888351,~1.0494448,~1.2412006,~1.3207878,~2.2291374,~2.8064945,~3.7055449,~4.4664812,~4.7378039,~5.0933132,~7.7385063,~8.6248188,~9.7002792,~12.134331,~15.50974,~17.669472,~23.099499,~38.328289,~42.843693,~48.982426,~60.020119,~75.210091,~115.57136,~138.95398,~327.46292,~725.4837] \; \mathrm{h}$

DBSpec

Baseline numbers from DBSpec (for dr10 objid 1237678879396725010):

for conservative line: (online, offline, stdoffline, S/N) (16443.5, 2159.5, 2.589106988905634, 63.51031483233666)
900s x 3
which has fibermag_r~20.1



In [21]:

    
fibfluxratios = 10**((sats['FIBERMAG_R']-20.1)/-2.5)
snr45=np.array(fibfluxratios*63)
timeper_dbsp = ((30/snr45)**2 * (900*u.s*3)).to(u.hour)
timeper_dbsp[timeper_dbsp<15*u.min] = 15*u.min
np.sort(timeper_dbsp)









    Out[21]:





$[0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.25,~0.2522268,~0.25980732,~0.4169803,~0.46399614,~0.52894789,~0.57133687,~0.60339653,~0.73370689,~0.78595245,~1.2290394,~1.8111496,~2.0051212,~2.1330483,~3.5551956,~4.053647,~4.6678071,~4.9080462,~8.6651793,~9.4853239,~18.637209] \; \mathrm{h}$



In [22]:

    
np.sort(timeper2)/np.sort(timeper_dbsp)









    Out[22]:





$[2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~2.6666667,~3.395534,~4.1977792,~4.9648023,~5.2831511,~8.9165497,~11.225978,~14.691321,~17.191515,~11.362177,~10.977059,~14.629997,~15.095856,~16.076126,~16.538389,~19.733686,~14.376652,~12.754053,~19.115198,~20.085665,~13.777702,~14.806449,~16.112511,~23.547325,~16.035904,~34.523113,~38.926628] \; \mathrm{}$

Below this is probably wrongish

Following http://www.astro.caltech.edu/~enk/dbsp_throughput/, but just assuming a straight ~20% throughput, which is good for ~Halpha for most gratings

As it currently stands this is wrong as it doesn't account for the sky background, but it also assumes the equivalent width is only ~5, so maybe those cancel...?



In [23]:

    
def m_to_nphot(mag, texp, dellamb, lamb, throughput=.2):
    num = texp * palomar_A * dellamb * (mag*u.ABmag).physical
    den = cnst.h * lamb
    return (throughput*num/den).decompose()
m_to_nphot(20, 1*u.second, 5*u.angstrom, 6563*u.angstrom)









    Out[23]:





$1.4694482 \; \mathrm{}$



In [24]:

    
m_to_nphot(10, 1*u.second, 1*u.angstrom, 6563*u.angstrom)









    Out[24]:





$2938.8963 \; \mathrm{}$



In [25]:

    
(0*u.ABmag).physical.to(u.erg*u.cm**-2)









    Out[25]:





$3.6307805 \times 10^{-20} \; \mathrm{\frac{erg}{cm^{2}}}$



In [26]:

    
(cwi_noise_20min/(0*u.ABmag).physical/u.Hz).decompose()









    Out[26]:





$192.79601 \; \mathrm{}$



In [27]:

    
# let's just say 2" is typical seeing
countrate = m_to_nphot(sats['FIBER2MAG_R'], 1*u.second, 1*u.angstrom, 6563*u.angstrom)/u.second

# assume we need ~100 counts per/angstrom for a decent centroid
time_needed = 100/ countrate
time_needed









    Out[27]:





$[7527.8354,~666.25446,~215.03125,~927.83423,~558.86646,~3428.5591,~5340.5151,~1555.6124,~660.48151,~2494.8333,~969.76794,~3791.8398,~201.49609,~657.36633,~642.84979,~95.368851,~423.35196,~10.650342,~116.72738,~5751.8027,~274.92242,~232.68102,~107.15934,~1261.2764,~3053.5386,~435.76074,~1490.8419,~1600.1823,~69.731544,~208.75578,~882.53387,~2814.6228,~244.51656,~208.34956,~178.21991,~2607.6455,~28.303686,~1373.1394,~139.03751,~112.83287,~992.73224,~3507.2825,~1947.4664,~49.379429,~1216.761,~1417.7328,~236.72516,~301.72754,~610.71198] \; \mathrm{s}$



In [28]:

    
np.sum(time_needed).to(u.hour)









    Out[28]:





$17.678227 \; \mathrm{h}$

observability



In [43]:

    
from astroplan import plots as planplots



In [34]:

    
pal = astroplan.Observer.at_site('palomar', timezone='US/Pacific')



In [42]:

    
targets = [astroplan.FixedTarget(SkyCoord(sat['RA'], sat['DEC'], unit=u.deg), str(sat['OBJID']))
          for sat in sats]



In [132]:

    
dbsp_thresh = 5*u.hour
any_thresh = 8*u.hour

for tcwi, tdbsp, targ in zip(timeper2, timeper_dbsp, targets):
    if tcwi<dbsp_thresh:
        targ.observable_by = 'CWI'
        targ.observing_time = tcwi
    elif tcwi>dbsp_thresh and tdbsp<any_thresh:
        targ.observable_by = 'DBSP'
        targ.observing_time = tdbsp
    else:
        targ.observable_by = None
        targ.observing_time = None
        

cwi_targets = [targ for targ in targets if targ.observable_by == 'CWI']
dbsp_targets = [targ for targ in targets if targ.observable_by == 'DBSP']
none_targets = [targ for targ in targets if targ.observable_by == None]

len(cwi_targets), len(dbsp_targets), len(none_targets)









    Out[132]:





(32, 14, 3)



In [164]:

    
cons = [astroplan.AirmassConstraint(2.5)]
months = np.array(range(2, 13) + [1])

obstables = []
timeobservable = []
night_length = []
for monthnum in months:
    midmonth = Time('2017-{}-15'.format(monthnum))
    midnight = pal.midnight(midmonth, 'nearest')
    eve = pal.twilight_evening_astronomical(midnight, 'previous')
    morn = pal.twilight_morning_astronomical(midnight, 'next')
    
    tab = astroplan.observability_table(cons, pal, targets, 
                                        time_range=(eve, morn), time_grid_resolution=0.2*u.hour)
    obstables.append(tab)
    night_length.append((morn-eve).to(u.hour))
    timeobservable.append(tab['fraction of time observable']*night_length[-1])

timeobservable = u.Quantity(timeobservable)
for targ, tobs in zip(targets, timeobservable.T):
    targ.time_observable = tobs
    if targ.observing_time is None:
        targ.months_observable_bool = np.array([False]*12)
        targ.months_observable = []
    else:
        targ.months_observable_bool = np.array([t>=targ.observing_time for t in tobs])
        targ.months_observable = months[targ.months_observable_bool]



In [224]:

    
# individual target info
data = [[] for i in range(19)]
for targ in targets:
    data[0].append(targ.name)
    data[1].append(targ.observable_by)
    data[2].append(targ.observing_time.to(u.hour).value)
    for i, b in enumerate(targ.months_observable_bool):
        data[i+3].append(b)
    data[-4].append(np.sum(targ.months_observable_bool))
    data[-3].append(np.any(targ.months_observable_bool[:6]))
    data[-2].append(np.any(targ.months_observable_bool[-6:]))
    data[-1].append(targ.observing_time is None)
Table(names=['name', 'instrument', 'time'] + list(months) + ['nmonths', 'A', 'B', 'none_target'], data=data).show_in_notebook()









    Out[224]:




<Table length=49>

idx name instrument time 2 3 4 5 6 7 8 9 10 11 12 1 nmonths A B none_target
0 1237651735757259099 None None False False False False False False False False False False False False 0 False False True
1 1237657607497515484 CWI 1.04944479465 h True True True True False False False True True True True True 9 True True False
2 1237657607497318756 CWI 0.666666686535 h True True True True False False False True True True True True 9 True True False
3 1237666408439939282 DBSP 0.25 h False False False False True True True True True True True True 8 True True False
4 1237663277925204111 CWI 0.666666686535 h False False False False True True True True True True True True 8 True True False
5 1237666408439677694 DBSP 4.90804624557 h False False False False False False True True True True False False 4 False True False
6 1237664338780029261 None None False False False False False False False False False False False False 0 False False True
7 1237678602387521791 DBSP 0.733706891537 h True False False False False True True True True True True True 8 True True False
8 1237678602387456130 CWI 1.32078778744 h True False False False False True True True True True True True 8 True True False
9 1237678602387456305 DBSP 1.81114959717 h False False False False False True True True True True True True 7 True True False
10 1237679169841725673 CWI 3.70554494858 h False False False False False False True True True True True True 6 False True False
11 1237678881574814166 DBSP 4.6678071022 h False False False False False False False True True True True False 4 False True False
12 1237678881574944900 CWI 0.666666686535 h True False False False False False True True True True True True 7 True True False
13 1237667255616274560 CWI 0.848883509636 h True True True True True False False False True True True True 9 True True False
14 1237667255616143540 CWI 1.24120056629 h True True True True True False False False False True True True 8 True True False
15 1237667255616143515 CWI 0.666666686535 h True True True True True False False False True True True True 9 True True False
16 1237665367429677221 CWI 0.666666686535 h True True True True True False False False True True True True 9 True True False
17 1237667287812735027 CWI 0.666666686535 h True True True True True False False False True True True True 9 True True False
18 1237650372092690464 CWI 0.666666686535 h True True True True True False False False False True True True 8 True True False
19 1237674648855118180 None None False False False False False False False False False False False False 0 False False True
20 1237650762927308814 CWI 0.666666686535 h True True True True True False False False False True True True 8 True True False
21 1237655693015056396 CWI 0.666666686535 h True True True True True True True False False False False True 8 True True False
22 1237648702984683605 CWI 0.666666686535 h True True True True True True True False False False False True 8 True True False
23 1237662698115432783 DBSP 0.463996142149 h True True True True True True True True True False False True 10 True True False
24 1237662698115433445 DBSP 3.55519556999 h False True True True True True True False False False False False 6 True True False
25 1237662698115432544 CWI 0.666666686535 h True True True True True True True True True False False True 10 True True False
26 1237662224092496776 DBSP 0.60339653492 h True True True True True True True True True False False True 10 True True False
27 1237662224092364842 DBSP 0.785952448845 h True True True True True True True True True False False True 10 True True False
28 1237662662147571761 CWI 0.666666686535 h True True True True True True True True True False False True 10 True True False
29 1237662224092299404 CWI 0.666666686535 h True True True True True True True True True False False True 10 True True False
30 1237662662147310256 CWI 2.22913742065 h True True True True True True True True False False False False 8 True True False
31 1237662662147703369 DBSP 2.13304829597 h True True True True True True True True False False False False 8 True True False
32 1237680192048857102 CWI 0.666666686535 h False False False False True True True True True True True False 7 True True False
33 1237679996084617517 CWI 0.666666686535 h False False False False True True True True True True True False 7 True True False
34 1237680066954264778 CWI 0.666666686535 h False False False False True True True True True True True False 7 True True False
35 1237680066954330699 DBSP 2.00512123108 h False False False False True True True True True True True False 7 True True False
36 1237679005021831220 CWI 0.666666686535 h False False False False True True True True True True True True 8 True True False
37 1237679005021831801 DBSP 0.528947889805 h False False False False True True True True True True True True 8 True True False
38 1237678777399443498 CWI 0.666666686535 h False False False False True True True True True True True True 8 True True False
39 1237678776862572690 CWI 0.666666686535 h False False False False True True True True True True True True 8 True True False
40 1237678777399509170 CWI 4.4664812088 h False False False False False False True True True True False False 4 False True False
41 1237679005558702536 DBSP 4.05364704132 h False False False False False False True True True True False False 4 False True False
42 1237668298203202132 DBSP 1.22903943062 h True True True True True False False False False True True True 8 True True False
43 1237668298203267092 CWI 0.666666686535 h True True True True True True False False False True True True 9 True True False
44 1237668298203070473 CWI 2.80649447441 h True True True True False False False False False False True True 6 True True False
45 1237668298740007188 CWI 4.737803936 h True True True True False False False False False False False True 5 True True False
46 1237648721248845970 CWI 0.666666686535 h True True True True True True True False False False False True 8 True True False
47 1237665565541728490 CWI 0.666666686535 h True True True True True True True True False False False True 9 True True False
48 1237665566078402826 CWI 0.666666686535 h True True True True True True True True False False False True 9 True True False



In [241]:

    
good_targets = [t for t in targets if t.observing_time is not None]
observed = [False]*len(good_targets)

months_to_consider = (3, 10)
monthidxs = [list(months).index(m) for m in months_to_consider]

total_hr = 0*u.hour
nights_needed = []
for monthnum in months_to_consider:    
    if monthnum == months_to_consider[0]:
        monthidx, monthidxother = monthidxs
    else:
        monthidxother, monthidx = monthidxs
        
    hr_needed_cwi = 0*u.hour
    hr_needed_dbsp = 0*u.hour
    for i, targ in enumerate(good_targets):
        if not observed[i] and targ.time_observable[monthidx] > targ.time_observable[monthidxother]:
            observed[i] = True
            total_hr += targ.observing_time
            if targ.observable_by == 'CWI':
                hr_needed_cwi += targ.observing_time
            elif targ.observable_by == 'DBSP':
                hr_needed_dbsp += targ.observing_time
    
    nights_needed.append(((hr_needed_cwi/night_length[monthidx]).value, 
                          (hr_needed_dbsp/night_length[monthidx]).value))
if not np.all(observed):
    print('Not all observed.  Missing:', [targ.name for targ, observed in zip(good_targets, observed)])
nights_needed, total_hr









    Out[241]:





([(2.46617459824083, 0.9440027087930974),
  (1.50139210129116, 1.919853499913575)],
 <Quantity 65.46816685795784 h>)

for reference: middle of A semeseter



In [76]:

    
times = pal.midnight(Time('2017-5-1'))

planplots.plot_airmass(cwi_targets, pal, times, brightness_shading=False, 
                       style_kwargs=dict(color='b', alpha=.5))
planplots.plot_airmass(dbsp_targets, pal, times, brightness_shading=False, 
                       style_kwargs=dict(color='r', alpha=.5))
planplots.plot_airmass(none_targets, pal, times, brightness_shading=True, 
                       style_kwargs=dict(color='k', alpha=.5))
plt.ylim(2.5, 1)









    Out[76]:





(2.5, 1)

for reference: middle of B semeseter



In [77]:

    
times = pal.midnight(Time('2017-11-1'))

planplots.plot_airmass(cwi_targets, pal, times, brightness_shading=False, 
                       style_kwargs=dict(color='b', alpha=.5))
planplots.plot_airmass(dbsp_targets, pal, times, brightness_shading=False, 
                       style_kwargs=dict(color='r', alpha=.5))
planplots.plot_airmass(none_targets, pal, times, brightness_shading=True, 
                       style_kwargs=dict(color='k', alpha=.5))
plt.ylim(2.5, 1)









    Out[77]:





(2.5, 1)

Investigate H$\alpha$ vs. mags



In [144]:

    
nsa = table.Table(hosts.get_nsa())



In [289]:

    
bandtocolor = {'u':'b', 'g':'g', 'r':'r', 'i':'m', 'z':'k'}

fibmag_to_lhaflux_interp = {}
lmods = {'u':modeling.models.Linear1D(slope=-0.75, intercept=0),
         'r':modeling.models.Linear1D(slope=-0.75, intercept=0)}
lmod_ranges = {'u': (20, 22), 'r':(18,20)}

fibmags = {}
for i, bandnm in enumerate('FNugriz'):
    if bandnm in 'FN':
        continue
    fibmags[bandnm] = fibmag = 22.5-2.5*np.log10(nsa['FIBERFLUX'][:, i])
    flux = nsa['HAFLUX']*10**-17*u.erg/u.s* u.cm**-2
    
    bins_for_med = np.linspace(15,22,75)
    meds = []
    for b1, b2 in zip(bins_for_med[:-1], bins_for_med[1:]):
        msk = (b1<fibmag)&(fibmag<b2)
        lflux = np.log10(flux.value)
        if np.sum(msk&np.isfinite(lflux)) == 0:
            meds.append(None)
            stds.append(None)
        else:
            scvals = sigma_clip(lflux[msk&np.isfinite(lflux)],sigma=2)
            meds.append(np.median(scvals.compressed()))
            
    meds = np.array(meds, dtype=float)
            
    bincens = (bins_for_med[1:]+bins_for_med[:-1])/2
    fibmag_to_lhaflux_interp[bandnm] = interpolate.interp1d(bincens[np.isfinite(meds)], 
                                                    meds[np.isfinite(meds)], 
                                                    kind='quadratic')
    
    plt.figure()

    plt.hexbin(fibmag, np.log10(flux.value), extent=(15,23,-16.5,-13))
    
    plt.plot(bincens, meds, '-or')
    
    if bandnm in lmods:
        if bandnm in lmod_ranges:
            msk = (lmod_ranges[bandnm][0]<bincens)&(bincens<lmod_ranges[bandnm][1])
        else:
            msk = np.ones(len(bincens), dtype=bool)
        newmod = modeling.fitting.LevMarLSQFitter()(lmods[bandnm], bincens[msk], meds[msk])
        lmods[bandnm] = newmod
        x = np.linspace(15, 23, 100)
        plt.plot(x, newmod(x),'k')
    
    #plt.scatter(fibmag, np.log10(flux.value), lw=0, alpha=.04, s=3, c=bandtocolor[bandnm])
    plt.xlim(15,23)
    plt.xlabel(bandnm, fontsize=24)
    plt.ylabel(r'$\log({\rm H}\alpha)$ flux', fontsize=24)
    plt.ylim(-16.5,-13)









    



/Users/erik/miniconda3/envs/saga/lib/python2.7/site-packages/ipykernel/__main__.py:12: RuntimeWarning: divide by zero encountered in log10
/Users/erik/miniconda3/envs/saga/lib/python2.7/site-packages/ipykernel/__main__.py:12: RuntimeWarning: invalid value encountered in log10
/Users/erik/miniconda3/envs/saga/lib/python2.7/site-packages/ipykernel/__main__.py:18: RuntimeWarning: invalid value encountered in greater
/Users/erik/miniconda3/envs/saga/lib/python2.7/site-packages/ipykernel/__main__.py:18: RuntimeWarning: invalid value encountered in less
/Users/erik/miniconda3/envs/saga/lib/python2.7/site-packages/ipykernel/__main__.py:19: RuntimeWarning: divide by zero encountered in log10
/Users/erik/miniconda3/envs/saga/lib/python2.7/site-packages/ipykernel/__main__.py:19: RuntimeWarning: invalid value encountered in log10
/Users/erik/miniconda3/envs/saga/lib/python2.7/site-packages/ipykernel/__main__.py:36: RuntimeWarning: divide by zero encountered in log10
/Users/erik/miniconda3/envs/saga/lib/python2.7/site-packages/ipykernel/__main__.py:36: RuntimeWarning: invalid value encountered in log10

Check that the two approaches give at least reasonably compatible-ish answers



In [299]:

    
uflux = 10**lmods['u'](fibmags['u'])
rflux = 10**lmods['r'](fibmags['r'])

plt.hexbin(fibmags['r'], (uflux - rflux)/uflux, extent=(15, 23, -1, 1))









    



/Users/erik/miniconda3/envs/saga/lib/python2.7/site-packages/ipykernel/__main__.py:4: RuntimeWarning: divide by zero encountered in true_divide
/Users/erik/miniconda3/envs/saga/lib/python2.7/site-packages/ipykernel/__main__.py:4: RuntimeWarning: invalid value encountered in true_divide






    Out[299]:





<matplotlib.collections.PolyCollection at 0x1398cbe10>



In [257]:

    
lmods









    Out[257]:





{'r': <Linear1D(slope=-0.5074828822006762, intercept=-5.115944337314049)>,
 'u': <Linear1D(slope=-0.544699254858693, intercept=-3.466572610994288)>}

RA	DEC	ZQUALITY	FIBERMAG_R	r
float64	float64	int64	float32	float32
149.687168865	32.7202654623	3	22.283	20.6923
180.636494306	1.95802947978	4	22.6497	18.6728
353.778805283	0.301058523211	3	21.9254	21.3615
248.58079685	19.7200349023	3	21.473	19.4478
248.16342684	19.792207594	4	21.7503	20.4952
335.953849494	-3.70119481833	4	21.4394	19.6137
39.5361613388	-1.39669557972	3	21.8981	20.1799
180.419076868	-1.20276655787	3	22.2339	21.8131
348.554591739	4.91500326962	4	21.8215	20.8844
20.3284666123	17.7539390491	4	21.3842	19.8126
...	...	...	...	...
123.243173206	36.198359966	4	18.669	15.5962
348.776907636	4.373197012	4	18.007	15.7936
158.04324634	28.4830569538	4	17.8647	15.2572
348.696648891	4.63995487019	4	18.2763	15.1461
180.29544216	-1.2976838319	4	18.1215	13.5133
248.393225697	19.9461400824	4	17.5609	15.8096
225.005401226	-1.09130226734	4	17.9322	14.9987
182.990666509	20.0278486922	4	17.1539	14.4876
348.643816258	4.4984434911	4	16.5174	12.8953
157.778274298	28.7966447953	4	15.5412	12.9873

idx	name	instrument	time	2	3	4	5	6	7	8	9	10	11	12	1	nmonths	A	B	none_target
0	1237651735757259099	None	None	False	False	False	False	False	False	False	False	False	False	False	False	0	False	False	True
1	1237657607497515484	CWI	1.04944479465 h	True	True	True	True	False	False	False	True	True	True	True	True	9	True	True	False
2	1237657607497318756	CWI	0.666666686535 h	True	True	True	True	False	False	False	True	True	True	True	True	9	True	True	False
3	1237666408439939282	DBSP	0.25 h	False	False	False	False	True	True	True	True	True	True	True	True	8	True	True	False
4	1237663277925204111	CWI	0.666666686535 h	False	False	False	False	True	True	True	True	True	True	True	True	8	True	True	False
5	1237666408439677694	DBSP	4.90804624557 h	False	False	False	False	False	False	True	True	True	True	False	False	4	False	True	False
6	1237664338780029261	None	None	False	False	False	False	False	False	False	False	False	False	False	False	0	False	False	True
7	1237678602387521791	DBSP	0.733706891537 h	True	False	False	False	False	True	True	True	True	True	True	True	8	True	True	False
8	1237678602387456130	CWI	1.32078778744 h	True	False	False	False	False	True	True	True	True	True	True	True	8	True	True	False
9	1237678602387456305	DBSP	1.81114959717 h	False	False	False	False	False	True	True	True	True	True	True	True	7	True	True	False
10	1237679169841725673	CWI	3.70554494858 h	False	False	False	False	False	False	True	True	True	True	True	True	6	False	True	False
11	1237678881574814166	DBSP	4.6678071022 h	False	False	False	False	False	False	False	True	True	True	True	False	4	False	True	False
12	1237678881574944900	CWI	0.666666686535 h	True	False	False	False	False	False	True	True	True	True	True	True	7	True	True	False
13	1237667255616274560	CWI	0.848883509636 h	True	True	True	True	True	False	False	False	True	True	True	True	9	True	True	False
14	1237667255616143540	CWI	1.24120056629 h	True	True	True	True	True	False	False	False	False	True	True	True	8	True	True	False
15	1237667255616143515	CWI	0.666666686535 h	True	True	True	True	True	False	False	False	True	True	True	True	9	True	True	False
16	1237665367429677221	CWI	0.666666686535 h	True	True	True	True	True	False	False	False	True	True	True	True	9	True	True	False
17	1237667287812735027	CWI	0.666666686535 h	True	True	True	True	True	False	False	False	True	True	True	True	9	True	True	False
18	1237650372092690464	CWI	0.666666686535 h	True	True	True	True	True	False	False	False	False	True	True	True	8	True	True	False
19	1237674648855118180	None	None	False	False	False	False	False	False	False	False	False	False	False	False	0	False	False	True
20	1237650762927308814	CWI	0.666666686535 h	True	True	True	True	True	False	False	False	False	True	True	True	8	True	True	False
21	1237655693015056396	CWI	0.666666686535 h	True	True	True	True	True	True	True	False	False	False	False	True	8	True	True	False
22	1237648702984683605	CWI	0.666666686535 h	True	True	True	True	True	True	True	False	False	False	False	True	8	True	True	False
23	1237662698115432783	DBSP	0.463996142149 h	True	True	True	True	True	True	True	True	True	False	False	True	10	True	True	False
24	1237662698115433445	DBSP	3.55519556999 h	False	True	True	True	True	True	True	False	False	False	False	False	6	True	True	False
25	1237662698115432544	CWI	0.666666686535 h	True	True	True	True	True	True	True	True	True	False	False	True	10	True	True	False
26	1237662224092496776	DBSP	0.60339653492 h	True	True	True	True	True	True	True	True	True	False	False	True	10	True	True	False
27	1237662224092364842	DBSP	0.785952448845 h	True	True	True	True	True	True	True	True	True	False	False	True	10	True	True	False
28	1237662662147571761	CWI	0.666666686535 h	True	True	True	True	True	True	True	True	True	False	False	True	10	True	True	False
29	1237662224092299404	CWI	0.666666686535 h	True	True	True	True	True	True	True	True	True	False	False	True	10	True	True	False
30	1237662662147310256	CWI	2.22913742065 h	True	True	True	True	True	True	True	True	False	False	False	False	8	True	True	False
31	1237662662147703369	DBSP	2.13304829597 h	True	True	True	True	True	True	True	True	False	False	False	False	8	True	True	False
32	1237680192048857102	CWI	0.666666686535 h	False	False	False	False	True	True	True	True	True	True	True	False	7	True	True	False
33	1237679996084617517	CWI	0.666666686535 h	False	False	False	False	True	True	True	True	True	True	True	False	7	True	True	False
34	1237680066954264778	CWI	0.666666686535 h	False	False	False	False	True	True	True	True	True	True	True	False	7	True	True	False
35	1237680066954330699	DBSP	2.00512123108 h	False	False	False	False	True	True	True	True	True	True	True	False	7	True	True	False
36	1237679005021831220	CWI	0.666666686535 h	False	False	False	False	True	True	True	True	True	True	True	True	8	True	True	False
37	1237679005021831801	DBSP	0.528947889805 h	False	False	False	False	True	True	True	True	True	True	True	True	8	True	True	False
38	1237678777399443498	CWI	0.666666686535 h	False	False	False	False	True	True	True	True	True	True	True	True	8	True	True	False
39	1237678776862572690	CWI	0.666666686535 h	False	False	False	False	True	True	True	True	True	True	True	True	8	True	True	False
40	1237678777399509170	CWI	4.4664812088 h	False	False	False	False	False	False	True	True	True	True	False	False	4	False	True	False
41	1237679005558702536	DBSP	4.05364704132 h	False	False	False	False	False	False	True	True	True	True	False	False	4	False	True	False
42	1237668298203202132	DBSP	1.22903943062 h	True	True	True	True	True	False	False	False	False	True	True	True	8	True	True	False
43	1237668298203267092	CWI	0.666666686535 h	True	True	True	True	True	True	False	False	False	True	True	True	9	True	True	False
44	1237668298203070473	CWI	2.80649447441 h	True	True	True	True	False	False	False	False	False	False	True	True	6	True	True	False
45	1237668298740007188	CWI	4.737803936 h	True	True	True	True	False	False	False	False	False	False	False	True	5	True	True	False
46	1237648721248845970	CWI	0.666666686535 h	True	True	True	True	True	True	True	False	False	False	False	True	8	True	True	False
47	1237665565541728490	CWI	0.666666686535 h	True	True	True	True	True	True	True	True	False	False	False	True	9	True	True	False
48	1237665566078402826	CWI	0.666666686535 h	True	True	True	True	True	True	True	True	False	False	False	True	9	True	True	False