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

17 rows where analysis = "diamond", bioproject = "PRJNA492280" 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
26776080	26776080	PRJNA492280_P_NODE_15621_length_164_cov_4.370079_g15514_i0	PRJNA492280	15621	164	4.370079	7.16692956	Bacteria	2	Bacteria	Bacteria	41.6	0.0331	NR	MBA4074283.1	2067979	g15514	i0	66.7	0.878048780487805	24	8	43.9	0	6	77	471	494	MBA4074283.1 hypothetical protein [Cyanobacteria bacterium PR.023]	diamond	144	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium PR.023
27013074	27013074	PRJNA492280_P_NODE_29742_length_151_cov_5.982456_g29635_i0	PRJNA492280	29742	151	5.982456	9.03350856	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	57.8	5.29e-8	NR	PZM78484.1	2052166	g29635	i0	100	0.47682119205298	24	0	47.7	0	147	76	3	26	PZM78484.1 MAG: glycogen debranching enzyme GlgX [Candidatus Melainabacteria bacterium]	diamond	72	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27044793	27044793	PRJNA492280_P_NODE_16262_length_164_cov_4.149606_g16155_i0	PRJNA492280	16262	164	4.149606	6.80535384	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	48.9	8.5e-5	NR	RTL36781.1	2052166	g16155	i0	50.8	1.07926829268293	59	23	97	1	162	4	154	212	RTL36781.1 MAG: ATP-dependent zinc metalloprotease FtsH [Candidatus Melainabacteria bacterium]	diamond	177	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27202611	27202611	PRJNA492280_P_NODE_30822_length_151_cov_3.798246_g30715_i0	PRJNA492280	30822	151	3.798246	5.73535146	Timaviella obliquedivisa	2303516	Bacteria	Bacteria	52	5.42e-6	NR	MBW4514799.1	2057768	g30715	i0	81.8	0.655629139072848	33	3	59.6	1	6	95	206	238	MBW4514799.1 CRISPR-associated protein [Timaviella obliquedivisa GSE-PSE-MK23-08B]	diamond	99	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Timaviella	Timaviella obliquedivisa
27550218	27550218	PRJNA492280_P_NODE_33004_length_150_cov_4.592920_g32897_i0	PRJNA492280	33004	150	4.59292	6.88938	Chroococcidiopsis cubana	171392	Bacteria	Bacteria	72.8	2.58e-13	NR	WP_106168274.1	171392	g32897	i0	52.9	1.74	87	2	96	1	3	146	206	292	WP_106168274.1 efflux RND transporter permease subunit [Chroococcidiopsis cubana]	diamond	261	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis cubana
27581847	27581847	PRJNA492280_P_NODE_24484_length_164_cov_2.661417_g24377_i0	PRJNA492280	24484	164	2.661417	4.36472388	Pseudanabaena sp. M57BS1SP1A06MG	2771237	Bacteria	Bacteria	48.5	1.17e-4	NR	MCA6601201.1	2771237	g24377	i0	59.5	0.676829268292683	37	15	67.7	0	111	1	454	490	MCA6601201.1 hypothetical protein [Pseudanabaena sp. M57BS1SP1A06MG]	diamond	111	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. M57BS1SP1A06MG
28497701	28497701	PRJNA492280_P_NODE_23787_length_164_cov_2.763780_g23680_i0	PRJNA492280	23787	164	2.76378	4.5325992	Drouetiella sp.	3088174	Bacteria	Bacteria	63.5	5.78e-10	NR	HEY9730773.1	3088174	g23680	i0	46.6	3.18292682926829	88	12	97	1	3	161	280	367	HEY9730773.1 PAS domain-containing sensor histidine kinase [Drouetiella sp.]	diamond	522	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
28529328	28529328	PRJNA492280_P_NODE_22827_length_164_cov_2.889764_g22720_i0	PRJNA492280	22827	164	2.889764	4.73921296	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	82.8	1.62e-18	NR	MBX3137683.1	2364082	g22720	i0	77.4	1.13414634146341	62	5	97	1	2	160	49	110	MBX3137683.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	186	82.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28876393	28876393	PRJNA492280_P_NODE_33768_length_150_cov_3.663717_g33661_i0	PRJNA492280	33768	150	3.663717	5.4955755	Cyanobacteria bacterium FACHB-471	2692763	Bacteria	Bacteria	67	1.94e-11	NR	MBD1868862.1	2692763	g33661	i0	44.6	1.84	92	8	98	1	148	2	52	143	MBD1868862.1 helix-turn-helix transcriptional regulator [Cyanobacteria bacterium FACHB-471]	diamond	276	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium FACHB-471
30107893	30107893	PRJNA492280_P_NODE_20192_length_164_cov_3.299213_g20085_i0	PRJNA492280	20192	164	3.299213	5.41070932	Drouetiella sp.	3088174	Bacteria	Bacteria	50.4	1.71e-5	NR	HEY9731272.1	3088174	g20085	i0	95.8	0.439024390243902	24	1	43.9	0	91	162	124	147	HEY9731272.1 hypothetical protein [Drouetiella sp.]	diamond	72	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella sp.
30218699	30218699	PRJNA492280_P_NODE_34472_length_150_cov_3.026549_g34365_i0	PRJNA492280	34472	150	3.026549	4.5398235	Cyanophyceae	3028117	Bacteria	Bacteria	54.7	6.19e-7	NR	WP_190431276.1	450526	g34365	i0	100	3.84	24	0	48	0	4	75	215	238	WP_190431276.1 MULTISPECIES: radical SAM protein [Trichocoleus]	diamond	576	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus
30518721	30518721	PRJNA492280_P_NODE_19813_length_164_cov_3.362205_g19706_i0	PRJNA492280	19813	164	3.362205	5.5140162	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	44.3	0.00354	NR	PKL77801.1	2013813	g19706	i0	65.7	1.97560975609756	35	12	64	0	109	5	19	53	PKL77801.1 MAG: bifunctional methylenetetrahydrofolate dehydrogenase/methenyltetrahydrofolate cyclohydrolase FolD [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	324	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
31056170	31056170	PRJNA492280_P_NODE_14395_length_164_cov_4.842520_g14288_i0	PRJNA492280	14395	164	4.84252	7.9417328	Aliterella atlantica	1827278	Bacteria	Bacteria	51.6	9.23e-6	NR	WP_045056004.1	1827278	g14288	i0	100	0.439024390243902	24	0	43.9	0	163	92	40	63	WP_045056004.1 type I glyceraldehyde-3-phosphate dehydrogenase [Aliterella atlantica]	diamond	72	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
31087443	31087443	PRJNA492280_P_NODE_16895_length_164_cov_3.976378_g16788_i0	PRJNA492280	16895	164	3.976378	6.52125992	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	42.4	0.00366	NR	HEY9652711.1	3081323	g16788	i0	66.7	1.44512195121951	24	8	43.9	0	74	3	11	34	HEY9652711.1 hypothetical protein [Coleofasciculaceae cyanobacterium]	diamond	237	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
31181914	31181914	PRJNA492280_P_NODE_32535_length_150_cov_5.761062_g32428_i0	PRJNA492280	32535	150	5.761062	8.641593	Cyanobacteria bacterium SZAS LIN-5	2807734	Bacteria	Bacteria	49.7	3.8e-5	NR	MBS2002039.1	2807734	g32428	i0	95.7	0.94	23	1	46	0	144	76	464	486	MBS2002039.1 CocE/NonD family hydrolase [Cyanobacteria bacterium SZAS LIN-5]	diamond	141	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-5
31957277	31957277	PRJNA492280_P_NODE_21777_length_164_cov_3.007874_g21670_i0	PRJNA492280	21777	164	3.007874	4.93291336	Cyanophyceae	3028117	Bacteria	Bacteria	56.6	4.37e-8	NR	WP_009631098.1	927677	g21670	i0	100	7.51829268292683	24	0	43.9	0	161	90	62	85	WP_009631098.1 photosystem II cytochrome c-550 [Synechocystis sp. PCC 7509]	diamond	1233	57	0.992982456140351	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
32763023	32763023	PRJNA492280_P_NODE_22480_length_164_cov_2.937008_g22373_i0	PRJNA492280	22480	164	2.937008	4.81669312	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	48.9	6.21e-5	NR	RTL35552.1	2052166	g22373	i0	70.8	0.439024390243902	24	7	43.9	0	75	4	100	123	RTL35552.1 MAG: hypothetical protein EKK48_28065 [Candidatus Melainabacteria bacterium]	diamond	72	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium

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