metadata: contig_metadata: 26 rows where bioproject = "PRJNA382357" and tax

26 rows where bioproject = "PRJNA382357" 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
13158472	13158472	PRJNA382357_P_NODE_98991_length_243_cov_2.065934_g98252_i0	PRJNA382357	98991	243	2.065934	5.02021962	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	313	9.1e-81	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g98252	i0	91.102	155.053497942387	236	13	97	5	12	243	3486087	3485856	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	37678	313	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15705117	15705117	PRJNA382357_P_NODE_108453_length_233_cov_14.127907_g107714_i0	PRJNA382357	108453	233	14.127907	32.91802331	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	191	4.23e-44	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g107714	i0	95.763	11.8969957081545	118	5	52	0	1	118	1903350	1903467	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	2772	191	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19528890	19528890	PRJNA382357_P_NODE_15136_length_554_cov_3.160243_g14413_i0	PRJNA382357	15136	554	3.160243	17.50774622	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	542	2.65e-149	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g14413	i0	94.382	109.379061371841	356	14	99	5	202	554	3042749	3043101	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	60596	542	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
21476547	21476547	PRJNA382357_P_NODE_165037_length_185_cov_4.032258_g164298_i0	PRJNA382357	165037	185	4.032258	7.4596773	FCB group	1783270	Bacteria	Bacteria	75	3.37e-9	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g164298	i0	82.927	3.91891891891892	82	14	44	0	1	82	169529	169610	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	725	75	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24630960	24630960	PRJNA382357_P_NODE_88700_length_255_cov_1.768041_g87961_i0	PRJNA382357	88700	255	1.768041	4.50850455	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	215	2.79e-51	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g87961	i0	93.197	23.7529411764706	147	9	78	1	103	249	2228201	2228346	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	6057	215	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26695111	26695111	PRJNA382357_P_NODE_171781_length_167_cov_2.471698_g171042_i0	PRJNA382357	171781	167	2.471698	4.12773566	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	60.8	5.21e-9	NR	HEU5260142.1	2448054	g171042	i0	80	0.718562874251497	40	7	70.1	1	44	160	306	345	HEU5260142.1 chromate efflux transporter [Gemmatimonadales bacterium]	diamond	120	60.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27422964	27422964	PRJNA382357_P_NODE_24543_length_451_cov_1.143590_g23806_i0	PRJNA382357	24543	451	1.14359	5.1575909	Gemmatimonas sp.	1962908	Bacteria	Bacteria	106	2.56e-25	NR	WP_353269536.1	1962908	g23806	i0	77	0.405764966740576	61	14	40.6	0	187	5	32	92	WP_353269536.1 DUF1376 domain-containing protein [Gemmatimonas sp.]	diamond	183	106	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp.
27485889	27485889	PRJNA382357_P_NODE_157563_length_199_cov_61.579710_g156824_i0	PRJNA382357	157563	199	61.57971	122.5436229	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	52.4	8.55e-6	NR	MBI4421429.1	2026742	g156824	i0	64.7	0.512562814070352	34	12	51.3	0	199	98	517	550	MBI4421429.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	102	52.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27770299	27770299	PRJNA382357_P_NODE_76204_length_273_cov_1.132075_g75465_i0	PRJNA382357	76204	273	1.132075	3.09056475	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	108	9.76e-26	NR	MEY4956711.1	2026742	g75465	i0	75.8	0.725274725274725	66	15	72.5	1	270	73	27	91	MEY4956711.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	198	108	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28464794	28464794	PRJNA382357_P_NODE_159206_length_196_cov_23.266667_g158467_i0	PRJNA382357	159206	196	23.266667	45.60266732	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	65.1	2.48e-10	NR	MDP9280377.1	2026742	g158467	i0	51.4	1.07142857142857	70	9	68.9	1	6	140	171	240	MDP9280377.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	210	65.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28969886	28969886	PRJNA382357_P_NODE_157628_length_199_cov_20.318841_g156889_i0	PRJNA382357	157628	199	20.318841	40.43449359	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	61.6	4.62e-9	NR	HEU5260135.1	2448054	g156889	i0	74.4	1.95979899497487	43	11	64.8	0	199	71	276	318	HEU5260135.1 Calx-beta domain-containing protein [Gemmatimonadales bacterium]	diamond	390	61.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29001868	29001868	PRJNA382357_P_NODE_57468_length_308_cov_25.716599_g56729_i0	PRJNA382357	57468	308	25.716599	79.20712492	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	112	3.79e-26	NR	MCR4339819.1	2026741	g56729	i0	65.8	0.769480519480519	79	26	76.9	1	306	70	249	326	MCR4339819.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	237	112	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29018674	29018674	PRJNA382357_P_NODE_108968_length_233_cov_1.511628_g108229_i0	PRJNA382357	108968	233	1.511628	3.52209324	Bacteria	2	Bacteria	Bacteria	133	1.91e-35	NR	HEU4879051.1	2026741	g108229	i0	86.7	3.91416309012876	75	10	96.6	0	7	231	84	158	HEU4879051.1 M24 family metallopeptidase [Gemmatimonadaceae bacterium]	diamond	912	134	0.992537313432836	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29128001	29128001	PRJNA382357_P_NODE_79989_length_267_cov_1.140777_g79250_i0	PRJNA382357	79989	267	1.140777	3.04587459	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	60.1	3.98e-8	NR	MBU6364778.1	2026742	g79250	i0	55.4	0.730337078651685	65	28	73	1	52	246	441	504	MBU6364778.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	195	60.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29885687	29885687	PRJNA382357_P_NODE_167431_length_179_cov_3.457627_g166692_i0	PRJNA382357	167431	179	3.457627	6.18915233	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	65.9	1.1e-10	NR	HEY7568779.1	2026741	g166692	i0	78.9	1.4413407821229	38	7	62	1	46	156	381	418	HEY7568779.1 amylo-alpha-1,6-glucosidase [Gemmatimonadaceae bacterium]	diamond	258	65.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29980308	29980308	PRJNA382357_P_NODE_155631_length_202_cov_0.921986_g154892_i0	PRJNA382357	155631	202	0.921986	1.86241172	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	55.8	5.81e-8	NR	MEW5927609.1	2026742	g154892	i0	61.7	8.27227722772277	47	18	69.8	0	198	58	58	104	MEW5927609.1 type II toxin-antitoxin system PrlF family antitoxin [Gemmatimonadota bacterium]	diamond	1671	55.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30643633	30643633	PRJNA382357_P_NODE_158313_length_198_cov_6.255474_g157574_i0	PRJNA382357	158313	198	6.255474	12.38583852	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	92	5.18e-20	NR	MCX5756623.1	2026742	g157574	i0	100	0.621212121212121	41	0	62.1	0	43	165	107	147	MCX5756623.1 serine hydrolase [Gemmatimonadota bacterium]	diamond	123	92	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30770368	30770368	PRJNA382357_P_NODE_81794_length_264_cov_3.916256_g81055_i0	PRJNA382357	81794	264	3.916256	10.33891584	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	44.7	0.0101	NR	HEV8399368.1	2448054	g81055	i0	69	0.659090909090909	29	9	33	0	91	5	754	782	HEV8399368.1 C1 family peptidase [Gemmatimonadales bacterium]	diamond	174	44.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30991419	30991419	PRJNA382357_P_NODE_129094_length_215_cov_1.597403_g128355_i0	PRJNA382357	129094	215	1.597403	3.43441645	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	48.9	1.71e-4	NR	HWE43700.1	2026741	g128355	i0	75.9	1.21395348837209	29	7	40.5	0	130	44	208	236	HWE43700.1 bifunctional UDP-sugar hydrolase/5'-nucleotidase [Gemmatimonadaceae bacterium]	diamond	261	48.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31528925	31528925	PRJNA382357_P_NODE_160396_length_194_cov_7.428571_g159657_i0	PRJNA382357	160396	194	7.428571	14.41142774	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	81.3	5.16e-16	NR	PHX96046.1	2026742	g159657	i0	83	0.72680412371134	47	8	72.7	0	194	54	578	624	PHX96046.1 MAG: fatty acid oxidation complex subunit alpha FadJ [Gemmatimonadota bacterium]	diamond	141	81.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
31686843	31686843	PRJNA382357_P_NODE_142537_length_207_cov_9.479452_g141798_i0	PRJNA382357	142537	207	9.479452	19.62246564	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	43.5	0.0119	NR	HMH56730.1	2448054	g141798	i0	66.7	1.7536231884058	24	8	34.8	0	59	130	1	24	HMH56730.1 GDP-mannose 4,6-dehydratase [Gemmatimonadales bacterium]	diamond	363	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31781626	31781626	PRJNA382357_P_NODE_104397_length_237_cov_5.653409_g103658_i0	PRJNA382357	104397	237	5.653409	13.39857933	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	65.1	4.32e-10	NR	HZB27312.1	2448054	g103658	i0	52.7	0.69620253164557	55	26	69.6	0	181	17	84	138	HZB27312.1 glycosyltransferase family 4 protein [Gemmatimonadales bacterium]	diamond	165	65.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31939942	31939942	PRJNA382357_P_NODE_99577_length_242_cov_24.701657_g98838_i0	PRJNA382357	99577	242	24.701657	59.77800994	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	52.8	3.94e-6	NR	HEX3273600.1	2448054	g98838	i0	62.9	0.855371900826446	35	13	43.4	0	171	67	135	169	HEX3273600.1 transposase [Gemmatimonadales bacterium]	diamond	207	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32193224	32193224	PRJNA382357_P_NODE_165118_length_184_cov_287.024390_g164379_i0	PRJNA382357	165118	184	287.02439	528.1248776	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	49.7	5.68e-5	NR	PHX97479.1	2026742	g164379	i0	84	1.48369565217391	25	3	40.8	1	182	108	122	145	PHX97479.1 MAG: hypothetical protein CK531_03255 [Gemmatimonadota bacterium]	diamond	273	49.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32288469	32288469	PRJNA382357_P_NODE_90139_length_253_cov_7.244792_g89400_i0	PRJNA382357	90139	253	7.244792	18.32932376	Longimicrobium sp.	2029185	Bacteria	Bacteria	107	9.25e-27	NR	HEU0297969.1	2029185	g89400	i0	95.2	0.74703557312253	63	1	72.3	1	65	247	1	63	HEU0297969.1 sugar ABC transporter permease [Longimicrobium sp.]	diamond	189	107	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32747137	32747137	PRJNA382357_P_NODE_149420_length_204_cov_8.965035_g148681_i0	PRJNA382357	149420	204	8.965035	18.2886714	Bacteria	2	Bacteria	Bacteria	53.1	4.41e-6	NR	HEX4931608.1	2026741	g148681	i0	71.1	1.11764705882353	38	11	55.9	0	3	116	248	285	HEX4931608.1 proton-conducting transporter membrane subunit [Gemmatimonadaceae bacterium]	diamond	228	53.5	0.992523364485981	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae 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);;