metadata: contig_metadata: 10 rows where bioproject = "PRJNA772154" and tax

10 rows where bioproject = "PRJNA772154" and tax_phylum = "Gemmatimonadota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
747370	747370	PRJNA772154_P_NODE_19021_length_250_cov_0.881356_g18836_i0	PRJNA772154	19021	250	0.881356	2.20339	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	165	3.07e-45	NR	MEZ4425688.1	2026742	g18836	i0	91.6	0.996	83	7	99.6	0	1	249	78	160	MEZ4425688.1 amidohydrolase family protein [Gemmatimonadota bacterium]	diamond	249	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
747414	747414	PRJNA772154_P_NODE_20781_length_246_cov_0.901734_g20596_i0	PRJNA772154	20781	246	0.901734	2.21826564	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	261	3.39e-65	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g20596	i0	86.179	82.5528455284553	246	29	99	5	1	244	3042802	3042560	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	20308	261	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
27527228	27527228	PRJNA772154_P_NODE_18263_length_252_cov_0.871508_g18078_i0	PRJNA772154	18263	252	0.871508	2.19620016	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	97.4	3.39e-22	NR	HKC39232.1	2448054	g18078	i0	61	0.976190476190476	82	32	97.6	0	252	7	206	287	HKC39232.1 DcaP family trimeric outer membrane transporter [Gemmatimonadales bacterium]	diamond	246	97.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28632569	28632569	PRJNA772154_P_NODE_18907_length_250_cov_0.881356_g18722_i0	PRJNA772154	18907	250	0.881356	2.20339	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	170	1.04e-50	NR	MCA9722350.1	2026742	g18722	i0	96.3	0.984	82	3	98.4	0	247	2	189	270	MCA9722350.1 ribosome small subunit-dependent GTPase A [Gemmatimonadota bacterium]	diamond	246	170	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28916277	28916277	PRJNA772154_P_NODE_21408_length_245_cov_0.906977_g21223_i0	PRJNA772154	21408	245	0.906977	2.22209365	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	79	6.8e-15	NR	MFN8580229.1	2026741	g21223	i0	52.6	1.91020408163265	78	35	94.3	2	8	238	65	141	MFN8580229.1 EAL domain-containing protein [Gemmatimonadaceae bacterium]	diamond	468	79	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30021870	30021870	PRJNA772154_P_NODE_20851_length_246_cov_0.901734_g20666_i0	PRJNA772154	20851	246	0.901734	2.21826564	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	119	6.18e-30	NR	MCA9720879.1	2026742	g20666	i0	100	0.695121951219512	57	0	69.5	0	1	171	317	373	MCA9720879.1 beta-lactamase family protein [Gemmatimonadota bacterium]	diamond	171	119	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30969740	30969740	PRJNA772154_P_NODE_19114_length_250_cov_0.881356_g18929_i0	PRJNA772154	19114	250	0.881356	2.20339	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	154	2.43e-41	NR	MCA9738377.1	2026742	g18929	i0	95.2	0.996	83	4	99.6	0	249	1	8	90	MCA9738377.1 HEAT repeat domain-containing protein [Gemmatimonadota bacterium]	diamond	249	154	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31507222	31507222	PRJNA772154_P_NODE_17996_length_252_cov_0.871508_g17811_i0	PRJNA772154	17996	252	0.871508	2.19620016	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	84	6.51e-17	NR	MBK7908416.1	2026742	g17811	i0	100	0.5	42	0	50	0	251	126	307	348	MBK7908416.1 Gfo/Idh/MocA family oxidoreductase [Gemmatimonadota bacterium]	diamond	126	84	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32139780	32139780	PRJNA772154_P_NODE_18978_length_250_cov_0.881356_g18793_i0	PRJNA772154	18978	250	0.881356	2.20339	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	139	4.93e-38	NR	HET9383629.1	2448054	g18793	i0	85.5	0.996	83	12	99.6	0	1	249	68	150	HET9383629.1 MBL fold metallo-hydrolase [Gemmatimonadales bacterium]	diamond	249	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32234931	32234931	PRJNA772154_P_NODE_19038_length_250_cov_0.881356_g18853_i0	PRJNA772154	19038	250	0.881356	2.20339	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	153	3.39e-41	NR	MCA9738293.1	2026742	g18853	i0	95.2	0.996	83	4	99.6	0	249	1	656	738	MCA9738293.1 UvrD-helicase domain-containing protein [Gemmatimonadota bacterium]	diamond	249	153	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;