metadata: contig_metadata: 23 rows where bioproject = "PRJNA724039" and tax_clade = "Cyanobacteriota/Melainabacteria group"

23 rows where bioproject = "PRJNA724039" 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
711243	711243	PRJNA724039_S_NODE_7561_length_243_cov_0.985437_g7354_i0	PRJNA724039	7561	243	0.985437	2.39461191	Geitlerinema sp. PCC 7407	1173025	Bacteria	Bacteria	370	5.32e-98	NTclustered	gi\|485099144\|ref\|NR_102539.1\|	1173025	g7354	i0	94.915	189.40329218107	236	12	97	0	1	236	452	217	Geitlerinema sp. PCC 7407 strain PCC 7407 23S ribosomal RNA, complete sequence	blastn	46025	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Geitlerinematales	Geitlerinemataceae	Geitlerinema	Geitlerinema sp. PCC 7407
1194196	1194196	PRJNA724039_S_NODE_881_length_964_cov_6.482201_g754_i0	PRJNA724039	881	964	6.482201	62.48841764	Bacteria	2	Bacteria	Bacteria	549	2.8399999999999987e-151	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g754	i0	78.363	114.653526970954	892	161	91	30	1	875	1478010	1477134	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	110526	549	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
3745877	3745877	PRJNA724039_S_NODE_11443_length_190_cov_3.379085_g11236_i0	PRJNA724039	11443	190	3.379085	6.4202615	Cyanophyceae	3028117	Bacteria	Bacteria	289	1.14e-73	NTclustered	gi\|1992526127\|gb\|CP070366.1\|	2811482	g11236	i0	94.211	170.6	190	10	99	1	2	190	2492364	2492175	Thermoleptolyngbya sp. PKUAC-SCTB121 chromosome, complete genome	blastn	32414	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya sp. PKUAC-SCTB121
4539621	4539621	PRJNA724039_S_NODE_6344_length_270_cov_4.982833_g6137_i0	PRJNA724039	6344	270	4.982833	13.4536491	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	259	1.36e-64	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g6137	i0	84.387	165.518518518519	269	36	99	5	2	268	511544	511280	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	44690	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
7089944	7089944	PRJNA724039_S_NODE_4046_length_355_cov_5.292453_g3839_i0	PRJNA724039	4046	355	5.292453	18.78820815	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	412	1.3399999999999998e-110	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g3839	i0	87.603	198.185915492958	363	35	99	3	2	355	3681814	3681453	Leptolyngbya sp. 7M chromosome	blastn	70356	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
7572014	7572014	PRJNA724039_S_NODE_2966_length_426_cov_25.339332_g2759_i0	PRJNA724039	2966	426	25.339332	107.94555432	Cyanophyceae	3028117	Bacteria	Bacteria	710	0	NTclustered	gi\|928241609\|gb\|KT731142.1\|	1716596	g2759	i0	96.714	103.06103286385	426	14	100	0	1	426	850	425	Pseudanabaenaceae cyanobacterium CENA321 16S ribosomal RNA gene, partial sequence	blastn	43904	710	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae		Pseudanabaenaceae cyanobacterium CENA321
9639623	9639623	PRJNA724039_S_NODE_17128_length_154_cov_1.811966_g16921_i0	PRJNA724039	17128	154	1.811966	2.79042764	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	228	1.9599999999999996e-55	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g16921	i0	93.464	323.12987012987	153	10	99	0	1	153	3679592	3679440	Leptolyngbya sp. 7M chromosome	blastn	49762	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
10122641	10122641	PRJNA724039_S_NODE_13348_length_175_cov_2.572464_g13141_i0	PRJNA724039	13348	175	2.572464	4.501812	Oscillatoriales	1150	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g13141	i0	100	158	175	0	100	0	1	175	811654	811480	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	27650	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
10915125	10915125	PRJNA724039_S_NODE_12369_length_182_cov_6.103448_g12162_i0	PRJNA724039	12369	182	6.103448	11.10827536	Calothrix sp. 336/3	1337936	Bacteria	Bacteria	137	4.15e-28	NTclustered	gi\|817925425\|gb\|CP011382.1\|	1337936	g12162	i0	80.899	79.2802197802198	178	30	97	4	2	177	6078237	6078412	Calothrix sp. 336/3, complete genome	blastn	14429	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. 336/3
11397746	11397746	PRJNA724039_S_NODE_15069_length_164_cov_3.165354_g14862_i0	PRJNA724039	15069	164	3.165354	5.19118056	Microcystis	1125	Bacteria	Bacteria	195	2.15e-45	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g14862	i0	88.344	56.8475609756098	163	18	99	1	1	163	5089684	5089523	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	9323	195	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
14740355	14740355	PRJNA724039_S_NODE_872_length_969_cov_19.296137_g746_i0	PRJNA724039	872	969	19.296137	186.97956753	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1016	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g746	i0	85.744	283.33746130031	968	130	99	6	4	969	3680783	3681744	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	274554	1016	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
17289205	17289205	PRJNA724039_S_NODE_3414_length_393_cov_5.665730_g3207_i0	PRJNA724039	3414	393	5.66573	22.2663189	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	289	2.63e-73	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g3207	i0	80.8	43.8676844783715	375	67	94	5	4	374	3680783	3681156	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	17240	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
17771833	17771833	PRJNA724039_S_NODE_10054_length_205_cov_2.220238_g9847_i0	PRJNA724039	10054	205	2.220238	4.5514879	Cyanophyceae	3028117	Bacteria	Bacteria	335	1.5899999999999992e-87	NTclustered	gi\|521763259\|gb\|KC463193.1\|	1352667	g9847	i0	96.535	100.20487804878	202	7	99	0	4	205	208	7	Oscillatoriales cyanobacterium EcFYyyy300 16S ribosomal RNA gene, partial sequence	blastn	20542	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium EcFYyyy300
17771889	17771889	PRJNA724039_S_NODE_1774_length_586_cov_23.976321_g1584_i0	PRJNA724039	1774	586	23.976321	140.50124106	Leptolyngbya	47251	Bacteria	Bacteria	876	0	NTclustered	gi\|2591945363\|gb\|CP053586.1\|	2547451	g1584	i0	93.955	164.436860068259	579	35	99	0	8	586	451294	450716	Leptolyngbya sp. NK1-12 chromosome 1, complete sequence	blastn	96360	881	0.994324631101022	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
18562859	18562859	PRJNA724039_S_NODE_15675_length_161_cov_1.838710_g15468_i0	PRJNA724039	15675	161	1.83871	2.9603231	Microcystis sp. MC19	1967666	Bacteria	Bacteria	130	6.01e-26	NTclustered	gi\|1370745791\|gb\|CP020664.1\|	1967666	g15468	i0	82.166	24.8571428571429	157	22	95	6	8	160	1026972	1027126	Microcystis sp. MC19 chromosome, complete genome	blastn	4002	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. MC19
20320543	20320543	PRJNA724039_S_NODE_10196_length_203_cov_5.036145_g9989_i0	PRJNA724039	10196	203	5.036145	10.22337435	Bacillati	1783272	Bacteria	Bacteria	220	4.58e-53	NTclustered	gi\|899519\|gb\|U28099.1\|UEU28099	40912	g9989	i0	86.869	7.00492610837438	198	25	97	1	1	197	100	297	Unidentified eubacterium clone PS#4 ribonuclease P RNA (rnpB) gene, partial sequence	blastn	1422	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					unidentified eubacterium clone PS#4
21113597	21113597	PRJNA724039_S_NODE_10017_length_205_cov_6.375000_g9810_i0	PRJNA724039	10017	205	6.375	13.06875	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	62.1	2.97e-5	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g9810	i0	100	0.160975609756098	33	0	16	0	1	33	1887804	1887772	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	33	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21596368	21596368	PRJNA724039_S_NODE_14297_length_169_cov_1.431818_g14090_i0	PRJNA724039	14297	169	1.431818	2.41977242	Cyanophyceae	3028117	Bacteria	Bacteria	250	4.66e-62	NTclustered	gi\|442539708\|gb\|KC218853.1\|	1211	g14090	i0	93.452	97.8639053254438	168	11	99	0	2	169	422	255	Uncultured cyanobacterium clone NAT29 16S ribosomal RNA gene, partial sequence	blastn	16539	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21596416	21596416	PRJNA724039_S_NODE_5237_length_305_cov_6.854478_g5030_i0	PRJNA724039	5237	305	6.854478	20.9061579	root	1	Root_unresolved	Root_unresolved	542	1.38e-149	NTclustered	gi\|238632324\|gb\|FJ967932.1\|	1211	g5030	i0	98.689	100.996721311475	305	4	100	0	1	305	390	694	Uncultured cyanobacterium clone BAC_2_G07 16S ribosomal RNA (rrn) gene, partial sequence	blastn	30804	542	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
27684428	27684428	PRJNA724039_S_NODE_13844_length_172_cov_1.429630_g13637_i0	PRJNA724039	13844	172	1.42963	2.4589636	Nostoc linckia z16	1628751	Bacteria	Bacteria	115	1.8499999999999999e-28	NR	PHK27803.1	1628751	g13637	i0	100	0.976744186046512	56	0	97.7	0	3	170	123	178	PHK27803.1 hypothetical protein VF13_41225 [Nostoc linckia z16]	diamond	168	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc linckia
28347094	28347094	PRJNA724039_S_NODE_7046_length_254_cov_2.096774_g6839_i0	PRJNA724039	7046	254	2.096774	5.32580596	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	129	3.61e-37	NR	MFA6208533.1	2364082	g6839	i0	95.7	0.826771653543307	70	3	82.7	0	43	252	1	70	MFA6208533.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	210	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28978740	28978740	PRJNA724039_S_NODE_9008_length_218_cov_1.917127_g8801_i0	PRJNA724039	9008	218	1.917127	4.17933686	Nostoc linckia z16	1628751	Bacteria	Bacteria	142	3.87e-38	NR	PHK27803.1	1628751	g8801	i0	98.6	0.990825688073395	72	1	99.1	0	1	216	172	243	PHK27803.1 hypothetical protein VF13_41225 [Nostoc linckia z16]	diamond	216	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc linckia
29136723	29136723	PRJNA724039_S_NODE_15849_length_160_cov_2.186992_g15642_i0	PRJNA724039	15849	160	2.186992	3.4991872	Nostoc linckia z16	1628751	Bacteria	Bacteria	102	6.3e-24	NR	PHK27803.1	1628751	g15642	i0	100	0.975	52	0	97.5	0	3	158	302	353	PHK27803.1 hypothetical protein VF13_41225 [Nostoc linckia z16]	diamond	156	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc linckia

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