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

11 rows where bioproject = "PRJNA906294", 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_order	tax_family	tax_genus	tax_species
4714178	4714178	PRJNA906294_P_NODE_117424_length_369_cov_1.462838_g113309_i0	PRJNA906294	117424	369	1.462838	5.39787222	Bodomorpha sp. HFCC 92	458884	SAR_Eukaryotes	SAR_Eukaryotes	682	0	NTclustered	gi\|197723521\|gb\|EF681900.2\|	458884	g113309	i0	100	28.9132791327913	369	0	100	0	1	369	245	613	Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence	blastn	10669	682	1	Eukaryota	Sar	Cercozoa	Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha sp. HFCC 92
17465762	17465762	PRJNA906294_P_NODE_194954_length_260_cov_1.625668_g190838_i0	PRJNA906294	194954	260	1.625668	4.2267368	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	131	3.98e-34	NR	MES1915306.1	1215613	g190838	i0	65.1	3.86538461538462	83	29	95.8	0	260	12	330	412	MES1915306.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	1005	132	0.992424242424242	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
23837569	23837569	PRJNA906294_P_NODE_105819_length_398_cov_2.070769_g101704_i0	PRJNA906294	105819	398	2.070769	8.24166062	Cercozoa sp. DMV	1342330	SAR_Eukaryotes	SAR_Eukaryotes	234	8.44e-73	NR	BAN37425.1	1342330	g101704	i0	82.6	0.994974874371859	132	23	99.5	0	398	3	296	427	BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV]	diamond	396	234	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. DMV
24200138	24200138	PRJNA906294_P_NODE_208099_length_249_cov_0.863636_g203983_i0	PRJNA906294	208099	249	0.863636	2.15045364	Bodomorpha	188949	SAR_Eukaryotes	SAR_Eukaryotes	455	1.47e-123	NTclustered	gi\|219524870\|gb\|EU709233.1\|	175275	g203983	i0	99.598	100.196787148594	249	1	100	0	1	249	597	845	Uncultured cercozoan isolate HetPan13 18S ribosomal RNA gene, partial sequence	blastn	24949	455	1	Eukaryota	Sar	Cercozoa				uncultured Cercozoa
28414071	28414071	PRJNA906294_P_NODE_133026_length_338_cov_1.433962_g128910_i0	PRJNA906294	133026	338	1.433962	4.84679156	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	69.3	5.44e-11	NR	MES1907171.1	1215613	g128910	i0	40.2	1.81065088757396	102	50	90.5	1	338	33	121	211	MES1907171.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	612	69.3	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
30213783	30213783	PRJNA906294_P_NODE_234872_length_199_cov_4.603175_g230756_i0	PRJNA906294	234872	199	4.603175	9.16031825	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	91.7	8.54e-23	NR	MES1911722.1	1215613	g230756	i0	76.9	0.78391959798995	52	12	78.4	0	194	39	1	52	MES1911722.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	156	91.7	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
30309210	30309210	PRJNA906294_P_NODE_231432_length_241_cov_0.904762_g227316_i0	PRJNA906294	231432	241	0.904762	2.18047642	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	60.8	7.13e-9	NR	MES1909310.1	1215613	g227316	i0	61.1	1.0954356846473	36	14	44.8	0	241	134	183	218	MES1909310.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	264	60.8	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
31541435	31541435	PRJNA906294_P_NODE_230256_length_241_cov_0.916667_g226140_i0	PRJNA906294	230256	241	0.916667	2.20916747	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00135	NR	ADK26622.1	323453	g226140	i0	85	2.24066390041494	20	3	24.9	0	241	182	111	130	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	540	45.4	1	Eukaryota	Sar	Cercozoa	Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
32015751	32015751	PRJNA906294_P_NODE_158118_length_300_cov_17.114537_g154002_i0	PRJNA906294	158118	300	17.114537	51.343611	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	83.2	4.96e-18	NR	MES1912234.1	1215613	g154002	i0	54.7	1.5	75	31	75	2	273	49	49	120	MES1912234.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	450	83.2	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
32118355	32118355	PRJNA906294_P_NODE_167318_length_289_cov_1.759259_g163202_i0	PRJNA906294	167318	289	1.759259	5.08425851	root	1	Root_unresolved	Root_unresolved	60.8	2.4e-8	NR	MES1911788.1	1215613	g163202	i0	50	3.86159169550173	56	28	58.1	0	108	275	32	87	MES1911788.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	1116	60.8	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
32174206	32174206	PRJNA906294_P_NODE_155778_length_304_cov_0.987013_g151662_i0	PRJNA906294	155778	304	0.987013	3.00051952	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	80.1	5.59e-15	NR	MES1912100.1	1215613	g151662	i0	40	0.888157894736842	90	53	87.8	1	270	4	374	463	MES1912100.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	270	80.1	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);;