metadata: contig_metadata: 5 rows where bioproject = "PRJNA1195374" and tax

5 rows where bioproject = "PRJNA1195374" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
23274322	23274322	PRJNA1195374_P_NODE_6819_length_821_cov_12.724599_g6524_i0	PRJNA1195374	6819	821	12.724599	104.46895779	Nitrosarchaeum sp.	2026886	Archaea	Archaea	253	5.46e-76	NR	MFB5612793.1	2026886	g6524	i0	73	1.44336175395859	196	53	71.6	0	2	589	457	652	MFB5612793.1 molecular chaperone DnaK [Nitrosarchaeum sp.]	diamond	1185	253	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp.
28651454	28651454	PRJNA1195374_P_NODE_1987_length_1287_cov_18.810544_g1822_i0	PRJNA1195374	1987	1287	18.810544	242.09170128	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	47.8	0.0411	NR	HKM78303.1	3045160	g1822	i0	36.7	0.20979020979021	90	51	19.6	1	1131	880	11	100	HKM78303.1 lipoyl(octanoyl) transferase LipB [Candidatus Bathyarchaeia archaeon]	diamond	270	47.8	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
30103857	30103857	PRJNA1195374_P_NODE_33132_length_392_cov_1.642633_g32788_i0	PRJNA1195374	33132	392	1.642633	6.43912136	Candidatus Nezhaarchaeales archaeon	2952944	Archaea	Archaea	43.5	0.0464	NR	MEM4699877.1	2952944	g32788	i0	38	0.604591836734694	79	39	57.4	3	17	241	32	104	MEM4699877.1 VOC family protein [Candidatus Nezhaarchaeales archaeon]	diamond	237	43.5	1	Archaea		Thermoproteati	Candidatus Nezhaarchaeota	Candidatus Nezhaarchaeia	Candidatus Nezhaarchaeales			Candidatus Nezhaarchaeales archaeon
32063804	32063804	PRJNA1195374_P_NODE_23718_length_466_cov_1.727735_g23374_i0	PRJNA1195374	23718	466	1.727735	8.0512451	Candidatus Nitrosotalea sp. FS	2341021	Archaea	Archaea	48.9	0.00141	NR	NHH98042.1	2341021	g23374	i0	30.4	1.01716738197425	79	51	50.9	1	306	70	89	163	NHH98042.1 putative MFS-type transporter [Candidatus Nitrosotalea sp. FS]	diamond	474	48.9	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosotaleales	Nitrosotaleaceae	Nitrosotalea	Candidatus Nitrosotalea sp. FS
32178018	32178018	PRJNA1195374_P_NODE_26418_length_441_cov_1.461957_g26074_i0	PRJNA1195374	26418	441	1.461957	6.44723037	root	1	Root_unresolved	Root_unresolved	67.4	7.19e-10	NR	KON30546.1	1685127	g26074	i0	60.7	0.82312925170068	56	22	38.1	0	439	272	425	480	KON30546.1 MAG: catalase [miscellaneous Crenarchaeota group-15 archaeon DG-45]	diamond	363	67.4	1	Archaea	MCG-15	Thermoproteati	Candidatus Bathyarchaeota					miscellaneous Crenarchaeota group-15 archaeon DG-45

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