metadata: contig_metadata: 12 rows where bioproject = "PRJDB3785", tax_phylum = "Acidobacteriota" and tax

12 rows where bioproject = "PRJDB3785", tax_phylum = "Acidobacteriota" 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
6084342	6084342	PRJDB3785_S_NODE_24925_length_164_cov_1.330435_g24772_i0	PRJDB3785	24925	164	1.330435	2.1819134	Pseudomonadati	3379134	Bacteria	Bacteria	94.7	5.07e-21	NR	WP_158911805.1	204434	g24772	i0	73.6	12.7317073170732	53	14	97	0	2	160	345	397	WP_158911805.1 MULTISPECIES: decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Acidobacteriaceae]	diamond	2088	95.5	0.991623036649215	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae
26810929	26810929	PRJDB3785_S_NODE_16961_length_191_cov_0.838028_g16808_i0	PRJDB3785	16961	191	0.838028	1.60063348	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	46.6	8.19e-4	NR	MEP6961832.1	1978231	g16808	i0	39	0.926701570680628	59	33	88	2	188	21	540	598	MEP6961832.1 NHL repeat-containing protein [Acidobacteriota bacterium]	diamond	177	46.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27121046	27121046	PRJDB3785_S_NODE_26822_length_161_cov_2.250000_g26669_i0	PRJDB3785	26822	161	2.25	3.6225	Bacteria	2	Bacteria	Bacteria	70.9	7.44e-13	NR	MBI1358074.1	1978231	g26669	i0	58.5	4.93788819875776	53	18	98.8	1	159	1	97	145	MBI1358074.1 hypothetical protein [Acidobacteriota bacterium]	diamond	795	70.9	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27626992	27626992	PRJDB3785_S_NODE_10484_length_234_cov_1.102703_g10331_i0	PRJDB3785	10484	234	1.102703	2.58032502	Acidobacteriota	57723	Bacteria	Bacteria	43.9	0.00989	NR	MCG8457082.1	2478486	g10331	i0	40.4	2.19230769230769	57	25	73.1	2	30	200	76	123	MCG8457082.1 cyclase family protein [Holophagales bacterium]	diamond	513	43.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
27658594	27658594	PRJDB3785_S_NODE_7044_length_283_cov_1.431624_g6891_i0	PRJDB3785	7044	283	1.431624	4.05149592	Acidobacteriota	57723	Bacteria	Bacteria	124	1.6199999999999998e-32	NR	HUH63403.1	1964191	g6891	i0	75.6	14.1413427561837	82	20	86.9	0	3	248	178	259	HUH63403.1 aldolase/citrate lyase family protein [Terracidiphilus sp.]	diamond	4002	124	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
28043216	28043216	PRJDB3785_S_NODE_8025_length_265_cov_1.782407_g7872_i0	PRJDB3785	8025	265	1.782407	4.72337855	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	65.1	3.38e-10	NR	MEK7723144.1	1978231	g7872	i0	35.7	1.90188679245283	84	54	95.1	0	265	14	89	172	MEK7723144.1 CAP domain-containing protein [Acidobacteriota bacterium]	diamond	504	65.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28138135	28138135	PRJDB3785_S_NODE_18225_length_185_cov_0.948529_g18072_i0	PRJDB3785	18225	185	0.948529	1.75477865	Terracidiphilus sp.	1964191	Bacteria	Bacteria	43.5	0.00922	NR	HEY1986039.1	1964191	g18072	i0	45	0.648648648648649	40	22	64.9	0	35	154	137	176	HEY1986039.1 pitrilysin family protein [Terracidiphilus sp.]	diamond	120	43.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
28485268	28485268	PRJDB3785_S_NODE_25987_length_163_cov_0.894737_g25834_i0	PRJDB3785	25987	163	0.894737	1.45842131	Candidatus Angelobacter sp.	2976921	Bacteria	Bacteria	41.2	0.043	NR	HEV3039097.1	2976921	g25834	i0	55.3	0.699386503067485	38	16	68.1	1	161	51	71	108	HEV3039097.1 MupA/Atu3671 family FMN-dependent luciferase-like monooxygenase [Candidatus Angelobacter sp.]	diamond	114	41.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia			Candidatus Angelobacter	Candidatus Angelobacter sp.
29584118	29584118	PRJDB3785_S_NODE_14250_length_205_cov_1.224359_g14097_i0	PRJDB3785	14250	205	1.224359	2.50993595	Holophagaceae	574976	Bacteria	Bacteria	78.6	4.55e-16	NR	WP_286355066.1	2927975	g14097	i0	58.2	7.84390243902439	67	26	98	1	4	204	3	67	WP_286355066.1 peroxiredoxin [Geothrix oryzae]	diamond	1608	79	0.994936708860759	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix oryzae
30001015	30001015	PRJDB3785_S_NODE_24011_length_166_cov_0.871795_g23858_i0	PRJDB3785	24011	166	0.871795	1.4471797	Terriglobales bacterium	2282142	Bacteria	Bacteria	75.9	2.77e-14	NR	HLO07140.1	2282142	g23858	i0	63.6	0.993975903614458	55	20	99.4	0	166	2	173	227	HLO07140.1 Ig-like domain repeat protein [Terriglobales bacterium]	diamond	165	75.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
30632605	30632605	PRJDB3785_S_NODE_893_length_856_cov_3.270136_g802_i0	PRJDB3785	893	856	3.270136	27.99236416	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	59.3	5.04e-6	NR	MBS1873370.1	1978231	g802	i0	34.4	0.438084112149533	125	60	42.8	5	420	55	112	217	MBS1873370.1 hypothetical protein [Acidobacteriota bacterium]	diamond	375	59.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31359784	31359784	PRJDB3785_S_NODE_23096_length_167_cov_1.271186_g22943_i0	PRJDB3785	23096	167	1.271186	2.12288062	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	41.2	0.0475	NR	MFA6956151.1	2651171	g22943	i0	43.6	0.70059880239521	39	22	70.1	0	166	50	334	372	MFA6956151.1 IPT/TIG domain-containing protein [Thermoanaerobaculia bacterium]	diamond	117	41.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia 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);;