metadata: contig_metadata: 28 rows where bioproject = "PRJNA1123309" and tax_clade = "Cyanobacteriota/Melainabacteria group"

28 rows where bioproject = "PRJNA1123309" 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
6656471	6656471	PRJNA1123309_P_NODE_65846_length_242_cov_0.923077_g65466_i0	PRJNA1123309	65846	242	0.923077	2.23384634	uncultured Rivularia sp.	447564	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2621703013\|emb\|OY762007.1\|	447564	g65466	i0	100	0.119834710743802	29	0	12	0	65	93	662926	662954	MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	uncultured Rivularia sp.
11756635	11756635	PRJNA1123309_P_NODE_21170_length_345_cov_3.117647_g20791_i0	PRJNA1123309	21170	345	3.117647	10.75588215	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	488	2.0999999999999993e-133	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g20791	i0	94.888	137.713043478261	313	14	90	2	16	327	3479	3168	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47511	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11757086	11757086	PRJNA1123309_P_NODE_610_length_1502_cov_5.058083_g475_i0	PRJNA1123309	610	1502	5.058083	75.97240666	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2231	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g475	i0	93.679	104.896138482024	1503	75	99	12	7	1501	3109	1619	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	157554	2231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15581452	15581452	PRJNA1123309_P_NODE_6533_length_578_cov_2.223762_g6175_i0	PRJNA1123309	6533	578	2.223762	12.85334436	Stanieria cyanosphaera	102116	Bacteria	Bacteria	446	2.24e-120	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g6175	i0	80.911	31.1851211072664	571	104	98	4	4	570	819	250	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	18025	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
20679530	20679530	PRJNA1123309_P_NODE_18737_length_363_cov_1.527586_g18358_i0	PRJNA1123309	18737	363	1.527586	5.54513718	Nostoc sp. C052	2576902	Bacteria	Bacteria	65.8	4.42e-6	NTclustered	gi\|1866639087\|gb\|CP040272.1\|	2576902	g18358	i0	93.182	100.537190082645	44	3	12	0	27	70	566460	566417	Nostoc sp. C052 chromosome, complete genome	blastn	36495	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C052
25255377	25255377	PRJNA1123309_P_NODE_49960_length_251_cov_1.707865_g49580_i0	PRJNA1123309	49960	251	1.707865	4.28674115	Nostoc	1177	Bacteria	Bacteria	390	4.239999999999999e-104	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g49580	i0	96.218	288.733067729084	238	9	95	0	14	251	56714	56477	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	72472	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
27038554	27038554	PRJNA1123309_P_NODE_57482_length_247_cov_0.896552_g57102_i0	PRJNA1123309	57482	247	0.896552	2.21448344	Microcystis sp. M42BS1	2771192	Bacteria	Bacteria	90.9	2.14e-19	NR	WP_287705463.1	2771192	g57102	i0	69.2	0.947368421052632	78	20	94.7	1	234	1	191	264	WP_287705463.1 hypothetical protein [Microcystis sp. M42BS1]	diamond	234	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M42BS1
27196434	27196434	PRJNA1123309_P_NODE_9642_length_485_cov_1.521845_g9267_i0	PRJNA1123309	9642	485	1.521845	7.38094825	Leptolyngbya sp.	47254	Bacteria	Bacteria	47.4	0.0101	NR	MEB3269333.1	47254	g9267	i0	41	0.377319587628866	61	34	37.7	1	283	465	162	220	MEB3269333.1 glycosyltransferase family 39 protein [Leptolyngbya sp.]	diamond	183	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp.
27228136	27228136	PRJNA1123309_P_NODE_41263_length_267_cov_1.963918_g40883_i0	PRJNA1123309	41263	267	1.963918	5.24366106	Hormoscilla sp. GUM202	2480853	Bacteria	Bacteria	122	3.12e-32	NR	MBO1351640.1	2480853	g40883	i0	66.7	3.85393258426966	87	29	97.8	0	265	5	117	203	MBO1351640.1 SDR family oxidoreductase [Hormoscilla sp. GUM202]	diamond	1029	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	Hormoscilla sp. GUM202
27449586	27449586	PRJNA1123309_P_NODE_41183_length_268_cov_0.948718_g40803_i0	PRJNA1123309	41183	268	0.948718	2.54256424	Coleofasciculus sp. S288	2876727	Bacteria	Bacteria	89.4	2.5e-20	NR	MCA1992396.1	2876727	g40803	i0	84	0.559701492537313	50	7	54.9	1	147	1	1	50	MCA1992396.1 DUF29 domain-containing protein [Coleofasciculus sp. S288]	diamond	150	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. S288
27765369	27765369	PRJNA1123309_P_NODE_46684_length_253_cov_1.722222_g46304_i0	PRJNA1123309	46684	253	1.722222	4.35722166	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	111	5.14e-28	NR	MBX9693789.1	2847862	g46304	i0	66.7	0.99604743083004	84	28	99.6	0	252	1	116	199	MBX9693789.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	252	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27828333	27828333	PRJNA1123309_P_NODE_1104_length_1197_cov_2.738434_g919_i0	PRJNA1123309	1104	1197	2.738434	32.77905498	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	468	5.01e-162	NR	MBX9694561.1	2847862	g919	i0	74.4	2.42105263157895	308	74	75.9	2	1132	224	15	322	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	2898	468	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28206999	28206999	PRJNA1123309_P_NODE_24606_length_324_cov_0.976096_g24226_i0	PRJNA1123309	24606	324	0.976096	3.16255104	Synechococcus sp.	1131	Bacteria	Bacteria	45.8	0.00747	NR	MEB3271288.1	1131	g24226	i0	37	0.75	81	41	72.2	4	12	245	50	123	MEB3271288.1 hypothetical protein [Synechococcus sp.]	diamond	243	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp.
28670101	28670101	PRJNA1123309_P_NODE_42667_length_264_cov_1.219895_g42287_i0	PRJNA1123309	42667	264	1.219895	3.2205228	Bacillati	1783272	Bacteria	Bacteria	80.5	2.46e-15	NR	OGI00057.1	1801606	g42287	i0	53.2	10.7045454545455	79	37	89.8	0	263	27	77	155	OGI00057.1 MAG: sodium-translocating pyrophosphatase [Candidatus Melainabacteria bacterium GWF2_37_15]	diamond	2826	80.9	0.995055624227441	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium GWF2_37_15
28901645	28901645	PRJNA1123309_P_NODE_68108_length_228_cov_2.006452_g67728_i0	PRJNA1123309	68108	228	2.006452	4.57471056	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	55.5	9.49e-7	NR	MBX9692038.1	2847862	g67728	i0	55.9	0.776315789473684	59	23	77.6	1	20	196	275	330	MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	177	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29217769	29217769	PRJNA1123309_P_NODE_43729_length_261_cov_1.521277_g43349_i0	PRJNA1123309	43729	261	1.521277	3.97053297	Anabaena sp. UHCC	1167	Bacteria	Bacteria	44.3	0.0133	NR	WP_323268198.1	3110238	g43349	i0	63.3	1.06896551724138	30	11	34.5	0	261	172	463	492	WP_323268198.1 NB-ARC domain-containing protein, partial [Anabaena sp. UHCC 0399]	diamond	279	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. UHCC 0399
29343942	29343942	PRJNA1123309_P_NODE_3389_length_766_cov_4.741703_g3078_i0	PRJNA1123309	3389	766	4.741703	36.32144498	Coleofasciculus sp. H7-2	3351545	Bacteria	Bacteria	53.5	4.82e-4	NR	WP_378174148.1	3351545	g3078	i0	28.3	0.469973890339426	120	74	42.3	2	19	342	462	581	WP_378174148.1 lipoxygenase family protein [Coleofasciculus sp. H7-2]	diamond	360	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. H7-2
29469825	29469825	PRJNA1123309_P_NODE_24770_length_323_cov_1.204000_g24390_i0	PRJNA1123309	24770	323	1.204	3.88892	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	70.5	1.26e-11	NR	MEA3493114.1	2053573	g24390	i0	47.9	0.659442724458204	71	37	65.9	0	20	232	267	337	MEA3493114.1 ankyrin repeat domain-containing protein [Candidatus Margulisiibacteriota bacterium]	diamond	213	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
30007167	30007167	PRJNA1123309_P_NODE_60951_length_245_cov_0.906977_g60571_i0	PRJNA1123309	60951	245	0.906977	2.22209365	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	88.2	3.04e-18	NR	WP_190377811.1	2650499	g60571	i0	70.1	0.942857142857143	77	23	94.3	0	238	8	1	77	WP_190377811.1 MULTISPECIES: D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [unclassified Leptolyngbya]	diamond	231	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
30164748	30164748	PRJNA1123309_P_NODE_10012_length_477_cov_1.126238_g9636_i0	PRJNA1123309	10012	477	1.126238	5.37215526	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	240	7.68e-77	NR	MBX9693408.1	2847862	g9636	i0	88.5	0.874213836477987	139	16	87.4	0	19	435	155	293	MBX9693408.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	417	240	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30670430	30670430	PRJNA1123309_P_NODE_42213_length_265_cov_1.390625_g41833_i0	PRJNA1123309	42213	265	1.390625	3.68515625	Okeania sp. SIO2C2	2607787	Bacteria	Bacteria	75.1	1.95e-13	NR	WP_287521849.1	2607787	g41833	i0	62	0.566037735849057	50	19	56.6	0	264	115	425	474	WP_287521849.1 tetratricopeptide repeat-containing sulfotransferase family protein [Okeania sp. SIO2C2]	diamond	150	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Okeania	Okeania sp. SIO2C2
30796806	30796806	PRJNA1123309_P_NODE_67494_length_235_cov_3.580247_g67114_i0	PRJNA1123309	67494	235	3.580247	8.41358045	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	50.1	8.23e-5	NR	MBX9692038.1	2847862	g67114	i0	63.9	0.459574468085106	36	13	46	0	215	108	166	201	MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	108	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30880815	30880815	PRJNA1123309_P_NODE_60034_length_246_cov_0.861272_g59654_i0	PRJNA1123309	60034	246	0.861272	2.11872912	Cyanophyceae	3028117	Bacteria	Bacteria	43.9	0.0149	NR	MBW4473153.1	1382958	g59654	i0	47.9	1.84146341463415	48	21	53.7	1	72	203	588	635	MBW4473153.1 lipoxygenase [Stenomitos rutilans HA7619-LM2]	diamond	453	44.3	0.99097065462754	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos rutilans
31681862	31681862	PRJNA1123309_P_NODE_4517_length_680_cov_1.431631_g4182_i0	PRJNA1123309	4517	680	1.431631	9.7350908	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	71.2	2.01e-10	NR	MBX9692038.1	2847862	g4182	i0	28.2	0.908823529411765	206	114	79.9	5	589	47	5	201	MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	618	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31766086	31766086	PRJNA1123309_P_NODE_15757_length_390_cov_2.384858_g15378_i0	PRJNA1123309	15757	390	2.384858	9.3009462	Pseudanabaena	1152	Bacteria	Bacteria	186	8.069999999999999e-52	NR	WP_190486929.1	2692859	g15378	i0	76.8	9.63076923076923	125	27	96.2	2	14	388	879	1001	WP_190486929.1 glutamate synthase large subunit [Pseudanabaena sp. FACHB-2040]	diamond	3756	186	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. FACHB-2040
31840053	31840053	PRJNA1123309_P_NODE_38217_length_275_cov_1.341584_g37837_i0	PRJNA1123309	38217	275	1.341584	3.689356	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	118	2.3899999999999995e-32	NR	MBX9693409.1	2847862	g37837	i0	72.3	0.905454545454545	83	23	90.5	0	257	9	1	83	MBX9693409.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	249	118	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31871785	31871785	PRJNA1123309_P_NODE_55577_length_248_cov_0.891429_g55197_i0	PRJNA1123309	55577	248	0.891429	2.21074392	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	144	3.01e-38	NR	MBW4640892.1	2839657	g55197	i0	100	0.931451612903226	77	0	93.1	0	2	232	375	451	MBW4640892.1 ABC transporter permease subunit [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	231	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32725412	32725412	PRJNA1123309_P_NODE_32260_length_289_cov_2.731481_g31880_i0	PRJNA1123309	32260	289	2.731481	7.89398009	Limnofasciculus baicalensis	3064906	Bacteria	Bacteria	48.5	5.86e-4	NR	WP_254014787.1	3064906	g31880	i0	46.5	0.8719723183391	43	23	44.6	0	286	158	445	487	WP_254014787.1 tetratricopeptide repeat protein, partial [Limnofasciculus baicalensis]	diamond	252	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Limnofasciculus	Limnofasciculus baicalensis

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