metadata: contig_metadata: 26 rows where bioproject = "PRJNA540466" and tax_clade = "Cyanobacteriota/Melainabacteria group"

26 rows where bioproject = "PRJNA540466" 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
1783623	1783623	PRJNA540466_S_NODE_58622_length_248_cov_2.502857_g58073_i0	PRJNA540466	58622	248	2.502857	6.20708536	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	239	1.6e-58	NTclustered	gi\|225696268\|gb\|FJ805935.1\|	259957	g58073	i0	86.026	44.508064516129	229	25	91	5	24	248	2910	3135	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	11038	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2393957	2393957	PRJNA540466_S_NODE_55762_length_253_cov_1.033333_g55213_i0	PRJNA540466	55762	253	1.033333	2.61433249	Nostocales	1161	Bacteria	Bacteria	222	1.65e-53	NTclustered	gi\|1373819911\|dbj\|AP018318.1\|	196308	g55213	i0	83.133	6.68379446640316	249	36	97	6	8	253	6448728	6448973	Nostoc sp. HK-01 DNA, complete genome	blastn	1691	222	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. HK-01
5611915	5611915	PRJNA540466_S_NODE_47525_length_270_cov_0.878173_g46976_i0	PRJNA540466	47525	270	0.878173	2.3710671	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	425	1.27e-114	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g46976	i0	95.185	129.892592592593	270	12	99	1	2	270	795110	795379	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	35071	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
5612103	5612103	PRJNA540466_S_NODE_70265_length_214_cov_4.510638_g69716_i0	PRJNA540466	70265	214	4.510638	9.65276532	Aliterella chasmolithica	2739056	Bacteria	Bacteria	353	4.609999999999999e-93	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g69716	i0	100	103.976635514019	191	0	89	0	24	214	1969	2159	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	22251	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
8160709	8160709	PRJNA540466_S_NODE_22607_length_374_cov_1.617940_g22058_i0	PRJNA540466	22607	374	1.61794	6.0510956	Leptolyngbya sp. NK1-12	2547451	Bacteria	Bacteria	488	2.29e-133	NTclustered	gi\|2591945363\|gb\|CP053586.1\|	2547451	g22058	i0	93.846	181.71122994652401	325	18	87	2	1	325	451872	451550	Leptolyngbya sp. NK1-12 chromosome 1, complete sequence	blastn	67960	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
15146487	15146487	PRJNA540466_S_NODE_16232_length_435_cov_3.651934_g15685_i0	PRJNA540466	16232	435	3.651934	15.8859129	Synechococcus	1129	Bacteria	Bacteria	52.8	0.042	NTclustered	gi\|2638507609\|emb\|OY986433.1\|	2789857	g15685	i0	100	0.128735632183908	28	0	6	0	140	167	918291	918264	Synechococcus sp. CBW1107 isolate KAC_106 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1107
19634410	19634410	PRJNA540466_S_NODE_7076_length_605_cov_1.447368_g6606_i0	PRJNA540466	7076	605	1.447368	8.7565764	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	935	0	NTclustered	gi\|225696247\|gb\|FJ805914.1\|	259957	g6606	i0	96.791	112.009917355372	561	16	92	2	47	605	2819	2259	Uncultured Chroococcidiopsis sp. clone AN1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	67766	935	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22795641	22795641	PRJNA540466_S_NODE_34498_length_309_cov_2.203390_g33949_i0	PRJNA540466	34498	309	2.20339	6.8084751	Chroococcidiopsis	54298	Bacteria	Bacteria	279	1.22e-70	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g33949	i0	82.958	2.01294498381877	311	51	100	2	1	309	328942	329252	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	622	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
25344820	25344820	PRJNA540466_S_NODE_55220_length_254_cov_1.165746_g54671_i0	PRJNA540466	55220	254	1.165746	2.96099484	Cyanophyceae	3028117	Bacteria	Bacteria	403	5.53e-108	NTclustered	gi\|225696200\|gb\|FJ805867.1\|	259957	g54671	i0	96.341	97.9133858267717	246	8	96	1	10	254	501	256	Uncultured Chroococcidiopsis sp. clone A2_9 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24870	405	0.995061728395062	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
26697859	26697859	PRJNA540466_S_NODE_11421_length_505_cov_7.321759_g10881_i0	PRJNA540466	11421	505	7.321759	36.97488295	Calothrix sp. MO_192.B10	3036784	Bacteria	Bacteria	120	2.6399999999999998e-31	NR	MDJ0619854.1	3036784	g10881	i0	65.3	3.32673267326733	95	33	56.4	0	1	285	45	139	MDJ0619854.1 profilin [Calothrix sp. MO_192.B10]	diamond	1680	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. MO_192.B10
26856594	26856594	PRJNA540466_S_NODE_22321_length_376_cov_1.973597_g21772_i0	PRJNA540466	22321	376	1.973597	7.42072472	Cyanobacteria bacterium UBA11049	2055787	Bacteria	Bacteria	110	1.18e-27	NR	HCF25950.1	2055787	g21772	i0	60.8	0.63031914893617	79	30	63	1	365	129	94	171	HCF25950.1 general stress protein [Cyanobacteria bacterium UBA11049]	diamond	237	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11049
27092717	27092717	PRJNA540466_S_NODE_25162_length_356_cov_1.321555_g24613_i0	PRJNA540466	25162	356	1.321555	4.7047358	Okeania	1458928	Bacteria	Bacteria	76.6	2.29e-15	NR	NES73758.1	2607792	g24613	i0	74.4	2.94943820224719	43	11	36.2	0	352	224	66	108	NES73758.1 DUF2237 domain-containing protein [Okeania sp. SIO2D1]	diamond	1050	77	0.994805194805195	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO2D1
27250729	27250729	PRJNA540466_S_NODE_31743_length_320_cov_3.080972_g31194_i0	PRJNA540466	31743	320	3.080972	9.8591104	Cyanophyceae	3028117	Bacteria	Bacteria	58.9	1.96e-7	NR	WP_228041892.1	54306	g31194	i0	45	3.871875	60	32	56.3	1	214	35	85	143	WP_228041892.1 diguanylate cyclase domain-containing protein [Planktothrix mougeotii]	diamond	1239	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix mougeotii
27488669	27488669	PRJNA540466_S_NODE_1503_length_914_cov_11.577883_g1295_i0	PRJNA540466	1503	914	11.577883	105.82185062	Moorena sp. SIOASIH	2607817	Bacteria	Bacteria	149	4.46e-41	NR	WP_293091305.1	2607817	g1295	i0	60.1	0.452954048140044	138	46	42.3	3	120	506	1	138	WP_293091305.1 profilin [Moorena sp. SIOASIH]	diamond	414	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena sp. SIOASIH
27678378	27678378	PRJNA540466_S_NODE_50084_length_264_cov_1.633508_g49535_i0	PRJNA540466	50084	264	1.633508	4.31246112	Cyanophyceae	3028117	Bacteria	Bacteria	98.6	1.1500000000000002e-21	NR	WP_190769108.1	3028117	g49535	i0	100	0.556818181818182	49	0	55.7	0	264	118	936	984	WP_190769108.1 MULTISPECIES: phosphoenolpyruvate carboxylase [Cyanophyceae]	diamond	147	98.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
27724923	27724923	PRJNA540466_S_NODE_56364_length_252_cov_0.871508_g55815_i0	PRJNA540466	56364	252	0.871508	2.19620016	Chroococcidiopsis	54298	Bacteria	Bacteria	115	8.439999999999999e-31	NR	OWY63088.1	1503470	g55815	i0	98.1	1.28571428571429	54	1	64.3	0	26	187	63	116	OWY63088.1 hypothetical protein B7486_54970, partial [cyanobacterium TDX16]	diamond	324	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16
27962249	27962249	PRJNA540466_S_NODE_68605_length_227_cov_3.155844_g68056_i0	PRJNA540466	68605	227	3.155844	7.16376588	Richelia sinica	1357545	Bacteria	Bacteria	54.3	2.44e-6	NR	WP_190608519.1	1357545	g68056	i0	43.1	1.79735682819383	72	38	92.5	2	3	212	317	387	WP_190608519.1 PIN domain-containing protein [Richelia sinica]	diamond	408	54.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sinica
28103271	28103271	PRJNA540466_S_NODE_29105_length_333_cov_1.761538_g28556_i0	PRJNA540466	29105	333	1.761538	5.86592154	Limnothrix	132605	Bacteria	Bacteria	94.4	1.92e-21	NR	WP_234406884.1	1704291	g28556	i0	64.5	1.11711711711712	62	21	55.9	1	3	188	138	198	WP_234406884.1 CAP domain-containing protein [Limnothrix sp. PR1529]	diamond	372	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix	Limnothrix sp. PR1529
28277829	28277829	PRJNA540466_S_NODE_63806_length_241_cov_3.059524_g63257_i0	PRJNA540466	63806	241	3.059524	7.37345284	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	46.6	0.00132	NR	MEZ0372880.1	2762020	g63257	i0	67.9	0.348547717842324	28	9	34.9	0	228	145	68	95	MEZ0372880.1 hypothetical protein [Candidatus Sericytochromatia bacterium]	diamond	84	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
28972748	28972748	PRJNA540466_S_NODE_67608_length_230_cov_2.318471_g67059_i0	PRJNA540466	67608	230	2.318471	5.3324833	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	73.9	3.08e-13	NR	MDP8964627.1	2847862	g67059	i0	58.6	0.756521739130435	58	24	75.7	0	2	175	396	453	MDP8964627.1 phosphatase PAP2 family protein [Cyanobacteriota bacterium]	diamond	174	73.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29193832	29193832	PRJNA540466_S_NODE_37589_length_298_cov_1.368889_g37040_i0	PRJNA540466	37589	298	1.368889	4.07928922	Chroococcus sp. FPU1	1974212	Bacteria	Bacteria	55.8	1.23e-7	NR	WP_206814480.1	1974212	g37040	i0	44	0.956375838926175	50	28	50.3	0	289	140	34	83	WP_206814480.1 putative quinol monooxygenase [Chroococcus sp. FPU101]	diamond	285	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. FPU101
29256512	29256512	PRJNA540466_S_NODE_13289_length_475_cov_2.258706_g12745_i0	PRJNA540466	13289	475	2.258706	10.7288535	Brasilonema sp. CT11	2748322	Bacteria	Bacteria	61.6	1.65e-8	NR	MBP5977894.1	2748322	g12745	i0	33.8	0.934736842105263	148	92	90.9	3	24	455	14	159	MBP5977894.1 hypothetical protein [Brasilonema sp. CT11]	diamond	444	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sp. CT11
29446045	29446045	PRJNA540466_S_NODE_41430_length_286_cov_1.098592_g40881_i0	PRJNA540466	41430	286	1.098592	3.14197312	Symplocastrum torsivum	1552229	Bacteria	Bacteria	55.1	2.94e-6	NR	MBW4546834.1	450513	g40881	i0	49.1	1.11188811188811	53	25	53.5	1	4	156	885	937	MBW4546834.1 hypothetical protein [Symplocastrum torsivum CPER-KK1]	diamond	318	55.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Symplocastrum	Symplocastrum torsivum
31293377	31293377	PRJNA540466_S_NODE_39255_length_292_cov_3.698630_g38706_i0	PRJNA540466	39255	292	3.69863	10.7999996	Cyanophyceae	3028117	Bacteria	Bacteria	112	2.15e-29	NR	WP_017299986.1	416001	g38706	i0	52.6	6.84246575342466	95	45	97.6	0	288	4	24	118	WP_017299986.1 CAP domain-containing protein [Nodosilinea nodulosa]	diamond	1998	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea nodulosa
32385786	32385786	PRJNA540466_S_NODE_55719_length_253_cov_1.277778_g55170_i0	PRJNA540466	55719	253	1.277778	3.23277834	Acaryochloridaceae cyanobacterium SU_2_1	2720477	Bacteria	Bacteria	44.7	0.00875	NR	NJK41014.1	2720477	g55170	i0	40.6	2.73913043478261	64	37	75.9	1	219	28	422	484	NJK41014.1 trypsin-like serine protease [Acaryochloridaceae cyanobacterium SU_2_1]	diamond	693	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae		Acaryochloridaceae cyanobacterium SU_2_1
32480851	32480851	PRJNA540466_S_NODE_22179_length_377_cov_2.151316_g21630_i0	PRJNA540466	22179	377	2.151316	8.11046132	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	143	3.26e-40	NR	PKL78470.1	2013813	g21630	i0	64.1	1.01856763925729	128	38	99.5	4	375	1	87	209	PKL78470.1 MAG: hypothetical protein CVV27_03250 [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	384	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1

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