metadata: contig_metadata: 9 rows where bioproject = "PRJNA670521", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA670521", 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
9566738	9566738	PRJNA670521_P_NODE_50568_length_294_cov_1.742081_g49823_i0	PRJNA670521	50568	294	1.742081	5.12171814	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	544	3.69e-150	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g49823	i0	100	61.6938775510204	294	0	100	0	1	294	1949	1656	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	18138	544	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
15941107	15941107	PRJNA670521_P_NODE_76013_length_249_cov_0.875000_g75268_i0	PRJNA670521	76013	249	0.875	2.17875	Bigelowiella natans	227086	SAR_Eukaryotes	SAR_Eukaryotes	110	9.33e-29	NR	AAT09077.1	227086	g75268	i0	66.7	0.939759036144578	78	26	94	0	236	3	3	80	AAT09077.1 transcription factor BTF3 [Bigelowiella natans]	diamond	234	110	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
21566983	21566983	PRJNA670521_P_NODE_12797_length_508_cov_1.048276_g12060_i0	PRJNA670521	12797	508	1.048276	5.32524208	Paulinella	39716	SAR_Eukaryotes	SAR_Eukaryotes	166	7.45e-46	NR	BAJ14650.1	39717	g12060	i0	70.5	9.85629921259843	112	33	66.1	0	1	336	318	429	BAJ14650.1 elongation factor 1alpha, partial [Paulinella chromatophora]	diamond	5007	167	0.994011976047904	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Paulinellidae	Paulinella	Paulinella chromatophora
27081697	27081697	PRJNA670521_P_NODE_66482_length_258_cov_4.162162_g65737_i0	PRJNA670521	66482	258	4.162162	10.73837796	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	72.8	6.58e-13	NR	MES1907752.1	1215613	g65737	i0	47.4	0.883720930232558	76	39	88.4	1	31	258	3	77	MES1907752.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	228	72.8	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
27315077	27315077	PRJNA670521_P_NODE_45763_length_307_cov_0.987179_g45018_i0	PRJNA670521	45763	307	0.987179	3.03063953	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	72.8	7.59e-13	NR	MES1907754.1	1215613	g45018	i0	41	2.90228013029316	100	58	96.7	1	1	297	107	206	MES1907754.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	891	72.8	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
28344965	28344965	PRJNA670521_P_NODE_63026_length_266_cov_1.321244_g62281_i0	PRJNA670521	63026	266	1.321244	3.51450904	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	138	2.8200000000000002e-36	NR	MES1910324.1	1215613	g62281	i0	67.9	0.947368421052632	84	27	94.7	0	264	13	241	324	MES1910324.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	252	138	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
29682733	29682733	PRJNA670521_P_NODE_9190_length_589_cov_1.718992_g8459_i0	PRJNA670521	9190	589	1.718992	10.12486288	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	133	9.29e-35	NR	MES1907754.1	1215613	g8459	i0	38.2	3.7741935483871	186	115	94.7	0	559	2	41	226	MES1907754.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	2223	134	0.992537313432836	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
31409002	31409002	PRJNA670521_P_NODE_91036_length_242_cov_0.911243_g90291_i0	PRJNA670521	91036	242	0.911243	2.20520806	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	84.3	1.85e-17	NR	ADK26624.1	323453	g90291	i0	70.4	0.669421487603306	54	16	66.9	0	240	79	223	276	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	162	84.3	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
31472337	31472337	PRJNA670521_P_NODE_3576_length_925_cov_2.372066_g2990_i0	PRJNA670521	3576	925	2.372066	21.9416105	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	118	6.52e-26	NR	MES1907148.1	1215613	g2990	i0	30.8	0.989189189189189	305	188	95	12	919	41	214	507	MES1907148.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	915	118	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);;