metadata: contig_metadata: 13 rows where bioproject = "PRJNA1093008", tax_phylum = "Acidobacteriota" and tax

13 rows where bioproject = "PRJNA1093008", 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
23151109	23151109	PRJNA1093008_S_NODE_74919_length_258_cov_2.281081_g74592_i0	PRJNA1093008	74919	258	2.281081	5.88518898	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g74592	i0	100	0.108527131782946	28	0	11	0	56	83	3917185	3917158	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
24424511	24424511	PRJNA1093008_S_NODE_47240_length_299_cov_1.362832_g46913_i0	PRJNA1093008	47240	299	1.362832	4.07486768	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	99.4	8.75e-24	NR	HXH25865.1	2910147	g46913	i0	73	2.23745819397993	74	19	74.2	1	3	224	105	177	HXH25865.1 polymer-forming cytoskeletal protein [Vicinamibacterales bacterium]	diamond	669	99.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
26750682	26750682	PRJNA1093008_S_NODE_11861_length_425_cov_2.187500_g11535_i0	PRJNA1093008	11861	425	2.1875	9.296875	Luteitalea sp.	2004800	Bacteria	Bacteria	45.8	0.00573	NR	MQA30427.1	2004800	g11535	i0	40	0.423529411764706	60	34	40.9	1	133	306	62	121	MQA30427.1 hypothetical protein [Luteitalea sp.]	diamond	180	45.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp.
27035984	27035984	PRJNA1093008_S_NODE_93342_length_243_cov_0.905882_g93015_i0	PRJNA1093008	93342	243	0.905882	2.20129326	Candidatus Sulfomarinibacteraceae bacterium	3069604	Bacteria	Bacteria	40.8	0.0275	NR	HSO29607.1	3069604	g93015	i0	33.8	0.91358024691358	74	32	88.9	3	16	231	11	69	HSO29607.1 hypothetical protein [Candidatus Sulfomarinibacteraceae bacterium]	diamond	222	40.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Candidatus Sulfomarinibacteraceae		Candidatus Sulfomarinibacteraceae bacterium
27320550	27320550	PRJNA1093008_S_NODE_22023_length_365_cov_2.452055_g21696_i0	PRJNA1093008	22023	365	2.452055	8.95000075	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	44.3	0.0378	NR	MEO8051486.1	1978231	g21696	i0	28.3	0.493150684931507	60	43	49.3	0	234	55	311	370	MEO8051486.1 glycosyltransferase [Acidobacteriota bacterium]	diamond	180	44.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27691145	27691145	PRJNA1093008_S_NODE_17604_length_386_cov_1.932907_g17277_i0	PRJNA1093008	17604	386	1.932907	7.46102102	Bacteria	2	Bacteria	Bacteria	45.8	0.0135	NR	HUO85128.1	2651171	g17277	i0	28.9	1.89637305699482	90	50	63.7	3	77	322	133	216	HUO85128.1 alpha/beta hydrolase-fold protein [Thermoanaerobaculia bacterium]	diamond	732	45.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
28204411	28204411	PRJNA1093008_S_NODE_58466_length_280_cov_2.748792_g58139_i0	PRJNA1093008	58466	280	2.748792	7.6966176	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	43.5	0.0319	NR	HEV3058303.1	2910147	g58139	i0	35.7	0.6	56	36	60	0	7	174	415	470	HEV3058303.1 ABC transporter permease [Vicinamibacterales bacterium]	diamond	168	43.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
29814790	29814790	PRJNA1093008_S_NODE_49671_length_294_cov_4.366516_g49344_i0	PRJNA1093008	49671	294	4.366516	12.83755704	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42	0.0298	NR	PYT11274.1	1978231	g49344	i0	38.1	0.642857142857143	63	39	64.3	0	230	42	21	83	PYT11274.1 MAG: hypothetical protein DMG59_26855, partial [Acidobacteriota bacterium]	diamond	189	42	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30289142	30289142	PRJNA1093008_S_NODE_74052_length_259_cov_2.962366_g73725_i0	PRJNA1093008	74052	259	2.962366	7.67252794	Terriglobia bacterium	2081523	Bacteria	Bacteria	43.5	0.021	NR	MBZ5650150.1	2081523	g73725	i0	43.5	0.718146718146718	62	29	71.8	1	32	217	137	192	MBZ5650150.1 hypothetical protein [Terriglobia bacterium]	diamond	186	43.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
31078804	31078804	PRJNA1093008_S_NODE_58935_length_280_cov_1.115942_g58608_i0	PRJNA1093008	58935	280	1.115942	3.1246376	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	111	9.32e-28	NR	RMG00051.1	1978231	g58608	i0	87.5	0.685714285714286	64	8	68.6	0	231	40	191	254	RMG00051.1 MAG: enoyl-ACP reductase [Acidobacteriota bacterium]	diamond	192	111	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31363335	31363335	PRJNA1093008_S_NODE_60056_length_278_cov_1.590244_g59729_i0	PRJNA1093008	60056	278	1.590244	4.42087832	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	43.9	0.0224	NR	HTX36711.1	2212468	g59729	i0	36.1	0.776978417266187	72	42	77.7	1	221	6	224	291	HTX36711.1 SBBP repeat-containing protein [Bryobacteraceae bacterium]	diamond	216	43.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31512863	31512863	PRJNA1093008_S_NODE_52916_length_289_cov_1.425926_g52589_i0	PRJNA1093008	52916	289	1.425926	4.12092614	Bacteria	2	Bacteria	Bacteria	44.7	0.0131	NR	PYV98261.1	1978231	g52589	i0	31.3	1.73356401384083	96	52	85.1	2	278	33	376	471	PYV98261.1 MAG: NADH-quinone oxidoreductase subunit L, partial [Acidobacteriota bacterium]	diamond	501	44.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32344110	32344110	PRJNA1093008_S_NODE_31639_length_333_cov_2.784615_g31312_i0	PRJNA1093008	31639	333	2.784615	9.27276795	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	149	5.329999999999999e-43	NR	HEY6361238.1	2910147	g31312	i0	76.4	1.98198198198198	110	26	99.1	0	2	331	84	193	HEY6361238.1 sigma-70 family RNA polymerase sigma factor [Vicinamibacterales bacterium]	diamond	660	149	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales 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);;