metadata: contig_metadata: 35 rows where bioproject = "PRJNA404067" and tax

35 rows where bioproject = "PRJNA404067" 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
414747	414747	PRJNA404067_P_NODE_38181_length_201_cov_1.935714_g37794_i0	PRJNA404067	38181	201	1.935714	3.89078514	Hyalangium minutum	394096	Bacteria	Bacteria	119	1.31e-30	NR	WP_044189518.1	394096	g37794	i0	95.1	1.82089552238806	61	3	91	0	18	200	184	244	WP_044189518.1 AmmeMemoRadiSam system radical SAM enzyme [Hyalangium minutum]	diamond	366	119	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Hyalangium	Hyalangium minutum
5518578	5518578	PRJNA404067_P_NODE_38205_length_201_cov_1.807143_g37818_i0	PRJNA404067	38205	201	1.807143	3.63235743	Pendulispora rubella	2741070	Bacteria	Bacteria	344	2.5799999999999998e-90	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g37818	i0	97.512	106.363184079602	201	5	100	0	1	201	7292232	7292032	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	21379	344	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
9342880	9342880	PRJNA404067_P_NODE_33168_length_207_cov_0.869863_g32781_i0	PRJNA404067	33168	207	0.869863	1.80061641	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	133	3.0599999999999995e-37	NR	MBI5298814.1	2026735	g32781	i0	94.1	0.985507246376812	68	4	98.6	0	2	205	17	84	MBI5298814.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Deltaproteobacteria bacterium]	diamond	204	133	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
10618307	10618307	PRJNA404067_P_NODE_11029_length_323_cov_1.354962_g10644_i0	PRJNA404067	11029	323	1.354962	4.37652726	Labilithrix luteola	1391654	Bacteria	Bacteria	449	9.199999999999999e-122	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10644	i0	97.348	145.557275541796	264	7	98	0	59	322	3942570	3942833	Labilithrix luteola strain DSM 27648, complete genome	blastn	47015	449	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11893271	11893271	PRJNA404067_P_NODE_18730_length_241_cov_1.750000_g18343_i0	PRJNA404067	18730	241	1.75	4.2175	Chondromyces crocatus	52	Bacteria	Bacteria	331	2.49e-86	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g18343	i0	91.983	160.867219917012	237	17	98	2	6	241	1431863	1431628	Chondromyces crocatus strain Cm c5, complete genome	blastn	38769	331	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
11893274	11893274	PRJNA404067_P_NODE_18950_length_240_cov_1.815642_g18563_i0	PRJNA404067	18950	240	1.815642	4.3575408	Pendulispora rubella	2741070	Bacteria	Bacteria	355	1.47e-93	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g18563	i0	93.333	111.716666666667	240	16	100	0	1	240	7289411	7289172	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	26812	355	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
14443768	14443768	PRJNA404067_P_NODE_39352_length_200_cov_2.618705_g38965_i0	PRJNA404067	39352	200	2.618705	5.23741	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	219	1.62e-52	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g38965	i0	87.701	83.365	187	23	94	0	2	188	9679256	9679070	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	16673	219	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15717230	15717230	PRJNA404067_P_NODE_22933_length_228_cov_1.371257_g22546_i0	PRJNA404067	22933	228	1.371257	3.12646596	Labilithrix luteola	1391654	Bacteria	Bacteria	342	1.08e-89	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g22546	i0	94.196	181.40350877193	224	13	98	0	1	224	3943241	3943018	Labilithrix luteola strain DSM 27648, complete genome	blastn	41360	342	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16992122	16992122	PRJNA404067_P_NODE_27754_length_216_cov_1.619355_g27367_i0	PRJNA404067	27754	216	1.619355	3.4978068	Labilithrix luteola	1391654	Bacteria	Bacteria	252	1.75e-62	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g27367	i0	87.907	0.99537037037037	215	24	99	2	3	216	6447356	6447569	Labilithrix luteola strain DSM 27648, complete genome	blastn	215	252	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19540530	19540530	PRJNA404067_P_NODE_34616_length_205_cov_0.888889_g34229_i0	PRJNA404067	34616	205	0.888889	1.82222245	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	60.8	9.29e-9	NR	HEY0479243.1	2212474	g34229	i0	69.8	1.11219512195122	43	13	62.9	0	204	76	521	563	HEY0479243.1 alkaline phosphatase family protein [Kofleriaceae bacterium]	diamond	228	60.8	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
22091088	22091088	PRJNA404067_P_NODE_27818_length_216_cov_1.387097_g27431_i0	PRJNA404067	27818	216	1.387097	2.99612952	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	101	3.47e-23	NR	MBI3799584.1	2026735	g27431	i0	78.6	0.777777777777778	56	12	77.8	0	49	216	3	58	MBI3799584.1 MFS transporter [Deltaproteobacteria bacterium]	diamond	168	101	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
26854168	26854168	PRJNA404067_P_NODE_26441_length_219_cov_1.373418_g26054_i0	PRJNA404067	26441	219	1.373418	3.00778542	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	82.8	2.09e-16	NR	MBK9263623.1	2268199	g26054	i0	52.2	0.917808219178082	67	32	91.8	0	218	18	126	192	MBK9263623.1 hypothetical protein [Polyangiaceae bacterium]	diamond	201	82.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27138201	27138201	PRJNA404067_P_NODE_32642_length_207_cov_1.479452_g32255_i0	PRJNA404067	32642	207	1.479452	3.06246564	Archangium sp.	1872627	Bacteria	Bacteria	80.9	3.68e-17	NR	MBL8910405.1	1872627	g32255	i0	97.2	1.56521739130435	36	1	52.2	0	100	207	1	36	MBL8910405.1 acyl-CoA thioesterase [Archangium sp.]	diamond	324	80.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
27549282	27549282	PRJNA404067_P_NODE_23724_length_226_cov_1.496970_g23337_i0	PRJNA404067	23724	226	1.49697	3.3831522	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.5	0.0166	NR	MCX5914200.1	2026735	g23337	i0	46.7	1.02212389380531	45	24	59.7	0	225	91	987	1031	MCX5914200.1 PLxRFG domain-containing protein [Deltaproteobacteria bacterium]	diamond	231	43.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28117581	28117581	PRJNA404067_P_NODE_31745_length_208_cov_1.687075_g31358_i0	PRJNA404067	31745	208	1.687075	3.509116	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	77.4	8.83e-15	NR	MBN8537443.1	2026735	g31358	i0	42.7	2.14903846153846	75	36	98.1	1	2	205	140	214	MBN8537443.1 LysR family transcriptional regulator [Deltaproteobacteria bacterium]	diamond	447	77.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28243823	28243823	PRJNA404067_P_NODE_40826_length_193_cov_2.962121_g40439_i0	PRJNA404067	40826	193	2.962121	5.71689353	Myxococcales bacterium	2026763	Bacteria	Bacteria	87	4.81e-18	NR	HXN83596.1	2026763	g40439	i0	63.1	3.99481865284974	65	23	99.5	1	1	192	120	184	HXN83596.1 phenylalanine--tRNA ligase subunit beta [Myxococcales bacterium]	diamond	771	87	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28307181	28307181	PRJNA404067_P_NODE_34386_length_205_cov_1.430556_g33999_i0	PRJNA404067	34386	205	1.430556	2.9326398	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	94.4	7.87e-23	NR	MDB4986247.1	2484252	g33999	i0	82	0.892682926829268	61	11	89.3	0	1	183	76	136	MDB4986247.1 synthase epsilon chain [Myxococcaceae bacterium]	diamond	183	94.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
28323728	28323728	PRJNA404067_P_NODE_33006_length_207_cov_0.876712_g32619_i0	PRJNA404067	33006	207	0.876712	1.81479384	Myxococcia	32015	Bacteria	Bacteria	104	3.59e-24	NR	HVH47746.1	1971228	g32619	i0	89.1	2.39130434782609	55	6	79.7	0	43	207	284	338	HVH47746.1 prolipoprotein diacylglyceryl transferase family protein [Labilithrix sp.]	diamond	495	105	0.990476190476191	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
29696007	29696007	PRJNA404067_P_NODE_12790_length_293_cov_2.676724_g12403_i0	PRJNA404067	12790	293	2.676724	7.84280132	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	137	5.09e-37	NR	MDP3939231.1	2026735	g12403	i0	69.1	0.993174061433447	97	30	99.3	0	3	293	108	204	MDP3939231.1 N4-gp56 family major capsid protein [Deltaproteobacteria bacterium]	diamond	291	137	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29759399	29759399	PRJNA404067_P_NODE_16591_length_255_cov_1.536082_g16204_i0	PRJNA404067	16591	255	1.536082	3.9170091	Myxococcota bacterium	2818507	Bacteria	Bacteria	82.8	2.61e-17	NR	MCS6913673.1	2818507	g16204	i0	56.5	1	85	32	98.8	3	3	254	36	116	MCS6913673.1 DUF882 domain-containing protein [Myxococcota bacterium]	diamond	255	82.8	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30043766	30043766	PRJNA404067_P_NODE_36551_length_203_cov_0.901408_g36164_i0	PRJNA404067	36551	203	0.901408	1.82985824	Labilithrix sp.	1971228	Bacteria	Bacteria	107	1.93e-25	NR	MBX3215761.1	1971228	g36164	i0	81.3	1.89162561576355	64	12	94.6	0	203	12	331	394	MBX3215761.1 hypothetical protein [Labilithrix sp.]	diamond	384	107	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
30170084	30170084	PRJNA404067_P_NODE_41892_length_189_cov_2.265625_g41505_i0	PRJNA404067	41892	189	2.265625	4.28203125	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	48.9	4.02e-5	NR	HEV8548767.1	2268199	g41505	i0	37.9	1.87301587301587	58	36	92.1	0	7	180	32	89	HEV8548767.1 hypothetical protein [Polyangiaceae bacterium]	diamond	354	48.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30201566	30201566	PRJNA404067_P_NODE_28692_length_214_cov_1.307190_g28305_i0	PRJNA404067	28692	214	1.30719	2.7973866	Polyangia bacterium	3058050	Bacteria	Bacteria	85.9	1.57e-17	NR	HEY5285121.1	3058050	g28305	i0	58.2	0.939252336448598	67	28	93.9	0	212	12	179	245	HEY5285121.1 insulinase family protein [Polyangia bacterium]	diamond	201	85.9	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
30250347	30250347	PRJNA404067_P_NODE_19892_length_237_cov_1.477273_g19505_i0	PRJNA404067	19892	237	1.477273	3.50113701	Polyangiales	3031712	Bacteria	Bacteria	42.7	0.0347	NR	HSO38188.1	1971228	g19505	i0	52.4	1.06329113924051	42	19	53.2	1	126	1	29	69	HSO38188.1 pitrilysin family protein [Labilithrix sp.]	diamond	252	42.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
30391861	30391861	PRJNA404067_P_NODE_37573_length_202_cov_0.907801_g37186_i0	PRJNA404067	37573	202	0.907801	1.83375802	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	50.4	3.93e-5	NR	MBI3294101.1	2026735	g37186	i0	67.6	0.504950495049505	34	11	50.5	0	3	104	287	320	MBI3294101.1 NADH-quinone oxidoreductase subunit D [Deltaproteobacteria bacterium]	diamond	102	50.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30486221	30486221	PRJNA404067_P_NODE_23853_length_226_cov_0.987879_g23466_i0	PRJNA404067	23853	226	0.987879	2.23260654	Labilithrix sp.	1971228	Bacteria	Bacteria	45.8	0.00248	NR	MBX3220947.1	1971228	g23466	i0	36.6	0.942477876106195	71	45	94.2	0	8	220	492	562	MBX3220947.1 caspase family protein [Labilithrix sp.]	diamond	213	45.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
30802064	30802064	PRJNA404067_P_NODE_18334_length_243_cov_3.741758_g17947_i0	PRJNA404067	18334	243	3.741758	9.09247194	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	63.5	1.78e-9	NR	MCD6294557.1	2026735	g17947	i0	52.8	1.30864197530864	53	25	65.4	0	204	46	325	377	MCD6294557.1 MMPL family transporter [Deltaproteobacteria bacterium]	diamond	318	63.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30928606	30928606	PRJNA404067_P_NODE_12854_length_292_cov_5.727273_g12467_i0	PRJNA404067	12854	292	5.727273	16.72363716	Polyangia bacterium	3058050	Bacteria	Bacteria	46.2	0.00371	NR	HEY7373179.1	3058050	g12467	i0	42.9	0.503424657534247	49	24	46.2	1	147	281	114	162	HEY7373179.1 aldo/keto reductase [Polyangia bacterium]	diamond	147	46.2	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
31782015	31782015	PRJNA404067_P_NODE_15797_length_261_cov_1.010000_g15410_i0	PRJNA404067	15797	261	1.01	2.6361	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	89	2.45e-18	NR	HEY2369555.1	2268199	g15410	i0	52.4	2.77011494252874	84	39	96.6	1	261	10	345	427	HEY2369555.1 hypothetical protein [Polyangiaceae bacterium]	diamond	723	89	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31782020	31782020	PRJNA404067_P_NODE_32817_length_207_cov_1.143836_g32430_i0	PRJNA404067	32817	207	1.143836	2.36774052	Myxococcales bacterium	2026763	Bacteria	Bacteria	113	2.45e-27	NR	RYE94384.1	2026763	g32430	i0	82.9	1.01449275362319	70	10	98.6	1	204	1	436	505	RYE94384.1 MAG: PAS domain-containing sensor histidine kinase [Myxococcales bacterium]	diamond	210	113	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31845345	31845345	PRJNA404067_P_NODE_27637_length_216_cov_3.851613_g27250_i0	PRJNA404067	27637	216	3.851613	8.31948408	Myxococcota bacterium	2818507	Bacteria	Bacteria	52.4	1.07e-5	NR	MEO0811888.1	2818507	g27250	i0	62.5	0.875	32	12	44.4	0	43	138	163	194	MEO0811888.1 hypothetical protein [Myxococcota bacterium]	diamond	189	52.4	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32066845	32066845	PRJNA404067_P_NODE_19878_length_237_cov_1.681818_g19491_i0	PRJNA404067	19878	237	1.681818	3.98590866	Myxococcota bacterium	2818507	Bacteria	Bacteria	42.7	0.0339	NR	MBU1534565.1	2818507	g19491	i0	38.2	0.860759493670886	68	40	86.1	1	205	2	410	475	MBU1534565.1 PilZ domain-containing protein [Myxococcota bacterium]	diamond	204	42.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32098549	32098549	PRJNA404067_P_NODE_19018_length_240_cov_1.150838_g18631_i0	PRJNA404067	19018	240	1.150838	2.7620112	Myxococcota bacterium	2818507	Bacteria	Bacteria	147	7.91e-39	NR	MEZ4319978.1	2818507	g18631	i0	88.8	1	80	9	100	0	240	1	627	706	MEZ4319978.1 glutamate-cysteine ligase family protein [Myxococcota bacterium]	diamond	240	147	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32257151	32257151	PRJNA404067_P_NODE_35698_length_204_cov_0.895105_g35311_i0	PRJNA404067	35698	204	0.895105	1.8260142	Labilithrix sp.	1971228	Bacteria	Bacteria	88.6	4.51e-20	NR	MDB4946207.1	1971228	g35311	i0	67.6	1	68	16	91.2	1	18	203	1	68	MDB4946207.1 hypothetical protein [Labilithrix sp.]	diamond	204	88.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
32904600	32904600	PRJNA404067_P_NODE_26320_length_219_cov_2.449367_g25933_i0	PRJNA404067	26320	219	2.449367	5.36411373	Myxococcia	32015	Bacteria	Bacteria	114	1.88e-30	NR	MBA3395842.1	2026735	g25933	i0	81.3	22.1506849315068	64	12	87.7	0	14	205	66	129	MBA3395842.1 Co2+/Mg2+ efflux protein ApaG [Deltaproteobacteria bacterium]	diamond	4851	114	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);;