metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA635874" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA635874" 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
4434659	4434659	PRJNA635874_P_NODE_204_length_1799_cov_8.902665_g159_i0	PRJNA635874	204	1799	8.902665	160.15894335	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	695	8.979999999999997e-247	NR	MES1909605.1	1215613	g159	i0	77.1	4.42078932740411	433	99	72.2	0	1782	484	1	433	MES1909605.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	7953	701	0.991440798858773	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
12086425	12086425	PRJNA635874_P_NODE_2290_length_826_cov_1.598938_g2170_i0	PRJNA635874	2290	826	1.598938	13.20722788	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	340	1.87e-114	NR	ADK26624.1	323453	g2170	i0	75.8	0.795399515738499	219	53	79.5	0	22	678	58	276	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	657	340	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
17184674	17184674	PRJNA635874_P_NODE_11294_length_442_cov_1.696477_g11147_i0	PRJNA635874	11294	442	1.696477	7.49842834	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	246	8.2e-82	NR	ADK26622.1	323453	g11147	i0	88.5	0.882352941176471	130	15	88.2	0	35	424	1	130	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	390	246	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
29935646	29935646	PRJNA635874_P_NODE_11111_length_445_cov_1.733871_g10964_i0	PRJNA635874	11111	445	1.733871	7.71572595	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	123	1.28e-32	NR	AAY21202.1	227086	g10964	i0	62.1	5.63595505617978	87	33	58.7	0	322	62	17	103	AAY21202.1 Rpl7A, partial [Bigelowiella natans]	diamond	2508	123	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
30744526	30744526	PRJNA635874_P_NODE_34374_length_286_cov_1.633803_g34227_i0	PRJNA635874	34374	286	1.633803	4.67267658	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	80.1	1.7e-15	NR	MES1912635.1	1215613	g34227	i0	45.5	3.11538461538462	99	48	98.6	2	284	3	23	120	MES1912635.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	891	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);;