metadata: contig_metadata: 26 rows where bioproject = "PRJNA944150", tax_kingdom = "Pseudomonadati" and tax

26 rows where bioproject = "PRJNA944150", tax_kingdom = "Pseudomonadati" 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
13677432	13677432	PRJNA944150_P_NODE_42331_length_163_cov_0.894737_g42080_i0	PRJNA944150	42331	163	0.894737	1.45842131	Myxococcus xanthus	34	Bacteria	Bacteria	159	7.779999999999998e-35	NTclustered	gi\|1691464223\|gb\|CP017171.1\|	34	g42080	i0	84.568	6.04294478527607	162	23	99	2	1	161	7039556	7039716	Myxococcus xanthus strain KF3.2.8c11 chromosome, complete genome	blastn	985	159	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
17501672	17501672	PRJNA944150_P_NODE_17274_length_210_cov_2.664596_g17023_i0	PRJNA944150	17274	210	2.664596	5.5956516	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	63.5	8.3e-11	NR	MBP1687414.1	2026735	g17023	i0	87.9	0.471428571428571	33	4	47.1	0	99	1	34	66	MBP1687414.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	99	63.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
22936787	22936787	PRJNA944150_P_NODE_16518_length_210_cov_5.111801_g16267_i0	PRJNA944150	16518	210	5.111801	10.7347821	Myxococcus	32	Bacteria	Bacteria	298	2.14e-76	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g16267	i0	90.367	23.8857142857143	218	13	100	1	1	210	3502578	3502795	Myxococcus xanthus strain DK1050 chromosome	blastn	5016	298	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
26993376	26993376	PRJNA944150_P_NODE_35722_length_167_cov_1.364407_g35471_i0	PRJNA944150	35722	167	1.364407	2.27855969	Pyxidicoccus sp. 3LG	3383247	Bacteria	Bacteria	77.4	2.19e-15	NR	MFP2930326.1	3383247	g35471	i0	69.1	1.97604790419162	55	17	98.8	0	1	165	79	133	MFP2930326.1 SDR family NAD(P)-dependent oxidoreductase [Pyxidicoccus sp. 3LG]	diamond	330	77.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus sp. 3LG
27278237	27278237	PRJNA944150_P_NODE_28083_length_181_cov_1.363636_g27832_i0	PRJNA944150	28083	181	1.363636	2.46818116	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	49.7	2.46e-5	NR	MDX2086943.1	2212474	g27832	i0	58.3	0.596685082872928	36	15	59.7	0	109	2	1	36	MDX2086943.1 PaaI family thioesterase [Kofleriaceae bacterium]	diamond	108	49.7	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
27695808	27695808	PRJNA944150_P_NODE_44664_length_161_cov_1.303571_g44413_i0	PRJNA944150	44664	161	1.303571	2.09874931	Pseudomonadati	3379134	Bacteria	Bacteria	102	2.75e-24	NR	WP_002616054.1	41	g44413	i0	88.7	4.93788819875776	53	6	98.8	0	2	160	273	325	WP_002616054.1 hypothetical protein [Stigmatella aurantiaca]	diamond	795	102	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
28390076	28390076	PRJNA944150_P_NODE_44886_length_161_cov_0.910714_g44635_i0	PRJNA944150	44886	161	0.910714	1.46624954	Archangium	47	Bacteria	Bacteria	51.2	1.14e-6	NR	MBL8910571.1	1872627	g44635	i0	95.5	1.22981366459627	22	1	41	0	2	67	64	85	MBL8910571.1 hypothetical protein [Archangium sp.]	diamond	198	51.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
28636179	28636179	PRJNA944150_P_NODE_46207_length_158_cov_3.330275_g45956_i0	PRJNA944150	46207	158	3.330275	5.2618345	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	60.5	6.47e-9	NR	MET0591273.1	2268199	g45956	i0	53.8	1.9746835443038	52	24	98.7	0	2	157	513	564	MET0591273.1 Ig-like domain-containing protein [Polyangiaceae bacterium]	diamond	312	60.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
29867367	29867367	PRJNA944150_P_NODE_47091_length_155_cov_2.839623_g46840_i0	PRJNA944150	47091	155	2.839623	4.40141565	Archangium gephyra	48	Bacteria	Bacteria	87.4	1.33e-18	NR	WP_047857745.1	48	g46840	i0	72.5	3.94838709677419	51	14	98.7	0	154	2	304	354	WP_047857745.1 NAD(P)/FAD-dependent oxidoreductase [Archangium gephyra]	diamond	612	87.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
29899029	29899029	PRJNA944150_P_NODE_32811_length_172_cov_1.487805_g32560_i0	PRJNA944150	32811	172	1.487805	2.5590246	Myxococcales bacterium	2026763	Bacteria	Bacteria	83.2	7.74e-17	NR	MCA9593600.1	2026763	g32560	i0	64.3	0.976744186046512	56	20	97.7	0	170	3	890	945	MCA9593600.1 DNA gyrase subunit B [Myxococcales bacterium]	diamond	168	83.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30025443	30025443	PRJNA944150_P_NODE_27731_length_181_cov_4.234848_g27480_i0	PRJNA944150	27731	181	4.234848	7.66507488	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	60.8	6.69e-9	NR	MBN1204746.1	2484252	g27480	i0	50	4.95580110497238	60	29	99.4	1	181	2	217	275	MBN1204746.1 M13 family metallopeptidase [Myxococcaceae bacterium]	diamond	897	60.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
30278405	30278405	PRJNA944150_P_NODE_22852_length_190_cov_3.255319_g22601_i0	PRJNA944150	22852	190	3.255319	6.1851061	Archangium sp.	1872627	Bacteria	Bacteria	77.4	1.07e-14	NR	MDP1822268.1	1872627	g22601	i0	73.7	0.9	57	15	90	0	188	18	300	356	MDP1822268.1 serine/threonine-protein kinase [Archangium sp.]	diamond	171	77.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
30341763	30341763	PRJNA944150_P_NODE_12332_length_243_cov_2.603093_g12081_i0	PRJNA944150	12332	243	2.603093	6.32551599	Nannocystis sp.	1962667	Bacteria	Bacteria	52.4	1.47e-5	NR	MBK8260160.1	1962667	g12081	i0	71.9	0.395061728395062	32	9	39.5	0	140	235	1	32	MBK8260160.1 hypothetical protein [Nannocystis sp.]	diamond	96	52.4	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
30341781	30341781	PRJNA944150_P_NODE_33672_length_170_cov_2.520661_g33421_i0	PRJNA944150	33672	170	2.520661	4.2851237	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	74.3	1e-13	NR	HVU05189.1	2268199	g33421	i0	67.3	1.90588235294118	55	18	97.1	0	4	168	406	460	HVU05189.1 carboxylesterase family protein [Polyangiaceae bacterium]	diamond	324	74.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30530705	30530705	PRJNA944150_P_NODE_41993_length_163_cov_0.894737_g41742_i0	PRJNA944150	41993	163	0.894737	1.45842131	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	65.9	8.91e-11	NR	MBK9263552.1	2268199	g41742	i0	57.4	0.993865030674847	54	23	99.4	0	162	1	806	859	MBK9263552.1 protein kinase [Polyangiaceae bacterium]	diamond	162	65.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30600694	30600694	PRJNA944150_P_NODE_28753_length_180_cov_1.061069_g28502_i0	PRJNA944150	28753	180	1.061069	1.9099242	Bacteria	2	Bacteria	Bacteria	87	1.02e-19	NR	MEI8254619.1	2026735	g28502	i0	75.4	2.85	57	14	95	0	173	3	16	72	MEI8254619.1 hypoxanthine phosphoribosyltransferase [Deltaproteobacteria bacterium]	diamond	513	87	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30657130	30657130	PRJNA944150_P_NODE_19873_length_199_cov_3.093333_g19622_i0	PRJNA944150	19873	199	3.093333	6.15573267	Myxococcota bacterium	2818507	Bacteria	Bacteria	70.9	2.41e-12	NR	MFT7622391.1	2818507	g19622	i0	70.5	1.92964824120603	44	13	66.3	0	199	68	135	178	MFT7622391.1 UDP-N-acetyl-D-glucosamine dehydrogenase [Myxococcota bacterium]	diamond	384	70.9	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30657143	30657143	PRJNA944150_P_NODE_40313_length_164_cov_0.886957_g40062_i0	PRJNA944150	40313	164	0.886957	1.45460948	Myxococcales bacterium	2026763	Bacteria	Bacteria	51.2	1.28e-5	NR	MDB4966015.1	2026763	g40062	i0	51.9	0.951219512195122	52	23	91.5	1	11	160	100	151	MDB4966015.1 hypothetical protein [Myxococcales bacterium]	diamond	156	51.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30941729	30941729	PRJNA944150_P_NODE_25754_length_185_cov_1.801471_g25503_i0	PRJNA944150	25754	185	1.801471	3.33272135	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	124	9.91e-33	NR	MBK6686445.1	2026735	g25503	i0	93.4	0.989189189189189	61	4	98.9	0	2	184	163	223	MBK6686445.1 fatty acid desaturase [Deltaproteobacteria bacterium]	diamond	183	124	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30973278	30973278	PRJNA944150_P_NODE_43814_length_162_cov_0.902655_g43563_i0	PRJNA944150	43814	162	0.902655	1.4623011	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	81.6	2.23e-16	NR	MBN8540325.1	2026735	g43563	i0	76.9	0.962962962962963	52	12	96.3	0	158	3	392	443	MBN8540325.1 transcription termination/antitermination protein NusA [Deltaproteobacteria bacterium]	diamond	156	81.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31289065	31289065	PRJNA944150_P_NODE_32495_length_172_cov_3.512195_g32244_i0	PRJNA944150	32495	172	3.512195	6.0409754	Anaeromyxobacteraceae bacterium	2510643	Bacteria	Bacteria	78.2	4.42e-15	NR	HVI73372.1	2510643	g32244	i0	83	2.52906976744186	47	8	82	0	30	170	4	50	HVI73372.1 FAD-dependent oxidoreductase [Anaeromyxobacteraceae bacterium]	diamond	435	78.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae		Anaeromyxobacteraceae bacterium
31605567	31605567	PRJNA944150_P_NODE_38536_length_165_cov_1.560345_g38285_i0	PRJNA944150	38536	165	1.560345	2.57456925	Myxococcota bacterium	2818507	Bacteria	Bacteria	87.4	2.29e-18	NR	MFC1641895.1	2818507	g38285	i0	72.2	2.94545454545455	54	15	98.2	0	2	163	197	250	MFC1641895.1 methionine--tRNA ligase [Myxococcota bacterium]	diamond	486	87.4	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31637048	31637048	PRJNA944150_P_NODE_44436_length_161_cov_1.723214_g44185_i0	PRJNA944150	44436	161	1.723214	2.77437454	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	55.1	6.92e-8	NR	MBT3259003.1	2026735	g44185	i0	46.7	0.838509316770186	45	24	83.9	0	25	159	44	88	MBT3259003.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	135	55.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31890096	31890096	PRJNA944150_P_NODE_36217_length_167_cov_0.864407_g35966_i0	PRJNA944150	36217	167	0.864407	1.44355969	Myxococcales bacterium	2026763	Bacteria	Bacteria	75.5	3.18e-14	NR	MSP60099.1	2026763	g35966	i0	64.3	1.0059880239521	56	19	98.8	1	2	166	21	76	MSP60099.1 ATP-binding protein [Myxococcales bacterium]	diamond	168	75.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32396525	32396525	PRJNA944150_P_NODE_3299_length_468_cov_2.558473_g3051_i0	PRJNA944150	3299	468	2.558473	11.97365364	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	45.4	0.0352	NR	RLB60749.1	2026735	g3051	i0	48.9	0.288461538461538	45	23	28.8	0	218	84	175	219	RLB60749.1 MAG: hypothetical protein DRI90_12965, partial [Deltaproteobacteria bacterium]	diamond	135	45.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32491523	32491523	PRJNA944150_P_NODE_28659_length_180_cov_1.290076_g28408_i0	PRJNA944150	28659	180	1.290076	2.3221368	Archangium gephyra	48	Bacteria	Bacteria	117	3.5499999999999996e-30	NR	PZR15519.1	48	g28408	i0	98.3	0.983333333333333	59	1	98.3	0	179	3	110	168	PZR15519.1 MAG: LysR family transcriptional regulator [Archangium gephyra]	diamond	177	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra

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