metadata: contig_metadata: 23 rows where bioproject = "PRJDB4941" and tax_clade = "Cyanobacteriota/Melainabacteria group"

23 rows where bioproject = "PRJDB4941" 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
3836894	3836894	PRJDB4941_P_NODE_9704_length_367_cov_2.025157_g8936_i0	PRJDB4941	9704	367	2.025157	7.43232619	Candidatus Tanganyikabacteria bacterium	2961651	Bacteria	Bacteria	81.6	1.38e-16	NR	MBM3267038.1	2961651	g8936	i0	71.9	0.465940054495913	57	16	46.6	0	362	192	106	162	MBM3267038.1 GNAT family N-acetyltransferase [Candidatus Tanganyikabacteria bacterium]	diamond	171	81.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Tanganyikabacteria bacterium
6388869	6388869	PRJDB4941_P_NODE_6566_length_488_cov_2.564920_g5799_i0	PRJDB4941	6566	488	2.56492	12.5168096	Cyanobacteria bacterium PR.3.49	2067978	Bacteria	Bacteria	246	4.15e-77	NR	MBA3856142.1	2067978	g5799	i0	72.8	1.99180327868852	162	44	99.6	0	1	486	265	426	MBA3856142.1 Xaa-Pro dipeptidase [Cyanobacteria bacterium PR.3.49]	diamond	972	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.3.49
15312750	15312750	PRJDB4941_P_NODE_41233_length_162_cov_0.920354_g40465_i0	PRJDB4941	41233	162	0.920354	1.49097348	Nostoc sp. MS1	2764711	Bacteria	Bacteria	78.7	2.22e-10	NTclustered	gi\|2093825993\|dbj\|AP023441.1\|	2764711	g40465	i0	86.301	0.648148148148148	73	8	44	2	76	147	704822	704751	Nostoc sp. MS1 DNA, complete genome	blastn	105	78.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. MS1
19135744	19135744	PRJDB4941_P_NODE_20416_length_226_cov_1.468927_g19648_i0	PRJDB4941	20416	226	1.468927	3.31977502	Bacteria	2	Bacteria	Bacteria	114	2.1000000000000002e-30	NR	CBN57873.1	272129	g19648	i0	79.7	43.7389380530973	69	14	91.6	0	218	12	17	85	CBN57873.1 response regulator receiver protein [Kamptonema sp. PCC 6506]	diamond	9885	115	0.991304347826087	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Kamptonema	Kamptonema sp. PCC 6506
20108086	20108086	PRJDB4941_P_NODE_19656_length_231_cov_2.285714_g18888_i0	PRJDB4941	19656	231	2.285714	5.27999934	Roseofilum capinflatum	3082943	Bacteria	Bacteria	92	1.37e-19	NR	WP_283768578.1	3082943	g18888	i0	67.7	0.844155844155844	65	21	84.4	0	29	223	399	463	WP_283768578.1 response regulator [Roseofilum capinflatum]	diamond	195	92	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Desertifilales	Desertifilaceae	Roseofilum	Roseofilum capinflatum
20108209	20108209	PRJDB4941_P_NODE_38736_length_164_cov_0.904348_g37968_i0	PRJDB4941	38736	164	0.904348	1.48313072	Chroococcidiopsis	54298	Bacteria	Bacteria	243	7.57e-60	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g37968	i0	94.839	1.89024390243902	155	8	95	0	1	155	4490152	4489998	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	310	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
26747200	26747200	PRJDB4941_P_NODE_14661_length_279_cov_1.130435_g13893_i0	PRJDB4941	14661	279	1.130435	3.15391365	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	46.6	0.00235	NR	MFM7389485.1	2692181	g13893	i0	48.9	0.505376344086022	47	24	50.5	0	9	149	234	280	MFM7389485.1 tetratricopeptide repeat protein [Vampirovibrionales bacterium]	diamond	141	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales			Vampirovibrionales bacterium
26931649	26931649	PRJDB4941_P_NODE_32762_length_172_cov_2.447154_g31994_i0	PRJDB4941	32762	172	2.447154	4.20910488	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	83.6	5.91e-17	NR	WP_039715486.1	1245922	g31994	i0	64.2	13.8313953488372	53	19	92.4	0	160	2	757	809	WP_039715486.1 hybrid sensor histidine kinase/response regulator [Scytonema millei]	diamond	2379	83.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema millei
27500697	27500697	PRJDB4941_P_NODE_11943_length_319_cov_4.192593_g11175_i0	PRJDB4941	11943	319	4.192593	13.37437167	Bacteria	2	Bacteria	Bacteria	51.6	6.7e-5	NR	WP_250635677.1	224012	g11175	i0	100	6.81818181818182	25	0	23.5	0	77	3	1	25	WP_250635677.1 xanthine dehydrogenase family protein molybdopterin-binding subunit [Nostoc piscinale]	diamond	2175	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc piscinale
28422321	28422321	PRJDB4941_P_NODE_13906_length_288_cov_1.460251_g13138_i0	PRJDB4941	13906	288	1.460251	4.20552288	Gloeobacter violaceus	33072	Bacteria	Bacteria	124	9.59e-31	NR	WP_164928677.1	33072	g13138	i0	57.4	0.979166666666667	94	40	97.9	0	286	5	192	285	WP_164928677.1 M56 family metallopeptidase [Gloeobacter violaceus]	diamond	282	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Gloeobacteraceae	Gloeobacter	Gloeobacter violaceus
28984805	28984805	PRJDB4941_P_NODE_34888_length_168_cov_1.310924_g34120_i0	PRJDB4941	34888	168	1.310924	2.20235232	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	72	6.26e-13	NR	OLE17086.1	1805101	g34120	i0	66.7	3.60714285714286	51	16	89.3	1	152	3	72	122	OLE17086.1 MAG: hypothetical protein AUI36_36895 [Cyanobacteria bacterium 13_1_40CM_2_61_4]	diamond	606	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium 13_1_40CM_2_61_4
29116922	29116922	PRJDB4941_P_NODE_17649_length_247_cov_1.570707_g16881_i0	PRJDB4941	17649	247	1.570707	3.87964629	Stenomitos sp.	3088177	Bacteria	Bacteria	77.4	6.64e-15	NR	HEY9855897.1	3088177	g16881	i0	63.2	3.43724696356275	57	21	69.2	0	1	171	202	258	HEY9855897.1 methyltransferase domain-containing protein [Stenomitos sp.]	diamond	849	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos sp.
29811265	29811265	PRJDB4941_P_NODE_38771_length_164_cov_0.904348_g38003_i0	PRJDB4941	38771	164	0.904348	1.48313072	Leptolyngbya sp. SIO1D8	2607807	Bacteria	Bacteria	62.4	1.48e-9	NR	NER79649.1	2607807	g38003	i0	60.4	0.969512195121951	53	21	97	0	160	2	130	182	NER79649.1 glycoside hydrolase family 104 protein [Leptolyngbya sp. SIO1D8]	diamond	159	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. SIO1D8
29900355	29900355	PRJDB4941_P_NODE_15011_length_274_cov_1.635556_g14243_i0	PRJDB4941	15011	274	1.635556	4.48142344	Cyanophyceae	3028117	Bacteria	Bacteria	65.5	2.82e-11	NR	MBR8834825.1	221294	g14243	i0	52.7	3.73357664233577	55	26	60.2	0	92	256	1	55	MBR8834825.1 hypothetical protein [Stigonema ocellatum SAG 48.90 = DSM 106950]	diamond	1023	65.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Stigonemataceae	Stigonema	Stigonema ocellatum
29937840	29937840	PRJDB4941_P_NODE_36951_length_166_cov_0.888889_g36183_i0	PRJDB4941	36951	166	0.888889	1.47555574	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	90.9	1.18e-19	NR	MBX9720368.1	2364082	g36183	i0	80	0.993975903614458	55	11	99.4	0	1	165	38	92	MBX9720368.1 Na+/H+ antiporter [Candidatus Obscuribacterales bacterium]	diamond	165	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29963436	29963436	PRJDB4941_P_NODE_19411_length_233_cov_1.586957_g18643_i0	PRJDB4941	19411	233	1.586957	3.69760981	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	97.8	1.36e-21	NR	HCF26556.1	2055787	g18643	i0	58.4	26.7682403433476	77	32	99.1	0	231	1	26	102	HCF26556.1 response regulator receiver protein [Cyanobacteria bacterium UBA11049]	diamond	6237	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
30380467	30380467	PRJDB4941_P_NODE_32873_length_172_cov_1.691057_g32105_i0	PRJDB4941	32873	172	1.691057	2.90861804	Gloeobacterales cyanobacterium ES-bin-141	2812628	Bacteria	Bacteria	61.6	2.31e-9	NR	MBC8122776.1	2812628	g32105	i0	66.7	0.732558139534884	42	14	73.3	0	46	171	11	52	MBC8122776.1 trypsin-like peptidase domain-containing protein [Gloeobacterales cyanobacterium ES-bin-141]	diamond	126	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales			Gloeobacterales cyanobacterium ES-bin-141
30474975	30474975	PRJDB4941_P_NODE_5753_length_539_cov_3.502041_g4987_i0	PRJDB4941	5753	539	3.502041	18.87600099	Leptolyngbya sp. SIO4C1	2607770	Bacteria	Bacteria	117	1.64e-27	NR	NEP19284.1	2607770	g4987	i0	43.2	1.55844155844156	146	77	80.7	2	456	22	5	145	NEP19284.1 hypothetical protein [Leptolyngbya sp. SIO4C1]	diamond	840	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. SIO4C1
30822370	30822370	PRJDB4941_P_NODE_14154_length_284_cov_4.736170_g13386_i0	PRJDB4941	14154	284	4.73617	13.4507228	Hydrococcus sp. Prado102	2929567	Bacteria	Bacteria	57.8	1.29e-7	NR	MCU0536000.1	2929567	g13386	i0	37.3	0.876760563380282	83	50	85.6	2	24	266	68	150	MCU0536000.1 hypothetical protein [Hydrococcus sp. Prado102]	diamond	249	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hydrococcaceae	Hydrococcus	Hydrococcus sp. Prado102
31232964	31232964	PRJDB4941_P_NODE_25835_length_198_cov_0.993289_g25067_i0	PRJDB4941	25835	198	0.993289	1.96671222	Leptolyngbyaceae cyanobacterium M33_DOE_097	2747805	Bacteria	Bacteria	113	3.2400000000000006e-27	NR	HIK15113.1	2747805	g25067	i0	78.5	2.95454545454545	65	14	98.5	0	3	197	1631	1695	HIK15113.1 PAS domain S-box protein [Leptolyngbyaceae cyanobacterium M33_DOE_097]	diamond	585	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium M33_DOE_097
31644186	31644186	PRJDB4941_P_NODE_39177_length_164_cov_0.904348_g38409_i0	PRJDB4941	39177	164	0.904348	1.48313072	Cyanobacteria bacterium REEB65	2800109	Bacteria	Bacteria	77	8.72e-15	NR	MBU6430178.1	2800109	g38409	i0	67.9	0.969512195121951	53	17	97	0	5	163	247	299	MBU6430178.1 IS91 family transposase [Cyanobacteria bacterium REEB65]	diamond	159	77	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium REEB65
32813716	32813716	PRJDB4941_P_NODE_10340_length_352_cov_1.425743_g9572_i0	PRJDB4941	10340	352	1.425743	5.01861536	Allocoleopsis sp.	3088169	Bacteria	Bacteria	67	5.66e-11	NR	HEY9664142.1	3088169	g9572	i0	64.2	0.451704545454545	53	19	45.2	0	320	162	125	177	HEY9664142.1 YetF domain-containing protein [Allocoleopsis sp.]	diamond	159	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis sp.
32870826	32870826	PRJDB4941_P_NODE_9720_length_367_cov_1.547170_g8952_i0	PRJDB4941	9720	367	1.54717	5.6781139	Nostocales	1161	Bacteria	Bacteria	147	4.89e-42	NR	WP_234419787.1	70799	g8952	i0	68.9	3.98910081743869	122	38	99.7	0	366	1	72	193	WP_234419787.1 hypothetical protein [Nodularia spumigena]	diamond	1464	148	0.993243243243243	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena

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