metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA492363" and tax_clade = "Cyanobacteriota/Melainabacteria group"

19 rows where analysis = "blastn", bioproject = "PRJNA492363" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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_class	tax_order	tax_family	tax_genus	tax_species
25565706	25565706	PRJNA492363_S_NODE_11841_length_283_cov_1.153153_g11020_i0	PRJNA492363	11841	283	1.153153	3.26342299	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	518	2.14e-142	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g11020	i0	99.647	1	283	1	100	0	1	283	4116664	4116382	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	283	518	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25566850	25566850	PRJNA492363_S_NODE_75857_length_219_cov_1.620253_g75036_i0	PRJNA492363	75857	219	1.620253	3.54835407	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	405	1.29e-108	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g75036	i0	100	1	219	0	100	0	1	219	4663557	4663339	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	219	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25625212	25625212	PRJNA492363_S_NODE_87721_length_208_cov_1.741497_g86900_i0	PRJNA492363	87721	208	1.741497	3.62231376	Acaryochloris	155977	Bacteria	Bacteria	69.4	1.81e-7	NTclustered	gi\|158311381\|gb\|CP000843.1\|	329726	g86900	i0	95.455	0.697115384615385	44	1	21	1	111	153	61481	61524	Acaryochloris marina MBIC11017 plasmid pREB6, complete sequence	blastn	145	69.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris marina
25701964	25701964	PRJNA492363_S_NODE_13802_length_267_cov_0.907767_g12981_i0	PRJNA492363	13802	267	0.907767	2.42373789	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	483	7.31e-132	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g12981	i0	99.251	1	267	2	100	0	1	267	48345	48611	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	267	483	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25837755	25837755	PRJNA492363_S_NODE_100947_length_201_cov_0.914286_g100126_i0	PRJNA492363	100947	201	0.914286	1.83771486	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g100126	i0	100	1	201	0	100	0	1	201	307500	307700	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	201	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25896914	25896914	PRJNA492363_S_NODE_101035_length_201_cov_0.914286_g100214_i0	PRJNA492363	101035	201	0.914286	1.83771486	Nostoc	1177	Bacteria	Bacteria	148	2.1699999999999997e-31	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g100214	i0	80.851	1.91542288557214	188	36	94	0	13	200	2292795	2292608	Nostoc sp. NIES-3756 DNA, complete genome	blastn	385	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
25897348	25897348	PRJNA492363_S_NODE_93363_length_205_cov_0.888889_g92542_i0	PRJNA492363	93363	205	0.888889	1.82222245	Nodularia	159191	Bacteria	Bacteria	171	4.74e-38	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g92542	i0	85.03	3.33170731707317	167	25	81	0	37	203	3827258	3827092	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	683	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26111362	26111362	PRJNA492363_S_NODE_77941_length_217_cov_1.205128_g77120_i0	PRJNA492363	77941	217	1.205128	2.61512776	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	381	2.1499999999999995e-101	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g77120	i0	98.605	0.990783410138249	215	3	99	0	1	215	851126	850912	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	215	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26111624	26111624	PRJNA492363_S_NODE_89621_length_207_cov_1.315068_g88800_i0	PRJNA492363	89621	207	1.315068	2.72219076	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	377	2.63e-100	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g88800	i0	99.517	1	207	1	100	0	1	207	3710543	3710749	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	207	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26111638	26111638	PRJNA492363_S_NODE_89877_length_207_cov_0.876712_g89056_i0	PRJNA492363	89877	207	0.876712	1.81479384	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g89056	i0	100	1	207	0	100	0	1	207	3596452	3596658	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	207	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26111657	26111657	PRJNA492363_S_NODE_91237_length_206_cov_1.937931_g90416_i0	PRJNA492363	91237	206	1.937931	3.99213786	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	298	2.09e-76	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g90416	i0	98.802	212.854368932039	167	2	81	0	1	167	1501162	1501328	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	43848	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26111808	26111808	PRJNA492363_S_NODE_96933_length_203_cov_1.352113_g96112_i0	PRJNA492363	96933	203	1.352113	2.74478939	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g96112	i0	100	1	203	0	100	0	1	203	4055764	4055562	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	203	375	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26246195	26246195	PRJNA492363_S_NODE_100750_length_201_cov_1.371429_g99929_i0	PRJNA492363	100750	201	1.371429	2.75657229	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	206	1.27e-48	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g99929	i0	91.837	3.00497512437811	147	12	73	0	20	166	5012091	5012237	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	604	206	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
26246208	26246208	PRJNA492363_S_NODE_101022_length_201_cov_0.914286_g100201_i0	PRJNA492363	101022	201	0.914286	1.83771486	Synechococcus sp. CCFWC 5	1131	Bacteria	Bacteria	222	1.26e-53	NTclustered	gi\|2482403951\|gb\|CP114977.1\|	2978474	g100201	i0	86.869	1.8407960199005	198	26	99	0	1	198	321321	321518	Synechococcus sp. CCFWC 502 chromosome	blastn	370	222	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CCFWC 502
26246599	26246599	PRJNA492363_S_NODE_15774_length_256_cov_0.984615_g14953_i0	PRJNA492363	15774	256	0.984615	2.5206144	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	468	1.95e-127	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g14953	i0	99.609	1	256	1	100	0	1	256	4985748	4985493	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	256	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26247640	26247640	PRJNA492363_S_NODE_81390_length_212_cov_1.701987_g80569_i0	PRJNA492363	81390	212	1.701987	3.60821244	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	387	4.5e-103	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g80569	i0	99.528	1	212	1	100	0	1	212	4264090	4263879	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	212	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26247965	26247965	PRJNA492363_S_NODE_94902_length_204_cov_1.790210_g94081_i0	PRJNA492363	94902	204	1.79021	3.6520284	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	372	1.2e-98	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g94081	i0	99.51	1.1421568627451	204	1	100	0	1	204	4021604	4021401	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	233	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26519771	26519771	PRJNA492363_S_NODE_86136_length_209_cov_0.864865_g85315_i0	PRJNA492363	86136	209	0.864865	1.80756785	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	387	4.42e-103	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g85315	i0	100	1	209	0	100	0	1	209	2673041	2673249	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	209	387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26520104	26520104	PRJNA492363_S_NODE_99032_length_202_cov_0.907801_g98211_i0	PRJNA492363	99032	202	0.907801	1.83375802	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	329	7.25e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g98211	i0	96.04	1	202	8	100	0	1	202	1496001	1495800	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	202	329	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);;