metadata: contig_metadata: 26 rows where bioproject = "PRJNA613025" and tax

26 rows where bioproject = "PRJNA613025" 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
591762	591762	PRJNA613025_S_NODE_21461_length_209_cov_1.306250_g21307_i0	PRJNA613025	21461	209	1.30625	2.7300625	Archangium gephyra	48	Bacteria	Bacteria	198	2.22e-46	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g21307	i0	83.81	8.94258373205742	210	32	100	2	1	209	11234695	11234487	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	1869	198	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
1867515	1867515	PRJNA613025_S_NODE_13962_length_297_cov_2.064516_g13808_i0	PRJNA613025	13962	297	2.064516	6.13161252	Pendulispora rubella	2741070	Bacteria	Bacteria	398	3.0799999999999996e-106	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g13808	i0	91.468	156.057239057239	293	20	98	3	6	297	7289487	7289199	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	46349	398	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
3142676	3142676	PRJNA613025_S_NODE_24503_length_191_cov_1.429577_g24349_i0	PRJNA613025	24503	191	1.429577	2.73049207	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	309	8.83e-80	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g24349	i0	96.277	227.366492146597	188	7	100	0	1	188	1384087	1384274	Anaeromyxobacter paludicola DNA, complete genome	blastn	43427	309	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
4419278	4419278	PRJNA613025_S_NODE_20224_length_218_cov_1.295858_g20070_i0	PRJNA613025	20224	218	1.295858	2.82497044	Labilithrix luteola	1391654	Bacteria	Bacteria	300	6.23e-77	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g20070	i0	91.364	120.912844036697	220	17	100	2	1	218	3942549	3942330	Labilithrix luteola strain DSM 27648, complete genome	blastn	26359	300	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5695046	5695046	PRJNA613025_S_NODE_10385_length_382_cov_4.303303_g10232_i0	PRJNA613025	10385	382	4.303303	16.43861746	Labilithrix luteola	1391654	Bacteria	Bacteria	442	1.8499999999999992e-119	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10232	i0	89.518	132.361256544503	353	31	97	5	1	350	3942261	3941912	Labilithrix luteola strain DSM 27648, complete genome	blastn	50562	442	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5695191	5695191	PRJNA613025_S_NODE_16065_length_262_cov_3.643192_g15911_i0	PRJNA613025	16065	262	3.643192	9.54516304	Pendulispora albinea	2741071	Bacteria	Bacteria	235	2.21e-57	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g15911	i0	83.083	162.36641221374	266	38	100	7	1	262	3590700	3590438	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	42540	235	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
5695543	5695543	PRJNA613025_S_NODE_32505_length_163_cov_0.894737_g32351_i0	PRJNA613025	32505	163	0.894737	1.45842131	Myxococcales bacterium	2026763	Bacteria	Bacteria	75.1	4.88e-14	NR	MBK6693411.1	2026763	g32351	i0	64.8	0.993865030674847	54	19	99.4	0	162	1	371	424	MBK6693411.1 HAMP domain-containing histidine kinase [Myxococcales bacterium]	diamond	162	75.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
6969838	6969838	PRJNA613025_S_NODE_10806_length_369_cov_251.712500_g10652_i0	PRJNA613025	10806	369	251.7125	928.819125	Pajaroellobacter abortibovis	1882918	Bacteria	Bacteria	532	1.03e-146	NTclustered	gi\|1127377833\|gb\|CP016908.1\|	1882918	g10652	i0	92.683	264.130081300813	369	27	100	0	1	369	1549408	1549776	Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome	blastn	97464	532	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Pajaroellobacter	Pajaroellobacter abortibovis
8245153	8245153	PRJNA613025_S_NODE_4447_length_749_cov_14.291429_g4310_i0	PRJNA613025	4447	749	14.291429	107.04280321	Pendulispora albinea	2741071	Bacteria	Bacteria	850	0	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g4310	i0	88.154	120.524699599466	726	70	96	13	3	719	3589475	3588757	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	90273	850	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
8801659	8801659	PRJNA613025_S_NODE_19207_length_227_cov_1.146067_g19053_i0	PRJNA613025	19207	227	1.146067	2.60157209	Anaeromyxobacter	161492	Bacteria	Bacteria	300	6.54e-77	NTclustered	gi\|470477744\|ref\|NR_076406.1\|	161493	g19053	i0	90.393	229.757709251101	229	20	100	2	1	227	650	422	Anaeromyxobacter dehalogenans strain 2CP-C 23S ribosomal RNA gene, complete sequence	blastn	52155	300	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
9520327	9520327	PRJNA613025_S_NODE_33448_length_161_cov_6.169643_g33294_i0	PRJNA613025	33448	161	6.169643	9.93312523	Labilithrix luteola	1391654	Bacteria	Bacteria	287	3.37e-73	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g33294	i0	99.367	154.534161490683	158	1	98	0	4	161	3942821	3942664	Labilithrix luteola strain DSM 27648, complete genome	blastn	24880	287	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10077307	10077307	PRJNA613025_S_NODE_27028_length_179_cov_1.169231_g26874_i0	PRJNA613025	27028	179	1.169231	2.09292349	Myxococcales	29	Bacteria	Bacteria	246	6.48e-61	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g26874	i0	92.442	249.893854748603	172	13	96	0	1	172	5101123	5100952	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	44731	246	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
10077322	10077322	PRJNA613025_S_NODE_28668_length_172_cov_1.243902_g28514_i0	PRJNA613025	28668	172	1.243902	2.13951144	Myxococcales	29	Bacteria	Bacteria	257	2.85e-64	NTclustered	gi\|545790941\|gb\|KF270704.1\|	35	g28514	i0	94.083	247.075581395349	169	10	98	0	1	169	583	751	Corallococcus macrosporus strain Ccm7 23S ribosomal RNA gene, partial sequence	blastn	42497	257	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
10795909	10795909	PRJNA613025_S_NODE_18509_length_233_cov_5.070652_g18355_i0	PRJNA613025	18509	233	5.070652	11.81461916	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	281	2.44e-71	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g18355	i0	88.559	121.055793991416	236	22	99	5	2	233	9677929	9677695	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	28206	281	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
11352214	11352214	PRJNA613025_S_NODE_19289_length_226_cov_1.864407_g19135_i0	PRJNA613025	19289	226	1.864407	4.21355982	Myxococcus	32	Bacteria	Bacteria	135	1.9400000000000003e-27	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g19135	i0	81.548	8.56194690265487	168	28	74	3	7	173	561018	561183	Myxococcus xanthus strain DK1050 chromosome	blastn	1935	135	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
11352265	11352265	PRJNA613025_S_NODE_26129_length_183_cov_1.126866_g25975_i0	PRJNA613025	26129	183	1.126866	2.06216478	Polyangiaceae	49	Bacteria	Bacteria	207	3.14e-49	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g25975	i0	87.027	177.693989071038	185	22	100	2	1	183	3690925	3690741	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	32518	207	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12070860	12070860	PRJNA613025_S_NODE_11370_length_354_cov_2.078689_g11216_i0	PRJNA613025	11370	354	2.078689	7.35855906	Cystobacter fuscus	43	Bacteria	Bacteria	444	4.73e-120	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g11216	i0	89.855	99.5197740112994	345	35	97	0	7	351	8623845	8623501	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	35230	444	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
13345653	13345653	PRJNA613025_S_NODE_14151_length_293_cov_190.397541_g13997_i0	PRJNA613025	14151	293	190.397541	557.86479513	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	392	1.41e-104	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g13997	i0	90.785	187.109215017065	293	27	100	0	1	293	8617077	8616785	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	54823	392	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
13345736	13345736	PRJNA613025_S_NODE_17231_length_247_cov_2.873737_g17077_i0	PRJNA613025	17231	247	2.873737	7.09813039	uncultured Polyangiaceae bacterium	417999	Bacteria	Bacteria	436	5.279999999999999e-118	NTclustered	gi\|545342541\|gb\|KF505773.1\|	417999	g17077	i0	98.394	99.2712550607287	249	2	100	2	1	247	494	246	Uncultured Polyangiaceae bacterium clone 5257 16S ribosomal RNA gene, partial sequence	blastn	24520	436	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		uncultured Polyangiaceae bacterium
18443870	18443870	PRJNA613025_S_NODE_24935_length_189_cov_0.842857_g24781_i0	PRJNA613025	24935	189	0.842857	1.59299973	Labilithrix luteola	1391654	Bacteria	Bacteria	189	1.1799999999999999e-43	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g24781	i0	85.106	414.047619047619	188	25	98	3	1	186	3941843	3942029	Labilithrix luteola strain DSM 27648, complete genome	blastn	78255	189	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
29164736	29164736	PRJNA613025_S_NODE_23409_length_197_cov_1.371622_g23255_i0	PRJNA613025	23409	197	1.371622	2.70209534	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	46.2	8.89e-4	NR	HEX7665424.1	2268199	g23255	i0	36.9	1.97969543147208	65	40	99	1	2	196	92	155	HEX7665424.1 glutathione binding-like protein [Polyangiaceae bacterium]	diamond	390	46.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
29448400	29448400	PRJNA613025_S_NODE_30730_length_166_cov_0.871795_g30576_i0	PRJNA613025	30730	166	0.871795	1.4471797	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	43.1	0.00948	NR	MEZ4306608.1	2268199	g30576	i0	86.4	0.397590361445783	22	3	39.8	0	99	164	358	379	MEZ4306608.1 protein kinase [Polyangiaceae bacterium]	diamond	66	43.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30206400	30206400	PRJNA613025_S_NODE_32352_length_163_cov_1.473684_g32198_i0	PRJNA613025	32352	163	1.473684	2.40210492	Myxococcota bacterium	2818507	Bacteria	Bacteria	55.1	5.66e-7	NR	MEQ1505933.1	2818507	g32198	i0	44.2	0.957055214723926	52	29	95.7	0	162	7	623	674	MEQ1505933.1 FAD-binding protein [Myxococcota bacterium]	diamond	156	55.1	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30365043	30365043	PRJNA613025_S_NODE_22632_length_202_cov_0.993464_g22478_i0	PRJNA613025	22632	202	0.993464	2.00679728	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	48.9	1.44e-4	NR	MCB9737160.1	2026735	g22478	i0	37.9	0.861386138613861	58	36	86.1	0	201	28	2	59	MCB9737160.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	174	48.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31091361	31091361	PRJNA613025_S_NODE_33935_length_161_cov_0.910714_g33781_i0	PRJNA613025	33935	161	0.910714	1.46624954	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	56.6	1.55e-7	NR	MCL2779433.1	2268199	g33781	i0	58.1	0.801242236024845	43	18	80.1	0	10	138	340	382	MCL2779433.1 hypothetical protein [Polyangiaceae bacterium]	diamond	129	56.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31881837	31881837	PRJNA613025_S_NODE_25737_length_185_cov_1.125000_g25583_i0	PRJNA613025	25737	185	1.125	2.08125	Myxococcales bacterium	2026763	Bacteria	Bacteria	80.5	8.31e-16	NR	MSP61786.1	2026763	g25583	i0	63.9	0.989189189189189	61	22	98.9	0	185	3	42	102	MSP61786.1 argininosuccinate lyase [Myxococcales bacterium]	diamond	183	80.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales 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);;