metadata: contig_metadata: 10 rows where bioproject = "PRJNA721440", tax_phylum = "Myxococcota" and tax

10 rows where bioproject = "PRJNA721440", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

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
27494503	27494503	PRJNA721440_S_NODE_2503_length_354_cov_2.865574_g2377_i0	PRJNA721440	2503	354	2.865574	10.14413196	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	112	2.47e-27	NR	RYF04405.1	2026735	g2377	i0	45.5	1.11864406779661	132	57	99.2	2	353	3	146	277	RYF04405.1 MAG: hypothetical protein EOO40_11245, partial [Deltaproteobacteria bacterium]	diamond	396	112	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28536622	28536622	PRJNA721440_S_NODE_13787_length_182_cov_1.172932_g13661_i0	PRJNA721440	13787	182	1.172932	2.13473624	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	98.6	1.11e-22	NR	RYZ12068.1	2484252	g13661	i0	73.3	0.989010989010989	60	16	98.9	0	180	1	116	175	RYZ12068.1 MAG: hypothetical protein EOO70_09315, partial [Myxococcaceae bacterium]	diamond	180	98.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
28547091	28547091	PRJNA721440_S_NODE_17007_length_169_cov_0.866667_g16881_i0	PRJNA721440	17007	169	0.866667	1.46466723	Byssovorax	224459	Bacteria	Bacteria	58.9	1.98e-8	NR	MCC6559247.1	2268199	g16881	i0	57.1	1.81065088757396	49	18	87	2	164	18	43	88	MCC6559247.1 DUF427 domain-containing protein [Polyangiaceae bacterium]	diamond	306	58.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
29420285	29420285	PRJNA721440_S_NODE_10069_length_204_cov_2.929032_g9943_i0	PRJNA721440	10069	204	2.929032	5.97522528	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	44.3	0.00647	NR	TNE43825.1	2026735	g9943	i0	44.4	0.661764705882353	45	24	64.7	1	183	52	44	88	TNE43825.1 MAG: hypothetical protein EP343_32135 [Deltaproteobacteria bacterium]	diamond	135	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30178350	30178350	PRJNA721440_S_NODE_18572_length_165_cov_1.189655_g18446_i0	PRJNA721440	18572	165	1.189655	1.96293075	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	63.2	6.37e-10	NR	RYZ16325.1	2484252	g18446	i0	56.9	0.927272727272727	51	22	92.7	0	163	11	162	212	RYZ16325.1 MAG: solute carrier family 25 protein, partial [Myxococcaceae bacterium]	diamond	153	63.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
30715484	30715484	PRJNA721440_S_NODE_10974_length_198_cov_2.791946_g10848_i0	PRJNA721440	10974	198	2.791946	5.52805308	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	63.2	9.08e-10	NR	RYF04405.1	2026735	g10848	i0	37.9	1	66	40	98.5	1	196	2	137	202	RYF04405.1 MAG: hypothetical protein EOO40_11245, partial [Deltaproteobacteria bacterium]	diamond	198	63.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30936876	30936876	PRJNA721440_S_NODE_19034_length_164_cov_0.904348_g18908_i0	PRJNA721440	19034	164	0.904348	1.48313072	Polyangiales bacterium	3034171	Bacteria	Bacteria	42.4	0.0175	NR	HET8933717.1	3034171	g18908	i0	34	1.9390243902439	53	35	97	0	1	159	318	370	HET8933717.1 serpin family protein [Polyangiales bacterium]	diamond	318	42.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
31168072	31168072	PRJNA721440_S_NODE_1055_length_510_cov_6.080260_g931_i0	PRJNA721440	1055	510	6.08026	31.009326	Pseudomonadati	3379134	Bacteria	Bacteria	190	2.8199999999999997e-56	NR	WP_044191788.1	394096	g931	i0	63.3	6.54705882352941	139	51	81.8	0	428	12	2	140	WP_044191788.1 zinc-dependent alcohol dehydrogenase [Hyalangium minutum]	diamond	3339	190	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Hyalangium	Hyalangium minutum
31347748	31347748	PRJNA721440_S_NODE_5996_length_247_cov_3.242424_g5870_i0	PRJNA721440	5996	247	3.242424	8.00878728	Myxococcales bacterium	2026763	Bacteria	Bacteria	42	0.0423	NR	MCA9717801.1	2026763	g5870	i0	56.7	0.364372469635628	30	13	36.4	0	91	2	21	50	MCA9717801.1 CoA transferase subunit A [Myxococcales bacterium]	diamond	90	42	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32233675	32233675	PRJNA721440_S_NODE_12138_length_190_cov_6.964539_g12012_i0	PRJNA721440	12138	190	6.964539	13.2326241	Myxococcales bacterium	2026763	Bacteria	Bacteria	117	1.2399999999999999e-28	NR	NNK43378.1	2026763	g12012	i0	80.3	1.92631578947368	61	12	96.3	0	3	185	436	496	NNK43378.1 NADP-dependent isocitrate dehydrogenase [Myxococcales bacterium]	diamond	366	117	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);;