metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJEB8827" and tax

6 rows where analysis = "blastn", bioproject = "PRJEB8827" 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
25665875	25665875	PRJEB8827f_S_NODE_20090_length_165_cov_1.723077_g20070_i0	PRJEB8827	20090	165	1.723077	2.84307705	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	159	7.9e-35	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g20070	i0	89.764	6.04848484848485	127	10	76	3	41	165	3682361	3682486	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	998	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25802301	25802301	PRJEB8827f_S_NODE_971_length_370_cov_3.071642_g951_i0	PRJEB8827	971	370	3.071642	11.3650754	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	261	5.37e-65	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g951	i0	80.109	38.4972972972973	367	59	97	11	10	368	3680903	3681263	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	14244	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25937882	25937882	PRJEB8827e_S_NODE_1084_length_367_cov_3.081325_g1056_i0	PRJEB8827	1084	367	3.081325	11.30846275	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	246	1.49e-60	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1056	i0	79.088	48.9509536784741	373	66	99	10	2	367	3680986	3681353	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	17965	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25938417	25938417	PRJEB8827f_S_NODE_4012_length_226_cov_4.099476_g3992_i0	PRJEB8827	4012	226	4.099476	9.26481576	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	252	1.85e-62	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g3992	i0	87.85	57.8451327433628	214	26	95	0	4	217	3681116	3680903	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13073	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26074043	26074043	PRJEB8827e_S_NODE_445_length_515_cov_21.012500_g423_i0	PRJEB8827	445	515	21.0125	108.214375	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	579	1.8699999999999993e-160	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g423	i0	87.14	145.497087378641	521	54	100	12	1	515	3682593	3682080	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	74931	579	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26346290	26346290	PRJEB8827f_S_NODE_159_length_600_cov_41.178761_g145_i0	PRJEB8827	159	600	41.178761	247.072566	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	636	1.2899999999999998e-177	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g145	i0	87.063	122.401666666667	572	62	94	11	1	566	3682116	3682681	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	73441	636	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);;