metadata: contig_metadata: 15 rows where bioproject = "PRJNA909412", tax_clade = "Sar" and tax

15 rows where bioproject = "PRJNA909412", 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
890668	890668	PRJNA909412_P_NODE_2601_length_329_cov_24.462069_g2461_i0	PRJNA909412	2601	329	24.462069	80.48020701	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	198	3.76e-46	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g2461	i0	79.933	28.7173252279635	299	36	90	16	34	329	4039	3762	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	9448	198	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
4719217	4719217	PRJNA909412_P_NODE_3324_length_288_cov_2.767068_g3183_i0	PRJNA909412	3324	288	2.767068	7.96915584	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	141	1.7099999999999996e-40	NR	AAT09077.1	227086	g3183	i0	71.9	7	96	27	100	0	288	1	25	120	AAT09077.1 transcription factor BTF3 [Bigelowiella natans]	diamond	2016	141	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
5993904	5993904	PRJNA909412_P_NODE_1605_length_434_cov_3.339241_g1465_i0	PRJNA909412	1605	434	3.339241	14.49230594	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	118	2.06e-29	NR	MES1907458.1	1215613	g1465	i0	67.8	0.601382488479263	87	28	60.1	0	172	432	33	119	MES1907458.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	261	118	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
7268868	7268868	PRJNA909412_P_NODE_66_length_1801_cov_15.603859_g50_i0	PRJNA909412	66	1801	15.603859	281.02550059	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	695	9.319999999999995e-247	NR	MES1909605.1	1215613	g50	i0	77.1	4.41588006662965	433	99	72.1	0	23	1321	1	433	MES1909605.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	7953	701	0.991440798858773	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
11094227	11094227	PRJNA909412_P_NODE_11769_length_166_cov_3.236220_g11628_i0	PRJNA909412	11769	166	3.23622	5.3721252	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	307	2.69e-79	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g11628	i0	100	100.777108433735	166	0	100	0	1	166	826	991	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	16729	307	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
12369802	12369802	PRJNA909412_P_NODE_1910_length_392_cov_4.291785_g1770_i0	PRJNA909412	1910	392	4.291785	16.8237972	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	719	0	NTclustered	gi\|300676732\|gb\|GQ377662.1\|	188950	g1770	i0	99.745	37.2678571428571	392	1	100	0	1	392	634	243	Bodomorpha minima alpha-tubulin (Atub) gene, partial cds	blastn	14609	719	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
13644342	13644342	PRJNA909412_P_NODE_4631_length_242_cov_6.384236_g4490_i0	PRJNA909412	4631	242	6.384236	15.44985112	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	425	1.11e-114	NTclustered	gi\|300676732\|gb\|GQ377662.1\|	188950	g4490	i0	98.347	99.3223140495868	242	4	100	0	1	242	648	889	Bodomorpha minima alpha-tubulin (Atub) gene, partial cds	blastn	24036	425	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
17468972	17468972	PRJNA909412_P_NODE_2034_length_378_cov_5.277286_g1894_i0	PRJNA909412	2034	378	5.277286	19.94814108	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	684	0	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g1894	i0	99.211	85.7592592592593	380	1	100	1	1	378	2111	1732	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	32417	684	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
17469014	17469014	PRJNA909412_P_NODE_94_length_1535_cov_8.555481_g71_i0	PRJNA909412	94	1535	8.555481	131.32663335	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	1491	0	NTclustered	gi\|238617630\|gb\|FJ973394.1\|	188950	g71	i0	98.805	73.0332247557003	837	10	55	0	426	1262	837	1	Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds	blastn	112106	1491	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
21292614	21292614	PRJNA909412_P_NODE_5397_length_224_cov_2.437838_g5256_i0	PRJNA909412	5397	224	2.437838	5.46075712	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	414	2.1999999999999996e-111	NTclustered	gi\|302026154\|gb\|GQ377660.1\|	188950	g5256	i0	100	19.8214285714286	224	0	100	0	1	224	253	476	Bodomorpha minima beta-tubulin (Btub) gene, partial cds	blastn	4440	414	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
23842893	23842893	PRJNA909412_P_NODE_1439_length_458_cov_9.269690_g1300_i0	PRJNA909412	1439	458	9.26969	42.4551802	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	846	0	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g1300	i0	100	19.1310043668122	458	0	100	0	1	458	347	804	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	8762	846	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
28098257	28098257	PRJNA909412_P_NODE_15825_length_153_cov_2.008772_g15684_i0	PRJNA909412	15825	153	2.008772	3.07342116	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	57.4	7.12e-8	NR	MES1907562.1	1215613	g15684	i0	49.1	1.07843137254902	55	23	98	1	2	151	216	270	MES1907562.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	165	57.4	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
28453251	28453251	PRJNA909412_P_NODE_7106_length_198_cov_2.075472_g6965_i0	PRJNA909412	7106	198	2.075472	4.10943456	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	85.1	2.44e-17	NR	AAP34647.1	227086	g6965	i0	64.6	5.81818181818182	65	23	98.5	0	198	4	267	331	AAP34647.1 chaperonin-containing TCP-1 theta [Bigelowiella natans]	diamond	1152	85.1	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
31446536	31446536	PRJNA909412_P_NODE_8916_length_179_cov_1.471429_g8775_i0	PRJNA909412	8916	179	1.471429	2.63385791	Paulinella micropora	1928728	SAR_Eukaryotes	SAR_Eukaryotes	77	1.5e-15	NR	BBE07971.1	1928728	g8775	i0	86.7	0.754189944134078	45	6	75.4	0	1	135	134	178	BBE07971.1 GTP-binding protein [Paulinella micropora]	diamond	135	77	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Paulinellidae	Paulinella	Paulinella micropora
32837145	32837145	PRJNA909412_P_NODE_13140_length_160_cov_3.859504_g12999_i0	PRJNA909412	13140	160	3.859504	6.1752064	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	40.8	0.0427	NR	MES1913617.1	1215613	g12999	i0	44.4	0.84375	45	24	84.4	1	21	155	112	155	MES1913617.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	135	40.8	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);;