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

5 rows where bioproject = "PRJNA380416", 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
27359652	27359652	PRJNA380416_P_NODE_12143_length_165_cov_0.879310_g11996_i0	PRJNA380416	12143	165	0.87931	1.4508615	Myxococcus	32	Bacteria	Bacteria	41.6	0.0326	NR	WP_141643431.1	32	g11996	i0	48.6	1.27272727272727	35	18	63.6	0	142	38	100	134	WP_141643431.1 MULTISPECIES: LysR family transcriptional regulator [Myxococcus]	diamond	210	41.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus
27896171	27896171	PRJNA380416_P_NODE_9025_length_190_cov_0.687943_g8878_i0	PRJNA380416	9025	190	0.687943	1.3070917	Sorangium cellulosum	56	Bacteria	Bacteria	41.6	0.0479	NR	WP_020464987.1	56	g8878	i0	44.3	0.963157894736842	61	29	90	2	186	16	182	241	WP_020464987.1 hypothetical protein [Sorangium cellulosum]	diamond	183	41.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
29222568	29222568	PRJNA380416_P_NODE_11409_length_167_cov_0.864407_g11262_i0	PRJNA380416	11409	167	0.864407	1.44355969	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	53.1	2.81e-6	NR	MCB9729930.1	2026735	g11262	i0	50.9	1.88622754491018	53	26	95.2	0	1	159	526	578	MCB9729930.1 carbon starvation protein A [Deltaproteobacteria bacterium]	diamond	315	53.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29758992	29758992	PRJNA380416_P_NODE_4951_length_262_cov_1.079812_g4804_i0	PRJNA380416	4951	262	1.079812	2.82910744	Polyangia bacterium	3058050	Bacteria	Bacteria	44.3	0.0125	NR	HJZ88007.1	3058050	g4804	i0	48	0.572519083969466	50	25	56.1	1	2	148	5	54	HJZ88007.1 zinc metalloprotease HtpX [Polyangia bacterium]	diamond	150	44.3	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
32698569	32698569	PRJNA380416_P_NODE_10280_length_177_cov_0.828125_g10133_i0	PRJNA380416	10280	177	0.828125	1.46578125	Myxococcota bacterium	2818507	Bacteria	Bacteria	41.6	0.0366	NR	MEM6955040.1	2818507	g10133	i0	43.1	1.96610169491525	58	28	91.5	2	9	170	6	62	MEM6955040.1 UMP kinase [Myxococcota bacterium]	diamond	348	41.6	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota 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);;