metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA492363" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA492363" 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	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	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	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	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
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	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	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
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	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	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	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	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	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
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	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	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	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	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	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);;