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

5 rows where bioproject = "PRJNA1139127", 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_species
18136832	18136832	PRJNA1139127_P_NODE_24275_length_371_cov_1.550336_g23784_i0	PRJNA1139127	24275	371	1.550336	5.75174656	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	196	1.08e-58	NR	MEO6602183.1	2268199	g23784	i0	86.3	0.946091644204852	117	16	94.6	0	371	21	66	182	MEO6602183.1 gephyrin-like molybdotransferase Glp [Polyangiaceae bacterium]	diamond	351	196	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangiaceae bacterium
28175651	28175651	PRJNA1139127_P_NODE_6506_length_883_cov_2.828395_g6129_i0	PRJNA1139127	6506	883	2.828395	24.97472785	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	48.1	0.0319	NR	HMK71712.1	2484252	g6129	i0	33.3	0.27519818799547	81	48	26.2	2	375	605	343	421	HMK71712.1 lactate utilization protein B [Myxococcaceae bacterium]	diamond	243	48.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcaceae bacterium
28649558	28649558	PRJNA1139127_P_NODE_47927_length_244_cov_0.888889_g47434_i0	PRJNA1139127	47927	244	0.888889	2.16888916	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.5	0.0207	NR	MDH4122132.1	2026735	g47434	i0	32.8	0.713114754098361	58	39	71.3	0	22	195	79	136	MDH4122132.1 DNA polymerase I [Deltaproteobacteria bacterium]	diamond	174	43.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria bacterium
29249205	29249205	PRJNA1139127_P_NODE_34349_length_291_cov_1.426606_g33856_i0	PRJNA1139127	34349	291	1.426606	4.15142346	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	92.8	1.75e-19	NR	HZJ68217.1	2212474	g33856	i0	70.1	1.38144329896907	67	19	69.1	1	201	1	1	66	HZJ68217.1 two-component regulator propeller domain-containing protein [Kofleriaceae bacterium]	diamond	402	92.8	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Kofleriaceae bacterium
32410046	32410046	PRJNA1139127_P_NODE_13739_length_552_cov_2.699374_g13259_i0	PRJNA1139127	13739	552	2.699374	14.90054448	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	269	2.4000000000000003e-80	NR	HEY1691467.1	2268199	g13259	i0	78.2	0.945652173913043	174	37	94.6	1	22	543	237	409	HEY1691467.1 hypothetical protein [Polyangiaceae bacterium]	diamond	522	269	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);;