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

9 rows where bioproject = "PRJNA795983", 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
779958	779958	PRJNA795983_S_NODE_14661_length_340_cov_1.355805_g14536_i0	PRJNA795983	14661	340	1.355805	4.609737	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	623	5.429999999999999e-174	NTclustered	gi\|197723521\|gb\|EF681900.2\|	458884	g14536	i0	99.706	27.7470588235294	340	1	100	0	1	340	257	596	Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence	blastn	9434	623	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
7158685	7158685	PRJNA795983_S_NODE_44766_length_223_cov_4.920000_g44641_i0	PRJNA795983	44766	223	4.92	10.9716	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	99	2.51e-16	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g44641	i0	98.214	18.5874439461883	56	1	25	0	168	223	3839	3784	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	4145	99	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
12259803	12259803	PRJNA795983_S_NODE_6970_length_444_cov_1.447439_g6845_i0	PRJNA795983	6970	444	1.447439	6.42662916	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	216	2.54e-67	NR	MES1911029.1	1215613	g6845	i0	71.2	6.98648648648649	146	42	98.6	0	442	5	29	174	MES1911029.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	3102	216	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
16082793	16082793	PRJNA795983_S_NODE_5953_length_469_cov_1.790404_g5828_i0	PRJNA795983	5953	469	1.790404	8.39699476	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	183	1.54e-54	NR	MES1907458.1	1215613	g5828	i0	70.1	1.727078891258	127	38	81.2	0	381	1	4	130	MES1907458.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	810	183	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
17358420	17358420	PRJNA795983_S_NODE_23414_length_291_cov_5.229358_g23289_i0	PRJNA795983	23414	291	5.229358	15.21743178	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	361	3.939999999999999e-95	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g23289	i0	90.809	87.2164948453608	272	21	93	2	22	291	1084	1353	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	25380	361	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
24168132	24168132	PRJNA795983_S_NODE_44619_length_226_cov_3.372549_g44494_i0	PRJNA795983	44619	226	3.372549	7.62196074	Bodomorpha	188949	SAR_Eukaryotes	SAR_Eukaryotes	418	1.7199999999999998e-112	NTclustered	gi\|225216798\|gb\|FJ176713.1\|	458884	g44494	i0	100	101.70796460177	226	0	100	0	1	226	119	344	Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence	blastn	22986	418	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
25006572	25006572	PRJNA795983_S_NODE_32980_length_258_cov_4.086486_g32855_i0	PRJNA795983	32980	258	4.086486	10.54313388	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	459	1.18e-124	NTclustered	gi\|197723521\|gb\|EF681900.2\|	458884	g32855	i0	100	99.1317829457364	248	0	96	0	11	258	1	248	Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence	blastn	25576	459	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
26642244	26642244	PRJNA795983_S_NODE_36521_length_250_cov_0.870056_g36396_i0	PRJNA795983	36521	250	0.870056	2.17514	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	59.3	6.06e-8	NR	MES1911981.1	1215613	g36396	i0	36.5	0.888	74	47	88.8	0	241	20	938	1011	MES1911981.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	222	59.3	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
27306809	27306809	PRJNA795983_S_NODE_11383_length_371_cov_1.446309_g11258_i0	PRJNA795983	11383	371	1.446309	5.36580639	Bigelowiella natans	227086	SAR_Eukaryotes	SAR_Eukaryotes	154	2.42e-45	NR	AAT09077.1	227086	g11258	i0	67.8	0.92991913746630706	115	37	93	0	19	363	1	115	AAT09077.1 transcription factor BTF3 [Bigelowiella natans]	diamond	345	154	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans

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);;