metadata: contig_metadata: 28 rows where bioproject = "PRJNA1102048" and tax_clade = "Cyanobacteriota/Melainabacteria group"

28 rows where bioproject = "PRJNA1102048" 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
10415106	10415106	PRJNA1102048_P_NODE_16729_length_243_cov_0.905882_g16625_i0	PRJNA1102048	16729	243	0.905882	2.20129326	Nostoc punctiforme	272131	Bacteria	Bacteria	81.3	1.03e-15	NR	WP_012409512.1	272131	g16625	i0	51.9	4.48148148148148	77	37	95.1	0	12	242	4017	4093	WP_012409512.1 non-ribosomal peptide synthetase [Nostoc punctiforme]	diamond	1089	81.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
21888605	21888605	PRJNA1102048_P_NODE_5418_length_369_cov_4.206081_g5314_i0	PRJNA1102048	5418	369	4.206081	15.52043889	Nostoc sp. C052	2576902	Bacteria	Bacteria	65.8	4.5e-6	NTclustered	gi\|1866639087\|gb\|CP040272.1\|	2576902	g5314	i0	93.182	98.8970189701897	44	3	12	0	1	44	566460	566417	Nostoc sp. C052 chromosome, complete genome	blastn	36493	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C052
24437682	24437682	PRJNA1102048_P_NODE_780_length_813_cov_2.022973_g691_i0	PRJNA1102048	780	813	2.022973	16.44677049	root	1	Root_unresolved	Root_unresolved	260	1.1099999999999998e-82	NR	MFN7393806.1	1153	g691	i0	67.4	26.6014760147601	193	63	71.2	0	580	2	2	194	MFN7393806.1 NADP-dependent isocitrate dehydrogenase [Pseudanabaena sp.]	diamond	21627	261	0.996168582375479	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
27225534	27225534	PRJNA1102048_P_NODE_7863_length_310_cov_1.299578_g7759_i0	PRJNA1102048	7863	310	1.299578	4.0286918	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	60.8	3.63e-8	NR	HEY9879774.1	3088178	g7759	i0	34	3.76451612903226	94	58	91	2	308	27	738	827	HEY9879774.1 VCBS domain-containing protein [Leptolyngbyaceae cyanobacterium]	diamond	1167	60.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
27343706	27343706	PRJNA1102048_P_NODE_16803_length_243_cov_0.905882_g16699_i0	PRJNA1102048	16803	243	0.905882	2.20129326	Cyanophyceae	3028117	Bacteria	Bacteria	99	2.87e-23	NR	WP_073608865.1	126344	g16699	i0	56.3	6.88888888888889	80	35	98.8	0	241	2	9	88	WP_073608865.1 translation elongation factor Ts [Phormidium tenue]	diamond	1674	100	0.99	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium tenue
27343707	27343707	PRJNA1102048_P_NODE_263_length_1182_cov_4.057710_g213_i0	PRJNA1102048	263	1182	4.05771	47.9621322	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	266	3.65e-81	NR	WP_149976945.1	1126	g213	i0	46.1	3.41370558375635	336	163	82.2	6	94	1065	1	330	WP_149976945.1 hypothetical protein [Microcystis aeruginosa]	diamond	4035	266	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
27447146	27447146	PRJNA1102048_P_NODE_16463_length_243_cov_1.358824_g16359_i0	PRJNA1102048	16463	243	1.358824	3.30194232	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	103	2.21e-26	NR	MBX9722668.1	2364082	g16359	i0	77.8	0.777777777777778	63	14	77.8	0	243	55	75	137	MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	189	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27469914	27469914	PRJNA1102048_P_NODE_5503_length_367_cov_1.323129_g5399_i0	PRJNA1102048	5503	367	1.323129	4.8558834299999996	Cyanophyceae	3028117	Bacteria	Bacteria	175	8.73e-51	NR	MFM8606235.1	2164130	g5399	i0	67.2	21.9400544959128	122	38	99.7	1	2	367	244	363	MFM8606235.1 pyridoxal-phosphate-dependent aminotransferase family protein [Cyanobium sp.]	diamond	8052	176	0.994318181818182	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp.
27659422	27659422	PRJNA1102048_P_NODE_584_length_906_cov_29.014406_g505_i0	PRJNA1102048	584	906	29.014406	262.87051836	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	124	5.070000000000001e-29	NR	WP_015138290.1	28072	g505	i0	37.3	2.15894039735099	217	123	71.2	6	826	182	90	295	WP_015138290.1 hypothetical protein [Nostoc sp. PCC 7524]	diamond	1956	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
27659423	27659423	PRJNA1102048_P_NODE_7364_length_319_cov_2.105691_g7260_i0	PRJNA1102048	7364	319	2.105691	6.71715429	Leptolyngbya	47251	Bacteria	Bacteria	109	1.29e-26	NR	EKQ69093.1	864702	g7260	i0	67.1	7.5987460815047	76	25	71.5	0	264	37	5	80	EKQ69093.1 phytoene/squalene synthetase [Leptolyngbyaceae cyanobacterium JSC-12]	diamond	2424	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium JSC-12
27983606	27983606	PRJNA1102048_P_NODE_3105_length_479_cov_1.273399_g3001_i0	PRJNA1102048	3105	479	1.273399	6.09958121	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	243	7.62e-79	NR	MBX9694001.1	2847862	g3001	i0	86.8	0.807933194154488	129	17	80.8	0	91	477	1	129	MBX9694001.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	387	243	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28172986	28172986	PRJNA1102048_P_NODE_12386_length_253_cov_1.650000_g12282_i0	PRJNA1102048	12386	253	1.65	4.1745	filamentous cyanobacterium CCP5	2107701	Bacteria	Bacteria	112	6.800000000000001e-27	NR	PSN15850.1	2107701	g12282	i0	64.3	1.99209486166008	84	30	99.6	0	2	253	416	499	PSN15850.1 alpha-D-glucose phosphate-specific phosphoglucomutase, partial [filamentous cyanobacterium CCP5]	diamond	504	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					filamentous cyanobacterium CCP5
28362429	28362429	PRJNA1102048_P_NODE_4006_length_426_cov_1.198300_g3902_i0	PRJNA1102048	4006	426	1.1983	5.104758	Trichodesmium erythraeum	1206	Bacteria	Bacteria	47.8	0.00464	NR	WP_011613745.1	1206	g3902	i0	35.6	0.415492957746479	59	37	40.8	1	191	18	347	405	WP_011613745.1 beta-galactosidase [Trichodesmium erythraeum]	diamond	177	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Trichodesmium	Trichodesmium erythraeum
28425808	28425808	PRJNA1102048_P_NODE_246_length_1214_cov_15.450482_g196_i0	PRJNA1102048	246	1214	15.450482	187.56885148	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	468	6.269999999999998e-162	NR	MBX9694561.1	2847862	g196	i0	74.4	2.38714991762768	308	74	74.9	2	1166	258	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2898	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28615212	28615212	PRJNA1102048_P_NODE_17147_length_242_cov_0.911243_g17043_i0	PRJNA1102048	17147	242	0.911243	2.20520806	Gloeocapsa sp. DLM2.Bin57	2480214	Bacteria	Bacteria	132	4.08e-36	NR	TVQ44609.1	2480214	g17043	i0	71.3	0.991735537190083	80	23	99.2	0	240	1	88	167	TVQ44609.1 MAG: phytoene/squalene synthase family protein [Gloeocapsa sp. DLM2.Bin57]	diamond	240	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. DLM2.Bin57
29017254	29017254	PRJNA1102048_P_NODE_14948_length_246_cov_1.780347_g14844_i0	PRJNA1102048	14948	246	1.780347	4.37965362	Synechococcus	1129	Bacteria	Bacteria	113	3.47e-27	NR	WP_244892590.1	431041	g14844	i0	69.6	5.41463414634146	79	23	96.3	1	3	239	253	330	WP_244892590.1 leucyl aminopeptidase [Candidatus Synechococcus spongiarum]	diamond	1332	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Candidatus Synechococcus spongiarum
29656671	29656671	PRJNA1102048_P_NODE_14950_length_246_cov_1.774566_g14846_i0	PRJNA1102048	14950	246	1.774566	4.36543236	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	42.7	0.00874	NR	MBX9693409.1	2847862	g14846	i0	34.3	0.817073170731707	67	40	81.7	1	46	246	1	63	MBX9693409.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	201	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29751528	29751528	PRJNA1102048_P_NODE_15311_length_246_cov_0.890173_g15207_i0	PRJNA1102048	15311	246	0.890173	2.18982558	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	94.7	5.27e-21	NR	MBX9693132.1	2847862	g15207	i0	69	1.02439024390244	84	18	97.6	6	5	244	22	101	MBX9693132.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	252	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29941470	29941470	PRJNA1102048_P_NODE_5451_length_369_cov_1.040541_g5347_i0	PRJNA1102048	5451	369	1.040541	3.83959629	Planktothrix tepida	1678309	Bacteria	Bacteria	107	1.5999999999999999e-24	NR	WP_072720187.1	1678309	g5347	i0	50	1.65853658536585	102	50	82.9	1	368	63	318	418	WP_072720187.1 aspartate aminotransferase family protein [Planktothrix tepida]	diamond	612	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix tepida
30289215	30289215	PRJNA1102048_P_NODE_15852_length_245_cov_0.895349_g15748_i0	PRJNA1102048	15852	245	0.895349	2.19360505	Microcystis aeruginosa	1126	Bacteria	Bacteria	61.2	2.54e-9	NR	NCR49255.1	2685985	g15748	i0	64.3	1.0530612244898	42	15	51.4	0	237	112	1	42	NCR49255.1 WD40 repeat domain-containing protein [Microcystis aeruginosa S11-01]	diamond	258	61.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
31047412	31047412	PRJNA1102048_P_NODE_14715_length_247_cov_0.885057_g14611_i0	PRJNA1102048	14715	247	0.885057	2.18609079	Candidatus Synechococcus calcipolaris	1522304	Bacteria	Bacteria	53.5	6.29e-6	NR	WP_277866898.1	1522304	g14611	i0	48.3	0.704453441295547	58	21	70.4	2	220	47	451	499	WP_277866898.1 cation-translocating P-type ATPase [Candidatus Synechococcus calcipolaris]	diamond	174	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Candidatus Synechococcus calcipolaris
31110135	31110135	PRJNA1102048_P_NODE_5015_length_383_cov_0.974194_g4911_i0	PRJNA1102048	5015	383	0.974194	3.73116302	Synechococcus sp. BO 88	1131	Bacteria	Bacteria	67	5.45e-10	NR	WP_094585142.1	169670	g4911	i0	32.5	2.95300261096606	123	55	96.3	3	13	381	182	276	WP_094585142.1 Dyp-type peroxidase [Synechococcus sp. BO 8801]	diamond	1131	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. BO 8801
31141534	31141534	PRJNA1102048_P_NODE_11975_length_257_cov_1.603261_g11871_i0	PRJNA1102048	11975	257	1.603261	4.12038077	Rivularia sp. T60_A2020_040	2774335	Bacteria	Bacteria	43.1	0.0305	NR	MBF2015250.1	2774335	g11871	i0	37.3	0.782101167315175	67	40	78.2	2	21	221	226	290	MBF2015250.1 hypothetical protein [Rivularia sp. T60_A2020_040]	diamond	201	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. T60_A2020_040
31386338	31386338	PRJNA1102048_P_NODE_8076_length_306_cov_1.309013_g7972_i0	PRJNA1102048	8076	306	1.309013	4.00557978	Cyanophyceae	3028117	Bacteria	Bacteria	59.3	1.26e-7	NR	WP_194144459.1	1828640	g7972	i0	65.9	1.64705882352941	41	14	40.2	0	1	123	1108	1148	WP_194144459.1 NACHT and WD repeat domain-containing protein [Nostoc sp. LEGE 12447]	diamond	504	59.7	0.993299832495812	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. LEGE 12447
31521523	31521523	PRJNA1102048_P_NODE_11316_length_264_cov_1.497382_g11212_i0	PRJNA1102048	11316	264	1.497382	3.95308848	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	61.6	1.02e-8	NR	MBX9692038.1	2847862	g11212	i0	45.6	0.897727272727273	79	36	81.8	2	4	219	51	129	MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	237	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32691249	32691249	PRJNA1102048_P_NODE_15760_length_245_cov_0.895349_g15656_i0	PRJNA1102048	15760	245	0.895349	2.19360505	Fischerella sp. CENA71	2653668	Bacteria	Bacteria	55.1	1.76e-6	NR	MCP6758337.1	2653668	g15656	i0	45.5	2.93877551020408	55	30	67.3	0	237	73	1635	1689	MCP6758337.1 AAA family ATPase [Fischerella sp. CENA71]	diamond	720	55.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. CENA71
32745780	32745780	PRJNA1102048_P_NODE_15560_length_245_cov_0.895349_g15456_i0	PRJNA1102048	15560	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	45.8	0.00265	NR	WP_146006125.1	372787	g15456	i0	34.2	9.82040816326531	79	50	96.7	1	242	6	59	135	WP_146006125.1 response regulator, partial [Fischerella thermalis]	diamond	2406	46.2	0.991341991341991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella thermalis
32848766	32848766	PRJNA1102048_P_NODE_13740_length_249_cov_0.875000_g13636_i0	PRJNA1102048	13740	249	0.875	2.17875	Nostoc sp. CmiSLP01	3075383	Bacteria	Bacteria	109	3.4000000000000004e-27	NR	MDZ8164484.1	3075383	g13636	i0	57.3	3.93975903614458	82	35	98.8	0	248	3	6	87	MDZ8164484.1 Rad52/Rad22 family DNA repair protein [Nostoc sp. CmiSLP01]	diamond	981	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CmiSLP01

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