metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1120060" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1120060" 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
238043	238043	PRJNA1120060_P_NODE_1450281_length_295_cov_7.490991_g1432296_i0	PRJNA1120060	1450281	295	7.490991	22.09842345	Archangium gephyra	48	Bacteria	Bacteria	207	5.52e-49	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g1432296	i0	91.391	41.5220338983051	151	13	51	0	1	151	5680741	5680891	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	12249	207	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
1524783	1524783	PRJNA1120060_P_NODE_2327122_length_260_cov_2.016043_g2309062_i0	PRJNA1120060	2327122	260	2.016043	5.2417118	Nannocystis punicea	2995304	Bacteria	Bacteria	172	1.7399999999999999e-38	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g2309062	i0	82.266	72.8576923076923	203	32	77	4	55	255	12901878	12901678	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	18943	172	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
2787990	2787990	PRJNA1120060_P_NODE_1407403_length_297_cov_4.522321_g1389421_i0	PRJNA1120060	1407403	297	4.522321	13.43129337	Minicystis rosea	888845	Bacteria	Bacteria	171	7.299999999999999e-38	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g1389421	i0	87.248	17.4713804713805	149	19	50	0	1	149	9096993	9096845	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	5189	171	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
6622018	6622018	PRJNA1120060_P_NODE_1875986_length_278_cov_0.887805_g1857970_i0	PRJNA1120060	1875986	278	0.887805	2.4680979	Archangium violaceum	83451	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g1857970	i0	100	0.100719424460432	28	0	10	0	52	79	4580578	4580551	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
7895497	7895497	PRJNA1120060_P_NODE_1775847_length_282_cov_1.215311_g1757836_i0	PRJNA1120060	1775847	282	1.215311	3.42717702	Labilithrix luteola	1391654	Bacteria	Bacteria	189	1.9e-43	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1757836	i0	86.207	52.7304964539007	174	24	62	0	31	204	7049286	7049459	Labilithrix luteola strain DSM 27648, complete genome	blastn	14870	189	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7904465	7904465	PRJNA1120060_P_NODE_2439247_length_256_cov_1.693989_g2421178_i0	PRJNA1120060	2439247	256	1.693989	4.33661184	Cystobacter fuscus	43	Bacteria	Bacteria	226	1.3e-54	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g2421178	i0	82.677	91.09375	254	44	99	0	3	256	6678776	6679029	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	23320	226	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
9180466	9180466	PRJNA1120060_P_NODE_2526088_length_253_cov_1.466667_g2508016_i0	PRJNA1120060	2526088	253	1.466667	3.71066751	Minicystis rosea	888845	Bacteria	Bacteria	291	4.4699999999999996e-74	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g2508016	i0	89.52	98.3873517786561	229	24	91	0	4	232	4866520	4866292	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	24892	291	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
11733619	11733619	PRJNA1120060_P_NODE_2731130_length_247_cov_9.879310_g2713046_i0	PRJNA1120060	2731130	247	9.87931	24.4018957	Corallococcus sp. CAG:1435	1262867	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2729058728\|emb\|OZ007028.1\|	1262867	g2713046	i0	99.595	1	247	1	100	0	1	247	1332269	1332023	MAG: Corallococcus sp. CAG:1435 isolate metabat2_pooled_hifiasm.1119 MAG genome assembly, chromosome: 1	blastn	247	451	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. CAG:1435
11736257	11736257	PRJNA1120060_P_NODE_2966930_length_242_cov_1.461538_g2948836_i0	PRJNA1120060	2966930	242	1.461538	3.53692196	Myxococcus fulvus	33	Bacteria	Bacteria	132	2.7200000000000003e-26	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g2948836	i0	79.888	5.24380165289256	179	36	74	0	37	215	397930	398108	Myxococcus fulvus 124B02, complete genome	blastn	1269	132	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
13005301	13005301	PRJNA1120060_P_NODE_2442331_length_256_cov_1.442623_g2424262_i0	PRJNA1120060	2442331	256	1.442623	3.69311488	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2108303649\|gb\|CP070673.1\|	2026735	g2424262	i0	100	0.11328125	29	0	11	0	38	66	903587	903615	MAG: Deltaproteobacteria bacterium isolate bin73 chromosome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
15552873	15552873	PRJNA1120060_P_NODE_2326193_length_260_cov_2.106952_g2308133_i0	PRJNA1120060	2326193	260	2.106952	5.4780752	Labilithrix luteola	1391654	Bacteria	Bacteria	222	1.71e-53	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2308133	i0	83.065	0.953846153846154	248	38	95	3	1	246	969384	969629	Labilithrix luteola strain DSM 27648, complete genome	blastn	248	222	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15565834	15565834	PRJNA1120060_P_NODE_3439753_length_212_cov_5.460432_g3421628_i0	PRJNA1120060	3439753	212	5.460432	11.57611584	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1950807334\|gb\|CP066680.1\|	2026735	g3421628	i0	100	0.141509433962264	30	0	14	0	157	186	95393	95422	MAG: Deltaproteobacteria bacterium isolate NC_groundwater_69_Ag_B-0.1um_32_21 chromosome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
16823051	16823051	PRJNA1120060_P_NODE_2016434_length_272_cov_1.798995_g1998401_i0	PRJNA1120060	2016434	272	1.798995	4.8932664	Myxococcales bacterium	2026763	Bacteria	Bacteria	95.3	4.09e-15	NTclustered	gi\|2108369872\|gb\|CP070650.1\|	2026763	g1998401	i0	89.333	0.275735294117647	75	8	28	0	172	246	2706979	2707053	MAG: Myxococcales bacterium isolate bin861 chromosome	blastn	75	95.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
16836440	16836440	PRJNA1120060_P_NODE_3103134_length_236_cov_2.288344_g3085033_i0	PRJNA1120060	3103134	236	2.288344	5.40049184	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	241	4.21e-59	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g3085033	i0	85.106	13.5593220338983	235	35	99	0	1	235	5269018	5268784	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	3200	241	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
16849764	16849764	PRJNA1120060_P_NODE_877834_length_312_cov_10.062762_g859906_i0	PRJNA1120060	877834	312	10.062762	31.39581744	Corallococcus sp. CAG:1435	1262867	Bacteria	Bacteria	278	4.42e-70	NTclustered	gi\|2729058728\|emb\|OZ007028.1\|	1262867	g859906	i0	100	0.96474358974359	150	0	96	0	163	312	866539	866688	MAG: Corallococcus sp. CAG:1435 isolate metabat2_pooled_hifiasm.1119 MAG genome assembly, chromosome: 1	blastn	301	278	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. CAG:1435
18100951	18100951	PRJNA1120060_P_NODE_2260655_length_262_cov_4.597884_g2242600_i0	PRJNA1120060	2260655	262	4.597884	12.04645608	Corallococcus sp. CAG:1435	1262867	Bacteria	Bacteria	457	4.34e-124	NTclustered	gi\|2729058728\|emb\|OZ007028.1\|	1262867	g2242600	i0	98.092	1	262	5	100	0	1	262	821261	821522	MAG: Corallococcus sp. CAG:1435 isolate metabat2_pooled_hifiasm.1119 MAG genome assembly, chromosome: 1	blastn	262	457	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. CAG:1435
18110940	18110940	PRJNA1120060_P_NODE_3087075_length_236_cov_5.582822_g3068974_i0	PRJNA1120060	3087075	236	5.582822	13.17545992	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1950807334\|gb\|CP066680.1\|	2026735	g3068974	i0	100	0.11864406779661	28	0	12	0	115	142	108683	108710	MAG: Deltaproteobacteria bacterium isolate NC_groundwater_69_Ag_B-0.1um_32_21 chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
20153176	20153176	PRJNA1120060_P_NODE_3405276_length_215_cov_8.471831_g3387156_i0	PRJNA1120060	3405276	215	8.471831	18.21443665	Myxococcia	32015	Bacteria	Bacteria	224	3.8e-54	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g3387156	i0	93.919	9.38139534883721	148	9	69	0	68	215	9249814	9249667	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	2017	226	0.991150442477876	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20650305	20650305	PRJNA1120060_P_NODE_2254017_length_263_cov_1.331579_g2235963_i0	PRJNA1120060	2254017	263	1.331579	3.50205277	Sorangium cellulosum	56	Bacteria	Bacteria	65.8	3.08e-6	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g2235963	i0	87.5	0.212927756653992	56	7	21	0	206	261	3755425	3755480	Sorangium cellulosum So0157-2, complete genome	blastn	56	65.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21931769	21931769	PRJNA1120060_P_NODE_2721738_length_248_cov_0.891429_g2703655_i0	PRJNA1120060	2721738	248	0.891429	2.21074392	Anaeromyxobacter sp. K	447217	Bacteria	Bacteria	207	4.52e-49	NTclustered	gi\|196170270\|gb\|CP001131.1\|	447217	g2703655	i0	86.387	77.375	191	24	77	2	57	246	2195100	2195289	Anaeromyxobacter sp. K, complete genome	blastn	19189	207	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. K
24472602	24472602	PRJNA1120060_P_NODE_2050120_length_270_cov_14.563452_g2032083_i0	PRJNA1120060	2050120	270	14.563452	39.3213204	Corallococcus sp. CAG:1435	1262867	Bacteria	Bacteria	414	2.74e-111	NTclustered	gi\|2729058728\|emb\|OZ007028.1\|	1262867	g2032083	i0	97.143	1.05555555555556	245	7	100	0	26	270	1483344	1483588	MAG: Corallococcus sp. CAG:1435 isolate metabat2_pooled_hifiasm.1119 MAG genome assembly, chromosome: 1	blastn	285	414	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. CAG:1435

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