metadata: contig_metadata: 5 rows where bioproject = "PRJNA815356" and tax

5 rows where bioproject = "PRJNA815356" and tax_clade = "Sar"

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_class	tax_order	tax_family	tax_genus	tax_species
2503408	2503408	PRJNA815356_P_NODE_11302_length_230_cov_2.101911_g11139_i0	PRJNA815356	11302	230	2.101911	4.8343953	Nannochloropsis	5748	SAR_Eukaryotes	SAR_Eukaryotes	425	1.05e-114	NTclustered	gi\|613433536\|gb\|KJ410684.1\|	43925	g11139	i0	100	141.860869565217	230	0	100	0	1	230	5845	5616	Nannochloropsis oculata strain CCMP525 chloroplast, complete genome	blastn	32628	425	1	Eukaryota	Sar	Eustigmatophyceae	Eustigmatales	Monodopsidaceae	Nannochloropsis	Nannochloropsis oculata
12298270	12298270	PRJNA815356_P_NODE_2090_length_457_cov_1.914062_g1928_i0	PRJNA815356	2090	457	1.914062	8.74726334	Poterioochromonas malhamensis	88167	SAR_Eukaryotes	SAR_Eukaryotes	843	0	NTclustered	gi\|2088238071\|ref\|NC_056910.1\|	88167	g1928	i0	100	90.2625820568928	456	0	99	0	1	456	29604	30059	Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome	blastn	41250	843	1	Eukaryota	Sar	Synurophyceae	Ochromonadales	Ochromonadaceae	Poterioochromonas	Poterioochromonas malhamensis
17397488	17397488	PRJNA815356_P_NODE_5414_length_309_cov_1.296610_g5251_i0	PRJNA815356	5414	309	1.29661	4.0065249	Nannochloropsis oceanica	145522	SAR_Eukaryotes	SAR_Eukaryotes	566	8.33e-157	NTclustered	gi\|542687962\|ref\|NC_022263.1\|	145522	g5251	i0	99.676	192.88996763754	309	1	100	0	1	309	51088	50780	Nannochloropsis oceanica strain CCMP531 chloroplast, complete genome	blastn	59603	566	1	Eukaryota	Sar	Eustigmatophyceae	Eustigmatales	Monodopsidaceae	Nannochloropsis	Nannochloropsis oceanica
23771517	23771517	PRJNA815356_P_NODE_1439_length_539_cov_1.392704_g1277_i0	PRJNA815356	1439	539	1.392704	7.50667456	Nannochloropsis limnetica	120807	SAR_Eukaryotes	SAR_Eukaryotes	219	4.929999999999999e-52	NTclustered	gi\|542687530\|ref\|NC_022256.1\|	120807	g1277	i0	78.286	65.0408163265306	350	68	64	8	189	534	24899	25244	Nannochloropsis limnetica strain CCMP505 mitochondrion, complete genome	blastn	35057	219	1	Eukaryota	Sar	Eustigmatophyceae	Eustigmatales	Monodopsidaceae	Nannochloropsis	Nannochloropsis limnetica
30244157	30244157	PRJNA815356_P_NODE_8172_length_261_cov_1.335106_g8009_i0	PRJNA815356	8172	261	1.335106	3.48462666	Ochromonadaceae sp. CCMP2298	483371	SAR_Eukaryotes	SAR_Eukaryotes	57.8	2.4e-7	NR	KAJ1442078.1	483371	g8009	i0	44.3	0.701149425287356	61	32	67.8	1	252	76	560	620	KAJ1442078.1 hypothetical protein B484DRAFT_426946 [Ochromonadaceae sp. CCMP2298]	diamond	183	57.8	1	Eukaryota	Sar	Synurophyceae	Ochromonadales	Ochromonadaceae		Ochromonadaceae sp. CCMP2298

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