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

4 rows where bioproject = "PRJEB12366", 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
1295028	1295028	PRJEB12366_S_NODE_182_length_330_cov_17.261017_g174_i0	PRJEB12366	182	330	17.261017	56.9613561	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	366	9.77e-97	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g174	i0	87.821	46.3181818181818	312	38	95	0	10	321	3680021	3679710	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	15285	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
10223574	10223574	PRJEB12366_S_NODE_229_length_310_cov_20.170909_g221_i0	PRJEB12366	229	310	20.170909	62.5298179	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	348	3.3e-91	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g221	i0	87.879	43.0161290322581	297	35	95	1	6	301	3679725	3680021	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13335	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
11498838	11498838	PRJEB12366_S_NODE_30_length_599_cov_85.737589_g25_i0	PRJEB12366	30	599	85.737589	513.56815811	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	612	2.17e-170	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g25	i0	86.98	81.0267111853089	553	60	91	11	28	574	3682681	3682135	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	48535	612	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22972798	22972798	PRJEB12366_S_NODE_39_length_545_cov_10.533333_g32_i0	PRJEB12366	39	545	10.533333	57.40666485	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	555	3.349999999999999e-153	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g32	i0	85.688	282.743119266055	538	64	98	11	11	542	3680690	3681220	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	154095	555	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);;