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

10 rows where bioproject = "PRJNA715462" and tax_kingdom = "Thermoproteati"

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
18558322	18558322	PRJNA715462_P_NODE_68495_length_241_cov_0.916667_g67699_i0	PRJNA715462	68495	241	0.916667	2.20916747	Candidatus Nitrososphaera evergladensis	1459637	Archaea	Archaea	206	1.57e-48	NTclustered	gi\|665992324\|gb\|CP007174.1\|	1459636	g67699	i0	82.158	4	241	41	99	2	2	241	1519047	1518808	Candidatus Nitrososphaera evergladensis SR1, complete genome	blastn	964	206	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera evergladensis
21108079	21108079	PRJNA715462_P_NODE_26797_length_347_cov_1.124088_g26001_i0	PRJNA715462	26797	347	1.124088	3.90058536	Nitrosarchaeum sp.	2026886	Archaea	Archaea	196	8.66e-57	NR	MFB5612793.1	2026886	g26001	i0	86.1	1.98847262247839	115	16	99.4	0	3	347	445	559	MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.]	diamond	690	196	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp.
27904550	27904550	PRJNA715462_P_NODE_58705_length_247_cov_0.885057_g57909_i0	PRJNA715462	58705	247	0.885057	2.18609079	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	44.7	0.00802	NR	PMB74956.1	2026714	g57909	i0	36.1	2.74493927125506	72	43	87.4	1	9	224	484	552	PMB74956.1 MAG: elongation factor EF-2 [Candidatus Bathyarchaeota archaeon]	diamond	678	44.7	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
27904556	27904556	PRJNA715462_P_NODE_63905_length_244_cov_0.900585_g63109_i0	PRJNA715462	63905	244	0.900585	2.1974274	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	162	1.78e-46	NR	HZB73908.1	2169593	g63109	i0	93.8	0.983606557377049	80	5	98.4	0	3	242	78	157	HZB73908.1 DUF3179 domain-containing protein [Nitrososphaeraceae archaeon]	diamond	240	162	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
27999721	27999721	PRJNA715462_P_NODE_54765_length_249_cov_0.875000_g53969_i0	PRJNA715462	54765	249	0.875	2.17875	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	55.1	8.55e-7	NR	HSQ54041.1	3045160	g53969	i0	76.5	0.409638554216867	34	8	41	0	1	102	52	85	HSQ54041.1 tetratricopeptide repeat protein [Candidatus Bathyarchaeia archaeon]	diamond	102	55.1	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
28610011	28610011	PRJNA715462_P_NODE_54827_length_249_cov_0.875000_g54031_i0	PRJNA715462	54827	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	98.2	5.18e-24	NR	MCE4628138.1	2480821	g54031	i0	53	5	83	39	100	0	249	1	18	100	MCE4628138.1 nucleoside-diphosphate kinase [Desulfurococcales archaeon]	diamond	1245	98.6	0.995943204868154	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales			Desulfurococcales archaeon
28946996	28946996	PRJNA715462_P_NODE_52268_length_250_cov_0.870056_g51472_i0	PRJNA715462	52268	250	0.870056	2.17514	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	54.3	3.4e-6	NR	MDW0181425.1	2169593	g51472	i0	40.9	3.192	66	39	79.2	0	3	200	665	730	MDW0181425.1 reverse transcriptase domain-containing protein [Nitrososphaeraceae archaeon]	diamond	798	54.3	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
31063233	31063233	PRJNA715462_P_NODE_70195_length_231_cov_2.075949_g69399_i0	PRJNA715462	70195	231	2.075949	4.79544219	Nitrososphaerota archaeon	2026795	Archaea	Archaea	58.2	9.5e-8	NR	RZD32614.1	2026795	g69399	i0	43.6	0.714285714285714	55	31	71.4	0	63	227	66	120	RZD32614.1 MAG: hypothetical protein CXT79_05995 [Nitrososphaerota archaeon]	diamond	165	58.2	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
31189037	31189037	PRJNA715462_P_NODE_56975_length_248_cov_0.880000_g56179_i0	PRJNA715462	56975	248	0.88	2.1824	Nitrosarchaeum sp.	2026886	Archaea	Archaea	112	1.57e-26	NR	MFB5612793.1	2026886	g56179	i0	69.5	0.991935483870968	82	25	99.2	0	3	248	512	593	MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.]	diamond	246	112	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp.
31442383	31442383	PRJNA715462_P_NODE_44336_length_268_cov_1.343590_g43540_i0	PRJNA715462	44336	268	1.34359	3.6008212	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	50.4	9.64e-5	NR	MDW0252355.1	2169593	g43540	i0	38.8	0.548507462686567	49	30	54.9	0	159	13	457	505	MDW0252355.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon]	diamond	147	50.4	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);;