metadata: contig_metadata: 8 rows where bioproject = "PRJEB50332", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJEB50332", tax_kingdom = "Pseudomonadati" 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
15019057	15019057	PRJEB50332_P_NODE_11912_length_214_cov_1.352941_g11830_i0	PRJEB50332	11912	214	1.352941	2.89529374	Archangium	47	Bacteria	Bacteria	161	3e-35	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g11830	i0	81.281	6.49532710280374	203	34	94	4	1	201	2331403	2331603	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	1390	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
28069106	28069106	PRJEB50332_P_NODE_7825_length_237_cov_1.107955_g7743_i0	PRJEB50332	7825	237	1.107955	2.62585335	root	1	Root_unresolved	Root_unresolved	80.5	1.61e-15	NR	WP_129344401.1	56	g7743	i0	53.9	11.3164556962025	76	34	94.9	1	227	3	204	279	WP_129344401.1 M20 family metallopeptidase [Sorangium cellulosum]	diamond	2682	80.9	0.995055624227441	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
28139275	28139275	PRJEB50332_P_NODE_8865_length_231_cov_1.282353_g8783_i0	PRJEB50332	8865	231	1.282353	2.96223543	Myxococcales bacterium	2026763	Bacteria	Bacteria	164	3.34e-46	NR	MBL9027325.1	2026763	g8783	i0	96.1	0.987012987012987	76	3	98.7	0	229	2	249	324	MBL9027325.1 outer membrane protein transport protein [Myxococcales bacterium]	diamond	228	164	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29212702	29212702	PRJEB50332_P_NODE_11929_length_214_cov_1.274510_g11847_i0	PRJEB50332	11929	214	1.27451	2.7274514	Bradymonadia bacterium	3121696	Bacteria	Bacteria	92.8	1.57e-20	NR	MFT6396027.1	3121696	g11847	i0	75	3.14018691588785	56	14	78.5	0	170	3	3	58	MFT6396027.1 malate dehydrogenase [Bradymonadia bacterium]	diamond	672	92.8	1	Bacteria	Pseudomonadati	Myxococcota	Bradymonadia				Bradymonadia bacterium
30381495	30381495	PRJEB50332_P_NODE_4193_length_291_cov_1.469565_g4111_i0	PRJEB50332	4193	291	1.469565	4.27643415	Myxococcales bacterium	2026763	Bacteria	Bacteria	86.3	2.04e-19	NR	MCA9640749.1	2026763	g4111	i0	83.3	0.556701030927835	54	9	55.7	0	1	162	58	111	MCA9640749.1 hypothetical protein [Myxococcales bacterium]	diamond	162	86.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30500759	30500759	PRJEB50332_P_NODE_18313_length_194_cov_2.571429_g18231_i0	PRJEB50332	18313	194	2.571429	4.98857226	Archangiaceae	39	Bacteria	Bacteria	42.4	0.0269	NR	WP_157232090.1	394096	g18231	i0	51.2	2.52061855670103	43	20	66.5	1	61	189	559	600	WP_157232090.1 hypothetical protein [Hyalangium minutum]	diamond	489	42.7	0.992974238875878	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Hyalangium	Hyalangium minutum
30728603	30728603	PRJEB50332_P_NODE_7974_length_236_cov_1.314286_g7892_i0	PRJEB50332	7974	236	1.314286	3.10171496	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	56.2	5.36e-7	NR	MEZ4444961.1	2268199	g7892	i0	46.5	1.83050847457627	71	36	89	2	210	1	52	121	MEZ4444961.1 endonuclease/exonuclease/phosphatase family protein [Polyangiaceae bacterium]	diamond	432	56.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31638536	31638536	PRJEB50332_P_NODE_1856_length_412_cov_1.293447_g1775_i0	PRJEB50332	1856	412	1.293447	5.32900164	Pseudomonadati	3379134	Bacteria	Bacteria	96.3	9.27e-21	NR	TNE50174.1	2026735	g1775	i0	43.3	3.13106796116505	97	54	69.9	1	18	305	181	277	TNE50174.1 MAG: hypothetical protein EP343_09595 [Deltaproteobacteria bacterium]	diamond	1290	97.1	0.991761071060762	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);;