metadata: contig_metadata: 15 rows where bioproject = "PRJNA641707" and tax_clade = "Nitrospinota/Tectimicrobiota group"

15 rows where bioproject = "PRJNA641707" 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
612404	612404	PRJNA641707_P_NODE_1721_length_1423_cov_258.198690_g1125_i1	PRJNA641707	1721	1423	258.19869	3674.1673587	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	1306	0	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g1125	i1	86.495	251.034434293746	1207	142	84	19	1	1201	2629301	2630492	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	357222	1306	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
6991662	6991662	PRJNA641707_P_NODE_206386_length_196_cov_6.816327_g203723_i0	PRJNA641707	206386	196	6.816327	13.36000092	Nitrospina watsonii	1323948	Bacteria	Bacteria	172	1.25e-38	NTclustered	gi\|2427816174\|emb\|OX336137.1\|	1323948	g203723	i0	83.684	201.377551020408	190	23	93	4	6	187	1935783	1935972	Nitrospina watsonii strain 347 genome assembly, chromosome: NSPWAT	blastn	39470	172	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina watsonii
12094457	12094457	PRJNA641707_P_NODE_286190_length_168_cov_4.218487_g283527_i0	PRJNA641707	286190	168	4.218487	7.08705816	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	99	1.53e-23	NR	HEX9870537.1	2528274	g283527	i0	92.9	1	56	4	100	0	168	1	14	69	HEX9870537.1 chaperonin GroEL [Candidatus Tectimicrobiota bacterium]	diamond	168	99	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
15919901	15919901	PRJNA641707_P_NODE_69833_length_251_cov_3.693069_g67170_i0	PRJNA641707	69833	251	3.693069	9.26960319	Candidatus Nitrohelix vancouverensis	2705534	Bacteria	Bacteria	108	4.79e-19	NTclustered	gi\|1938442527\|gb\|CP048620.1\|	2705534	g67170	i0	86.139	32.2589641434263	101	13	40	1	1	101	2187256	2187355	MAG: Candidatus Nitrohelix vancouverensis isolate VA-1 chromosome	blastn	8097	108	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitrohelix	Candidatus Nitrohelix vancouverensis
22289420	22289420	PRJNA641707_P_NODE_1698_length_1429_cov_253.031884_g1125_i0	PRJNA641707	1698	1429	253.031884	3615.82562236	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	1474	0	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g1125	i0	88.67	269.445066480056	1218	126	85	11	215	1429	2630509	2629301	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	385037	1474	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
22293868	22293868	PRJNA641707_P_NODE_57258_length_282_cov_8.175966_g54597_i0	PRJNA641707	57258	282	8.175966	23.05622412	Candidatus Nitronauta litoralis	2705533	Bacteria	Bacteria	93.5	1.53e-14	NTclustered	gi\|1938439011\|gb\|CP048685.1\|	2705533	g54597	i0	77.206	2.98581560283688	136	26	46	1	34	164	3877717	3877582	MAG: Candidatus Nitronauta litoralis isolate EB chromosome, complete genome	blastn	842	93.5	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitronauta	Candidatus Nitronauta litoralis
23564659	23564659	PRJNA641707_P_NODE_15619_length_547_cov_17.152610_g13265_i0	PRJNA641707	15619	547	17.15261	93.8247767	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	763	0	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g13265	i0	92.365	212.550274223035	537	40	98	1	11	547	2628547	2629082	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	116265	763	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
27934095	27934095	PRJNA641707_P_NODE_95465_length_246_cov_4.862944_g92802_i0	PRJNA641707	95465	246	4.862944	11.96284224	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	76.3	8.95e-15	NR	HEY5870384.1	2528274	g92802	i0	97.1	0.414634146341463	34	1	41.5	0	1	102	135	168	HEY5870384.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	102	76.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
28723347	28723347	PRJNA641707_P_NODE_210667_length_195_cov_8.102740_g208004_i0	PRJNA641707	210667	195	8.10274	15.800343	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	71.6	1.23e-12	NR	MBM3223783.1	2528274	g208004	i0	55.6	1.32307692307692	54	17	83.1	1	195	34	353	399	MBM3223783.1 VWA domain-containing protein [Candidatus Tectimicrobiota bacterium]	diamond	258	71.6	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
29039346	29039346	PRJNA641707_P_NODE_312768_length_160_cov_10.090090_g310105_i0	PRJNA641707	312768	160	10.09009	16.144144	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	87.8	1.54e-18	NR	HEY5868907.1	2528274	g310105	i0	82.7	0.975	52	9	97.5	0	156	1	289	340	HEY5868907.1 molybdopterin-dependent oxidoreductase [Candidatus Tectimicrobiota bacterium]	diamond	156	87.8	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
29670155	29670155	PRJNA641707_P_NODE_253190_length_181_cov_2.939394_g250527_i0	PRJNA641707	253190	181	2.939394	5.32030314	Nitrospinae bacterium CG11_big_fil_rev_8_21_14_	1974048	Bacteria	Bacteria	57	4.44e-8	NR	PIR00428.1	1974048	g250527	i0	50	0.895027624309392	54	27	89.5	0	13	174	8	61	PIR00428.1 MAG: hypothetical protein COV66_06785 [Nitrospinae bacterium CG11_big_fil_rev_8_21_14_0_20_45_15]	diamond	162	57	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinae bacterium CG11_big_fil_rev_8_21_14_0_20_45_15
31218246	31218246	PRJNA641707_P_NODE_317895_length_158_cov_13.192661_g315232_i0	PRJNA641707	317895	158	13.192661	20.84440438	Nitrospinota bacterium	2026769	Bacteria	Bacteria	84.7	5.47e-18	NR	MBI3326113.1	2026769	g315232	i0	78.4	0.968354430379747	51	11	96.8	0	153	1	30	80	MBI3326113.1 NAD(+) diphosphatase [Nitrospinota bacterium]	diamond	153	84.7	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
31724505	31724505	PRJNA641707_P_NODE_167697_length_201_cov_29.532895_g165034_i0	PRJNA641707	167697	201	29.532895	59.36111895	Nitrospinota bacterium	2026769	Bacteria	Bacteria	41.2	0.0198	NR	MFC1492043.1	2026769	g165034	i0	42.9	0.73134328358209	49	28	73.1	0	183	37	38	86	MFC1492043.1 hypothetical protein [Nitrospinota bacterium]	diamond	147	41.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
32673089	32673089	PRJNA641707_P_NODE_138060_length_242_cov_6.968912_g135397_i0	PRJNA641707	138060	242	6.968912	16.86476704	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	68.2	4.02e-11	NR	HEY5865788.1	2528274	g135397	i0	93.8	0.396694214876033	32	2	39.7	0	4	99	503	534	HEY5865788.1 tetratricopeptide repeat protein [Candidatus Tectimicrobiota bacterium]	diamond	96	68.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
32862156	32862156	PRJNA641707_P_NODE_192920_length_198_cov_9.328859_g190257_i0	PRJNA641707	192920	198	9.328859	18.47114082	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	44.7	0.00411	NR	HEY5868565.1	2528274	g190257	i0	78.8	0.5	33	7	50	0	196	98	173	205	HEY5868565.1 SPOR domain-containing protein [Candidatus Tectimicrobiota bacterium]	diamond	99	44.7	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);;