metadata: contig_metadata: 10 rows where bioproject = "PRJNA1248424", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA1248424", 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
2903840	2903840	PRJNA1248424_P_NODE_61363_length_272_cov_1.291457_g55295_i0	PRJNA1248424	61363	272	1.291457	3.51276304	Archangium gephyra	48	Bacteria	Bacteria	335	2.21e-87	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g55295	i0	92.05	80.7279411764706	239	18	100	1	1	239	10964088	10963851	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	21958	335	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
6730740	6730740	PRJNA1248424_P_NODE_59306_length_277_cov_1.877451_g53238_i0	PRJNA1248424	59306	277	1.877451	5.20053927	Corallococcus sp. AB	1898750	Bacteria	Bacteria	101	6.03e-26	NR	WP_233607615.1	2316715	g53238	i0	81.3	0.693140794223827	64	12	69.3	0	277	86	7	70	WP_233607615.1 hypothetical protein, partial [Corallococcus sp. AB018]	diamond	192	101	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. AB018
13107052	13107052	PRJNA1248424_P_NODE_66971_length_256_cov_2.153005_g60902_i0	PRJNA1248424	66971	256	2.153005	5.5116928	Archangium violaceum	83451	Bacteria	Bacteria	209	1.3e-49	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g60902	i0	81.928	0.97265625	249	43	97	2	1	248	6776017	6776264	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	249	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
16930137	16930137	PRJNA1248424_P_NODE_55534_length_287_cov_1.200935_g49466_i0	PRJNA1248424	55534	287	1.200935	3.44668345	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	165	1.19e-46	NR	HSK01642.1	2212474	g49466	i0	88.4	1.98606271777003	95	11	99.3	0	1	285	108	202	HSK01642.1 class II fumarate hydratase [Kofleriaceae bacterium]	diamond	570	165	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
27692205	27692205	PRJNA1248424_P_NODE_80864_length_238_cov_2.272727_g74795_i0	PRJNA1248424	80864	238	2.272727	5.40909026	Bacteria	2	Bacteria	Bacteria	126	1.05e-31	NR	MBA3541565.1	2026735	g74795	i0	69.2	2.93697478991597	78	24	98.3	0	236	3	382	459	MBA3541565.1 SpoIIE family protein phosphatase [Deltaproteobacteria bacterium]	diamond	699	127	0.992125984251969	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27768830	27768830	PRJNA1248424_P_NODE_77244_length_244_cov_0.888889_g71175_i0	PRJNA1248424	77244	244	0.888889	2.16888916	Myxococcales bacterium	2026763	Bacteria	Bacteria	98.6	6.91e-22	NR	MBK6691071.1	2026763	g71175	i0	57.5	0.983606557377049	80	33	97.1	1	4	240	119	198	MBK6691071.1 hypothetical protein [Myxococcales bacterium]	diamond	240	98.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28178793	28178793	PRJNA1248424_P_NODE_61926_length_270_cov_2.065990_g55857_i0	PRJNA1248424	61926	270	2.06599	5.578173	Pyxidicoccus xibeiensis	2906759	Bacteria	Bacteria	48.5	4.81e-4	NR	WP_253982693.1	2906759	g55857	i0	54.2	0.533333333333333	48	22	53.3	0	126	269	1051	1098	WP_253982693.1 DUF924 family protein [Pyxidicoccus xibeiensis]	diamond	144	48.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus xibeiensis
28336924	28336924	PRJNA1248424_P_NODE_75866_length_245_cov_0.895349_g69797_i0	PRJNA1248424	75866	245	0.895349	2.19360505	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	43.9	0.0142	NR	MBW2453469.1	2026735	g69797	i0	51.2	0.502040816326531	41	20	50.2	0	127	5	152	192	MBW2453469.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	123	43.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32760258	32760258	PRJNA1248424_P_NODE_47600_length_322_cov_2.642570_g41533_i0	PRJNA1248424	47600	322	2.64257	8.5090754	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	63.5	1.04e-10	NR	MEI6704322.1	2026735	g41533	i0	85.7	0.326086956521739	35	5	32.6	0	216	320	35	69	MEI6704322.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	105	63.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32791562	32791562	PRJNA1248424_P_NODE_64460_length_263_cov_1.673684_g58391_i0	PRJNA1248424	64460	263	1.673684	4.40178892	Archangium sp.	1872627	Bacteria	Bacteria	151	1.18e-41	NR	WP_324960869.1	1872627	g58391	i0	86.2	0.992395437262357	87	12	99.2	0	261	1	239	325	WP_324960869.1 ABC transporter substrate-binding protein [Archangium sp.]	diamond	261	151	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.

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