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

17 rows where analysis = "blastn", bioproject = "PRJNA849822" 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
2113924	2113924	PRJNA849822_P_NODE_12542_length_415_cov_2.459064_g12368_i0	PRJNA849822	12542	415	2.459064	10.2051156	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	671	0	NTclustered	gi\|745734142\|gb\|KM458348.1\|	183215	g12368	i0	99.459	108.703614457831	370	1	89	1	47	415	1	370	Uncultured Pleurocapsales cyanobacterium isolate OTU 00075 23S ribosomal RNA gene, partial sequence	blastn	45112	671	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
2113965	2113965	PRJNA849822_P_NODE_17542_length_346_cov_1.648352_g17368_i0	PRJNA849822	17542	346	1.648352	5.70329792	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	470	7.63e-128	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17368	i0	91.329	135.725433526012	346	26	99	4	1	344	3681200	3681543	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	46961	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
2113997	2113997	PRJNA849822_P_NODE_22082_length_308_cov_1.804255_g21908_i0	PRJNA849822	22082	308	1.804255	5.5571054	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	477	3.999999999999999e-130	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g21908	i0	94.771	143.321428571429	306	16	99	0	1	306	3458	3153	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44143	477	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2114008	2114008	PRJNA849822_P_NODE_23482_length_299_cov_1.048673_g23308_i0	PRJNA849822	23482	299	1.048673	3.13553227	uncultured Rivularia sp.	447564	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2621703013\|emb\|OY762007.1\|	447564	g23308	i0	100	0.0936454849498328	28	0	9	0	220	247	3246618	3246591	MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	uncultured Rivularia sp.
3389515	3389515	PRJNA849822_P_NODE_7663_length_552_cov_1.158664_g7491_i0	PRJNA849822	7663	552	1.158664	6.39582528	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	815	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g7491	i0	93.773	193.820652173913	546	28	99	4	1	545	3670008	3669468	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	106989	815	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
5941972	5941972	PRJNA849822_P_NODE_5705_length_655_cov_1.379725_g5536_i0	PRJNA849822	5705	655	1.379725	9.03719875	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	891	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g5536	i0	91.411	108.242748091603	652	53	99	3	1	649	1641	2292	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	70899	891	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8491522	8491522	PRJNA849822_P_NODE_34847_length_251_cov_2.623596_g34673_i0	PRJNA849822	34847	251	2.623596	6.58522596	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	226	1.2699999999999999e-54	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g34673	i0	83.071	63.7848605577689	254	38	99	5	1	250	3682129	3682381	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	16010	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8491577	8491577	PRJNA849822_P_NODE_41607_length_244_cov_0.912281_g41433_i0	PRJNA849822	41607	244	0.912281	2.22596564	Synechococcus sp. KORDI-49	585423	Bacteria	Bacteria	78.7	3.63e-10	NTclustered	gi\|670928808\|gb\|CP006270.1\|	585423	g41433	i0	94.118	18.0491803278689	51	3	21	0	194	244	1967545	1967495	Synechococcus sp. KORDI-49, complete genome	blastn	4404	78.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. KORDI-49
18689894	18689894	PRJNA849822_P_NODE_21395_length_313_cov_2.020833_g21221_i0	PRJNA849822	21395	313	2.020833	6.32520729	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	342	1.5499999999999996e-89	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g21221	i0	86.859	28.3961661341853	312	33	99	6	1	309	3680944	3681250	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	8888	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21240620	21240620	PRJNA849822_P_NODE_21577_length_312_cov_1.313808_g21403_i0	PRJNA849822	21577	312	1.313808	4.09908096	Nostoc edaphicum	264686	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g21403	i0	100	0.0897435897435897	28	0	9	0	268	295	1687496	1687523	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
21635591	21635591	PRJNA849822_P_NODE_2977_length_947_cov_1.591533_g2834_i0	PRJNA849822	2977	947	1.591533	15.07181751	Cyanophyceae	3028117	Bacteria	Bacteria	1321	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g2834	i0	91.912	106.512143611404	952	66	100	11	1	947	794074	795019	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	100867	1330	0.993233082706767	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
22515267	22515267	PRJNA849822_P_NODE_13618_length_397_cov_1.126543_g13444_i0	PRJNA849822	13618	397	1.126543	4.47237571	Anabaena cylindrica	1165	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|428682590\|gb\|CP003663.1\|	272123	g13444	i0	100	0.141057934508816	28	0	7	0	211	238	45448	45421	Anabaena cylindrica PCC 7122 plasmid pANACY.04, complete sequence	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
22515305	22515305	PRJNA849822_P_NODE_17638_length_345_cov_1.613971_g17464_i0	PRJNA849822	17638	345	1.613971	5.56819995	Pseudanabaena mucicola	71190	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2522923893\|gb\|CP097329.1\|	2942274	g17464	i0	100	0.0840579710144927	29	0	8	0	204	232	2761994	2762022	Pseudanabaena mucicola str. Chao 1806 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena mucicola
22515375	22515375	PRJNA849822_P_NODE_26598_length_282_cov_1.492823_g26424_i0	PRJNA849822	26598	282	1.492823	4.20976086	Chamaesiphon minutus	1173032	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|428015215\|gb\|CP003600.1\|	1173020	g26424	i0	100	0.106382978723404	30	0	11	0	207	236	5681967	5681996	Chamaesiphon minutus PCC 6605, complete genome	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
23790837	23790837	PRJNA849822_P_NODE_24359_length_293_cov_2.077273_g24185_i0	PRJNA849822	24359	293	2.077273	6.08640989	uncultured cyanobacterium	1211	Bacteria	Bacteria	514	2.88e-141	NTclustered	gi\|105990274\|gb\|DQ514005.1\|	1211	g24185	i0	98.294	100	293	5	100	0	1	293	170	462	Uncultured cyanobacterium clone 100M1_D9 16S ribosomal RNA gene, partial sequence	blastn	29300	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
24185035	24185035	PRJNA849822_P_NODE_18979_length_332_cov_1.567568_g18805_i0	PRJNA849822	18979	332	1.567568	5.20432576	Oscillatoriales	1150	Bacteria	Bacteria	603	6.889999999999997e-168	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g18805	i0	99.398	183.385542168675	332	2	100	0	1	332	1622	1291	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	60884	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
24185050	24185050	PRJNA849822_P_NODE_24439_length_293_cov_1.295455_g24265_i0	PRJNA849822	24439	293	1.295455	3.79568315	Bacteria	2	Bacteria	Bacteria	531	2.86e-146	NTclustered	gi\|199584193\|gb\|FJ028685.1\|	1211	g24265	i0	99.317	97.5051194539249	293	2	100	0	1	293	5	297	Uncultured cyanobacterium clone SSB-42 16S ribosomal RNA gene, partial sequence	blastn	28569	536	0.990671641791045	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);;