metadata: contig_metadata: 20 rows where bioproject = "PRJNA384462" and tax

20 rows where bioproject = "PRJNA384462" 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
7453819	7453819	PRJNA384462_S_NODE_106_length_1141_cov_12.782967_g82_i0	PRJNA384462	106	1141	12.782967	145.85365347	Myxococcia	32015	Bacteria	Bacteria	1509	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g82	i0	90.568	150.561787905346	1145	101	100	6	1	1141	3942913	3941772	Labilithrix luteola strain DSM 27648, complete genome	blastn	171791	1509	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
9333389	9333389	PRJNA384462_S_NODE_14388_length_163_cov_1.324561_g14272_i0	PRJNA384462	14388	163	1.324561	2.15903443	Bacteria	2	Bacteria	Bacteria	85.5	8.18e-18	NR	NLN62363.1	2026763	g14272	i0	72.5	16.1779141104294	51	14	93.9	0	159	7	295	345	NLN62363.1 argininosuccinate synthase [Myxococcales bacterium]	diamond	2637	85.9	0.9953434225844	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
15708054	15708054	PRJNA384462_S_NODE_1333_length_452_cov_13.325062_g1217_i0	PRJNA384462	1333	452	13.325062	60.22928024	Pendulispora albinea	2741071	Bacteria	Bacteria	606	7.449999999999998e-169	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g1217	i0	92.29	148.681415929204	428	31	94	2	27	452	3589270	3588843	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	67204	606	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
26885509	26885509	PRJNA384462_S_NODE_9781_length_185_cov_1.125000_g9665_i0	PRJNA384462	9781	185	1.125	2.08125	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	69.7	5.23e-12	NR	MCB1198107.1	2026735	g9665	i0	59.6	3.48648648648649	57	22	90.8	1	180	13	124	180	MCB1198107.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	645	69.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27517559	27517559	PRJNA384462_S_NODE_13723_length_165_cov_0.879310_g13607_i0	PRJNA384462	13723	165	0.87931	1.4508615	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	57.4	8.76e-8	NR	HEY1957771.1	2268199	g13607	i0	42.3	0.945454545454545	52	29	92.7	1	156	4	288	339	HEY1957771.1 hypothetical protein [Polyangiaceae bacterium]	diamond	156	57.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27724264	27724264	PRJNA384462_S_NODE_7004_length_210_cov_2.204969_g6888_i0	PRJNA384462	7004	210	2.204969	4.6304349	Bacteria	2	Bacteria	Bacteria	88.2	1.81e-20	NR	MCC6220444.1	2026735	g6888	i0	69.2	8.68571428571429	65	19	92.9	1	14	208	24	87	MCC6220444.1 glycine cleavage system protein GcvH [Deltaproteobacteria bacterium]	diamond	1824	89	0.991011235955056	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27770353	27770353	PRJNA384462_S_NODE_10904_length_178_cov_1.162791_g10788_i0	PRJNA384462	10904	178	1.162791	2.06976798	Polyangiales bacterium	3034171	Bacteria	Bacteria	58.9	3.06e-8	NR	MFO0630836.1	3034171	g10788	i0	48.1	0.910112359550562	54	26	91	1	175	14	325	376	MFO0630836.1 lysyl oxidase family protein [Polyangiales bacterium]	diamond	162	58.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
28481680	28481680	PRJNA384462_S_NODE_11746_length_173_cov_1.233871_g11630_i0	PRJNA384462	11746	173	1.233871	2.13459683	Pseudomonadati	3379134	Bacteria	Bacteria	75.9	3.03e-14	NR	MDD9933294.1	2026763	g11630	i0	58.9	4.90751445086705	56	23	97.1	0	172	5	1423	1478	MDD9933294.1 glutamate synthase large subunit [Myxococcales bacterium]	diamond	849	76.6	0.990861618798956	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28545014	28545014	PRJNA384462_S_NODE_8067_length_199_cov_1.353333_g7951_i0	PRJNA384462	8067	199	1.353333	2.69313267	Pseudomonadati	3379134	Bacteria	Bacteria	104	9.39e-26	NR	HLV19947.1	2268199	g7951	i0	73.4	11.4874371859296	64	17	96.5	0	4	195	163	226	HLV19947.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Polyangiaceae bacterium]	diamond	2286	104	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28717442	28717442	PRJNA384462_S_NODE_4247_length_257_cov_3.500000_g4131_i0	PRJNA384462	4247	257	3.5	8.995	Anaeromyxobacter sp.	1872521	Bacteria	Bacteria	49.7	1.46e-4	NR	HET6411598.1	1872521	g4131	i0	40.3	1.51750972762646	67	38	77	2	255	58	244	309	HET6411598.1 leishmanolysin-related zinc metalloendopeptidase [Anaeromyxobacter sp.]	diamond	390	49.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp.
28938501	28938501	PRJNA384462_S_NODE_7408_length_206_cov_1.254777_g7292_i0	PRJNA384462	7408	206	1.254777	2.58484062	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	132	1.3599999999999999e-34	NR	NRA34788.1	2268199	g7292	i0	83.6	1.96601941747573	67	11	97.6	0	203	3	333	399	NRA34788.1 class I SAM-dependent methyltransferase [Polyangiaceae bacterium]	diamond	405	132	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
29145031	29145031	PRJNA384462_S_NODE_8209_length_198_cov_1.026846_g8093_i0	PRJNA384462	8209	198	1.026846	2.03315508	Polyangium	55	Bacteria	Bacteria	73.2	3.76e-13	NR	MBK9260476.1	2268199	g8093	i0	48.4	3.87878787878788	64	32	97	1	193	2	496	558	MBK9260476.1 hypothetical protein [Polyangiaceae bacterium]	diamond	768	73.9	0.990527740189445	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
29285551	29285551	PRJNA384462_S_NODE_3249_length_289_cov_1.683333_g3133_i0	PRJNA384462	3249	289	1.683333	4.86483237	Myxococcales bacterium	2026763	Bacteria	Bacteria	49.7	2.14e-4	NR	MCA9565456.1	2026763	g3133	i0	36.8	0.705882352941177	68	42	70.6	1	227	24	193	259	MCA9565456.1 hypothetical protein [Myxococcales bacterium]	diamond	204	49.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29443314	29443314	PRJNA384462_S_NODE_15110_length_162_cov_0.858407_g14994_i0	PRJNA384462	15110	162	0.858407	1.39061934	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	41.6	0.0298	NR	MBN8616070.1	2026735	g14994	i0	35.3	0.944444444444444	51	30	94.4	1	160	8	104	151	MBN8616070.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	153	41.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29601150	29601150	PRJNA384462_S_NODE_250_length_894_cov_5.165680_g192_i0	PRJNA384462	250	894	5.16568	46.1811792	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	113	8.4e-24	NR	MBK9259502.1	2268199	g192	i0	44.8	3.25167785234899	165	87	54.7	4	1	489	1081	1243	MBK9259502.1 hypothetical protein [Polyangiaceae bacterium]	diamond	2907	113	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30439809	30439809	PRJNA384462_S_NODE_3253_length_289_cov_1.404167_g3137_i0	PRJNA384462	3253	289	1.404167	4.05804263	Bacteria	2	Bacteria	Bacteria	65.5	6.74e-10	NR	HTJ41131.1	2212474	g3137	i0	56.5	1.14186851211073	62	21	58.1	1	23	190	848	909	HTJ41131.1 hypothetical protein [Kofleriaceae bacterium]	diamond	330	65.5	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
30755621	30755621	PRJNA384462_S_NODE_13374_length_166_cov_0.871795_g13258_i0	PRJNA384462	13374	166	0.871795	1.4471797	Bacteria	2	Bacteria	Bacteria	42.7	0.013	NR	MCB9787062.1	2026735	g13258	i0	44	2.89156626506024	50	23	86.7	2	21	164	277	323	MCB9787062.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	480	43.1	0.990719257540603	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32210197	32210197	PRJNA384462_S_NODE_13498_length_165_cov_2.189655_g13382_i0	PRJNA384462	13498	165	2.189655	3.61293075	Pseudomonadati	3379134	Bacteria	Bacteria	108	6.91e-26	NR	KPK15036.1	1703407	g13382	i0	84.9	21.3090909090909	53	8	96.4	0	2	160	295	347	KPK15036.1 MAG: glutamate synthase [Myxococcales bacterium SG8_38]	diamond	3516	108	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium SG8_38
32589916	32589916	PRJNA384462_S_NODE_1319_length_455_cov_1.100985_g1203_i0	PRJNA384462	1319	455	1.100985	5.00948175	Pseudomonadati	3379134	Bacteria	Bacteria	124	1.19e-29	NR	WP_129354670.1	56	g1203	i0	45	3.8967032967033	129	67	82.4	2	379	5	111	239	WP_129354670.1 RCC1 domain-containing protein [Sorangium cellulosum]	diamond	1773	124	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
32761811	32761811	PRJNA384462_S_NODE_1760_length_393_cov_4.008721_g1644_i0	PRJNA384462	1760	393	4.008721	15.75427353	Bradymonadia bacterium	3121696	Bacteria	Bacteria	44.7	0.0387	NR	MFN3201068.1	3121696	g1644	i0	31.7	0.625954198473282	82	55	62.6	1	72	317	417	497	MFN3201068.1 Kazal-type serine protease inhibitor domain-containing protein [Bradymonadia bacterium]	diamond	246	44.7	1	Bacteria	Pseudomonadati	Myxococcota	Bradymonadia				Bradymonadia 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);;