metadata: contig_metadata: 14 rows where bioproject = "PRJNA335774", tax_phylum = "Acidobacteriota" and tax

14 rows where bioproject = "PRJNA335774", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
13823157	13823157	PRJNA335774_P_NODE_43111_length_247_cov_0.885057_g42959_i0	PRJNA335774	43111	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	159	2.56e-46	NR	MDQ6787343.1	1978231	g42959	i0	90.2	5.97570850202429	82	8	99.6	0	1	246	33	114	MDQ6787343.1 tRNA 2-thiocytidine(32) synthetase TtcA [Acidobacteriota bacterium]	diamond	1476	160	0.99375	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
23341847	23341847	PRJNA335774_P_NODE_11099_length_439_cov_0.830601_g10947_i0	PRJNA335774	11099	439	0.830601	3.64633839	Bacteria	2	Bacteria	Bacteria	221	3.58e-67	NR	MDQ1405843.1	2052142	g10947	i0	69.9	11.9726651480638	146	44	99.8	0	2	439	77	222	MDQ1405843.1 aldehyde dehydrogenase [Acidobacteriaceae bacterium]	diamond	5256	221	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
27327607	27327607	PRJNA335774_P_NODE_47163_length_242_cov_0.911243_g47011_i0	PRJNA335774	47163	242	0.911243	2.20520806	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	44.7	0.00755	NR	MDQ3348975.1	1978231	g47011	i0	36.4	0.818181818181818	66	39	81.8	1	41	238	108	170	MDQ3348975.1 hypothetical protein [Acidobacteriota bacterium]	diamond	198	44.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27485447	27485447	PRJNA335774_P_NODE_17623_length_361_cov_1.364583_g17471_i0	PRJNA335774	17623	361	1.364583	4.92614463	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	93.6	1.65e-19	NR	MBD0327934.1	2283092	g17471	i0	63.2	1.32963988919668	76	25	63.2	1	230	3	2	74	MBD0327934.1 F0F1 ATP synthase subunit alpha [Pyrinomonadaceae bacterium]	diamond	480	93.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27706850	27706850	PRJNA335774_P_NODE_15444_length_381_cov_1.217532_g15292_i0	PRJNA335774	15444	381	1.217532	4.63879692	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	70.5	2.96e-11	NR	HJO03728.1	1978231	g15292	i0	34.7	0.976377952755906	124	64	96.9	4	13	381	259	366	HJO03728.1 PHB depolymerase family esterase [Acidobacteriota bacterium]	diamond	372	70.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28653730	28653730	PRJNA335774_P_NODE_44707_length_245_cov_0.895349_g44555_i0	PRJNA335774	44707	245	0.895349	2.19360505	Candidatus Acidiferrum typicum	1953112	Bacteria	Bacteria	47.4	8.5e-4	NR	MCU1343560.1	1953112	g44555	i0	30.1	2.53469387755102	73	51	89.4	0	232	14	155	227	MCU1343560.1 hypothetical protein [Candidatus Acidiferrum typicum]	diamond	621	47.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum typicum
28986957	28986957	PRJNA335774_P_NODE_16168_length_374_cov_1.146179_g16016_i0	PRJNA335774	16168	374	1.146179	4.28670946	Terriglobales	204433	Bacteria	Bacteria	79.3	6.38e-15	NR	HEY1257354.1	1964191	g16016	i0	37.5	2.6951871657754	112	60	82.6	3	64	372	21	131	HEY1257354.1 hypothetical protein [Terracidiphilus sp.]	diamond	1008	79.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
29948345	29948345	PRJNA335774_P_NODE_46491_length_243_cov_0.905882_g46339_i0	PRJNA335774	46491	243	0.905882	2.20129326	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	44.3	0.0109	NR	MBP6703275.1	2793154	g46339	i0	43.3	1.69135802469136	67	27	80.2	2	195	1	73	130	MBP6703275.1 S9 family peptidase [Vicinamibacteria bacterium]	diamond	411	44.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
30548548	30548548	PRJNA335774_P_NODE_45513_length_244_cov_0.900585_g45361_i0	PRJNA335774	45513	244	0.900585	2.1974274	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	60.1	5.17e-9	NR	HEX8335675.1	2283092	g45361	i0	50.8	0.799180327868853	65	29	77.5	2	189	1	2	65	HEX8335675.1 sulfotransferase [Pyrinomonadaceae bacterium]	diamond	195	60.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30579946	30579946	PRJNA335774_P_NODE_8573_length_491_cov_1.093301_g8421_i0	PRJNA335774	8573	491	1.093301	5.36810791	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	128	1.11e-31	NR	PYV22530.1	1978231	g8421	i0	42.7	0.959266802443992	157	85	95.9	1	491	21	41	192	PYV22530.1 MAG: hypothetical protein DMG24_16385, partial [Acidobacteriota bacterium]	diamond	471	128	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31528499	31528499	PRJNA335774_P_NODE_32796_length_275_cov_1.861386_g32644_i0	PRJNA335774	32796	275	1.861386	5.1188115	Blastocatellia bacterium	2052146	Bacteria	Bacteria	50.8	6.61e-5	NR	HEY8458878.1	2052146	g32644	i0	39.1	0.949090909090909	87	49	93.8	2	6	263	177	260	HEY8458878.1 HEAT repeat domain-containing protein [Blastocatellia bacterium]	diamond	261	50.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
31830132	31830132	PRJNA335774_P_NODE_29077_length_291_cov_1.587156_g28925_i0	PRJNA335774	29077	291	1.587156	4.61862396	Pseudomonadati	3379134	Bacteria	Bacteria	117	1.66e-28	NR	HKE26766.1	2212468	g28925	i0	56.3	9.89690721649485	96	42	99	0	290	3	279	374	HKE26766.1 aldehyde dehydrogenase family protein [Bryobacteraceae bacterium]	diamond	2880	118	0.991525423728814	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
32034554	32034554	PRJNA335774_P_NODE_45558_length_244_cov_0.900585_g45406_i0	PRJNA335774	45558	244	0.900585	2.1974274	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	43.1	0.0274	NR	HYN01254.1	2793154	g45406	i0	33.3	0.737704918032787	60	37	70.1	1	29	199	206	265	HYN01254.1 sulfatase [Vicinamibacteria bacterium]	diamond	180	43.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
32446088	32446088	PRJNA335774_P_NODE_7859_length_508_cov_1.032184_g7707_i0	PRJNA335774	7859	508	1.032184	5.24349472	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	75.5	2.06e-12	NR	HTQ56087.1	2212468	g7707	i0	44.8	1.73031496062992	96	48	53.7	2	232	504	224	319	HTQ56087.1 cytochrome P450 [Bryobacteraceae bacterium]	diamond	879	75.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;