metadata: contig_metadata: 22 rows where bioproject = "PRJNA561212" and tax_clade = "Cyanobacteriota/Melainabacteria group"

22 rows where bioproject = "PRJNA561212" 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
1821191	1821191	PRJNA561212_P_NODE_4842_length_503_cov_1.337209_g4632_i0	PRJNA561212	4842	503	1.337209	6.72616127	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	769	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g4632	i0	95.258	189.978131212724	485	23	96	0	10	494	3682179	3682663	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	95559	769	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
4373041	4373041	PRJNA561212_P_NODE_9864_length_351_cov_1.492806_g9653_i0	PRJNA561212	9864	351	1.492806	5.23974906	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	340	6.32e-89	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g9653	i0	85.329	74.3846153846154	334	44	95	4	11	342	3681396	3681066	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	26109	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6923453	6923453	PRJNA561212_P_NODE_23066_length_247_cov_1.298851_g22855_i0	PRJNA561212	23066	247	1.298851	3.20816197	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	396	8.95e-106	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g22855	i0	98.23	93.4777327935223	226	4	91	0	13	238	3680404	3680179	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	23089	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6923627	6923627	PRJNA561212_P_NODE_9626_length_355_cov_1.351064_g9415_i0	PRJNA561212	9626	355	1.351064	4.7962772	Nostoc sp. PCC 7107	317936	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|427357970\|gb\|CP003548.1\|	317936	g9415	i0	97.059	0.569014084507042	34	0	10	1	202	235	1990154	1990122	Nostoc sp. PCC 7107, complete genome	blastn	202	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7107
13299400	13299400	PRJNA561212_P_NODE_1651_length_842_cov_2.803641_g1464_i0	PRJNA561212	1651	842	2.803641	23.60665722	Calothrix parasitica	1973486	Bacteria	Bacteria	56.5	0.007	NTclustered	gi\|1210161462\|dbj\|AP018227.1\|	1973488	g1464	i0	100	0.0356294536817102	30	0	4	0	183	212	1699939	1699910	Calothrix parasitica NIES-267 DNA, nearly complete genome	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parasitica
15158730	15158730	PRJNA561212_P_NODE_12432_length_315_cov_2.078512_g12221_i0	PRJNA561212	12432	315	2.078512	6.5473128	Cyanophyceae	3028117	Bacteria	Bacteria	505	1.8799999999999995e-138	NTclustered	gi\|1345606788\|gb\|MG968522.1\|	102128	g12221	i0	97.306	126.530158730159	297	8	94	0	10	306	322	618	Leptolyngbya sp. PCC 73110 23S ribosomal RNA gene, partial sequence	blastn	39857	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 73110
15848322	15848322	PRJNA561212_P_NODE_24833_length_244_cov_0.912281_g24622_i0	PRJNA561212	24833	244	0.912281	2.22596564	Pseudanabaena sp. Chao 1811	2963092	Bacteria	Bacteria	58.4	4.73e-4	NTclustered	gi\|2429870828\|gb\|CP101416.1\|	2963092	g24622	i0	89.13	0.188524590163934	46	5	19	0	123	168	16043	16088	Pseudanabaena sp. Chao 1811 chromosome, complete genome	blastn	46	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. Chao 1811
20257211	20257211	PRJNA561212_P_NODE_19796_length_255_cov_1.565934_g19585_i0	PRJNA561212	19796	255	1.565934	3.9931317	Leptolyngbyaceae	1890438	Bacteria	Bacteria	422	1.53e-113	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g19585	i0	97.561	164.01568627451	246	6	96	0	10	255	4595	4840	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	41824	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
26794314	26794314	PRJNA561212_P_NODE_1381_length_923_cov_2.020000_g1211_i0	PRJNA561212	1381	923	2.02	18.6446	Calothrix sp. PCC 63	1187	Bacteria	Bacteria	86.3	7.77e-15	NR	WP_015196642.1	1170562	g1211	i0	31.3	1.24485373781148	208	127	67	7	77	694	242	435	WP_015196642.1 cytochrome P450 [Calothrix sp. PCC 6303]	diamond	1149	86.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
26840149	26840149	PRJNA561212_P_NODE_22321_length_249_cov_0.886364_g22110_i0	PRJNA561212	22321	249	0.886364	2.20704636	Cyanophyceae	3028117	Bacteria	Bacteria	127	8.699999999999999e-33	NR	WP_226587261.1	467598	g22110	i0	70.1	14.0722891566265	77	23	92.8	0	240	10	58	134	WP_226587261.1 selenium-binding family protein [Microseira wollei]	diamond	3504	128	0.9921875	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Microseira	Microseira wollei
27395366	27395366	PRJNA561212_P_NODE_16303_length_280_cov_1.381643_g16092_i0	PRJNA561212	16303	280	1.381643	3.8686004	Aphanothece sp. CMT-3BRIN-NPC111	2839655	Bacteria	Bacteria	43.9	0.023	NR	MBW4574449.1	2839655	g16092	i0	32.5	0.857142857142857	80	48	80.4	3	276	52	549	627	MBW4574449.1 hypothetical protein [Aphanothece sp. CMT-3BRIN-NPC111]	diamond	240	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece sp. CMT-3BRIN-NPC111
27931951	27931951	PRJNA561212_P_NODE_9985_length_349_cov_1.416667_g9774_i0	PRJNA561212	9985	349	1.416667	4.94416783	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	100	5.94e-22	NR	MBW4503829.1	1939789	g9774	i0	47.9	1.04011461318052	121	54	96.3	2	11	346	243	363	MBW4503829.1 NAD(P)-binding protein [Scytonema hyalinum WJT4-NPBG1]	diamond	363	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
28910422	28910422	PRJNA561212_P_NODE_21148_length_251_cov_1.151685_g20937_i0	PRJNA561212	21148	251	1.151685	2.89072935	Oscillatoria acuminata	118323	Bacteria	Bacteria	78.2	1.36e-14	NR	WP_015148269.1	118323	g20937	i0	76	2.45019920318725	50	12	59.8	0	19	168	543	592	WP_015148269.1 ABC transporter ATP-binding protein [Oscillatoria acuminata]	diamond	615	78.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
29682095	29682095	PRJNA561212_P_NODE_19210_length_259_cov_1.913978_g18999_i0	PRJNA561212	19210	259	1.913978	4.95720302	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	104	9.289999999999999e-24	NR	WP_011318991.1	1162	g18999	i0	59.5	8.71042471042471	84	33	96.1	1	3	251	72	155	WP_011318991.1 MULTISPECIES: DNA sulfur modification protein DndB [Nostocaceae]	diamond	2256	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae
29935225	29935225	PRJNA561212_P_NODE_7491_length_401_cov_1.536585_g7280_i0	PRJNA561212	7491	401	1.536585	6.16170585	Cyanophyceae	3028117	Bacteria	Bacteria	117	1.11e-27	NR	NJK35412.1	2720467	g7280	i0	47.3	8.67082294264339	131	66	95.8	2	392	9	247	377	NJK35412.1 M3 family metallopeptidase [Oscillatoriales cyanobacterium SM2_2_1]	diamond	3477	118	0.991525423728814	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium SM2_2_1
30173824	30173824	PRJNA561212_P_NODE_9352_length_360_cov_1.445993_g9141_i0	PRJNA561212	9352	360	1.445993	5.2055748	cyanobacterium TDX16	1503470	Bacteria	Bacteria	55.5	4.88e-6	NR	OWY70024.1	1503470	g9141	i0	32.3	0.825	99	66	81.7	1	307	14	455	553	OWY70024.1 hypothetical protein B7486_17105 [cyanobacterium TDX16]	diamond	297	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16
30458650	30458650	PRJNA561212_P_NODE_19013_length_261_cov_1.196809_g18802_i0	PRJNA561212	19013	261	1.196809	3.12367149	Limnofasciculus baicalensis	3064906	Bacteria	Bacteria	48.5	4.42e-4	NR	WP_254012206.1	3064906	g18802	i0	39.2	0.908045977011494	79	48	90.8	0	10	246	718	796	WP_254012206.1 colicin uptake protein [Limnofasciculus baicalensis]	diamond	237	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Limnofasciculus	Limnofasciculus baicalensis
31311326	31311326	PRJNA561212_P_NODE_22715_length_248_cov_0.891429_g22504_i0	PRJNA561212	22715	248	0.891429	2.21074392	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	49.3	4.4e-5	NR	MBK9202362.1	2711154	g22504	i0	48.9	0.544354838709677	45	23	54.4	0	239	105	16	60	MBK9202362.1 tetratricopeptide repeat protein [Candidatus Obscuribacter sp.]	diamond	135	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31659164	31659164	PRJNA561212_P_NODE_24657_length_244_cov_1.257310_g24446_i0	PRJNA561212	24657	244	1.25731	3.0678364	aff. Roholtiella sp. LEGE 12411	1828822	Bacteria	Bacteria	58.5	8.99e-9	NR	WP_244142014.1	1828822	g24446	i0	47.8	1.69672131147541	69	34	83.6	2	27	230	26	93	WP_244142014.1 hypothetical protein [aff. Roholtiella sp. LEGE 12411]	diamond	414	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Fortieaceae	Roholtiella	aff. Roholtiella sp. LEGE 12411
31690920	31690920	PRJNA561212_P_NODE_11897_length_322_cov_0.835341_g11686_i0	PRJNA561212	11897	322	0.835341	2.68979802	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	51.6	7.19e-5	NR	HEY9751917.1	3081323	g11686	i0	54.5	0.81055900621118	44	20	41	0	322	191	491	534	HEY9751917.1 tetratricopeptide repeat protein [Coleofasciculaceae cyanobacterium]	diamond	261	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
32147882	32147882	PRJNA561212_P_NODE_18498_length_264_cov_1.539267_g18287_i0	PRJNA561212	18498	264	1.539267	4.06366488	Pseudanabaena	1152	Bacteria	Bacteria	88.2	4.08e-18	NR	MDX2253976.1	2971805	g18287	i0	48.8	2.77272727272727	82	42	93.2	0	253	8	50	131	MDX2253976.1 aldehyde dehydrogenase [Pseudanabaenaceae cyanobacterium bins.39]	diamond	732	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae		Pseudanabaenaceae cyanobacterium bins.39
32432761	32432761	PRJNA561212_P_NODE_16819_length_276_cov_2.118227_g16608_i0	PRJNA561212	16819	276	2.118227	5.84630652	Nostocales	1161	Bacteria	Bacteria	93.2	9.29e-20	NR	WP_109011483.1	1178	g16608	i0	54.2	3.95652173913043	96	39	98.9	2	273	1	241	336	WP_109011483.1 NAD(P)-binding protein [Nostoc commune]	diamond	1092	93.6	0.995726495726496	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune

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