metadata: contig_metadata: 31 rows where bioproject = "PRJNA293022" and tax

31 rows where bioproject = "PRJNA293022" 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
1059684	1059684	PRJNA293022_P_NODE_20641_length_313_cov_2.818182_g19904_i0	PRJNA293022	20641	313	2.818182	8.82090966	Anaeromyxobacter	161492	Bacteria	Bacteria	226	1.63e-54	NTclustered	gi\|470477744\|ref\|NR_076406.1\|	161493	g19904	i0	80.368	83.7923322683706	326	41	99	15	3	311	501	182	Anaeromyxobacter dehalogenans strain 2CP-C 23S ribosomal RNA gene, complete sequence	blastn	26227	226	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
2334930	2334930	PRJNA293022_P_NODE_32422_length_246_cov_1.035533_g31685_i0	PRJNA293022	32422	246	1.035533	2.54741118	Haliangium	162027	Bacteria	Bacteria	281	2.6000000000000007e-71	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g31685	i0	87.603	218.329268292683	242	30	98	0	5	246	647	888	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	53709	281	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
2334996	2334996	PRJNA293022_P_NODE_67922_length_169_cov_0.866667_g67185_i0	PRJNA293022	67922	169	0.866667	1.46466723	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	57	1.27e-8	NR	MFO0595143.1	2484252	g67185	i0	49.1	0.976331360946746	55	28	97.6	0	168	4	1	55	MFO0595143.1 cytochrome c [Myxococcaceae bacterium]	diamond	165	57	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
3610165	3610165	PRJNA293022_P_NODE_1743_length_985_cov_7.525641_g1350_i0	PRJNA293022	1743	985	7.525641	74.12756385	Myxococcia	32015	Bacteria	Bacteria	1164	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1350	i0	88.052	178.621319796954	996	101	99	15	3	985	3941810	3942800	Labilithrix luteola strain DSM 27648, complete genome	blastn	175942	1164	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3610185	3610185	PRJNA293022_P_NODE_28463_length_263_cov_97.210280_g27726_i0	PRJNA293022	28463	263	97.21028	255.6630364	Archangiaceae	39	Bacteria	Bacteria	359	1.26e-94	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g27726	i0	93.061	319.737642585551	245	17	100	0	1	245	5100970	5101214	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	84091	359	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
10577102	10577102	PRJNA293022_P_NODE_10929_length_433_cov_3.494792_g10194_i0	PRJNA293022	10929	433	3.494792	15.13244936	Labilithrix luteola	1391654	Bacteria	Bacteria	472	2.71e-128	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10194	i0	86.56	317.549653579677	439	46	99	10	1	432	3942248	3941816	Labilithrix luteola strain DSM 27648, complete genome	blastn	137499	472	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10577167	10577167	PRJNA293022_P_NODE_27949_length_266_cov_2.682028_g27212_i0	PRJNA293022	27949	266	2.682028	7.13419448	Labilithrix luteola	1391654	Bacteria	Bacteria	257	4.8e-64	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g27212	i0	84.906	5.31203007518797	265	29	97	9	8	265	7915575	7915835	Labilithrix luteola strain DSM 27648, complete genome	blastn	1413	257	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11851818	11851818	PRJNA293022_P_NODE_10010_length_452_cov_7.183623_g9277_i0	PRJNA293022	10010	452	7.183623	32.46997596	Labilithrix luteola	1391654	Bacteria	Bacteria	745	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9277	i0	96.452	196.997787610619	451	16	99	0	2	452	3943882	3944332	Labilithrix luteola strain DSM 27648, complete genome	blastn	89043	745	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12538183	12538183	PRJNA293022_P_NODE_31530_length_249_cov_3.345000_g30793_i0	PRJNA293022	31530	249	3.345	8.32905	Stigmatella	40	Bacteria	Bacteria	278	3.42e-70	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g30793	i0	87.243	232.232931726908	243	31	98	0	5	247	1309	1551	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	57826	278	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
13813038	13813038	PRJNA293022_P_NODE_17931_length_337_cov_3.652778_g17194_i0	PRJNA293022	17931	337	3.652778	12.30986186	Myxococcales	29	Bacteria	Bacteria	298	3.7e-76	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g17194	i0	83.235	259.237388724036	340	41	98	12	1	330	389675	390008	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	87363	298	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
14402220	14402220	PRJNA293022_P_NODE_42052_length_215_cov_2.072289_g41315_i0	PRJNA293022	42052	215	2.072289	4.45542135	Labilithrix luteola	1391654	Bacteria	Bacteria	246	8.1e-61	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g41315	i0	87.793	158.186046511628	213	22	98	4	1	211	3941979	3941769	Labilithrix luteola strain DSM 27648, complete genome	blastn	34010	246	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15675906	15675906	PRJNA293022_P_NODE_12033_length_411_cov_9.127072_g11296_i0	PRJNA293022	12033	411	9.127072	37.51226592	Labilithrix luteola	1391654	Bacteria	Bacteria	649	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g11296	i0	95.134	168.333333333333	411	20	100	0	1	411	3942390	3942800	Labilithrix luteola strain DSM 27648, complete genome	blastn	69185	649	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16362156	16362156	PRJNA293022_P_NODE_21193_length_309_cov_1.730769_g20456_i0	PRJNA293022	21193	309	1.730769	5.34807621	Archangiaceae	39	Bacteria	Bacteria	388	1.94e-103	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g20456	i0	89.61	309.323624595469	308	29	99	3	1	307	2320	2015	S.aurantiaca 23S rRNA gene	blastn	95581	388	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
18911127	18911127	PRJNA293022_P_NODE_36455_length_231_cov_3.109890_g35718_i0	PRJNA293022	36455	231	3.10989	7.1838459	root	1	Root_unresolved	Root_unresolved	401	1.7799999999999992e-107	NTclustered	gi\|1143709091\|gb\|KX572848.1\|	35	g35718	i0	98.253	101.125541125541	229	4	99	0	1	229	778	550	Myxococcus macrosporus strain 102 16S ribosomal RNA gene, partial sequence	blastn	23360	401	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
18911205	18911205	PRJNA293022_P_NODE_70375_length_167_cov_1.161017_g69638_i0	PRJNA293022	70375	167	1.161017	1.93889839	Nannocystis	53	Bacteria	Bacteria	200	4.73e-47	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g69638	i0	88.554	63.6586826347305	166	17	99	2	3	167	944	1108	N.exedens 23S rRNA gene	blastn	10631	200	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
20185815	20185815	PRJNA293022_P_NODE_60176_length_179_cov_1.592308_g59439_i0	PRJNA293022	60176	179	1.592308	2.85023132	Archangiaceae	39	Bacteria	Bacteria	254	3.87e-63	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g59439	i0	93.529	248.949720670391	170	11	95	0	9	178	398350	398181	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	44562	254	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
20774994	20774994	PRJNA293022_P_NODE_8457_length_492_cov_2.455982_g7731_i0	PRJNA293022	8457	492	2.455982	12.08343144	Labilithrix luteola	1391654	Bacteria	Bacteria	797	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g7731	i0	96.107	134.508130081301	488	19	99	0	3	490	3942063	3942550	Labilithrix luteola strain DSM 27648, complete genome	blastn	66178	797	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21461475	21461475	PRJNA293022_P_NODE_45537_length_207_cov_0.949367_g44800_i0	PRJNA293022	45537	207	0.949367	1.96518969	Sorangium	39643	Bacteria	Bacteria	281	2.12e-71	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g44800	i0	92	135.222222222222	200	16	97	0	3	202	1619	1818	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	27991	281	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22049830	22049830	PRJNA293022_P_NODE_6158_length_572_cov_26.250478_g5456_i0	PRJNA293022	6158	572	26.250478	150.15273416	Labilithrix luteola	1391654	Bacteria	Bacteria	640	9.469999999999998e-179	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5456	i0	86.942	128.456293706294	582	61	100	14	1	572	7915781	7915205	Labilithrix luteola strain DSM 27648, complete genome	blastn	73477	640	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22736540	22736540	PRJNA293022_P_NODE_47898_length_201_cov_3.309211_g47161_i0	PRJNA293022	47898	201	3.309211	6.65151411	Myxococcus	32	Bacteria	Bacteria	368	1.53e-97	NTclustered	gi\|545790940\|gb\|KF270703.1\|	33	g47161	i0	100	226.781094527363	199	0	99	0	3	201	191	389	Myxococcus fulvus strain Mxf428 23S ribosomal RNA gene, partial sequence	blastn	45583	368	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
22736603	22736603	PRJNA293022_P_NODE_70878_length_167_cov_0.881356_g70141_i0	PRJNA293022	70878	167	0.881356	1.47186452	Stigmatella	40	Bacteria	Bacteria	231	1.68e-56	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g70141	i0	92.121	28.2395209580838	165	11	98	2	4	167	263	426	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	4716	231	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
24599324	24599324	PRJNA293022_P_NODE_28140_length_265_cov_2.861111_g27403_i0	PRJNA293022	28140	265	2.861111	7.58194415	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	477	3.369999999999999e-130	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g27403	i0	99.242	224.51320754717	264	2	99	0	1	264	2161851	2161588	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	59496	477	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
24599518	24599518	PRJNA293022_P_NODE_70600_length_167_cov_0.881356_g69863_i0	PRJNA293022	70600	167	0.881356	1.47186452	Archangium violaceum	83451	Bacteria	Bacteria	139	1.05e-28	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g69863	i0	82.716	28.3712574850299	162	23	96	4	3	163	1675022	1675179	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	4738	139	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
25285843	25285843	PRJNA293022_P_NODE_61580_length_177_cov_1.398438_g60843_i0	PRJNA293022	61580	177	1.398438	2.47523526	Pendulispora	3375062	Bacteria	Bacteria	158	3.0799999999999998e-34	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g60843	i0	83.333	673.220338983051	180	20	99	10	3	177	7289089	7288915	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	119160	158	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
27863783	27863783	PRJNA293022_P_NODE_68985_length_168_cov_0.873950_g68248_i0	PRJNA293022	68985	168	0.87395	1.468236	Myxococcales bacterium	2026763	Bacteria	Bacteria	40.4	0.027	NR	HBQ13286.1	2026763	g68248	i0	40	0.714285714285714	40	24	71.4	0	149	30	18	57	HBQ13286.1 fatty acid hydroxylase [Myxococcales bacterium]	diamond	120	40.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29302330	29302330	PRJNA293022_P_NODE_69089_length_168_cov_0.873950_g68352_i0	PRJNA293022	69089	168	0.87395	1.468236	Bacteria	2	Bacteria	Bacteria	64.7	2.48e-10	NR	MFP6665302.1	2026735	g68352	i0	53.8	3.98214285714286	52	21	92.9	1	13	168	877	925	MFP6665302.1 DUF4215 domain-containing protein [Deltaproteobacteria bacterium]	diamond	669	64.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29965521	29965521	PRJNA293022_P_NODE_77451_length_163_cov_0.912281_g76714_i0	PRJNA293022	77451	163	0.912281	1.48701803	Bacteria	2	Bacteria	Bacteria	103	5.460000000000001e-26	NR	MAI79276.1	2026735	g76714	i0	86.8	14.6319018404908	53	7	97.5	0	160	2	73	125	MAI79276.1 lipid-transfer protein [Deltaproteobacteria bacterium]	diamond	2385	104	0.990384615384615	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30264075	30264075	PRJNA293022_P_NODE_43812_length_211_cov_1.179012_g43075_i0	PRJNA293022	43812	211	1.179012	2.48771532	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	51.6	1.85e-5	NR	MBN2496246.1	2026735	g43075	i0	43.8	1.81990521327014	73	37	98.1	3	2	208	69	141	MBN2496246.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	384	51.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30579474	30579474	PRJNA293022_P_NODE_78993_length_162_cov_0.920354_g78256_i0	PRJNA293022	78993	162	0.920354	1.49097348	Polyangiales bacterium	3034171	Bacteria	Bacteria	90.9	1.26e-19	NR	MFO0561589.1	3034171	g78256	i0	80.8	1.92592592592593	52	10	96.3	0	5	160	409	460	MFO0561589.1 NAD(P)/FAD-dependent oxidoreductase [Polyangiales bacterium]	diamond	312	90.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
30863995	30863995	PRJNA293022_P_NODE_77034_length_163_cov_0.912281_g76297_i0	PRJNA293022	77034	163	0.912281	1.48701803	Myxococcales bacterium	2026763	Bacteria	Bacteria	50.8	8.58e-6	NR	MCA9774536.1	2026763	g76297	i0	55	0.736196319018405	40	18	73.6	0	5	124	45	84	MCA9774536.1 hypothetical protein [Myxococcales bacterium]	diamond	120	50.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32886621	32886621	PRJNA293022_P_NODE_77320_length_163_cov_0.912281_g76583_i0	PRJNA293022	77320	163	0.912281	1.48701803	Myxococcales bacterium	2026763	Bacteria	Bacteria	99.8	1.08e-22	NR	MBL8685704.1	2026763	g76583	i0	86.8	1.95092024539877	53	7	97.5	0	4	162	1297	1349	MBL8685704.1 hypothetical protein [Myxococcales bacterium]	diamond	318	99.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales 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);;