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

21 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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
1013295	1013295	PRJNA1067370_P_NODE_521_length_1868_cov_3.769916_g382_i0	PRJNA1067370	521	1868	3.769916	70.42203088	Chroococcidiopsis	54298	Bacteria	Bacteria	3265	0	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g382	i0	98.184	163.429336188437	1872	30	100	4	1	1868	3817	1946	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	305286	3265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
2731091	2731091	PRJNA1067370_P_NODE_111003_length_242_cov_0.911243_g110454_i0	PRJNA1067370	111003	242	0.911243	2.20520806	Nostoc flagelliforme	1306274	Bacteria	Bacteria	420	5.19e-113	NTclustered	gi\|1297075411\|gb\|CP024785.1\|	2038116	g110454	i0	97.934	14.4462809917355	242	5	100	0	1	242	6781912	6782153	Nostoc flagelliforme CCNUN1 chromosome, complete genome	blastn	3496	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
2731455	2731455	PRJNA1067370_P_NODE_53563_length_289_cov_2.268519_g53014_i0	PRJNA1067370	53563	289	2.268519	6.55601991	Brasilonema sennae	1397703	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g53014	i0	94.444	0.124567474048443	36	0	12	2	153	186	6493155	6493190	Brasilonema sennae CENA114 chromosome	blastn	36	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
2731566	2731566	PRJNA1067370_P_NODE_74783_length_257_cov_2.320652_g74234_i0	PRJNA1067370	74783	257	2.320652	5.96407564	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	370	5.68e-98	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g74234	i0	92.607	172.097276264591	257	19	100	0	1	257	435	179	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	44229	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
4007433	4007433	PRJNA1067370_P_NODE_58944_length_281_cov_1.735577_g58395_i0	PRJNA1067370	58944	281	1.735577	4.87697137	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	475	1.2999999999999999e-129	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g58395	i0	97.153	235.409252669039	281	8	100	0	1	281	1859310	1859030	Calothrix sp. PCC 7716 DNA, complete genome	blastn	66150	475	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
4007546	4007546	PRJNA1067370_P_NODE_76064_length_256_cov_0.857923_g75515_i0	PRJNA1067370	76064	256	0.857923	2.19628288	Nodularia sphaerocarpa	137816	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2198613447\|gb\|CP060140.1\|	2761619	g75515	i0	100	0.109375	28	0	11	0	23	50	3440816	3440789	Nodularia sphaerocarpa UHCC 0038 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia sphaerocarpa
6116376	6116376	PRJNA1067370_P_NODE_31405_length_349_cov_2.130435_g30857_i0	PRJNA1067370	31405	349	2.130435	7.43521815	Pleurocapsales	52604	Bacteria	Bacteria	523	5.809999999999998e-144	NTclustered	gi\|1373447558\|gb\|KY979120.1\|	118165	g30857	i0	93.696	205.418338108883	349	22	100	0	1	349	692	344	Stanieria sp. PCC 7301 strain UTEX LB 1635 23S ribosomal RNA gene, partial sequence	blastn	71691	523	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria sp. PCC 7301
6116389	6116389	PRJNA1067370_P_NODE_35805_length_333_cov_0.888462_g35257_i0	PRJNA1067370	35805	333	0.888462	2.95857846	Gloeomargarita	1188227	Bacteria	Bacteria	207	6.33e-49	NTclustered	gi\|1100591715\|gb\|CP017675.1\|	1188229	g35257	i0	79.73	75.6486486486486	296	52	88	8	42	333	806053	806344	Gloeomargarita lithophora Alchichica-D10 chromosome	blastn	25191	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeomargaritales	Gloeomargaritaceae	Gloeomargarita	Gloeomargarita lithophora
9108280	9108280	PRJNA1067370_P_NODE_18788_length_432_cov_0.871866_g18240_i0	PRJNA1067370	18788	432	0.871866	3.76646112	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	610	5.4899999999999996e-170	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g18240	i0	92.166	125.979166666667	434	31	100	3	1	432	2088	1656	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	54423	610	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10384309	10384309	PRJNA1067370_P_NODE_68649_length_267_cov_0.793814_g68100_i0	PRJNA1067370	68649	267	0.793814	2.11948338	Microcoleus vaginatus	119532	Bacteria	Bacteria	494	3.38e-135	NTclustered	gi\|1519336827\|gb\|MK211228.1\|	2489143	g68100	i0	100	150.250936329588	267	0	100	0	1	267	2549	2283	Microcoleus vaginatus KZ-23-1 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	40117	494	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
11659548	11659548	PRJNA1067370_P_NODE_52750_length_291_cov_0.844037_g52201_i0	PRJNA1067370	52750	291	0.844037	2.45614767	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	501	2.23e-137	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g52201	i0	97.924	122.594501718213	289	6	99	0	3	291	1244840	1244552	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	35675	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
11659716	11659716	PRJNA1067370_P_NODE_79210_length_251_cov_1.314607_g78661_i0	PRJNA1067370	79210	251	1.314607	3.29966357	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	390	4.239999999999999e-104	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g78661	i0	95.142	1.96812749003984	247	12	98	0	2	248	5920822	5921068	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	494	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
15483610	15483610	PRJNA1067370_P_NODE_39773_length_320_cov_1.068826_g39225_i0	PRJNA1067370	39773	320	1.068826	3.4202432	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	503	6.89e-138	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g39225	i0	95.541	127.4125	314	14	98	0	7	320	2617	2304	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40772	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15483709	15483709	PRJNA1067370_P_NODE_56393_length_285_cov_1.849057_g55844_i0	PRJNA1067370	56393	285	1.849057	5.26981245	Pleurocapsa minor	54308	Bacteria	Bacteria	505	1.6799999999999995e-138	NTclustered	gi\|2717502817\|gb\|PP667998.1\|	3139816	g55844	i0	98.596	128.950877192982	285	4	100	0	1	285	2249	2533	Pleurocapsa minor SAG 4.99 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36751	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa minor
16315584	16315584	PRJNA1067370_P_NODE_103253_length_244_cov_0.900585_g102704_i0	PRJNA1067370	103253	244	0.900585	2.1974274	Chroococcidiopsis	54298	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g102704	i0	98.77	2.77868852459016	244	3	100	0	1	244	1980585	1980342	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	678	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
19306340	19306340	PRJNA1067370_P_NODE_19096_length_428_cov_2.233803_g18548_i0	PRJNA1067370	19096	428	2.233803	9.56067684	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	715	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g18548	i0	97.608	177.570093457944	418	8	97	2	1	417	3669794	3670210	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	76000	715	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
20581742	20581742	PRJNA1067370_P_NODE_12157_length_524_cov_3.050998_g11612_i0	PRJNA1067370	12157	524	3.050998	15.98722952	Aliterella chasmolithica	2739056	Bacteria	Bacteria	725	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g11612	i0	91.778	110.101145038168	523	39	99	3	4	524	2500	1980	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	57693	725	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
20581949	20581949	PRJNA1067370_P_NODE_34517_length_337_cov_1.670455_g33969_i0	PRJNA1067370	34517	337	1.670455	5.62943335	Tolypothrix tenuis	457083	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|1210177014\|dbj\|AP018248.1\|	231146	g33969	i0	100	0.0830860534124629	28	0	8	0	201	228	39333	39360	Tolypothrix tenuis PCC 7101 DNA, nearly complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix tenuis
22690072	22690072	PRJNA1067370_P_NODE_50158_length_296_cov_1.874439_g49610_i0	PRJNA1067370	50158	296	1.874439	5.54833944	Cyanophyceae	3028117	Bacteria	Bacteria	531	2.899999999999999e-146	NTclustered	gi\|1053098883\|gb\|KT715251.1\|	1211	g49610	i0	98.986	100	296	3	100	0	1	296	265	560	Uncultured cyanobacterium clone C69 16S ribosomal RNA gene, partial sequence	blastn	29600	536	0.990671641791045	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23132919	23132919	PRJNA1067370_P_NODE_115259_length_241_cov_0.916667_g114710_i0	PRJNA1067370	115259	241	0.916667	2.20916747	Calothrix sp. PCC 7507	99598	Bacteria	Bacteria	158	4.47e-34	NTclustered	gi\|427347790\|gb\|CP003943.1\|	99598	g114710	i0	80.66	0.879668049792531	212	33	87	7	1	209	553536	553330	Calothrix sp. PCC 7507 chromosome, complete genome	blastn	212	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7507
24406814	24406814	PRJNA1067370_P_NODE_47360_length_303_cov_1.152174_g46812_i0	PRJNA1067370	47360	303	1.152174	3.49108722	Dolichospermum heterosporum	747522	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2283110535\|gb\|CP099464.1\|	747523	g46812	i0	100	0.0924092409240924	28	0	9	0	50	77	2802899	2802872	Dolichospermum heterosporum TAC447 strain NIES-1697 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum heterosporum

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