metadata: contig_metadata: 5 rows where bioproject = "PRJNA608660", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

5 rows where bioproject = "PRJNA608660", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

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_kingdom	tax_phylum	tax_species
3135660	3135660	PRJNA608660_P_NODE_3983_length_710_cov_7.550681_g3717_i0	PRJNA608660	3983	710	7.550681	53.6098351	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	246	3.0299999999999997e-60	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g3717	i0	78.713	39.4042253521127	404	61	97	21	311	699	3681346	3680953	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	27977	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
27111596	27111596	PRJNA608660_P_NODE_47862_length_165_cov_1.267241_g47505_i0	PRJNA608660	47862	165	1.267241	2.09094765	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	105	7.3e-26	NR	HIA54065.1	2052166	g47505	i0	94.3	1.92727272727273	53	3	96.4	0	1	159	221	273	HIA54065.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	318	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
29196044	29196044	PRJNA608660_P_NODE_7789_length_534_cov_8.597938_g7456_i0	PRJNA608660	7789	534	8.597938	45.91298892	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	227	7.440000000000001e-73	NR	HIA51106.1	2052166	g7456	i0	100	0.960674157303371	171	0	96.1	0	523	11	5	175	HIA51106.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	513	227	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
29227702	29227702	PRJNA608660_P_NODE_10389_length_463_cov_1.214976_g10044_i0	PRJNA608660	10389	463	1.214976	5.62533888	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	266	7.77e-88	NR	HIA52909.1	2052166	g10044	i0	89.3	0.965442764578834	149	16	96.5	0	16	462	22	170	HIA52909.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	447	266	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
31976646	31976646	PRJNA608660_P_NODE_8578_length_510_cov_1.657267_g8243_i0	PRJNA608660	8578	510	1.657267	8.4520617	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	318	1.5899999999999996e-106	NR	MBC7998045.1	2052166	g8243	i0	95.9	0.994117647058824	169	7	99.4	0	2	508	134	302	MBC7998045.1 patatin-like phospholipase family protein [Candidatus Melainabacteria bacterium]	diamond	507	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium

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