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

13 rows where analysis = "blastn", bioproject = "PRJNA1167252" 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
1589359	1589359	PRJNA1167252_P_NODE_29202_length_242_cov_0.923077_g28929_i0	PRJNA1167252	29202	242	0.923077	2.23384634	Minicystis rosea	888845	Bacteria	Bacteria	71.3	6.02e-8	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g28929	i0	100	2.14462809917355	38	0	16	0	141	178	9184355	9184318	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	519	71.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
4868034	4868034	PRJNA1167252_P_NODE_25964_length_248_cov_0.891429_g25691_i0	PRJNA1167252	25964	248	0.891429	2.21074392	Myxococcus	32	Bacteria	Bacteria	167	7.679999999999999e-37	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g25691	i0	79.051	31.8911290322581	253	46	99	6	1	247	1471322	1471573	Myxococcus xanthus strain DK1050 chromosome	blastn	7909	167	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
6142811	6142811	PRJNA1167252_P_NODE_24865_length_249_cov_2.176136_g24592_i0	PRJNA1167252	24865	249	2.176136	5.41857864	Polyangiaceae	49	Bacteria	Bacteria	350	7.14e-92	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g24592	i0	92.095	188.502008032129	253	12	100	8	1	249	1156	1404	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	46937	353	0.991501416430595	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
6692498	6692498	PRJNA1167252_P_NODE_25986_length_248_cov_0.891429_g25713_i0	PRJNA1167252	25986	248	0.891429	2.21074392	Sorangium cellulosum	56	Bacteria	Bacteria	161	3.5699999999999995e-35	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g25713	i0	79.012	5.92338709677419	243	45	97	6	9	248	4612350	4612111	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	1469	161	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9242476	9242476	PRJNA1167252_P_NODE_23288_length_252_cov_0.871508_g23015_i0	PRJNA1167252	23288	252	0.871508	2.19620016	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	202	2.14e-47	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g23015	i0	81.275	21.7579365079365	251	45	99	2	1	250	2839751	2839502	Anaeromyxobacter oryzae DNA, complete genome	blastn	5483	202	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
10518268	10518268	PRJNA1167252_P_NODE_25609_length_248_cov_0.891429_g25336_i0	PRJNA1167252	25609	248	0.891429	2.21074392	Stigmatella aurantiaca	41	Bacteria	Bacteria	340	4.27e-89	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g25336	i0	91.532	94.6008064516129	248	19	100	2	1	248	1671	1426	S.aurantiaca 23S rRNA gene	blastn	23461	340	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
10518317	10518317	PRJNA1167252_P_NODE_27469_length_245_cov_0.906977_g27196_i0	PRJNA1167252	27469	245	0.906977	2.22209365	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	231	2.65e-56	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g27196	i0	86.301	54.4285714285714	219	22	87	8	26	239	9545296	9545081	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	13335	231	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
11243228	11243228	PRJNA1167252_P_NODE_23869_length_251_cov_0.876404_g23596_i0	PRJNA1167252	23869	251	0.876404	2.19977404	Corallococcus	83461	Bacteria	Bacteria	239	1.6300000000000002e-58	NTclustered	gi\|337255776\|gb\|CP002830.1\|	35	g23596	i0	84.647	25.5219123505976	241	35	96	2	7	246	4137113	4137352	Myxococcus macrosporus strain HW-1, complete genome	blastn	6406	239	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
14343836	14343836	PRJNA1167252_P_NODE_8252_length_444_cov_1.878706_g7979_i0	PRJNA1167252	8252	444	1.878706	8.34145464	Labilithrix luteola	1391654	Bacteria	Bacteria	538	2.7e-148	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g7979	i0	88.565	391.34009009009	446	48	100	3	1	444	3941775	3942219	Labilithrix luteola strain DSM 27648, complete genome	blastn	173755	538	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15617473	15617473	PRJNA1167252_P_NODE_28993_length_243_cov_0.917647_g28720_i0	PRJNA1167252	28993	243	0.917647	2.22988221	Sorangium cellulosum	56	Bacteria	Bacteria	121	5.92e-23	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g28720	i0	77.193	31.0987654320988	228	38	91	13	1	221	9368367	9368147	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	7557	121	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18891412	18891412	PRJNA1167252_P_NODE_18235_length_286_cov_1.009390_g17962_i0	PRJNA1167252	18235	286	1.00939	2.8868554	Myxococcia	32015	Bacteria	Bacteria	422	1.75e-113	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g17962	i0	93.38	213.447552447552	287	16	100	3	1	286	3489783	3490067	Sorangium cellulosum 'So ce 56' complete genome	blastn	61046	422	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21441702	21441702	PRJNA1167252_P_NODE_1337_length_1140_cov_2.612933_g1192_i0	PRJNA1167252	1337	1140	2.612933	29.7874362	Polyangiaceae	49	Bacteria	Bacteria	1458	0	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g1192	i0	89.712	136.147368421053	1147	111	100	6	1	1140	1446	2592	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	155208	1467	0.993865030674847	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
23266838	23266838	PRJNA1167252_P_NODE_27419_length_245_cov_0.906977_g27146_i0	PRJNA1167252	27419	245	0.906977	2.22209365	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	265	2.61e-66	NTclustered	gi\|2107977474\|gb\|CP070783.1\|	2026735	g27146	i0	91.623	5.0530612244898	191	16	78	0	45	235	755864	755674	MAG: Deltaproteobacteria bacterium isolate bin162 chromosome	blastn	1238	265	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium

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