metadata: contig_metadata: 7 rows where bioproject = "PRJNA870096", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA870096", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

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
27023530	27023530	PRJNA870096_S_NODE_68722_length_211_cov_1.970238_g67058_i0	PRJNA870096	68722	211	1.970238	4.15720218	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	46.6	0.00108	NR	MBS1824405.1	1978231	g67058	i0	36.8	0.81042654028436	57	34	78.2	1	186	22	396	452	MBS1824405.1 rhamnogalacturonan lyase [Acidobacteriota bacterium]	diamond	171	46.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28065875	28065875	PRJNA870096_S_NODE_45545_length_262_cov_1.657534_g43881_i0	PRJNA870096	45545	262	1.657534	4.34273908	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	43.9	0.0167	NR	HEY4084935.1	2212468	g43881	i0	44.2	0.595419847328244	52	27	59.5	2	47	202	84	133	HEY4084935.1 sulfotransferase [Bryobacteraceae bacterium]	diamond	156	43.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
28357984	28357984	PRJNA870096_S_NODE_58226_length_230_cov_1.540107_g56562_i0	PRJNA870096	58226	230	1.540107	3.5422461	Candidatus Sulfotelmatobacter	2136116	Bacteria	Bacteria	58.2	1.05e-7	NR	MBL8186354.1	1978231	g56562	i0	44.3	4.13478260869565	61	34	79.6	0	27	209	269	329	MBL8186354.1 cyanophycinase [Acidobacteriota bacterium]	diamond	951	58.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29747113	29747113	PRJNA870096_S_NODE_44230_length_266_cov_1.721973_g42566_i0	PRJNA870096	44230	266	1.721973	4.58044818	Bacteria	2	Bacteria	Bacteria	106	7.5e-28	NR	MCB1055700.1	1978231	g42566	i0	55.8	7.78195488721805	77	34	86.8	0	239	9	6	82	MCB1055700.1 M13 family peptidase [Acidobacteriota bacterium]	diamond	2070	106	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31825029	31825029	PRJNA870096_S_NODE_143597_length_151_cov_0.888889_g141933_i0	PRJNA870096	143597	151	0.888889	1.34222239	Acidicapsa ligni	542300	Bacteria	Bacteria	75.5	3.03e-14	NR	WP_263355721.1	542300	g141933	i0	62	2.90066225165563	50	19	99.3	0	150	1	762	811	WP_263355721.1 formylglycine-generating enzyme family protein [Acidicapsa ligni]	diamond	438	75.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidicapsa	Acidicapsa ligni
31951707	31951707	PRJNA870096_S_NODE_99297_length_177_cov_1.604478_g97633_i0	PRJNA870096	99297	177	1.604478	2.83992606	Granulicella mallensis	940614	Bacteria	Bacteria	63.5	2.83e-10	NR	WP_184258112.1	940614	g97633	i0	58.6	2.91525423728814	58	22	98.3	1	174	1	147	202	WP_184258112.1 O-methyltransferase [Granulicella mallensis]	diamond	516	63.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
32173456	32173456	PRJNA870096_S_NODE_36378_length_295_cov_2.626984_g34714_i0	PRJNA870096	36378	295	2.626984	7.7496028	Terriglobales bacterium	2282142	Bacteria	Bacteria	48.9	4.43e-4	NR	MFL6300465.1	2282142	g34714	i0	42.4	2.7864406779661	66	36	67.1	1	293	96	173	236	MFL6300465.1 TonB family protein [Terriglobales bacterium]	diamond	822	48.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales 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);;