metadata: contig_metadata: 30 rows where bioproject = "PRJNA376117" and tax_clade = "Cyanobacteriota/Melainabacteria group"

30 rows where bioproject = "PRJNA376117" 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
1674798	1674798	PRJNA376117_P_NODE_44682_length_241_cov_0.916667_g44380_i0	PRJNA376117	44682	241	0.916667	2.20916747	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	401	1.8699999999999993e-107	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g44380	i0	96.68	1	241	8	100	0	1	241	5550406	5550166	Anabaena sp. YBS01 chromosome, complete genome	blastn	241	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
2950425	2950425	PRJNA376117_P_NODE_23903_length_286_cov_1.446009_g23601_i0	PRJNA376117	23903	286	1.446009	4.13558574	Leptolyngbya sp. BL-A-14	3104317	Bacteria	Bacteria	364	2.9899999999999993e-96	NTclustered	gi\|2804745243\|gb\|CP166621.1\|	3104317	g23601	i0	89.583	171.020979020979	288	28	100	1	1	286	3749508	3749795	MAG: Leptolyngbya sp. BL-A-14 chromosome, complete genome	blastn	48912	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL-A-14
5503534	5503534	PRJNA376117_P_NODE_34585_length_250_cov_1.740113_g34283_i0	PRJNA376117	34585	250	1.740113	4.3502825	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	315	2.62e-81	NTclustered	gi\|225696214\|gb\|FJ805881.1\|	259957	g34283	i0	89.683	160.496	252	19	99	4	1	248	1823	2071	Uncultured Chroococcidiopsis sp. clone A3_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40124	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7451684	7451684	PRJNA376117_P_NODE_33506_length_251_cov_2.449438_g33204_i0	PRJNA376117	33506	251	2.449438	6.14808938	Oscillatoriales	1150	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2095813707\|gb\|OK161270.1\|	2876722	g33204	i0	99.203	155.932270916335	251	2	100	0	1	251	3057	2807	Oscillatoria sp. 2.1A 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39139	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. 2.1A
7451734	7451734	PRJNA376117_P_NODE_40506_length_245_cov_0.895349_g40204_i0	PRJNA376117	40506	245	0.895349	2.19360505	Limnospira	2596745	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g40204	i0	100	8.04897959183674	245	0	100	0	1	245	4257663	4257419	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	1972	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
8053303	8053303	PRJNA376117_P_NODE_40887_length_244_cov_1.350877_g40585_i0	PRJNA376117	40887	244	1.350877	3.29613988	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	298	2.56e-76	NTclustered	gi\|225696253\|gb\|FJ805920.1\|	259957	g40585	i0	89.54	110.905737704918	239	19	97	6	1	236	3288	3053	Uncultured Chroococcidiopsis sp. clone A1_6 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27061	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10603464	10603464	PRJNA376117_P_NODE_18009_length_325_cov_4.396825_g17707_i0	PRJNA376117	18009	325	4.396825	14.28968125	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	435	2.6e-117	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g17707	i0	90.826	193.332307692308	327	26	100	4	1	325	1626	1950	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	62833	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16977004	16977004	PRJNA376117_P_NODE_1074_length_1716_cov_3.096166_g926_i0	PRJNA376117	1074	1716	3.096166	53.13020856	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	1472	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g926	i0	94.404	206.779137529138	965	42	99	10	2	961	3669129	3670086	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	354833	1472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
20801572	20801572	PRJNA376117_P_NODE_42617_length_243_cov_0.905882_g42315_i0	PRJNA376117	42617	243	0.905882	2.20129326	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	350	6.94e-92	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g42315	i0	92.593	95.962962962963	243	18	100	0	1	243	5562447	5562205	Anabaena sp. YBS01 chromosome, complete genome	blastn	23319	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
27485710	27485710	PRJNA376117_P_NODE_40223_length_245_cov_0.895349_g39921_i0	PRJNA376117	40223	245	0.895349	2.19360505	Pseudanabaena sp. ELA607	3064511	Bacteria	Bacteria	71.6	1.71e-14	NR	MEI6429300.1	3064511	g39921	i0	78	0.502040816326531	41	9	50.2	0	163	41	9	49	MEI6429300.1 hypothetical protein [Pseudanabaena sp. ELA607]	diamond	123	71.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. ELA607
27517266	27517266	PRJNA376117_P_NODE_21883_length_295_cov_2.806306_g21581_i0	PRJNA376117	21883	295	2.806306	8.2786027	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	68.6	1.17e-11	NR	WP_041780282.1	2886352	g21581	i0	44.8	3.36610169491525	87	46	88.5	2	291	31	16	100	WP_041780282.1 vWA domain-containing protein [Allocoleopsis franciscana]	diamond	993	68.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
27927735	27927735	PRJNA376117_P_NODE_30625_length_262_cov_2.211640_g30323_i0	PRJNA376117	30625	262	2.21164	5.7944968	Alkalinema sp. CACIAM 7	3100328	Bacteria	Bacteria	183	1.2199999999999999e-54	NR	OUC11604.1	1934309	g30323	i0	100	0.99618320610687	87	0	99.6	0	262	2	254	340	OUC11604.1 MAG: hypothetical protein B0A82_26875 [Alkalinema sp. CACIAM 70d]	diamond	261	183	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Alkalinema	Alkalinema sp. CACIAM 70d
28022596	28022596	PRJNA376117_P_NODE_39705_length_245_cov_3.819767_g39403_i0	PRJNA376117	39705	245	3.819767	9.35842915	Cyanobacteria bacterium J06639_1	3023214	Bacteria	Bacteria	42	0.0495	NR	MEO1133969.1	3023214	g39403	i0	35.1	0.697959183673469	57	30	69.8	1	66	236	90	139	MEO1133969.1 YwiC-like family protein [Cyanobacteria bacterium J06639_1]	diamond	171	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06639_1
28053904	28053904	PRJNA376117_P_NODE_21265_length_299_cov_4.464602_g20963_i0	PRJNA376117	21265	299	4.464602	13.34915998	Okeania sp. SIO2D1	2607792	Bacteria	Bacteria	72.4	7.86e-14	NR	NES65768.1	2607792	g20963	i0	37.1	0.973244147157191	97	59	95.3	1	292	8	8	104	NES65768.1 hypothetical protein [Okeania sp. SIO2D1]	diamond	291	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO2D1
28180094	28180094	PRJNA376117_P_NODE_32246_length_256_cov_2.016393_g31944_i0	PRJNA376117	32246	256	2.016393	5.16196608	Nostoc linckia	92942	Bacteria	Bacteria	47	0.00126	NR	WP_368731841.1	92942	g31944	i0	77.4	1.67578125	31	7	36.3	0	163	255	27	57	WP_368731841.1 MHYT domain-containing protein, partial [Nostoc linckia]	diamond	429	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc linckia
28481591	28481591	PRJNA376117_P_NODE_27306_length_275_cov_1.128713_g27004_i0	PRJNA376117	27306	275	1.128713	3.10396075	Scytonema	1203	Bacteria	Bacteria	65.9	4.07e-10	NR	MEC4817083.1	2684455	g27004	i0	36.3	3.97090909090909	91	55	99.3	1	2	274	823	910	MEC4817083.1 CHAT domain-containing protein [Scytonema sp. PMC 1069.18]	diamond	1092	65.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PMC 1069.18
28496186	28496186	PRJNA376117_P_NODE_27467_length_274_cov_1.512438_g27165_i0	PRJNA376117	27467	274	1.512438	4.14408012	Okeania sp. SIO2D1	2607792	Bacteria	Bacteria	67.8	3.64e-12	NR	NES65768.1	2607792	g27165	i0	37.1	0.974452554744526	89	54	95.3	1	266	6	8	96	NES65768.1 hypothetical protein [Okeania sp. SIO2D1]	diamond	267	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO2D1
28891851	28891851	PRJNA376117_P_NODE_17668_length_328_cov_5.501961_g17366_i0	PRJNA376117	17668	328	5.501961	18.04643208	root	1	Root_unresolved	Root_unresolved	75.1	1.26e-14	NR	WP_375470271.1	340711	g17366	i0	35.2	1.8109756097561	108	67	96	3	316	2	17	124	WP_375470271.1 CVNH domain-containing protein [uncultured Nostoc sp.]	diamond	594	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	uncultured Nostoc sp.
29190793	29190793	PRJNA376117_P_NODE_14269_length_362_cov_2.840830_g13967_i0	PRJNA376117	14269	362	2.84083	10.2838046	Nostoc sp.	1180	Bacteria	Bacteria	92	5.97e-21	NR	WP_334858291.1	1180	g13967	i0	75.5	1.38397790055249	53	13	43.9	0	159	1	2	54	WP_334858291.1 coactosin family protein [Nostoc sp.]	diamond	501	92	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
29270755	29270755	PRJNA376117_P_NODE_32989_length_253_cov_2.488889_g32687_i0	PRJNA376117	32989	253	2.488889	6.29688917	Nostocales	1161	Bacteria	Bacteria	59.3	6.25e-8	NR	MBW4628362.1	1049025	g32687	i0	76.3	3.68774703557312	38	9	45.1	0	13	126	541	578	MBW4628362.1 AAA-like domain-containing protein [Brasilonema octagenarum HA4186-MV1]	diamond	933	59.7	0.993299832495812	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema octagenarum
29569476	29569476	PRJNA376117_P_NODE_25990_length_279_cov_1.495146_g25688_i0	PRJNA376117	25990	279	1.495146	4.17145734	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	82	1.56e-16	NR	MBX9696048.1	2847862	g25688	i0	54.2	0.774193548387097	72	33	77.4	0	55	270	2	73	MBX9696048.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	216	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30232846	30232846	PRJNA376117_P_NODE_30772_length_262_cov_1.359788_g30470_i0	PRJNA376117	30772	262	1.359788	3.56264456	Atlanticothrix silvestris	2840444	Bacteria	Bacteria	102	6.61e-23	NR	WP_214442558.1	2840444	g30470	i0	53.5	0.984732824427481	86	39	98.5	1	4	261	360	444	WP_214442558.1 acylase [Atlanticothrix silvestris]	diamond	258	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Atlanticothrix	Atlanticothrix silvestris
31497148	31497148	PRJNA376117_P_NODE_22656_length_290_cov_2.654378_g22354_i0	PRJNA376117	22656	290	2.654378	7.6976962	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	64.7	5.58e-11	NR	HEY9799329.1	3088178	g22354	i0	33.7	1.90344827586207	89	55	91	2	24	287	23	108	HEY9799329.1 hypothetical protein [Leptolyngbyaceae cyanobacterium]	diamond	552	64.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
31528732	31528732	PRJNA376117_P_NODE_25456_length_281_cov_1.370192_g25154_i0	PRJNA376117	25456	281	1.370192	3.85023952	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	205	1.96e-61	NR	PZM81480.1	2052166	g25154	i0	98.9	0.99288256227758	93	1	99.3	0	279	1	82	174	PZM81480.1 MAG: hypothetical protein DKT66_19935 [Candidatus Melainabacteria bacterium]	diamond	279	205	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31686662	31686662	PRJNA376117_P_NODE_19217_length_315_cov_1.909091_g18915_i0	PRJNA376117	19217	315	1.909091	6.01363665	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	64.3	2.16e-9	NR	MDX2272534.1	2847862	g18915	i0	31.7	1.97142857142857	104	70	99	1	3	314	325	427	MDX2272534.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	621	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31798549	31798549	PRJNA376117_P_NODE_2217_length_1006_cov_2.758842_g1970_i0	PRJNA376117	2217	1006	2.758842	27.75395052	Bacillati	1783272	Bacteria	Bacteria	79	5.01e-12	NR	WP_193950673.1	1828643	g1970	i0	31.1	1.80417495029821	148	95	44.1	2	21	464	464	604	WP_193950673.1 thioester reductase domain-containing protein, partial [Nostoc sp. LEGE 12450]	diamond	1815	79.7	0.991217063989962	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. LEGE 12450
32097969	32097969	PRJNA376117_P_NODE_24938_length_283_cov_1.100000_g24636_i0	PRJNA376117	24938	283	1.1	3.113	Nostoc sp.	1180	Bacteria	Bacteria	147	2.1399999999999993e-43	NR	WP_334858291.1	1180	g24636	i0	74.2	1.97173144876325	93	24	98.6	0	281	3	43	135	WP_334858291.1 coactosin family protein [Nostoc sp.]	diamond	558	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
32431672	32431672	PRJNA376117_P_NODE_45259_length_227_cov_3.701299_g44957_i0	PRJNA376117	45259	227	3.701299	8.40194873	Pseudanabaena	1152	Bacteria	Bacteria	60.1	2.27e-8	NR	WP_019499601.1	118173	g44957	i0	42.1	3.01321585903084	76	40	97.8	2	5	226	312	385	WP_019499601.1 fatty acid desaturase [Pseudanabaena sp. PCC 6802]	diamond	684	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. PCC 6802
32635343	32635343	PRJNA376117_P_NODE_25960_length_279_cov_1.684466_g25658_i0	PRJNA376117	25960	279	1.684466	4.69966014	Prochlorothrix sp.	54309	Bacteria	Bacteria	75.5	1.79e-13	NR	MEB3162773.1	54309	g25658	i0	42.1	3.02150537634409	95	48	94.6	2	264	1	528	622	MEB3162773.1 adenylate/guanylate cyclase domain-containing protein [Prochlorothrix sp.]	diamond	843	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Prochlorotrichales	Prochlorotrichaceae	Prochlorothrix	Prochlorothrix sp.
32872959	32872959	PRJNA376117_P_NODE_39400_length_246_cov_0.890173_g39098_i0	PRJNA376117	39400	246	0.890173	2.18982558	Moorena	1155738	Bacteria	Bacteria	73.9	2.56e-13	NR	WP_293047493.1	2607819	g39098	i0	43.8	5.65853658536585	80	44	97.6	1	242	3	182	260	WP_293047493.1 NAD/NADP octopine/nopaline dehydrogenase family protein [Moorena sp. SIO1F2]	diamond	1392	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena sp. SIO1F2

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