metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA667863" and tax_clade = "Cyanobacteriota/Melainabacteria group"

19 rows where analysis = "diamond", bioproject = "PRJNA667863" 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
17212047	17212047	PRJNA667863_P_NODE_3094_length_347_cov_1.076642_g3060_i0	PRJNA667863	3094	347	1.076642	3.73594774	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	212	4.38e-68	NR	MBX9724270.1	2364082	g3060	i0	91.3	1.97982708933718	115	10	99.4	0	345	1	50	164	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	687	212	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
21036429	21036429	PRJNA667863_P_NODE_15677_length_243_cov_0.905882_g15643_i0	PRJNA667863	15677	243	0.905882	2.20129326	Bacillati	1783272	Bacteria	Bacteria	122	1.38e-30	NR	MBK9204061.1	2711154	g15643	i0	67.5	6.64197530864198	83	24	98.8	1	2	241	356	438	MBK9204061.1 beta-glucosidase [Candidatus Obscuribacter sp.]	diamond	1614	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
26954861	26954861	PRJNA667863_P_NODE_10362_length_255_cov_5.521978_g10328_i0	PRJNA667863	10362	255	5.521978	14.0810439	Calothrix sp. MO_192.B10	3036784	Bacteria	Bacteria	113	4.36e-30	NR	MDJ0619854.1	3036784	g10328	i0	67.5	0.976470588235294	83	27	97.6	0	254	6	15	97	MDJ0619854.1 profilin [Calothrix sp. MO_192.B10]	diamond	249	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. MO_192.B10
27176210	27176210	PRJNA667863_P_NODE_15122_length_244_cov_0.900585_g15088_i0	PRJNA667863	15122	244	0.900585	2.1974274	Vacuolonema iberomarrocanum	3454632	Bacteria	Bacteria	43.5	0.02	NR	MBE9100975.1	1828880	g15088	i0	36.5	0.639344262295082	52	31	61.5	1	43	192	125	176	MBE9100975.1 hypothetical protein [filamentous cyanobacterium LEGE 07170]	diamond	156	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Vacuolonema	Vacuolonema iberomarrocanum
27207799	27207799	PRJNA667863_P_NODE_5002_length_303_cov_1.130435_g4968_i0	PRJNA667863	5002	303	1.130435	3.42521805	Hydrococcus sp. RM1_1_31	2720429	Bacteria	Bacteria	79.7	1.41e-15	NR	NJO93546.1	2720429	g4968	i0	45.3	2	95	48	90.1	3	273	1	11	105	NJO93546.1 fibro-slime domain-containing protein [Hydrococcus sp. RM1_1_31]	diamond	606	79.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hydrococcaceae	Hydrococcus	Hydrococcus sp. RM1_1_31
27883251	27883251	PRJNA667863_P_NODE_745_length_563_cov_4.693878_g713_i0	PRJNA667863	745	563	4.693878	26.42653314	root	1	Root_unresolved	Root_unresolved	94	8.1e-21	NR	WP_070396083.1	1155739	g713	i0	60	2.12078152753108	80	32	42.6	0	1	240	59	138	WP_070396083.1 profilin [Moorena producens]	diamond	1194	94	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
27914745	27914745	PRJNA667863_P_NODE_5985_length_288_cov_1.432558_g5951_i0	PRJNA667863	5985	288	1.432558	4.12576704	Cyanophyceae	3028117	Bacteria	Bacteria	44.3	0.0178	NR	MBI4782238.1	2750147	g5951	i0	29.1	3.13541666666667	79	54	81.3	2	236	3	212	289	MBI4782238.1 hypothetical protein [Oscillatoriophycideae cyanobacterium NC_groundwater_1537_Pr4_S-0.65um_50_18]	diamond	903	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae				Oscillatoriophycideae cyanobacterium NC_groundwater_1537_Pr4_S-0.65um_50_18
29292082	29292082	PRJNA667863_P_NODE_1869_length_403_cov_3.903030_g1835_i0	PRJNA667863	1869	403	3.9030300000000002	15.7292109	Calothrix sp. MO_192.B10	3036784	Bacteria	Bacteria	160	1.27e-47	NR	MDJ0619854.1	3036784	g1835	i0	68.6	0.900744416873449	121	37	89.3	1	44	403	1	121	MDJ0619854.1 profilin [Calothrix sp. MO_192.B10]	diamond	363	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. MO_192.B10
29323569	29323569	PRJNA667863_P_NODE_11369_length_251_cov_0.865169_g11335_i0	PRJNA667863	11369	251	0.865169	2.17157419	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	160	3.78e-44	NR	PZM85239.1	2052166	g11335	i0	98.8	0.99203187250996006	83	1	99.2	0	3	251	499	581	PZM85239.1 MAG: DNA primase [Candidatus Melainabacteria bacterium]	diamond	249	160	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29607464	29607464	PRJNA667863_P_NODE_930_length_519_cov_5.670404_g897_i0	PRJNA667863	930	519	5.6704040000000004	29.42939676	Moorena sp. SIOASIH	2607817	Bacteria	Bacteria	150	4.87e-43	NR	WP_293091305.1	2607817	g897	i0	60.1	0.797687861271676	138	46	74.6	3	489	103	1	138	WP_293091305.1 profilin [Moorena sp. SIOASIH]	diamond	414	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena sp. SIOASIH
29828801	29828801	PRJNA667863_P_NODE_14951_length_244_cov_2.368421_g14917_i0	PRJNA667863	14951	244	2.368421	5.77894724	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	93.6	8.240000000000001e-22	NR	MBW4637628.1	2839657	g14917	i0	83.7	0.602459016393443	49	8	60.2	0	1	147	107	155	MBW4637628.1 GNAT family N-acetyltransferase [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	147	93.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
29955246	29955246	PRJNA667863_P_NODE_13391_length_247_cov_0.885057_g13357_i0	PRJNA667863	13391	247	0.885057	2.18609079	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	70.5	2.65e-12	NR	WP_009632616.1	927677	g13357	i0	91.2	0.412955465587045	34	3	41.3	0	104	3	1	34	WP_009632616.1 WecB/TagA/CpsF family glycosyltransferase [Synechocystis sp. PCC 7509]	diamond	102	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
30461177	30461177	PRJNA667863_P_NODE_11433_length_251_cov_0.865169_g11399_i0	PRJNA667863	11433	251	0.865169	2.17157419	Cyanobacteria bacterium UBA9273	2055791	Bacteria	Bacteria	167	7.919999999999999e-48	NR	HBB31606.1	2055791	g11399	i0	98.8	0.99203187250996006	83	1	99.2	0	3	251	91	173	HBB31606.1 MFS transporter [Cyanobacteria bacterium UBA9273]	diamond	249	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA9273
30472894	30472894	PRJNA667863_P_NODE_15293_length_244_cov_0.900585_g15259_i0	PRJNA667863	15293	244	0.900585	2.1974274	Cyanophyceae	3028117	Bacteria	Bacteria	110	1.54e-26	NR	MBD0361742.1	2768885	g15259	i0	92.3	4.5	52	4	63.9	0	156	1	286	337	MBD0361742.1 transposase [Coleofasciculus sp. C3-bin4]	diamond	1098	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. C3-bin4
30586951	30586951	PRJNA667863_P_NODE_15693_length_243_cov_0.905882_g15659_i0	PRJNA667863	15693	243	0.905882	2.20129326	Cyanophyceae	3028117	Bacteria	Bacteria	162	1.37e-44	NR	WP_199306194.1	3028117	g15659	i0	98.8	1	81	1	100	0	1	243	361	441	WP_199306194.1 MULTISPECIES: AMP-dependent synthetase/ligase [Cyanophyceae]	diamond	243	162	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae
30839873	30839873	PRJNA667863_P_NODE_17154_length_241_cov_0.916667_g17120_i0	PRJNA667863	17154	241	0.916667	2.20916747	Coleofasciculus sp. FACHB-712	2692789	Bacteria	Bacteria	159	1.86e-44	NR	WP_190429838.1	2692789	g17120	i0	97.5	0.995850622406639	80	2	99.6	0	241	2	13	92	WP_190429838.1 phospholipase D-like domain-containing protein [Coleofasciculus sp. FACHB-712]	diamond	240	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. FACHB-712
31029692	31029692	PRJNA667863_P_NODE_15955_length_243_cov_0.905882_g15921_i0	PRJNA667863	15955	243	0.905882	2.20129326	Aliterella atlantica	1827278	Bacteria	Bacteria	90.5	5.08e-19	NR	WP_045053299.1	1827278	g15921	i0	66.2	0.91358024691358	74	25	91.4	0	241	20	170	243	WP_045053299.1 methyl-accepting chemotaxis protein [Aliterella atlantica]	diamond	222	90.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31503868	31503868	PRJNA667863_P_NODE_17536_length_237_cov_2.676829_g17502_i0	PRJNA667863	17536	237	2.676829	6.34408473	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	67.4	6.84e-11	NR	MFA7341534.1	2364082	g17502	i0	64.6	0.607594936708861	48	17	60.8	0	235	92	474	521	MFA7341534.1 DDE-type integrase/transposase/recombinase [Candidatus Obscuribacterales bacterium]	diamond	144	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32768164	32768164	PRJNA667863_P_NODE_16060_length_242_cov_2.710059_g16026_i0	PRJNA667863	16060	242	2.710059	6.55834278	Spirulina sp. CCNP131	1157	Bacteria	Bacteria	68.9	2.09e-11	NR	WP_323257193.1	3110249	g16026	i0	44.3	3.16115702479339	79	41	97.9	1	241	5	263	338	WP_323257193.1 flavin monoamine oxidase family protein [Spirulina sp. CCNP1310]	diamond	765	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp. CCNP1310

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