metadata: contig_metadata: 7 rows where bioproject = "PRJNA1022139", tax_phylum = "Nitrososphaerota" and tax

7 rows where bioproject = "PRJNA1022139", tax_phylum = "Nitrososphaerota" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26623299	26623299	PRJNA1022139_P_NODE_17221_length_333_cov_1.776923_g17116_i0	PRJNA1022139	17221	333	1.776923	5.91715359	Candidatus Caldarchaeum sp.	2972665	Archaea	Archaea	42	0.0318	NR	MEM0462448.1	2972665	g17116	i0	31.3	0.576576576576577	64	36	57.7	1	268	77	2	57	MEM0462448.1 hypothetical protein [Candidatus Caldarchaeum sp.]	diamond	192	42	1	Archaea	Thermoproteati	Nitrososphaerota		Candidatus Caldarchaeales	Candidatus Caldarchaeaceae	Candidatus Caldarchaeum	Candidatus Caldarchaeum sp.
27098109	27098109	PRJNA1022139_P_NODE_27882_length_274_cov_2.179104_g27777_i0	PRJNA1022139	27882	274	2.179104	5.97074496	Nitrosopumilus sp.	2024843	Archaea	Archaea	62.4	1.17e-9	NR	MBT3686226.1	2024843	g27777	i0	36.6	2.38686131386861	82	52	89.8	0	246	1	1	82	MBT3686226.1 ferritin [Nitrosopumilus sp.]	diamond	654	62.4	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
27438225	27438225	PRJNA1022139_P_NODE_21583_length_302_cov_1.008734_g21478_i0	PRJNA1022139	21583	302	1.008734	3.04637668	root	1	Root_unresolved	Root_unresolved	120	9.16e-31	NR	WP_268541211.1	1603555	g21478	i0	57	15.8940397350993	100	43	99.3	0	1	300	48	147	WP_268541211.1 spherulation-specific family 4 protein, partial [Candidatus Nitrosotenuis cloacae]	diamond	4800	121	0.991735537190083	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
29623878	29623878	PRJNA1022139_P_NODE_31210_length_262_cov_1.629630_g31105_i0	PRJNA1022139	31210	262	1.62963	4.2696306	Candidatus Nitrosotalea sp. FS	2341021	Archaea	Archaea	48.5	2.98e-4	NR	NHH98042.1	2341021	g31105	i0	30.4	1.80916030534351	79	51	90.5	1	10	246	89	163	NHH98042.1 putative MFS-type transporter [Candidatus Nitrosotalea sp. FS]	diamond	474	48.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosotaleales	Nitrosotaleaceae	Nitrosotalea	Candidatus Nitrosotalea sp. FS
30185006	30185006	PRJNA1022139_P_NODE_25212_length_284_cov_1.184834_g25107_i0	PRJNA1022139	25212	284	1.184834	3.36492856	Archaea	2157	Archaea	Archaea	53.1	1.32e-5	NR	MBT5201713.1	2026795	g25107	i0	33.7	2.36619718309859	92	59	97.2	2	8	283	316	405	MBT5201713.1 polysaccharide deacetylase family protein [Nitrososphaerota archaeon]	diamond	672	53.1	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
30975112	30975112	PRJNA1022139_P_NODE_3574_length_667_cov_1.685185_g3472_i0	PRJNA1022139	3574	667	1.685185	11.24018395	root	1	Root_unresolved	Root_unresolved	244	8.05e-76	NR	WP_157927732.1	1903276	g3472	i0	54.4	10.880059970015	217	94	96.3	3	642	1	57	271	WP_157927732.1 multicopper oxidase domain-containing protein [Candidatus Nitrosotalea okcheonensis]	diamond	7257	246	0.991869918699187	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosotaleales	Nitrosotaleaceae	Nitrosotalea	Candidatus Nitrosotalea okcheonensis
32374592	32374592	PRJNA1022139_P_NODE_19679_length_315_cov_1.272727_g19574_i0	PRJNA1022139	19679	315	1.272727	4.00909005	Nitrososphaerales archaeon	2268197	Archaea	Archaea	71.2	7.84e-14	NR	MFI5422912.1	2268197	g19574	i0	48.5	0.647619047619048	68	34	63.8	1	66	266	8	75	MFI5422912.1 hypothetical protein [Nitrososphaerales archaeon]	diamond	204	71.2	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales			Nitrososphaerales 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);;