metadata: contig_metadata: 5 rows where bioproject = "PRJNA876641", tax_clade = "Stenosarchaea group" and tax

5 rows where bioproject = "PRJNA876641", tax_clade = "Stenosarchaea group" and tax_phylum = "Methanobacteriota"

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
12332215	12332215	PRJNA876641_P_NODE_14690_length_256_cov_1.295082_g14616_i0	PRJNA876641	14690	256	1.295082	3.31540992	Halobaculum sp. CBA1158	2904243	Archaea	Archaea	176	1.32e-39	NTclustered	gi\|2176093559\|gb\|CP090371.1\|	2904243	g14616	i0	80.435	8.78125	230	45	90	0	4	233	1585525	1585754	Halobaculum sp. CBA1158 chromosome, complete genome	blastn	2248	176	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum sp. CBA1158
21255234	21255234	PRJNA876641_P_NODE_19357_length_246_cov_1.335260_g19283_i0	PRJNA876641	19357	246	1.33526	3.2847396	Halomarina pelagica	2961599	Archaea	Archaea	67.6	7.94e-7	NTclustered	gi\|2270305250\|gb\|CP100454.1\|	2961599	g19283	i0	95.238	1.04065040650407	42	2	17	0	6	47	1375388	1375429	Halomarina pelagica strain BND7 chromosome, complete genome	blastn	256	67.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Halomarina	Halomarina pelagica
28200082	28200082	PRJNA876641_P_NODE_24106_length_227_cov_2.766234_g24032_i0	PRJNA876641	24106	227	2.766234	6.27935118	root	1	Root_unresolved	Root_unresolved	50.4	5.42e-5	NR	WP_115883272.1	2077203	g24032	i0	35.1	1.784140969163	74	42	92.5	3	7	216	228	299	WP_115883272.1 oxidoreductase [Haloferax sp. Atlit-12N]	diamond	405	50.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax	Haloferax sp. Atlit-12N
29675906	29675906	PRJNA876641_P_NODE_13030_length_265_cov_1.333333_g12956_i0	PRJNA876641	13030	265	1.333333	3.53333245	Methanosarcinales archaeon	2250255	Archaea	Archaea	54.3	4.04e-6	NR	RYE83256.1	2250255	g12956	i0	34.9	0.939622641509434	83	52	91.7	1	244	2	150	232	RYE83256.1 MAG: hypothetical protein EOO65_04255 [Methanosarcinales archaeon]	diamond	249	54.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
31477497	31477497	PRJNA876641_P_NODE_22736_length_242_cov_0.911243_g22662_i0	PRJNA876641	22736	242	0.911243	2.20520806	Candidatus Methanophagales archaeon	2056316	Archaea	Archaea	41.2	0.0209	NR	MCR5853007.1	2056316	g22662	i0	44.7	0.582644628099174	47	20	58.3	1	82	222	18	58	MCR5853007.1 hypothetical protein [Candidatus Methanophagales archaeon]	diamond	141	41.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales			Candidatus Methanophagales 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);;