metadata: contig_metadata: 9 rows where bioproject = "PRJNA1148190" and tax

9 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Auribacterota"

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
14321076	14321076	PRJNA1148190_P_NODE_204512_length_373_cov_1.283333_g193342_i0	PRJNA1148190	204512	373	1.283333	4.78683209	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	92	9.51e-19	NR	MEW6534803.1	2093365	g193342	i0	40.9	0.924932975871314	115	68	92.5	0	345	1	1612	1726	MEW6534803.1 zeta toxin family protein [Candidatus Auribacterota bacterium]	diamond	345	92	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
27356257	27356257	PRJNA1148190_P_NODE_674543_length_246_cov_1.780347_g663370_i0	PRJNA1148190	674543	246	1.780347	4.37965362	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	96.3	1.68e-22	NR	MDX9704010.1	2093365	g663370	i0	80.8	2.63414634146341	52	10	63.4	0	157	2	141	192	MDX9704010.1 DNA methyltransferase [Candidatus Auribacterota bacterium]	diamond	648	96.3	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
28618437	28618437	PRJNA1148190_P_NODE_21527_length_1722_cov_1.439660_g13195_i0	PRJNA1148190	21527	1722	1.43966	24.7909452	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	252	3.46e-75	NR	MEA3347053.1	2093365	g13195	i0	39	0.562717770034843	323	191	56.1	5	1215	250	9	326	MEA3347053.1 DnaB-like helicase C-terminal domain-containing protein [Candidatus Auribacterota bacterium]	diamond	969	252	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
28839151	28839151	PRJNA1148190_P_NODE_192528_length_382_cov_2.990291_g181358_i0	PRJNA1148190	192528	382	2.990291	11.42291162	Candidatus Ancaeobacter aquaticus	3039677	Bacteria	Bacteria	97.8	5.319999999999999e-23	NR	MDP8263688.1	3039677	g181358	i0	39.3	1.09947643979058	140	70	98.2	2	1	375	3	142	MDP8263688.1 DUF3862 domain-containing protein [Candidatus Ancaeobacter aquaticus]	diamond	420	97.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota	Candidatus Ancaeobacteria	Candidatus Ancaeobacterales	Candidatus Ancaeobacteraceae	Candidatus Ancaeobacter	Candidatus Ancaeobacter aquaticus
29723320	29723320	PRJNA1148190_P_NODE_344950_length_302_cov_1.681223_g333777_i0	PRJNA1148190	344950	302	1.681223	5.07729346	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	80.9	4.77e-16	NR	MCC6450533.1	2093365	g333777	i0	61.8	2.21523178807947	55	21	54.6	0	1	165	180	234	MCC6450533.1 IS1595 family transposase [Candidatus Auribacterota bacterium]	diamond	669	80.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
29944706	29944706	PRJNA1148190_P_NODE_305991_length_317_cov_1.602459_g294818_i0	PRJNA1148190	305991	317	1.602459	5.07979503	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	78.6	2.4e-14	NR	MCX6353766.1	2093365	g294818	i0	42.6	0.889589905362776	94	53	88	1	2	280	453	546	MCX6353766.1 hypothetical protein [Candidatus Auribacterota bacterium]	diamond	282	78.6	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
32062271	32062271	PRJNA1148190_P_NODE_22858_length_1634_cov_2.716208_g2419_i1	PRJNA1148190	22858	1634	2.716208	44.38283872	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	347	2.95e-111	NR	MDX9704016.1	2093365	g2419	i1	74.8	0.422276621787026	230	54	41.5	1	1	678	173	402	MDX9704016.1 DNA methyltransferase [Candidatus Auribacterota bacterium]	diamond	690	347	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
32189002	32189002	PRJNA1148190_P_NODE_228638_length_356_cov_1.088339_g217468_i0	PRJNA1148190	228638	356	1.088339	3.87448684	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	52.4	5.61e-5	NR	MBN2190413.1	2093365	g217468	i0	34.9	0.918539325842697	109	67	91	3	4	327	335	440	MBN2190413.1 autotransporter outer membrane beta-barrel domain-containing protein [Candidatus Auribacterota bacterium]	diamond	327	52.4	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
32252906	32252906	PRJNA1148190_P_NODE_464658_length_273_cov_2.085000_g453485_i0	PRJNA1148190	464658	273	2.085	5.69205	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	58.9	1.07e-7	NR	MEW6534551.1	2093365	g453485	i0	40.3	0.736263736263736	67	36	73.6	1	213	13	403	465	MEW6534551.1 terminase family protein [Candidatus Auribacterota bacterium]	diamond	201	58.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota 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);;