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

16 rows where analysis = "blastn", bioproject = "PRJNA408129" 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
1082702	1082702	PRJNA408129_S_NODE_14801_length_196_cov_4.383648_g14783_i0	PRJNA408129	14801	196	4.383648	8.59195008	Chroococcidiopsis	54298	Bacteria	Bacteria	117	5.93e-22	NTclustered	gi\|105990477\|gb\|DQ514208.1\|	1211	g14783	i0	100	31.7142857142857	63	0	32	0	124	186	967	905	Uncultured cyanobacterium clone 500M2_B9 16S ribosomal RNA gene, partial sequence	blastn	6216	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1082750	1082750	PRJNA408129_S_NODE_7001_length_244_cov_12.850242_g6983_i0	PRJNA408129	7001	244	12.850242	31.35459048	Oscillatoriales	1150	Bacteria	Bacteria	372	1.49e-98	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g6983	i0	98.131	101.33196721311501	214	3	88	1	15	228	295	507	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	24725	374	0.994652406417112	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
4910766	4910766	PRJNA408129_S_NODE_36004_length_150_cov_1.955752_g35986_i0	PRJNA408129	36004	150	1.955752	2.933628	Thermoleptolyngbya	2303528	Bacteria	Bacteria	213	5.3e-51	NTclustered	gi\|2592622306\|gb\|CP053540.1\|	2547457	g35986	i0	93.706	142.386666666667	143	7	95	2	9	150	312013	312154	Thermoleptolyngbya oregonensis NK1-22 chromosome, complete genome	blastn	21358	213	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
6185831	6185831	PRJNA408129_S_NODE_33605_length_153_cov_2.051724_g33587_i0	PRJNA408129	33605	153	2.051724	3.13913772	Nostocales	1161	Bacteria	Bacteria	135	1.2099999999999999e-27	NTclustered	gi\|924287285\|gb\|CP011456.1\|	1647413	g33587	i0	85.385	3.52941176470588	130	19	85	0	7	136	3283661	3283532	Anabaena sp. WA102 chromosome, complete sequence	blastn	540	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. WA102
7460699	7460699	PRJNA408129_S_NODE_5366_length_262_cov_4.315556_g5348_i0	PRJNA408129	5366	262	4.315556	11.30675672	Macrochaete	1844958	Bacteria	Bacteria	285	2.1699999999999997e-72	NTclustered	gi\|1026261016\|gb\|KT336439.2\|	1781141	g5348	i0	90.741	56.9732824427481	216	17	82	3	45	258	1742	1528	Macrochaete psychrophila CCALA 32 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	14927	287	0.993031358885017	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete psychrophila
8071680	8071680	PRJNA408129_S_NODE_21607_length_174_cov_6.992701_g21589_i0	PRJNA408129	21607	174	6.992701	12.16729974	Cylindrospermum stagnale	142864	Bacteria	Bacteria	132	1.83e-26	NTclustered	gi\|428256439\|gb\|CP003642.1\|	56107	g21589	i0	87.611	0.649425287356322	113	14	65	0	42	154	5763029	5763141	Cylindrospermum stagnale PCC 7417, complete genome	blastn	113	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum stagnale
10622199	10622199	PRJNA408129_S_NODE_10289_length_220_cov_1.786885_g10271_i0	PRJNA408129	10289	220	1.786885	3.931147	Anabaenopsis circularis	109266	Bacteria	Bacteria	217	6.529999999999999e-52	NTclustered	gi\|1210095109\|dbj\|AP018174.1\|	1085406	g10271	i0	93.793	4.7	145	8	66	1	61	205	2131183	2131040	Anabaenopsis circularis NIES-21 DNA, nearly complete genome	blastn	1034	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis circularis
10622322	10622322	PRJNA408129_S_NODE_2489_length_318_cov_5.042705_g2471_i0	PRJNA408129	2489	318	5.042705	16.0358019	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	342	1.58e-89	NTclustered	gi\|225696229\|gb\|FJ805896.1\|	259957	g2471	i0	87.96	111.48427672956	299	24	92	10	1	293	2945	3237	Uncultured Chroococcidiopsis sp. clone NA2_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35452	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10622327	10622327	PRJNA408129_S_NODE_2529_length_317_cov_3.160714_g2511_i0	PRJNA408129	2529	317	3.160714	10.01946338	Nostoc sp. UHCC 0870	2914041	Bacteria	Bacteria	193	1.68e-44	NTclustered	gi\|2190707562\|gb\|CP091913.1\|	2914041	g2511	i0	79.505	0.892744479495268	283	49	88	7	2	279	4557319	4557597	Nostoc sp. UHCC 0870 chromosome, complete genome	blastn	283	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0870
13172161	13172161	PRJNA408129_S_NODE_2531_length_317_cov_2.096429_g2513_i0	PRJNA408129	2531	317	2.096429	6.64567993	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	305	2.06e-78	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g2513	i0	84.295	17.1072555205047	312	49	98	0	3	314	2364465	2364776	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	5423	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
15110468	15110468	PRJNA408129_S_NODE_22872_length_171_cov_6.686567_g22854_i0	PRJNA408129	22872	171	6.686567	11.43402957	Nostocales	1161	Bacteria	Bacteria	143	8.26e-30	NTclustered	gi\|817925425\|gb\|CP011382.1\|	1337936	g22854	i0	93.75	9.18713450292398	96	4	56	2	10	104	2861420	2861514	Calothrix sp. 336/3, complete genome	blastn	1571	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. 336/3
16996017	16996017	PRJNA408129_S_NODE_8294_length_233_cov_8.836735_g8276_i0	PRJNA408129	8294	233	8.836735	20.58959255	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	348	2.37e-91	NTclustered	gi\|225696177\|gb\|FJ805844.1\|	259957	g8276	i0	95.413	106.811158798283	218	10	94	0	1	218	1871	2088	Uncultured Chroococcidiopsis sp. clone AU1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24887	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19544309	19544309	PRJNA408129_S_NODE_33136_length_153_cov_8.293103_g33118_i0	PRJNA408129	33136	153	8.293103	12.688447590000001	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	206	9.09e-49	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g33118	i0	92.908	150.385620915033	141	10	92	0	2	142	1388	1248	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	23009	206	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
19544349	19544349	PRJNA408129_S_NODE_4956_length_267_cov_133.982609_g4938_i0	PRJNA408129	4956	267	133.982609	357.73356603	Aliterella chasmolithica	2739056	Bacteria	Bacteria	379	9.869999999999997e-101	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g4938	i0	94.672	109.486891385768	244	13	91	0	11	254	2207	1964	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29233	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
20820123	20820123	PRJNA408129_S_NODE_27637_length_162_cov_2.392000_g27619_i0	PRJNA408129	27637	162	2.392	3.87504	Cylindrospermum sp. NIES-4074	2005457	Bacteria	Bacteria	156	9.99e-34	NTclustered	gi\|1210208533\|dbj\|AP018269.1\|	2005457	g27619	i0	84.81	1.69753086419753	158	20	96	4	7	162	1983505	1983660	Cylindrospermum sp. NIES-4074 DNA, nearly complete genome	blastn	275	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum sp. NIES-4074
24644778	24644778	PRJNA408129_S_NODE_22320_length_173_cov_1.801471_g22302_i0	PRJNA408129	22320	173	1.801471	3.11654483	Phormidium nigroviride	482564	Bacteria	Bacteria	298	1.69e-76	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g22302	i0	97.688	4	173	4	100	0	1	173	443316	443144	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	692	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride

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