metadata: contig_metadata: 19 rows where bioproject = "PRJNA1199330" and tax_clade = "Cyanobacteriota/Melainabacteria group"

19 rows where bioproject = "PRJNA1199330" 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
3594307	3594307	PRJNA1199330_P_NODE_104383_length_250_cov_1.762712_g103684_i0	PRJNA1199330	104383	250	1.762712	4.40678	Pycnacronema	2530217	Bacteria	Bacteria	460	3.17e-125	NTclustered	gi\|1053098779\|gb\|KT715147.1\|	1211	g103684	i0	100	99.292	249	0	99	0	2	250	505	257	Uncultured cyanobacterium clone A59 16S ribosomal RNA gene, partial sequence	blastn	24823	460	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
11804463	11804463	PRJNA1199330_P_NODE_63690_length_287_cov_2.247664_g62991_i0	PRJNA1199330	63690	287	2.247664	6.45079568	Nostoc sp. UHCC 0926	3025190	Bacteria	Bacteria	62.1	4.41e-5	NTclustered	gi\|2444439127\|gb\|CP117768.1\|	3025190	g62991	i0	97.222	0.125435540069686	36	1	13	0	25	60	1424600	1424635	Nostoc sp. UHCC 0926 chromosome, complete genome	blastn	36	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0926
16902433	16902433	PRJNA1199330_P_NODE_21794_length_439_cov_1.691257_g21100_i0	PRJNA1199330	21794	439	1.691257	7.42461823	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	665	0	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g21100	i0	94.091	139.854214123007	440	23	100	3	1	439	2333	2770	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	61396	665	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16903042	16903042	PRJNA1199330_P_NODE_65514_length_286_cov_1.136150_g64815_i0	PRJNA1199330	65514	286	1.13615	3.249389	Synechococcus sp. LS0587_1	493890	Bacteria	Bacteria	204	6.899999999999999e-48	NTclustered	gi\|166406552\|gb\|EU362677.1\|	493890	g64815	i0	80.586	2.24825174825175	273	45	94	7	18	286	46	314	Synechococcus sp. LS0587_1 phosphonate transporter subunit (phnD) gene, partial cds	blastn	643	204	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. LS0587_1
20727129	20727129	PRJNA1199330_P_NODE_49357_length_305_cov_1.672414_g48658_i0	PRJNA1199330	49357	305	1.672414	5.1008627	Spirirestis rafaelensis	293980	Bacteria	Bacteria	283	9.26e-72	NTclustered	gi\|648713590\|gb\|KF934131.1\|	1494766	g48658	i0	96.023	67.5868852459016	176	4	69	3	18	192	319	146	Hassallia sp. UB1-KK1 clone 1 leader 16S ribosomal RNA gene, partial sequence; 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	20614	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
27388816	27388816	PRJNA1199330_P_NODE_77743_length_275_cov_1.193069_g77044_i0	PRJNA1199330	77743	275	1.193069	3.28093975	Arthrospira sp. PLM2.Bin9	2599626	Bacteria	Bacteria	50.1	1.35e-4	NR	WP_317269148.1	2599626	g77044	i0	37.8	1.78909090909091	82	42	89.5	1	246	1	209	281	WP_317269148.1 SGNH/GDSL hydrolase family protein [Arthrospira sp. PLM2.Bin9]	diamond	492	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Arthrospira	Arthrospira sp. PLM2.Bin9
27736296	27736296	PRJNA1199330_P_NODE_91324_length_262_cov_1.428571_g90625_i0	PRJNA1199330	91324	262	1.428571	3.74285602	Acaryochloridaceae cyanobacterium CSU_3_4	2720417	Bacteria	Bacteria	81.6	9.92e-16	NR	NJN38870.1	2720417	g90625	i0	66.1	2.72519083969466	56	19	64.1	0	2	169	1160	1215	NJN38870.1 hypothetical protein [Acaryochloridaceae cyanobacterium CSU_3_4]	diamond	714	81.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae		Acaryochloridaceae cyanobacterium CSU_3_4
27818177	27818177	PRJNA1199330_P_NODE_118024_length_238_cov_2.757576_g117325_i0	PRJNA1199330	118024	238	2.757576	6.56303088	Cyanophyceae	3028117	Bacteria	Bacteria	78.6	6.48e-17	NR	WP_322687258.1	3075406	g117325	i0	64.1	1.63865546218487	64	22	80.7	1	234	43	29	91	WP_322687258.1 hypothetical protein [Nostoc sp. EfeVER01]	diamond	390	79	0.994936708860759	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. EfeVER01
29207389	29207389	PRJNA1199330_P_NODE_33709_length_356_cov_3.381625_g33010_i0	PRJNA1199330	33709	356	3.381625	12.038585	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	89.7	4.56e-18	NR	WP_141293733.1	1160	g33010	i0	47.6	5.29213483146067	103	50	86.8	2	34	342	429	527	WP_141293733.1 ABC transporter ATP-binding protein/permease [Planktothrix agardhii]	diamond	1884	89.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
29459519	29459519	PRJNA1199330_P_NODE_77050_length_275_cov_2.321782_g76351_i0	PRJNA1199330	77050	275	2.321782	6.3849005	Thermostichus	2881385	Bacteria	Bacteria	45.1	0.00723	NR	WP_244350296.1	32053	g76351	i0	47.4	1.86545454545455	57	26	57.8	2	202	44	61	117	WP_244350296.1 response regulator transcription factor [Thermostichus vulcanus]	diamond	513	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Thermostichales	Thermostichaceae	Thermostichus	Thermostichus vulcanus
29629996	29629996	PRJNA1199330_P_NODE_100590_length_253_cov_0.866667_g99891_i0	PRJNA1199330	100590	253	0.866667	2.19266751	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	164	5.98e-45	NR	HEY9782992.1	3088178	g99891	i0	100	0.99604743083004	84	0	99.6	0	253	2	62	145	HEY9782992.1 phycobilisome rod-core linker polypeptide [Leptolyngbyaceae cyanobacterium]	diamond	252	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
29965132	29965132	PRJNA1199330_P_NODE_103771_length_251_cov_0.865169_g103072_i0	PRJNA1199330	103771	251	0.865169	2.17157419	root	1	Root_unresolved	Root_unresolved	47.8	6.89e-4	NR	WP_335091579.1	1180	g103072	i0	55.6	3.33466135458167	36	16	43	0	26	133	221	256	WP_335091579.1 WD40 repeat domain-containing serine/threonine-protein kinase, partial [Nostoc sp.]	diamond	837	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
30388941	30388941	PRJNA1199330_P_NODE_84093_length_269_cov_1.244898_g83394_i0	PRJNA1199330	84093	269	1.244898	3.34877562	Cyanobium sp. ELA712	3064510	Bacteria	Bacteria	84.3	1.18e-16	NR	MEI6111384.1	3064510	g83394	i0	56.5	0.769516728624535	69	29	75.8	1	208	5	6	74	MEI6111384.1 acyltransferase family protein [Cyanobium sp. ELA712]	diamond	207	84.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. ELA712
30609496	30609496	PRJNA1199330_P_NODE_124033_length_212_cov_5.899281_g123334_i0	PRJNA1199330	124033	212	5.899281	12.50647572	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	137	7.82e-36	NR	MBN9397356.1	2052166	g123334	i0	100	0.990566037735849	70	0	99.1	0	212	3	541	610	MBN9397356.1 serine/threonine protein kinase [Candidatus Melainabacteria bacterium]	diamond	210	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30672709	30672709	PRJNA1199330_P_NODE_100313_length_253_cov_0.866667_g99614_i0	PRJNA1199330	100313	253	0.866667	2.19266751	Cyanobium sp. Copco_Reservoir_LC18	1328305	Bacteria	Bacteria	45.4	0.00457	NR	WP_159818519.1	1328305	g99614	i0	45.5	0.521739130434783	44	24	52.2	0	98	229	26	69	WP_159818519.1 glycosyltransferase family 61 protein [Cyanobium sp. Copco_Reservoir_LC18]	diamond	132	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. Copco_Reservoir_LC18
30849713	30849713	PRJNA1199330_P_NODE_110354_length_246_cov_1.473988_g109655_i0	PRJNA1199330	110354	246	1.473988	3.62601048	root	1	Root_unresolved	Root_unresolved	46.2	0.00217	NR	WP_334734406.1	1180	g109655	i0	52.5	2.86585365853659	40	19	48.8	0	126	245	170	209	WP_334734406.1 methyltransferase [Nostoc sp.]	diamond	705	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
30925875	30925875	PRJNA1199330_P_NODE_80714_length_272_cov_1.567839_g80015_i0	PRJNA1199330	80714	272	1.567839	4.26452208	Cyanobacteria bacterium P01_F01_bin.150	3023293	Bacteria	Bacteria	59.3	1.42e-8	NR	MEM9212796.1	3023293	g80015	i0	46.6	1.29044117647059	58	30	64	1	177	4	3	59	MEM9212796.1 thioredoxin-dependent thiol peroxidase [Cyanobacteria bacterium P01_F01_bin.150]	diamond	351	59.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_F01_bin.150
31526405	31526405	PRJNA1199330_P_NODE_115856_length_242_cov_1.639053_g115157_i0	PRJNA1199330	115856	242	1.639053	3.96650826	Cyanophyceae	3028117	Bacteria	Bacteria	84.7	1.42e-17	NR	WP_190764995.1	3028117	g115157	i0	95.5	1.09090909090909	44	2	54.5	0	132	1	1	44	WP_190764995.1 MULTISPECIES: ABC transporter permease [Cyanophyceae]	diamond	264	84.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
32822169	32822169	PRJNA1199330_P_NODE_40160_length_326_cov_1.229249_g39461_i0	PRJNA1199330	40160	326	1.229249	4.00735174	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	50.4	1.86e-4	NR	MFP5503407.1	2762020	g39461	i0	32.5	0.763803680981595	83	46	67.2	2	244	26	106	188	MFP5503407.1 serine/threonine-protein kinase [Candidatus Sericytochromatia bacterium]	diamond	249	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium

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