metadata: contig_metadata: 7 rows where bioproject = "PRJEB56027", tax_phylum = "Myxococcota" and tax

7 rows where bioproject = "PRJEB56027", 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
1396382	1396382	PRJEB56027_P_NODE_101102_length_267_cov_1.587629_g98293_i0	PRJEB56027	101102	267	1.587629	4.23896943	Myxococcales bacterium	2026763	Bacteria	Bacteria	161	1.15e-43	NR	MFT3922441.1	2026763	g98293	i0	90.9	0.98876404494382	88	8	98.9	0	266	3	873	960	MFT3922441.1 CusA/CzcA family heavy metal efflux RND transporter [Myxococcales bacterium]	diamond	264	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
7775372	7775372	PRJEB56027_P_NODE_138567_length_207_cov_4.343284_g135758_i0	PRJEB56027	138567	207	4.343284	8.99059788	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2108340089\|gb\|CP070660.1\|	2026735	g135758	i0	100	0.135265700483092	28	0	14	0	17	44	169888	169915	MAG: Deltaproteobacteria bacterium isolate bin79 chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
17973948	17973948	PRJEB56027_P_NODE_115015_length_251_cov_0.865169_g112206_i0	PRJEB56027	115015	251	0.865169	2.17157419	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	122	3.22e-30	NR	MBC7794110.1	2026735	g112206	i0	79.5	0.99203187250996006	83	17	99.2	0	1	249	429	511	MBC7794110.1 potassium-transporting ATPase subunit KdpA [Deltaproteobacteria bacterium]	diamond	249	122	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27570669	27570669	PRJEB56027_P_NODE_132984_length_241_cov_0.916667_g130175_i0	PRJEB56027	132984	241	0.916667	2.20916747	Archangium sp. Cb G35	1920190	Bacteria	Bacteria	42.7	0.0333	NR	OJT22995.1	1920190	g130175	i0	38.9	1.79253112033195	72	40	89.6	1	9	224	17	84	OJT22995.1 hypothetical protein BO221_19065 [Archangium sp. Cb G35]	diamond	432	42.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp. Cb G35
27570670	27570670	PRJEB56027_P_NODE_74244_length_317_cov_1.118852_g71435_i0	PRJEB56027	74244	317	1.118852	3.54676084	Myxococcota bacterium	2818507	Bacteria	Bacteria	45.4	0.00698	NR	HTO52293.1	2818507	g71435	i0	47.8	0.634069400630915	67	32	62.5	3	288	91	107	171	HTO52293.1 GNAT family N-acetyltransferase [Myxococcota bacterium]	diamond	201	45.4	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31234064	31234064	PRJEB56027_P_NODE_126815_length_244_cov_1.497076_g124006_i0	PRJEB56027	126815	244	1.497076	3.65286544	Polyangia bacterium	3058050	Bacteria	Bacteria	53.9	4.32e-6	NR	HEX7505255.1	3058050	g124006	i0	71.9	0.39344262295082	32	9	39.3	0	2	97	480	511	HEX7505255.1 HEAT repeat domain-containing protein [Polyangia bacterium]	diamond	96	53.9	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
31645276	31645276	PRJEB56027_P_NODE_129397_length_243_cov_0.905882_g126588_i0	PRJEB56027	129397	243	0.905882	2.20129326	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	99	5.41e-22	NR	MBI2609428.1	2026735	g126588	i0	62.8	15.4074074074074	78	29	96.3	0	236	3	284	361	MBI2609428.1 chaperonin GroEL [Deltaproteobacteria bacterium]	diamond	3744	99	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria 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);;