metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA681822" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA681822" 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
653928	653928	PRJNA681822_P_NODE_296961_length_275_cov_1.292079_g295472_i0	PRJNA681822	296961	275	1.292079	3.55321725	Minicystis rosea	888845	Bacteria	Bacteria	311	3.78e-80	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g295472	i0	87.546	293.607272727273	273	29	97	4	1	268	768867	769139	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	80742	311	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
1170045	1170045	PRJNA681822_P_NODE_184881_length_317_cov_1.721311_g183393_i0	PRJNA681822	184881	317	1.721311	5.45655587	Myxococcia	32015	Bacteria	Bacteria	348	3.3800000000000003e-91	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g183393	i0	86.901	213.403785488959	313	37	98	4	7	317	2211	2521	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	67649	351	0.991452991452991	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
3721696	3721696	PRJNA681822_P_NODE_16123_length_949_cov_2.213470_g15009_i0	PRJNA681822	16123	949	2.21347	21.0058303	Polyangiaceae	49	Bacteria	Bacteria	1214	0	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g15009	i0	89.789	146.690200210748	950	93	100	4	1	949	3690916	3689970	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	139209	1225	0.991020408163265	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4481860	4481860	PRJNA681822_P_NODE_285204_length_278_cov_1.258537_g283715_i0	PRJNA681822	285204	278	1.258537	3.49873286	Nannocystis exedens	54	Bacteria	Bacteria	176	1.46e-39	NTclustered	gi\|1493631844\|gb\|MH908893.1\|	54	g283715	i0	78.731	26.4172661870504	268	54	96	3	9	274	4747	4481	Nannocystis exedens strain MNa3061 t3pks biosynthetic gene cluster, complete sequence	blastn	7344	176	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
4482467	4482467	PRJNA681822_P_NODE_338724_length_264_cov_0.895288_g337235_i0	PRJNA681822	338724	264	0.895288	2.36356032	Archangium violaceum	83451	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g337235	i0	90.698	0.162878787878788	43	2	16	2	118	158	918750	918708	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	43	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
4484940	4484940	PRJNA681822_P_NODE_71504_length_446_cov_1.238606_g70030_i0	PRJNA681822	71504	446	1.238606	5.52418276	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	248	5.13e-61	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g70030	i0	79.772	0.786995515695067	351	63	78	7	1	347	3810947	3810601	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	351	248	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
4998687	4998687	PRJNA681822_P_NODE_233164_length_290_cov_1.829493_g231675_i0	PRJNA681822	233164	290	1.829493	5.3055297	Sorangium	39643	Bacteria	Bacteria	307	5.1900000000000005e-79	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g231675	i0	85.906	68.5758620689655	298	30	99	7	1	288	1471	1766	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	19887	307	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4999220	4999220	PRJNA681822_P_NODE_408004_length_249_cov_0.875000_g406515_i0	PRJNA681822	408004	249	0.875	2.17875	Myxococcus	32	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g406515	i0	100	18	249	0	100	0	1	249	522155	521907	Myxococcus xanthus strain DK1050 chromosome	blastn	4482	460	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
4999417	4999417	PRJNA681822_P_NODE_475184_length_242_cov_0.857988_g473694_i0	PRJNA681822	475184	242	0.857988	2.07633096	Myxococcus	32	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g473694	i0	99.587	88.9669421487603	242	1	100	0	1	242	4454071	4454312	Myxococcus xanthus strain DK1050 chromosome	blastn	21530	442	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
10099283	10099283	PRJNA681822_P_NODE_346488_length_261_cov_2.090426_g344999_i0	PRJNA681822	346488	261	2.090426	5.45601186	Polyangiales	3031712	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|409969077\|gb\|JQ700683.1\|	453118	g344999	i0	100	100.609195402299	261	0	100	0	1	261	369	629	Uncultured Chondromyces sp. clone 40-3_34 16S ribosomal RNA gene, partial sequence	blastn	26259	483	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	uncultured Chondromyces sp.
10099553	10099553	PRJNA681822_P_NODE_434568_length_246_cov_0.890173_g433079_i0	PRJNA681822	434568	246	0.890173	2.18982558	Myxococcus	32	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g433079	i0	99.187	56.5731707317073	246	2	100	0	1	246	2720241	2720486	Myxococcus xanthus strain DK1050 chromosome	blastn	13917	444	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
10856183	10856183	PRJNA681822_P_NODE_152589_length_339_cov_3.056391_g151101_i0	PRJNA681822	152589	339	3.056391	10.36116549	Labilithrix luteola	1391654	Bacteria	Bacteria	569	7.149999999999998e-158	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g151101	i0	97.041	163.890855457227	338	10	99	0	1	338	3944264	3943927	Labilithrix luteola strain DSM 27648, complete genome	blastn	55559	569	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12133518	12133518	PRJNA681822_P_NODE_308450_length_272_cov_1.346734_g306961_i0	PRJNA681822	308450	272	1.346734	3.66311648	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	207	5.03e-49	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g306961	i0	91.946	3.17279411764706	149	11	55	1	111	259	1017623	1017476	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	863	207	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
12650344	12650344	PRJNA681822_P_NODE_481190_length_241_cov_0.916667_g479700_i0	PRJNA681822	481190	241	0.916667	2.20916747	Myxococcus	32	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g479700	i0	100	19.9253112033195	241	0	100	0	1	241	5158791	5159031	Myxococcus xanthus strain DK1050 chromosome	blastn	4802	446	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
15198726	15198726	PRJNA681822_P_NODE_207372_length_304_cov_1.333333_g205884_i0	PRJNA681822	207372	304	1.333333	4.05333232	root	1	Root_unresolved	Root_unresolved	396	1.14e-105	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g205884	i0	90.196	164.042763157895	306	26	100	4	1	304	3690344	3690647	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	49869	396	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15199455	15199455	PRJNA681822_P_NODE_427572_length_247_cov_0.885057_g426083_i0	PRJNA681822	427572	247	0.885057	2.18609079	Myxococcus	32	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g426083	i0	100	24.4453441295547	247	0	100	0	1	247	5442025	5442271	Myxococcus xanthus strain DK1050 chromosome	blastn	6038	457	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
18507744	18507744	PRJNA681822_P_NODE_426495_length_247_cov_0.885057_g425006_i0	PRJNA681822	426495	247	0.885057	2.18609079	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	364	2.519999999999999e-96	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g425006	i0	94.142	41.7246963562753	239	14	97	0	3	241	1771815	1772053	Anaeromyxobacter oryzae DNA, complete genome	blastn	10306	364	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
19021883	19021883	PRJNA681822_P_NODE_192255_length_312_cov_9.481172_g190767_i0	PRJNA681822	192255	312	9.481172	29.58125664	Myxococcus	32	Bacteria	Bacteria	577	3.89e-160	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g190767	i0	100	56.1346153846154	312	0	100	0	1	312	2527661	2527350	Myxococcus xanthus strain DK1050 chromosome	blastn	17514	577	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
20296590	20296590	PRJNA681822_P_NODE_247056_length_287_cov_1.439252_g245567_i0	PRJNA681822	247056	287	1.439252	4.13065324	Anaeromyxobacter	161492	Bacteria	Bacteria	130	1.19e-25	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g245567	i0	87.069	3.19512195121951	116	13	40	2	160	274	1735076	1734962	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	917	130	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
22332870	22332870	PRJNA681822_P_NODE_416158_length_248_cov_0.880000_g414669_i0	PRJNA681822	416158	248	0.88	2.1824	Sorangium cellulosum	56	Bacteria	Bacteria	159	1.28e-34	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g414669	i0	87.681	4.62096774193548	138	15	55	2	4	140	6594301	6594165	Sorangium cellulosum So0157-2, complete genome	blastn	1146	159	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24879559	24879559	PRJNA681822_P_NODE_242940_length_288_cov_1.432558_g241451_i0	PRJNA681822	242940	288	1.432558	4.12576704	Myxococcota bacterium	2818507	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2907625649\|emb\|OZ223209.1\|	2818507	g241451	i0	94.286	0.121527777777778	35	2	12	0	1	35	4538699	4538733	MAG: Myxococcota bacterium isolate 6e5ad1d4-156e-4916-952c-8a0b14857fe9 genome assembly, chromosome: 1	blastn	35	54.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
24879569	24879569	PRJNA681822_P_NODE_244000_length_288_cov_1.260465_g242511_i0	PRJNA681822	244000	288	1.260465	3.6301392	Sorangium cellulosum	56	Bacteria	Bacteria	193	1.5e-44	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g242511	i0	82.096	69.9513888888889	229	37	79	4	1	227	3965166	3964940	Sorangium cellulosum 'So ce 56' complete genome	blastn	20146	193	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24882061	24882061	PRJNA681822_P_NODE_445680_length_245_cov_0.895349_g444191_i0	PRJNA681822	445680	245	0.895349	2.19360505	Sorangium cellulosum	56	Bacteria	Bacteria	104	6.02e-18	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g444191	i0	88.372	1.15102040816327	86	10	35	0	54	139	3738320	3738405	Sorangium cellulosum 'So ce 56' complete genome	blastn	282	104	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
25397480	25397480	PRJNA681822_P_NODE_483520_length_241_cov_0.916667_g482030_i0	PRJNA681822	483520	241	0.916667	2.20916747	Myxococcus	32	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g482030	i0	100	36.8215767634855	241	0	100	0	1	241	6549688	6549928	Myxococcus xanthus strain DK1050 chromosome	blastn	8874	446	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus

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