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

21 rows where analysis = "blastn", bioproject = "PRJNA853203" 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
841360	841360	PRJNA853203_P_NODE_19281_length_268_cov_1.020513_g19132_i0	PRJNA853203	19281	268	1.020513	2.73497484	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	165	3.02e-36	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g19132	i0	78.764	7.28358208955224	259	45	95	9	15	268	122639	122892	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	1952	165	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
841485	841485	PRJNA853203_P_NODE_37641_length_247_cov_0.896552_g37492_i0	PRJNA853203	37641	247	0.896552	2.21448344	Myxococcus stipitatus	83455	Bacteria	Bacteria	134	7.750000000000001e-27	NTclustered	gi\|441484664\|gb\|CP004025.1\|	1278073	g37492	i0	77.328	4.73684210526316	247	42	97	13	1	240	3008012	3008251	Myxococcus stipitatus DSM 14675, complete genome	blastn	1170	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
841569	841569	PRJNA853203_P_NODE_48841_length_236_cov_3.601227_g48692_i0	PRJNA853203	48841	236	3.601227	8.49889572	Pendulispora brunnea	2905690	Bacteria	Bacteria	156	1.57e-33	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g48692	i0	78.814	1	236	46	99	4	1	234	4079884	4080117	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	236	156	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
2116879	2116879	PRJNA853203_P_NODE_40282_length_246_cov_0.901734_g40133_i0	PRJNA853203	40282	246	0.901734	2.21826564	Archangium gephyra	48	Bacteria	Bacteria	263	9.430000000000001e-66	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g40133	i0	89.524	88.2317073170732	210	18	85	3	39	246	8064298	8064505	Archangium gephyra strain DSM 2261, complete genome	blastn	21705	263	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
5944759	5944759	PRJNA853203_P_NODE_48605_length_239_cov_2.283133_g48456_i0	PRJNA853203	48605	239	2.283133	5.45668787	Pendulispora brunnea	2905690	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g48456	i0	100	0.117154811715481	28	0	12	0	160	187	9522803	9522830	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
6338709	6338709	PRJNA853203_P_NODE_47145_length_242_cov_0.923077_g46996_i0	PRJNA853203	47145	242	0.923077	2.23384634	Archangium	47	Bacteria	Bacteria	281	2.55e-71	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g46996	i0	88.136	98.595041322314	236	28	98	0	7	242	8300581	8300346	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	23860	281	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
9769327	9769327	PRJNA853203_P_NODE_11108_length_286_cov_1.464789_g10959_i0	PRJNA853203	11108	286	1.464789	4.18929654	Sorangium cellulosum	56	Bacteria	Bacteria	226	1.47e-54	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g10959	i0	85.268	7.48251748251748	224	28	78	5	34	255	7163690	7163470	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	2140	226	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9769378	9769378	PRJNA853203_P_NODE_1668_length_473_cov_1.612500_g1521_i0	PRJNA853203	1668	473	1.6125	7.627125	Labilithrix luteola	1391654	Bacteria	Bacteria	630	4.649999999999999e-176	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1521	i0	90.698	166.348837209302	473	44	100	0	1	473	3942258	3941786	Labilithrix luteola strain DSM 27648, complete genome	blastn	78683	630	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
9769380	9769380	PRJNA853203_P_NODE_16908_length_273_cov_1.230000_g16759_i0	PRJNA853203	16908	273	1.23	3.3579	Archangium violaceum	83451	Bacteria	Bacteria	265	2.96e-66	NTclustered	gi\|2579675135\|gb\|CP043493.1\|	83451	g16759	i0	85.769	152.157509157509	260	26	93	10	10	262	12650657	12650402	Archangium violaceum strain Cbvi 34 chromosome, complete genome	blastn	41539	265	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
11044991	11044991	PRJNA853203_P_NODE_15309_length_276_cov_1.837438_g15160_i0	PRJNA853203	15309	276	1.837438	5.07132888	Archangium gephyra	48	Bacteria	Bacteria	176	1.44e-39	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g15160	i0	84.916	4.06521739130435	179	22	64	5	14	189	7133616	7133440	Archangium gephyra strain DSM 2261, complete genome	blastn	1122	176	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
13595115	13595115	PRJNA853203_P_NODE_20991_length_264_cov_1.481675_g20842_i0	PRJNA853203	20991	264	1.481675	3.911622	Minicystis rosea	888845	Bacteria	Bacteria	191	4.899999999999998e-44	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g20842	i0	80.972	2.03787878787879	247	42	92	5	5	247	2856149	2856394	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	538	191	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
17419606	17419606	PRJNA853203_P_NODE_24574_length_256_cov_2.147541_g24425_i0	PRJNA853203	24574	256	2.147541	5.49770496	Polyangium aurulentum	2567896	Bacteria	Bacteria	278	3.53e-70	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g24425	i0	86.328	77.5390625	256	33	99	2	2	256	1528491	1528745	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	19850	278	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
18692643	18692643	PRJNA853203_P_NODE_14875_length_277_cov_1.529412_g14726_i0	PRJNA853203	14875	277	1.529412	4.23647124	Chondromyces crocatus	52	Bacteria	Bacteria	171	6.74e-38	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g14726	i0	82.039	3.79783393501805	206	32	73	4	42	244	11140159	11140362	Chondromyces crocatus strain Cm c5, complete genome	blastn	1052	171	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
18692860	18692860	PRJNA853203_P_NODE_44755_length_243_cov_1.605882_g44606_i0	PRJNA853203	44755	243	1.605882	3.90229326	Labilithrix luteola	1391654	Bacteria	Bacteria	63.9	1.01e-5	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g44606	i0	87.273	0.226337448559671	55	7	23	0	112	166	10720212	10720266	Labilithrix luteola strain DSM 27648, complete genome	blastn	55	63.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19086230	19086230	PRJNA853203_P_NODE_41735_length_245_cov_0.906977_g41586_i0	PRJNA853203	41735	245	0.906977	2.22209365	Sorangium	39643	Bacteria	Bacteria	102	2.16e-17	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g41586	i0	85.149	1.67755102040816	101	13	41	2	5	104	5293358	5293259	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	411	102	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19967893	19967893	PRJNA853203_P_NODE_1656_length_474_cov_1.653367_g1509_i0	PRJNA853203	1656	474	1.653367	7.83695958	Labilithrix luteola	1391654	Bacteria	Bacteria	669	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1509	i0	92.178	114.926160337553	473	37	99	0	1	473	3943489	3943017	Labilithrix luteola strain DSM 27648, complete genome	blastn	54475	669	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19968132	19968132	PRJNA853203_P_NODE_48216_length_242_cov_0.923077_g48067_i0	PRJNA853203	48216	242	0.923077	2.23384634	Sorangium cellulosum	56	Bacteria	Bacteria	132	2.7200000000000003e-26	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g48067	i0	82.781	3.10330578512397	151	22	62	4	77	225	3093488	3093636	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	751	132	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22518197	22518197	PRJNA853203_P_NODE_33098_length_249_cov_2.414773_g32949_i0	PRJNA853203	33098	249	2.414773	6.01278477	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	159	1.29e-34	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g32949	i0	88.06	53.8393574297189	134	16	54	0	8	141	5868566	5868699	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	13406	159	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
23793681	23793681	PRJNA853203_P_NODE_33479_length_249_cov_1.454545_g33330_i0	PRJNA853203	33479	249	1.454545	3.62181705	Labilithrix luteola	1391654	Bacteria	Bacteria	161	3.59e-35	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g33330	i0	79.747	1.61044176706827	237	37	92	11	18	247	7774542	7774774	Labilithrix luteola strain DSM 27648, complete genome	blastn	401	161	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
25067578	25067578	PRJNA853203_P_NODE_33120_length_249_cov_2.232955_g32971_i0	PRJNA853203	33120	249	2.232955	5.56005795	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	231	2.7e-56	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g32971	i0	83.794	83.8955823293173	253	31	99	9	1	247	4201159	4200911	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	20890	231	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
25461336	25461336	PRJNA853203_P_NODE_29320_length_252_cov_0.871508_g29171_i0	PRJNA853203	29320	252	0.871508	2.19620016	Sorangium	39643	Bacteria	Bacteria	318	2.0399999999999996e-82	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g29171	i0	89.6	53.5515873015873	250	26	99	0	3	252	14056698	14056947	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	13495	320	0.99375	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);;