metadata: contig_metadata: 13 rows where bioproject = "PRJNA760904" and tax

13 rows where bioproject = "PRJNA760904" 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
2018249	2018249	PRJNA760904_P_NODE_18182_length_245_cov_0.895349_g18125_i0	PRJNA760904	18182	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	141	3.9e-41	NR	MEJ2153491.1	2026742	g18125	i0	86.1	7.82448979591837	79	11	96.7	0	239	3	49	127	MEJ2153491.1 M28 family peptidase [Gemmatimonadota bacterium]	diamond	1917	141	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
7582935	7582935	PRJNA760904_P_NODE_10006_length_287_cov_1.761682_g9949_i0	PRJNA760904	10006	287	1.761682	5.05602734	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	151	7.17e-41	NR	MDH3290253.1	2026742	g9949	i0	73.4	1.96515679442509	94	25	98.3	0	287	6	171	264	MDH3290253.1 L-glutamate gamma-semialdehyde dehydrogenase [Gemmatimonadota bacterium]	diamond	564	151	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
9670705	9670705	PRJNA760904_P_NODE_5908_length_356_cov_1.088339_g5851_i0	PRJNA760904	5908	356	1.088339	3.87448684	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	184	3.54e-53	NR	MDZ7779024.1	2026742	g5851	i0	69.8	5.89044943820225	116	35	97.8	0	4	351	156	271	MDZ7779024.1 L-glutamate gamma-semialdehyde dehydrogenase [Gemmatimonadota bacterium]	diamond	2097	184	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28442854	28442854	PRJNA760904_P_NODE_1266_length_683_cov_1.267213_g1212_i0	PRJNA760904	1266	683	1.267213	8.65506479	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	127	7.439999999999998e-32	NR	MEO5902543.1	2026741	g1212	i0	35.8	4.68228404099561	215	131	91.8	3	668	42	45	258	MEO5902543.1 SDR family oxidoreductase [Gemmatimonadaceae bacterium]	diamond	3198	127	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28663815	28663815	PRJNA760904_P_NODE_8247_length_311_cov_1.294118_g8190_i0	PRJNA760904	8247	311	1.294118	4.02470698	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	70.1	1.79e-11	NR	MCU0623070.1	2026741	g8190	i0	40	1.91961414790997	100	57	95.5	2	11	307	42	139	MCU0623070.1 S8 family peptidase [Gemmatimonadaceae bacterium]	diamond	597	70.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28948149	28948149	PRJNA760904_P_NODE_13008_length_263_cov_1.826316_g12951_i0	PRJNA760904	13008	263	1.826316	4.80321108	Longimicrobium sp.	2029185	Bacteria	Bacteria	55.5	1.23e-6	NR	HEX2078858.1	2029185	g12951	i0	64.6	0.547528517110266	48	17	54.8	0	117	260	135	182	HEX2078858.1 DUF2382 domain-containing protein [Longimicrobium sp.]	diamond	144	55.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
29200671	29200671	PRJNA760904_P_NODE_12329_length_268_cov_2.384615_g12272_i0	PRJNA760904	12329	268	2.384615	6.3907682	Longimicrobium sp.	2029185	Bacteria	Bacteria	48.1	3.17e-4	NR	WP_331071924.1	2029185	g12272	i0	42.2	1.83582089552239	64	31	71.6	1	268	77	118	175	WP_331071924.1 YsnF/AvaK domain-containing protein [Longimicrobium sp.]	diamond	492	48.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
29390094	29390094	PRJNA760904_P_NODE_5689_length_361_cov_2.100694_g5632_i0	PRJNA760904	5689	361	2.100694	7.58350534	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	92.4	1.45e-19	NR	HKH91170.1	2026741	g5632	i0	54.6	4.0387811634349	97	44	80.6	0	1	291	211	307	HKH91170.1 DUF2382 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	1458	92.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29705249	29705249	PRJNA760904_P_NODE_12990_length_263_cov_2.463158_g12933_i0	PRJNA760904	12990	263	2.463158	6.47810554	Longimicrobium sp.	2029185	Bacteria	Bacteria	72	1.01e-12	NR	HEX2078858.1	2029185	g12933	i0	66	3.9467680608365	53	18	60.5	0	47	205	137	189	HEX2078858.1 DUF2382 domain-containing protein [Longimicrobium sp.]	diamond	1038	72	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30116170	30116170	PRJNA760904_P_NODE_1252_length_686_cov_2.314845_g1198_i0	PRJNA760904	1252	686	2.314845	15.8798367	Longimicrobium sp.	2029185	Bacteria	Bacteria	48.5	0.00863	NR	HEX2078858.1	2029185	g1198	i0	67.6	0.297376093294461	34	11	14.9	0	103	2	137	170	HEX2078858.1 DUF2382 domain-containing protein [Longimicrobium sp.]	diamond	204	48.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
30242805	30242805	PRJNA760904_P_NODE_5352_length_370_cov_2.414141_g5295_i0	PRJNA760904	5352	370	2.414141	8.9323217	Longimicrobium sp.	2029185	Bacteria	Bacteria	54.3	1.03e-5	NR	HEX2078858.1	2029185	g5295	i0	64.3	0.340540540540541	42	15	34.1	0	126	1	137	178	HEX2078858.1 DUF2382 domain-containing protein [Longimicrobium sp.]	diamond	126	54.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31918033	31918033	PRJNA760904_P_NODE_19517_length_243_cov_0.905882_g19460_i0	PRJNA760904	19517	243	0.905882	2.20129326	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	84.7	6.31e-17	NR	MDQ3606579.1	2026742	g19460	i0	47.4	3.92592592592593	78	40	96.3	1	7	240	282	358	MDQ3606579.1 S9 family peptidase [Gemmatimonadota bacterium]	diamond	954	84.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32202837	32202837	PRJNA760904_P_NODE_598_length_950_cov_1.611174_g557_i0	PRJNA760904	598	950	1.611174	15.306153	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	76.3	3.09e-11	NR	MBM3956824.1	2026742	g557	i0	35.3	0.527368421052632	167	92	51.8	5	148	639	83	236	MBM3956824.1 tandem-95 repeat protein [Gemmatimonadota bacterium]	diamond	501	76.3	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);;