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

8 rows where analysis = "blastn", bioproject = "PRJNA561212" 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
1821191	1821191	PRJNA561212_P_NODE_4842_length_503_cov_1.337209_g4632_i0	PRJNA561212	4842	503	1.337209	6.72616127	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	769	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g4632	i0	95.258	189.978131212724	485	23	96	0	10	494	3682179	3682663	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	95559	769	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
4373041	4373041	PRJNA561212_P_NODE_9864_length_351_cov_1.492806_g9653_i0	PRJNA561212	9864	351	1.492806	5.23974906	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	340	6.32e-89	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g9653	i0	85.329	74.3846153846154	334	44	95	4	11	342	3681396	3681066	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	26109	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6923453	6923453	PRJNA561212_P_NODE_23066_length_247_cov_1.298851_g22855_i0	PRJNA561212	23066	247	1.298851	3.20816197	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	396	8.95e-106	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g22855	i0	98.23	93.4777327935223	226	4	91	0	13	238	3680404	3680179	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	23089	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6923627	6923627	PRJNA561212_P_NODE_9626_length_355_cov_1.351064_g9415_i0	PRJNA561212	9626	355	1.351064	4.7962772	Nostoc sp. PCC 7107	317936	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|427357970\|gb\|CP003548.1\|	317936	g9415	i0	97.059	0.569014084507042	34	0	10	1	202	235	1990154	1990122	Nostoc sp. PCC 7107, complete genome	blastn	202	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7107
13299400	13299400	PRJNA561212_P_NODE_1651_length_842_cov_2.803641_g1464_i0	PRJNA561212	1651	842	2.803641	23.60665722	Calothrix parasitica	1973486	Bacteria	Bacteria	56.5	0.007	NTclustered	gi\|1210161462\|dbj\|AP018227.1\|	1973488	g1464	i0	100	0.0356294536817102	30	0	4	0	183	212	1699939	1699910	Calothrix parasitica NIES-267 DNA, nearly complete genome	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parasitica
15158730	15158730	PRJNA561212_P_NODE_12432_length_315_cov_2.078512_g12221_i0	PRJNA561212	12432	315	2.078512	6.5473128	Cyanophyceae	3028117	Bacteria	Bacteria	505	1.8799999999999995e-138	NTclustered	gi\|1345606788\|gb\|MG968522.1\|	102128	g12221	i0	97.306	126.530158730159	297	8	94	0	10	306	322	618	Leptolyngbya sp. PCC 73110 23S ribosomal RNA gene, partial sequence	blastn	39857	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 73110
15848322	15848322	PRJNA561212_P_NODE_24833_length_244_cov_0.912281_g24622_i0	PRJNA561212	24833	244	0.912281	2.22596564	Pseudanabaena sp. Chao 1811	2963092	Bacteria	Bacteria	58.4	4.73e-4	NTclustered	gi\|2429870828\|gb\|CP101416.1\|	2963092	g24622	i0	89.13	0.188524590163934	46	5	19	0	123	168	16043	16088	Pseudanabaena sp. Chao 1811 chromosome, complete genome	blastn	46	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. Chao 1811
20257211	20257211	PRJNA561212_P_NODE_19796_length_255_cov_1.565934_g19585_i0	PRJNA561212	19796	255	1.565934	3.9931317	Leptolyngbyaceae	1890438	Bacteria	Bacteria	422	1.53e-113	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g19585	i0	97.561	164.01568627451	246	6	96	0	10	255	4595	4840	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	41824	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis

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);;