metadata: contig_metadata: 14 rows where bioproject = "PRJNA826497", tax_kingdom = "Pseudomonadati" and tax

14 rows where bioproject = "PRJNA826497", 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
3371445	3371445	PRJNA826497_S_NODE_12283_length_176_cov_2.818182_g12243_i0	PRJNA826497	12283	176	2.818182	4.96000032	Archangium sp.	1872627	Bacteria	Bacteria	104	1.8999999999999998e-24	NR	MDP3157731.1	1872627	g12243	i0	84.5	0.988636363636364	58	9	98.9	0	2	175	267	324	MDP3157731.1 urocanate hydratase [Archangium sp.]	diamond	174	104	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
4648993	4648993	PRJNA826497_S_NODE_13704_length_170_cov_2.817518_g13664_i0	PRJNA826497	13704	170	2.817518	4.7897806	Chondromyces crocatus	52	Bacteria	Bacteria	65.8	1.83e-6	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g13664	i0	91.489	26.5941176470588	47	4	28	0	112	158	4299915	4299961	Chondromyces crocatus strain Cm c5, complete genome	blastn	4521	65.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
26706004	26706004	PRJNA826497_S_NODE_13261_length_172_cov_2.546763_g13221_i0	PRJNA826497	13261	172	2.546763	4.38043236	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	88.2	8.87e-19	NR	MBN8539795.1	2026735	g13221	i0	73.6	1.84883720930233	53	14	92.4	0	167	9	3	55	MBN8539795.1 NAD(P)/FAD-dependent oxidoreductase [Deltaproteobacteria bacterium]	diamond	318	88.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27433937	27433937	PRJNA826497_S_NODE_1003_length_336_cov_3.933993_g963_i0	PRJNA826497	1003	336	3.933993	13.21821648	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	56.2	1.98e-6	NR	HQP36072.1	2268199	g963	i0	43.6	0.946428571428571	55	28	47.3	2	153	311	98	151	HQP36072.1 hypothetical protein [Polyangiaceae bacterium]	diamond	318	56.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27654917	27654917	PRJNA826497_S_NODE_3584_length_247_cov_8.051402_g3544_i0	PRJNA826497	3584	247	8.051402	19.88696294	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	46.2	0.0023	NR	MBX7112751.1	2484252	g3544	i0	57.1	0.425101214574899	35	15	42.5	0	3	107	332	366	MBX7112751.1 hypothetical protein [Myxococcaceae bacterium]	diamond	105	46.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
27718265	27718265	PRJNA826497_S_NODE_16844_length_159_cov_3.904762_g16804_i0	PRJNA826497	16844	159	3.904762	6.20857158	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	67.4	2.33e-11	NR	RYF12745.1	2026735	g16804	i0	63.8	2.22641509433962	58	15	98.1	2	158	3	970	1027	RYF12745.1 MAG: hypothetical protein EOO40_00480, partial [Deltaproteobacteria bacterium]	diamond	354	67.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28822673	28822673	PRJNA826497_S_NODE_16248_length_161_cov_2.632812_g16208_i0	PRJNA826497	16248	161	2.632812	4.23882732	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	52.4	4.67e-6	NR	HWZ88203.1	2268199	g16208	i0	88.9	1.00621118012422	27	3	50.3	0	161	81	296	322	HWZ88203.1 hypothetical protein [Polyangiaceae bacterium]	diamond	162	52.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28885988	28885988	PRJNA826497_S_NODE_16768_length_159_cov_6.103175_g16728_i0	PRJNA826497	16768	159	6.103175	9.70404825	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	70.1	2.62e-12	NR	RYF12745.1	2026735	g16728	i0	63	0.867924528301887	46	17	86.8	0	139	2	821	866	RYF12745.1 MAG: hypothetical protein EOO40_00480, partial [Deltaproteobacteria bacterium]	diamond	138	70.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28949483	28949483	PRJNA826497_S_NODE_6268_length_214_cov_2.381215_g6228_i0	PRJNA826497	6268	214	2.381215	5.0958001	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	92.8	7.5e-23	NR	MBN8542155.1	2026735	g6228	i0	81.7	0.841121495327103	60	11	84.1	0	34	213	1	60	MBN8542155.1 DUF1844 domain-containing protein [Deltaproteobacteria bacterium]	diamond	180	92.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30907737	30907737	PRJNA826497_S_NODE_9474_length_190_cov_5.872611_g9434_i0	PRJNA826497	9474	190	5.872611	11.1579609	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	48.9	1.17e-4	NR	MBI5609457.1	2026735	g9434	i0	90.5	0.331578947368421	21	2	33.2	0	3	65	366	386	MBI5609457.1 peptidoglycan-binding protein [Deltaproteobacteria bacterium]	diamond	63	48.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30970861	30970861	PRJNA826497_S_NODE_4474_length_234_cov_2.840796_g4434_i0	PRJNA826497	4474	234	2.840796	6.64746264	Myxococcales bacterium	2026763	Bacteria	Bacteria	63.9	5.7e-11	NR	MCA9640749.1	2026763	g4434	i0	82.9	1.05128205128205	41	7	52.6	0	5	127	73	113	MCA9640749.1 hypothetical protein [Myxococcales bacterium]	diamond	246	63.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31137063	31137063	PRJNA826497_S_NODE_7375_length_204_cov_4.941520_g7335_i0	PRJNA826497	7375	204	4.94152	10.0807008	Myxococcia	32015	Bacteria	Bacteria	53.1	2.92e-6	NR	MCA9679761.1	2026763	g7335	i0	47.9	2.17647058823529	48	23	70.6	1	5	148	169	214	MCA9679761.1 maleylacetoacetate isomerase [Myxococcales bacterium]	diamond	444	53.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31571625	31571625	PRJNA826497_S_NODE_4536_length_233_cov_4.460000_g4496_i0	PRJNA826497	4536	233	4.46	10.3918	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	55.5	1.09e-6	NR	HEY3821388.1	2268199	g4496	i0	45.6	0.875536480686695	68	34	87.6	2	23	226	962	1026	HEY3821388.1 hypothetical protein [Polyangiaceae bacterium]	diamond	204	55.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32457452	32457452	PRJNA826497_S_NODE_1079_length_331_cov_3.140940_g1039_i0	PRJNA826497	1079	331	3.14094	10.3965114	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	64.3	2.38e-9	NR	MDH3975426.1	2026735	g1039	i0	40.3	0.697885196374622	77	45	69.8	1	3	233	295	370	MDH3975426.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	231	64.3	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);;