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

6 rows where bioproject = "PRJNA446034" 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
26823012	26823012	PRJNA446034_S_NODE_7601_length_279_cov_2.301653_g7564_i0	PRJNA446034	7601	279	2.301653	6.4216118700000004	Myxococcales bacterium	2026763	Bacteria	Bacteria	46.6	0.0024	NR	MBL8717817.1	2026763	g7564	i0	45.8	0.516129032258065	48	25	51.6	1	149	6	23	69	MBL8717817.1 hypothetical protein [Myxococcales bacterium]	diamond	144	46.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
26902654	26902654	PRJNA446034_S_NODE_45361_length_187_cov_17.046667_g45324_i0	PRJNA446034	45361	187	17.046667	31.87726729	Sorangium	39643	Bacteria	Bacteria	42.4	0.022	NR	KYF92803.1	56	g45324	i0	58.1	3.97860962566845	31	13	49.7	0	140	48	78	108	KYF92803.1 hypothetical protein BE17_40145, partial [Sorangium cellulosum]	diamond	744	42.7	0.992974238875878	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
29444171	29444171	PRJNA446034_S_NODE_21250_length_222_cov_10.183784_g21213_i0	PRJNA446034	21250	222	10.183784	22.60800048	Corallococcus interemptor	2316720	Bacteria	Bacteria	83.2	7.44e-19	NR	WP_147468539.1	2316720	g21213	i0	92.1	0.513513513513513	38	3	51.4	0	146	33	15	52	WP_147468539.1 reverse transcriptase domain-containing protein, partial [Corallococcus interemptor]	diamond	114	83.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus interemptor
30865834	30865834	PRJNA446034_S_NODE_38014_length_195_cov_7.702532_g37977_i0	PRJNA446034	38014	195	7.702532	15.0199374	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	61.6	3.13e-9	NR	HEX7601263.1	2268199	g37977	i0	76.7	0.661538461538462	43	10	66.2	0	66	194	164	206	HEX7601263.1 nucleoside triphosphate pyrophosphohydrolase [Polyangiaceae bacterium]	diamond	129	61.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31687867	31687867	PRJNA446034_S_NODE_67817_length_171_cov_0.992537_g67780_i0	PRJNA446034	67817	171	0.992537	1.69723827	Corallococcus interemptor	2316720	Bacteria	Bacteria	47.4	4.19e-5	NR	WP_208647468.1	2316720	g67780	i0	75.9	0.508771929824561	29	7	50.9	0	171	85	55	83	WP_208647468.1 hypothetical protein, partial [Corallococcus interemptor]	diamond	87	47.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus interemptor
31814428	31814428	PRJNA446034_S_NODE_30157_length_206_cov_3.384615_g30120_i0	PRJNA446034	30157	206	3.384615	6.9723069	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	128	1.18e-33	NR	RYF10413.1	2026735	g30120	i0	100	0.888349514563107	61	0	88.8	0	23	205	312	372	RYF10413.1 MAG: hypothetical protein EOO40_05200, partial [Deltaproteobacteria bacterium]	diamond	183	128	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria 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);;