metadata: contig_metadata: 5 rows where bioproject = "PRJNA1160211", tax_phylum = "Nitrososphaerota" and tax

5 rows where bioproject = "PRJNA1160211", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

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
3589591	3589591	PRJNA1160211_S_NODE_94923_length_467_cov_5.588832_g93698_i0	PRJNA1160211	94923	467	5.588832	26.09984544	Nitrososphaera	497726	Archaea	Archaea	604	2.779999999999999e-168	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g93698	i0	90.15	54.5139186295503	467	42	99	4	3	466	566	101	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	25458	604	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
13064320	13064320	PRJNA1160211_S_NODE_74611_length_510_cov_60.075515_g73397_i0	PRJNA1160211	74611	510	60.075515	306.3851265	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	833	0	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g73397	i0	98.723	29.1274509803922	470	5	92	1	25	493	1790015	1790484	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	14855	833	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
27830093	27830093	PRJNA1160211_S_NODE_255444_length_257_cov_3.489130_g254211_i0	PRJNA1160211	255444	257	3.48913	8.9670641	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	92.8	6.49e-20	NR	HET9805429.1	2169593	g254211	i0	91.7	1.68093385214008	48	4	56	0	22	165	293	340	HET9805429.1 enolase [Nitrososphaeraceae archaeon]	diamond	432	92.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
29282359	29282359	PRJNA1160211_S_NODE_7209_length_874_cov_15.579276_g6547_i0	PRJNA1160211	7209	874	15.579276	136.16287224	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	133	1.7599999999999998e-31	NR	HYP42518.1	2109671	g6547	i0	60.5	0.391304347826087	114	45	39.1	0	532	191	56	169	HYP42518.1 hypothetical protein [Candidatus Nitrosocosmicus sp.]	diamond	342	133	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
32051217	32051217	PRJNA1160211_S_NODE_32678_length_639_cov_11.192580_g31569_i0	PRJNA1160211	32678	639	11.19258	71.5205862	root	1	Root_unresolved	Root_unresolved	152	5.51e-41	NR	MCD6036617.1	2169593	g31569	i0	45.5	3.51643192488263	187	92	87.8	5	12	572	162	338	MCD6036617.1 yhdN 2 [Nitrososphaeraceae archaeon]	diamond	2247	153	0.993464052287582	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);;