metadata: contig_metadata: 6 rows where bioproject = "PRJNA1103784" and tax

6 rows where bioproject = "PRJNA1103784" 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
27216755	27216755	PRJNA1103784_P_NODE_4602_length_270_cov_1.345178_g4547_i0	PRJNA1103784	4602	270	1.345178	3.6319806	Bacteria	2	Bacteria	Bacteria	52	7.77e-6	NR	MCU1263907.1	1978231	g4547	i0	46.7	3.43333333333333	45	24	50	0	18	152	93	137	MCU1263907.1 thiol-disulfide oxidoreductase [Acidobacteriota bacterium]	diamond	927	52	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30415581	30415581	PRJNA1103784_P_NODE_1633_length_405_cov_1.186747_g1578_i0	PRJNA1103784	1633	405	1.186747	4.80632535	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	132	4.63e-37	NR	MDQ7008653.1	1978231	g1578	i0	78.9	0.666666666666667	90	19	66.7	0	383	114	22	111	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	270	132	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30636198	30636198	PRJNA1103784_P_NODE_2773_length_325_cov_1.253968_g2718_i0	PRJNA1103784	2773	325	1.253968	4.075396	Holophaga sp.	2582906	Bacteria	Bacteria	49.7	3.17e-4	NR	HLO66042.1	2582906	g2718	i0	34.6	0.987692307692308	107	58	92.3	3	18	317	13	114	HLO66042.1 Vps62-related protein [Holophaga sp.]	diamond	321	49.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	Holophaga sp.
30699486	30699486	PRJNA1103784_P_NODE_1934_length_376_cov_1.267327_g1879_i0	PRJNA1103784	1934	376	1.267327	4.76514952	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	80.5	5.01e-15	NR	MDR3737318.1	2052142	g1879	i0	41.9	0.98936170212766	124	68	96.5	3	2	364	186	308	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	372	80.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
32461900	32461900	PRJNA1103784_P_NODE_6919_length_245_cov_0.895349_g6864_i0	PRJNA1103784	6919	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	74.3	2.94e-13	NR	MFL6261088.1	2651171	g6864	i0	52.2	3.99183673469388	69	33	84.5	0	214	8	2171	2239	MFL6261088.1 amino acid adenylation domain-containing protein [Thermoanaerobaculia bacterium]	diamond	978	74.7	0.994645247657296	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
32691283	32691283	PRJNA1103784_P_NODE_7620_length_242_cov_0.911243_g7565_i0	PRJNA1103784	7620	242	0.911243	2.20520806	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	95.5	1.21e-21	NR	HEY3129132.1	1978231	g7565	i0	58.8	5.05785123966942	68	28	84.3	0	228	25	211	278	HEY3129132.1 urate oxidase [Acidobacteriota bacterium]	diamond	1224	95.5	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);;