metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA784979" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA784979" 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
27085316	27085316	PRJNA784979_S_NODE_10942_length_166_cov_0.871795_g10900_i0	PRJNA784979	10942	166	0.871795	1.4471797	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	57.8	6.56e-8	NR	MET0790993.1	2268199	g10900	i0	47.3	0.993975903614458	55	29	99.4	0	2	166	344	398	MET0790993.1 hypothetical protein [Polyangiaceae bacterium]	diamond	165	57.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27622483	27622483	PRJNA784979_S_NODE_10944_length_166_cov_0.871795_g10902_i0	PRJNA784979	10944	166	0.871795	1.4471797	Archangium sp.	1872627	Bacteria	Bacteria	68.6	7.67e-12	NR	MDP1827653.1	1872627	g10902	i0	65.4	3.68674698795181	52	18	94	0	6	161	4	55	MDP1827653.1 hypothetical protein [Archangium sp.]	diamond	612	68.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
27748895	27748895	PRJNA784979_S_NODE_13284_length_161_cov_0.910714_g13242_i0	PRJNA784979	13284	161	0.910714	1.46624954	Archangiaceae bacterium	2684409	Bacteria	Bacteria	49.7	4.35e-5	NR	MBK7860774.1	2684409	g13242	i0	50	1.00621118012422	54	26	98.8	1	159	1	754	807	MBK7860774.1 zinc-ribbon domain-containing protein [Archangiaceae bacterium]	diamond	162	49.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae		Archangiaceae bacterium
29358976	29358976	PRJNA784979_S_NODE_12649_length_162_cov_1.433628_g12607_i0	PRJNA784979	12649	162	1.433628	2.32247736	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	79.7	6.89e-16	NR	MCC6809955.1	2026735	g12607	i0	72.3	0.87037037037037	47	13	87	0	159	19	226	272	MCC6809955.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	141	79.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30401675	30401675	PRJNA784979_S_NODE_7013_length_191_cov_0.894366_g6971_i0	PRJNA784979	7013	191	0.894366	1.70823906	Myxococcota bacterium	2818507	Bacteria	Bacteria	41.2	0.0488	NR	MEN0065938.1	2818507	g6971	i0	45.7	0.722513089005236	46	25	72.3	0	145	8	80	125	MEN0065938.1 hypothetical protein [Myxococcota bacterium]	diamond	138	41.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31769625	31769625	PRJNA784979_S_NODE_11477_length_165_cov_0.879310_g11435_i0	PRJNA784979	11477	165	0.87931	1.4508615	Myxococcia	32015	Bacteria	Bacteria	110	1.7700000000000002e-26	NR	MES1188455.1	2026763	g11435	i0	86.8	2.89090909090909	53	7	96.4	0	164	6	91	143	MES1188455.1 M20/M25/M40 family metallo-hydrolase [Myxococcales bacterium]	diamond	477	110	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31918599	31918599	PRJNA784979_S_NODE_7517_length_186_cov_1.145985_g7475_i0	PRJNA784979	7517	186	1.145985	2.1315321	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	54.7	9.31e-7	NR	RLB63939.1	2026735	g7475	i0	54.4	1.82258064516129	57	24	91.9	2	173	3	13	67	RLB63939.1 MAG: hypothetical protein DRH08_10395 [Deltaproteobacteria bacterium]	diamond	339	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31981768	31981768	PRJNA784979_S_NODE_10298_length_167_cov_0.864407_g10256_i0	PRJNA784979	10298	167	0.864407	1.44355969	Myxococcales bacterium	2026763	Bacteria	Bacteria	90.5	1.18e-21	NR	MDO9018539.1	2026763	g10256	i0	82.1	1.0059880239521	56	9	98.8	1	3	167	57	112	MDO9018539.1 cupredoxin domain-containing protein [Myxococcales bacterium]	diamond	168	90.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32393238	32393238	PRJNA784979_S_NODE_12959_length_162_cov_0.902655_g12917_i0	PRJNA784979	12959	162	0.902655	1.4623011	Polyangiales bacterium	3034171	Bacteria	Bacteria	48.5	1.07e-4	NR	HET8940098.1	3034171	g12917	i0	52.9	2.81481481481481	51	24	94.4	0	161	9	154	204	HET8940098.1 hypothetical protein [Polyangiales bacterium]	diamond	456	48.5	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);;