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

21 rows where analysis = "blastn", bioproject = "PRJNA716463" 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
707947	707947	PRJNA716463_P_NODE_43661_length_296_cov_3.004484_g43244_i0	PRJNA716463	43661	296	3.004484	8.89327264	Sorangium cellulosum	56	Bacteria	Bacteria	255	1.95e-63	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g43244	i0	82.428	48.3175675675676	313	35	99	11	1	294	2293677	2293988	Sorangium cellulosum So0157-2, complete genome	blastn	14302	255	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
708386	708386	PRJNA716463_P_NODE_72801_length_274_cov_2.164179_g72384_i0	PRJNA716463	72801	274	2.164179	5.92985046	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	167	8.609999999999999e-37	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g72384	i0	79.087	17.4671532846715	263	39	93	12	21	274	2948192	2948447	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	4786	167	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
1983506	1983506	PRJNA716463_P_NODE_14022_length_322_cov_2.216867_g13606_i0	PRJNA716463	14022	322	2.216867	7.13831174	Minicystis rosea	888845	Bacteria	Bacteria	531	3.18e-146	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g13606	i0	96.562	148.152173913043	320	11	99	0	1	320	769556	769875	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	47705	531	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
1983977	1983977	PRJNA716463_P_NODE_4422_length_486_cov_3.268765_g4020_i0	PRJNA716463	4422	486	3.268765	15.8861979	Sorangium cellulosum	56	Bacteria	Bacteria	69.4	4.7e-7	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g4020	i0	86.885	0.253086419753086	61	8	13	0	425	485	1254891	1254951	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	123	69.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1984483	1984483	PRJNA716463_P_NODE_77062_length_271_cov_1.555556_g76645_i0	PRJNA716463	77062	271	1.555556	4.21555676	Labilithrix luteola	1391654	Bacteria	Bacteria	307	4.8e-79	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g76645	i0	87.085	128.89667896679	271	35	100	0	1	271	3974911	3975181	Labilithrix luteola strain DSM 27648, complete genome	blastn	34931	307	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3259296	3259296	PRJNA716463_P_NODE_44843_length_295_cov_2.644144_g44426_i0	PRJNA716463	44843	295	2.644144	7.8002248	Labilithrix luteola	1391654	Bacteria	Bacteria	102	2.68e-17	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g44426	i0	79.72	0.484745762711864	143	27	48	2	9	150	6613004	6613145	Labilithrix luteola strain DSM 27648, complete genome	blastn	143	102	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4536158	4536158	PRJNA716463_P_NODE_3344_length_533_cov_4.463043_g2948_i0	PRJNA716463	3344	533	4.463043	23.78801919	Pendulispora brunnea	2905690	Bacteria	Bacteria	603	1.1499999999999999e-167	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g2948	i0	87.175	151.772983114447	538	59	100	8	1	533	7407530	7408062	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	80895	603	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
4537147	4537147	PRJNA716463_P_NODE_93004_length_257_cov_4.581522_g92587_i0	PRJNA716463	93004	257	4.581522	11.77451154	Stigmatella aurantiaca	41	Bacteria	Bacteria	326	1.25e-84	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g92587	i0	89.764	37.2217898832685	254	26	99	0	1	254	6721040	6721293	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	9566	326	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
4537243	4537243	PRJNA716463_P_NODE_99304_length_252_cov_0.949721_g98887_i0	PRJNA716463	99304	252	0.949721	2.39329692	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	183	7.769999999999998e-42	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g98887	i0	80.556	3.26984126984127	252	37	98	12	1	246	2573409	2573164	Anaeromyxobacter paludicola DNA, complete genome	blastn	824	183	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
5021302	5021302	PRJNA716463_P_NODE_604_length_1257_cov_5.418074_g338_i0	PRJNA716463	604	1257	5.418074	68.10519018	Myxococcia	32015	Bacteria	Bacteria	1703	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g338	i0	91.211	148.02784407319	1263	96	100	14	1	1257	7915376	7914123	Labilithrix luteola strain DSM 27648, complete genome	blastn	186071	1703	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7085894	7085894	PRJNA716463_P_NODE_107386_length_245_cov_1.790698_g106968_i0	PRJNA716463	107386	245	1.790698	4.3872101	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	390	4.129999999999999e-104	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g106968	i0	95.51	16.9959183673469	245	9	100	2	1	245	947265	947023	Anaeromyxobacter oryzae DNA, complete genome	blastn	4164	390	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
7087192	7087192	PRJNA716463_P_NODE_75486_length_272_cov_2.035176_g75069_i0	PRJNA716463	75486	272	2.035176	5.53567872	Polyangium aurulentum	2567896	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g75069	i0	100	0.102941176470588	28	0	10	0	38	65	6097108	6097135	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
7087430	7087430	PRJNA716463_P_NODE_90726_length_259_cov_4.177419_g90309_i0	PRJNA716463	90726	259	4.177419	10.81951521	Labilithrix luteola	1391654	Bacteria	Bacteria	315	2.72e-81	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g90309	i0	88.506	16.984555984556	261	28	100	1	1	259	3943220	3943480	Labilithrix luteola strain DSM 27648, complete genome	blastn	4399	315	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11396232	11396232	PRJNA716463_P_NODE_113369_length_239_cov_3.060241_g112951_i0	PRJNA716463	113369	239	3.060241	7.31397599	Anaeromyxobacter	161492	Bacteria	Bacteria	431	2.3599999999999996e-116	NTclustered	gi\|470484038\|ref\|NR_076626.1\|	161493	g112951	i0	99.163	257.196652719665	239	2	100	0	1	239	2088	2326	Anaeromyxobacter dehalogenans strain 2CP-1 23S ribosomal RNA gene, complete sequence	blastn	61470	431	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
12188090	12188090	PRJNA716463_P_NODE_96010_length_255_cov_1.692308_g95593_i0	PRJNA716463	96010	255	1.692308	4.3153854	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	174	4.74e-39	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g95593	i0	79.693	93.5333333333333	261	38	98	12	7	255	948695	948438	Anaeromyxobacter oryzae DNA, complete genome	blastn	23851	174	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
14737783	14737783	PRJNA716463_P_NODE_93892_length_257_cov_1.673913_g93475_i0	PRJNA716463	93892	257	1.673913	4.30195641	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	320	5.8e-83	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g93475	i0	89.189	2.01556420233463	259	24	100	4	1	257	2194794	2195050	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	518	320	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
19834033	19834033	PRJNA716463_P_NODE_101496_length_250_cov_1.740113_g101079_i0	PRJNA716463	101496	250	1.740113	4.3502825	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	409	1.17e-109	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g101079	i0	96.371	126.784	248	9	99	0	3	250	948206	948453	Anaeromyxobacter oryzae DNA, complete genome	blastn	31696	409	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
19835498	19835498	PRJNA716463_P_NODE_82736_length_266_cov_2.782383_g82319_i0	PRJNA716463	82736	266	2.782383	7.40113878	Labilithrix luteola	1391654	Bacteria	Bacteria	255	1.73e-63	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g82319	i0	85.484	12.8533834586466	248	32	92	4	1	246	4224116	4224361	Labilithrix luteola strain DSM 27648, complete genome	blastn	3419	255	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21109720	21109720	PRJNA716463_P_NODE_107757_length_244_cov_5.479532_g107339_i0	PRJNA716463	107757	244	5.479532	13.37005808	Minicystis rosea	888845	Bacteria	Bacteria	132	2.75e-26	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g107339	i0	77.016	3.36475409836066	248	46	100	11	1	244	13450627	13450867	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	821	132	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
22870263	22870263	PRJNA716463_P_NODE_22278_length_310_cov_3.337553_g21861_i0	PRJNA716463	22278	310	3.337553	10.3464143	Sorangium	39643	Bacteria	Bacteria	387	6.989999999999998e-103	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g21861	i0	89.677	100.487096774194	310	22	100	1	1	310	1541	1242	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	31151	387	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24934607	24934607	PRJNA716463_P_NODE_50000_length_290_cov_3.147465_g49583_i0	PRJNA716463	50000	290	3.147465	9.1276485	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	348	3.06e-91	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g49583	i0	88.316	1.00344827586207	291	32	100	2	1	290	10070854	10071143	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	291	348	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus

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