metadata: contig_metadata: 10 rows where bioproject = "PRJNA1249042", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA1249042", 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
9980207	9980207	PRJNA1249042_S_NODE_116988_length_150_cov_2.196262_g116774_i0	PRJNA1249042	116988	150	2.196262	3.294393	Corallococcus	83461	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g116774	i0	100	271.36	150	0	100	0	1	150	142719	142570	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	40704	278	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
23307120	23307120	PRJNA1249042_S_NODE_75959_length_182_cov_1.000000_g75745_i0	PRJNA1249042	75959	182	1	1.82	Cystobacter fuscus	43	Bacteria	Bacteria	202	1.4499999999999998e-47	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g75745	i0	93.985	220.626373626374	133	8	75	0	27	159	451243	451111	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	40154	202	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
28070762	28070762	PRJNA1249042_S_NODE_70545_length_187_cov_1.305556_g70331_i0	PRJNA1249042	70545	187	1.305556	2.44138972	Polyangium	55	Bacteria	Bacteria	42.4	0.0236	NR	HVK69664.1	57	g70331	i0	39.5	2.06951871657754	43	26	69	0	170	42	267	309	HVK69664.1 serine/threonine-protein kinase [Polyangium sp.]	diamond	387	42.7	0.992974238875878	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium sp.
28652738	28652738	PRJNA1249042_S_NODE_75547_length_182_cov_1.719424_g75333_i0	PRJNA1249042	75547	182	1.719424	3.12935168	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	42.7	0.0165	NR	HWZ91608.1	2268199	g75333	i0	55.6	0.445054945054945	27	12	44.5	0	30	110	209	235	HWZ91608.1 DUF3160 domain-containing protein [Polyangiaceae bacterium]	diamond	81	42.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28873659	28873659	PRJNA1249042_S_NODE_94368_length_165_cov_4.860656_g94154_i0	PRJNA1249042	94368	165	4.860656	8.0200824	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	39.7	0.025	NR	HXK20015.1	2268199	g94154	i0	45	0.727272727272727	40	22	72.7	0	134	15	22	61	HXK20015.1 hypothetical protein [Polyangiaceae bacterium]	diamond	120	39.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31147482	31147482	PRJNA1249042_S_NODE_74735_length_183_cov_1.342857_g74521_i0	PRJNA1249042	74735	183	1.342857	2.45742831	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.5	0.00376	NR	MCC7108582.1	2026735	g74521	i0	44.2	0.704918032786885	43	23	68.9	1	3	128	39	81	MCC7108582.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	129	43.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31464367	31464367	PRJNA1249042_S_NODE_8416_length_323_cov_1.510714_g8202_i0	PRJNA1249042	8416	323	1.510714	4.87960622	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	45.4	0.0102	NR	MBW2459596.1	2026735	g8202	i0	37.5	0.520123839009288	56	30	51.1	2	269	105	135	186	MBW2459596.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	168	45.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31527491	31527491	PRJNA1249042_S_NODE_35576_length_231_cov_2.404255_g35362_i0	PRJNA1249042	35576	231	2.404255	5.55382905	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	46.6	0.0014	NR	MCB9647796.1	2026735	g35362	i0	42.9	0.727272727272727	56	31	72.7	1	39	206	495	549	MCB9647796.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	168	46.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31577174	31577174	PRJNA1249042_S_NODE_113256_length_152_cov_2.155963_g113042_i0	PRJNA1249042	113256	152	2.155963	3.27706376	Myxococcia	32015	Bacteria	Bacteria	101	6.1e-26	NR	MBK7535305.1	2026763	g113042	i0	88	1.97368421052632	50	6	98.7	0	152	3	40	89	MBK7535305.1 hypothetical protein [Myxococcales bacterium]	diamond	300	101	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32033544	32033544	PRJNA1249042_S_NODE_118238_length_150_cov_0.878505_g118024_i0	PRJNA1249042	118238	150	0.878505	1.3177575	Myxococcales bacterium	2026763	Bacteria	Bacteria	42.7	0.0103	NR	GMV39624.1	2026763	g118024	i0	44.2	0.86	43	23	86	1	131	3	189	230	GMV39624.1 MAG: hypothetical protein AMXMBFR64_13400 [Myxococcales bacterium]	diamond	129	42.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales 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);;