metadata: contig_metadata: 10 rows where bioproject = "PRJNA861969" and tax

10 rows where bioproject = "PRJNA861969" 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
3788418	3788418	PRJNA861969_P_NODE_9063_length_429_cov_1.081461_g8832_i0	PRJNA861969	9063	429	1.081461	4.63946769	Archangiaceae	39	Bacteria	Bacteria	680	0	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g8832	i0	98.446	211.452214452214	386	6	99	0	44	429	452593	452978	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	90713	680	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
7224815	7224815	PRJNA861969_P_NODE_4186_length_640_cov_1.606702_g3959_i0	PRJNA861969	4186	640	1.606702	10.2828928	Cystobacter fuscus	43	Bacteria	Bacteria	1149	0	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g3959	i0	99.062	243.2	640	6	100	0	1	640	7643749	7643110	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	155648	1149	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
12325811	12325811	PRJNA861969_P_NODE_4950_length_582_cov_2.298625_g4720_i0	PRJNA861969	4950	582	2.298625	13.3779975	Cystobacter fuscus	43	Bacteria	Bacteria	1070	0	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g4720	i0	99.828	277.79381443299	582	1	100	0	1	582	452320	451739	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	161676	1070	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
27505834	27505834	PRJNA861969_P_NODE_25343_length_274_cov_1.184080_g25112_i0	PRJNA861969	25343	274	1.18408	3.2443792	Polyangiaceae	49	Bacteria	Bacteria	84	5.71e-17	NR	MFT3772076.1	1971901	g25112	i0	65.6	1.99270072992701	61	20	65.7	1	270	91	238	298	MFT3772076.1 ion channel [Minicystis sp.]	diamond	546	84	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis sp.
27655569	27655569	PRJNA861969_P_NODE_11124_length_389_cov_1.161392_g10893_i0	PRJNA861969	11124	389	1.161392	4.51781488	Myxococcota bacterium	2818507	Bacteria	Bacteria	45.8	0.0129	NR	MCK6575926.1	2818507	g10893	i0	48.1	0.416452442159383	54	27	40.9	1	165	7	8	61	MCK6575926.1 serine/threonine protein kinase [Myxococcota bacterium]	diamond	162	45.8	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27781777	27781777	PRJNA861969_P_NODE_37304_length_245_cov_0.895349_g37073_i0	PRJNA861969	37304	245	0.895349	2.19360505	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	136	2.39e-35	NR	MDB5219357.1	2484252	g37073	i0	87.7	0.991836734693878	81	10	99.2	0	243	1	76	156	MDB5219357.1 Lipid export ATP-binding/permease protein MsbA [Myxococcaceae bacterium]	diamond	243	136	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
27844619	27844619	PRJNA861969_P_NODE_24784_length_276_cov_2.113300_g24553_i0	PRJNA861969	24784	276	2.1133	5.832708	Archangium primigenium	2792470	Bacteria	Bacteria	108	1.0400000000000002e-27	NR	WP_204486456.1	2792470	g24553	i0	98.2	0.608695652173913	56	1	60.9	0	109	276	1	56	WP_204486456.1 GNAT family N-acetyltransferase [Archangium primigenium]	diamond	168	108	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	[Archangium] primigenium
29968489	29968489	PRJNA861969_P_NODE_26791_length_267_cov_1.587629_g26560_i0	PRJNA861969	26791	267	1.587629	4.23896943	Myxococcia	32015	Bacteria	Bacteria	73.9	1.84e-13	NR	MCA9587853.1	2026763	g26560	i0	51.1	1.98876404494382	92	42	100	1	1	267	148	239	MCA9587853.1 GNAT family N-acetyltransferase [Myxococcales bacterium]	diamond	531	73.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31287292	31287292	PRJNA861969_P_NODE_22435_length_287_cov_1.439252_g22204_i0	PRJNA861969	22435	287	1.439252	4.13065324	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	111	1.57e-26	NR	MBK6921356.1	2026735	g22204	i0	59.8	0.857142857142857	82	32	84.7	1	2	244	262	343	MBK6921356.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	246	111	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32268268	32268268	PRJNA861969_P_NODE_41958_length_241_cov_0.916667_g41727_i0	PRJNA861969	41958	241	0.916667	2.20916747	Archangium gephyra	48	Bacteria	Bacteria	134	1e-37	NR	PZR04419.1	48	g41727	i0	91.8	0.908713692946058	73	6	90.9	0	3	221	120	192	PZR04419.1 MAG: hypothetical protein DI536_34240 [Archangium gephyra]	diamond	219	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra

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