metadata: contig_metadata: 21 rows where bioproject = "PRJNA1245487", tax_phylum = "Myxococcota" and tax

21 rows where bioproject = "PRJNA1245487", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

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
1051591	1051591	PRJNA1245487_P_NODE_981_length_1129_cov_9.564394_g49_i1	PRJNA1245487	981	1129	9.564394	107.98200826	Stigmatella	40	Bacteria	Bacteria	1766	0	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g49	i1	94.956	235.219663418955	1130	52	100	5	1	1129	649	1774	S.aurantiaca 23S rRNA gene	blastn	265563	1766	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
1625860	1625860	PRJNA1245487_P_NODE_23182_length_219_cov_5.376712_g22844_i0	PRJNA1245487	23182	219	5.376712	11.77499928	Labilithrix luteola	1391654	Bacteria	Bacteria	311	2.9000000000000004e-80	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g22844	i0	92.273	273.045662100457	220	15	100	2	1	219	3942096	3942314	Labilithrix luteola strain DSM 27648, complete genome	blastn	59797	311	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7429122	7429122	PRJNA1245487_P_NODE_13526_length_312_cov_1.828452_g13188_i0	PRJNA1245487	13526	312	1.828452	5.70477024	Myxococcales	29	Bacteria	Bacteria	239	2.09e-58	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g13188	i0	83.333	466.157051282051	270	34	85	11	46	310	178801	178538	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	145441	239	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
7429209	7429209	PRJNA1245487_P_NODE_18246_length_260_cov_1.475936_g17908_i0	PRJNA1245487	18246	260	1.475936	3.8374335999999998	Stigmatella	40	Bacteria	Bacteria	414	2.62e-111	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g17908	i0	95.385	262.134615384615	260	12	100	0	1	260	752	493	S.aurantiaca 23S rRNA gene	blastn	68155	414	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
8704419	8704419	PRJNA1245487_P_NODE_9787_length_382_cov_7.511327_g9449_i0	PRJNA1245487	9787	382	7.511327	28.69326914	Haliangium	162027	Bacteria	Bacteria	490	6.509999999999998e-134	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g9449	i0	90	157.722513089005	380	37	99	1	1	380	1227	849	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	60250	490	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
10555191	10555191	PRJNA1245487_P_NODE_18169_length_260_cov_4.224599_g17831_i0	PRJNA1245487	18169	260	4.224599	10.9839574	Pendulispora brunnea	2905690	Bacteria	Bacteria	387	5.72e-103	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g17831	i0	93.487	230.488461538462	261	15	100	2	1	260	7408929	7409188	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	59927	387	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
11254559	11254559	PRJNA1245487_P_NODE_14169_length_303_cov_1.356522_g13831_i0	PRJNA1245487	14169	303	1.356522	4.11026166	Sorangium	39643	Bacteria	Bacteria	462	1.1e-125	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g13831	i0	94.352	135.920792079208	301	17	99	0	3	303	1253	953	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	41184	462	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
13804868	13804868	PRJNA1245487_P_NODE_4071_length_622_cov_3.424408_g3743_i0	PRJNA1245487	4071	622	3.424408	21.29981776	Pendulispora	3375062	Bacteria	Bacteria	981	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g3743	i0	95.338	152.390675241158	622	22	100	4	1	622	7288860	7289474	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	94787	985	0.995939086294416	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
14380157	14380157	PRJNA1245487_P_NODE_11392_length_348_cov_2.829091_g11054_i0	PRJNA1245487	11392	348	2.829091	9.84523668	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	566	9.519999999999999e-157	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g11054	i0	95.977	603.040229885057	348	14	100	0	1	348	947226	947573	Anaeromyxobacter oryzae DNA, complete genome	blastn	209858	566	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
15654058	15654058	PRJNA1245487_P_NODE_14613_length_296_cov_3.062780_g14275_i0	PRJNA1245487	14613	296	3.06278	9.0658288	Archangium violaceum	83451	Bacteria	Bacteria	398	3.059999999999999e-106	NTclustered	gi\|2579675135\|gb\|CP043493.1\|	83451	g14275	i0	90.97	215.084459459459	299	21	100	6	1	296	5180143	5179848	Archangium violaceum strain Cbvi 34 chromosome, complete genome	blastn	63665	398	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
16353986	16353986	PRJNA1245487_P_NODE_6733_length_477_cov_6.131188_g6397_i0	PRJNA1245487	6733	477	6.131188	29.24576676	Stigmatella	40	Bacteria	Bacteria	658	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g6397	i0	91.684	245.496855345912	481	30	100	8	1	477	51	525	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	117102	658	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
18202781	18202781	PRJNA1245487_P_NODE_16295_length_278_cov_1.102439_g15957_i0	PRJNA1245487	16295	278	1.102439	3.06478042	Archangium gephyra	48	Bacteria	Bacteria	211	3.9900000000000002e-50	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g15957	i0	81.298	59.7841726618705	262	47	94	2	12	272	10059562	10059822	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	16620	211	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
18202831	18202831	PRJNA1245487_P_NODE_20255_length_248_cov_2.622857_g19917_i0	PRJNA1245487	20255	248	2.622857	6.50468536	Labilithrix luteola	1391654	Bacteria	Bacteria	241	4.46e-59	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g19917	i0	85.185	16.258064516129	243	27	96	7	10	247	7915580	7915818	Labilithrix luteola strain DSM 27648, complete genome	blastn	4032	241	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
20752519	20752519	PRJNA1245487_P_NODE_11177_length_352_cov_3.559140_g10839_i0	PRJNA1245487	11177	352	3.55914	12.5281728	Myxococcales bacterium	2026763	Bacteria	Bacteria	444	4.699999999999998e-120	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g10839	i0	89.518	95.8835227272727	353	34	100	3	1	352	1312389	1312739	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	33751	444	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
20752539	20752539	PRJNA1245487_P_NODE_12917_length_322_cov_1.232932_g12579_i0	PRJNA1245487	12917	322	1.232932	3.97004104	Pendulispora albinea	2741071	Bacteria	Bacteria	497	3.2299999999999998e-136	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g12579	i0	94.444	122.189440993789	324	16	100	2	1	322	3589223	3588900	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	39345	497	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
24003261	24003261	PRJNA1245487_P_NODE_12479_length_329_cov_2.027344_g12141_i0	PRJNA1245487	12479	329	2.027344	6.66996176	root	1	Root_unresolved	Root_unresolved	401	2.6699999999999992e-107	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g12141	i0	88.788	118.693009118541	330	34	99	3	1	328	1621	1949	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	39050	401	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
24003422	24003422	PRJNA1245487_P_NODE_22159_length_241_cov_2.779762_g21821_i0	PRJNA1245487	22159	241	2.779762	6.69922642	Stigmatella	40	Bacteria	Bacteria	340	4.13e-89	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g21821	i0	92.116	282.319502074689	241	19	100	0	1	241	27	267	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	68039	340	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
24577528	24577528	PRJNA1245487_P_NODE_9020_length_403_cov_2.300000_g8682_i0	PRJNA1245487	9020	403	2.3	9.269	Labilithrix luteola	1391654	Bacteria	Bacteria	444	5.46e-120	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g8682	i0	87	206.411910669975	400	45	98	7	8	403	3941856	3942252	Labilithrix luteola strain DSM 27648, complete genome	blastn	83184	444	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
26630437	26630437	PRJNA1245487_P_NODE_11141_length_353_cov_1.950000_g10803_i0	PRJNA1245487	11141	353	1.95	6.8835	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	89.4	6.25e-18	NR	MER2566866.1	2484252	g10803	i0	43.6	0.994334277620397	117	53	96.9	3	3	344	808	914	MER2566866.1 thrombospondin type-1 domain-containing protein [Myxococcaceae bacterium]	diamond	351	89.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
27800283	27800283	PRJNA1245487_P_NODE_21204_length_245_cov_0.906977_g20866_i0	PRJNA1245487	21204	245	0.906977	2.22209365	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	42.7	0.0351	NR	HUQ03225.1	2212474	g20866	i0	34.8	0.808163265306122	66	39	75.9	2	217	32	159	224	HUQ03225.1 class II aldolase/adducin family protein [Kofleriaceae bacterium]	diamond	198	42.7	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
28526507	28526507	PRJNA1245487_P_NODE_16187_length_279_cov_1.504854_g15849_i0	PRJNA1245487	16187	279	1.504854	4.19854266	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	82.4	6.59e-16	NR	MBI5542280.1	2026735	g15849	i0	60.8	0.849462365591398	79	28	81.7	1	49	276	13	91	MBI5542280.1 TonB-dependent receptor [Deltaproteobacteria bacterium]	diamond	237	82.4	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);;