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

12 rows where analysis = "blastn", bioproject = "PRJNA716463" 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
1192797	1192797	PRJNA716463_P_NODE_28761_length_310_cov_2.649789_g28344_i0	PRJNA716463	28761	310	2.649789	8.2143459	Oscillatoriales	1150	Bacteria	Bacteria	484	2.4099999999999996e-132	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g28344	i0	93.458	196.609677419355	321	10	100	1	1	310	101519	101839	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	60949	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
1983284	1983284	PRJNA716463_P_NODE_113542_length_239_cov_2.548193_g113124_i0	PRJNA716463	113542	239	2.548193	6.09018127	Myxosarcina sp. SAG 30.84	1521510	Bacteria	Bacteria	425	1.1e-114	NTclustered	gi\|664803843\|gb\|KM019956.1\|	1521510	g113124	i0	98.745	100.041841004184	239	3	100	0	1	239	242	4	Myxosarcina sp. SAG 30.84 16S ribosomal RNA gene, partial sequence	blastn	23910	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Myxosarcina	Myxosarcina sp. SAG 30.84
1984284	1984284	PRJNA716463_P_NODE_64682_length_280_cov_2.487923_g64265_i0	PRJNA716463	64682	280	2.487923	6.9661844	Nostoc sp. PCC 7524	28072	Bacteria	Bacteria	512	9.85e-141	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g64265	i0	99.643	4.95714285714286	280	1	100	0	1	280	6008717	6008996	Nostoc sp. PCC 7524, complete genome	blastn	1388	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
1984458	1984458	PRJNA716463_P_NODE_75502_length_272_cov_2.015075_g75085_i0	PRJNA716463	75502	272	2.015075	5.481004	Phormidium nigroviride	482564	Bacteria	Bacteria	270	6.329999999999999e-68	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g75085	i0	84.559	5.90441176470588	272	42	100	0	1	272	4569664	4569935	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1606	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
4536176	4536176	PRJNA716463_P_NODE_34624_length_299_cov_3.955752_g34207_i0	PRJNA716463	34624	299	3.955752	11.82769848	Nostoc sp. ATCC 29106	82766	Bacteria	Bacteria	278	4.21e-70	NTclustered	gi\|4033739\|gb\|AF056037.1\|AF056037	82766	g34207	i0	100	3.96655518394649	150	0	100	0	150	299	858	709	Nostoc ATCC29106 modification methylase M.NspHI (nspHIM) and NspHI restriction endonuclease (nspHIR) genes, complete cds	blastn	1186	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 29106
5021411	5021411	PRJNA716463_P_NODE_83324_length_266_cov_1.595855_g82907_i0	PRJNA716463	83324	266	1.595855	4.2449743	Planktothrix	54304	Bacteria	Bacteria	178	3.849999999999999e-40	NTclustered	gi\|2261189783\|emb\|LR882967.1\|	132604	g82907	i0	79.518	1.87218045112782	249	51	94	0	18	266	2055039	2055287	Planktothrix pseudagardhii strain No.713 genome assembly, chromosome: I	blastn	498	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix pseudagardhii
5810976	5810976	PRJNA716463_P_NODE_116765_length_234_cov_2.465839_g116347_i0	PRJNA716463	116765	234	2.465839	5.77006326	Kamptonema animale	92934	Bacteria	Bacteria	335	1.8599999999999996e-87	NTclustered	gi\|1566846284\|dbj\|LC455664.1\|	92934	g116347	i0	93.363	171.884615384615	226	15	97	0	1	226	602	377	Kamptonema animale NIES-206 gene for 23S ribosomal RNA, partial sequence	blastn	40221	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Kamptonema	Kamptonema animale
7087272	7087272	PRJNA716463_P_NODE_80286_length_268_cov_2.564103_g79869_i0	PRJNA716463	80286	268	2.564103	6.87179604	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	187	6.449999999999998e-43	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g79869	i0	80.932	0.880597014925373	236	45	88	0	32	267	4120334	4120099	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	236	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8845688	8845688	PRJNA716463_P_NODE_12427_length_340_cov_0.861423_g12012_i0	PRJNA716463	12427	340	0.861423	2.9288382	Cyanophyceae	3028117	Bacteria	Bacteria	351	2.83e-92	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g12012	i0	85.423	151.558823529412	343	45	100	5	1	340	1873095	1873435	Leptolyngbya sp. O-77 DNA, complete genome	blastn	51530	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77
9636588	9636588	PRJNA716463_P_NODE_52688_length_289_cov_1.134259_g52271_i0	PRJNA716463	52688	289	1.134259	3.27800851	Phormidium sp. NIES-2115	2510784	Bacteria	Bacteria	460	3.749999999999999e-125	NTclustered	gi\|1566846238\|dbj\|LC455616.1\|	2510784	g52271	i0	95.517	154.536332179931	290	10	100	3	1	289	877	590	Phormidium sp. NIES-2115 gene for 23S ribosomal RNA, partial sequence	blastn	44661	460	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. NIES-2115
11396765	11396765	PRJNA716463_P_NODE_90489_length_260_cov_1.614973_g90072_i0	PRJNA716463	90489	260	1.614973	4.1989298	Oscillatoriales	1150	Bacteria	Bacteria	468	1.99e-127	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g90072	i0	99.231	145.673076923077	260	1	100	1	1	260	1071	813	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	37875	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
21595357	21595357	PRJNA716463_P_NODE_87557_length_262_cov_2.878307_g87140_i0	PRJNA716463	87557	262	2.878307	7.54116434	root	1	Root_unresolved	Root_unresolved	484	1.99e-132	NTclustered	gi\|892164921\|gb\|KT182535.1\|	1211	g87140	i0	100	99.7099236641221	262	0	100	0	1	262	1342	1081	Uncultured cyanobacterium clone MBR Ca 100ppm 6 16S ribosomal RNA gene, partial sequence	blastn	26124	484	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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