metadata: contig_metadata: 8 rows where bioproject = "PRJEB82358" and tax

8 rows where bioproject = "PRJEB82358" 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
17992332	17992332	PRJEB82358_P_NODE_17495_length_247_cov_1.379310_g17484_i0	PRJEB82358	17495	247	1.37931	3.4068957	uncultured Thermoanaerobaculia bacterium	3036248	Bacteria	Bacteria	174	4.57e-39	NTclustered	gi\|2518540615\|emb\|OX638294.1\|	3036248	g17484	i0	86.25	40.7692307692308	160	22	65	0	87	246	667249	667408	MAG: uncultured Thermoanaerobaculia bacterium isolate 42478a12-5572-4d71-959b-92ffd854a98d genome assembly, chromosome: 1	blastn	10070	174	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				uncultured Thermoanaerobaculia bacterium
20541782	20541782	PRJEB82358_P_NODE_20157_length_232_cov_2.446541_g20146_i0	PRJEB82358	20157	232	2.446541	5.67597512	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	300	6.71e-77	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g20146	i0	93.137	55.2327586206897	204	14	88	0	24	227	3557229	3557026	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	12814	300	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
26741682	26741682	PRJEB82358_P_NODE_15241_length_261_cov_3.563830_g15230_i0	PRJEB82358	15241	261	3.56383	9.3015963	Pseudomonadati	3379134	Bacteria	Bacteria	98.6	5.779999999999999e-23	NR	MDQ2945430.1	1978231	g15230	i0	55.2	1.94252873563218	87	39	100	0	1	261	5	91	MDQ2945430.1 IS21-like element helper ATPase IstB [Acidobacteriota bacterium]	diamond	507	98.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26900507	26900507	PRJEB82358_P_NODE_23621_length_199_cov_7.396825_g23610_i0	PRJEB82358	23621	199	7.396825	14.71968175	Pseudomonadati	3379134	Bacteria	Bacteria	102	1.8299999999999994e-23	NR	MCX6597616.1	1978231	g23610	i0	84.2	6.96482412060301	57	9	85.9	0	3	173	254	310	MCX6597616.1 glycosyltransferase [Acidobacteriota bacterium]	diamond	1386	102	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27571419	27571419	PRJEB82358_P_NODE_17944_length_245_cov_1.494186_g17933_i0	PRJEB82358	17944	245	1.494186	3.6607557	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	62	6.24e-9	NR	HEV8039869.1	2212468	g17933	i0	47.5	0.979591836734694	80	36	95.5	4	2	235	813	888	HEV8039869.1 trypsin-like peptidase domain-containing protein [Bryobacteraceae bacterium]	diamond	240	62	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
28739700	28739700	PRJEB82358_P_NODE_13087_length_279_cov_1.364078_g13076_i0	PRJEB82358	13087	279	1.364078	3.80577762	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	63.5	1.76e-9	NR	HEX7330309.1	2283092	g13076	i0	44.3	0.752688172043011	70	39	75.3	0	236	27	119	188	HEX7330309.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	210	63.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30002872	30002872	PRJEB82358_P_NODE_13371_length_276_cov_2.921182_g13360_i0	PRJEB82358	13371	276	2.921182	8.06246232	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	57.4	2e-8	NR	HXN74906.1	3069120	g13360	i0	51.9	0.58695652173913	54	26	58.7	0	207	46	25	78	HXN74906.1 hypothetical protein [Candidatus Acidiferrum sp.]	diamond	162	57.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
31772601	31772601	PRJEB82358_P_NODE_18677_length_241_cov_6.178571_g18666_i0	PRJEB82358	18677	241	6.178571	14.89035611	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	91.3	7.45e-21	NR	PYT21880.1	1978231	g18666	i0	75	0.697095435684647	56	14	69.7	0	2	169	131	186	PYT21880.1 MAG: hypothetical protein DMG57_37270 [Acidobacteriota bacterium]	diamond	168	91.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota 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);;