Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PNC2012 protist biodiversity from IOPAN to Darwin Core #54

Open
cnrdh opened this issue Oct 15, 2021 · 2 comments
Open

PNC2012 protist biodiversity from IOPAN to Darwin Core #54

cnrdh opened this issue Oct 15, 2021 · 2 comments
Assignees

Comments

@cnrdh
Copy link
Member

cnrdh commented Oct 15, 2021

41 data/deposit/iopan/protist-biodiversity/pnc2012-protist-biodiversity.tsv
@cnrdh
Copy link
Member Author

cnrdh commented Oct 27, 2021

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
Copy link
Member Author

cnrdh commented Oct 28, 2021

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]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant