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

5 rows where bioproject = "PRJNA554794", 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
27078246	27078246	PRJNA554794_P_NODE_20202_length_198_cov_1.093960_g16273_i0	PRJNA554794	20202	198	1.09396	2.1660408	Myxococcales bacterium	2026763	Bacteria	Bacteria	56.6	2.74e-7	NR	NLN61331.1	2026763	g16273	i0	49	1.59090909090909	51	26	77.3	0	186	34	496	546	NLN61331.1 DUF3597 domain-containing protein [Myxococcales bacterium]	diamond	315	56.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27236244	27236244	PRJNA554794_P_NODE_24303_length_162_cov_0.893805_g20374_i0	PRJNA554794	24303	162	0.893805	1.4479641	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.5	0.00664	NR	MBN2496174.1	2026735	g20374	i0	42.9	0.907407407407407	49	22	90.7	3	9	155	917	959	MBN2496174.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	147	43.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27741954	27741954	PRJNA554794_P_NODE_23624_length_164_cov_0.878261_g19695_i0	PRJNA554794	23624	164	0.878261	1.44034804	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	68.9	8.67e-13	NR	HEY4175856.1	2212474	g19695	i0	63	1.66463414634146	46	17	84.1	0	19	156	6	51	HEY4175856.1 PPC domain-containing protein [Kofleriaceae bacterium]	diamond	273	68.9	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
29572771	29572771	PRJNA554794_P_NODE_20790_length_189_cov_0.792857_g16861_i0	PRJNA554794	20790	189	0.792857	1.49849973	Myxococcales bacterium	2026763	Bacteria	Bacteria	52.4	7.14e-6	NR	MCA9538182.1	2026763	g16861	i0	50	2.42857142857143	52	26	82.5	0	160	5	419	470	MCA9538182.1 hypothetical protein [Myxococcales bacterium]	diamond	459	52.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32052701	32052701	PRJNA554794_P_NODE_21358_length_181_cov_1.598485_g17429_i0	PRJNA554794	21358	181	1.598485	2.89325785	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	111	1.2399999999999999e-28	NR	WP_020733286.1	56	g17429	i0	86.7	13.8729281767956	60	8	99.4	0	180	1	102	161	WP_020733286.1 glutathione peroxidase [Sorangium cellulosum]	diamond	2511	112	0.991071428571429	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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);;