metadata: contig_metadata: 14 rows where bioproject = "PRJNA971676", tax_phylum = "Atribacterota" and tax

14 rows where bioproject = "PRJNA971676", tax_phylum = "Atribacterota" 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
944822	944822	PRJNA971676_P_NODE_8281_length_308_cov_1.251064_g8192_i0	PRJNA971676	8281	308	1.251064	3.85327712	uncultured Atribacterota bacterium	263865	Bacteria	Bacteria	344	4.239999999999999e-90	NTclustered	gi\|306490911\|gb\|GU180083.1\|	263865	g8192	i0	87.708	688	301	29	96	5	13	308	10989	11286	Uncultured candidate division JS1 bacterium clone fosmid vNS2B_16C12 genomic sequence	blastn	211904	344	1	Bacteria	Pseudomonadati	Atribacterota					uncultured Atribacterota bacterium
26804343	26804343	PRJNA971676_P_NODE_15101_length_250_cov_0.870056_g15012_i0	PRJNA971676	15101	250	0.870056	2.17514	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	106	1.21e-25	NR	TET09776.1	2053509	g15012	i0	96.2	0.636	53	2	63.6	0	90	248	1	53	TET09776.1 MAG: ABC transporter ATP-binding protein, partial [Candidatus Atribacteria bacterium]	diamond	159	106	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
27120485	27120485	PRJNA971676_P_NODE_21482_length_243_cov_0.905882_g21393_i0	PRJNA971676	21482	243	0.905882	2.20129326	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	168	1.36e-50	NR	MCK4241892.1	2053509	g21393	i0	100	1.97530864197531	80	0	98.8	0	242	3	93	172	MCK4241892.1 TRAP transporter substrate-binding protein DctP [Candidatus Atribacteria bacterium]	diamond	480	168	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
27380124	27380124	PRJNA971676_P_NODE_13883_length_251_cov_0.865169_g13794_i0	PRJNA971676	13883	251	0.865169	2.17157419	root	1	Root_unresolved	Root_unresolved	111	2.1e-26	NR	HAJ32396.1	2053509	g13794	i0	75.3	3.66932270916335	81	19	96.8	1	243	1	425	504	HAJ32396.1 subtilisin [Candidatus Atribacteria bacterium]	diamond	921	111	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
27531506	27531506	PRJNA971676_P_NODE_20003_length_245_cov_0.895349_g19914_i0	PRJNA971676	20003	245	0.895349	2.19360505	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	156	3.0299999999999997e-45	NR	MCK4308733.1	2053509	g19914	i0	96.3	0.991836734693878	81	3	99.2	0	244	2	81	161	MCK4308733.1 DNA polymerase III subunit beta [Candidatus Atribacteria bacterium]	diamond	243	156	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
28895361	28895361	PRJNA971676_P_NODE_16888_length_248_cov_0.880000_g16799_i0	PRJNA971676	16888	248	0.88	2.1824	Candidatus Sediminicultor	3378346	Bacteria	Bacteria	118	1.2099999999999999e-31	NR	OGD16899.1	1797291	g16799	i0	91.4	2.54032258064516	70	6	84.7	0	39	248	1	70	OGD16899.1 MAG: BioY family transporter [Candidatus Sediminicultor quintus]	diamond	630	118	1	Bacteria	Pseudomonadati	Atribacterota	Candidatus Phoenicimicrobiia	Candidatus Pheonicimicrobiales	Candidatus Phoenicimicrobiaceae	Candidatus Sediminicultor	Candidatus Sediminicultor quintus
29488968	29488968	PRJNA971676_P_NODE_20770_length_244_cov_0.900585_g20681_i0	PRJNA971676	20770	244	0.900585	2.1974274	Candidatus Atribacteria bacterium HGW-Atribacteria-1	2013676	Bacteria	Bacteria	158	7.98e-46	NR	PKP57899.1	2013676	g20681	i0	97.5	0.995901639344262	81	2	99.6	0	2	244	137	217	PKP57899.1 MAG: integrase [Candidatus Atribacteria bacterium HGW-Atribacteria-1]	diamond	243	158	1	Bacteria	Pseudomonadati	Atribacterota					Candidatus Atribacteria bacterium HGW-Atribacteria-1
29646572	29646572	PRJNA971676_P_NODE_15410_length_250_cov_0.870056_g15321_i0	PRJNA971676	15410	250	0.870056	2.17514	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	160	8.129999999999998e-48	NR	HCL90314.1	2053509	g15321	i0	95.1	3.936	82	4	98.4	0	3	248	28	109	HCL90314.1 class II aldolase [Candidatus Atribacteria bacterium]	diamond	984	160	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
30973970	30973970	PRJNA971676_P_NODE_22654_length_242_cov_0.911243_g22565_i0	PRJNA971676	22654	242	0.911243	2.20520806	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	44.3	0.0108	NR	MCK4241733.1	2053509	g22565	i0	40	0.619834710743802	50	25	62	1	150	1	815	859	MCK4241733.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Atribacteria bacterium]	diamond	150	44.3	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
31391190	31391190	PRJNA971676_P_NODE_22496_length_242_cov_0.911243_g22407_i0	PRJNA971676	22496	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	107	1.22e-25	NR	RXG64167.1	2019525	g22407	i0	71.3	1.98347107438017	80	23	99.2	0	242	3	115	194	RXG64167.1 MAG: sugar phosphate isomerase/epimerase [Candidatus Atribacteria bacterium 1244-E10-H5-B2]	diamond	480	108	0.990740740740741	Bacteria	Pseudomonadati	Atribacterota					Candidatus Atribacteria bacterium 1244-E10-H5-B2
31543016	31543016	PRJNA971676_P_NODE_18396_length_246_cov_0.890173_g18307_i0	PRJNA971676	18396	246	0.890173	2.18982558	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	150	5.97e-41	NR	TET09432.1	2053509	g18307	i0	100	5.92682926829268	81	0	98.8	0	245	3	312	392	TET09432.1 MAG: Rne/Rng family ribonuclease, partial [Candidatus Atribacteria bacterium]	diamond	1458	150	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
31732585	31732585	PRJNA971676_P_NODE_8597_length_304_cov_1.000000_g8508_i0	PRJNA971676	8597	304	1	3.04	Candidatus Atribacteria bacterium 1244-E1	2053509	Bacteria	Bacteria	192	2.7e-60	NR	RXG65052.1	2019525	g8508	i0	97	0.986842105263158	100	3	98.7	0	3	302	70	169	RXG65052.1 MAG: LemA family protein [Candidatus Atribacteria bacterium 1244-E10-H5-B2]	diamond	300	192	1	Bacteria	Pseudomonadati	Atribacterota					Candidatus Atribacteria bacterium 1244-E10-H5-B2
32428833	32428833	PRJNA971676_P_NODE_17659_length_247_cov_0.885057_g17570_i0	PRJNA971676	17659	247	0.885057	2.18609079	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	162	3.03e-49	NR	MCK4241009.1	2053509	g17570	i0	92.6	10.821862348178101	81	6	98.4	0	3	245	54	134	MCK4241009.1 sugar phosphate isomerase/epimerase [Candidatus Atribacteria bacterium]	diamond	2673	162	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
32781838	32781838	PRJNA971676_P_NODE_21420_length_243_cov_0.905882_g21331_i0	PRJNA971676	21420	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	149	2.11e-44	NR	HCL90811.1	2053509	g21331	i0	86.3	1.97530864197531	80	11	98.8	0	241	2	6	85	HCL90811.1 hypothetical protein [Candidatus Atribacteria bacterium]	diamond	480	149	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria 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);;