metadata: contig_metadata: 12 rows where bioproject = "PRJNA414225", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA414225", tax_kingdom = "Pseudomonadati" 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
2969603	2969603	PRJNA414225_P_NODE_13863_length_195_cov_1.150685_g13776_i0	PRJNA414225	13863	195	1.150685	2.24383575	Labilithrix luteola	1391654	Bacteria	Bacteria	279	7.1e-71	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g13776	i0	93.158	137.928205128205	190	13	97	0	5	194	3942073	3942262	Labilithrix luteola strain DSM 27648, complete genome	blastn	26896	279	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5522713	5522713	PRJNA414225_P_NODE_44745_length_168_cov_1.714286_g44658_i0	PRJNA414225	44745	168	1.714286	2.88000048	Myxococcota bacterium	2818507	Bacteria	Bacteria	111	2.3e-20	NTclustered	gi\|2621786039\|emb\|OY782497.1\|	2818507	g44658	i0	79.503	7.82142857142857	161	29	95	4	7	165	3395553	3395395	MAG: Myxococcota bacterium isolate 0c961c99-2a7e-4543-b017-306f11f6fc1d genome assembly, chromosome: 1	blastn	1314	111	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
9347136	9347136	PRJNA414225_P_NODE_78568_length_163_cov_0.894737_g78481_i0	PRJNA414225	78568	163	0.894737	1.45842131	Archangium gephyra	48	Bacteria	Bacteria	148	1.68e-31	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g78481	i0	85.417	91.4233128834356	144	19	88	2	21	163	5895145	5895287	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	14902	148	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
18934635	18934635	PRJNA414225_P_NODE_65155_length_165_cov_0.879310_g65068_i0	PRJNA414225	65155	165	0.87931	1.4508615	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	57.8	6.13e-8	NR	MBI4515129.1	2026735	g65068	i0	62.3	0.963636363636364	53	20	96.4	0	2	160	254	306	MBI4515129.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	159	57.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
26726987	26726987	PRJNA414225_P_NODE_56481_length_166_cov_0.871795_g56394_i0	PRJNA414225	56481	166	0.871795	1.4471797	Myxococcales bacterium	2026763	Bacteria	Bacteria	86.7	2.67e-20	NR	MCA9640749.1	2026763	g56394	i0	83.3	0.975903614457831	54	9	97.6	0	2	163	58	111	MCA9640749.1 hypothetical protein [Myxococcales bacterium]	diamond	162	86.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
26726991	26726991	PRJNA414225_P_NODE_86761_length_162_cov_0.902655_g86674_i0	PRJNA414225	86761	162	0.902655	1.4623011	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	94.4	8.050000000000001e-21	NR	GMU63075.1	2484252	g86674	i0	92.5	9.81481481481481	53	4	98.1	0	2	160	612	664	GMU63075.1 MAG: hypothetical protein AMXMBFR34_48380 [Myxococcaceae bacterium]	diamond	1590	94.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
27391790	27391790	PRJNA414225_P_NODE_16223_length_191_cov_1.084507_g16136_i0	PRJNA414225	16223	191	1.084507	2.07140837	Anaeromyxobacter terrae	2925406	Bacteria	Bacteria	50.4	3.47e-5	NR	WP_242344762.1	2925406	g16136	i0	51.8	0.879581151832461	56	27	88	0	178	11	132	187	WP_242344762.1 EpsG family protein [Anaeromyxobacter terrae]	diamond	168	50.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter terrae
27565989	27565989	PRJNA414225_P_NODE_24684_length_183_cov_1.522388_g24597_i0	PRJNA414225	24684	183	1.522388	2.78597004	Pseudomonadati	3379134	Bacteria	Bacteria	50.8	2.38e-5	NR	MBN8535434.1	2026735	g24597	i0	73.3	0.983606557377049	30	8	49.2	0	90	1	1	30	MBN8535434.1 ABC transporter ATP-binding protein [Deltaproteobacteria bacterium]	diamond	180	50.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27770743	27770743	PRJNA414225_P_NODE_90164_length_159_cov_2.572727_g90077_i0	PRJNA414225	90164	159	2.572727	4.09063593	Myxococcales bacterium	2026763	Bacteria	Bacteria	74.3	1.91e-14	NR	MBL9025069.1	2026763	g90077	i0	60.8	0.962264150943396	51	20	96.2	0	158	6	171	221	MBL9025069.1 carotenoid synthesis regulator CarF [Myxococcales bacterium]	diamond	153	74.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28307299	28307299	PRJNA414225_P_NODE_60366_length_166_cov_0.871795_g60279_i0	PRJNA414225	60366	166	0.871795	1.4471797	Myxococcota bacterium	2818507	Bacteria	Bacteria	94.4	8.42e-21	NR	HSI04277.1	2818507	g60279	i0	83.3	1.73493975903614	48	8	86.7	0	146	3	643	690	HSI04277.1 PilC/PilY family type IV pilus protein [Myxococcota bacterium]	diamond	288	94.4	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
29601500	29601500	PRJNA414225_P_NODE_36810_length_174_cov_1.456000_g36723_i0	PRJNA414225	36810	174	1.456	2.53344	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	73.2	2.68e-13	NR	MDP2341952.1	2026735	g36723	i0	72.7	0.948275862068966	55	15	94.8	0	166	2	150	204	MDP2341952.1 GAF domain-containing protein [Deltaproteobacteria bacterium]	diamond	165	73.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30328853	30328853	PRJNA414225_P_NODE_74272_length_164_cov_0.886957_g74185_i0	PRJNA414225	74272	164	0.886957	1.45460948	Myxococcales bacterium	2026763	Bacteria	Bacteria	84.7	2.62e-18	NR	MDH3519357.1	2026763	g74185	i0	77.4	0.969512195121951	53	12	97	0	4	162	37	89	MDH3519357.1 endonuclease III [Myxococcales bacterium]	diamond	159	84.7	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);;