metadata: contig_metadata: 9 rows where bioproject = "PRJNA1016321", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA1016321", 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
23955084	23955084	PRJNA1016321_P_NODE_48939_length_250_cov_0.870056_g48708_i0	PRJNA1016321	48939	250	0.870056	2.17514	Pseudomonadati	3379134	Bacteria	Bacteria	100	1.3799999999999998e-23	NR	MEO7328762.1	1971901	g48708	i0	60.2	6.936	83	29	98.4	2	248	3	65	144	MEO7328762.1 glucose 1-dehydrogenase [Minicystis sp.]	diamond	1734	100	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis sp.
27698659	27698659	PRJNA1016321_P_NODE_41724_length_273_cov_1.195000_g41493_i0	PRJNA1016321	41724	273	1.195	3.26235	Myxococcales bacterium	2026763	Bacteria	Bacteria	42.4	0.0493	NR	MCA9631504.1	2026763	g41493	i0	41.7	0.395604395604396	36	21	39.6	0	263	156	124	159	MCA9631504.1 sel1 repeat family protein [Myxococcales bacterium]	diamond	108	42.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28921770	28921770	PRJNA1016321_P_NODE_53468_length_244_cov_0.900585_g53237_i0	PRJNA1016321	53468	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	68.9	1.7e-11	NR	WP_271923709.1	2995306	g53237	i0	71.7	8.63114754098361	46	13	56.6	0	240	103	277	322	WP_271923709.1 helix-turn-helix transcriptional regulator [Polyangium mundeleinium]	diamond	2106	69.3	0.994227994227994	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium mundeleinium
29087724	29087724	PRJNA1016321_P_NODE_49208_length_249_cov_1.482955_g48977_i0	PRJNA1016321	49208	249	1.482955	3.69255795	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	121	5.75e-31	NR	MDL2123176.1	2026735	g48977	i0	70.9	1.89156626506024	79	23	95.2	0	12	248	11	89	MDL2123176.1 site-specific DNA-methyltransferase [Deltaproteobacteria bacterium]	diamond	471	121	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29592359	29592359	PRJNA1016321_P_NODE_53490_length_244_cov_0.900585_g53259_i0	PRJNA1016321	53490	244	0.900585	2.1974274	Myxococcales bacterium	2026763	Bacteria	Bacteria	47.8	6.51e-4	NR	MBK7399089.1	2026763	g53259	i0	34.9	1.75819672131148	83	48	97.1	4	7	243	36	116	MBK7399089.1 hypothetical protein [Myxococcales bacterium]	diamond	429	47.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30256401	30256401	PRJNA1016321_P_NODE_53012_length_245_cov_0.895349_g52781_i0	PRJNA1016321	53012	245	0.895349	2.19360505	Myxococcales bacterium	2026763	Bacteria	Bacteria	63.5	1.82e-9	NR	MDH5675665.1	2026763	g52781	i0	50	0.955102040816327	78	29	83.3	2	205	2	1072	1149	MDH5675665.1 DUF4215 domain-containing protein [Myxococcales bacterium]	diamond	234	63.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30288031	30288031	PRJNA1016321_P_NODE_51652_length_246_cov_1.595376_g51421_i0	PRJNA1016321	51652	246	1.595376	3.92462496	Polyangia bacterium	3058050	Bacteria	Bacteria	68.2	4.22e-11	NR	HXU01300.1	3058050	g51421	i0	42.1	1.78048780487805	76	43	92.7	1	240	13	146	220	HXU01300.1 PHP domain-containing protein [Polyangia bacterium]	diamond	438	68.2	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
31108968	31108968	PRJNA1016321_P_NODE_52315_length_246_cov_0.861272_g52084_i0	PRJNA1016321	52315	246	0.861272	2.11872912	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	61.2	5.1e-9	NR	HEY1957898.1	2268199	g52084	i0	50.7	0.817073170731707	67	27	81.7	1	201	1	121	181	HEY1957898.1 NrsF family protein [Polyangiaceae bacterium]	diamond	201	61.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31678231	31678231	PRJNA1016321_P_NODE_46457_length_255_cov_1.620879_g46226_i0	PRJNA1016321	46457	255	1.620879	4.13324145	Polyangiales bacterium	3034171	Bacteria	Bacteria	132	6.36e-36	NR	MFI5301889.1	3034171	g46226	i0	71.4	0.988235294117647	84	24	98.8	0	253	2	172	255	MFI5301889.1 hypothetical protein [Polyangiales bacterium]	diamond	252	132	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales 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);;