metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax

22 rows where analysis = "blastn", bioproject = "PRJEB58983" 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
124642	124642	PRJEB58983_P_NODE_12941_length_351_cov_5.154676_g12526_i0	PRJEB58983	12941	351	5.154676	18.09291276	Myxococcales bacterium	2026763	Bacteria	Bacteria	316	1.0699999999999999e-81	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g12526	i0	83.239	273.595441595442	352	52	99	7	2	350	1309631	1309978	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	96032	316	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
3950903	3950903	PRJEB58983_P_NODE_20284_length_288_cov_2.558140_g19869_i0	PRJEB58983	20284	288	2.55814	7.3674432	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	289	1.87e-73	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g19869	i0	86.081	115.649305555556	273	32	93	6	1	269	1515	1245	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	33307	289	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
3951062	3951062	PRJEB58983_P_NODE_27404_length_254_cov_3.585635_g26989_i0	PRJEB58983	27404	254	3.585635	9.1075129	Chondromyces crocatus	52	Bacteria	Bacteria	230	9.929999999999998e-56	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g26989	i0	87.685	122.645669291339	203	18	78	5	56	254	1380	1579	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	31152	230	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
5227690	5227690	PRJEB58983_P_NODE_35165_length_212_cov_4.187050_g34750_i0	PRJEB58983	35165	212	4.18705	8.876546	Labilithrix luteola	1391654	Bacteria	Bacteria	281	2.18e-71	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g34750	i0	90.566	107.674528301887	212	20	100	0	1	212	7090104	7090315	Labilithrix luteola strain DSM 27648, complete genome	blastn	22827	281	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6502956	6502956	PRJEB58983_P_NODE_15846_length_321_cov_4.282258_g15431_i0	PRJEB58983	15846	321	4.282258	13.74604818	Labilithrix luteola	1391654	Bacteria	Bacteria	497	3.22e-136	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g15431	i0	95.513	150.616822429907	312	12	97	2	1	311	3944268	3943958	Labilithrix luteola strain DSM 27648, complete genome	blastn	48348	497	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7777546	7777546	PRJEB58983_P_NODE_32827_length_240_cov_2.017964_g32412_i0	PRJEB58983	32827	240	2.017964	4.8431136	Labilithrix luteola	1391654	Bacteria	Bacteria	394	3.11e-105	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g32412	i0	96.25	157.225	240	9	100	0	1	240	3944029	3944268	Labilithrix luteola strain DSM 27648, complete genome	blastn	37734	394	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
9920386	9920386	PRJEB58983_P_NODE_5168_length_540_cov_2.648822_g4755_i0	PRJEB58983	5168	540	2.648822	14.3036388	Stigmatella	40	Bacteria	Bacteria	776	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g4755	i0	92.593	244.624074074074	540	40	100	0	1	540	1197	658	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	132097	778	0.997429305912596	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
10328171	10328171	PRJEB58983_P_NODE_35589_length_199_cov_5.349206_g35174_i0	PRJEB58983	35589	199	5.349206	10.64491994	Labilithrix luteola	1391654	Bacteria	Bacteria	268	1.5799999999999998e-67	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g35174	i0	91.045	11.1809045226131	201	14	100	4	1	199	7915792	7915594	Labilithrix luteola strain DSM 27648, complete genome	blastn	2225	268	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10328183	10328183	PRJEB58983_P_NODE_3909_length_617_cov_1.840074_g3504_i0	PRJEB58983	3909	617	1.840074	11.35325658	Minicystis rosea	888845	Bacteria	Bacteria	680	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g3504	i0	86.914	111.53322528363	619	65	99	15	9	616	768874	769487	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	68816	680	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
11603522	11603522	PRJEB58983_P_NODE_32490_length_242_cov_0.923077_g32075_i0	PRJEB58983	32490	242	0.923077	2.23384634	Myxococcales bacterium	2026763	Bacteria	Bacteria	274	4.27e-69	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g32075	i0	87.243	254.809917355372	243	27	99	4	1	241	1313171	1313411	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	61664	274	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
12878884	12878884	PRJEB58983_P_NODE_9331_length_408_cov_1.635821_g8917_i0	PRJEB58983	9331	408	1.635821	6.67414968	Minicystis rosea	888845	Bacteria	Bacteria	427	5.569999999999999e-115	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g8917	i0	85.961	216.377450980392	406	49	98	6	8	408	13715524	13715122	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	88282	427	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
14153350	14153350	PRJEB58983_P_NODE_25472_length_263_cov_1.152632_g25057_i0	PRJEB58983	25472	263	1.152632	3.03142216	Labilithrix luteola	1391654	Bacteria	Bacteria	377	3.49e-100	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g25057	i0	92.453	113.425855513308	265	18	100	1	1	263	3942317	3942581	Labilithrix luteola strain DSM 27648, complete genome	blastn	29831	377	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14153369	14153369	PRJEB58983_P_NODE_26932_length_256_cov_3.754098_g26517_i0	PRJEB58983	26932	256	3.754098	9.61049088	Labilithrix luteola	1391654	Bacteria	Bacteria	185	2.2e-42	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g26517	i0	80.078	7.984375	256	46	99	3	1	255	5311015	5311266	Labilithrix luteola strain DSM 27648, complete genome	blastn	2044	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16294740	16294740	PRJEB58983_P_NODE_16813_length_313_cov_2.337500_g16398_i0	PRJEB58983	16813	313	2.3375	7.316375	Corallococcus	83461	Bacteria	Bacteria	222	2.11e-53	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g16398	i0	91.018	137.584664536741	167	11	52	4	119	282	144020	144185	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	43064	222	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
18843701	18843701	PRJEB58983_P_NODE_19195_length_295_cov_1.126126_g18780_i0	PRJEB58983	19195	295	1.126126	3.3220717	Anaeromyxobacter	161492	Bacteria	Bacteria	337	6.75e-88	NTclustered	gi\|470477744\|ref\|NR_076406.1\|	161493	g18780	i0	91.2	250.352542372881	250	19	84	3	15	262	657	409	Anaeromyxobacter dehalogenans strain 2CP-C 23S ribosomal RNA gene, complete sequence	blastn	73854	337	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
18843731	18843731	PRJEB58983_P_NODE_23855_length_270_cov_2.370558_g23440_i0	PRJEB58983	23855	270	2.370558	6.4005066	Corallococcus	83461	Bacteria	Bacteria	165	3.05e-36	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g23440	i0	87.586	44.0333333333333	145	14	53	4	46	188	143736	143878	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	11889	165	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
20118705	20118705	PRJEB58983_P_NODE_556_length_1721_cov_175.076456_g247_i1	PRJEB58983	556	1721	175.076456	3013.06580776	Pendulispora	3375062	Bacteria	Bacteria	1929	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g247	i1	86.976	177.624636839047	1743	191	100	31	1	1721	9854139	9852411	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	305692	1936	0.996384297520661	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
20525807	20525807	PRJEB58983_P_NODE_22257_length_278_cov_1.395122_g21842_i0	PRJEB58983	22257	278	1.395122	3.87843916	Pseudomyxococcus hansupus	1297742	Bacteria	Bacteria	409	1.32e-109	NTclustered	gi\|891158403\|gb\|CP012109.1\|	1297742	g21842	i0	93.165	315.359712230216	278	19	100	0	1	278	1943588	1943865	Myxococcus hansupus strain mixupus chromosome, complete genome	blastn	87670	409	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pseudomyxococcus	Pseudomyxococcus hansupus
20526075	20526075	PRJEB58983_P_NODE_35397_length_205_cov_4.159091_g34982_i0	PRJEB58983	35397	205	4.159091	8.52613655	Pendulispora rubella	2741070	Bacteria	Bacteria	263	7.600000000000002e-66	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g34982	i0	89.756	136.770731707317	205	21	100	0	1	205	7289997	7289793	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	28038	263	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
20526083	20526083	PRJEB58983_P_NODE_3737_length_635_cov_3.373665_g3332_i0	PRJEB58983	3737	635	3.373665	21.42277275	Labilithrix luteola	1391654	Bacteria	Bacteria	885	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g3332	i0	92.114	194.987401574803	634	40	99	6	1	628	3941769	3942398	Labilithrix luteola strain DSM 27648, complete genome	blastn	123817	885	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21801781	21801781	PRJEB58983_P_NODE_30438_length_246_cov_3.052023_g30023_i0	PRJEB58983	30438	246	3.052023	7.50797658	Labilithrix luteola	1391654	Bacteria	Bacteria	377	3.2300000000000003e-100	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g30023	i0	94.309	122.073170731707	246	14	100	0	1	246	3943067	3943312	Labilithrix luteola strain DSM 27648, complete genome	blastn	30030	377	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24350488	24350488	PRJEB58983_P_NODE_1160_length_1196_cov_8.469279_g893_i0	PRJEB58983	1160	1196	8.469279	101.29257684	Pendulispora rubella	2741070	Bacteria	Bacteria	1559	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g893	i0	90.36	162.171404682274	1193	108	99	6	1	1191	7288851	7290038	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	193957	1559	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella

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