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

25 rows where analysis = "blastn", bioproject = "PRJNA816047" 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
25595945	25595945	PRJNA816047a_S_NODE_73929_length_248_cov_5.388571_g71269_i0	PRJNA816047	73929	248	5.388571	13.36365608	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	237	5.77e-58	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g71269	i0	86.301	2.4758064516129	219	28	88	2	7	224	1270688	1270471	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	614	237	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
25603065	25603065	PRJNA816047d_S_NODE_24545_length_434_cov_3.572178_g22717_i0	PRJNA816047	24545	434	3.572178	15.50325252	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	612	1.53e-170	NTclustered	gi\|225696226\|gb\|FJ805893.1\|	259957	g22717	i0	96.257	94.1820276497696	374	13	86	1	62	434	2899	2526	Uncultured Chroococcidiopsis sp. clone NA2_7 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40875	612	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25604336	25604336	PRJNA816047d_S_NODE_45217_length_325_cov_1.801471_g43382_i0	PRJNA816047	45217	325	1.801471	5.85478075	Allocoleopsis franciscana PCC 7113	1173027	Bacteria	Bacteria	198	3.71e-46	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g43382	i0	78.056	0.981538461538462	319	66	98	4	3	319	7451589	7451273	Allocoleopsis franciscana PCC 7113, complete genome	blastn	319	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
25606220	25606220	PRJNA816047d_S_NODE_81953_length_261_cov_1.870192_g80118_i0	PRJNA816047	81953	261	1.870192	4.88120112	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	185	2.2499999999999994e-42	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g80118	i0	90.714	41.6973180076628	140	12	53	1	113	251	4231739	4231600	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	10883	185	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
25737389	25737389	PRJNA816047d_S_NODE_11690_length_705_cov_4654.866564_g10186_i0	PRJNA816047	11690	705	4654.866564	32816.8092762	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	754	0	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g10186	i0	93.504	81.7333333333333	508	31	72	2	52	557	1667	2174	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	57622	754	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25741832	25741832	PRJNA816047d_S_NODE_68418_length_277_cov_1.098214_g66583_i0	PRJNA816047	68418	277	1.098214	3.04205278	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	424	4.69e-114	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g66583	i0	94.224	1	277	16	100	0	1	277	5232004	5231728	Calothrix sp. PCC 7716 DNA, complete genome	blastn	277	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
25866284	25866284	PRJNA816047a_S_NODE_53691_length_288_cov_2.455814_g51031_i0	PRJNA816047	53691	288	2.455814	7.07274432	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	503	6.12e-138	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g51031	i0	98.596	62.6423611111111	285	3	99	1	1	285	4450634	4450351	Calothrix sp. PCC 7716 DNA, complete genome	blastn	18041	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
25868580	25868580	PRJNA816047a_S_NODE_84643_length_226_cov_2.071895_g81983_i0	PRJNA816047	84643	226	2.071895	4.6824827	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	189	1.4699999999999999e-43	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g81983	i0	97.297	159.287610619469	111	3	66	0	21	131	4626796	4626686	Leptolyngbya sp. 7M chromosome	blastn	35999	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
25870197	25870197	PRJNA816047b_S_NODE_27355_length_315_cov_4.177686_g25043_i0	PRJNA816047	27355	315	4.177686	13.1597109	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	5.42e-114	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g25043	i0	99.569	83.6666666666667	232	1	74	0	74	305	2808	2577	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	26355	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25871382	25871382	PRJNA816047b_S_NODE_43371_length_260_cov_2.850267_g41059_i0	PRJNA816047	43371	260	2.850267	7.4106942	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	255	1.68e-63	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g41059	i0	94.048	78.5230769230769	168	10	65	0	93	260	2178	2011	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	20416	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
25873157	25873157	PRJNA816047d_S_NODE_117515_length_242_cov_1.539683_g115680_i0	PRJNA816047	117515	242	1.539683	3.72603286	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	383	6.81e-102	NTclustered	gi\|225696216\|gb\|FJ805883.1\|	259957	g115680	i0	96.17	110.818181818182	235	8	97	1	8	242	2204	2437	Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26818	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25875326	25875326	PRJNA816047d_S_NODE_28227_length_401_cov_3.468391_g26395_i0	PRJNA816047	28227	401	3.468391	13.90824791	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	568	3.09e-157	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g26395	i0	92.269	140.478802992519	401	30	99	1	1	400	3263	2863	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	56332	568	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25876312	25876312	PRJNA816047d_S_NODE_44875_length_326_cov_1.611722_g43040_i0	PRJNA816047	44875	326	1.611722	5.25421372	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	446	1.1999999999999995e-120	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g43040	i0	92.188	190.957055214724	320	17	97	7	12	326	1857892	1857576	Calothrix sp. PCC 7716 DNA, complete genome	blastn	62252	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
25876990	25876990	PRJNA816047d_S_NODE_57179_length_296_cov_5.403292_g55344_i0	PRJNA816047	57179	296	5.403292	15.99374432	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	401	2.3699999999999988e-107	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g55344	i0	91.554	114.314189189189	296	18	99	7	5	296	2123	1831	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33837	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25998860	25998860	PRJNA816047a_S_NODE_11620_length_592_cov_7.589595_g9044_i0	PRJNA816047	11620	592	7.589595	44.9304024	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	597	5.999999999999998e-166	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g9044	i0	88.641	152	493	53	93	3	39	529	1601	2092	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	89984	597	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
26005168	26005168	PRJNA816047b_S_NODE_11244_length_455_cov_3.041885_g8948_i0	PRJNA816047	11244	455	3.041885	13.84057675	Synechocystis sp. LKSZ1	3144951	Bacteria	Bacteria	104	1.2e-17	NTclustered	gi\|2736090469\|dbj\|AP031572.1\|	3144951	g8948	i0	86.458	0.421978021978022	96	12	21	1	317	412	1623755	1623661	Synechocystis sp. LKSZ1 DNA, complete genome	blastn	192	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. LKSZ1
26014458	26014458	PRJNA816047d_S_NODE_78852_length_263_cov_7.828571_g77017_i0	PRJNA816047	78852	263	7.828571	20.58914173	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	121	6.489999999999999e-23	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g77017	i0	83.333	45.0836501901141	132	20	50	2	71	201	2576654	2576524	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	11857	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26177132	26177132	PRJNA816047a_S_NODE_22037_length_432_cov_13337.657382_g19385_i0	PRJNA816047	22037	432	13337.657382	57618.67989024	Oscillatoriales	1150	Bacteria	Bacteria	501	3.44e-137	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g19385	i0	96.689	126.386574074074	302	8	71	2	80	381	811626	811925	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	54599	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
26282141	26282141	PRJNA816047d_S_NODE_133222_length_228_cov_2.188571_g131387_i0	PRJNA816047	133222	228	2.188571	4.98994188	Cylindrospermum sp. NIES-4	2910429	Bacteria	Bacteria	183	6.909999999999998e-42	NTclustered	gi\|1210208533\|dbj\|AP018269.1\|	2005457	g131387	i0	81.818	2.91666666666667	220	38	96	2	1	219	1772942	1772724	Cylindrospermum sp. NIES-4074 DNA, nearly complete genome	blastn	665	183	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum sp. NIES-4074
26284093	26284093	PRJNA816047d_S_NODE_32534_length_374_cov_3.358255_g30700_i0	PRJNA816047	32534	374	3.358255	12.5598737	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	176	2.02e-39	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g30700	i0	94.017	29.9197860962567	117	6	31	1	139	255	1700	1585	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	11190	176	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
26285695	26285695	PRJNA816047d_S_NODE_61102_length_289_cov_2.529661_g59267_i0	PRJNA816047	61102	289	2.529661	7.31072029	Fischerella sp. NIES-3754	1752063	Bacteria	Bacteria	167	9.16e-37	NTclustered	gi\|965684975\|dbj\|AP017305.1\|	1752063	g59267	i0	88.406	10.159169550173	138	16	48	0	139	276	818186	818323	Fischerella sp. NIES-3754 DNA, complete genome	blastn	2936	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. NIES-3754
26286211	26286211	PRJNA816047d_S_NODE_70998_length_273_cov_1.113636_g69163_i0	PRJNA816047	70998	273	1.113636	3.04022628	Allocoleopsis franciscana PCC 7113	1173027	Bacteria	Bacteria	239	1.79e-58	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g69163	i0	91.379	0.637362637362637	174	15	64	0	1	174	3361052	3361225	Allocoleopsis franciscana PCC 7113, complete genome	blastn	174	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
26410456	26410456	PRJNA816047a_S_NODE_52119_length_291_cov_2.559633_g49459_i0	PRJNA816047	52119	291	2.559633	7.44853203	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	315	3.11e-81	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g49459	i0	98.333	73.4982817869416	180	2	62	1	30	208	1999	2178	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	21388	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
26546919	26546919	PRJNA816047a_S_NODE_54872_length_285_cov_3.174528_g52212_i0	PRJNA816047	54872	285	3.174528	9.0474048	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	265	3.11e-66	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g52212	i0	96.273	121.175438596491	161	6	56	0	101	261	1859029	1859189	Calothrix sp. PCC 7716 DNA, complete genome	blastn	34535	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
26558762	26558762	PRJNA816047d_S_NODE_86792_length_258_cov_1.297561_g84957_i0	PRJNA816047	86792	258	1.297561	3.34770738	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g84957	i0	97.059	0.131782945736434	34	0	13	1	172	205	57881	57913	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	34	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium

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