metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA917598" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA917598" 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
2172502	2172502	PRJNA917598_P_NODE_88082_length_246_cov_0.890173_g87138_i0	PRJNA917598	88082	246	0.890173	2.18982558	Chondromyces crocatus	52	Bacteria	Bacteria	261	3.39e-65	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g87138	i0	85.887	125.760162601626	248	31	100	4	1	246	1599	1844	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	30937	261	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
4725540	4725540	PRJNA917598_P_NODE_83604_length_249_cov_0.875000_g82660_i0	PRJNA917598	83604	249	0.875	2.17875	Pendulispora brunnea	2905690	Bacteria	Bacteria	246	9.629999999999999e-61	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g82660	i0	90	25.578313253012	190	19	76	0	1	190	775373	775562	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	6369	246	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
5079420	5079420	PRJNA917598_P_NODE_19504_length_528_cov_1.630769_g18567_i0	PRJNA917598	19504	528	1.630769	8.61046032	Myxococcus	32	Bacteria	Bacteria	976	0	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g18567	i0	100	313.176136363636	528	0	100	0	1	528	379881	379354	Myxococcus xanthus strain DK1050 chromosome	blastn	165357	976	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
6355303	6355303	PRJNA917598_P_NODE_29205_length_426_cov_1.130312_g28261_i0	PRJNA917598	29205	426	1.130312	4.81512912	Corallococcus	83461	Bacteria	Bacteria	279	1.73e-70	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g28261	i0	80.211	214.241784037559	379	69	88	6	51	426	144187	143812	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	91267	279	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
7273647	7273647	PRJNA917598_P_NODE_18946_length_536_cov_1.643629_g18009_i0	PRJNA917598	18946	536	1.643629	8.80985144	Pendulispora rubella	2741070	Bacteria	Bacteria	673	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g18009	i0	89.425	130.738805970149	539	50	100	7	1	536	9852521	9853055	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	70076	673	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
10180296	10180296	PRJNA917598_P_NODE_78748_length_252_cov_1.832402_g77804_i0	PRJNA917598	78748	252	1.832402	4.61765304	Myxococcus	32	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|648821865\|gb\|KJ611191.1\|	34	g77804	i0	100	130	252	0	100	0	1	252	413	664	Myxococcus xanthus strain E-G(E)-1 16S ribosomal RNA gene, partial sequence	blastn	32760	466	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
10180306	10180306	PRJNA917598_P_NODE_7968_length_850_cov_4.347490_g7141_i0	PRJNA917598	7968	850	4.34749	36.953665	Haliangium	162027	Bacteria	Bacteria	806	0	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g7141	i0	84.36	144.082352941176	844	108	98	16	21	850	944	1777	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	122470	806	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
12730934	12730934	PRJNA917598_P_NODE_60070_length_291_cov_1.206422_g59126_i0	PRJNA917598	60070	291	1.206422	3.51068802	Myxococcus	32	Bacteria	Bacteria	538	1.6999999999999994e-148	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g59126	i0	100	243.463917525773	291	0	100	0	1	291	380160	379870	Myxococcus xanthus strain DK1050 chromosome	blastn	70848	538	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
13650451	13650451	PRJNA917598_P_NODE_75071_length_261_cov_1.500000_g74127_i0	PRJNA917598	75071	261	1.5	3.915	Archangium gephyra	48	Bacteria	Bacteria	244	3.66e-60	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g74127	i0	87.5	145.448275862069	216	21	81	5	24	234	108595	108381	Archangium gephyra strain DSM 2261, complete genome	blastn	37962	244	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
14923151	14923151	PRJNA917598_P_NODE_10012_length_754_cov_5.615272_g9122_i0	PRJNA917598	10012	754	5.615272	42.33915088	Labilithrix luteola	1391654	Bacteria	Bacteria	979	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9122	i0	90.132	115.862068965517	760	65	99	7	1	753	7089933	7090689	Labilithrix luteola strain DSM 27648, complete genome	blastn	87360	979	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17829027	17829027	PRJNA917598_P_NODE_60194_length_290_cov_2.870968_g59250_i0	PRJNA917598	60194	290	2.870968	8.3258072	Nannocystis	53	Bacteria	Bacteria	326	1.43e-84	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g59250	i0	86.986	141.675862068966	292	34	100	4	1	290	54	343	N.exedens 23S rRNA gene	blastn	41086	326	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
21653231	21653231	PRJNA917598_P_NODE_13057_length_654_cov_2.987952_g12130_i0	PRJNA917598	13057	654	2.987952	19.54120608	Myxococcia	32015	Bacteria	Bacteria	808	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g12130	i0	89.457	120.22629969419	645	61	98	6	16	654	7090495	7089852	Labilithrix luteola strain DSM 27648, complete genome	blastn	78628	808	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21653909	21653909	PRJNA917598_P_NODE_88157_length_246_cov_0.890173_g87213_i0	PRJNA917598	88157	246	0.890173	2.18982558	Myxococcus	32	Bacteria	Bacteria	448	2.4299999999999995e-121	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g87213	i0	99.592	264.170731707317	245	1	99	0	1	245	380414	380658	Myxococcus xanthus strain DK1050 chromosome	blastn	64986	448	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);;