metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA814235" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA814235" 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
27275743	27275743	PRJNA814235_P_NODE_24903_length_383_cov_2.644509_g23533_i0	PRJNA814235	24903	383	2.644509	10.12846947	Nitrososphaera sp.	1971748	Archaea	Archaea	79.3	2.47e-14	NR	MCI0556924.1	1971748	g23533	i0	66.7	1.32375979112272	57	19	44.6	0	212	382	319	375	MCI0556924.1 IS110 family transposase [Nitrososphaera sp.]	diamond	507	79.3	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
30591436	30591436	PRJNA814235_P_NODE_101493_length_203_cov_2.379518_g100098_i0	PRJNA814235	101493	203	2.379518	4.83042154	Candidatus Nitrosocosmicus franklandus	1826864	Archaea	Archaea	74.7	3.53e-14	NR	WP_134483916.1	1798806	g100098	i0	60.5	1.12315270935961	76	21	99	1	1	201	69	144	WP_134483916.1 nicotinate phosphoribosyltransferase [Candidatus Nitrosocosmicus franklandus]	diamond	228	74.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus franklandianus
30812610	30812610	PRJNA814235_P_NODE_124574_length_201_cov_2.634146_g123179_i0	PRJNA814235	124574	201	2.634146	5.29463346	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	48.5	1.95e-4	NR	MCW4009962.1	2026714	g123179	i0	84	0.373134328358209	25	4	37.3	0	75	1	266	290	MCW4009962.1 M42 family metallopeptidase [Candidatus Bathyarchaeota archaeon]	diamond	75	48.5	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
31413254	31413254	PRJNA814235_P_NODE_199816_length_150_cov_3.053097_g198421_i0	PRJNA814235	199816	150	3.053097	4.5796455	Pyrobaculum aerophilum	13773	Archaea	Archaea	88.2	1.03e-18	NR	WP_116430384.1	13773	g198421	i0	74.2	3.96	66	1	100	1	150	1	482	547	WP_116430384.1 hypothetical protein [Pyrobaculum aerophilum]	diamond	594	88.2	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Pyrobaculum	Pyrobaculum aerophilum
31476614	31476614	PRJNA814235_P_NODE_116256_length_203_cov_1.903614_g114861_i0	PRJNA814235	116256	203	1.903614	3.86433642	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	43.5	0.0102	NR	MFB3887936.1	3045160	g114861	i0	75	0.354679802955665	24	6	35.5	0	131	202	199	222	MFB3887936.1 anaerobic ribonucleoside-triphosphate reductase activating protein [Candidatus Bathyarchaeia archaeon]	diamond	72	43.5	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia 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);;