metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA379145" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA379145" 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
1675405	1675405	PRJNA379145_P_NODE_25762_length_482_cov_20.298441_g23714_i0	PRJNA379145	25762	482	20.298441	97.83848562	Labilithrix luteola	1391654	Bacteria	Bacteria	590	8.049999999999999e-164	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g23714	i0	88.889	148.109958506224	486	45	100	9	1	482	7090389	7089909	Labilithrix luteola strain DSM 27648, complete genome	blastn	71389	590	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2349372	2349372	PRJNA379145_P_NODE_60082_length_188_cov_2.374194_g57928_i0	PRJNA379145	60082	188	2.374194	4.46348472	Stigmatella	40	Bacteria	Bacteria	303	4.03e-78	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g57928	i0	95.745	186.228723404255	188	8	100	0	1	188	567	754	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	35011	303	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
4228289	4228289	PRJNA379145_P_NODE_64324_length_174_cov_20.964539_g62170_i0	PRJNA379145	64324	174	20.964539	36.47829786	Pendulispora albinea	2741071	Bacteria	Bacteria	183	4.969999999999999e-42	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g62170	i0	85.955	256.913793103448	178	18	99	7	2	174	3590712	3590537	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	44703	183	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
5504546	5504546	PRJNA379145_P_NODE_46965_length_251_cov_3.655963_g44812_i0	PRJNA379145	46965	251	3.655963	9.17646713	Haliangium ochraceum	80816	Bacteria	Bacteria	110	1.33e-19	NTclustered	gi\|559112048\|tpe\|HG525310.1\|	502025	g44812	i0	78.022	1.43824701195219	182	34	70	5	3	178	12	193	TPA: Haliangium ochraceum DSM 14365 tmRNA gene Halia_ochra_14365	blastn	361	110	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
5504713	5504713	PRJNA379145_P_NODE_63245_length_178_cov_1.241379_g61091_i0	PRJNA379145	63245	178	1.241379	2.20965462	Corallococcus coralloides	184914	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g61091	i0	100	0.162921348314607	29	0	16	0	143	171	7491796	7491824	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
5504790	5504790	PRJNA379145_P_NODE_70865_length_157_cov_2.467742_g68710_i0	PRJNA379145	70865	157	2.467742	3.87435494	Pendulispora albinea	2741071	Bacteria	Bacteria	97.1	5.9e-16	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g68710	i0	85.567	7.32484076433121	97	8	60	6	64	157	3588064	3588157	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	1150	97.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
6176927	6176927	PRJNA379145_P_NODE_18045_length_643_cov_2.880328_g16268_i0	PRJNA379145	18045	643	2.880328	18.52050904	Stigmatella	40	Bacteria	Bacteria	761	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g16268	i0	88.062	227.782270606532	645	73	100	3	1	643	1765	1123	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	146464	761	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
6778842	6778842	PRJNA379145_P_NODE_65006_length_172_cov_53.647482_g62852_i0	PRJNA379145	65006	172	53.647482	92.27366904	Myxococcales bacterium	2026763	Bacteria	Bacteria	147	6.429999999999999e-31	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g62852	i0	82.84	328.191860465116	169	24	98	4	2	169	1310383	1310547	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	56449	147	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
8054398	8054398	PRJNA379145_P_NODE_70827_length_157_cov_12.209677_g68672_i0	PRJNA379145	70827	157	12.209677	19.16919289	Sorangium cellulosum	56	Bacteria	Bacteria	196	5.66e-46	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g68672	i0	89.241	224.917197452229	158	15	99	2	1	156	3451860	3451703	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	35312	196	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9328939	9328939	PRJNA379145_P_NODE_38768_length_314_cov_1.825623_g36617_i0	PRJNA379145	38768	314	1.825623	5.73245622	Myxococcales bacterium	2026763	Bacteria	Bacteria	300	9.5e-77	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g36617	i0	84.194	183.78025477707	310	47	99	2	1	310	1312254	1312561	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	57707	300	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
10002103	10002103	PRJNA379145_P_NODE_25648_length_484_cov_11.682927_g23603_i0	PRJNA379145	25648	484	11.682927	56.54536668	Sorangium	39643	Bacteria	Bacteria	617	3.709999999999999e-172	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g23603	i0	89.669	147.797520661157	484	50	100	0	1	484	3690524	3690041	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	71534	617	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
10604290	10604290	PRJNA379145_P_NODE_10989_length_901_cov_59.980415_g9735_i0	PRJNA379145	10989	901	59.980415	540.42353915	Chondromyces crocatus	52	Bacteria	Bacteria	1122	0	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g9735	i0	89.085	129.485016648169	907	93	100	5	1	901	1430387	1431293	Chondromyces crocatus strain Cm c5, complete genome	blastn	116666	1122	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
14429768	14429768	PRJNA379145_P_NODE_53812_length_214_cov_1.486188_g51658_i0	PRJNA379145	53812	214	1.486188	3.18044232	Labilithrix luteola	1391654	Bacteria	Bacteria	241	3.75e-59	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g51658	i0	87.037	57.1028037383178	216	24	100	4	1	214	3942012	3942225	Labilithrix luteola strain DSM 27648, complete genome	blastn	12220	241	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16978109	16978109	PRJNA379145_P_NODE_28234_length_442_cov_5.332518_g26142_i0	PRJNA379145	28234	442	5.332518	23.56972956	Minicystis rosea	888845	Bacteria	Bacteria	446	1.68e-120	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g26142	i0	85.111	205.156108597285	450	52	100	13	1	442	769269	768827	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	90679	446	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
16978163	16978163	PRJNA379145_P_NODE_32374_length_383_cov_5.014286_g30238_i0	PRJNA379145	32374	383	5.014286	19.20471538	Archangium violaceum	83451	Bacteria	Bacteria	496	1.3999999999999998e-135	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g30238	i0	90.104	244.66318537859	384	35	100	3	1	383	2689609	2689990	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	93706	496	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
17651631	17651631	PRJNA379145_P_NODE_37634_length_324_cov_134.597938_g35483_i0	PRJNA379145	37634	324	134.597938	436.09731912	Polyangiaceae	49	Bacteria	Bacteria	412	1.2099999999999997e-110	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g35483	i0	90.221	330.404320987654	317	29	97	2	1	315	3692035	3692351	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	107051	412	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18925510	18925510	PRJNA379145_P_NODE_51835_length_223_cov_45.057895_g49681_i0	PRJNA379145	51835	223	45.057895	100.47910585	root	1	Root_unresolved	Root_unresolved	357	3.75e-94	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g49681	i0	95.516	186.811659192825	223	10	100	0	1	223	632	854	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	41659	359	0.994428969359331	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
18925522	18925522	PRJNA379145_P_NODE_5935_length_1244_cov_52.815029_g5210_i0	PRJNA379145	5935	1244	52.815029	657.01896076	root	1	Root_unresolved	Root_unresolved	1171	0	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g5210	i0	83.838	137.420418006431	1256	178	99	22	2	1244	1780	537	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	170951	1182	0.990693739424704	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
20802448	20802448	PRJNA379145_P_NODE_53497_length_215_cov_2.428571_g51343_i0	PRJNA379145	53497	215	2.428571	5.22142765	Labilithrix luteola	1391654	Bacteria	Bacteria	309	1.02e-79	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g51343	i0	92.593	122.553488372093	216	15	100	1	1	215	3942317	3942532	Labilithrix luteola strain DSM 27648, complete genome	blastn	26349	309	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22077211	22077211	PRJNA379145_P_NODE_23558_length_521_cov_15.704918_g21571_i0	PRJNA379145	23558	521	15.704918	81.82262278	Chondromyces crocatus	52	Bacteria	Bacteria	540	8.94e-149	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g21571	i0	88.043	110.909788867562	460	50	87	4	1	455	1431293	1430834	Chondromyces crocatus strain Cm c5, complete genome	blastn	57784	540	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
22077221	22077221	PRJNA379145_P_NODE_24278_length_508_cov_7.640000_g22266_i0	PRJNA379145	24278	508	7.64	38.8112	Sorangium cellulosum	56	Bacteria	Bacteria	399	1.5399999999999998e-106	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g22266	i0	85.751	108.301181102362	386	45	75	10	128	507	4849348	4849729	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	55017	399	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22750826	22750826	PRJNA379145_P_NODE_30698_length_406_cov_40.115282_g28571_i0	PRJNA379145	30698	406	40.115282	162.86804492	Polyangiaceae	49	Bacteria	Bacteria	595	1.4399999999999996e-165	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g28571	i0	93.12	151.056650246305	407	26	100	2	1	406	3691554	3691959	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	61329	601	0.990016638935108	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23353096	23353096	PRJNA379145_P_NODE_62999_length_178_cov_3.124138_g60845_i0	PRJNA379145	62999	178	3.124138	5.56096564	Sorangium cellulosum	56	Bacteria	Bacteria	167	5.149999999999999e-37	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g60845	i0	83.799	79.4887640449438	179	25	99	4	1	177	4849553	4849729	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	14149	167	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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