metadata: contig_metadata: 33 rows where bioproject = "PRJNA1148190" and tax

33 rows where bioproject = "PRJNA1148190" and tax_phylum = "Calditrichota"

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
7413937	7413937	PRJNA1148190_P_NODE_684266_length_246_cov_0.890173_g673093_i0	PRJNA1148190	684266	246	0.890173	2.18982558	Pseudomonadati	3379134	Bacteria	Bacteria	148	2.3e-39	NR	KAA3596706.1	2212469	g673093	i0	84.1	23	82	13	100	0	1	246	605	686	KAA3596706.1 MAG: glycine dehydrogenase (aminomethyl-transferring), partial [Calditrichota bacterium]	diamond	5658	148	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
15062669	15062669	PRJNA1148190_P_NODE_349212_length_301_cov_1.013158_g338039_i0	PRJNA1148190	349212	301	1.013158	3.04960558	Pseudomonadati	3379134	Bacteria	Bacteria	62.1	4.65e-5	NTclustered	gi\|1108618394\|gb\|CP018099.1\|	880073	g338039	i0	93.023	3.0797342192691	43	1	14	2	53	95	2515064	2515104	Caldithrix abyssi DSM 13497, complete genome	blastn	927	62.1	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae	Caldithrix	Caldithrix abyssi
26660054	26660054	PRJNA1148190_P_NODE_81241_length_606_cov_1.330206_g70116_i0	PRJNA1148190	81241	606	1.330206	8.06104836	Calditrichota bacterium	2212469	Bacteria	Bacteria	92.4	5.21e-19	NR	RMD95379.1	2212469	g70116	i0	30.7	0.871287128712871	176	120	86.6	2	80	604	16	190	RMD95379.1 MAG: glycosyltransferase [Calditrichota bacterium]	diamond	528	92.4	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
26850291	26850291	PRJNA1148190_P_NODE_67801_length_681_cov_2.179276_g56731_i0	PRJNA1148190	67801	681	2.179276	14.84086956	Calditrichota bacterium	2212469	Bacteria	Bacteria	89.4	1.96e-16	NR	RMF56720.1	2212469	g56731	i0	34	1.43171806167401	162	96	67.4	5	680	222	802	961	RMF56720.1 MAG: PAS domain S-box protein [Calditrichota bacterium]	diamond	975	89.4	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
26944087	26944087	PRJNA1148190_P_NODE_177362_length_397_cov_1.058642_g166193_i0	PRJNA1148190	177362	397	1.058642	4.20280874	Calditrichota bacterium	2212469	Bacteria	Bacteria	71.2	2.09e-11	NR	MCB0271083.1	2212469	g166193	i0	43.8	0.672544080604534	89	46	67.3	3	13	279	54	138	MCB0271083.1 hypothetical protein [Calditrichota bacterium]	diamond	267	71.2	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
27091148	27091148	PRJNA1148190_P_NODE_150602_length_428_cov_2.374648_g139435_i0	PRJNA1148190	150602	428	2.374648	10.16349344	Pseudomonadati	3379134	Bacteria	Bacteria	50.4	4.58e-4	NR	MCB0311804.1	2212469	g139435	i0	54.1	2.78271028037383	37	17	25.9	0	289	399	1	37	MCB0311804.1 hypothetical protein [Calditrichota bacterium]	diamond	1191	50.8	0.992125984251969	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
27133712	27133712	PRJNA1148190_P_NODE_241182_length_348_cov_1.672727_g230012_i0	PRJNA1148190	241182	348	1.672727	5.82108996	Calditrichota bacterium	2212469	Bacteria	Bacteria	75.5	7.19e-15	NR	MCB0271082.1	2212469	g230012	i0	60.7	0.525862068965517	61	24	52.6	0	344	162	51	111	MCB0271082.1 hypothetical protein [Calditrichota bacterium]	diamond	183	75.5	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
27133826	27133826	PRJNA1148190_P_NODE_309822_length_316_cov_0.950617_g298649_i0	PRJNA1148190	309822	316	0.950617	3.00394972	Calditrichota bacterium	2212469	Bacteria	Bacteria	44.7	0.0185	NR	KAA3601411.1	2212469	g298649	i0	37.7	0.655063291139241	69	40	62.7	1	198	1	677	745	KAA3601411.1 MAG: T9SS C-terminal target domain-containing protein [Calditrichota bacterium]	diamond	207	44.7	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
27355557	27355557	PRJNA1148190_P_NODE_276783_length_330_cov_1.416342_g265612_i0	PRJNA1148190	276783	330	1.416342	4.6739286	Calditrichota bacterium	2212469	Bacteria	Bacteria	46.2	0.006	NR	MCB0271083.1	2212469	g265612	i0	36.1	0.654545454545455	72	45	65.5	1	43	258	57	127	MCB0271083.1 hypothetical protein [Calditrichota bacterium]	diamond	216	46.2	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
27502259	27502259	PRJNA1148190_P_NODE_783683_length_241_cov_0.916667_g772510_i0	PRJNA1148190	783683	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	110	7.15e-26	NR	MBD3223941.1	1962856	g772510	i0	63.8	5.97510373443983	80	29	99.6	0	240	1	51	130	MBD3223941.1 prolyl oligopeptidase family serine peptidase [Caldithrix sp.]	diamond	1440	110	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae	Caldithrix	Caldithrix sp.
27513237	27513237	PRJNA1148190_P_NODE_217623_length_363_cov_1.568966_g206453_i0	PRJNA1148190	217623	363	1.568966	5.69534658	Calditrichota bacterium	2212469	Bacteria	Bacteria	111	7.21e-29	NR	MCB0271082.1	2212469	g206453	i0	73.5	0.56198347107438	68	18	56.2	0	206	3	1	68	MCB0271082.1 hypothetical protein [Calditrichota bacterium]	diamond	204	111	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
27513872	27513872	PRJNA1148190_P_NODE_574943_length_252_cov_1.631285_g563770_i0	PRJNA1148190	574943	252	1.631285	4.1108382	Calditrichota bacterium	2212469	Bacteria	Bacteria	43.5	0.0214	NR	MCB1048581.1	2212469	g563770	i0	35.1	0.678571428571429	57	37	67.9	0	2	172	164	220	MCB1048581.1 PEGA domain-containing protein [Calditrichota bacterium]	diamond	171	43.5	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
27639955	27639955	PRJNA1148190_P_NODE_385044_length_289_cov_1.425926_g373871_i0	PRJNA1148190	385044	289	1.425926	4.12092614	Calditrichota bacterium	2212469	Bacteria	Bacteria	43.9	0.0254	NR	RMH63238.1	2212469	g373871	i0	30.7	0.913494809688581	88	55	85.1	2	260	15	409	496	RMH63238.1 MAG: T9SS C-terminal target domain-containing protein [Calditrichota bacterium]	diamond	264	43.9	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
27640583	27640583	PRJNA1148190_P_NODE_747624_length_243_cov_0.905882_g736451_i0	PRJNA1148190	747624	243	0.905882	2.20129326	Calditrichota bacterium	2212469	Bacteria	Bacteria	142	4.94e-39	NR	MCB1060312.1	2212469	g736451	i0	77.5	4.92592592592593	80	18	98.8	0	241	2	8	87	MCB1060312.1 hypothetical protein [Calditrichota bacterium]	diamond	1197	142	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
27766678	27766678	PRJNA1148190_P_NODE_600384_length_250_cov_1.406780_g589211_i0	PRJNA1148190	600384	250	1.40678	3.51695	Calditrichia bacterium	2268178	Bacteria	Bacteria	87.4	5.18e-18	NR	MEE9117842.1	2268178	g589211	i0	46.8	0.948	79	42	94.8	0	248	12	102	180	MEE9117842.1 phage tail tube protein [Calditrichia bacterium]	diamond	237	87.4	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia				Calditrichia bacterium
28145173	28145173	PRJNA1148190_P_NODE_391125_length_288_cov_1.302326_g379952_i0	PRJNA1148190	391125	288	1.302326	3.75069888	Calditrichia bacterium	2268178	Bacteria	Bacteria	88.2	5.2e-19	NR	MCK4894486.1	2268178	g379952	i0	58.3	0.75	72	30	75	0	225	10	8	79	MCK4894486.1 M50 family metallopeptidase [Calditrichia bacterium]	diamond	216	88.2	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia				Calditrichia bacterium
28175900	28175900	PRJNA1148190_P_NODE_144806_length_437_cov_1.431319_g133641_i0	PRJNA1148190	144806	437	1.431319	6.25486403	Calditrichota bacterium	2212469	Bacteria	Bacteria	77.8	1.38e-14	NR	NQU06471.1	2212469	g133641	i0	39.3	0.926773455377574	135	62	89.9	5	416	24	41	159	NQU06471.1 hypothetical protein [Calditrichota bacterium]	diamond	405	77.8	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
28239449	28239449	PRJNA1148190_P_NODE_350946_length_300_cov_1.356828_g339773_i0	PRJNA1148190	350946	300	1.356828	4.070484	Calditrichota bacterium	2212469	Bacteria	Bacteria	75.1	2.94e-13	NR	MCB0271083.1	2212469	g339773	i0	41.1	0.95	95	56	95	0	295	11	390	484	MCB0271083.1 hypothetical protein [Calditrichota bacterium]	diamond	285	75.1	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
28366503	28366503	PRJNA1148190_P_NODE_786486_length_241_cov_0.916667_g775313_i0	PRJNA1148190	786486	241	0.916667	2.20916747	Calditrichota bacterium	2212469	Bacteria	Bacteria	72	1.15e-12	NR	MCB0282523.1	2212469	g775313	i0	53.4	0.721991701244813	58	21	72.2	1	63	236	3	54	MCB0282523.1 glycoside hydrolase family 43 protein [Calditrichota bacterium]	diamond	174	72	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
28681414	28681414	PRJNA1148190_P_NODE_113047_length_498_cov_2.258824_g101885_i0	PRJNA1148190	113047	498	2.258824	11.24894352	Calditrichota bacterium	2212469	Bacteria	Bacteria	60.1	3.78e-7	NR	MCB0303987.1	2212469	g101885	i0	36.5	2.31325301204819	104	59	60.8	3	192	494	35	134	MCB0303987.1 recombinase RecT [Calditrichota bacterium]	diamond	1152	60.1	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
28934798	28934798	PRJNA1148190_P_NODE_615188_length_250_cov_0.870056_g604015_i0	PRJNA1148190	615188	250	0.870056	2.17514	Calditrichota bacterium	2212469	Bacteria	Bacteria	67.4	5.02e-11	NR	RMF65914.1	2212469	g604015	i0	55	2.04	60	26	70.8	1	2	178	225	284	RMF65914.1 MAG: SCO family protein [Calditrichota bacterium]	diamond	510	67.4	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
28998569	28998569	PRJNA1148190_P_NODE_93868_length_554_cov_2.713098_g82723_i0	PRJNA1148190	93868	554	2.713098	15.03056292	Calditrichota bacterium	2212469	Bacteria	Bacteria	54.7	3.41e-6	NR	MCB0275268.1	2212469	g82723	i0	38.9	0.487364620938628	90	51	48.7	1	296	27	11	96	MCB0275268.1 helix-turn-helix transcriptional regulator [Calditrichota bacterium]	diamond	270	54.7	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
30292610	30292610	PRJNA1148190_P_NODE_349992_length_300_cov_2.008811_g338819_i0	PRJNA1148190	349992	300	2.008811	6.026433	Calditrichota bacterium	2212469	Bacteria	Bacteria	87	8.79e-20	NR	MCB1060719.1	2212469	g338819	i0	74.1	0.54	54	14	54	0	137	298	3	56	MCB1060719.1 nucleotidyltransferase domain-containing protein [Calditrichota bacterium]	diamond	162	87	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
30419413	30419413	PRJNA1148190_P_NODE_629473_length_249_cov_0.875000_g618300_i0	PRJNA1148190	629473	249	0.875	2.17875	Calditrichota bacterium	2212469	Bacteria	Bacteria	76.6	4.83e-14	NR	RMH78263.1	2212469	g618300	i0	46.8	0.927710843373494	77	41	92.8	0	243	13	906	982	RMH78263.1 MAG: hypothetical protein D6681_20215 [Calditrichota bacterium]	diamond	231	76.6	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
30671058	30671058	PRJNA1148190_P_NODE_234053_length_352_cov_2.114695_g222883_i0	PRJNA1148190	234053	352	2.114695	7.4437264	Calditrichota bacterium	2212469	Bacteria	Bacteria	75.9	3.08e-13	NR	RMH78276.1	2212469	g222883	i0	37.9	1.96875	116	69	97.2	2	9	350	517	631	RMH78276.1 MAG: hypothetical protein D6681_20280 [Calditrichota bacterium]	diamond	693	75.9	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
30702804	30702804	PRJNA1148190_P_NODE_287114_length_325_cov_1.718254_g275943_i0	PRJNA1148190	287114	325	1.718254	5.5843255	Calditrichota bacterium	2212469	Bacteria	Bacteria	101	1.9e-22	NR	MCB0271083.1	2212469	g275943	i0	52.2	0.849230769230769	92	42	83.1	1	3	272	46	137	MCB0271083.1 hypothetical protein [Calditrichota bacterium]	diamond	276	101	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
30703362	30703362	PRJNA1148190_P_NODE_602954_length_250_cov_0.870056_g591781_i0	PRJNA1148190	602954	250	0.870056	2.17514	Calditrichia bacterium	2268178	Bacteria	Bacteria	80.9	1.56e-15	NR	MEE9117838.1	2268178	g591781	i0	50	0.936	78	39	93.6	0	240	7	667	744	MEE9117838.1 hypothetical protein [Calditrichia bacterium]	diamond	234	80.9	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia				Calditrichia bacterium
31144507	31144507	PRJNA1148190_P_NODE_162235_length_413_cov_1.900000_g151068_i0	PRJNA1148190	162235	413	1.9	7.847	Calditrichota bacterium	2212469	Bacteria	Bacteria	123	1.97e-30	NR	MCB0277442.1	2212469	g151068	i0	47.7	1.80871670702179	128	67	93	0	412	29	67	194	MCB0277442.1 MFS transporter [Calditrichota bacterium]	diamond	747	123	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
31557328	31557328	PRJNA1148190_P_NODE_744276_length_243_cov_0.905882_g733103_i0	PRJNA1148190	744276	243	0.905882	2.20129326	Calditrichaceae bacterium	2614252	Bacteria	Bacteria	65.9	2.39e-10	NR	MEJ2055797.1	2614252	g733103	i0	52.5	0.987654320987654	80	38	98.8	0	240	1	16	95	MEJ2055797.1 aldehyde dehydrogenase (NADP(+)) [Calditrichaceae bacterium]	diamond	240	65.9	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae		Calditrichaceae bacterium
32125667	32125667	PRJNA1148190_P_NODE_130318_length_461_cov_2.247423_g119155_i0	PRJNA1148190	130318	461	2.247423	10.36062003	Caldithrix abyssi	187145	Bacteria	Bacteria	64.7	7.47e-9	NR	WP_169833731.1	187145	g119155	i0	40.5	0.481561822125813	74	43	48.2	1	460	239	204	276	WP_169833731.1 hypothetical protein [Caldithrix abyssi]	diamond	222	64.7	1	Bacteria	Pseudomonadati	Calditrichota	Calditrichia	Calditrichales	Calditrichaceae	Caldithrix	Caldithrix abyssi
32126183	32126183	PRJNA1148190_P_NODE_429798_length_280_cov_1.690821_g418625_i0	PRJNA1148190	429798	280	1.690821	4.7342988	Calditrichota bacterium	2212469	Bacteria	Bacteria	108	1.77e-25	NR	MCB0271083.1	2212469	g418625	i0	67.5	0.825	77	25	82.5	0	244	14	1	77	MCB0271083.1 hypothetical protein [Calditrichota bacterium]	diamond	231	108	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
32474617	32474617	PRJNA1148190_P_NODE_671339_length_247_cov_0.885057_g660166_i0	PRJNA1148190	671339	247	0.885057	2.18609079	Calditrichota bacterium	2212469	Bacteria	Bacteria	91.3	4.88e-21	NR	MCB0292866.1	2212469	g660166	i0	65.3	3.57085020242915	75	25	89.9	1	26	247	1	75	MCB0292866.1 pyridoxal-phosphate dependent enzyme [Calditrichota bacterium]	diamond	882	91.3	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota bacterium
32494231	32494231	PRJNA1148190_P_NODE_462379_length_274_cov_1.258706_g451206_i0	PRJNA1148190	462379	274	1.258706	3.44885444	Bacteria	2	Bacteria	Bacteria	108	3.82e-25	NR	RMH78715.1	2212469	g451206	i0	59.6	3.90875912408759	89	33	97.4	1	272	6	463	548	RMH78715.1 MAG: DUF87 domain-containing protein [Calditrichota bacterium]	diamond	1071	108	1	Bacteria	Pseudomonadati	Calditrichota					Calditrichota 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);;