metadata: contig_metadata: 8 rows where bioproject = "PRJNA908278", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA908278", 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_genus	tax_species
9818167	9818167	PRJNA908278_P_NODE_24708_length_260_cov_1.962567_g24605_i0	PRJNA908278	24708	260	1.962567	5.1026742	Proleptomonas faecicola	149084	SAR_Eukaryotes	SAR_Eukaryotes	281	2.78e-71	NTclustered	gi\|302026150\|gb\|GQ377654.1\|	149084	g24605	i0	86.381	100.230769230769	257	35	99	0	4	260	1188	932	Proleptomonas faecicola beta-tubulin (Btub) gene, partial cds	blastn	26060	281	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Proleptomonas	Proleptomonas faecicola
26707533	26707533	PRJNA908278_P_NODE_30941_length_246_cov_0.890173_g30838_i0	PRJNA908278	30941	246	0.890173	2.18982558	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	54.7	3.84e-7	NR	MES1913255.1	1215613	g30838	i0	51	0.621951219512195	51	24	61	1	155	6	31	81	MES1913255.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	153	54.7	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
27474296	27474296	PRJNA908278_P_NODE_11863_length_357_cov_2.218310_g11760_i0	PRJNA908278	11863	357	2.21831	7.9193667	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	145	2.72e-41	NR	ACF24579.1	67809	g11760	i0	64.9	8.5546218487395	114	39	95.8	1	7	348	1	113	ACF24579.1 40S ribosomal protein S9 [Gymnochlora stellata]	diamond	3054	145	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae		Gymnochlora	Gymnochlora stellata
28516305	28516305	PRJNA908278_P_NODE_32427_length_244_cov_1.467836_g32324_i0	PRJNA908278	32427	244	1.467836	3.58151984	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	81.6	6.71e-16	NR	MES1909875.1	1215613	g32324	i0	42.7	2.76639344262295	82	37	88.5	1	244	29	253	334	MES1909875.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	675	81.6	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
29929823	29929823	PRJNA908278_P_NODE_28971_length_248_cov_1.320000_g28868_i0	PRJNA908278	28971	248	1.32	3.2736	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	70.1	8.58e-13	NR	MES1909107.1	1215613	g28868	i0	59.6	0.629032258064516	52	21	62.9	0	240	85	53	104	MES1909107.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	156	70.1	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
30435420	30435420	PRJNA908278_P_NODE_29153_length_248_cov_0.880000_g29050_i0	PRJNA908278	29153	248	0.88	2.1824	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	76.6	1.3e-14	NR	MES1916707.1	1215613	g29050	i0	52.2	0.810483870967742	67	32	81	0	35	235	180	246	MES1916707.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	201	76.6	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
32086612	32086612	PRJNA908278_P_NODE_4598_length_539_cov_1.596567_g4495_i0	PRJNA908278	4598	539	1.596567	8.60549613	root	1	Root_unresolved	Root_unresolved	167	7.7e-48	NR	MES1915219.1	1215613	g4495	i0	59.3	3.1113172541744	135	52	73.5	1	144	539	15	149	MES1915219.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	1677	167	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
32364104	32364104	PRJNA908278_P_NODE_6879_length_450_cov_0.782493_g6776_i0	PRJNA908278	6879	450	0.782493	3.5212185	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	70.9	9.95e-12	NR	MES1909766.1	1215613	g6776	i0	39.4	0.66	99	55	64.7	3	440	150	41	136	MES1909766.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	297	70.9	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);;