metadata: contig_metadata: 15 rows where bioproject = "PRJNA1174207" and tax

15 rows where bioproject = "PRJNA1174207" and tax_superkingdom = "Archaea"

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
315552	315552	PRJNA1174207_P_NODE_21481_length_308_cov_1.510638_g20952_i0	PRJNA1174207	21481	308	1.510638	4.65276504	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	566	8.299999999999999e-157	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g20952	i0	100	18.9058441558442	306	0	99	0	3	308	739198	739503	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	5823	566	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
2866770	2866770	PRJNA1174207_P_NODE_5203_length_744_cov_2.572280_g4705_i0	PRJNA1174207	5203	744	2.57228	19.1377632	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	1062	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g4705	i0	98.988	70.0201612903226	593	6	99	0	2	594	739205	738613	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	52095	1062	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
6143506	6143506	PRJNA1174207_P_NODE_30045_length_264_cov_2.267016_g29516_i0	PRJNA1174207	30045	264	2.267016	5.98492224	Candidatus Nitrosotenuis	1825023	Archaea	Archaea	486	5.579999999999999e-133	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g29516	i0	100	102.280303030303	263	0	99	0	2	264	741303	741041	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	27002	486	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
6693914	6693914	PRJNA1174207_P_NODE_8246_length_549_cov_4.002101_g7722_i0	PRJNA1174207	8246	549	4.002101	21.97153449	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	1009	0	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g7722	i0	99.818	97.2823315118397	549	1	100	0	1	549	740752	740204	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	53408	1009	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
9243523	9243523	PRJNA1174207_P_NODE_27408_length_275_cov_2.103960_g26879_i0	PRJNA1174207	27408	275	2.10396	5.78589	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	359	1.33e-94	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g26879	i0	90.441	1.99272727272727	272	26	99	0	3	274	1495875	1495604	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	548	359	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
16343068	16343068	PRJNA1174207_P_NODE_22813_length_297_cov_4.169643_g22284_i0	PRJNA1174207	22813	297	4.169643	12.38383971	Methanosarcina	2207	Archaea	Archaea	549	8.029999999999997e-152	NTclustered	gi\|827396966\|gb\|CP008746.1\|	796385	g22284	i0	100	40.2592592592593	297	0	100	0	1	297	4158835	4158539	Methanosarcina barkeri CM1, complete genome	blastn	11957	549	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina barkeri
20167049	20167049	PRJNA1174207_P_NODE_38656_length_244_cov_2.690058_g38127_i0	PRJNA1174207	38656	244	2.690058	6.56374152	root	1	Root_unresolved	Root_unresolved	446	8.639999999999999e-121	NTclustered	gi\|325984387\|gb\|JF262284.1\|	29281	g38127	i0	99.59	100	244	1	100	0	1	244	571	814	Uncultured crenarchaeote clone YLA147 16S ribosomal RNA gene, partial sequence	blastn	24400	446	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
22717677	22717677	PRJNA1174207_P_NODE_42138_length_237_cov_2.487805_g41609_i0	PRJNA1174207	42138	237	2.487805	5.89609785	Candidatus Nitrosotenuis	1825023	Archaea	Archaea	438	1.4e-118	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g41609	i0	100	98.2995780590717	237	0	100	0	1	237	738442	738206	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	23297	438	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
26723465	26723465	PRJNA1174207_P_NODE_21661_length_306_cov_2.278970_g21132_i0	PRJNA1174207	21661	306	2.27897	6.9736482	archaeon	1906665	Archaea	Archaea	124	2.77e-33	NR	MDP2434978.1	1906665	g21132	i0	59.4	0.990196078431373	101	40	99	1	2	304	109	208	MDP2434978.1 glycoside hydrolase family 25 protein [archaeon]	diamond	303	124	1	Archaea								archaeon
26977173	26977173	PRJNA1174207_P_NODE_39662_length_243_cov_0.905882_g39133_i0	PRJNA1174207	39662	243	0.905882	2.20129326	Nitrosarchaeum sp.	2026886	Archaea	Archaea	89.7	1.11e-18	NR	MEX2192498.1	2026886	g39133	i0	57.3	1.01234567901235	82	34	100	1	1	243	826	907	MEX2192498.1 N-6 DNA methylase [Nitrosarchaeum sp.]	diamond	246	89.7	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp.
27577652	27577652	PRJNA1174207_P_NODE_9364_length_504_cov_2.238979_g8838_i0	PRJNA1174207	9364	504	2.238979	11.28445416	archaeon	1906665	Archaea	Archaea	43.5	0.0423	NR	MCQ2816078.1	1906665	g8838	i0	30.6	0.369047619047619	62	43	36.9	0	187	2	32	93	MCQ2816078.1 EF-hand domain-containing protein [archaeon]	diamond	186	43.5	1	Archaea								archaeon
31525989	31525989	PRJNA1174207_P_NODE_32976_length_252_cov_1.636872_g32447_i0	PRJNA1174207	32976	252	1.636872	4.12491744	Nanobdellota archaeon	2026764	Archaea	Archaea	75.1	1.6e-13	NR	MCK5629034.1	2026764	g32447	i0	50.7	1.5952380952381	67	33	79.8	0	1	201	175	241	MCK5629034.1 diaminopimelate decarboxylase [Nanoarchaeota archaeon]	diamond	402	75.1	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
32253791	32253791	PRJNA1174207_P_NODE_26338_length_280_cov_1.386473_g25809_i0	PRJNA1174207	26338	280	1.386473	3.8821244	Methanobacteriota archaeon	2026739	Archaea	Archaea	43.1	0.0272	NR	MAV06623.1	2026739	g25809	i0	31	0.9	84	52	86.8	3	266	24	101	181	MAV06623.1 hypothetical protein [Methanobacteriota archaeon]	diamond	252	43.1	1	Archaea		Methanobacteriati	Methanobacteriota					Methanobacteriota archaeon
32664161	32664161	PRJNA1174207_P_NODE_29340_length_267_cov_1.912371_g28811_i0	PRJNA1174207	29340	267	1.912371	5.10603057	archaeon	1906665	Archaea	Archaea	117	7.879999999999999e-31	NR	RYG50181.1	1906665	g28811	i0	65.9	2.01123595505618	88	30	98.9	0	3	266	32	119	RYG50181.1 MAG: hypothetical protein EON67_05740, partial [archaeon]	diamond	537	117	1	Archaea								archaeon
32884611	32884611	PRJNA1174207_P_NODE_36460_length_247_cov_1.327586_g35931_i0	PRJNA1174207	36460	247	1.327586	3.27913742	archaeon	1906665	Archaea	Archaea	92	1.33e-19	NR	MCQ2821526.1	1906665	g35931	i0	75.5	3.88663967611336	53	13	64.4	0	167	9	183	235	MCQ2821526.1 protein kinase [archaeon]	diamond	960	92	1	Archaea								archaeon

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