metadata: contig_metadata: 23 rows where bioproject = "PRJNA1237347" and tax_clade = "Nitrospinota/Tectimicrobiota group"

23 rows where bioproject = "PRJNA1237347" and tax_clade = "Nitrospinota/Tectimicrobiota group"

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
13091354	13091354	PRJNA1237347_P_NODE_161571_length_499_cov_1.561033_g155010_i0	PRJNA1237347	161571	499	1.561033	7.78955467	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	63.2	4e-8	NR	MEE9149461.1	2528274	g155010	i0	39.3	0.673346693386774	112	58	63.1	3	40	354	338	446	MEE9149461.1 ATP-binding protein [Candidatus Tectimicrobiota bacterium]	diamond	336	63.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
14367426	14367426	PRJNA1237347_P_NODE_195312_length_440_cov_2.365123_g188740_i0	PRJNA1237347	195312	440	2.365123	10.4065412	Candidatus Nitronauta litoralis	2705533	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1938439011\|gb\|CP048685.1\|	2705533	g188740	i0	96.97	0.465909090909091	33	1	8	0	335	367	34942	34974	MAG: Candidatus Nitronauta litoralis isolate EB chromosome, complete genome	blastn	205	56.5	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitronauta	Candidatus Nitronauta litoralis
16915438	16915438	PRJNA1237347_P_NODE_191674_length_446_cov_1.383378_g185102_i0	PRJNA1237347	191674	446	1.383378	6.16986588	Bacteria	2	Bacteria	Bacteria	115	7.29e-28	NR	WP_179137224.1	93172	g185102	i0	60.4	4.32511210762332	91	35	61.2	1	444	172	215	304	WP_179137224.1 NAD(+) diphosphatase [Candidatus Entotheonella palauensis]	diamond	1929	115	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella palauensis
24565316	24565316	PRJNA1237347_P_NODE_228620_length_397_cov_1.425926_g222048_i0	PRJNA1237347	228620	397	1.425926	5.66092622	Bacteria	2	Bacteria	Bacteria	149	1.0299999999999999e-38	NR	MDA1109176.1	2026769	g222048	i0	61.3	8.62972292191436	119	46	89.9	0	37	393	669	787	MDA1109176.1 PAS domain S-box protein [Nitrospinota bacterium]	diamond	3426	149	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
26597949	26597949	PRJNA1237347_P_NODE_337241_length_310_cov_2.270042_g330668_i0	PRJNA1237347	337241	310	2.270042	7.0371302	Nitrospinota bacterium	2026769	Bacteria	Bacteria	64.3	2.19e-9	NR	MBI4384665.1	2026769	g330668	i0	60	3.35806451612903	50	20	48.4	0	1	150	617	666	MBI4384665.1 adenylate/guanylate cyclase domain-containing protein [Nitrospinota bacterium]	diamond	1041	64.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
26661402	26661402	PRJNA1237347_P_NODE_430761_length_267_cov_1.293814_g424188_i0	PRJNA1237347	430761	267	1.293814	3.45448338	Nitrospinota bacterium	2026769	Bacteria	Bacteria	57.4	3.4e-7	NR	MDH5763792.1	2026769	g424188	i0	45.6	0.640449438202247	57	31	64	0	175	5	399	455	MDH5763792.1 HEAT repeat domain-containing protein [Nitrospinota bacterium]	diamond	171	57.4	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
26756174	26756174	PRJNA1237347_P_NODE_19261_length_1803_cov_2.019075_g16804_i0	PRJNA1237347	19261	1803	2.019075	36.40392225	Nitrospinota bacterium	2026769	Bacteria	Bacteria	127	1.29e-26	NR	MBI5186125.1	2026769	g16804	i0	27.3	0.810316139767055	487	306	76.7	17	1710	328	441	905	MBI5186125.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Nitrospinota bacterium]	diamond	1461	127	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
27041709	27041709	PRJNA1237347_P_NODE_498562_length_248_cov_0.880000_g491989_i0	PRJNA1237347	498562	248	0.88	2.1824	Candidatus Entotheonella serta	1652106	Bacteria	Bacteria	47	0.0013	NR	PON15145.1	1652106	g491989	i0	54.2	0.580645161290323	48	20	58.1	1	99	242	699	744	PON15145.1 hypothetical protein C2W62_25375 [Candidatus Entotheonella serta]	diamond	144	47	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella serta
27831097	27831097	PRJNA1237347_P_NODE_303344_length_332_cov_0.698842_g296771_i0	PRJNA1237347	303344	332	0.698842	2.32015544	Nitrospina sp.	2024844	Bacteria	Bacteria	43.9	0.0369	NR	MBT5471931.1	2024844	g296771	i0	32	0.677710843373494	75	49	66	1	242	24	18	92	MBT5471931.1 AmmeMemoRadiSam system radical SAM enzyme [Nitrospina sp.]	diamond	225	43.9	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina sp.
27894326	27894326	PRJNA1237347_P_NODE_38825_length_1229_cov_1.993080_g34648_i0	PRJNA1237347	38825	1229	1.99308	24.4949532	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	77	5.89e-12	NR	HEY7494564.1	2528274	g34648	i0	45.1	0.22213181448332	91	49	22	1	3	272	137	227	HEY7494564.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	273	77	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
28589112	28589112	PRJNA1237347_P_NODE_307347_length_329_cov_1.218750_g300774_i0	PRJNA1237347	307347	329	1.21875	4.0096875	Nitrospinota bacterium	2026769	Bacteria	Bacteria	49.3	2.85e-4	NR	MFQ5915144.1	2026769	g300774	i0	61	0.373860182370821	41	16	37.4	0	125	3	73	113	MFQ5915144.1 ribonuclease HI family protein [Nitrospinota bacterium]	diamond	123	49.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29585882	29585882	PRJNA1237347_P_NODE_104650_length_662_cov_1.276740_g98219_i0	PRJNA1237347	104650	662	1.27674	8.4520188	Bacteria	2	Bacteria	Bacteria	62	8.95e-8	NR	MFP6870892.1	2026769	g98219	i0	32.1	1.96676737160121	168	104	74.3	5	45	536	7	168	MFP6870892.1 LamG domain-containing protein [Nitrospinota bacterium]	diamond	1302	62.4	0.993589743589744	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29693764	29693764	PRJNA1237347_P_NODE_378030_length_289_cov_1.370370_g371457_i0	PRJNA1237347	378030	289	1.37037	3.9603693	Nitrospinota bacterium	2026769	Bacteria	Bacteria	124	3.96e-32	NR	MDA0692544.1	2026769	g371457	i0	63.5	1.99307958477509	96	34	99.7	1	289	2	109	203	MDA0692544.1 nucleotidyl transferase AbiEii/AbiGii toxin family protein [Nitrospinota bacterium]	diamond	576	124	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29725116	29725116	PRJNA1237347_P_NODE_168950_length_485_cov_1.507282_g162381_i0	PRJNA1237347	168950	485	1.507282	7.3103177	Candidatus Entotheonella gemina	1429439	Bacteria	Bacteria	45.4	0.0476	NR	ETX03510.1	1429439	g162381	i0	28.6	0.736082474226804	119	67	73.6	4	31	387	275	375	ETX03510.1 MAG: hypothetical protein ETSY2_33260 [Candidatus Entotheonella gemina]	diamond	357	45.4	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella gemina
29788717	29788717	PRJNA1237347_P_NODE_412151_length_274_cov_2.328358_g405578_i0	PRJNA1237347	412151	274	2.328358	6.37970092	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	42.7	0.0156	NR	MBI4595818.1	2528274	g405578	i0	52.8	0.394160583941606	36	17	39.4	0	213	106	1	36	MBI4595818.1 helix-turn-helix domain-containing protein [Candidatus Tectimicrobiota bacterium]	diamond	108	42.7	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
29852288	29852288	PRJNA1237347_P_NODE_532371_length_244_cov_0.900585_g525798_i0	PRJNA1237347	532371	244	0.900585	2.1974274	Candidatus Entotheonella factor	1429438	Bacteria	Bacteria	86.7	1.31e-17	NR	ETW95517.1	1429438	g525798	i0	53.8	2.69262295081967	78	35	94.7	1	231	1	47	124	ETW95517.1 MAG: hypothetical protein ETSY1_30310 [Candidatus Entotheonella factor]	diamond	657	87.4	0.991990846681922	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella factor
30691840	30691840	PRJNA1237347_P_NODE_434973_length_265_cov_1.604167_g428400_i0	PRJNA1237347	434973	265	1.604167	4.25104255	Pseudomonadati	3379134	Bacteria	Bacteria	134	4.21e-34	NR	MBF0293179.1	2026769	g428400	i0	69	7.59622641509434	84	26	95.1	0	14	265	573	656	MBF0293179.1 RHS repeat-associated core domain-containing protein [Nitrospinota bacterium]	diamond	2013	134	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
30818304	30818304	PRJNA1237347_P_NODE_436654_length_264_cov_2.816754_g430081_i0	PRJNA1237347	436654	264	2.816754	7.43623056	Bacteria	2	Bacteria	Bacteria	127	5.03e-33	NR	OGV99163.1	1801680	g430081	i0	67.8	27.5795454545455	87	28	98.9	0	3	263	104	190	OGV99163.1 MAG: 6-phosphofructokinase [Nitrospinae bacterium RIFCSPHIGHO2_02_39_11]	diamond	7281	128	0.9921875	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinae bacterium RIFCSPHIGHO2_02_39_11
30862692	30862692	PRJNA1237347_P_NODE_163174_length_496_cov_1.267139_g156612_i0	PRJNA1237347	163174	496	1.267139	6.28500944	Nitrospinales bacterium	2833568	Bacteria	Bacteria	65.5	3.79e-9	NR	MFQ5673231.1	2833568	g156612	i0	53.1	1.08870967741935	64	23	35.1	2	143	316	79	141	MFQ5673231.1 formimidoylglutamase [Nitrospinales bacterium]	diamond	540	65.5	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales			Nitrospinales bacterium
31209723	31209723	PRJNA1237347_P_NODE_117415_length_615_cov_1.040590_g110918_i0	PRJNA1237347	117415	615	1.04059	6.3996285	Nitrospina sp.	2024844	Bacteria	Bacteria	79.7	2.6e-15	NR	HIB43776.1	2024844	g110918	i0	61	0.604878048780488	59	23	28.8	0	12	188	59	117	HIB43776.1 hypothetical protein [Nitrospina sp.]	diamond	372	79.7	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina sp.
31779608	31779608	PRJNA1237347_P_NODE_25277_length_1562_cov_9.067831_g22156_i0	PRJNA1237347	25277	1562	9.067831	141.63952022	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	663	1.3299999999999994e-234	NR	HEY5868420.1	2528274	g22156	i0	66.4	0.948783610755442	494	163	94.9	1	50	1531	1	491	HEY5868420.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	1482	663	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
32476244	32476244	PRJNA1237347_P_NODE_426619_length_268_cov_4.948718_g420046_i0	PRJNA1237347	426619	268	4.948718	13.26256424	Nitrospinota bacterium	2026769	Bacteria	Bacteria	43.9	0.0193	NR	MDP7580296.1	2026769	g420046	i0	31.5	1.02985074626866	92	55	96.3	3	259	2	26	115	MDP7580296.1 sigma 54-interacting transcriptional regulator [Nitrospinota bacterium]	diamond	276	43.9	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
32664921	32664921	PRJNA1237347_P_NODE_199960_length_433_cov_6.350000_g193388_i0	PRJNA1237347	199960	433	6.35	27.4955	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	60.5	2.3e-8	NR	HEY5868419.1	2528274	g193388	i0	30.8	0.630484988452656	91	63	63	0	382	110	54	144	HEY5868419.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	273	60.5	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota 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);;