metadata: contig_metadata: 31 rows where bioproject = "PRJNA1122875" and tax

31 rows where bioproject = "PRJNA1122875" and tax_phylum = "Cyanobacteriota"

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
2828567	2828567	PRJNA1122875_P_NODE_51203_length_243_cov_1.470588_g50979_i0	PRJNA1122875	51203	243	1.470588	3.57352884	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|225696216\|gb\|FJ805883.1\|	259957	g50979	i0	98.765	161.01646090535	243	3	100	0	1	243	2583	2825	Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39127	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6655458	6655458	PRJNA1122875_P_NODE_2886_length_861_cov_4.593909_g2716_i0	PRJNA1122875	2886	861	4.593909	39.55355649	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	579	3.22e-160	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g2716	i0	82.805	51.6178861788618	663	98	76	12	1	655	6695754	6696408	Leptolyngbya sp. 7M chromosome	blastn	44443	579	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
6655649	6655649	PRJNA1122875_P_NODE_45786_length_249_cov_0.875000_g45562_i0	PRJNA1122875	45786	249	0.875	2.17875	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	361	3.3e-95	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g45562	i0	92.771	1	249	18	100	0	1	249	2901584	2901832	Allocoleopsis franciscana PCC 7113, complete genome	blastn	249	361	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
8682021	8682021	PRJNA1122875_P_NODE_5327_length_681_cov_1.695724_g5117_i0	PRJNA1122875	5327	681	1.695724	11.54788044	root	1	Root_unresolved	Root_unresolved	186	2.52e-52	NR	WP_290883344.1	1191	g5117	i0	59.9	52.6563876651982	157	57	67	2	1	456	338	493	WP_290883344.1 leucyl aminopeptidase [Fischerella sp.]	diamond	35859	186	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp.
9205411	9205411	PRJNA1122875_P_NODE_12508_length_471_cov_2.062814_g12285_i0	PRJNA1122875	12508	471	2.062814	9.71585394	Lyngbya aestuarii	118322	Bacteria	Bacteria	150	1.2899999999999999e-39	NR	WP_023066999.1	118322	g12285	i0	50	2.95541401273885	158	74	99.4	4	2	469	19	173	WP_023066999.1 FAD-dependent oxidoreductase [Lyngbya aestuarii]	diamond	1392	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Lyngbya	Lyngbya aestuarii
14306817	14306817	PRJNA1122875_P_NODE_5852_length_655_cov_2.589347_g5640_i0	PRJNA1122875	5852	655	2.589347	16.96022285	Bacteria	2	Bacteria	Bacteria	216	1.7999999999999996e-68	NR	MEO0406224.1	3023243	g5640	i0	65.5	7.45648854961832	148	51	67.8	0	579	136	2	149	MEO0406224.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_A01_bin.135]	diamond	4884	218	0.990825688073395	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_A01_bin.135
16331150	16331150	PRJNA1122875_P_NODE_28373_length_308_cov_7.089362_g28149_i0	PRJNA1122875	28373	308	7.089362	21.83523496	root	1	Root_unresolved	Root_unresolved	281	3.37e-71	NTclustered	gi\|558025694\|gb\|KF463268.1\|	1211	g28149	i0	100	108.094155844156	152	0	97	0	4	155	241	392	Uncultured cyanobacterium clone slizCya30 16S ribosomal RNA gene, partial sequence	blastn	33293	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16854902	16854902	PRJNA1122875_P_NODE_33094_length_286_cov_1.131455_g32870_i0	PRJNA1122875	33094	286	1.131455	3.2359613	Vacuolonema iberomarrocanum	3454632	Bacteria	Bacteria	100	1.3e-22	NR	MBE9102058.1	1828880	g32870	i0	54.7	0.996503496503496	95	41	99.7	1	1	285	240	332	MBE9102058.1 alkene reductase [filamentous cyanobacterium LEGE 07170]	diamond	285	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Vacuolonema	Vacuolonema iberomarrocanum
17606507	17606507	PRJNA1122875_P_NODE_51994_length_243_cov_0.905882_g51770_i0	PRJNA1122875	51994	243	0.905882	2.20129326	Chroococcidiopsis	54298	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g51770	i0	99.177	181.855967078189	243	2	100	0	1	243	64	306	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	44191	438	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
21430599	21430599	PRJNA1122875_P_NODE_10277_length_516_cov_11.446953_g10058_i0	PRJNA1122875	10277	516	11.446953	59.06627748	root	1	Root_unresolved	Root_unresolved	281	5.92e-71	NTclustered	gi\|558025694\|gb\|KF463268.1\|	1211	g10058	i0	100	97.437984496124	152	0	87	0	4	155	241	392	Uncultured cyanobacterium clone slizCya30 16S ribosomal RNA gene, partial sequence	blastn	50278	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26975185	26975185	PRJNA1122875_P_NODE_39782_length_263_cov_1.215789_g39558_i0	PRJNA1122875	39782	263	1.215789	3.19752507	Goleter apudmare	1886697	Bacteria	Bacteria	42.7	0.0482	NR	MBW4644832.1	1382955	g39558	i0	33.3	0.992395437262357	87	42	99.2	3	262	2	572	642	MBW4644832.1 amino acid adenylation domain-containing protein [Goleter apudmare HA4340-LM2]	diamond	261	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Goleter	Goleter apudmare
27091027	27091027	PRJNA1122875_P_NODE_51002_length_244_cov_0.900585_g50778_i0	PRJNA1122875	51002	244	0.900585	2.1974274	Adonisia	2950183	Bacteria	Bacteria	79	2.79e-15	NR	WP_163696175.1	2950184	g50778	i0	52.3	2.31147540983607	65	31	79.9	0	241	47	237	301	WP_163696175.1 hypothetical protein [Adonisia turfae]	diamond	564	79.3	0.996216897856242	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota				Adonisia	Adonisia turfae
27607373	27607373	PRJNA1122875_P_NODE_18024_length_393_cov_1.743750_g17800_i0	PRJNA1122875	18024	393	1.74375	6.8529375	Chlorogloeopsis sp. ULAP	28069	Bacteria	Bacteria	66.6	6.29e-11	NR	WP_289792290.1	3056483	g17800	i0	34.3	0.824427480916031	108	69	80.9	2	359	42	4	111	WP_289792290.1 beta-lactamase hydrolase domain-containing protein [Chlorogloeopsis sp. ULAP01]	diamond	324	66.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis sp. ULAP01
27796849	27796849	PRJNA1122875_P_NODE_17724_length_397_cov_0.768519_g17500_i0	PRJNA1122875	17724	397	0.768519	3.05102043	Nostoc sp. UHCC	1180	Bacteria	Bacteria	58.9	3.77e-7	NR	WP_237993545.1	2914041	g17500	i0	31.1	1.86649874055416	119	71	89.9	5	25	381	95	202	WP_237993545.1 glycosyltransferase family 8 protein [Nostoc sp. UHCC 0870]	diamond	741	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0870
27828288	27828288	PRJNA1122875_P_NODE_32084_length_289_cov_1.388889_g31860_i0	PRJNA1122875	32084	289	1.388889	4.01388921	Allocoleopsis sp.	3088169	Bacteria	Bacteria	44.3	0.0171	NR	HEY9703304.1	3088169	g31860	i0	84.6	0.269896193771626	26	4	27	0	91	14	10	35	HEY9703304.1 cbb3-type cytochrome c oxidase subunit I [Allocoleopsis sp.]	diamond	78	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis sp.
27880607	27880607	PRJNA1122875_P_NODE_10125_length_520_cov_2.241611_g9906_i0	PRJNA1122875	10125	520	2.241611	11.6563772	Microcoleaceae	1892252	Bacteria	Bacteria	95.5	2.66e-19	NR	MCL2933004.1	2917419	g9906	i0	42.3	4.46538461538462	149	56	85.4	6	11	454	430	549	MCL2933004.1 ABC transporter ATP-binding protein/permease [Trichodesmium sp. MAG_R03]	diamond	2322	96.3	0.991692627206646	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Trichodesmium	Trichodesmium sp. MAG_R03
28049277	28049277	PRJNA1122875_P_NODE_50565_length_244_cov_0.900585_g50341_i0	PRJNA1122875	50565	244	0.900585	2.1974274	Cyanobacteria bacterium J06555_13	3023131	Bacteria	Bacteria	46.6	0.00167	NR	MEN8445163.1	3023131	g50341	i0	36.6	1.74590163934426	71	44	87.3	1	2	214	119	188	MEN8445163.1 S-layer homology domain-containing protein [Cyanobacteria bacterium J06555_13]	diamond	426	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06555_13
28270125	28270125	PRJNA1122875_P_NODE_6846_length_614_cov_2.558226_g6630_i0	PRJNA1122875	6846	614	2.558226	15.70750764	Cyanobacteria bacterium RI_101	2775578	Bacteria	Bacteria	92.8	1.08e-18	NR	MBJ7898529.1	2775578	g6630	i0	60	1.54397394136808	70	28	34.2	0	142	351	4	73	MBJ7898529.1 DnaJ domain-containing protein [Cyanobacteria bacterium RI_101]	diamond	948	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium RI_101
28270130	28270130	PRJNA1122875_P_NODE_8926_length_551_cov_1.652720_g8707_i0	PRJNA1122875	8926	551	1.65272	9.1064872	Acaryochloris thomasi	2929456	Bacteria	Bacteria	72.4	2.89e-11	NR	WP_110988953.1	2929456	g8707	i0	32.4	1.48094373865699	136	80	72.4	4	23	421	230	356	WP_110988953.1 fatty acid desaturase family protein [Acaryochloris thomasi]	diamond	816	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris thomasi
28586196	28586196	PRJNA1122875_P_NODE_19487_length_378_cov_1.200000_g19263_i0	PRJNA1122875	19487	378	1.2	4.536	Rhizonema sp. NSF051	3019273	Bacteria	Bacteria	57.4	6.62e-7	NR	MDF5716538.1	3019273	g19263	i0	33.6	0.992063492063492	125	53	99.2	2	1	375	46	140	MDF5716538.1 cadmium resistance transporter [Rhizonema sp. NSF051]	diamond	375	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rhizonemataceae	Rhizonema	Rhizonema sp. NSF051
28859333	28859333	PRJNA1122875_P_NODE_35588_length_278_cov_1.126829_g35364_i0	PRJNA1122875	35588	278	1.126829	3.13258462	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	97.1	1.1200000000000002e-21	NR	WP_323356229.1	59930	g35364	i0	57	9.38848920863309	79	33	84.2	1	43	276	121	199	WP_323356229.1 NADPH-dependent aldehyde reductase Ahr [Cyanobium gracile]	diamond	2610	97.8	0.992842535787321	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
29175373	29175373	PRJNA1122875_P_NODE_32769_length_287_cov_1.242991_g32545_i0	PRJNA1122875	32769	287	1.242991	3.56738417	root	1	Root_unresolved	Root_unresolved	83.6	2.21e-16	NR	WP_193801356.1	102235	g32545	i0	52.2	3.80487804878049	69	33	72.1	0	238	32	314	382	WP_193801356.1 serpin family protein [Cyanobacterium stanieri]	diamond	1092	83.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium stanieri
29438145	29438145	PRJNA1122875_P_NODE_20410_length_369_cov_1.040541_g20186_i0	PRJNA1122875	20410	369	1.040541	3.83959629	Cyanobium sp. FGCU6	2974642	Bacteria	Bacteria	85.5	1.87e-17	NR	MCS5692086.1	2974642	g20186	i0	44	3.40650406504065	109	46	78.9	3	72	362	53	158	MCS5692086.1 peptidylprolyl isomerase [Cyanobium sp. FGCU6]	diamond	1257	85.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. FGCU6
29785749	29785749	PRJNA1122875_P_NODE_26771_length_319_cov_1.878049_g26547_i0	PRJNA1122875	26771	319	1.878049	5.99097631	Kovacikia minuta	2931930	Bacteria	Bacteria	101	4.34e-25	NR	WP_254721928.1	2931930	g26547	i0	64.7	0.639498432601881	68	24	63.9	0	318	115	54	121	WP_254721928.1 DUF1688 family protein [Kovacikia minuta]	diamond	204	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
30007101	30007101	PRJNA1122875_P_NODE_28671_length_307_cov_0.987179_g28447_i0	PRJNA1122875	28671	307	0.987179	3.03063953	Scytonema sp. UIC 1	1204	Bacteria	Bacteria	95.5	1.5e-21	NR	WP_155747481.1	2304196	g28447	i0	57.1	3.72312703583062	70	30	68.4	0	2	211	86	155	WP_155747481.1 hypothetical protein [Scytonema sp. UIC 10036]	diamond	1143	95.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. UIC 10036
30249202	30249202	PRJNA1122875_P_NODE_7852_length_581_cov_0.940945_g7634_i0	PRJNA1122875	7852	581	0.940945	5.46689045	root	1	Root_unresolved	Root_unresolved	58.2	3.51e-6	NR	WP_127083364.1	32056	g7634	i0	32.3	3.21170395869191	124	61	58.3	3	423	85	127	238	WP_127083364.1 scytonemin biosynthesis PEP-CTERM protein ScyF [Dulcicalothrix desertica]	diamond	1866	58.5	0.994871794871795	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
31808531	31808531	PRJNA1122875_P_NODE_19317_length_379_cov_2.009804_g19093_i0	PRJNA1122875	19317	379	2.009804	7.61715716	Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35	2801880	Bacteria	Bacteria	56.6	1.78e-6	NR	MBV8885584.1	2801880	g19093	i0	33.7	1.99472295514512	89	57	69.7	2	3	266	199	286	MBV8885584.1 NmrA/HSCARG family protein [Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35]	diamond	756	56.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35
31903391	31903391	PRJNA1122875_P_NODE_41177_length_257_cov_2.929348_g40953_i0	PRJNA1122875	41177	257	2.929348	7.52842436	Synechococcaceae cyanobacterium SM2_3_1	2720469	Bacteria	Bacteria	79.3	5.89e-15	NR	NJK64014.1	2720469	g40953	i0	65.3	2.3579766536965	49	17	57.2	0	246	100	917	965	NJK64014.1 aminomethyl-transferring glycine dehydrogenase [Synechococcaceae cyanobacterium SM2_3_1]	diamond	606	79.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae cyanobacterium SM2_3_1
32030101	32030101	PRJNA1122875_P_NODE_3098_length_840_cov_3.320730_g2919_i0	PRJNA1122875	3098	840	3.32073	27.894132	Hormoscilla sp. GUM202	2480853	Bacteria	Bacteria	72.8	3.05e-11	NR	MBO1348701.1	2480853	g2919	i0	31.9	0.514285714285714	144	88	48.2	3	595	191	16	158	MBO1348701.1 hypothetical protein [Hormoscilla sp. GUM202]	diamond	432	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	Hormoscilla sp. GUM202
32125139	32125139	PRJNA1122875_P_NODE_50118_length_244_cov_1.801170_g49894_i0	PRJNA1122875	50118	244	1.80117	4.3948548	Synechococcus sp. BA-124 BA4	3110251	Bacteria	Bacteria	80.1	5.58e-16	NR	WP_323243508.1	3110251	g49894	i0	54	2.37295081967213	63	29	77.5	0	229	41	97	159	WP_323243508.1 class I SAM-dependent methyltransferase [Synechococcus sp. BA-124 BA4]	diamond	579	80.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. BA-124 BA4
32188258	32188258	PRJNA1122875_P_NODE_17378_length_401_cov_0.939024_g17154_i0	PRJNA1122875	17378	401	0.939024	3.76548624	Prochloraceae cyanobacterium	2692183	Bacteria	Bacteria	149	3.9699999999999996e-43	NR	MDJ0716040.1	2692183	g17154	i0	53	1.00249376558603	134	61	99.5	2	401	3	10	142	MDJ0716040.1 SET domain-containing protein [Prochloraceae cyanobacterium]	diamond	402	149	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Prochloraceae		Prochloraceae cyanobacterium

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