metadata: contig_metadata: 12 rows where bioproject = "PRJNA591000" and tax

12 rows where bioproject = "PRJNA591000" 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
26794896	26794896	PRJNA591000_P_NODE_13421_length_401_cov_30.588710_g11829_i0	PRJNA591000	13421	401	30.58871	122.6607271	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	145	2.2199999999999996e-37	NR	MEO5926752.1	2212468	g11829	i0	92	0.561097256857855	75	6	56.1	0	227	3	170	244	MEO5926752.1 cyclic nucleotide-binding domain-containing protein [Bryobacteraceae bacterium]	diamond	225	145	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
26794899	26794899	PRJNA591000_P_NODE_7241_length_520_cov_1.810591_g5796_i0	PRJNA591000	7241	520	1.810591	9.4150732	Candidatus Sulfotelmatobacter sp.	2771375	Bacteria	Bacteria	69.3	9.28e-11	NR	HYB75278.1	2771375	g5796	i0	52.7	0.317307692307692	55	26	31.7	0	75	239	131	185	HYB75278.1 hypothetical protein [Candidatus Sulfotelmatobacter sp.]	diamond	165	69.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Sulfotelmatobacter	Candidatus Sulfotelmatobacter sp.
27269292	27269292	PRJNA591000_P_NODE_9343_length_457_cov_4.988318_g7789_i0	PRJNA591000	9343	457	4.988318	22.79661326	Bryobacterales bacterium	2026791	Bacteria	Bacteria	243	2.67e-75	NR	MBL8241503.1	2026791	g7789	i0	78.5	0.978118161925602	149	21	90.6	1	19	432	269	417	MBL8241503.1 alpha-L-fucosidase [Bryobacterales bacterium]	diamond	447	243	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
27869211	27869211	PRJNA591000_P_NODE_10725_length_434_cov_1.175309_g9150_i0	PRJNA591000	10725	434	1.175309	5.10084106	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	45.4	0.0316	NR	HPS77461.1	2699758	g9150	i0	50	0.78110599078341	60	22	35.9	1	174	19	705	764	HPS77461.1 tail fiber domain-containing protein [Thermoanaerobaculaceae bacterium]	diamond	339	45.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
29006461	29006461	PRJNA591000_P_NODE_728_length_1248_cov_3.766202_g498_i0	PRJNA591000	728	1248	3.766202	47.00220096	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	63.2	5.04e-7	NR	MEN6607258.1	2212468	g498	i0	27.6	0.348557692307692	145	89	34.1	4	614	1039	20	151	MEN6607258.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	435	63.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
29826841	29826841	PRJNA591000_P_NODE_7451_length_511_cov_5.348548_g5983_i0	PRJNA591000	7451	511	5.348548	27.33108028	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	52	1.88e-4	NR	RLE28255.1	1978231	g5983	i0	26.3	0.939334637964775	160	114	91.6	1	496	29	16	175	RLE28255.1 MAG: hypothetical protein DRJ65_00060 [Acidobacteriota bacterium]	diamond	480	52	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30553479	30553479	PRJNA591000_P_NODE_1333_length_1036_cov_6.843098_g942_i0	PRJNA591000	1333	1036	6.843098	70.89449528	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	159	1.2399999999999997e-42	NR	MFN7980398.1	2910147	g942	i0	55.7	0.405405405405405	140	61	40.3	1	550	134	120	259	MFN7980398.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	420	159	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31502000	31502000	PRJNA591000_P_NODE_7936_length_494_cov_2.868817_g6431_i0	PRJNA591000	7936	494	2.868817	14.17195598	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	147	1.14e-38	NR	PYV68727.1	1978231	g6431	i0	48.7	0.910931174089069	150	73	89.3	4	478	38	288	436	PYV68727.1 MAG: hypothetical protein DMG97_23955 [Acidobacteriota bacterium]	diamond	450	147	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32039619	32039619	PRJNA591000_P_NODE_9418_length_456_cov_1.266979_g7864_i0	PRJNA591000	9418	456	1.266979	5.77742424	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	70.1	3.23e-11	NR	HYU99889.1	2283092	g7864	i0	54.4	0.375	57	22	35.5	2	435	274	164	219	HYU99889.1 glycosyltransferase family A protein [Pyrinomonadaceae bacterium]	diamond	171	70.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32653497	32653497	PRJNA591000_P_NODE_15380_length_353_cov_4.746914_g13775_i0	PRJNA591000	15380	353	4.746914	16.75660642	Pseudomonadati	3379134	Bacteria	Bacteria	112	8.21e-29	NR	MCC7126433.1	1978231	g13775	i0	50	3.61189801699717	110	47	90.1	3	21	338	7	112	MCC7126433.1 class I SAM-dependent methyltransferase [Acidobacteriota bacterium]	diamond	1275	112	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32671778	32671778	PRJNA591000_P_NODE_9660_length_451_cov_2.744076_g8102_i0	PRJNA591000	9660	451	2.744076	12.37578276	Candidatus Acidiferrum panamense	2741543	Bacteria	Bacteria	61.6	1.31e-8	NR	MBA0085656.1	2741543	g8102	i0	63.5	0.34589800443459	52	19	34.6	0	451	296	8	59	MBA0085656.1 hypothetical protein [Candidatus Acidiferrum panamense]	diamond	156	61.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum panamense
32735017	32735017	PRJNA591000_P_NODE_8860_length_468_cov_1.325740_g7323_i0	PRJNA591000	8860	468	1.32574	6.2044632	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	53.1	8.19e-5	NR	HTR37090.1	2212468	g7323	i0	59.5	0.269230769230769	42	14	26.9	1	326	451	178	216	HTR37090.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	126	53.1	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);;