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

10 rows where bioproject = "PRJNA682774", 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
25401202	25401202	PRJNA682774_P_NODE_1840_length_330_cov_1.517510_g1811_i0	PRJNA682774	1840	330	1.51751	5.007783	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	155	2.8899999999999995e-42	NR	MAY80483.1	2026735	g1811	i0	72.5	0.927272727272727	102	26	92.7	1	329	24	88	187	MAY80483.1 F0F1 ATP synthase subunit alpha [Deltaproteobacteria bacterium]	diamond	306	155	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27492981	27492981	PRJNA682774_P_NODE_4903_length_245_cov_0.906977_g4874_i0	PRJNA682774	4903	245	0.906977	2.22209365	Archangiaceae bacterium	2684409	Bacteria	Bacteria	137	8.049999999999999e-37	NR	MBM4779054.1	2684409	g4874	i0	100	0.991836734693878	81	0	99.2	0	245	3	56	136	MBM4779054.1 2-oxoglutarate dehydrogenase complex dihydrolipoyllysine-residue succinyltransferase [Archangiaceae bacterium]	diamond	243	137	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae		Archangiaceae bacterium
27619324	27619324	PRJNA682774_P_NODE_4504_length_247_cov_0.896552_g4475_i0	PRJNA682774	4504	247	0.896552	2.21448344	Myxococcota bacterium	2818507	Bacteria	Bacteria	51.6	3.09e-5	NR	MFT7620850.1	2818507	g4475	i0	45.2	0.753036437246964	62	32	75.3	1	243	58	211	270	MFT7620850.1 putative repeat protein (TIGR01451 family) [Myxococcota bacterium]	diamond	186	51.6	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27650928	27650928	PRJNA682774_P_NODE_5364_length_242_cov_0.923077_g5335_i0	PRJNA682774	5364	242	0.923077	2.23384634	Polyangia bacterium	3058050	Bacteria	Bacteria	57.8	1.85e-7	NR	HEY3358500.1	3058050	g5335	i0	46.7	0.929752066115702	75	36	93	1	238	14	491	561	HEY3358500.1 hypothetical protein [Polyangia bacterium]	diamond	225	57.8	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
27714366	27714366	PRJNA682774_P_NODE_5084_length_244_cov_0.912281_g5055_i0	PRJNA682774	5084	244	0.912281	2.22596564	Myxococcota bacterium	2818507	Bacteria	Bacteria	64.7	2.94e-10	NR	MFT5682882.1	2818507	g5055	i0	40.3	1.63524590163934	77	42	94.7	1	9	239	117	189	MFT5682882.1 endonuclease/exonuclease/phosphatase family metal-dependent hydrolase [Myxococcota bacterium]	diamond	399	64.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30461720	30461720	PRJNA682774_P_NODE_3173_length_261_cov_1.659574_g3144_i0	PRJNA682774	3173	261	1.659574	4.33148814	Myxococcota bacterium	2818507	Bacteria	Bacteria	105	1.41e-24	NR	MEE8557089.1	2818507	g3144	i0	56	1.85057471264368	84	37	96.6	0	259	8	48	131	MEE8557089.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Myxococcota bacterium]	diamond	483	105	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30808851	30808851	PRJNA682774_P_NODE_5094_length_244_cov_0.912281_g5065_i0	PRJNA682774	5094	244	0.912281	2.22596564	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	47.8	6.54e-4	NR	MCP4369292.1	2026735	g5065	i0	36.1	0.75	61	39	75	0	238	56	166	226	MCP4369292.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	183	47.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30935314	30935314	PRJNA682774_P_NODE_2774_length_278_cov_1.370732_g2745_i0	PRJNA682774	2774	278	1.370732	3.81063496	Archangium sp.	1872627	Bacteria	Bacteria	43.1	0.042	NR	MBL9038857.1	1872627	g2745	i0	30.8	0.841726618705036	78	54	84.2	0	264	31	737	814	MBL9038857.1 phosphoenolpyruvate carboxylase [Archangium sp.]	diamond	234	43.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
31282752	31282752	PRJNA682774_P_NODE_4815_length_245_cov_0.906977_g4786_i0	PRJNA682774	4815	245	0.906977	2.22209365	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	62	6.28e-9	NR	WP_053235180.1	927083	g4786	i0	57.4	0.575510204081633	47	20	57.6	0	2	142	693	739	WP_053235180.1 MopE-related protein [Sandaracinus amylolyticus]	diamond	141	62	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
31516162	31516162	PRJNA682774_P_NODE_2896_length_273_cov_1.215000_g2867_i0	PRJNA682774	2896	273	1.215	3.31695	root	1	Root_unresolved	Root_unresolved	119	1e-29	NR	WP_245913682.1	54	g2867	i0	59.3	8.8021978021978	86	35	94.5	0	14	271	318	403	WP_245913682.1 zinc-dependent alcohol dehydrogenase [Nannocystis exedens]	diamond	2403	120	0.991666666666667	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens

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