metadata: contig_metadata: 25 rows where bioproject = "PRJNA753704" and tax_clade = "Cyanobacteriota/Melainabacteria group"

25 rows where bioproject = "PRJNA753704" 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
2477535	2477535	PRJNA753704_P_NODE_8462_length_401_cov_5.176829_g8101_i0	PRJNA753704	8462	401	5.176829	20.75908429	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	134	1.87e-34	NR	WP_006530517.1	102232	g8101	i0	64.6	8.8428927680798	96	34	71.8	0	388	101	320	415	WP_006530517.1 glycerate kinase type-2 family protein [Gloeocapsa sp. PCC 73106]	diamond	3546	135	0.992592592592593	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 73106
5834612	5834612	PRJNA753704_P_NODE_19685_length_274_cov_0.925373_g19324_i0	PRJNA753704	19685	274	0.925373	2.53552202	Picosynechococcus sp. PCC 7003	374981	Bacteria	Bacteria	331	2.89e-86	NTclustered	gi\|2275105\|emb\|X97393.1\|	374981	g19324	i0	91.057	23.6386861313869	246	20	89	2	28	272	4	248	Synechococcus sp. rnpB gene, strain PCC7003	blastn	6477	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7003
7109645	7109645	PRJNA753704_P_NODE_11386_length_351_cov_1.122302_g11025_i0	PRJNA753704	11386	351	1.122302	3.93928002	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	353	8.12e-93	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g11025	i0	85.714	0.977207977207977	343	39	97	8	1	339	2647202	2647538	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	343	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8384446	8384446	PRJNA753704_P_NODE_30967_length_208_cov_4.881481_g30606_i0	PRJNA753704	30967	208	4.881481	10.15348048	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	340	3.4699999999999996e-89	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g30606	i0	96.154	2.03365384615385	208	8	100	0	1	208	3682437	3682230	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	423	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8384452	8384452	PRJNA753704_P_NODE_327_length_1751_cov_25.941001_g212_i0	PRJNA753704	327	1751	25.941001	454.22692751	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1873	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g212	i0	86.11	146.216447744146	1771	209	100	35	1	1751	3682673	3680920	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	256025	1873	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
8384455	8384455	PRJNA753704_P_NODE_347_length_1691_cov_22.076638_g212_i1	PRJNA753704	347	1691	22.076638	373.31594858	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1831	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g212	i1	86.276	145.948551153164	1705	210	100	21	1	1691	3680979	3682673	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	246799	1831	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
9659663	9659663	PRJNA753704_P_NODE_4488_length_533_cov_2.636957_g4129_i0	PRJNA753704	4488	533	2.636957	14.05498081	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	316	3.89e-108	NR	MBX9724270.1	2364082	g4129	i0	91.1	0.945590994371482	168	15	94.6	0	8	511	3	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	504	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
10935002	10935002	PRJNA753704_P_NODE_15609_length_303_cov_5.121739_g15248_i0	PRJNA753704	15609	303	5.121739	15.51886917	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	181	5.47e-54	NR	MFN4151019.1	2762020	g15248	i0	89	0.99009900990099	100	11	99	0	2	301	138	237	MFN4151019.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	300	181	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
17309070	17309070	PRJNA753704_P_NODE_12134_length_341_cov_1.152985_g11773_i0	PRJNA753704	12134	341	1.152985	3.93167885	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	196	6.469999999999999e-61	NR	MFN4150446.1	2762020	g11773	i0	80.5	0.994134897360704	113	22	99.4	0	340	2	58	170	MFN4150446.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	339	196	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
17779735	17779735	PRJNA753704_P_NODE_17874_length_285_cov_7.650943_g17513_i0	PRJNA753704	17874	285	7.650943	21.80518755	root	1	Root_unresolved	Root_unresolved	503	6.049999999999998e-138	NTclustered	gi\|469665367\|gb\|KC545738.1\|	1211	g17513	i0	98.932	113.228070175439	281	3	99	0	2	282	873	593	Uncultured cyanobacterium clone BFB532 16S ribosomal RNA gene, partial sequence	blastn	32270	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17779796	17779796	PRJNA753704_P_NODE_25814_length_248_cov_0.891429_g25453_i0	PRJNA753704	25814	248	0.891429	2.21074392	Microcoleus	44471	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|1804756945\|gb\|MT013207.1\|	2705320	g25453	i0	99.194	174.125	248	2	100	0	1	248	1893	2140	Microcoleus anatoxicus PTRS1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43183	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
21133731	21133731	PRJNA753704_P_NODE_617_length_1324_cov_12.866507_g426_i0	PRJNA753704	617	1324	12.866507	170.35255268	Limnospira platensis	118562	Bacteria	Bacteria	1552	0	NTclustered	gi\|83777317\|gb\|DQ120927.1\|	357682	g426	i0	100	10.929003021148	840	0	63	0	1	840	840	1	Arthrospira platensis Ap-s chemotaxis signal transduction protein gene, partial cds	blastn	14470	1552	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
23684140	23684140	PRJNA753704_P_NODE_2959_length_644_cov_12.119089_g2606_i0	PRJNA753704	2959	644	12.119089	78.04693316	Limnospira platensis	118562	Bacteria	Bacteria	708	0	NTclustered	gi\|83777317\|gb\|DQ120927.1\|	357682	g2606	i0	99.741	7.93012422360248	386	1	60	0	1	386	831	1216	Arthrospira platensis Ap-s chemotaxis signal transduction protein gene, partial cds	blastn	5107	708	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
26926354	26926354	PRJNA753704_P_NODE_26582_length_246_cov_0.901734_g26221_i0	PRJNA753704	26582	246	0.901734	2.21826564	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	142	1.2899999999999999e-38	NR	MBX9694244.1	2847862	g26221	i0	82.9	1	82	14	100	0	246	1	27	108	MBX9694244.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	246	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
26957817	26957817	PRJNA753704_P_NODE_25482_length_248_cov_1.782857_g25121_i0	PRJNA753704	25482	248	1.782857	4.42148536	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	56.2	4.43e-7	NR	MFN4150446.1	2762020	g25121	i0	44.8	0.810483870967742	67	27	81	1	29	229	10	66	MFN4150446.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	201	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
26957825	26957825	PRJNA753704_P_NODE_802_length_1189_cov_5.344982_g574_i0	PRJNA753704	802	1189	5.344982	63.55183598	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	464	1.0799999999999997e-160	NR	MBX9694561.1	2847862	g574	i0	73.4	2.43734230445753	308	77	76.5	2	1146	238	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2898	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27210731	27210731	PRJNA753704_P_NODE_11902_length_344_cov_1.726937_g11541_i0	PRJNA753704	11902	344	1.726937	5.94066328	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	97.8	1.98e-21	NR	MBX9692038.1	2847862	g11541	i0	62	0.619186046511628	71	26	61	1	135	344	4	74	MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	213	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27369308	27369308	PRJNA753704_P_NODE_17423_length_289_cov_1.300926_g17062_i0	PRJNA753704	17423	289	1.300926	3.75967614	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	135	6.31e-38	NR	MBX9674352.1	2364082	g17062	i0	100	0.695501730103806	67	0	69.6	0	201	1	1	67	MBX9674352.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	201	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27758034	27758034	PRJNA753704_P_NODE_21124_length_265_cov_1.947917_g20763_i0	PRJNA753704	21124	265	1.947917	5.16198005	root	1	Root_unresolved	Root_unresolved	102	5.15e-23	NR	WP_244892590.1	431041	g20763	i0	68	36.8603773584906	75	21	84.9	2	1	225	238	309	WP_244892590.1 leucyl aminopeptidase [Candidatus Synechococcus spongiarum]	diamond	9768	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Candidatus Synechococcus spongiarum
29515841	29515841	PRJNA753704_P_NODE_4170_length_550_cov_1.528302_g3811_i0	PRJNA753704	4170	550	1.528302	8.405661	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	92	2.27e-19	NR	MBX9690859.1	2847862	g3811	i0	39.1	0.698181818181818	128	72	68.7	3	524	147	2	125	MBX9690859.1 AMP-binding protein [Cyanobacteriota bacterium]	diamond	384	92	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29873254	29873254	PRJNA753704_P_NODE_24591_length_250_cov_2.033898_g24230_i0	PRJNA753704	24591	250	2.033898	5.084745	Nostoc	1177	Bacteria	Bacteria	68.6	1.37e-11	NR	WP_289798355.1	3056647	g24230	i0	64.4	1.644	45	16	54	0	14	148	65	109	WP_289798355.1 hypothetical protein [Nostoc sp. GT001]	diamond	411	68.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. GT001
30337718	30337718	PRJNA753704_P_NODE_11292_length_352_cov_2.150538_g10931_i0	PRJNA753704	11292	352	2.150538	7.56989376	Aphanizomenon flos-aquae WA1	1176	Bacteria	Bacteria	76.3	1.31e-14	NR	OBQ32396.1	1710896	g10931	i0	45	1.11647727272727	131	51	98	6	6	350	20	145	OBQ32396.1 MAG: hypothetical protein AN484_27995, partial [Aphanizomenon flos-aquae WA102]	diamond	393	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
30495400	30495400	PRJNA753704_P_NODE_28453_length_242_cov_0.923077_g28092_i0	PRJNA753704	28453	242	0.923077	2.23384634	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	112	1.22e-26	NR	MFN4149581.1	2762020	g28092	i0	69.9	0.90495867768595	73	22	90.5	0	24	242	6	78	MFN4149581.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	219	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
32455947	32455947	PRJNA753704_P_NODE_27939_length_243_cov_0.917647_g27578_i0	PRJNA753704	27939	243	0.917647	2.22988221	Gloeomargarita sp. SKYB120	2972682	Bacteria	Bacteria	99.4	4.45e-22	NR	MCS7293508.1	2972682	g27578	i0	64.6	6.53086419753086	65	23	80.2	0	226	32	433	497	MCS7293508.1 isoleucine--tRNA ligase [Gloeomargarita sp. SKYB120]	diamond	1587	99.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeomargaritales	Gloeomargaritaceae	Gloeomargarita	Gloeomargarita sp. SKYB120
32708120	32708120	PRJNA753704_P_NODE_10600_length_363_cov_2.003448_g10239_i0	PRJNA753704	10600	363	2.003448	7.27251624	Hassallia sp. WJT32-NPBG1	2835088	Bacteria	Bacteria	67.4	3.2e-10	NR	MBW4609009.1	2835088	g10239	i0	37.7	0.942148760330578	114	62	93.4	3	17	355	436	541	MBW4609009.1 Dyp-type peroxidase [Hassallia sp. WJT32-NPBG1]	diamond	342	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Hassallia	Hassallia sp. WJT32-NPBG1

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