metadata: contig_metadata: 22 rows where bioproject = "PRJNA879067" and tax

22 rows where bioproject = "PRJNA879067" and tax_kingdom = "Thermoproteati"

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
854748	854748	PRJNA879067_P_NODE_31421_length_740_cov_8.110945_g28080_i0	PRJNA879067	31421	740	8.110945	60.020993	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	1002	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g28080	i0	91.093	1.00135135135135	741	64	100	2	1	740	270901	271640	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	741	1002	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
2131023	2131023	PRJNA879067_P_NODE_64362_length_421_cov_1.942529_g60877_i0	PRJNA879067	64362	421	1.942529	8.17804709	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	701	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g60877	i0	96.675	1.99524940617577	421	14	100	0	1	421	663964	663544	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	840	701	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
3405465	3405465	PRJNA879067_P_NODE_30883_length_749_cov_5.241124_g27554_i0	PRJNA879067	30883	749	5.241124	39.25601876	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	1000	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g27554	i0	90.704	1.31375166889186	753	66	100	3	1	749	1323475	1322723	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	984	1000	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
4682887	4682887	PRJNA879067_P_NODE_25944_length_846_cov_5.402329_g22737_i0	PRJNA879067	25944	846	5.402329	45.70370334	Nitrosopumilus zosterae	718286	Archaea	Archaea	54.7	0.024	NTclustered	gi\|2289589374\|dbj\|AP026695.1\|	718286	g22737	i0	96.875	0.0378250591016548	32	1	4	0	368	399	1617635	1617604	Nitrosopumilus zosterae NM25 DNA, complete genome	blastn	32	54.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus zosterae
7233564	7233564	PRJNA879067_P_NODE_52146_length_507_cov_4.122120_g48662_i0	PRJNA879067	52146	507	4.12212	20.8991484	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	660	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g48662	i0	91.649	2.465483234714	479	37	94	3	30	507	1045943	1045467	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	1250	660	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
7233703	7233703	PRJNA879067_P_NODE_56666_length_472_cov_10.596491_g53181_i0	PRJNA879067	56666	472	10.596491	50.01543752	uncultured crenarchaeote	29281	Archaea	Archaea	638	2.77e-178	NTclustered	gi\|22797874\|emb\|AJ496176.1\|	29281	g53181	i0	92.955	47.2944915254237	440	28	93	3	9	447	6340	5903	Uncultured crenarchaeote 34 kb genomic fragment	blastn	22323	638	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
7234369	7234369	PRJNA879067_P_NODE_8266_length_1730_cov_11.960772_g6375_i0	PRJNA879067	8266	1730	11.960772	206.9213556	Candidatus Nitrosotenuis sp. DW1	2259672	Archaea	Archaea	501	1.4699999999999999e-136	NTclustered	gi\|1869227213\|gb\|CP030846.1\|	2259672	g6375	i0	73.721	6.21560693641618	1446	311	81	46	121	1516	21503	22929	Candidatus Nitrosotenuis sp. DW1 chromosome, complete genome	blastn	10753	501	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis sp. DW1
8507374	8507374	PRJNA879067_P_NODE_24567_length_878_cov_11.309317_g21418_i0	PRJNA879067	24567	878	11.309317	99.29580326	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	1493	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g21418	i0	98.465	1.91002277904328	847	13	96	0	32	878	302145	301299	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	1677	1493	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
13608688	13608688	PRJNA879067_P_NODE_41951_length_601_cov_4.566288_g38496_i0	PRJNA879067	41951	601	4.566288	27.44339088	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	885	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g38496	i0	94.618	0.958402662229617	576	24	95	2	1	570	1492535	1493109	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	576	885	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
13609586	13609586	PRJNA879067_P_NODE_73891_length_367_cov_3.921769_g70406_i0	PRJNA879067	73891	367	3.921769	14.39289223	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	556	6.06e-154	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g70406	i0	96.176	0.926430517711172	340	13	93	0	28	367	1369295	1368956	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	340	556	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
14883655	14883655	PRJNA879067_P_NODE_62732_length_431_cov_3.539106_g59247_i0	PRJNA879067	62732	431	3.539106	15.25354686	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	322	2.87e-83	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g59247	i0	87.234	0.654292343387471	282	36	65	0	32	313	2964693	2964974	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	282	322	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
16156820	16156820	PRJNA879067_P_NODE_16053_length_1172_cov_8.823476_g13355_i0	PRJNA879067	16053	1172	8.823476	103.41113872	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	1375	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g13355	i0	88.225	4.16723549488055	1155	131	98	5	1	1152	1160268	1159116	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	4884	1375	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
16158513	16158513	PRJNA879067_P_NODE_69593_length_390_cov_3.324921_g66108_i0	PRJNA879067	69593	390	3.324921	12.9671919	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	126	2.33e-35	NR	MDF2738432.1	2169593	g66108	i0	91.5	0.907692307692308	59	5	45.4	0	221	45	1	59	MDF2738432.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	354	126	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
21257448	21257448	PRJNA879067_P_NODE_5357_length_2176_cov_14.075131_g3904_i0	PRJNA879067	5357	2176	14.075131	306.27485056	Candidatus Nitrosotenuis chungbukensis	1353246	Archaea	Archaea	1134	0	NTclustered	gi\|2551106379\|gb\|CP130341.1\|	1353246	g3904	i0	76.987	6.88465073529412	2038	435	93	32	143	2161	1454489	1456511	Candidatus Nitrosotenuis chungbukensis strain MY2 chromosome, complete genome	blastn	14981	1134	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis chungbukensis
27055375	27055375	PRJNA879067_P_NODE_15322_length_1209_cov_8.209507_g12690_i0	PRJNA879067	15322	1209	8.209507	99.25293963	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	212	1.26e-61	NR	MDW3611096.1	2169593	g12690	i0	96.3	0.267990074441687	108	4	26.8	0	1188	865	187	294	MDW3611096.1 DNA repair and recombination protein RadA [Nitrososphaeraceae archaeon]	diamond	324	212	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
27813632	27813632	PRJNA879067_P_NODE_103384_length_251_cov_0.865169_g99898_i0	PRJNA879067	103384	251	0.865169	2.17157419	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	70.9	2.92e-13	NR	HTY77714.1	3045160	g99898	i0	74.4	0.51394422310757	43	11	51.4	0	1	129	80	122	HTY77714.1 TRAP transporter small permease [Candidatus Bathyarchaeia archaeon]	diamond	129	70.9	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
29486556	29486556	PRJNA879067_P_NODE_102530_length_253_cov_1.205556_g99044_i0	PRJNA879067	102530	253	1.205556	3.05005668	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	58.9	5.61e-9	NR	HET9806997.1	2169593	g99044	i0	62.8	0.509881422924901	43	16	51	0	130	2	6	48	HET9806997.1 P-loop NTPase fold protein [Nitrososphaeraceae archaeon]	diamond	129	58.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
29644271	29644271	PRJNA879067_P_NODE_34270_length_697_cov_3.482372_g30889_i0	PRJNA879067	34270	697	3.482372	24.27213284	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	65.9	1.53e-10	NR	MDW3605092.1	2169593	g30889	i0	91.4	0.288378766140603	35	3	15.1	0	524	628	1	35	MDW3605092.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	201	65.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
29834140	29834140	PRJNA879067_P_NODE_79831_length_340_cov_0.996255_g76345_i0	PRJNA879067	79831	340	0.996255	3.387267	Nitrosopumilus sp.	2024843	Archaea	Archaea	125	1.0599999999999998e-31	NR	MDA7940732.1	2024843	g76345	i0	65.4	2.12647058823529	81	28	71.5	0	14	256	319	399	MDA7940732.1 multicopper oxidase domain-containing protein [Nitrosopumilus sp.]	diamond	723	125	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
31097784	31097784	PRJNA879067_P_NODE_70655_length_385_cov_0.900641_g67170_i0	PRJNA879067	70655	385	0.900641	3.46746785	Desulfurococcales archaeon	2480821	Archaea	Archaea	68.9	3.39e-12	NR	MEB3780172.1	2480821	g67170	i0	43.5	0.662337662337662	85	42	66.2	1	3	257	33	111	MEB3780172.1 YbjQ family protein [Desulfurococcales archaeon]	diamond	255	68.9	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales			Desulfurococcales archaeon
31825110	31825110	PRJNA879067_P_NODE_76997_length_352_cov_2.856631_g73511_i0	PRJNA879067	76997	352	2.856631	10.05534112	Nitrososphaerota archaeon	2026795	Archaea	Archaea	101	2.41e-22	NR	MEM3063527.1	2026795	g73511	i0	47.3	0.954545454545455	112	59	95.5	0	337	2	357	468	MEM3063527.1 DNA polymerase [Nitrososphaerota archaeon]	diamond	336	101	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
32686895	32686895	PRJNA879067_P_NODE_92760_length_288_cov_1.790698_g89274_i0	PRJNA879067	92760	288	1.790698	5.15721024	root	1	Root_unresolved	Root_unresolved	65.9	1.14e-10	NR	HYF75015.1	2109671	g89274	i0	66.7	3.20833333333333	45	11	46.9	1	288	154	75	115	HYF75015.1 nucleoside 2-deoxyribosyltransferase domain-containing protein [Candidatus Nitrosocosmicus sp.]	diamond	924	65.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.

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);;