metadata: contig_metadata: 27 rows where bioproject = "PRJNA896758" and tax

27 rows where bioproject = "PRJNA896758" 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
8525644	8525644	PRJNA896758_P_NODE_23407_length_247_cov_0.885057_g23017_i0	PRJNA896758	23407	247	0.885057	2.18609079	Myxococcia	32015	Bacteria	Bacteria	150	2.05e-41	NR	HXX69662.1	2268199	g23017	i0	86.3	7.78542510121457	80	11	97.2	0	3	242	92	171	HXX69662.1 class II fumarate hydratase [Polyangiaceae bacterium]	diamond	1923	150	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
17451126	17451126	PRJNA896758_P_NODE_9634_length_367_cov_2.744898_g9244_i0	PRJNA896758	9634	367	2.744898	10.07377566	Labilithrix luteola	1391654	Bacteria	Bacteria	473	6.279999999999999e-129	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9244	i0	89.946	195.983651226158	368	35	99	1	2	367	3943241	3942874	Labilithrix luteola strain DSM 27648, complete genome	blastn	71926	473	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18724221	18724221	PRJNA896758_P_NODE_10675_length_351_cov_1.086331_g10285_i0	PRJNA896758	10675	351	1.086331	3.81302181	Labilithrix luteola	1391654	Bacteria	Bacteria	599	9.45e-167	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10285	i0	97.436	153.136752136752	351	9	100	0	1	351	3942509	3942859	Labilithrix luteola strain DSM 27648, complete genome	blastn	53751	599	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
23825068	23825068	PRJNA896758_P_NODE_5859_length_470_cov_1.790932_g5470_i0	PRJNA896758	5859	470	1.790932	8.4173804	Myxococcales bacterium	2026763	Bacteria	Bacteria	490	8.17e-134	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g5470	i0	85.745	80.6617021276596	470	60	99	7	1	467	1312454	1312919	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	37911	490	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
26866133	26866133	PRJNA896758_P_NODE_16941_length_281_cov_1.129808_g16551_i0	PRJNA896758	16941	281	1.129808	3.17476048	Myxococcota bacterium	2818507	Bacteria	Bacteria	134	2.65e-36	NR	MCG3174412.1	2818507	g16551	i0	66.7	0.96085409252669	90	30	96.1	0	5	274	157	246	MCG3174412.1 hypothetical protein [Myxococcota bacterium]	diamond	270	134	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27024023	27024023	PRJNA896758_P_NODE_25542_length_243_cov_0.905882_g25152_i0	PRJNA896758	25542	243	0.905882	2.20129326	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	68.6	1.86e-11	NR	MEO8552247.1	2212474	g25152	i0	48.2	1.04938271604938	85	38	98.8	3	3	242	180	263	MEO8552247.1 hypothetical protein [Kofleriaceae bacterium]	diamond	255	68.6	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
27150065	27150065	PRJNA896758_P_NODE_17782_length_275_cov_1.524752_g17392_i0	PRJNA896758	17782	275	1.524752	4.193068	Myxococcota bacterium	2818507	Bacteria	Bacteria	55.1	2.49e-6	NR	HRE88458.1	2818507	g17392	i0	67.6	0.370909090909091	34	11	37.1	0	265	164	58	91	HRE88458.1 fibrinogen-like YCDxxxxGGGW domain-containing protein [Myxococcota bacterium]	diamond	102	55.1	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27150074	27150074	PRJNA896758_P_NODE_22702_length_248_cov_1.628571_g22312_i0	PRJNA896758	22702	248	1.628571	4.03885608	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	140	1.34e-38	NR	MDP2345659.1	2026735	g22312	i0	75.6	0.991935483870968	82	20	99.2	0	2	247	12	93	MDP2345659.1 DMT family transporter [Deltaproteobacteria bacterium]	diamond	246	140	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27245318	27245318	PRJNA896758_P_NODE_22723_length_248_cov_1.400000_g22333_i0	PRJNA896758	22723	248	1.4	3.472	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	64.3	8.74e-11	NR	MCU0686357.1	2268199	g22333	i0	85	0.967741935483871	40	6	48.4	0	247	128	100	139	MCU0686357.1 Rrf2 family transcriptional regulator [Polyangiaceae bacterium]	diamond	240	64.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27529611	27529611	PRJNA896758_P_NODE_20543_length_255_cov_1.692308_g20153_i0	PRJNA896758	20543	255	1.692308	4.3153854	Myxococcales bacterium	2026763	Bacteria	Bacteria	72.4	1.19e-12	NR	MBL9099532.1	2026763	g20153	i0	47.7	1.01176470588235	86	38	95.3	2	246	4	265	348	MBL9099532.1 bis-aminopropyl spermidine synthase family protein [Myxococcales bacterium]	diamond	258	72.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28413811	28413811	PRJNA896758_P_NODE_13726_length_310_cov_2.945148_g13336_i0	PRJNA896758	13726	310	2.945148	9.1299588	Archangium gephyra	48	Bacteria	Bacteria	111	7.32e-26	NR	PZR15492.1	48	g13336	i0	100	0.483870967741935	50	0	48.4	0	161	310	508	557	PZR15492.1 MAG: hypothetical protein DI536_08570 [Archangium gephyra]	diamond	150	111	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
29045335	29045335	PRJNA896758_P_NODE_24028_length_246_cov_0.890173_g23638_i0	PRJNA896758	24028	246	0.890173	2.18982558	Sandaracinus sp.	2024858	Bacteria	Bacteria	70.1	8.86e-12	NR	MAQ13482.1	2024858	g23638	i0	46.5	2.68292682926829	71	37	86.6	1	219	7	321	390	MAQ13482.1 amidase [Sandaracinus sp.]	diamond	660	70.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus sp.
29487035	29487035	PRJNA896758_P_NODE_19550_length_263_cov_1.321053_g19160_i0	PRJNA896758	19550	263	1.321053	3.47436939	Sandaracinus sp.	2024858	Bacteria	Bacteria	87	1.18e-17	NR	MCB9619160.1	2024858	g19160	i0	52.4	3.85551330798479	82	37	93.5	1	247	2	292	371	MCB9619160.1 aldehyde dehydrogenase family protein [Sandaracinus sp.]	diamond	1014	87	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus sp.
29518740	29518740	PRJNA896758_P_NODE_19090_length_266_cov_1.512953_g18700_i0	PRJNA896758	19090	266	1.512953	4.02445498	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	62.4	4.08e-9	NR	HYR55913.1	2484252	g18700	i0	46.3	1.55639097744361	67	33	72.2	1	240	49	212	278	HYR55913.1 SDR family oxidoreductase [Myxococcaceae bacterium]	diamond	414	62.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
29866166	29866166	PRJNA896758_P_NODE_24891_length_244_cov_0.900585_g24501_i0	PRJNA896758	24891	244	0.900585	2.1974274	Citreicoccus inhibens	2849499	Bacteria	Bacteria	132	1.24e-35	NR	WP_217082086.1	2849499	g24501	i0	75	4.89344262295082	80	20	98.4	0	2	241	180	259	WP_217082086.1 FAD-dependent thymidylate synthase [Citreicoccus inhibens]	diamond	1194	132	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Citreicoccus	Citreicoccus inhibens
29960878	29960878	PRJNA896758_P_NODE_21091_length_251_cov_1.297753_g20701_i0	PRJNA896758	21091	251	1.297753	3.25736003	Paraliomyxa miuraensis	376150	Bacteria	Bacteria	64.3	1.01e-9	NR	WP_266220655.1	376150	g20701	i0	37.3	0.99203187250996006	83	51	98	1	5	250	404	486	WP_266220655.1 choice-of-anchor I family protein [Paraliomyxa miuraensis]	diamond	249	64.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales		Paraliomyxa	Paraliomyxa miuraensis
30189706	30189706	PRJNA896758_P_NODE_18312_length_272_cov_1.130653_g17922_i0	PRJNA896758	18312	272	1.130653	3.07537616	Bacteria	2	Bacteria	Bacteria	44.7	0.0101	NR	MFA9470571.1	2026735	g17922	i0	44.4	1.98529411764706	36	20	39.7	0	259	152	244	279	MFA9470571.1 Kazal-type serine protease inhibitor domain-containing protein [Deltaproteobacteria bacterium]	diamond	540	44.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30340597	30340597	PRJNA896758_P_NODE_13632_length_312_cov_0.811715_g13242_i0	PRJNA896758	13632	312	0.811715	2.5325508	Myxococcales bacterium	2026763	Bacteria	Bacteria	104	1.31e-24	NR	MCA9507341.1	2026763	g13242	i0	51	0.961538461538462	100	48	96.2	1	301	2	56	154	MCA9507341.1 hypothetical protein [Myxococcales bacterium]	diamond	300	104	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30529521	30529521	PRJNA896758_P_NODE_10573_length_352_cov_1.369176_g10183_i0	PRJNA896758	10573	352	1.369176	4.81949952	Sorangium cellulosum	56	Bacteria	Bacteria	102	1.45e-24	NR	WP_061608780.1	56	g10183	i0	49	3.69886363636364	100	49	85.2	2	325	26	47	144	WP_061608780.1 pyridoxamine 5'-phosphate oxidase family protein [Sorangium cellulosum]	diamond	1302	102	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
30655952	30655952	PRJNA896758_P_NODE_8453_length_390_cov_1.536278_g8063_i0	PRJNA896758	8453	390	1.536278	5.9914842	Myxococcales bacterium	2026763	Bacteria	Bacteria	44.3	0.0402	NR	HKC58972.1	2026763	g8063	i0	35.8	0.623076923076923	81	30	56.9	3	226	5	24	89	HKC58972.1 peptidoglycan-associated lipoprotein Pal [Myxococcales bacterium]	diamond	243	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30719086	30719086	PRJNA896758_P_NODE_13894_length_308_cov_2.331915_g13504_i0	PRJNA896758	13894	308	2.331915	7.1822982	Polyangia bacterium	3058050	Bacteria	Bacteria	91.3	6.98e-19	NR	HZS39580.1	3058050	g13504	i0	43.4	2.02597402597403	106	52	99.4	3	307	2	280	381	HZS39580.1 WSC domain-containing protein [Polyangia bacterium]	diamond	624	91.3	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
30877161	30877161	PRJNA896758_P_NODE_26294_length_241_cov_1.392857_g25904_i0	PRJNA896758	26294	241	1.392857	3.35678537	Archangium gephyra	48	Bacteria	Bacteria	146	1.24e-41	NR	PZR10841.1	48	g25904	i0	97.5	0.995850622406639	80	2	99.6	0	2	241	118	197	PZR10841.1 MAG: ABC transporter permease [Archangium gephyra]	diamond	240	146	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
31098186	31098186	PRJNA896758_P_NODE_17215_length_279_cov_1.339806_g16825_i0	PRJNA896758	17215	279	1.339806	3.73805874	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	46.6	0.00239	NR	MEJ7603518.1	2212474	g16825	i0	60.8	1.09677419354839	51	7	54.8	2	153	1	1	38	MEJ7603518.1 trypsin-like peptidase domain-containing protein [Kofleriaceae bacterium]	diamond	306	46.6	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
31137354	31137354	PRJNA896758_P_NODE_22275_length_249_cov_0.875000_g21885_i0	PRJNA896758	22275	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	58.2	1.51e-7	NR	MFT3772735.1	1971901	g21885	i0	50.9	7.03614457831325	53	26	63.9	0	225	67	580	632	MFT3772735.1 hypothetical protein [Minicystis sp.]	diamond	1752	58.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis sp.
31295686	31295686	PRJNA896758_P_NODE_21875_length_250_cov_0.870056_g21485_i0	PRJNA896758	21875	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	79.3	3.78e-15	NR	MCB9651304.1	2026735	g21485	i0	50	2.82	76	37	90	1	4	228	296	371	MCB9651304.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	705	79.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32181572	32181572	PRJNA896758_P_NODE_9458_length_371_cov_1.550336_g9068_i0	PRJNA896758	9458	371	1.550336	5.75174656	Myxococcia	32015	Bacteria	Bacteria	107	2.5999999999999996e-24	NR	MCC7537080.1	2026735	g9068	i0	53.3	2.53099730458221	107	50	86.5	0	321	1	9	115	MCC7537080.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	939	107	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32781420	32781420	PRJNA896758_P_NODE_19800_length_261_cov_1.494681_g19410_i0	PRJNA896758	19800	261	1.494681	3.90111741	Archangium	47	Bacteria	Bacteria	134	2.56e-34	NR	WP_052517748.1	83451	g19410	i0	77.1	12.4367816091954	83	19	95.4	0	260	12	643	725	WP_052517748.1 PEP/pyruvate-binding domain-containing protein [Archangium violaceum]	diamond	3246	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum

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