metadata: contig_metadata: 28 rows where bioproject = "PRJNA438572" and tax

28 rows where bioproject = "PRJNA438572" 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
2366363	2366363	PRJNA438572_P_NODE_11182_length_307_cov_2.000000_g11063_i0	PRJNA438572	11182	307	2	6.14	Haliangium	162027	Bacteria	Bacteria	377	4.16e-100	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g11063	i0	88.961	177.625407166124	308	31	99	3	1	306	1279	973	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	54531	377	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
3641953	3641953	PRJNA438572_P_NODE_1683_length_740_cov_1.272864_g1579_i0	PRJNA438572	1683	740	1.272864	9.4191936	Stigmatella	40	Bacteria	Bacteria	981	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g1579	i0	90.701	242.933783783784	742	61	100	5	1	740	917	182	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	179771	981	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
6812843	6812843	PRJNA438572_P_NODE_24126_length_242_cov_0.923077_g24007_i0	PRJNA438572	24126	242	0.923077	2.23384634	Minicystis rosea	888845	Bacteria	Bacteria	185	2.06e-42	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g24007	i0	81.092	70.8512396694215	238	39	97	6	1	235	10105655	10105889	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	17146	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
17012295	17012295	PRJNA438572_P_NODE_17194_length_253_cov_0.866667_g17075_i0	PRJNA438572	17194	253	0.866667	2.19266751	Polyangium aurulentum	2567896	Bacteria	Bacteria	254	5.86e-63	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g17075	i0	85.156	3.04347826086957	256	28	99	9	3	253	8660101	8660351	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	770	254	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
25317292	25317292	PRJNA438572_P_NODE_7540_length_369_cov_1.050676_g7421_i0	PRJNA438572	7540	369	1.050676	3.87699444	Haliangium	162027	Bacteria	Bacteria	420	8.34e-113	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g7421	i0	88.122	239.691056910569	362	32	98	7	8	369	1523	1173	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	88446	420	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
26791269	26791269	PRJNA438572_P_NODE_5701_length_419_cov_1.982659_g5582_i0	PRJNA438572	5701	419	1.982659	8.30734121	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	130	8.119999999999999e-34	NR	MEO8552339.1	2212474	g5582	i0	60.4	0.758949880668258	106	39	74.5	3	106	417	191	295	MEO8552339.1 hypothetical protein [Kofleriaceae bacterium]	diamond	318	130	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
27328990	27328990	PRJNA438572_P_NODE_17923_length_252_cov_0.865922_g17804_i0	PRJNA438572	17923	252	0.865922	2.18212344	Myxococcota bacterium	2818507	Bacteria	Bacteria	53.1	8.59e-6	NR	MCH2173896.1	2818507	g17804	i0	33.3	0.964285714285714	81	54	96.4	0	244	2	315	395	MCH2173896.1 MATE family efflux transporter [Myxococcota bacterium]	diamond	243	53.1	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27518400	27518400	PRJNA438572_P_NODE_24863_length_228_cov_2.348387_g24744_i0	PRJNA438572	24863	228	2.348387	5.35432236	Pyxidicoccus trucidator	2709662	Bacteria	Bacteria	50.4	5.81e-5	NR	WP_164017221.1	2709662	g24744	i0	46.4	1.36842105263158	56	30	73.7	0	226	59	676	731	WP_164017221.1 adenylate/guanylate cyclase domain-containing protein [Pyxidicoccus trucidator]	diamond	312	50.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus trucidator
28244395	28244395	PRJNA438572_P_NODE_5126_length_439_cov_1.915301_g5007_i0	PRJNA438572	5126	439	1.915301	8.40817139	Archangium sp.	1872627	Bacteria	Bacteria	175	1.29e-49	NR	HEY0880548.1	1872627	g5007	i0	59.7	5.70615034168565	139	56	95	0	11	427	119	257	HEY0880548.1 SDR family NAD(P)-dependent oxidoreductase [Archangium sp.]	diamond	2505	175	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
28402436	28402436	PRJNA438572_P_NODE_16626_length_254_cov_1.690608_g16507_i0	PRJNA438572	16626	254	1.6906080000000001	4.29414432	Myxococcota bacterium	2818507	Bacteria	Bacteria	110	9.999999999999999e-27	NR	MEL6178351.1	2818507	g16507	i0	61.9	0.992125984251969	84	32	99.2	0	253	2	201	284	MEL6178351.1 NADH:flavin oxidoreductase/NADH oxidase family protein [Myxococcota bacterium]	diamond	252	110	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
29239720	29239720	PRJNA438572_P_NODE_9689_length_329_cov_0.914062_g9570_i0	PRJNA438572	9689	329	0.914062	3.00726398	root	1	Root_unresolved	Root_unresolved	45.8	0.00807	NR	MBK6683549.1	2026735	g9570	i0	45	2.63525835866261	40	22	36.5	0	274	155	247	286	MBK6683549.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	867	45.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29349734	29349734	PRJNA438572_P_NODE_13949_length_278_cov_1.521951_g13830_i0	PRJNA438572	13949	278	1.521951	4.23102378	Myxococcales bacterium	2026763	Bacteria	Bacteria	103	9.61e-26	NR	MCB9529829.1	2026763	g13830	i0	61.4	1.76978417266187	83	32	89.6	0	25	273	42	124	MCB9529829.1 VapA/VapB family virulence-associated protein [Myxococcales bacterium]	diamond	492	103	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29665016	29665016	PRJNA438572_P_NODE_15930_length_260_cov_1.652406_g15811_i0	PRJNA438572	15930	260	1.652406	4.2962556	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	45.4	0.00525	NR	HEY3821388.1	2268199	g15811	i0	39.5	0.992307692307692	86	45	99.2	3	2	259	1006	1084	HEY3821388.1 hypothetical protein [Polyangiaceae bacterium]	diamond	258	45.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
29918188	29918188	PRJNA438572_P_NODE_4671_length_457_cov_1.218750_g4552_i0	PRJNA438572	4671	457	1.21875	5.5696875	Myxococcales bacterium	2026763	Bacteria	Bacteria	108	1.28e-26	NR	MBL9042354.1	2026763	g4552	i0	47	0.866520787746171	132	67	86	3	441	49	31	160	MBL9042354.1 profilin [Myxococcales bacterium]	diamond	396	108	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30549839	30549839	PRJNA438572_P_NODE_24633_length_242_cov_0.893491_g24514_i0	PRJNA438572	24633	242	0.893491	2.16224822	Myxococcota bacterium	2818507	Bacteria	Bacteria	42.4	0.0486	NR	MEM7153991.1	2818507	g24514	i0	47.5	0.495867768595041	40	20	48.3	1	117	1	144	183	MEM7153991.1 hypothetical protein [Myxococcota bacterium]	diamond	120	42.4	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30612972	30612972	PRJNA438572_P_NODE_15273_length_266_cov_1.585492_g15154_i0	PRJNA438572	15273	266	1.585492	4.21740872	Bradymonadia bacterium	3121696	Bacteria	Bacteria	62.4	5.99e-9	NR	MFN3199518.1	3121696	g15154	i0	41.7	0.81203007518797	72	39	81.2	2	263	48	677	745	MFN3199518.1 hypothetical protein [Bradymonadia bacterium]	diamond	216	62.4	1	Bacteria	Pseudomonadati	Myxococcota	Bradymonadia				Bradymonadia bacterium
30755881	30755881	PRJNA438572_P_NODE_9354_length_334_cov_1.111111_g9235_i0	PRJNA438572	9354	334	1.111111	3.71111074	Anaeromyxobacter	161492	Bacteria	Bacteria	142	5.44e-38	NR	MFO0584119.1	1872521	g9235	i0	73	12.4311377245509	100	27	89.8	0	334	35	322	421	MFO0584119.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Anaeromyxobacter sp.]	diamond	4152	142	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp.
30913932	30913932	PRJNA438572_P_NODE_16074_length_259_cov_1.258065_g15955_i0	PRJNA438572	16074	259	1.258065	3.25838835	Bacteria	2	Bacteria	Bacteria	63.5	2.17e-9	NR	MFK7989863.1	2510337	g15955	i0	56	2.64092664092664	50	21	56.8	1	5	151	44	93	MFK7989863.1 MopE-related protein [Sandaracinaceae bacterium]	diamond	684	63.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae		Sandaracinaceae bacterium
31087060	31087060	PRJNA438572_P_NODE_20835_length_247_cov_0.896552_g20716_i0	PRJNA438572	20835	247	0.896552	2.21448344	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	44.7	0.00516	NR	HVK77064.1	2212474	g20716	i0	85.7	0.255060728744939	21	3	25.5	0	245	183	165	185	HVK77064.1 HNH endonuclease [Kofleriaceae bacterium]	diamond	63	44.7	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
31308218	31308218	PRJNA438572_P_NODE_21975_length_245_cov_1.319767_g21856_i0	PRJNA438572	21975	245	1.319767	3.23342915	Myxococcota bacterium	2818507	Bacteria	Bacteria	72	1.86e-12	NR	MFO0751290.1	2818507	g21856	i0	46.3	1.98367346938776	80	41	96.7	2	240	4	470	548	MFO0751290.1 thrombospondin type-1 domain-containing protein [Myxococcota bacterium]	diamond	486	72	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31324562	31324562	PRJNA438572_P_NODE_20755_length_247_cov_0.896552_g20636_i0	PRJNA438572	20755	247	0.896552	2.21448344	Pseudomonadati	3379134	Bacteria	Bacteria	84.7	9.36e-19	NR	HVN39390.1	2818507	g20636	i0	52.6	3.89878542510121	78	36	94.7	1	234	1	37	113	HVN39390.1 MAPEG family protein [Myxococcota bacterium]	diamond	963	84.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31403367	31403367	PRJNA438572_P_NODE_19016_length_250_cov_0.881356_g18897_i0	PRJNA438572	19016	250	0.881356	2.20339	Myxococcota bacterium	2818507	Bacteria	Bacteria	58.9	8.03e-8	NR	MED5463341.1	2818507	g18897	i0	46	0.756	63	31	75.6	1	20	208	171	230	MED5463341.1 5'-nucleotidase C-terminal domain-containing protein [Myxococcota bacterium]	diamond	189	58.9	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31577752	31577752	PRJNA438572_P_NODE_6056_length_407_cov_1.164671_g5937_i0	PRJNA438572	6056	407	1.164671	4.74021097	Pseudomonadati	3379134	Bacteria	Bacteria	83.2	4.1e-16	NR	MBW2022647.1	2026735	g5937	i0	76.5	1.87960687960688	51	12	37.6	0	205	53	126	176	MBW2022647.1 3-hydroxybutyryl-CoA dehydrogenase [Deltaproteobacteria bacterium]	diamond	765	83.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31845913	31845913	PRJNA438572_P_NODE_16317_length_257_cov_1.260870_g16198_i0	PRJNA438572	16317	257	1.26087	3.2404359	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	98.2	4.0900000000000002e-22	NR	MDB4995853.1	2484252	g16198	i0	54.1	4.96108949416342	85	39	99.2	0	255	1	94	178	MDB4995853.1 N-acetylmuramoyl-L-alanine amidase [Myxococcaceae bacterium]	diamond	1275	98.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
31877501	31877501	PRJNA438572_P_NODE_3137_length_555_cov_2.587137_g3019_i0	PRJNA438572	3137	555	2.587137	14.35861035	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	160	9.81e-44	NR	HEY6728916.1	2268199	g3019	i0	44.3	1.99459459459459	185	100	99.5	2	3	554	222	404	HEY6728916.1 phosphoglycerate kinase [Polyangiaceae bacterium]	diamond	1107	160	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31957165	31957165	PRJNA438572_P_NODE_15037_length_268_cov_1.594872_g14918_i0	PRJNA438572	15037	268	1.594872	4.27425696	Archangium	47	Bacteria	Bacteria	49.3	2.44e-4	NR	MBL8937652.1	1872627	g14918	i0	42.6	2.11567164179104	47	27	52.6	0	236	96	469	515	MBL8937652.1 hypothetical protein [Archangium sp.]	diamond	567	49.7	0.991951710261569	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
32273873	32273873	PRJNA438572_P_NODE_7878_length_362_cov_1.349481_g7759_i0	PRJNA438572	7878	362	1.349481	4.88512122	Pseudomonadati	3379134	Bacteria	Bacteria	92.4	4.51e-20	NR	MBL8683519.1	2026763	g7759	i0	51.9	1.25966850828729	77	35	62.2	1	334	110	47	123	MBL8683519.1 fatty acid desaturase family protein [Myxococcales bacterium]	diamond	456	92.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32699567	32699567	PRJNA438572_P_NODE_3240_length_547_cov_1.286920_g3122_i0	PRJNA438572	3240	547	1.28692	7.0394524	Enhygromyxa salina	215803	Bacteria	Bacteria	134	4.17e-33	NR	WP_146658148.1	215803	g3122	i0	39	1.12431444241316	205	96	99.3	3	546	4	250	449	WP_146658148.1 choice-of-anchor I family protein [Enhygromyxa salina]	diamond	615	134	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Enhygromyxa	Enhygromyxa salina

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);;