metadata: contig_metadata: 10 rows where bioproject = "PRJNA560932", tax_phylum = "Nitrososphaerota" and tax

10 rows where bioproject = "PRJNA560932", 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
13298805	13298805	PRJNA560932_P_NODE_49271_length_259_cov_1.365591_g48915_i0	PRJNA560932	49271	259	1.365591	3.53688069	Nitrosarchaeum sp.	2026886	Archaea	Archaea	111	3.46e-26	NR	MFB5612793.1	2026886	g48915	i0	71.8	0.984555984555985	85	24	98.5	0	2	256	518	602	MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.]	diamond	255	111	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp.
26712919	26712919	PRJNA560932_P_NODE_38221_length_294_cov_1.389140_g37865_i0	PRJNA560932	38221	294	1.38914	4.0840716	Thermoproteati	1783275	Archaea	Archaea	45.1	0.00955	NR	MEM4316274.1	2026795	g37865	i0	28.9	2.54081632653061	83	56	84.7	2	43	291	200	279	MEM4316274.1 DUF3782 domain-containing protein [Nitrososphaerota archaeon]	diamond	747	45.4	0.993392070484582	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
27693526	27693526	PRJNA560932_P_NODE_48264_length_262_cov_1.629630_g47908_i0	PRJNA560932	48264	262	1.62963	4.2696306	root	1	Root_unresolved	Root_unresolved	43.1	0.0231	NR	WP_148703158.1	338191	g47908	i0	35.1	1.94656488549618	57	36	65.3	1	260	90	117	172	WP_148703158.1 MULTISPECIES: NADPH-dependent FMN reductase [Nitrosopumilus]	diamond	510	43.1	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus
27756633	27756633	PRJNA560932_P_NODE_28484_length_336_cov_3.148289_g28128_i0	PRJNA560932	28484	336	3.148289	10.57825104	Candidatus Nitrosotenuis	1825023	Archaea	Archaea	104	5.02e-25	NR	MBI5698011.1	2026795	g28128	i0	58	4.30357142857143	81	34	72.3	0	64	306	4	84	MBI5698011.1 ammonium transporter [Nitrososphaerota archaeon]	diamond	1446	104	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
28324622	28324622	PRJNA560932_P_NODE_63646_length_243_cov_0.905882_g63290_i0	PRJNA560932	63646	243	0.905882	2.20129326	Thermoproteati	1783275	Archaea	Archaea	57	3.02e-7	NR	WP_172602162.1	1798806	g63290	i0	36.1	5.82716049382716	83	40	88.9	2	243	28	125	205	WP_172602162.1 ribose-phosphate diphosphokinase [Candidatus Nitrosocosmicus franklandus]	diamond	1416	57	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus franklandianus
29966676	29966676	PRJNA560932_P_NODE_1591_length_1229_cov_3.747405_g1421_i0	PRJNA560932	1591	1229	3.747405	46.05560745	root	1	Root_unresolved	Root_unresolved	364	5.24e-120	NR	WP_101010768.1	1499975	g1421	i0	52	15.2172497965826	344	156	82.8	3	78	1094	54	393	WP_101010768.1 multicopper oxidase domain-containing protein [Nitrosotalea sinensis]	diamond	18702	364	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosotaleales	Nitrosotaleaceae	Nitrosotalea	Nitrosotalea sinensis
30914618	30914618	PRJNA560932_P_NODE_22914_length_370_cov_1.898990_g22558_i0	PRJNA560932	22914	370	1.89899	7.026263	root	1	Root_unresolved	Root_unresolved	43.9	0.0493	NR	HJS64354.1	2169593	g22558	i0	54.5	0.608108108108108	33	15	26.8	0	153	251	232	264	HJS64354.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	225	44.3	0.99097065462754	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
31216091	31216091	PRJNA560932_P_NODE_61555_length_245_cov_0.895349_g61199_i0	PRJNA560932	61555	245	0.895349	2.19360505	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	107	1.3500000000000002e-26	NR	MCJ7636954.1	2169593	g61199	i0	64.6	9.66122448979592	79	28	96.7	0	8	244	73	151	MCJ7636954.1 ammonia channel protein [Nitrososphaeraceae archaeon]	diamond	2367	107	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
31690894	31690894	PRJNA560932_P_NODE_62557_length_244_cov_0.900585_g62201_i0	PRJNA560932	62557	244	0.900585	2.1974274	Nitrososphaerota archaeon	2026795	Archaea	Archaea	90.9	1.3e-19	NR	MEM3062935.1	2026795	g62201	i0	50.7	1.74590163934426	71	34	87.3	1	1	213	205	274	MEM3062935.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	426	90.9	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
31754153	31754153	PRJNA560932_P_NODE_49497_length_258_cov_1.664865_g49141_i0	PRJNA560932	49497	258	1.664865	4.2953517	Candidatus Nitrosocaldus islandicus	2045011	Archaea	Archaea	114	1.3100000000000002e-27	NR	WP_103288010.1	2045011	g49141	i0	64.7	3.95348837209302	85	30	98.8	0	257	3	13	97	WP_103288010.1 IMP dehydrogenase [Candidatus Nitrosocaldus islandicus]	diamond	1020	114	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Candidatus Nitrosocaldales	Candidatus Nitrosocaldaceae	Candidatus Nitrosocaldus	Candidatus Nitrosocaldus islandicus

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