metadata: contig_metadata: 13 rows where bioproject = "PRJEB12237", tax_phylum = "Myxococcota" and tax

13 rows where bioproject = "PRJEB12237", 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
11188923	11188923	PRJEB12237_P_NODE_3089_length_387_cov_3.250000_g2893_i0	PRJEB12237	3089	387	3.25	12.5775	Pseudomonadati	3379134	Bacteria	Bacteria	95.5	4.409999999999999e-23	NR	MCD6280016.1	2026735	g2893	i0	67.1	4.27131782945736	70	19	54.3	1	122	331	4	69	MCD6280016.1 cold-shock protein [Deltaproteobacteria bacterium]	diamond	1653	95.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
17872313	17872313	PRJEB12237_P_NODE_4015_length_323_cov_1.347222_g3819_i0	PRJEB12237	4015	323	1.347222	4.35152706	Pseudomonadati	3379134	Bacteria	Bacteria	146	2.33e-39	NR	MBI1947140.1	2026735	g3819	i0	66.7	6	108	35	99.4	1	3	323	225	332	MBI1947140.1 NADP-dependent isocitrate dehydrogenase [Deltaproteobacteria bacterium]	diamond	1938	147	0.993197278911565	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
20421343	20421343	PRJEB12237_P_NODE_3617_length_347_cov_1.381410_g3421_i0	PRJEB12237	3617	347	1.38141	4.7934927	Pseudomonadati	3379134	Bacteria	Bacteria	215	3.92e-66	NR	WP_146654455.1	1391654	g3421	i0	92.1	94.8155619596542	114	9	98.6	0	345	4	292	405	WP_146654455.1 NADP-dependent isocitrate dehydrogenase [Labilithrix luteola]	diamond	32901	216	0.99537037037037	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
26716029	26716029	PRJEB12237_P_NODE_8921_length_182_cov_1.088435_g8725_i0	PRJEB12237	8921	182	1.088435	1.9809517	Myxococcales bacterium	2026763	Bacteria	Bacteria	45.8	0.00103	NR	MBK8215412.1	2026763	g8725	i0	43.4	2.75274725274725	53	24	87.4	1	176	18	155	201	MBK8215412.1 glutathione S-transferase family protein [Myxococcales bacterium]	diamond	501	45.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
26937916	26937916	PRJEB12237_P_NODE_9602_length_173_cov_1.391304_g9406_i0	PRJEB12237	9602	173	1.391304	2.40695592	Myxococcales bacterium	2026763	Bacteria	Bacteria	42.7	0.0146	NR	MAO83026.1	2026763	g9406	i0	42.9	0.84971098265896	49	25	85	2	16	162	16	61	MAO83026.1 hypothetical protein [Myxococcales bacterium]	diamond	147	42.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27222421	27222421	PRJEB12237_P_NODE_10963_length_159_cov_2.258065_g10767_i0	PRJEB12237	10963	159	2.258065	3.59032335	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	65.1	1.58e-10	NR	MBN2845406.1	2026735	g10767	i0	63.3	3.69811320754717	49	16	92.5	1	159	13	443	489	MBN2845406.1 hydroxylamine reductase [Deltaproteobacteria bacterium]	diamond	588	65.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27816621	27816621	PRJEB12237_P_NODE_9444_length_175_cov_1.414286_g9248_i0	PRJEB12237	9444	175	1.414286	2.4750005	Archangiaceae	39	Bacteria	Bacteria	98.6	3.23e-22	NR	WP_083967961.1	394096	g9248	i0	78.6	8.70857142857143	56	12	96	0	1	168	578	633	WP_083967961.1 peptidoglycan-binding protein [Hyalangium minutum]	diamond	1524	98.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Hyalangium	Hyalangium minutum
28448077	28448077	PRJEB12237_P_NODE_10946_length_160_cov_0.952000_g10750_i0	PRJEB12237	10946	160	0.952	1.5232	Nannocystis	53	Bacteria	Bacteria	68.2	1.09e-11	NR	HEY0134472.1	1962667	g10750	i0	62.7	2.86875	51	19	95.6	0	155	3	228	278	HEY0134472.1 TauD/TfdA family dioxygenase [Nannocystis sp.]	diamond	459	68.2	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
28927797	28927797	PRJEB12237_P_NODE_9468_length_175_cov_1.135714_g9272_i0	PRJEB12237	9468	175	1.135714	1.9874995	Stigmatella erecta	83460	Bacteria	Bacteria	50.4	2.8e-5	NR	WP_143076215.1	83460	g9272	i0	37.7	3.36	69	30	96	3	7	174	148	216	WP_143076215.1 hypothetical protein [Stigmatella erecta]	diamond	588	50.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella erecta
29079476	29079476	PRJEB12237_P_NODE_6328_length_230_cov_1.876923_g6132_i0	PRJEB12237	6328	230	1.876923	4.3169229	root	1	Root_unresolved	Root_unresolved	78.6	2.77e-15	NR	TNE49017.1	2026735	g6132	i0	49.3	6.83478260869565	75	36	97.8	1	225	1	46	118	TNE49017.1 MAG: alpha/beta hydrolase [Deltaproteobacteria bacterium]	diamond	1572	79.3	0.991172761664565	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30664906	30664906	PRJEB12237_P_NODE_1373_length_616_cov_2.528399_g1204_i0	PRJEB12237	1373	616	2.528399	15.57493784	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	179	4.81e-53	NR	HLT31923.1	2484252	g1204	i0	49.7	2.63961038961039	187	91	91.1	2	614	54	19	202	HLT31923.1 glutathione binding-like protein [Myxococcaceae bacterium]	diamond	1626	179	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
31391982	31391982	PRJEB12237_P_NODE_6516_length_225_cov_2.494737_g6320_i0	PRJEB12237	6516	225	2.494737	5.61315825	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	67	4.08e-12	NR	HZF54429.1	2268199	g6320	i0	46.9	2.52	64	34	85.3	0	5	196	61	124	HZF54429.1 hypothetical protein [Polyangiaceae bacterium]	diamond	567	67	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31423412	31423412	PRJEB12237_P_NODE_11016_length_159_cov_1.290323_g10820_i0	PRJEB12237	11016	159	1.290323	2.05161357	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	84.7	2.65e-19	NR	MEZ4441762.1	2268199	g10820	i0	71.2	0.981132075471698	52	15	98.1	0	156	1	58	109	MEZ4441762.1 DUF962 domain-containing protein [Polyangiaceae bacterium]	diamond	156	84.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae 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);;