metadata: contig_metadata: 5 rows where bioproject = "PRJNA484127", tax_phylum = "Myxococcota" and tax

5 rows where bioproject = "PRJNA484127", tax_phylum = "Myxococcota" 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
29350024	29350024	PRJNA484127_P_NODE_32269_length_250_cov_0.881356_g32120_i0	PRJNA484127	32269	250	0.881356	2.20339	Pyxidicoccus xibeiensis	2906759	Bacteria	Bacteria	60.5	2.11e-8	NR	WP_253978926.1	2906759	g32120	i0	44.7	0.912	76	41	91.2	1	235	8	112	186	WP_253978926.1 DUF1986 domain-containing protein [Pyxidicoccus xibeiensis]	diamond	228	60.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus xibeiensis
29507727	29507727	PRJNA484127_P_NODE_16230_length_318_cov_2.546939_g16081_i0	PRJNA484127	16230	318	2.546939	8.09926602	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	114	3.37e-29	NR	HUQ02728.1	2212474	g16081	i0	47.8	2.12264150943396	113	49	97.2	3	6	314	79	191	HUQ02728.1 CAP domain-containing protein [Kofleriaceae bacterium]	diamond	675	114	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
30170974	30170974	PRJNA484127_P_NODE_38112_length_243_cov_0.917647_g37963_i0	PRJNA484127	38112	243	0.917647	2.22988221	Archangium sp.	1872627	Bacteria	Bacteria	47.4	9.12e-4	NR	MDP1827721.1	1872627	g37963	i0	42.2	1.11111111111111	90	43	100	2	243	1	588	677	MDP1827721.1 choice-of-anchor D domain-containing protein [Archangium sp.]	diamond	270	47.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
32636729	32636729	PRJNA484127_P_NODE_12800_length_348_cov_1.934545_g12651_i0	PRJNA484127	12800	348	1.934545	6.7322166	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	47.8	0.00198	NR	MBK9266403.1	2268199	g12651	i0	38.1	0.543103448275862	63	36	53.4	2	320	135	106	166	MBK9266403.1 hypothetical protein [Polyangiaceae bacterium]	diamond	189	47.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32731547	32731547	PRJNA484127_P_NODE_32700_length_249_cov_0.886364_g32551_i0	PRJNA484127	32700	249	0.886364	2.20704636	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	107	6.94e-26	NR	HEY1958641.1	2268199	g32551	i0	69.4	1.75903614457831	72	22	86.7	0	247	32	271	342	HEY1958641.1 potassium channel protein [Polyangiaceae bacterium]	diamond	438	107	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae 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);;