metadata: contig_metadata: 9 rows where bioproject = "PRJNA897077" and tax

9 rows where bioproject = "PRJNA897077" 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
2519806	2519806	PRJNA897077_P_NODE_19162_length_244_cov_0.894737_g19035_i0	PRJNA897077	19162	244	0.894737	2.18315828	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	147	2.67e-40	NR	HTY80510.1	3045160	g19035	i0	91.4	0.995901639344262	81	7	99.6	0	1	243	337	417	HTY80510.1 CoA transferase [Candidatus Bathyarchaeia archaeon]	diamond	243	147	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
17451960	17451960	PRJNA897077_P_NODE_7214_length_363_cov_2.286207_g7087_i0	PRJNA897077	7214	363	2.286207	8.29893141	haloarchaeon 3A1-DGR	1071085	Archaea	Archaea	56.5	0.003	NTclustered	gi\|1804090075\|gb\|CP048032.1\|	1071085	g7087	i0	100	0.322314049586777	30	0	8	0	203	232	1418813	1418784	Haloarchaeon 3A1-DGR strain 3A1-DGR chromosome, complete genome	blastn	117	56.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales			haloarchaeon 3A1-DGR
21646318	21646318	PRJNA897077_P_NODE_19457_length_243_cov_0.917647_g19330_i0	PRJNA897077	19457	243	0.917647	2.22988221	Methanothermobacter	145260	Archaea	Archaea	448	2.39e-121	NTclustered	gi\|427188531\|dbj\|AP011952.1\|	866790	g19330	i0	100	4.97942386831276	242	0	99	0	1	242	1436085	1435844	Methanothermobacter sp. CaT2 DNA, complete genome	blastn	1210	448	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanothermobacter	Methanothermobacter sp. CaT2
28823936	28823936	PRJNA897077_P_NODE_17548_length_248_cov_0.880000_g17421_i0	PRJNA897077	17548	248	0.88	2.1824	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	111	4.5700000000000005e-27	NR	MFA5174430.1	2026773	g17421	i0	61	0.991935483870968	82	32	99.2	0	247	2	106	187	MFA5174430.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	246	111	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
29108498	29108498	PRJNA897077_P_NODE_17528_length_248_cov_0.891429_g17401_i0	PRJNA897077	17528	248	0.891429	2.21074392	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	108	2.3e-26	NR	MBS3142688.1	2026803	g17401	i0	62.2	0.991935483870968	82	31	99.2	0	248	3	118	199	MBS3142688.1 type II methionyl aminopeptidase [Candidatus Woesearchaeota archaeon]	diamond	246	108	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
29897879	29897879	PRJNA897077_P_NODE_17151_length_248_cov_1.782857_g17024_i0	PRJNA897077	17151	248	1.782857	4.42148536	Thermoplasmatota archaeon	2806419	Archaea	Archaea	43.9	0.00769	NR	HEV8361626.1	2806419	g17024	i0	35.7	1.01612903225806	84	38	96.8	3	2	241	43	114	HEV8361626.1 hypothetical protein [Thermoplasmatota archaeon]	diamond	252	43.9	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
30182020	30182020	PRJNA897077_P_NODE_16912_length_249_cov_0.886364_g16785_i0	PRJNA897077	16912	249	0.886364	2.20704636	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	115	1.3399999999999998e-31	NR	HKG30437.1	2169593	g16785	i0	75.6	0.939759036144578	78	18	92.8	1	1	231	15	92	HKG30437.1 FUN14 domain-containing protein [Nitrososphaeraceae archaeon]	diamond	234	115	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32332333	32332333	PRJNA897077_P_NODE_19279_length_243_cov_0.917647_g19152_i0	PRJNA897077	19279	243	0.917647	2.22988221	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	153	3.779999999999999e-43	NR	HZV96983.1	2109671	g19152	i0	92.6	1	81	6	100	0	243	1	245	325	HZV96983.1 hypothetical protein [Candidatus Nitrosocosmicus sp.]	diamond	243	153	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
32522116	32522116	PRJNA897077_P_NODE_16279_length_251_cov_0.870787_g16152_i0	PRJNA897077	16279	251	0.870787	2.18567537	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	144	9.26e-41	NR	MDW0278021.1	2169593	g16152	i0	90.4	3.95617529880478	83	8	99.2	0	1	249	69	151	MDW0278021.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	993	144	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae 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);;