metadata: contig_metadata: 30 rows where bioproject = "PRJNA493828" and tax

30 rows where bioproject = "PRJNA493828" 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
3025395	3025395	PRJNA493828_P_NODE_16683_length_306_cov_4.879828_g16264_i0	PRJNA493828	16683	306	4.879828	14.93227368	Archangium violaceum	83451	Bacteria	Bacteria	333	9.1e-87	NTclustered	gi\|2579675135\|gb\|CP043493.1\|	83451	g16264	i0	87.205	190.212418300654	297	32	96	2	1	295	5180818	5181110	Archangium violaceum strain Cbvi 34 chromosome, complete genome	blastn	58205	333	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
4301706	4301706	PRJNA493828_P_NODE_37084_length_244_cov_1.619883_g36665_i0	PRJNA493828	37084	244	1.619883	3.95251452	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	396	8.829999999999997e-106	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g36665	i0	95.902	224.827868852459	244	10	100	0	1	244	2160609	2160852	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	54858	396	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
8127773	8127773	PRJNA493828_P_NODE_29787_length_256_cov_4.710383_g29368_i0	PRJNA493828	29787	256	4.710383	12.05858048	Myxococcales bacterium	2026763	Bacteria	Bacteria	335	2.0599999999999993e-87	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g29368	i0	90.272	135.7734375	257	24	100	1	1	256	1308248	1308504	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	34758	335	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
10035012	10035012	PRJNA493828_P_NODE_29168_length_258_cov_2.329730_g28749_i0	PRJNA493828	29168	258	2.32973	6.0107034	Haliangium	162027	Bacteria	Bacteria	327	3.48e-85	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g28749	i0	89.535	44.7519379844961	258	27	100	0	1	258	234	491	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	11546	327	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
11953257	11953257	PRJNA493828_P_NODE_18170_length_295_cov_3.427928_g17751_i0	PRJNA493828	18170	295	3.427928	10.1123876	Myxococcales bacterium	2026763	Bacteria	Bacteria	209	1.54e-49	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g17751	i0	79.661	111.345762711864	295	56	99	4	3	295	1307913	1308205	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	32847	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
13228610	13228610	PRJNA493828_P_NODE_33971_length_248_cov_2.548571_g33552_i0	PRJNA493828	33971	248	2.548571	6.32045608	Corallococcus macrosporus	35	Bacteria	Bacteria	272	1.5799999999999996e-68	NTclustered	gi\|1243045502\|gb\|CP022203.1\|	1189310	g33552	i0	86.64	17.5483870967742	247	31	99	2	3	248	5793102	5793347	Corallococcus macrosporus DSM 14697 chromosome, complete genome	blastn	4352	272	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
13860247	13860247	PRJNA493828_P_NODE_38651_length_242_cov_1.680473_g38232_i0	PRJNA493828	38651	242	1.680473	4.06674466	Archangium	47	Bacteria	Bacteria	302	1.96e-77	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g38232	i0	90.708	267.090909090909	226	21	93	0	1	226	107211	106986	Archangium gephyra strain DSM 2261, complete genome	blastn	64636	302	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
14503315	14503315	PRJNA493828_P_NODE_19532_length_289_cov_1.916667_g19113_i0	PRJNA493828	19532	289	1.916667	5.53916763	Nannocystis punicea	2995304	Bacteria	Bacteria	396	1.0699999999999997e-105	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g19113	i0	91.409	160.141868512111	291	22	100	3	1	289	7595998	7596287	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	46281	396	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
16409338	16409338	PRJNA493828_P_NODE_44513_length_223_cov_5.260000_g44094_i0	PRJNA493828	44513	223	5.26	11.7298	Nannocystis	53	Bacteria	Bacteria	255	1.41e-63	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g44094	i0	88.318	183.201793721973	214	24	96	1	1	213	20	233	N.exedens 23S rRNA gene	blastn	40854	255	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
17051969	17051969	PRJNA493828_P_NODE_25014_length_270_cov_3.659898_g24595_i0	PRJNA493828	25014	270	3.659898	9.8817246	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	383	7.73e-102	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g24595	i0	92.222	192.962962962963	270	21	100	0	1	270	9676406	9676675	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	52100	383	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
17052159	17052159	PRJNA493828_P_NODE_37934_length_243_cov_0.905882_g37515_i0	PRJNA493828	37934	243	0.905882	2.20129326	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	126	3.96e-32	NR	HEX5101900.1	2268199	g37515	i0	70	1.97530864197531	80	24	98.8	0	241	2	411	490	HEX5101900.1 lipase maturation factor family protein [Polyangiaceae bacterium]	diamond	480	126	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
18326219	18326219	PRJNA493828_P_NODE_19115_length_291_cov_1.412844_g18696_i0	PRJNA493828	19115	291	1.412844	4.11137604	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	250	8.909999999999999e-62	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g18696	i0	85.039	59.1786941580756	254	28	86	10	38	286	2090651	2090403	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	17221	250	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
20232844	20232844	PRJNA493828_P_NODE_18296_length_294_cov_4.977376_g17877_i0	PRJNA493828	18296	294	4.977376	14.63348544	Myxococcales	29	Bacteria	Bacteria	516	8.05e-142	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g17877	i0	98.625	296.316326530612	291	4	99	0	1	291	4450774	4450484	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	87117	521	0.990403071017274	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
22151032	22151032	PRJNA493828_P_NODE_15358_length_310_cov_3.075949_g14939_i0	PRJNA493828	15358	310	3.075949	9.5354419	Myxococcota bacterium	2818507	Bacteria	Bacteria	85.9	8.48e-20	NR	HVH04409.1	2818507	g14939	i0	97.6	0.406451612903226	42	1	40.6	0	127	2	1	42	HVH04409.1 LemA family protein [Myxococcota bacterium]	diamond	126	85.9	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
22151115	22151115	PRJNA493828_P_NODE_19538_length_289_cov_1.888889_g19119_i0	PRJNA493828	19538	289	1.888889	5.45888921	Chondromyces crocatus	52	Bacteria	Bacteria	278	4.0500000000000005e-70	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g19119	i0	85.502	92.4429065743945	269	35	94	4	21	285	1431123	1430855	Chondromyces crocatus strain Cm c5, complete genome	blastn	26716	278	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
22151182	22151182	PRJNA493828_P_NODE_23918_length_274_cov_1.686567_g23499_i0	PRJNA493828	23918	274	1.686567	4.62119358	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	166	4.129999999999999e-48	NR	HEY3496663.1	2268199	g23499	i0	90	0.985401459854015	90	9	98.5	0	5	274	160	249	HEY3496663.1 phospho-N-acetylmuramoyl-pentapeptide-transferase [Polyangiaceae bacterium]	diamond	270	166	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
22151464	22151464	PRJNA493828_P_NODE_42058_length_233_cov_2.750000_g41639_i0	PRJNA493828	42058	233	2.75	6.4075	Nannocystis sp.	1962667	Bacteria	Bacteria	331	2.39e-86	NTclustered	gi\|1386873111\|gb\|MF774778.1\|	1962667	g41639	i0	92.982	84.5836909871245	228	15	97	1	1	227	597	370	Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence	blastn	19708	331	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
23427310	23427310	PRJNA493828_P_NODE_40559_length_238_cov_4.606061_g40140_i0	PRJNA493828	40559	238	4.606061	10.96242518	Archangium violaceum	83451	Bacteria	Bacteria	357	4.0499999999999996e-94	NTclustered	gi\|2579675135\|gb\|CP043493.1\|	83451	g40140	i0	93.697	237.260504201681	238	15	100	0	1	238	5179992	5180229	Archangium violaceum strain Cbvi 34 chromosome, complete genome	blastn	56468	357	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
24700387	24700387	PRJNA493828_P_NODE_11440_length_341_cov_1.929104_g11021_i0	PRJNA493828	11440	341	1.929104	6.57824464	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	468	2.7e-127	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g11021	i0	92.145	218.061583577713	331	26	97	0	1	331	9678393	9678723	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	74359	468	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
26665132	26665132	PRJNA493828_P_NODE_43801_length_227_cov_2.876623_g43382_i0	PRJNA493828	43801	227	2.876623	6.52993421	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	133	1.32e-34	NR	HEY3498849.1	2268199	g43382	i0	89.3	0.991189427312775	75	8	99.1	0	227	3	338	412	HEY3498849.1 DUF58 domain-containing protein [Polyangiaceae bacterium]	diamond	225	133	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
26887260	26887260	PRJNA493828_P_NODE_35961_length_246_cov_0.890173_g35542_i0	PRJNA493828	35961	246	0.890173	2.18982558	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	42	0.025	NR	HTQ47759.1	2268199	g35542	i0	42.3	0.634146341463415	52	29	62.2	1	166	14	22	73	HTQ47759.1 cereblon family protein [Polyangiaceae bacterium]	diamond	156	42	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28434981	28434981	PRJNA493828_P_NODE_29326_length_258_cov_1.427027_g28907_i0	PRJNA493828	29326	258	1.427027	3.68172966	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	84.3	7.33e-17	NR	MEZ4360189.1	2212474	g28907	i0	81.8	0.511627906976744	44	8	51.2	0	256	125	358	401	MEZ4360189.1 beta-ketoacyl synthase N-terminal-like domain-containing protein [Kofleriaceae bacterium]	diamond	132	84.3	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
28561326	28561326	PRJNA493828_P_NODE_40147_length_240_cov_2.574850_g39728_i0	PRJNA493828	40147	240	2.57485	6.17964	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	77	1.44e-15	NR	MBI5590671.1	2026735	g39728	i0	48.8	1	80	40	100	1	1	240	24	102	MBI5590671.1 type VI secretion system tube protein Hcp [Deltaproteobacteria bacterium]	diamond	240	77	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29208469	29208469	PRJNA493828_P_NODE_43749_length_227_cov_3.311688_g43330_i0	PRJNA493828	43749	227	3.311688	7.51753176	Pseudomonadati	3379134	Bacteria	Bacteria	58.5	7.46e-9	NR	MBW1792115.1	2026735	g43330	i0	46.9	1.24229074889868	49	26	64.8	0	188	42	2	50	MBW1792115.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	282	58.9	0.99320882852292	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29255599	29255599	PRJNA493828_P_NODE_32129_length_251_cov_0.865169_g31710_i0	PRJNA493828	32129	251	0.865169	2.17157419	Myxococcales bacterium	2026763	Bacteria	Bacteria	83.2	2.38e-16	NR	MSQ81441.1	2026763	g31710	i0	73.1	1.24302788844622	52	14	62.2	0	1	156	692	743	MSQ81441.1 hypothetical protein [Myxococcales bacterium]	diamond	312	83.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31324740	31324740	PRJNA493828_P_NODE_29635_length_257_cov_1.668478_g29216_i0	PRJNA493828	29635	257	1.668478	4.28798846	Myxococcia	32015	Bacteria	Bacteria	49.3	2.19e-4	NR	MCA9692965.1	2026763	g29216	i0	60.5	0.88715953307393	38	14	43.2	1	125	15	747	784	MCA9692965.1 VWA domain-containing protein [Myxococcales bacterium]	diamond	228	49.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31372652	31372652	PRJNA493828_P_NODE_21356_length_283_cov_1.114286_g20937_i0	PRJNA493828	21356	283	1.114286	3.15342938	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	82.4	2.95e-16	NR	HEY3497072.1	2268199	g20937	i0	71.4	0.593639575971731	56	16	59.4	0	283	116	261	316	HEY3497072.1 helix-turn-helix transcriptional regulator [Polyangiaceae bacterium]	diamond	168	82.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31562470	31562470	PRJNA493828_P_NODE_21896_length_281_cov_1.264423_g21477_i0	PRJNA493828	21896	281	1.264423	3.55302863	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	72	1.4e-13	NR	HEY3498920.1	2268199	g21477	i0	74.4	3.56583629893238	43	11	45.9	0	279	151	98	140	HEY3498920.1 EscU/YscU/HrcU family type III secretion system export apparatus switch protein [Polyangiaceae bacterium]	diamond	1002	72	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32036773	32036773	PRJNA493828_P_NODE_46558_length_207_cov_5.194030_g46139_i0	PRJNA493828	46558	207	5.19403	10.7516421	Nannocystis sp.	1962667	Bacteria	Bacteria	105	6.099999999999999e-25	NR	MBK8261646.1	1962667	g46139	i0	76.5	6.88405797101449	68	16	98.6	0	204	1	309	376	MBK8261646.1 acetyl-CoA C-acetyltransferase [Nannocystis sp.]	diamond	1425	105	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
32479930	32479930	PRJNA493828_P_NODE_42899_length_230_cov_2.700637_g42480_i0	PRJNA493828	42899	230	2.700637	6.2114651	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	73.6	3.4e-13	NR	MEO8178807.1	2026735	g42480	i0	43.9	0.860869565217391	66	37	86.1	0	228	31	299	364	MEO8178807.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	198	73.6	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);;