metadata: contig_metadata: 19 rows where bioproject = "PRJNA782235" and tax

19 rows where bioproject = "PRJNA782235" 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
763272	763272	PRJNA782235_P_NODE_17181_length_250_cov_1.802260_g16992_i0	PRJNA782235	17181	250	1.80226	4.50565	Cystobacter fuscus	43	Bacteria	Bacteria	444	3.1999999999999986e-120	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g16992	i0	98.795	299.48	249	3	99	0	1	249	4450522	4450770	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	74870	444	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
4591622	4591622	PRJNA782235_P_NODE_19824_length_248_cov_0.880000_g19635_i0	PRJNA782235	19824	248	0.88	2.1824	Archangium gephyra	48	Bacteria	Bacteria	169	2.13e-37	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g19635	i0	85.366	62.7822580645161	164	22	66	2	71	233	854457	854295	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	15570	169	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
4591703	4591703	PRJNA782235_P_NODE_24864_length_244_cov_0.900585_g24675_i0	PRJNA782235	24864	244	0.900585	2.1974274	Sorangium cellulosum	56	Bacteria	Bacteria	106	1.67e-18	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g24675	i0	82.645	1.72950819672131	121	19	49	2	26	145	12021022	12020903	Sorangium cellulosum So0157-2, complete genome	blastn	422	106	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4591713	4591713	PRJNA782235_P_NODE_25404_length_243_cov_0.905882_g25215_i0	PRJNA782235	25404	243	0.905882	2.20129326	Myxococcota bacterium	2818507	Bacteria	Bacteria	151	1.75e-41	NR	MEZ0311045.1	2818507	g25215	i0	97.5	1.97530864197531	80	2	98.8	0	241	2	131	210	MEZ0311045.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatA [Myxococcota bacterium]	diamond	480	151	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
4591851	4591851	PRJNA782235_P_NODE_9804_length_291_cov_1.077982_g9615_i0	PRJNA782235	9804	291	1.077982	3.13692762	Cystobacter fuscus	43	Bacteria	Bacteria	479	1.0399999999999996e-130	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g9615	i0	96.54	227.034364261168	289	10	99	0	3	291	7643462	7643750	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	66067	479	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
12242982	12242982	PRJNA782235_P_NODE_24230_length_244_cov_1.280702_g24041_i0	PRJNA782235	24230	244	1.280702	3.12491288	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	248	2.6199999999999997e-61	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g24041	i0	85.95	8.65163934426229	242	22	99	6	3	244	74225	74454	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	2111	248	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
14791952	14791952	PRJNA782235_P_NODE_21812_length_246_cov_1.780347_g21623_i0	PRJNA782235	21812	246	1.780347	4.37965362	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	294	3.34e-75	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g21623	i0	88.211	28.3739837398374	246	29	100	0	1	246	5126427	5126672	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	6980	294	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
14792014	14792014	PRJNA782235_P_NODE_26612_length_242_cov_0.911243_g26423_i0	PRJNA782235	26612	242	0.911243	2.20520806	Pseudomyxococcus hansupus	1297742	Bacteria	Bacteria	193	1.23e-44	NTclustered	gi\|891158403\|gb\|CP012109.1\|	1297742	g26423	i0	90.909	5.3099173553719	143	13	59	0	60	202	5692763	5692621	Myxococcus hansupus strain mixupus chromosome, complete genome	blastn	1285	193	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pseudomyxococcus	Pseudomyxococcus hansupus
17790056	17790056	PRJNA782235_P_NODE_23654_length_245_cov_0.895349_g23465_i0	PRJNA782235	23654	245	0.895349	2.19360505	Nannocystis	53	Bacteria	Bacteria	377	3.21e-100	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g23465	i0	95.378	157.94693877551	238	10	97	1	4	240	668	905	N.exedens 23S rRNA gene	blastn	38697	377	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
21165974	21165974	PRJNA782235_P_NODE_24137_length_244_cov_1.801170_g23948_i0	PRJNA782235	24137	244	1.80117	4.3948548	Myxococcota bacterium	2818507	Bacteria	Bacteria	133	2.4e-36	NR	MFA6032311.1	2818507	g23948	i0	79	4.97950819672131	81	17	99.6	0	2	244	47	127	MFA6032311.1 site-specific integrase [Myxococcota bacterium]	diamond	1215	133	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
21166104	21166104	PRJNA782235_P_NODE_7837_length_322_cov_0.907631_g7648_i0	PRJNA782235	7837	322	0.907631	2.92257182	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	579	1.1199999999999997e-160	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g7648	i0	99.068	299.124223602484	322	3	100	0	1	322	2161384	2161705	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	96318	579	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
22440699	22440699	PRJNA782235_P_NODE_21778_length_246_cov_1.780347_g21589_i0	PRJNA782235	21778	246	1.780347	4.37965362	Bacteria candidate phyla	1783234	Bacteria	Bacteria	105	3.2299999999999997e-24	NR	HTN83717.1	2093377	g21589	i0	67.5	3.90243902439024	77	25	93.9	0	233	3	1522	1598	HTN83717.1 type I polyketide synthase [Sorangium sp.]	diamond	960	106	0.990566037735849	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium sp.
24989728	24989728	PRJNA782235_P_NODE_14000_length_264_cov_1.554974_g13811_i0	PRJNA782235	14000	264	1.554974	4.10513136	Myxococcus stipitatus	83455	Bacteria	Bacteria	183	8.2e-42	NTclustered	gi\|441484664\|gb\|CP004025.1\|	1278073	g13811	i0	79.389	1.96212121212121	262	52	99	2	1	261	3997782	3998042	Myxococcus stipitatus DSM 14675, complete genome	blastn	518	183	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
27874822	27874822	PRJNA782235_P_NODE_10625_length_285_cov_1.452830_g10436_i0	PRJNA782235	10625	285	1.45283	4.1405655	Myxococcales bacterium	2026763	Bacteria	Bacteria	43.5	0.0227	NR	GMV42276.1	2026763	g10436	i0	39.3	0.642105263157895	61	37	64.2	0	212	30	8	68	GMV42276.1 MAG: hypothetical protein AMXMBFR64_39920 [Myxococcales bacterium]	diamond	183	43.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29642687	29642687	PRJNA782235_P_NODE_27570_length_241_cov_1.291667_g27381_i0	PRJNA782235	27570	241	1.291667	3.11291747	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	42.4	0.0464	NR	MBN1226214.1	2026735	g27381	i0	34.6	0.647302904564315	52	32	62.2	1	218	69	184	235	MBN1226214.1 TAXI family TRAP transporter solute-binding subunit [Deltaproteobacteria bacterium]	diamond	156	42.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30211395	30211395	PRJNA782235_P_NODE_25472_length_243_cov_0.905882_g25283_i0	PRJNA782235	25472	243	0.905882	2.20129326	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	141	2.1399999999999996e-37	NR	MFN0247680.1	2212474	g25283	i0	87.8	1.80246913580247	74	9	91.4	0	241	20	45	118	MFN0247680.1 class II glutamine amidotransferase [Kofleriaceae bacterium]	diamond	438	141	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
30811848	30811848	PRJNA782235_P_NODE_15814_length_253_cov_1.355556_g15625_i0	PRJNA782235	15814	253	1.355556	3.42955668	Myxococcus vastator	2709664	Bacteria	Bacteria	56.6	3.86e-7	NR	WP_163778624.1	2709664	g15625	i0	44.2	1.82608695652174	77	41	91.3	2	252	22	37	111	WP_163778624.1 endonuclease/exonuclease/phosphatase family protein [Myxococcus vastator]	diamond	462	56.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus vastator
31570783	31570783	PRJNA782235_P_NODE_19336_length_249_cov_0.875000_g19147_i0	PRJNA782235	19336	249	0.875	2.17875	Anaeromyxobacteraceae bacterium	2510643	Bacteria	Bacteria	119	4.489999999999999e-31	NR	HZZ84940.1	2510643	g19147	i0	70.6	2.03614457831325	85	21	97.6	1	6	248	131	215	HZZ84940.1 outer membrane beta-barrel domain-containing protein [Anaeromyxobacteraceae bacterium]	diamond	507	119	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae		Anaeromyxobacteraceae bacterium
32266805	32266805	PRJNA782235_P_NODE_23138_length_245_cov_0.895349_g22949_i0	PRJNA782235	23138	245	0.895349	2.19360505	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	85.9	1.9e-18	NR	MFN7698519.1	2026735	g22949	i0	55.1	1.91020408163265	78	35	95.5	0	238	5	11	88	MFN7698519.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	468	85.9	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);;