metadata: contig_metadata: 8 rows where bioproject = "PRJNA758087", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA758087", tax_kingdom = "Pseudomonadati" and tax_phylum = "Myxococcota"

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
19054503	19054503	PRJNA758087_P_NODE_31935_length_380_cov_11.433225_g30615_i0	PRJNA758087	31935	380	11.433225	43.446255	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	84	6.99e-16	NR	TNE43136.1	2026735	g30615	i0	36.1	0.939473684210526	119	66	91.6	3	26	373	68	179	TNE43136.1 MAG: LamG domain-containing protein [Deltaproteobacteria bacterium]	diamond	357	84	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
23686168	23686168	PRJNA758087_P_NODE_18179_length_663_cov_1.161017_g16894_i0	PRJNA758087	18179	663	1.161017	7.69754271	Labilithrix luteola	1391654	Bacteria	Bacteria	833	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g16894	i0	89.371	128.099547511312	668	63	100	7	1	663	7915726	7915062	Labilithrix luteola strain DSM 27648, complete genome	blastn	84930	833	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
27147347	27147347	PRJNA758087_P_NODE_39602_length_277_cov_3.828431_g38282_i0	PRJNA758087	39602	277	3.828431	10.60475387	Nannocystis sp.	1962667	Bacteria	Bacteria	44.7	0.0122	NR	WP_293258009.1	1962667	g38282	i0	40	0.595667870036101	55	29	55.2	1	271	119	761	815	WP_293258009.1 PAS domain S-box protein [Nannocystis sp.]	diamond	165	44.7	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
27210796	27210796	PRJNA758087_P_NODE_35182_length_334_cov_0.873563_g33862_i0	PRJNA758087	35182	334	0.873563	2.91770042	Myxococcales bacterium	2026763	Bacteria	Bacteria	140	3.17e-36	NR	MBL9109371.1	2026763	g33862	i0	73.9	0.826347305389222	92	23	81.7	1	62	334	54	145	MBL9109371.1 hypothetical protein [Myxococcales bacterium]	diamond	276	140	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30147492	30147492	PRJNA758087_P_NODE_43272_length_243_cov_0.905882_g41952_i0	PRJNA758087	43272	243	0.905882	2.20129326	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	55.8	8.74e-7	NR	TMA61741.1	2026735	g41952	i0	43.8	0.987654320987654	80	35	98.8	2	3	242	220	289	TMA61741.1 MAG: hypothetical protein E6J68_15740 [Deltaproteobacteria bacterium]	diamond	240	55.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30558269	30558269	PRJNA758087_P_NODE_13713_length_817_cov_9.487903_g12514_i0	PRJNA758087	13713	817	9.487903	77.51616751	Polyangiales bacterium	3034171	Bacteria	Bacteria	226	1.26e-69	NR	MFO0694577.1	3034171	g12514	i0	55	0.800489596083231	218	98	80	0	784	131	71	288	MFO0694577.1 hypothetical protein [Polyangiales bacterium]	diamond	654	226	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
31443389	31443389	PRJNA758087_P_NODE_22976_length_545_cov_3.970339_g21659_i0	PRJNA758087	22976	545	3.970339	21.63834755	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	272	6.179999999999998e-82	NR	MBN8538972.1	2026735	g21659	i0	79.2	3.80366972477064	173	36	95.2	0	18	536	319	491	MBN8538972.1 type IV secretion system DNA-binding domain-containing protein [Deltaproteobacteria bacterium]	diamond	2073	272	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32424161	32424161	PRJNA758087_P_NODE_30719_length_400_cov_0.831804_g29399_i0	PRJNA758087	30719	400	0.831804	3.327216	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	206	6.669999999999999e-60	NR	MDB5214021.1	2484252	g29399	i0	84.2	0.9975	133	20	99.8	1	400	2	17	148	MDB5214021.1 Hybrid sensor histidine kinase/response regulator [Myxococcaceae bacterium]	diamond	399	206	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae 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);;