metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA429937" 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
427087	427087	PRJNA429937_P_NODE_60881_length_443_cov_2.502415_g41009_i0	PRJNA429937	60881	443	2.502415	11.08569845	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	200	1.45e-46	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g41009	i0	86.667	0.406320541760722	180	24	41	0	212	391	3715698	3715877	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	180	200	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
2976541	2976541	PRJNA429937_P_NODE_13143_length_1007_cov_114.242331_g7754_i0	PRJNA429937	13143	1007	114.242331	1150.42027317	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	972	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g7754	i0	87.799	246.446871896723	836	95	83	7	153	984	3681491	3682323	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	248172	972	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
2977033	2977033	PRJNA429937_P_NODE_26503_length_711_cov_43.781525_g15902_i0	PRJNA429937	26503	711	43.781525	311.28664275	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	680	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g15902	i0	85	133.216596343179	680	90	94	10	19	688	3681646	3682323	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	94717	680	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
2977572	2977572	PRJNA429937_P_NODE_5023_length_1529_cov_67.860000_g2970_i0	PRJNA429937	5023	1529	67.86	1037.5794	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1110	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2970	i0	85.178	168.972531066056	1093	151	71	11	24	1108	3682323	3681234	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	258359	1110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
6805385	6805385	PRJNA429937_P_NODE_9246_length_1181_cov_75.648438_g5430_i0	PRJNA429937	9246	1181	75.648438	893.40805278	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1179	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5430	i0	86.235	147.838272650296	1097	140	92	8	24	1113	3682323	3681231	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	174597	1179	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
10629668	10629668	PRJNA429937_P_NODE_12469_length_1033_cov_29.446215_g7339_i0	PRJNA429937	12469	1033	29.446215	304.17940095	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	791	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g7339	i0	84.42	116.639883833495	828	103	79	23	221	1033	3682635	3681819	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	120489	791	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
11906268	11906268	PRJNA429937_P_NODE_84470_length_351_cov_4.204969_g61962_i0	PRJNA429937	84470	351	4.204969	14.75944119	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	58.4	7.13e-4	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g61962	i0	87.755	0.13960113960114	49	6	14	0	201	249	872011	871963	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	49	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
13179361	13179361	PRJNA429937_P_NODE_11591_length_1070_cov_28.417867_g6812_i0	PRJNA429937	11591	1070	28.417867	304.0711769	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	789	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g6812	i0	85.752	112.448598130841	765	87	70	19	1	752	3681819	3682574	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	120320	789	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
14454672	14454672	PRJNA429937_P_NODE_12172_length_1045_cov_73.285433_g7153_i0	PRJNA429937	12172	1045	73.285433	765.83277485	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	961	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g7153	i0	87.119	131.231578947368	854	103	81	7	174	1022	3681472	3682323	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	137137	961	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
14454763	14454763	PRJNA429937_P_NODE_13172_length_1006_cov_105.615148_g7770_i0	PRJNA429937	13172	1006	105.615148	1062.48838888	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	981	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g7770	i0	87.947	160.889662027833	838	94	83	7	24	857	3682323	3681489	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	161855	981	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
14456550	14456550	PRJNA429937_P_NODE_95612_length_315_cov_3.503497_g73015_i0	PRJNA429937	95612	315	3.503497	11.03601555	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	121	7.969999999999999e-23	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g73015	i0	88.119	0.320634920634921	101	12	32	0	42	142	4224730	4224830	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	101	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
17003361	17003361	PRJNA429937_P_NODE_156914_length_156_cov_1849.944882_g134287_i0	PRJNA429937	156914	156	1849.944882	2885.91401592	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	176	7.31e-40	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g134287	i0	87.097	528.801282051282	155	20	99	0	2	156	3680511	3680357	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	82493	176	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
18277320	18277320	PRJNA429937_P_NODE_11435_length_1077_cov_28.236641_g6718_i0	PRJNA429937	11435	1077	28.236641	304.10862357	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	789	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g6718	i0	85.752	111.717734447539	765	87	70	19	326	1077	3682574	3681819	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	120320	789	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
19553045	19553045	PRJNA429937_P_NODE_6376_length_1389_cov_67.035294_g3750_i0	PRJNA429937	6376	1389	67.035294	931.12023366	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1179	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g3750	i0	86.235	125.818574514039	1097	140	84	8	277	1366	3681231	3682323	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	174762	1179	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
20827504	20827504	PRJNA429937_P_NODE_12737_length_1022_cov_29.719033_g7502_i0	PRJNA429937	12737	1022	29.719033	303.72851726	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	789	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g7502	i0	85.752	117.729941291585	765	87	74	19	271	1022	3682574	3681819	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	120320	789	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22103091	22103091	PRJNA429937_P_NODE_33718_length_625_cov_2.109060_g20801_i0	PRJNA429937	33718	625	2.10906	13.181625	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	178	9.81e-40	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g20801	i0	79.757	0.3952	247	49	39	1	189	434	3904088	3904334	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	247	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
23378684	23378684	PRJNA429937_P_NODE_35359_length_609_cov_3.763793_g21958_i0	PRJNA429937	35359	609	3.763793	22.92149937	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g21958	i0	92.683	0.0673234811165846	41	1	6	2	516	554	2664919	2664959	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	41	58.4	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);;