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

21 rows where bioproject = "PRJNA734348" 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
3268190	3268190	PRJNA734348_P_NODE_109083_length_247_cov_0.885057_g108385_i0	PRJNA734348	109083	247	0.885057	2.18609079	uncultured Candidatus Entotheonella sp.	312019	Bacteria	Bacteria	274	4.38e-69	NTclustered	gi\|2518596677\|emb\|OX639990.1\|	312019	g108385	i0	86.747	123.101214574899	249	30	99	3	2	247	2628647	2628895	MAG: uncultured Candidatus Entotheonella sp. isolate 26b0520c-cf9d-432e-a440-87a3e388b1d5 genome assembly, chromosome: 1	blastn	30406	274	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	uncultured Candidatus Entotheonella sp.
18570825	18570825	PRJNA734348_P_NODE_84915_length_256_cov_2.256831_g84217_i0	PRJNA734348	84915	256	2.256831	5.77748736	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	139	9.93e-37	NR	HSF33428.1	2528274	g84217	i0	77.4	2.953125	84	19	98.4	0	256	5	255	338	HSF33428.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Tectimicrobiota bacterium]	diamond	756	139	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
21121546	21121546	PRJNA734348_P_NODE_82877_length_258_cov_1.659459_g82179_i0	PRJNA734348	82877	258	1.659459	4.28140422	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	176	1.6e-50	NR	HEX9867696.1	2528274	g82179	i0	97.6	0.988372093023256	85	2	98.8	0	256	2	386	470	HEX9867696.1 phosphoribosylformylglycinamidine synthase subunit PurS [Candidatus Tectimicrobiota bacterium]	diamond	255	176	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
26735519	26735519	PRJNA734348_P_NODE_90461_length_252_cov_1.357542_g89763_i0	PRJNA734348	90461	252	1.357542	3.42100584	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	178	1.74e-52	NR	HEX9870216.1	2528274	g89763	i0	92.8	0.988095238095238	83	6	98.8	0	2	250	190	272	HEX9870216.1 CoA transferase [Candidatus Tectimicrobiota bacterium]	diamond	249	178	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
27400231	27400231	PRJNA734348_P_NODE_64503_length_275_cov_1.524752_g63806_i0	PRJNA734348	64503	275	1.524752	4.193068	Nitrospinota bacterium	2026769	Bacteria	Bacteria	87	1.41e-17	NR	MDH5509369.1	2026769	g63806	i0	45.1	1.98545454545455	91	50	99.3	0	1	273	30	120	MDH5509369.1 DEAD/DEAH box helicase [Nitrospinota bacterium]	diamond	546	87	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
27652831	27652831	PRJNA734348_P_NODE_144524_length_226_cov_2.496732_g143826_i0	PRJNA734348	144524	226	2.496732	5.64261432	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	146	7.87e-41	NR	HEY7492388.1	2528274	g143826	i0	93.2	0.982300884955752	74	5	98.2	0	3	224	139	212	HEY7492388.1 amidohydrolase family protein [Candidatus Tectimicrobiota bacterium]	diamond	222	146	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
27873721	27873721	PRJNA734348_P_NODE_89345_length_253_cov_0.933333_g88647_i0	PRJNA734348	89345	253	0.933333	2.36133249	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	150	4.289999999999999e-40	NR	HEY5864913.1	2528274	g88647	i0	96.4	0.99604743083004	84	3	99.6	0	2	253	647	730	HEY5864913.1 AAA family ATPase [Candidatus Tectimicrobiota bacterium]	diamond	252	150	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
28852286	28852286	PRJNA734348_P_NODE_142308_length_229_cov_2.461538_g141610_i0	PRJNA734348	142308	229	2.461538	5.63692202	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	118	6.35e-29	NR	HEX2277895.1	2528274	g141610	i0	77.6	0.995633187772926	76	17	99.6	0	228	1	483	558	HEX2277895.1 PEP/pyruvate-binding domain-containing protein [Candidatus Tectimicrobiota bacterium]	diamond	228	118	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
29231539	29231539	PRJNA734348_P_NODE_128129_length_242_cov_0.911243_g127431_i0	PRJNA734348	128129	242	0.911243	2.20520806	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	142	3.61e-38	NR	HEX9869364.1	2528274	g127431	i0	90	0.991735537190083	80	8	99.2	0	241	2	286	365	HEX9869364.1 ATP-binding protein [Candidatus Tectimicrobiota bacterium]	diamond	240	142	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
29578496	29578496	PRJNA734348_P_NODE_88270_length_253_cov_3.350000_g87572_i0	PRJNA734348	88270	253	3.35	8.4755	Candidatus Nitrohelix vancouverensis	2705534	Bacteria	Bacteria	137	1.17e-38	NR	QPJ66595.1	2705534	g87572	i0	74.7	1.9802371541502	83	21	98.4	0	2	250	11	93	QPJ66595.1 MAG: imidazoleglycerol-phosphate dehydratase HisB [Candidatus Nitrohelix vancouverensis]	diamond	501	137	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitrohelix	Candidatus Nitrohelix vancouverensis
29641514	29641514	PRJNA734348_P_NODE_148150_length_206_cov_4.421053_g147452_i0	PRJNA734348	148150	206	4.421053	9.10736918	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	117	2.57e-29	NR	HEX9868400.1	2528274	g147452	i0	85.3	0.990291262135922	68	10	99	0	1	204	73	140	HEX9868400.1 IS110 family transposase [Candidatus Tectimicrobiota bacterium]	diamond	204	117	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
30178731	30178731	PRJNA734348_P_NODE_146352_length_215_cov_4.838028_g145654_i0	PRJNA734348	146352	215	4.838028	10.4017602	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	134	2.63e-36	NR	MDQ3829317.1	2528274	g145654	i0	81.7	0.990697674418605	71	13	99.1	0	215	3	231	301	MDQ3829317.1 IS630 family transposase [Candidatus Tectimicrobiota bacterium]	diamond	213	134	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
30315910	30315910	PRJNA734348_P_NODE_150052_length_198_cov_5.672000_g149354_i0	PRJNA734348	150052	198	5.672	11.23056	Bacteria	2	Bacteria	Bacteria	110	1.86e-26	NR	MDQ3828620.1	2528274	g149354	i0	91.7	1.81818181818182	60	5	90.9	0	3	182	408	467	MDQ3828620.1 transposase [Candidatus Tectimicrobiota bacterium]	diamond	360	111	0.990990990990991	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
30368826	30368826	PRJNA734348_P_NODE_143772_length_227_cov_2.512987_g143074_i0	PRJNA734348	143772	227	2.512987	5.70448049	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	120	5.18e-30	NR	HEX2276925.1	2528274	g143074	i0	93.3	0.79295154185022	60	4	79.3	0	3	182	39	98	HEX2276925.1 ABC transporter substrate-binding protein [Candidatus Tectimicrobiota bacterium]	diamond	180	120	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
30400488	30400488	PRJNA734348_P_NODE_91833_length_251_cov_1.370787_g91135_i0	PRJNA734348	91833	251	1.370787	3.44067537	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	155	2.1600000000000001e-44	NR	HSF31962.1	2528274	g91135	i0	85.5	0.99203187250996006	83	12	99.2	0	250	2	210	292	HSF31962.1 phytoene/squalene synthase family protein [Candidatus Tectimicrobiota bacterium]	diamond	249	155	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
30621077	30621077	PRJNA734348_P_NODE_79353_length_261_cov_1.638298_g78655_i0	PRJNA734348	79353	261	1.638298	4.27595778	Nitrospina sp.	2024844	Bacteria	Bacteria	56.2	8.44e-7	NR	MBT4374554.1	2024844	g78655	i0	40.7	2.2183908045977	91	37	85.1	2	246	25	23	113	MBT4374554.1 hypothetical protein [Nitrospina sp.]	diamond	579	56.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina sp.
30652549	30652549	PRJNA734348_P_NODE_110033_length_246_cov_2.763006_g109335_i0	PRJNA734348	110033	246	2.763006	6.79699476	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	120	7.89e-31	NR	MDQ3830196.1	2528274	g109335	i0	72.8	0.98780487804878	81	22	98.8	0	2	244	226	306	MDQ3830196.1 DUF2332 domain-containing protein [Candidatus Tectimicrobiota bacterium]	diamond	243	120	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
31664143	31664143	PRJNA734348_P_NODE_105597_length_248_cov_0.880000_g104899_i0	PRJNA734348	105597	248	0.88	2.1824	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	136	2.15e-37	NR	HSF31988.1	2528274	g104899	i0	93.7	0.955645161290323	79	5	95.6	0	239	3	42	120	HSF31988.1 bile acid:sodium symporter [Candidatus Tectimicrobiota bacterium]	diamond	237	136	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
31790604	31790604	PRJNA734348_P_NODE_136117_length_238_cov_2.672727_g135419_i0	PRJNA734348	136117	238	2.672727	6.36109026	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	40	0.0425	NR	HEX2279541.1	2528274	g135419	i0	76	0.315126050420168	25	6	31.5	0	163	237	1	25	HEX2279541.1 helix-turn-helix domain-containing protein [Candidatus Tectimicrobiota bacterium]	diamond	75	40	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
31790614	31790614	PRJNA734348_P_NODE_149637_length_200_cov_4.409449_g148939_i0	PRJNA734348	149637	200	4.409449	8.818898	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	132	1.0699999999999998e-37	NR	HEX9869917.1	2528274	g148939	i0	95.5	0.99	66	3	99	0	2	199	38	103	HEX9869917.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	198	132	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
32581933	32581933	PRJNA734348_P_NODE_88799_length_253_cov_1.711111_g88101_i0	PRJNA734348	88799	253	1.711111	4.32911083	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	167	9.3e-51	NR	HEX9869215.1	2528274	g88101	i0	92.8	1.96837944664032	83	6	98.4	0	251	3	9	91	HEX9869215.1 transposase [Candidatus Tectimicrobiota bacterium]	diamond	498	167	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);;