search

npolar / marine-db

https://doi.org/10.21334/marine-db
0 stars 0 forks source link

PNC2012 protist biodiversity from IOPAN to Darwin Core #54

Open cnrdh opened 2 years ago

cnrdh commented 2 years ago 
41 data/deposit/iopan/protist-biodiversity/pnc2012-protist-biodiversity.tsv
cnrdh commented 2 years ago 

expedition  fieldNumber locality    depth [m]   data    V chamber   Vth filtered [L]    Vbot[ml]    class   scientificName  taxonRemarks    N   fields  K   cells in chamb  cells in 1000 ml    eventRemarks    verbatimScientificName
PNC2012     Sofiadypet  15  2012-01-14  10  60  200 Bacillariophyceae   Thalassiosira sp.       5   100 321.61  16.0805 53.6016666666667        
PNC2012     Sofiadypet  15  2012-01-14  10  60  200 Peridinea   Torodinium robustum     2   100 321.61  6.4322  21.4406666666667        
PNC2012     Sofiadypet  15  2012-01-14  10  60  200 Peridinea   Neoceratium fusus       1   100 321.61  3.2161  10.7203333333333        
PNC2012     Sofiadypet  15  2012-01-14  10  60  200 Peridinea   Neoceratium arcticum        1   100 321.61  3.2161  10.7203333333333        
PNC2012     Sofiadypet  15  2012-01-14  10  60  200 Peridinea   Peridinea cysts     2   98  4407.47 89.9483673469388    299.827891156463        
PNC2012     Sofiadypet  15  2012-01-14  10  60  200 Peridinea   Gymnodinium galeatum        1   98  4407.47 44.9741836734694    149.913945578231        
PNC2012     Rijpfjorden 35  2012-01-12  10  60  200 Peridinea   Dinophysis rotundata        3   94  321.61  10.2641489361702    34.213829787234     
PNC2012     Rijpfjorden 35  2012-01-12  10  60  200 Peridinea   Peridinea non det.thecate 10-20 thecate 10-20   5   94  321.61  17.106914893617 57.0230496453901        
PNC2012     Rijpfjorden 35  2012-01-12  10  60  200 Bacillariophyceae   Thalassiosira sp.       2   94  321.61  6.84276595744681    22.809219858156     
PNC2012     Rijpfjorden 35  2012-01-12  10  60  200 Peridinea   Gymnodinium galeatum        1   104 4407.47 42.3795192307692    141.265064102564        
PNC2012     Rijpfjorden 0   2012-01-12  10  60  200 Peridinea   Protoperidinium cerasus     1   120 321.61  2.68008333333333    8.93361111111111        
PNC2012     Rijpfjorden 0   2012-01-12  10  60  200 Peridinea   Dinophysis rotundata        1   120 321.61  2.68008333333333    8.93361111111111        
PNC2012     Rijpfjorden 0   2012-01-12  10  60  200 Peridinea   Gymnodiniales 40-50um   40-50   1   120 321.61  2.68008333333333    8.93361111111111        
PNC2012     Rijpfjorden 0   2012-01-12  10  60  200 Peridinea   Gymnodinium sp.5-10 5-10    1   128 4407.47 34.433359375    114.777864583333        
PNC2012     Rijpfjorden 0   2012-01-12  10  60  200 Peridinea   Peridinea non det.thecate 20-30 thecate 20-30   1   128 4407.47 34.433359375    114.777864583333        
PNC2012     Rijpfjorden 0   2012-01-12  10  60  200 Peridinea   Gymnodinium sp.20-30    20-30   1   128 4407.47 34.433359375    114.777864583333        
PNC2012     Sofiadypet  150 2012-01-14  10  60  200 Bacillariophyceae   Thalassiosira sp.       1   127 321.61  2.53236220472441    8.44120734908137        
PNC2012     Sofiadypet  150 2012-01-14  10  60  200 Prymnesiophyceae    Coccolithus pelagicus       2   108 4407.47 81.6198148148148    272.066049382716        
PNC2012     Sofiadypet  150 2012-01-14  10  60  200 Peridinea   Pronoctiluca pelagica       1   108 4407.47 40.8099074074074    136.033024691358        
PNC2012     Sofiadypet  150 2012-01-14  10  60  200 Dictyochophyceae    Dictyocha speculum      1   108 4407.47 40.8099074074074    136.033024691358        
PNC2012     Rijpfjorden     2012-01-12  10  60  200 Bacillariophyceae   Gyrosigma fasciola      1   100 4407.47 44.0747 146.915666666667    Sampled at bottom   
PNC2012     Rijpfjorden     2012-01-12  10  60  200 Peridinea   Peridinea cysts     1   100 4407.47 44.0747 146.915666666667    Sampled at bottom   
PNC2012     Rijpfjorden 35  2012-01-12  50  1   1000    Peridinea   Peridinea cysts     2   83  321.61  7.74963855421687    7749.63855421687        
PNC2012     Rijpfjorden 35  2012-01-12  50  1   1000    Peridinea   Gymnodinium sp.cf wulffii   cf wulffii  2   89  4407.47 99.0442696629214    99044.2696629214        
PNC2012     Rijpfjorden 35  2012-01-12  50  1   1000    Dictyochophyceae    Dictyocha speculum      1   89  4407.47 49.5221348314607    49522.1348314607        
PNC2012     Rijpfjorden 35  2012-01-12  50  1   1000    Bacillariophyceae   Pseudo-nitzschia sp.        1   89  4407.47 49.5221348314607    49522.1348314607        
PNC2012     Rijpfjorden 15  2012-01-12  50  1   1000    Peridinea   Neoceratium arcticum        1   103 321.61  3.12242718446602    3122.42718446602        
PNC2012     Sofiadypet  5   2012-01-14  50  1   1000    Bacillariophyceae   Thalassiosira sp.cf angulata    cf angulata 2   112 321.61  5.74303571428571    5743.03571428571        
PNC2012     Sofiadypet  5   2012-01-14  50  1   1000    Bacillariophyceae   Nitzschia sp.30-40  30-40   3   107 4407.47 123.573925233645    123573.925233645        
PNC2012     Sofiadypet  5   2012-01-14  50  1   1000    Peridinea   Gymnodinium sp.cf wulffii   cf wulffii  2   107 4407.47 82.3826168224299    82382.6168224299        
PNC2012     Sofiadypet  5   2012-01-14  50  1   1000    Peridinea   Gymnodinium sp.10-20    10-20   2   107 4407.47 82.3826168224299    82382.6168224299        
PNC2012     Sofiadypet  5   2012-01-14  50  1   1000    Bacillariophyceae   Pseudo-nitzschia pseudodelicatissima        2   107 4407.47 82.3826168224299    82382.6168224299        Pseudonitzschia pseudodelicatissima
PNC2012     Sofiadypet  0   2012-01-12  50  1   1000    Peridinea   Protoperidinium pellucidum      1   83  321.61  3.87481927710843    3874.81927710843        
PNC2012     Sofiadypet  0   2012-01-12  50  1   1000    Bacillariophyceae   Thalassiosira sp.cf angulata    cf angulata 1   83  321.61  3.87481927710843    3874.81927710843        
PNC2012     Sofiadypet  0   2012-01-12  50  1   1000    Peridinea   Gymnodinium galeatum        1   95  4407.47 46.3944210526316    46394.4210526316        
PNC2012     Sofiadypet  75  2012-01-14  50  1   1000    Bacillariophyceae   Thalassiosira sp.10-20  10-20   1   93  4407.47 47.3921505376344    47392.1505376344        
PNC2012     Rijpfjorden 75  2012-01-12  50  1   1000    Peridinea   Dinophysis rotundata        1   94  321.61  3.4213829787234 3421.3829787234     
PNC2012     Rijpfjorden 75  2012-01-12  50  1   1000    Peridinea   Gymnodinium sp.10-20    10-20   1   99  4407.47 44.519898989899 44519.898989899     
PNC2012     Sofiadypet  15  2012-01-14  50  1   1000    Bacillariophyceae   Thalassiosira sp.       2   87  321.61  7.39333333333333    7393.33333333333        
PNC2012     Rijpfjorden 0   2012-01-12  50  1   1000    Peridinea   Gymnodinium wulffii     1   113 4407.47 39.0041592920354    39004.1592920354
cnrdh commented 2 years ago

Hmm, as seen above data has no fieldNumber just location (and date/depth) And depths and sample types are wrong


~/npolar/marine-db$ cat $samples | ndjson-filter 'd.eventDate.startsWith("2012-01-14")' | ndjson-map '[d.gear,d.sampletype]' | sort | uniq -c
     11 ["Multinet 200 µm","Lipids"]
      3 ["Ship CTD","CTD"]

$ cat $samples | ndjson-filter 'd.eventDate.startsWith("2012-01-14")' | ndjson-map '[d.maximumDepthInMeters,d.minimumDepthInMeters]' | sort -nr
[900,600]
[600,300]
[600,200]
[500,0]
[500,0]
[500,0]
[50,0]
[300,50]
[2000,600]
[2000,1800]
[1800,1600]
[1600,1400]
[1400,1200]
[1200,900]