metadata: contig_metadata: 10 rows where bioproject = "PRJNA1233465" and tax

10 rows where bioproject = "PRJNA1233465" and tax_phylum = "Nitrososphaerota"

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
26090820	26090820	PRJNA1233465e_S_NODE_125933_length_175_cov_4.373016_g124623_i0	PRJNA1233465	125933	175	4.373016	7.652778	Nitrosopumilus adriaticus	1580092	Archaea	Archaea	62.1	2.45e-5	NTclustered	gi\|2790751567\|gb\|CP167059.1\|	1580092	g124623	i0	97.222	0.205714285714286	36	1	21	0	122	157	882923	882958	Nitrosopumilus adriaticus strain CCS1 chromosome	blastn	36	62.1	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus adriaticus
32931443	32931443	PRJNA1233465a_S_NODE_130249_length_206_cov_6579.292994_g128975_i0	PRJNA1233465	130249	206	6579.292994	13553.34356764	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	42	0.0422	NR	MDW0213754.1	2169593	g128975	i0	72	0.364077669902913	25	7	36.4	0	85	11	336	360	MDW0213754.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	75	42	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32932730	32932730	PRJNA1233465d_S_NODE_138289_length_163_cov_0.894737_g137178_i0	PRJNA1233465	138289	163	0.894737	1.45842131	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	87	2.24e-20	NR	HEY7570302.1	2169593	g137178	i0	74.1	1.98773006134969	54	14	99.4	0	162	1	26	79	HEY7570302.1 acyl-CoA dehydrogenase family protein [Nitrososphaeraceae archaeon]	diamond	324	87	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
33034678	33034678	PRJNA1233465b_S_NODE_221908_length_200_cov_1.688742_g220223_i0	PRJNA1233465	221908	200	1.688742	3.377484	Nitrososphaerota archaeon	2026795	Archaea	Archaea	133	1.32e-37	NR	MEM4675793.1	2026795	g220223	i0	82.8	0.96	64	11	96	0	195	4	100	163	MEM4675793.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	192	133	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
33069565	33069565	PRJNA1233465d_S_NODE_79309_length_200_cov_1313.496689_g78198_i0	PRJNA1233465	79309	200	1313.496689	2626.993378	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	40.4	0.0328	NR	MDW0332462.1	2169593	g78198	i0	60	0.45	30	9	45	1	38	127	59	85	MDW0332462.1 metallophosphoesterase family protein [Nitrososphaeraceae archaeon]	diamond	90	40.4	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
33119807	33119807	PRJNA1233465b_S_NODE_157047_length_231_cov_2.483516_g155362_i0	PRJNA1233465	157047	231	2.483516	5.73692196	Nitrososphaera sp.	1971748	Archaea	Archaea	47.8	1.33e-4	NR	MCI0562075.1	1971748	g155362	i0	40.4	0.74025974025974	57	34	74	0	2	172	59	115	MCI0562075.1 hypothetical protein [Nitrososphaera sp.]	diamond	171	47.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
33120495	33120495	PRJNA1233465d_S_NODE_149847_length_154_cov_2.580952_g148736_i0	PRJNA1233465	149847	154	2.580952	3.97466608	Nitrososphaeria archaeon	2268198	Archaea	Archaea	39.3	0.0364	NR	NDB33661.1	2268198	g148736	i0	53.1	0.623376623376623	32	15	62.3	0	102	7	33	64	NDB33661.1 hypothetical protein [Nitrososphaeria archaeon]	diamond	96	39.3	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria				Nitrososphaeria archaeon
33120553	33120553	PRJNA1233465d_S_NODE_24975_length_327_cov_159.043165_g23864_i0	PRJNA1233465	24975	327	159.043165	520.07114955	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	42	0.0251	NR	MDW3604526.1	2169593	g23864	i0	39.3	0.559633027522936	61	26	53.2	2	272	99	1	53	MDW3604526.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	183	42	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
33136776	33136776	PRJNA1233465a_S_NODE_86023_length_242_cov_56930.440415_g84749_i0	PRJNA1233465	86023	242	56930.440415	137771.6658043	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	43.5	0.00272	NR	MDW0272514.1	2169593	g84749	i0	65.4	0.322314049586777	26	9	32.2	0	88	11	49	74	MDW0272514.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	78	43.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
33154662	33154662	PRJNA1233465d_S_NODE_32696_length_291_cov_28447.409091_g31585_i0	PRJNA1233465	32696	291	28447.409091	82781.96045481	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	41.2	0.0438	NR	MDW0332462.1	2169593	g31585	i0	44.6	0.670103092783505	65	29	64.9	3	262	74	26	85	MDW0332462.1 metallophosphoesterase family protein [Nitrososphaeraceae archaeon]	diamond	195	41.2	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);;