metadata: contig_metadata: 6 rows where bioproject = "PRJNA807347" and tax

6 rows where bioproject = "PRJNA807347" 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
27022540	27022540	PRJNA807347_P_NODE_8842_length_280_cov_1.487923_g8739_i0	PRJNA807347	8842	280	1.487923	4.1661844	Minicystis rosea	888845	Bacteria	Bacteria	64.3	5.63e-10	NR	APR84111.1	888845	g8739	i0	55.8	0.557142857142857	52	23	55.7	0	115	270	106	157	APR84111.1 Hypothetical protein A7982_09460 [Minicystis rosea]	diamond	156	64.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
27307178	27307178	PRJNA807347_P_NODE_16243_length_243_cov_1.652941_g16140_i0	PRJNA807347	16243	243	1.652941	4.01664663	Myxococcales bacterium	2026763	Bacteria	Bacteria	97.4	1.21e-21	NR	MBL9102114.1	2026763	g16140	i0	65	0.987654320987654	80	27	98.8	1	3	242	172	250	MBL9102114.1 class I SAM-dependent RNA methyltransferase [Myxococcales bacterium]	diamond	240	97.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28096443	28096443	PRJNA807347_P_NODE_14485_length_247_cov_0.890805_g14382_i0	PRJNA807347	14485	247	0.890805	2.20028835	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	179	6.03e-54	NR	GMV20048.1	2268199	g14382	i0	98.8	1.9919028340081	82	1	99.6	0	247	2	194	275	GMV20048.1 MAG: hypothetical protein AMXMBFR56_82720 [Polyangiaceae bacterium]	diamond	492	179	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30528032	30528032	PRJNA807347_P_NODE_12713_length_250_cov_1.751412_g12610_i0	PRJNA807347	12713	250	1.751412	4.37853	Myxococcales bacterium	2026763	Bacteria	Bacteria	115	2.72e-29	NR	MCA9773597.1	2026763	g12610	i0	100	0.744	62	0	74.4	0	63	248	1	62	MCA9773597.1 Fic family protein [Myxococcales bacterium]	diamond	186	115	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30970568	30970568	PRJNA807347_P_NODE_16874_length_242_cov_0.923077_g16771_i0	PRJNA807347	16874	242	0.923077	2.23384634	Myxococcales bacterium	2026763	Bacteria	Bacteria	105	6.19e-26	NR	MBX3250730.1	2026763	g16771	i0	58.2	0.979338842975207	79	33	97.9	0	239	3	131	209	MBX3250730.1 iron-sulfur cluster repair di-iron protein [Myxococcales bacterium]	diamond	237	105	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31358736	31358736	PRJNA807347_P_NODE_9316_length_275_cov_1.242574_g9213_i0	PRJNA807347	9316	275	1.242574	3.4170785	Myxococcales	29	Bacteria	Bacteria	126	3.81e-33	NR	WP_075004696.1	41	g9213	i0	71.3	3.07636363636364	94	24	99.3	1	3	275	44	137	WP_075004696.1 S66 peptidase family protein [Stigmatella aurantiaca]	diamond	846	126	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca

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