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

5 rows where analysis = "diamond", bioproject = "PRJNA917598" 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
11098830	11098830	PRJNA917598_P_NODE_14589_length_617_cov_2.097426_g13655_i0	PRJNA917598	14589	617	2.097426	12.94111842	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	256	8.81e-85	NR	ADK26622.1	323453	g13655	i0	94.6	0.632090761750405	130	7	63.2	0	575	186	1	130	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	390	256	1	Eukaryota	Sar	Cercozoa	Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
13649814	13649814	PRJNA917598_P_NODE_49491_length_326_cov_1.217391_g48547_i0	PRJNA917598	49491	326	1.217391	3.96869466	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	186	9.47e-57	NR	ADK26624.1	323453	g48547	i0	89.8	0.901840490797546	98	10	90.2	0	1	294	179	276	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	294	186	1	Eukaryota	Sar	Cercozoa	Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
20022810	20022810	PRJNA917598_P_NODE_46076_length_338_cov_1.452830_g45132_i0	PRJNA917598	46076	338	1.45283	4.9105654	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	221	5.31e-72	NR	ADK47156.1	323453	g45132	i0	95.5	0.994082840236686	112	5	99.4	0	1	336	17	128	ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74]	diamond	336	221	1	Eukaryota	Sar	Cercozoa	Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
27561549	27561549	PRJNA917598_P_NODE_85984_length_247_cov_0.885057_g85040_i0	PRJNA917598	85984	247	0.885057	2.18609079	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	97.8	1.0300000000000001e-22	NR	MES1915897.1	1215613	g85040	i0	56.6	2.01619433198381	83	33	99.6	2	1	246	60	140	MES1915897.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	498	97.8	1	Eukaryota	Sar	Cercozoa				Cercozoa sp. M6MM
31762982	31762982	PRJNA917598_P_NODE_86437_length_247_cov_0.885057_g85493_i0	PRJNA917598	86437	247	0.885057	2.18609079	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	75.5	1.18e-13	NR	MES1910298.1	1215613	g85493	i0	46.9	1.94331983805668	81	43	98.4	0	246	4	430	510	MES1910298.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	480	75.5	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);;