metadata: contig_metadata: 10 rows where bioproject = "PRJNA330616", tax_clade = "Sar" and tax

10 rows where bioproject = "PRJNA330616", 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
4897345	4897345	PRJNA330616_P_NODE_7304_length_308_cov_2.011583_g6895_i0	PRJNA330616	7304	308	2.011583	6.19567564	Bodomorpha	188949	SAR_Eukaryotes	SAR_Eukaryotes	558	1.39e-154	NTclustered	gi\|33309639\|gb\|AF411276.1\|	188950	g6895	i0	99.351	87.5681818181818	308	2	100	0	1	308	1024	717	Bodomorpha minima 18S ribosomal RNA gene, complete sequence	blastn	26971	558	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
8043114	8043114	PRJNA330616_P_NODE_3787_length_441_cov_3.410714_g3380_i0	PRJNA330616	3787	441	3.410714	15.04124874	Chlorarachniophyceae sp. P329	467061	SAR_Eukaryotes	SAR_Eukaryotes	252	3.92e-62	NTclustered	gi\|220983374\|dbj\|AB453010.1\|	467061	g3380	i0	85.774	52.7256235827664	239	32	54	2	67	305	1019	1255	Chlorarachniophyceae sp. P329 gene for nuclear large subunit ribosomal RNA, partial sequence	blastn	23252	252	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae				Chlorarachniophyceae sp. P329
9317852	9317852	PRJNA330616_P_NODE_3368_length_472_cov_10.231678_g2962_i0	PRJNA330616	3368	472	10.231678	48.29352016	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	791	0	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g2962	i0	96.842	22.3559322033898	475	12	100	3	1	472	331	805	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	10552	791	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
13143160	13143160	PRJNA330616_P_NODE_18251_length_197_cov_1.243243_g17842_i0	PRJNA330616	18251	197	1.243243	2.44918871	Chlorarachniophyceae sp. P329	467061	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.02e-4	NTclustered	gi\|220983374\|dbj\|AB453010.1\|	467061	g17842	i0	100	14.9238578680203	32	0	16	0	85	116	1593	1624	Chlorarachniophyceae sp. P329 gene for nuclear large subunit ribosomal RNA, partial sequence	blastn	2940	60.2	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae				Chlorarachniophyceae sp. P329
13143380	13143380	PRJNA330616_P_NODE_3511_length_461_cov_4.660194_g3105_i0	PRJNA330616	3511	461	4.660194	21.48349434	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	841	0	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g3105	i0	99.566	92.234273318872	461	2	100	0	1	461	1704	2164	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	42520	841	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
15692300	15692300	PRJNA330616_P_NODE_19813_length_189_cov_1.814286_g19404_i0	PRJNA330616	19813	189	1.814286	3.42900054	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	350	5.14e-92	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g19404	i0	100	100.396825396825	189	0	100	0	1	189	829	1017	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	18975	350	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
15692504	15692504	PRJNA330616_P_NODE_333_length_1614_cov_27.338658_g205_i0	PRJNA330616	333	1614	27.338658	441.24594012	Rosculus sp.	2231160	SAR_Eukaryotes	SAR_Eukaryotes	2344	0	NTclustered	gi\|1402550476\|gb\|MH488762.1\|	2231160	g205	i0	93.206	28.0198265179678	1619	71	99	25	1	1608	15	1605	Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence	blastn	45224	2344	1	Eukaryota	Sar	Cercozoa			Guttulinopsidae	Rosculus	Rosculus sp.
19515771	19515771	PRJNA330616_P_NODE_9136_length_274_cov_3.324444_g8727_i0	PRJNA330616	9136	274	3.324444	9.10897656	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	217	8.43e-52	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g8727	i0	81.227	25.0985401459854	277	44	100	8	1	274	3746	4017	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	6877	217	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
26884935	26884935	PRJNA330616_P_NODE_15841_length_210_cov_1.583851_g15432_i0	PRJNA330616	15841	210	1.583851	3.3260871	Lotharella oceanica	641309	SAR_Eukaryotes	SAR_Eukaryotes	67.4	4.36e-13	NR	AIB09582.1	641309	g15432	i0	57.4	0.771428571428571	54	23	77.1	0	201	40	1	54	AIB09582.1 hypothetical protein M951_chr1100 [Lotharella oceanica]	diamond	162	67.4	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Lotharella	Lotharella oceanica
29790124	29790124	PRJNA330616_P_NODE_18391_length_196_cov_1.476190_g17982_i0	PRJNA330616	18391	196	1.47619	2.8933324	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	80.9	1.78e-17	NR	MES1909029.1	1215613	g17982	i0	56.3	1.95918367346939	64	26	94.9	1	196	11	40	103	MES1909029.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	384	80.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);;