metadata: contig_metadata: 22 rows where bioproject = "PRJNA757618", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

22 rows where bioproject = "PRJNA757618", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Cyanobacteriota"

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
4561017	4561017	PRJNA757618_P_NODE_33804_length_249_cov_0.880682_g32752_i0	PRJNA757618	33804	249	0.880682	2.19289818	Pseudanabaena sp. PCC 68	1153	Bacteria	Bacteria	73.6	3.7e-13	NR	WP_019501600.1	118173	g32752	i0	100	0.481927710843373	40	0	48.2	0	130	249	133	172	WP_019501600.1 hypothetical protein [Pseudanabaena sp. PCC 6802]	diamond	120	73.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. PCC 6802
9661270	9661270	PRJNA757618_P_NODE_6388_length_478_cov_1.387654_g5336_i0	PRJNA757618	6388	478	1.387654	6.63298612	Aliterella chasmolithica	2739056	Bacteria	Bacteria	839	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g5336	i0	98.326	114.301255230126	478	8	100	0	1	478	2459	1982	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	54636	839	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
10130945	10130945	PRJNA757618_P_NODE_10348_length_348_cov_1.687273_g9296_i0	PRJNA757618	10348	348	1.687273	5.87171004	Chroococcidiopsis	54298	Bacteria	Bacteria	459	1.66e-124	NTclustered	gi\|225696268\|gb\|FJ805935.1\|	259957	g9296	i0	90.725	126.341954022989	345	30	99	2	1	345	3337	2995	Uncultured Chroococcidiopsis sp. clone NA1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43967	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12212357	12212357	PRJNA757618_P_NODE_5710_length_542_cov_1.782516_g4660_i0	PRJNA757618	5710	542	1.782516	9.66123672	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	843	0	NTclustered	gi\|225696221\|gb\|FJ805888.1\|	259957	g4660	i0	94.679	113.479704797048	545	25	100	4	1	542	2835	2292	Uncultured Chroococcidiopsis sp. clone NA2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	61506	843	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15231058	15231058	PRJNA757618_P_NODE_37392_length_247_cov_0.896552_g36340_i0	PRJNA757618	37392	247	0.896552	2.21448344	Leptolyngbya	47251	Bacteria	Bacteria	276	1.22e-69	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g36340	i0	87.448	5.80566801619433	239	30	97	0	9	247	763386	763624	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	1434	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
16035296	16035296	PRJNA757618_P_NODE_39753_length_246_cov_0.895954_g38701_i0	PRJNA757618	39753	246	0.895954	2.20404684	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g38701	i0	100	2	246	0	100	0	1	246	2077292	2077537	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	492	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
20328835	20328835	PRJNA757618_P_NODE_20096_length_276_cov_1.517241_g19044_i0	PRJNA757618	20096	276	1.517241	4.18758516	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	86.7	4.03e-19	NR	MBS1953124.1	2807733	g19044	i0	97.7	0.467391304347826	43	1	46.7	0	131	3	1	43	MBS1953124.1 VOC family protein [Cyanobacteria bacterium SZAS-4]	diamond	129	86.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
21604665	21604665	PRJNA757618_P_NODE_31317_length_250_cov_0.881356_g30265_i0	PRJNA757618	31317	250	0.881356	2.20339	Prochlorococcus	1218	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|78711884\|gb\|CP000111.1\|	74546	g30265	i0	100	0.224	28	0	11	0	44	71	595274	595301	Prochlorococcus marinus str. MIT 9312, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
24958716	24958716	PRJNA757618_P_NODE_10140_length_351_cov_1.482014_g9088_i0	PRJNA757618	10140	351	1.482014	5.20186914	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	527	4.519999999999999e-145	NTclustered	gi\|225696229\|gb\|FJ805896.1\|	259957	g9088	i0	93.768	152.623931623932	353	19	100	3	1	351	3761	4112	Uncultured Chroococcidiopsis sp. clone NA2_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	53571	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
27369354	27369354	PRJNA757618_P_NODE_39003_length_246_cov_0.901734_g37951_i0	PRJNA757618	39003	246	0.901734	2.21826564	Cyanobacteria bacterium DS2.3.42	2067977	Bacteria	Bacteria	171	6.22e-51	NR	MBA3993748.1	2067977	g37951	i0	100	2	82	0	100	0	246	1	187	268	MBA3993748.1 hypothetical protein [Cyanobacteria bacterium DS2.3.42]	diamond	492	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium DS2.3.42
27685093	27685093	PRJNA757618_P_NODE_40804_length_245_cov_0.906977_g39752_i0	PRJNA757618	40804	245	0.906977	2.22209365	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	116	1.14e-28	NR	MBS1955793.1	2807733	g39752	i0	79.3	1.00408163265306	82	11	99.2	2	1	243	14	90	MBS1955793.1 HlyD family secretion protein [Cyanobacteria bacterium SZAS-4]	diamond	246	116	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
28136767	28136767	PRJNA757618_P_NODE_30145_length_251_cov_0.870787_g29093_i0	PRJNA757618	30145	251	0.870787	2.18567537	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	58.9	4.21e-8	NR	WP_106166204.1	171392	g29093	i0	96.4	2.00796812749004	28	1	33.5	0	249	166	202	229	WP_106166204.1 urease accessory protein UreF [Chroococcidiopsis cubana]	diamond	504	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis cubana
29105781	29105781	PRJNA757618_P_NODE_31548_length_250_cov_0.881356_g30496_i0	PRJNA757618	31548	250	0.881356	2.20339	Aliterella atlantica	1827278	Bacteria	Bacteria	108	3.82e-28	NR	WP_045057036.1	1827278	g30496	i0	88.1	1.416	59	7	70.8	0	72	248	1	59	WP_045057036.1 nuclear transport factor 2 family protein [Aliterella atlantica]	diamond	354	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
29326532	29326532	PRJNA757618_P_NODE_41229_length_245_cov_0.906977_g40177_i0	PRJNA757618	41229	245	0.906977	2.22209365	aff. Roholtiella sp. LEGE 12411	1828822	Bacteria	Bacteria	137	2.71e-36	NR	WP_194002775.1	1828822	g40177	i0	90.7	0.918367346938776	75	7	91.8	0	226	2	5	79	WP_194002775.1 FAD-dependent oxidoreductase [aff. Roholtiella sp. LEGE 12411]	diamond	225	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Fortieaceae	Roholtiella	aff. Roholtiella sp. LEGE 12411
29389917	29389917	PRJNA757618_P_NODE_29749_length_251_cov_0.876404_g28697_i0	PRJNA757618	29749	251	0.876404	2.19977404	Cyanobacteria bacterium DS2.3.42	2067977	Bacteria	Bacteria	166	5.46e-49	NR	MBA3992909.1	2067977	g28697	i0	90.4	2.97609561752988	83	8	99.2	0	251	3	204	286	MBA3992909.1 hypothetical protein [Cyanobacteria bacterium DS2.3.42]	diamond	747	166	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium DS2.3.42
29389922	29389922	PRJNA757618_P_NODE_38349_length_247_cov_0.879310_g37297_i0	PRJNA757618	38349	247	0.87931	2.1718957	Nostoc sp. CHAB 5834	2780403	Bacteria	Bacteria	117	1.5e-28	NR	MCC5609589.1	2780403	g37297	i0	72.8	0.983805668016194	81	20	98.4	1	3	245	330	408	MCC5609589.1 hypothetical protein [Nostoc sp. CHAB 5834]	diamond	243	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5834
29705087	29705087	PRJNA757618_P_NODE_35830_length_248_cov_0.885714_g34778_i0	PRJNA757618	35830	248	0.885714	2.19657072	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	93.2	5.5e-23	NR	WP_146134187.1	2107693	g34778	i0	96.2	0.629032258064516	52	2	62.9	0	248	93	13	64	WP_146134187.1 hypothetical protein, partial [Chlorogloea sp. CCALA 695]	diamond	156	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
29809927	29809927	PRJNA757618_P_NODE_39011_length_246_cov_0.901734_g37959_i0	PRJNA757618	39011	246	0.901734	2.21826564	Nostocales	1161	Bacteria	Bacteria	136	3.5599999999999997e-37	NR	OKH54253.1	1137096	g37959	i0	82.9	7.97560975609756	82	14	100	0	246	1	194	275	OKH54253.1 AraC family transcriptional regulator [Calothrix sp. HK-06]	diamond	1962	137	0.992700729927007	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. HK-06
30916030	30916030	PRJNA757618_P_NODE_45914_length_243_cov_0.911765_g44862_i0	PRJNA757618	45914	243	0.911765	2.21558895	Leptolyngbyaceae	1890438	Bacteria	Bacteria	71.6	1.65e-14	NR	WP_058997422.1	1552121	g44862	i0	43.5	2.24691358024691	62	35	76.5	0	223	38	1	62	WP_058997422.1 hypothetical protein [Leptolyngbya sp. NIES-2104]	diamond	546	71.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-2104
31032685	31032685	PRJNA757618_P_NODE_47975_length_242_cov_0.917160_g46923_i0	PRJNA757618	47975	242	0.91716	2.2195272	Synechococcus sp.	1131	Bacteria	Bacteria	56.6	4.8e-7	NR	MEB3208662.1	1131	g46923	i0	37.8	0.91735537190082606	74	46	91.7	0	224	3	602	675	MEB3208662.1 hypothetical protein [Synechococcus sp.]	diamond	222	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp.
32044449	32044449	PRJNA757618_P_NODE_38238_length_247_cov_0.885057_g37186_i0	PRJNA757618	38238	247	0.885057	2.18609079	Leptolyngbya sp. SIO1D8	2607807	Bacteria	Bacteria	69.7	1.27e-11	NR	NER78025.1	2607807	g37186	i0	36.3	1.37246963562753	113	40	98.4	1	243	1	552	664	NER78025.1 DUF4157 domain-containing protein [Leptolyngbya sp. SIO1D8]	diamond	339	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. SIO1D8
32361105	32361105	PRJNA757618_P_NODE_43479_length_244_cov_0.912281_g42427_i0	PRJNA757618	43479	244	0.912281	2.22596564	Pleurocapsa sp. CCALA 161	2107688	Bacteria	Bacteria	179	1e-53	NR	WP_106233271.1	2107688	g42427	i0	100	0.995901639344262	81	0	99.6	0	243	1	110	190	WP_106233271.1 glycosyltransferase family 2 protein [Pleurocapsa sp. CCALA 161]	diamond	243	179	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. CCALA 161

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