metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA758770" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA758770" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_order	tax_species
13494416	13494416	PRJNA758770_S_NODE_25411_length_251_cov_0.876404_g25285_i0	PRJNA758770	25411	251	0.876404	2.19977404	Candidatus Dojkabacteria bacterium HGW-Dojkabacteria-1	2013761	Bacteria	Bacteria	155	2.1299999999999994e-42	NR	PKN02790.1	2013761	g25285	i0	92.8	0.99203187250996006	83	6	99.2	0	250	2	72	154	PKN02790.1 MAG: hypothetical protein CVU76_02050 [Candidatus Dojkabacteria bacterium HGW-Dojkabacteria-1]	diamond	249	155	1	Bacteria	Bacteria candidate phyla			Candidatus Dojkabacteria bacterium HGW-Dojkabacteria-1
27274392	27274392	PRJNA758770_S_NODE_28743_length_247_cov_0.896552_g28617_i0	PRJNA758770	28743	247	0.896552	2.21448344	Parcubacteria group bacterium ADurb.Bin216	1852939	Bacteria	Bacteria	64.3	1.6e-11	NR	OQB10002.1	1852939	g28617	i0	50	1.22672064777328	52	26	63.2	0	92	247	1	52	OQB10002.1 MAG: hypothetical protein BWY21_00566 [Parcubacteria group bacterium ADurb.Bin216]	diamond	303	64.3	1	Bacteria	Bacteria candidate phyla			Parcubacteria group bacterium ADurb.Bin216
27716903	27716903	PRJNA758770_S_NODE_24064_length_252_cov_1.134078_g23938_i0	PRJNA758770	24064	252	1.134078	2.85787656	Candidatus Absconditabacterales bacterium	2927939	Bacteria	Bacteria	122	3.95e-32	NR	HMY80910.1	2927939	g23938	i0	83.1	0.988095238095238	83	14	98.8	0	2	250	123	205	HMY80910.1 prohibitin family protein [Candidatus Absconditabacterales bacterium]	diamond	249	122	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditabacterales bacterium
27842640	27842640	PRJNA758770_S_NODE_25204_length_251_cov_0.876404_g25078_i0	PRJNA758770	25204	251	0.876404	2.19977404	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	85.9	1.55e-19	NR	HEY5588263.1	2053589	g25078	i0	69.2	0.621513944223108	52	16	62.2	0	91	246	1	52	HEY5588263.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	156	85.9	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
27937623	27937623	PRJNA758770_S_NODE_32665_length_242_cov_0.923077_g32539_i0	PRJNA758770	32665	242	0.923077	2.23384634	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	98.6	4.93e-22	NR	HYE08665.1	2052139	g32539	i0	51.9	0.979338842975207	79	38	97.9	0	242	6	95	173	HYE08665.1 glycosyltransferase family 2 protein [Patescibacteria group bacterium]	diamond	237	98.6	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
28821279	28821279	PRJNA758770_S_NODE_23968_length_252_cov_1.446927_g23842_i0	PRJNA758770	23968	252	1.446927	3.64625604	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	65.5	3.93e-10	NR	MCH8518718.1	2044595	g23842	i0	39.8	0.988095238095238	83	47	98.8	1	3	251	153	232	MCH8518718.1 hypothetical protein [Candidatus Altimarinota bacterium]	diamond	249	65.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Altimarinota bacterium
29273135	29273135	PRJNA758770_S_NODE_31049_length_244_cov_0.912281_g30923_i0	PRJNA758770	31049	244	0.912281	2.22596564	Bacteria	2	Bacteria	Bacteria	107	1.22e-26	NR	PIQ23068.1	2014262	g30923	i0	86.7	1.54918032786885	60	8	73.8	0	195	16	193	252	PIQ23068.1 MAG: hypothetical protein COW64_25980 [bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26]	diamond	378	107	1	Bacteria	Bacteria candidate phyla	Candidatus Blackallbacteria		bacterium (Candidatus Blackallbacteria) CG18_big_fil_WC_8_21_14_2_50_49_26
30347686	30347686	PRJNA758770_S_NODE_32692_length_242_cov_0.923077_g32566_i0	PRJNA758770	32692	242	0.923077	2.23384634	Bacteria	2	Bacteria	Bacteria	132	2.09e-36	NR	MBN2854262.1	2052139	g32566	i0	82.3	2.9504132231405	79	14	97.9	0	239	3	54	132	MBN2854262.1 30S ribosomal protein S5 [Patescibacteria group bacterium]	diamond	714	132	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
30906367	30906367	PRJNA758770_S_NODE_9214_length_364_cov_1.147766_g9088_i0	PRJNA758770	9214	364	1.147766	4.17786824	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	127	3.3799999999999995e-32	NR	NMC87755.1	2045217	g9088	i0	98.4	0.527472527472527	64	1	52.7	0	363	172	330	393	NMC87755.1 IS30 family transposase [Candidatus Moraniibacteriota bacterium]	diamond	192	127	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota		Candidatus Moraniibacteriota bacterium
32424293	32424293	PRJNA758770_S_NODE_24519_length_252_cov_0.871508_g24393_i0	PRJNA758770	24519	252	0.871508	2.19620016	Candidatus Rifleibacteriota bacterium	2053586	Bacteria	Bacteria	114	6.47e-29	NR	MCK9456405.1	2053586	g24393	i0	59.7	0.916666666666667	77	31	91.7	0	250	20	49	125	MCK9456405.1 metallophosphoesterase family protein [Candidatus Rifleibacteriota bacterium]	diamond	231	114	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota		Candidatus Rifleibacteriota bacterium
32897089	32897089	PRJNA758770_S_NODE_26280_length_250_cov_0.881356_g26154_i0	PRJNA758770	26280	250	0.881356	2.20339	candidate division WS6 bacterium GW2	74243	Bacteria	Bacteria	70.9	4.83e-12	NR	KKP64120.1	1619093	g26154	i0	45.8	0.996	83	45	99.6	0	2	250	320	402	KKP64120.1 MAG: NHL repeat containing protein, partial [candidate division WS6 bacterium GW2011_GWE1_34_7]	diamond	249	70.9	1	Bacteria	Bacteria candidate phyla			candidate division WS6 bacterium GW2011_GWE1_34_7

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