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

5 rows where bioproject = "PRJNA309466", 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
11855461	11855461	PRJNA309466_P_NODE_17510_length_163_cov_2.736842_g17453_i0	PRJNA309466	17510	163	2.736842	4.46105246	Labilithrix luteola	1391654	Bacteria	Bacteria	219	1.2699999999999999e-52	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g17453	i0	90.854	10.8343558282209	164	13	100	2	1	163	3942050	3942212	Labilithrix luteola strain DSM 27648, complete genome	blastn	1766	219	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
28102389	28102389	PRJNA309466_P_NODE_7825_length_217_cov_5.732143_g7768_i0	PRJNA309466	7825	217	5.732143	12.43875031	Bacteria	2	Bacteria	Bacteria	60.5	1.5e-8	NR	RPI55997.1	2026735	g7768	i0	38.8	4.65898617511521	67	39	92.6	1	201	1	288	352	RPI55997.1 MAG: hypothetical protein EHM49_01210 [Deltaproteobacteria bacterium]	diamond	1011	60.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28765482	28765482	PRJNA309466_P_NODE_18247_length_162_cov_0.920354_g18190_i0	PRJNA309466	18247	162	0.920354	1.49097348	Pseudomonadati	3379134	Bacteria	Bacteria	43.9	0.00477	NR	NQZ99276.1	2026763	g18190	i0	66.7	2.88888888888889	30	10	55.6	0	160	71	239	268	NQZ99276.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Myxococcales bacterium]	diamond	468	44.3	0.99097065462754	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30579516	30579516	PRJNA309466_P_NODE_17513_length_163_cov_2.675439_g17456_i0	PRJNA309466	17513	163	2.675439	4.36096557	Myxococcota bacterium	2818507	Bacteria	Bacteria	90.5	1.6e-19	NR	HQE74717.1	2818507	g17456	i0	77.4	3.90184049079755	53	12	97.5	0	2	160	133	185	HQE74717.1 DEAD/DEAH box helicase [Myxococcota bacterium]	diamond	636	90.5	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31370078	31370078	PRJNA309466_P_NODE_11616_length_188_cov_14.956835_g11559_i0	PRJNA309466	11616	188	14.956835	28.1188498	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	43.9	0.0071	NR	HEX6272860.1	2268199	g11559	i0	35.8	0.845744680851064	53	31	79.8	1	11	160	212	264	HEX6272860.1 hypothetical protein [Polyangiaceae bacterium]	diamond	159	43.9	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);;