metadata: contig_metadata: 11 rows where bioproject = "PRJEB50332", tax_clade = "Sar" and tax

11 rows where bioproject = "PRJEB50332", tax_clade = "Sar" and tax_phylum = "Cercozoa"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1393790	1393790	PRJEB50332_P_NODE_13642_length_209_cov_0.878378_g13560_i0	PRJEB50332	13642	209	0.878378	1.83581002	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	122	3.729999999999999e-32	NR	ADK26624.1	323453	g13560	i0	83.8	0.976076555023923	68	11	97.6	0	206	3	127	194	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	204	122	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
1393872	1393872	PRJEB50332_P_NODE_4342_length_287_cov_1.646018_g4260_i0	PRJEB50332	4342	287	1.646018	4.72407166	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	475	1.3299999999999996e-129	NTclustered	gi\|300676732\|gb\|GQ377662.1\|	188950	g4260	i0	96.516	99.0592334494773	287	10	100	0	1	287	792	1078	Bodomorpha minima alpha-tubulin (Atub) gene, partial cds	blastn	28430	475	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
6497585	6497585	PRJEB50332_P_NODE_106_length_1444_cov_4.083153_g48_i1	PRJEB50332	106	1444	4.083153	58.96072932	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	587	5.5e-206	NR	MES1909605.1	1215613	g48	i1	75.3	3.95775623268698	373	92	77.5	0	1	1119	61	433	MES1909605.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	5715	590	0.994915254237288	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
7771871	7771871	PRJEB50332_P_NODE_3387_length_316_cov_2.196078_g3305_i0	PRJEB50332	3387	316	2.196078	6.93960648	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	241	5.88e-59	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g3305	i0	81.447	38.25	318	37	100	15	1	316	4021	3724	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	12087	241	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
11597832	11597832	PRJEB50332_P_NODE_70_length_1612_cov_4.576402_g48_i0	PRJEB50332	70	1612	4.576402	73.77160024	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	587	4.419999999999999e-205	NR	MES1909605.1	1215613	g48	i0	75.3	3.54528535980149	373	92	69.4	0	1	1119	61	433	MES1909605.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	5715	591	0.993231810490694	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
12873037	12873037	PRJEB50332_P_NODE_9451_length_227_cov_1.951807_g9369_i0	PRJEB50332	9451	227	1.951807	4.43060189	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	387	4.88e-103	NTclustered	gi\|238617630\|gb\|FJ973394.1\|	188950	g9369	i0	97.357	80.3392070484581	227	6	100	0	1	227	597	371	Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds	blastn	18237	387	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
14147820	14147820	PRJEB50332_P_NODE_6072_length_252_cov_2.560209_g5990_i0	PRJEB50332	6072	252	2.560209	6.45172668	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	460	3.2e-125	NTclustered	gi\|300676732\|gb\|GQ377662.1\|	188950	g5990	i0	99.603	25.1587301587302	252	1	100	0	1	252	590	339	Bodomorpha minima alpha-tubulin (Atub) gene, partial cds	blastn	6340	460	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
21796116	21796116	PRJEB50332_P_NODE_1458_length_457_cov_1.982323_g1377_i0	PRJEB50332	1458	457	1.982323	9.05921611	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	774	0	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g1377	i0	97.368	22.781181619256	456	10	99	2	1	454	328	783	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	10411	774	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
26938446	26938446	PRJEB50332_P_NODE_1042_length_531_cov_1.761702_g962_i0	PRJEB50332	1042	531	1.761702	9.35463762	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	229	5.929999999999999e-72	NR	MES1911029.1	1215613	g962	i0	65.7	3.02824858757062	178	56	97.7	3	4	522	42	219	MES1911029.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	1608	229	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
27570629	27570629	PRJEB50332_P_NODE_1184_length_500_cov_2.528474_g1103_i0	PRJEB50332	1184	500	2.528474	12.64237	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	60.1	9.11e-8	NR	MES1913617.1	1215613	g1103	i0	43.7	0.426	71	39	42.6	1	70	282	104	173	MES1913617.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	213	60.1	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
31202106	31202106	PRJEB50332_P_NODE_16215_length_205_cov_0.902778_g16133_i0	PRJEB50332	16215	205	0.902778	1.8506949	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	44.3	0.00636	NR	MES1911702.1	1215613	g16133	i0	29.9	0.980487804878049	67	47	98	0	203	3	389	455	MES1911702.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	201	44.3	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;