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

8 rows where bioproject = "PRJNA752572", 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
9657059	9657059	PRJNA752572_P_NODE_167888_length_206_cov_1.865497_g167381_i0	PRJNA752572	167888	206	1.865497	3.84292382	Paracercomonas marina	372086	SAR_Eukaryotes	SAR_Eukaryotes	359	9.47e-95	NTclustered	gi\|88792583\|gb\|DQ386164.1\|	372086	g167381	i0	98.058	171.383495145631	206	4	100	0	1	206	2707	2502	Paracercomonas marina 28S ribosomal RNA gene, partial sequence	blastn	35305	359	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Paracercomonas	Paracercomonas marina
9657064	9657064	PRJNA752572_P_NODE_197908_length_189_cov_1.844156_g197401_i0	PRJNA752572	197908	189	1.844156	3.48545484	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	76.6	3.26e-16	NR	ACF24578.1	67809	g197401	i0	66.7	2.44444444444444	51	17	81	0	157	5	1	51	ACF24578.1 60S ribosomal protein L34 [Gymnochlora stellata]	diamond	462	76.6	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata
19855645	19855645	PRJNA752572_P_NODE_126996_length_238_cov_1.812808_g126489_i0	PRJNA752572	126996	238	1.812808	4.31448304	Paracercomonas marina	372086	SAR_Eukaryotes	SAR_Eukaryotes	429	8.45e-116	NTclustered	gi\|88792583\|gb\|DQ386164.1\|	372086	g126489	i0	99.16	95.7941176470588	238	2	100	0	1	238	1704	1941	Paracercomonas marina 28S ribosomal RNA gene, partial sequence	blastn	22799	429	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Paracercomonas	Paracercomonas marina
21131127	21131127	PRJNA752572_P_NODE_102797_length_266_cov_2.290043_g102290_i0	PRJNA752572	102797	266	2.290043	6.09151438	Cercomonas sp. HFCC549	458874	SAR_Eukaryotes	SAR_Eukaryotes	475	1.2199999999999997e-129	NTclustered	gi\|161015714\|gb\|EF681948.1\|	458874	g102290	i0	98.872	17.218045112782	266	3	100	0	1	266	321	586	Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence	blastn	4580	475	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Cercomonas	Cercomonas sp. HFCC549
21131175	21131175	PRJNA752572_P_NODE_222457_length_178_cov_1.097902_g221950_i0	PRJNA752572	222457	178	1.097902	1.95426556	Bigelowiella natans	227086	SAR_Eukaryotes	SAR_Eukaryotes	55.1	2.16e-7	NR	AAT09077.1	227086	g221950	i0	62.2	0.758426966292135	45	16	75.8	1	142	8	1	44	AAT09077.1 transcription factor BTF3 [Bigelowiella natans]	diamond	135	55.1	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
27179095	27179095	PRJNA752572_P_NODE_143702_length_223_cov_2.335106_g143195_i0	PRJNA752572	143702	223	2.335106	5.20728638	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	64.7	5.05e-10	NR	MES1915879.1	1215613	g143195	i0	40.8	1.9103139013452901	71	42	95.5	0	223	11	186	256	MES1915879.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	426	64.7	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
30432430	30432430	PRJNA752572_P_NODE_98833_length_272_cov_1.438819_g98326_i0	PRJNA752572	98833	272	1.438819	3.91358768	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	65.9	2.55e-10	NR	MES1912506.1	1215613	g98326	i0	37.8	1.80882352941176	74	46	81.6	0	264	43	25	98	MES1912506.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	492	65.9	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
31189926	31189926	PRJNA752572_P_NODE_255335_length_167_cov_1.515152_g254828_i0	PRJNA752572	255335	167	1.515152	2.53030384	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	72.4	5.93e-14	NR	MES1913565.1	1215613	g254828	i0	75	3.52095808383234	44	11	79	0	33	164	5	48	MES1913565.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	588	72.4	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);;