metadata: contig_metadata: 27 rows where bioproject = "PRJEB81463" and tax_clade = "Cyanobacteriota/Melainabacteria group"

27 rows where bioproject = "PRJEB81463" 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
140485	140485	PRJEB81463_P_NODE_23821_length_248_cov_0.891429_g23549_i0	PRJEB81463	23821	248	0.891429	2.21074392	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'	1618022	Bacteria	Bacteria	303	5.61e-78	NTclustered	gi\|1349670869\|gb\|CP026692.1\|	1618022	g23549	i0	88.71	1	248	28	100	0	1	248	1424859	1424612	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont' strain 5183 chromosome, complete genome	blastn	248	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'
3966601	3966601	PRJEB81463_P_NODE_23144_length_249_cov_0.886364_g22872_i0	PRJEB81463	23144	249	0.886364	2.20704636	Microcoleus vaginatus	119532	Bacteria	Bacteria	433	6.89e-117	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g22872	i0	97.992	26.3734939759036	249	5	100	0	1	249	4034430	4034678	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	6567	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
7792581	7792581	PRJEB81463_P_NODE_13607_length_284_cov_1.919431_g13335_i0	PRJEB81463	13607	284	1.919431	5.45118404	Microcoleus vaginatus	119532	Bacteria	Bacteria	492	1.2999999999999999e-134	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g13335	i0	97.887	179.225352112676	284	6	100	0	1	284	1374444	1374727	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	50900	492	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
10343525	10343525	PRJEB81463_P_NODE_25849_length_245_cov_0.906977_g25577_i0	PRJEB81463	25849	245	0.906977	2.22209365	Nostocales	1161	Bacteria	Bacteria	149	1.4999999999999998e-39	NR	WP_029634421.1	1161	g25577	i0	91.4	3.96734693877551	81	7	99.2	0	3	245	304	384	WP_029634421.1 MULTISPECIES: ATP-binding cassette domain-containing protein [Nostocales]	diamond	972	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
10343667	10343667	PRJEB81463_P_NODE_5489_length_427_cov_3.915254_g5217_i0	PRJEB81463	5489	427	3.915254	16.71813458	Aliterella chasmolithica	2739056	Bacteria	Bacteria	717	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g5217	i0	96.956	116.789227166276	427	13	100	0	1	427	2011	2437	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	49869	717	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
13750783	13750783	PRJEB81463_P_NODE_24311_length_247_cov_0.896552_g24039_i0	PRJEB81463	24311	247	0.896552	2.21448344	Nostocaceae	1162	Bacteria	Bacteria	171	5.91e-38	NTclustered	gi\|1334417636\|gb\|CP023278.1\|	1869241	g24039	i0	79.661	2.91497975708502	236	48	96	0	4	239	5819972	5819737	Nostoc sp. CENA543 chromosome, complete genome	blastn	720	172	0.994186046511628	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CENA543
14169113	14169113	PRJEB81463_P_NODE_8632_length_342_cov_2.066914_g8360_i0	PRJEB81463	8632	342	2.066914	7.06884588	Aliterella chasmolithica	2739056	Bacteria	Bacteria	444	4.57e-120	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g8360	i0	90.087	118.631578947368	343	32	100	2	1	342	2011	2352	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	40572	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
15025221	15025221	PRJEB81463_P_NODE_13092_length_287_cov_1.546729_g12820_i0	PRJEB81463	13092	287	1.546729	4.43911223	Nostocaceae	1162	Bacteria	Bacteria	525	1.2999999999999995e-144	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g12820	i0	99.652	266.261324041812	287	1	100	0	1	287	3059626	3059340	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	76417	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
16717135	16717135	PRJEB81463_P_NODE_19574_length_255_cov_1.620879_g19302_i0	PRJEB81463	19574	255	1.620879	4.13324145	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	174	4.74e-39	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g19302	i0	80.081	41.9647058823529	246	39	94	10	1	239	2362897	2363139	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	10701	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
17991897	17991897	PRJEB81463_P_NODE_14855_length_278_cov_1.170732_g14583_i0	PRJEB81463	14855	278	1.170732	3.25463496	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	147	2.64e-41	NR	WP_106369252.1	2107693	g14583	i0	88	0.992805755395683	92	11	99.3	0	3	278	197	288	WP_106369252.1 DUF2382 domain-containing protein [Chlorogloea sp. CCALA 695]	diamond	276	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
17991992	17991992	PRJEB81463_P_NODE_21255_length_251_cov_1.938202_g20983_i0	PRJEB81463	21255	251	1.938202	4.86488702	Calothrix sp. PCC 7507	99598	Bacteria	Bacteria	209	1.28e-49	NTclustered	gi\|427347790\|gb\|CP003943.1\|	99598	g20983	i0	81.673	2.71713147410359	251	46	100	0	1	251	6288870	6288620	Calothrix sp. PCC 7507 chromosome, complete genome	blastn	682	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7507
21817479	21817479	PRJEB81463_P_NODE_898_length_1033_cov_2.635417_g714_i0	PRJEB81463	898	1033	2.635417	27.22385761	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1495	0	NTclustered	gi\|225696175\|gb\|FJ805842.1\|	259957	g714	i0	92.913	105.193610842207	1030	69	99	4	3	1030	3106	2079	Uncultured Chroococcidiopsis sp. clone AU1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	108665	1495	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21817485	21817485	PRJEB81463_P_NODE_9318_length_330_cov_1.214008_g9046_i0	PRJEB81463	9318	330	1.214008	4.0062264	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	499	9.23e-137	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g9046	i0	93.994	183.715151515152	333	15	100	5	1	330	816	486	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	60626	499	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
23949776	23949776	PRJEB81463_P_NODE_14579_length_279_cov_1.514563_g14307_i0	PRJEB81463	14579	279	1.514563	4.22563077	root	1	Root_unresolved	Root_unresolved	510	3.5299999999999996e-140	NTclustered	gi\|691483284\|gb\|KM006898.1\|	1211	g14307	i0	99.642	98.8028673835125	279	1	100	0	1	279	170	448	Uncultured cyanobacterium clone 3B-31 16S ribosomal RNA gene, partial sequence	blastn	27566	510	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26748973	26748973	PRJEB81463_P_NODE_25221_length_246_cov_0.901734_g24949_i0	PRJEB81463	25221	246	0.901734	2.21826564	Richelia sp. RM2_1_2	2720436	Bacteria	Bacteria	119	4.779999999999999e-32	NR	NJO65654.1	2720436	g24949	i0	67.9	0.98780487804878	81	25	98.8	1	2	244	3	82	NJO65654.1 PCRF domain-containing protein [Richelia sp. RM2_1_2]	diamond	243	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sp. RM2_1_2
28637832	28637832	PRJEB81463_P_NODE_20467_length_253_cov_0.866667_g20195_i0	PRJEB81463	20467	253	0.866667	2.19266751	Cyanophyceae	3028117	Bacteria	Bacteria	74.7	1.99e-13	NR	MBW4577150.1	2839655	g20195	i0	42.2	2.94071146245059	83	45	97.2	2	247	2	230	310	MBW4577150.1 low temperature requirement protein A [Aphanothece sp. CMT-3BRIN-NPC111]	diamond	744	74.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece sp. CMT-3BRIN-NPC111
28700897	28700897	PRJEB81463_P_NODE_20887_length_252_cov_0.871508_g20615_i0	PRJEB81463	20887	252	0.871508	2.19620016	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	66.6	6.76e-11	NR	WP_334915882.1	1180	g20615	i0	41.3	7.36904761904762	75	41	89.3	1	27	251	5	76	WP_334915882.1 alpha/beta hydrolase [Nostoc sp.]	diamond	1857	66.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
28985230	28985230	PRJEB81463_P_NODE_21688_length_251_cov_0.876404_g21416_i0	PRJEB81463	21688	251	0.876404	2.19977404	Cyanophyceae	3028117	Bacteria	Bacteria	125	2.32e-31	NR	MDJ0535884.1	3036641	g21416	i0	77.1	3.9203187250996	83	19	99.2	0	2	250	405	487	MDJ0535884.1 molybdopterin-dependent oxidoreductase [Xenococcaceae cyanobacterium MO_207.B15]	diamond	984	126	0.992063492063492	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Xenococcaceae		Xenococcaceae cyanobacterium MO_207.B15
29118807	29118807	PRJEB81463_P_NODE_9229_length_331_cov_5.267442_g8957_i0	PRJEB81463	9229	331	5.267442	17.43523302	unclassified Microcoleus	2642155	Bacteria	Bacteria	80.5	1.71e-16	NR	WP_333266733.1	2642155	g8957	i0	40.5	1.98489425981873	111	64	98.8	2	330	4	35	145	WP_333266733.1 MULTISPECIES: hypothetical protein [unclassified Microcoleus]	diamond	657	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus
29395430	29395430	PRJEB81463_P_NODE_25149_length_246_cov_0.901734_g24877_i0	PRJEB81463	25149	246	0.901734	2.21826564	Cyanophyceae	3028117	Bacteria	Bacteria	154	4.13e-43	NR	MBW4472077.1	1382958	g24877	i0	92.6	1.97560975609756	81	6	98.8	0	3	245	22	102	MBW4472077.1 glycosyltransferase family 4 protein [Stenomitos rutilans HA7619-LM2]	diamond	486	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos rutilans
29844720	29844720	PRJEB81463_P_NODE_21711_length_251_cov_0.876404_g21439_i0	PRJEB81463	21711	251	0.876404	2.19977404	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	44.3	0.0114	NR	MEB3237294.1	2762020	g21439	i0	55.6	0.836653386454183	27	12	32.3	0	178	98	19	45	MEB3237294.1 protein kinase [Candidatus Sericytochromatia bacterium]	diamond	210	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
29932425	29932425	PRJEB81463_P_NODE_30071_length_220_cov_4.129252_g29799_i0	PRJEB81463	30071	220	4.129252	9.0843544	Coleofasciculus	669368	Bacteria	Bacteria	60.8	3.85e-10	NR	MEQ9550622.1	3069528	g29799	i0	42.9	3.42272727272727	63	36	85.9	0	190	2	6	68	MEQ9550622.1 hypothetical protein [Coleofasciculus sp. G3-WIS-01]	diamond	753	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. G3-WIS-01
30634435	30634435	PRJEB81463_P_NODE_27133_length_243_cov_1.476471_g26861_i0	PRJEB81463	27133	243	1.476471	3.58782453	Umezakia ovalisporum	75695	Bacteria	Bacteria	88.6	1.79e-20	NR	WP_414521423.1	75695	g26861	i0	100	0.641975308641975	52	0	64.2	0	3	158	3	54	WP_414521423.1 hypothetical protein, partial [Umezakia ovalisporum]	diamond	156	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Umezakia	Umezakia ovalisporum
31551498	31551498	PRJEB81463_P_NODE_14196_length_281_cov_1.500000_g13924_i0	PRJEB81463	14196	281	1.5	4.215	Leptolyngbyaceae cyanobacterium M65_K2018_010	2747810	Bacteria	Bacteria	51.2	3.03e-5	NR	HIK43646.1	2747810	g13924	i0	67.7	0.330960854092527	31	10	33.1	0	112	20	159	189	HIK43646.1 zinc ribbon domain-containing protein [Leptolyngbyaceae cyanobacterium M65_K2018_010]	diamond	93	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium M65_K2018_010
32057355	32057355	PRJEB81463_P_NODE_24858_length_246_cov_1.739884_g24586_i0	PRJEB81463	24858	246	1.739884	4.28011464	Chroogloeocystis siderophila	329163	Bacteria	Bacteria	93.2	1.45e-20	NR	WP_084544412.1	329163	g24586	i0	46.3	0.975609756097561	80	43	97.6	0	242	3	142	221	WP_084544412.1 sulfotransferase family protein [Chroogloeocystis siderophila]	diamond	240	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroogloeocystis	Chroogloeocystis siderophila
32657784	32657784	PRJEB81463_P_NODE_24220_length_247_cov_1.178161_g23948_i0	PRJEB81463	24220	247	1.178161	2.91005767	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	127	4.9999999999999996e-33	NR	WP_106369630.1	2107693	g23948	i0	86.4	3.93522267206478	81	11	98.4	0	245	3	184	264	WP_106369630.1 RNA-guided endonuclease InsQ/TnpB family protein [Chlorogloea sp. CCALA 695]	diamond	972	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
32783937	32783937	PRJEB81463_P_NODE_29620_length_229_cov_2.192308_g29348_i0	PRJEB81463	29620	229	2.192308	5.02038532	Aphanocapsa feldmannii 277cV	2507553	Bacteria	Bacteria	41.6	0.0304	NR	TGG91043.1	2507553	g29348	i0	36.7	0.641921397379913	49	29	64.2	1	81	227	18	64	TGG91043.1 MAG: NIPSNAP family protein [Aphanocapsa feldmannii 277cV]	diamond	147	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Aphanocapsa	Aphanocapsa feldmannii

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