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

16 rows where analysis = "diamond", bioproject = "PRJEB7799" 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
25662520	25662520	PRJEB7799c_S_NODE_18226_length_163_cov_2.632812_g18203_i0	PRJEB7799	18226	163	2.632812	4.29148356	Nostoc sp. CMAA16	1180	Bacteria	Bacteria	99.8	5.1899999999999996e-24	NR	WP_236145297.1	2055159	g18203	i0	98	0.938650306748466	51	1	93.9	0	3	155	88	138	WP_236145297.1 F0F1 ATP synthase subunit gamma, partial [Nostoc sp. CMAA1605]	diamond	153	99.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CMAA1605
26345530	26345530	PRJEB7799p_S_NODE_2863_length_284_cov_5.301205_g2840_i0	PRJEB7799	2863	284	5.301205	15.0554222	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	135	3.46e-38	NR	MBX9724270.1	2364082	g2840	i0	91.4	0.73943661971831	70	6	73.9	0	3	212	101	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	210	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
32930028	32930028	PRJEB7799d_S_NODE_2697_length_198_cov_2.484663_g2687_i0	PRJEB7799	2697	198	2.484663	4.91963274	Nostoc sp. CMAA16	1180	Bacteria	Bacteria	75.5	3.14e-16	NR	WP_236145211.1	2055159	g2687	i0	96.8	0.46969696969697	31	1	47	0	1	93	36	66	WP_236145211.1 hypothetical protein, partial [Nostoc sp. CMAA1605]	diamond	93	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CMAA1605
32947242	32947242	PRJEB7799f_S_NODE_1834_length_206_cov_5.643275_g1818_i0	PRJEB7799	1834	206	5.643275	11.6251465	Microcystis aeruginosa PCC 78	1126	Bacteria	Bacteria	48.5	1.45e-4	NR	ARI79959.1	1903187	g1818	i0	52.4	0.611650485436893	42	20	61.2	0	7	132	27	68	ARI79959.1 hypothetical protein BH695_0678 [Microcystis aeruginosa PCC 7806SL]	diamond	126	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
32947301	32947301	PRJEB7799g_S_NODE_2754_length_197_cov_4.308642_g2538_i0	PRJEB7799	2754	197	4.308642	8.48802474	Microcystis aeruginosa PCC 78	1126	Bacteria	Bacteria	45.4	0.00176	NR	ARI79959.1	1903187	g2538	i0	47.6	0.639593908629442	42	22	64	0	6	131	27	68	ARI79959.1 hypothetical protein BH695_0678 [Microcystis aeruginosa PCC 7806SL]	diamond	126	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
32964157	32964157	PRJEB7799a_S_NODE_12250_length_174_cov_1.726619_g12215_i0	PRJEB7799	12250	174	1.726619	3.00431706	Calothrix sp. PCC 63	1187	Bacteria	Bacteria	39.7	0.0324	NR	WP_015199565.1	1170562	g12215	i0	66.7	0.413793103448276	24	8	41.4	0	1	72	7	30	WP_015199565.1 hypothetical protein [Calothrix sp. PCC 6303]	diamond	72	39.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
32981349	32981349	PRJEB7799a_S_NODE_6867_length_204_cov_3.059172_g6832_i0	PRJEB7799	6867	204	3.059172	6.24071088	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	43.5	0.0107	NR	MBI2811608.1	2052166	g6832	i0	72.2	0.529411764705882	36	10	52.9	0	202	95	31	66	MBI2811608.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	108	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
33015285	33015285	PRJEB7799a_S_NODE_19284_length_151_cov_5.439655_g19249_i0	PRJEB7799	19284	151	5.439655	8.21387905	Nostoc sp. CHAB 5836	2780404	Bacteria	Bacteria	41.6	0.00478	NR	WP_229551186.1	2780404	g19249	i0	71.4	0.556291390728477	28	8	55.6	0	112	29	22	49	WP_229551186.1 hypothetical protein [Nostoc sp. CHAB 5836]	diamond	84	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5836
33025958	33025958	PRJEB7799p_S_NODE_20932_length_162_cov_3.629921_g20909_i0	PRJEB7799	20932	162	3.629921	5.88047202	Bacteria	2	Bacteria	Bacteria	44.3	0.00115	NR	MFM6519251.1	513223	g20909	i0	55.3	4.27777777777778	47	21	87	0	157	17	73	119	MFM6519251.1 tetratricopeptide repeat protein [Microcystis panniformis]	diamond	693	44.7	0.991051454138702	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis panniformis
33067395	33067395	PRJEB7799p_S_NODE_17037_length_172_cov_3.109489_g17014_i0	PRJEB7799	17037	172	3.109489	5.34832108	Nostoc sp. CMAA16	1180	Bacteria	Bacteria	96.3	1.34e-22	NR	WP_236145297.1	2055159	g17014	i0	98	0.854651162790698	49	1	85.5	0	1	147	38	86	WP_236145297.1 F0F1 ATP synthase subunit gamma, partial [Nostoc sp. CMAA1605]	diamond	147	96.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CMAA1605
33083523	33083523	PRJEB7799a_S_NODE_3318_length_255_cov_3.972727_g3283_i0	PRJEB7799	3318	255	3.972727	10.13045385	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	71.6	2.84e-12	NR	MBX9721607.1	2364082	g3283	i0	100	0.811764705882353	35	0	41.2	0	107	3	414	448	MBX9721607.1 LysM peptidoglycan-binding domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	207	71.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33083784	33083784	PRJEB7799h_S_NODE_230_length_302_cov_1239.775281_g227_i0	PRJEB7799	230	302	1239.775281	3744.12134862	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	121	1.7899999999999998e-32	NR	MBX9724270.1	2364082	g227	i0	96.6	0.586092715231788	59	2	58.6	0	273	97	112	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	177	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
33094110	33094110	PRJEB7799o_S_NODE_1022_length_220_cov_2.848649_g1014_i0	PRJEB7799	1022	220	2.848649	6.2670278	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	40.4	0.0172	NR	UWU47611.1	459495	g1014	i0	81.8	1.2	22	4	30	0	213	148	21	42	UWU47611.1 Clp protease [Arthrospira platensis C1]	diamond	264	40.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
33152034	33152034	PRJEB7799i_S_NODE_10552_length_155_cov_2.908333_g10522_i0	PRJEB7799	10552	155	2.908333	4.50791615	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	63.9	2.16e-11	NR	PZM84364.1	2052166	g10522	i0	76.3	0.735483870967742	38	9	73.5	0	17	130	78	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	114	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
33152246	33152246	PRJEB7799l_S_NODE_10152_length_169_cov_6.305970_g10123_i0	PRJEB7799	10152	169	6.30597	10.6570893	Nostoc sp. CHAB 5836	2780404	Bacteria	Bacteria	42.7	0.00213	NR	WP_229551186.1	2780404	g10123	i0	71.4	0.497041420118343	28	8	49.7	0	124	41	22	49	WP_229551186.1 hypothetical protein [Nostoc sp. CHAB 5836]	diamond	84	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5836
33152739	33152739	PRJEB7799p_S_NODE_18944_length_167_cov_1.818182_g18921_i0	PRJEB7799	18944	167	1.818182	3.03636394	Cyanobacteria bacterium P01_G01_bin.39	3023304	Bacteria	Bacteria	57.4	9.06e-8	NR	MEM8719171.1	3023304	g18921	i0	59.6	0.844311377245509	47	18	84.4	1	162	22	310	355	MEM8719171.1 DUF4347 domain-containing protein [Cyanobacteria bacterium P01_G01_bin.39]	diamond	141	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_G01_bin.39

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