metadata: contig_metadata: 21 rows where bioproject = "PRJNA944406" and tax_clade = "Nitrospinota/Tectimicrobiota group"

21 rows where bioproject = "PRJNA944406" 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
7302221	7302221	PRJNA944406_P_NODE_11006_length_376_cov_1.755776_g10047_i0	PRJNA944406	11006	376	1.755776	6.60171776	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	324	6.87e-84	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g10047	i0	82.632	133.425531914894	380	52	100	13	1	376	2629827	2630196	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	50168	324	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
7303096	7303096	PRJNA944406_P_NODE_8986_length_415_cov_2.040936_g8027_i0	PRJNA944406	8986	415	2.040936	8.4698844	Candidatus Nitronauta litoralis	2705533	Bacteria	Bacteria	139	2.98e-28	NTclustered	gi\|1938439011\|gb\|CP048685.1\|	2705533	g8027	i0	76.596	94.7012048192771	282	48	66	17	136	407	3876379	3876652	MAG: Candidatus Nitronauta litoralis isolate EB chromosome, complete genome	blastn	39301	139	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitronauta	Candidatus Nitronauta litoralis
8577136	8577136	PRJNA944406_P_NODE_11387_length_371_cov_0.946309_g10428_i0	PRJNA944406	11387	371	0.946309	3.51080639	Candidatus Nitrohelix vancouverensis	2705534	Bacteria	Bacteria	134	1.22e-26	NTclustered	gi\|1938442527\|gb\|CP048620.1\|	2705534	g10428	i0	77.043	87.4420485175202	257	44	69	9	22	277	2190004	2189762	MAG: Candidatus Nitrohelix vancouverensis isolate VA-1 chromosome	blastn	32441	134	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitrohelix	Candidatus Nitrohelix vancouverensis
8577801	8577801	PRJNA944406_P_NODE_7487_length_459_cov_1.569948_g6531_i0	PRJNA944406	7487	459	1.569948	7.20606132	uncultured marine Nitrospinaceae bacterium	482920	Bacteria	Bacteria	211	6.94e-50	NTclustered	gi\|118340518\|gb\|EF106972.1\|	482920	g6531	i0	76.334	45.6296296296296	431	81	92	16	40	459	39201	38781	Uncultured marine Nitrospinaceae bacterium clone EB080L20_F04, partial sequence	blastn	20944	211	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae		uncultured marine Nitrospinaceae bacterium
21326967	21326967	PRJNA944406_P_NODE_68097_length_250_cov_0.870056_g67138_i0	PRJNA944406	68097	250	0.870056	2.17514	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	162	3.1e-44	NR	HEY5866119.1	2528274	g67138	i0	100	0.984	82	0	98.4	0	248	3	201	282	HEY5866119.1 preprotein translocase subunit SecA [Candidatus Tectimicrobiota bacterium]	diamond	246	162	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
21327186	21327186	PRJNA944406_P_NODE_90277_length_245_cov_0.895349_g89318_i0	PRJNA944406	90277	245	0.895349	2.19360505	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	142	1.65e-37	NR	HEX9872141.1	2528274	g89318	i0	93.8	0.991836734693878	81	5	99.2	0	243	1	414	494	HEX9872141.1 efflux RND transporter permease subunit [Candidatus Tectimicrobiota bacterium]	diamond	243	142	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
23876770	23876770	PRJNA944406_P_NODE_13499_length_346_cov_1.948718_g12540_i0	PRJNA944406	13499	346	1.948718	6.74256428	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	462	1.2799999999999998e-125	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g12540	i0	90.778	454.352601156069	347	30	100	2	1	346	2629136	2628791	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	157206	462	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
23877100	23877100	PRJNA944406_P_NODE_40139_length_272_cov_1.547739_g39180_i0	PRJNA944406	40139	272	1.547739	4.20985008	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	318	2.23e-82	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g39180	i0	88.148	7.31617647058824	270	28	99	3	2	269	2628930	2629197	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	1990	318	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
25486135	25486135	PRJNA944406_P_NODE_72320_length_249_cov_0.875000_g71361_i0	PRJNA944406	72320	249	0.875	2.17875	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	162	2.26e-44	NR	HEX2277722.1	2528274	g71361	i0	95.1	1.97590361445783	82	4	98.8	0	3	248	502	583	HEX2277722.1 pyruvate, phosphate dikinase [Candidatus Tectimicrobiota bacterium]	diamond	492	162	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
27404712	27404712	PRJNA944406_P_NODE_103063_length_242_cov_0.911243_g102104_i0	PRJNA944406	103063	242	0.911243	2.20520806	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	144	9.6e-40	NR	HEY5864329.1	2528274	g102104	i0	88.8	0.991735537190083	80	9	99.2	0	242	3	246	325	HEY5864329.1 FAD-dependent oxidoreductase [Candidatus Tectimicrobiota bacterium]	diamond	240	144	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
27657408	27657408	PRJNA944406_P_NODE_85204_length_246_cov_0.890173_g84245_i0	PRJNA944406	85204	246	0.890173	2.18982558	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	103	1.0099999999999999e-24	NR	HSF31496.1	2528274	g84245	i0	65.8	1.95121951219512	79	27	96.3	0	2	238	202	280	HSF31496.1 SDR family oxidoreductase [Candidatus Tectimicrobiota bacterium]	diamond	480	103	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
28067606	28067606	PRJNA944406_P_NODE_37605_length_275_cov_1.202970_g36646_i0	PRJNA944406	37605	275	1.20297	3.3081675	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	55.8	5.57e-8	NR	GIX48747.1	2528274	g36646	i0	73	0.807272727272727	37	10	40.4	0	162	272	1	37	GIX48747.1 MAG: 50S ribosomal protein L31 [Candidatus Tectimicrobiota bacterium]	diamond	222	55.8	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
28169148	28169148	PRJNA944406_P_NODE_77985_length_248_cov_0.880000_g77026_i0	PRJNA944406	77985	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	46.2	5.57e-4	NR	WP_034427083.1	93172	g77026	i0	100	5.56451612903226	20	0	24.2	0	188	247	1	20	WP_034427083.1 Lin0512 family protein [Candidatus Entotheonella palauensis]	diamond	1380	46.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella palauensis
28415123	28415123	PRJNA944406_P_NODE_85226_length_246_cov_0.890173_g84267_i0	PRJNA944406	85226	246	0.890173	2.18982558	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	155	8.4e-45	NR	HEX9867526.1	2528274	g84267	i0	95.1	1	82	4	100	0	246	1	81	162	HEX9867526.1 xanthine dehydrogenase family protein subunit M [Candidatus Tectimicrobiota bacterium]	diamond	246	155	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
29362244	29362244	PRJNA944406_P_NODE_111009_length_237_cov_2.676829_g110050_i0	PRJNA944406	111009	237	2.676829	6.34408473	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	130	3.96e-33	NR	HEY5870258.1	2528274	g110050	i0	98.5	0.860759493670886	68	1	86.1	0	34	237	564	631	HEY5870258.1 translation initiation factor IF-2 [Candidatus Tectimicrobiota bacterium]	diamond	204	130	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
29488307	29488307	PRJNA944406_P_NODE_81150_length_247_cov_0.885057_g80191_i0	PRJNA944406	81150	247	0.885057	2.18609079	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	45.1	0.00597	NR	HEX2277388.1	2528274	g80191	i0	100	0.48582995951417	20	0	24.3	0	2	61	509	528	HEX2277388.1 ABC transporter substrate-binding protein [Candidatus Tectimicrobiota bacterium]	diamond	120	45.1	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
29709096	29709096	PRJNA944406_P_NODE_58190_length_255_cov_2.181319_g57231_i0	PRJNA944406	58190	255	2.181319	5.56236345	Candidatus Entotheonella serta	1652106	Bacteria	Bacteria	73.6	4.67e-13	NR	PON18731.1	1652106	g57231	i0	48.7	0.917647058823529	78	38	91.8	1	21	254	13	88	PON18731.1 hypothetical protein C2W62_06365 [Candidatus Entotheonella serta]	diamond	234	73.6	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella serta
29899103	29899103	PRJNA944406_P_NODE_69291_length_250_cov_0.870056_g68332_i0	PRJNA944406	69291	250	0.870056	2.17514	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	132	1.1699999999999999e-34	NR	HSF28910.1	2528274	g68332	i0	81.9	0.996	83	15	99.6	0	250	2	9	91	HSF28910.1 sigma-54 dependent transcriptional regulator [Candidatus Tectimicrobiota bacterium]	diamond	249	132	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
30537623	30537623	PRJNA944406_P_NODE_65573_length_251_cov_0.865169_g64614_i0	PRJNA944406	65573	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	164	1.07e-44	NR	HEY5870299.1	2528274	g64614	i0	96.3	1.97211155378486	82	3	98	0	5	250	88	169	HEY5870299.1 DNA polymerase III subunit alpha [Candidatus Tectimicrobiota bacterium]	diamond	495	164	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
31130926	31130926	PRJNA944406_P_NODE_89195_length_245_cov_1.546512_g88236_i0	PRJNA944406	89195	245	1.546512	3.7889544	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	70.1	8.68e-12	NR	HSF30980.1	2528274	g88236	i0	85	0.489795918367347	40	6	49	0	125	244	1	40	HSF30980.1 sigma-54-dependent Fis family transcriptional regulator [Candidatus Tectimicrobiota bacterium]	diamond	120	70.1	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
32743766	32743766	PRJNA944406_P_NODE_40640_length_272_cov_1.331658_g39681_i0	PRJNA944406	40640	272	1.331658	3.62210976	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	52.8	1.24e-5	NR	HEY5867385.1	2528274	g39681	i0	76.3	0.419117647058824	38	9	41.9	0	35	148	37	74	HEY5867385.1 aminoacyl-tRNA hydrolase [Candidatus Tectimicrobiota bacterium]	diamond	114	52.8	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);;