metadata: contig_metadata: 6 rows where bioproject = "PRJNA1068513", tax_phylum = "Acidobacteriota" and tax

6 rows where bioproject = "PRJNA1068513", 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_species
19307513	19307513	PRJNA1068513_S_NODE_856_length_719_cov_18.866873_g818_i0	PRJNA1068513	856	719	18.866873	135.65281687	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	147	1.3799999999999999e-38	NR	MDR3737318.1	2052142	g818	i0	44.4	0.826147426981919	198	103	81.4	4	718	134	115	308	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	594	147	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacteriaceae bacterium
27185181	27185181	PRJNA1068513_S_NODE_9402_length_293_cov_3.045455_g9356_i0	PRJNA1068513	9402	293	3.045455	8.92318315	Pseudomonadati	3379134	Bacteria	Bacteria	118	4.33e-30	NR	TDI46102.1	1978231	g9356	i0	86.4	12.901023890785	59	8	60.4	0	287	111	225	283	TDI46102.1 MAG: 3-hydroxybutyryl-CoA dehydrogenase [Acidobacteriota bacterium]	diamond	3780	118	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
29372572	29372572	PRJNA1068513_S_NODE_1389_length_630_cov_4.039497_g1349_i0	PRJNA1068513	1389	630	4.039497	25.4488311	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	89.4	1.17e-16	NR	MFN7919619.1	2212468	g1349	i0	30.6	1.64761904761905	183	105	77.6	4	621	133	470	650	MFN7919619.1 RICIN domain-containing protein [Bryobacteraceae bacterium]	diamond	1038	89.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
29561852	29561852	PRJNA1068513_S_NODE_4970_length_406_cov_9.891892_g4925_i0	PRJNA1068513	4970	406	9.891892	40.16108152	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	87.8	3.35e-17	NR	MBX3265733.1	1978231	g4925	i0	38.7	0.820197044334975	111	64	79.8	3	2	325	122	231	MBX3265733.1 hypothetical protein [Acidobacteriota bacterium]	diamond	333	87.8	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
29584839	29584839	PRJNA1068513_S_NODE_9370_length_294_cov_2.085973_g9324_i0	PRJNA1068513	9370	294	2.085973	6.13276062	Bacteria	2	Bacteria	Bacteria	46.2	0.00431	NR	MBM3740319.1	1978231	g9324	i0	40.3	1.36734693877551	67	35	68.4	2	270	70	801	862	MBM3740319.1 hypothetical protein [Acidobacteriota bacterium]	diamond	402	46.2	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
32785333	32785333	PRJNA1068513_S_NODE_2700_length_516_cov_7.232506_g2656_i0	PRJNA1068513	2700	516	7.232506	37.31973096	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	52.4	1.98e-4	NR	MBS1873370.1	1978231	g2656	i0	32.8	1.98837209302326	122	60	69.2	5	516	160	115	217	MBS1873370.1 hypothetical protein [Acidobacteriota bacterium]	diamond	1026	52.4	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);;