metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA556992" 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
3077998	3077998	PRJNA556992_P_NODE_3163_length_1732_cov_18.863773_g2554_i0	PRJNA556992	3163	1732	18.863773	326.72054836	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1408	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2554	i0	84.701	123.952655889145	1438	188	89	26	1	1420	3682654	3681231	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	214686	1408	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
5626160	5626160	PRJNA556992_P_NODE_103885_length_400_cov_4.305810_g101701_i0	PRJNA556992	103885	400	4.30581	17.22324	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	342	2.03e-89	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g101701	i0	82.908	37.0975	392	55	96	8	2	386	3680916	3681302	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	14839	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
6901504	6901504	PRJNA556992_P_NODE_1140206_length_203_cov_9.453846_g1138015_i0	PRJNA556992	1140206	203	9.453846	19.19130738	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	265	2.09e-66	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1138015	i0	90.909	2.51231527093596	198	16	97	2	7	203	4710725	4710529	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	510	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
8188224	8188224	PRJNA556992_P_NODE_973167_length_233_cov_3.525000_g970977_i0	PRJNA556992	973167	233	3.525	8.21325	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	331	2.39e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g970977	i0	92.308	1.00429184549356	234	16	100	2	1	233	3095200	3094968	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	234	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
10739085	10739085	PRJNA556992_P_NODE_939689_length_236_cov_13.030675_g937499_i0	PRJNA556992	939689	236	13.030675	30.752393	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	259	1.16e-64	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g937499	i0	86.441	1	236	32	100	0	1	236	3378894	3379129	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	236	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
12004029	12004029	PRJNA556992_P_NODE_185390_length_335_cov_3.320611_g183202_i0	PRJNA556992	185390	335	3.320611	11.12404685	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	361	4.62e-95	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g183202	i0	86.747	25.2985074626866	332	35	97	8	10	335	2594344	2594016	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	8475	361	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
12604750	12604750	PRJNA556992_P_NODE_299570_length_289_cov_1.328704_g297381_i0	PRJNA556992	299570	289	1.328704	3.83995456	Bacteria	2	Bacteria	Bacteria	279	1.13e-70	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g297381	i0	84.859	121.944636678201	284	36	98	5	1	283	1478442	1478165	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	35242	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium MEL.A1
13279855	13279855	PRJNA556992_P_NODE_229751_length_312_cov_1.539749_g227563_i0	PRJNA556992	229751	312	1.539749	4.80401688	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	488	1.88e-133	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g227563	i0	94.872	212.599358974359	312	16	100	0	1	312	3681940	3681629	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	66331	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
15838423	15838423	PRJNA556992_P_NODE_998113_length_230_cov_7.719745_g995923_i0	PRJNA556992	998113	230	7.719745	17.7554135	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	346	8.41e-91	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g995923	i0	94.248	0.982608695652174	226	13	98	0	5	230	1468231	1468006	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	226	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
18380229	18380229	PRJNA556992_P_NODE_414515_length_275_cov_1.905941_g412326_i0	PRJNA556992	414515	275	1.905941	5.24133775	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	348	2.88e-91	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g412326	i0	89.455	84.7345454545455	275	29	100	0	1	275	3680540	3680266	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	23302	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22207646	22207646	PRJNA556992_P_NODE_583258_length_260_cov_2.326203_g581069_i0	PRJNA556992	583258	260	2.326203	6.0481278	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	337	5.839999999999998e-88	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g581069	i0	90	1	260	26	100	0	1	260	3301510	3301251	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	260	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
23477979	23477979	PRJNA556992_P_NODE_217999_length_317_cov_12.049180_g215811_i0	PRJNA556992	217999	317	12.04918	38.1959006	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	375	1.5499999999999995e-99	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g215811	i0	88.365	1.00315457413249	318	29	100	6	1	317	850715	850405	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	318	375	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);;