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

5 rows where bioproject = "PRJNA816047", 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
26013899	26013899	PRJNA816047d_S_NODE_66980_length_279_cov_2.101770_g65145_i0	PRJNA816047	66980	279	2.10177	5.8639383	Nitrososphaeria archaeon	2268198	Archaea	Archaea	69.7	5.21e-12	NR	MFP3282688.1	2268198	g65145	i0	47.6	0.881720430107527	82	35	88.2	2	10	255	119	192	MFP3282688.1 hypothetical protein [Nitrososphaeria archaeon]	diamond	246	69.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria				Nitrososphaeria archaeon
26588646	26588646	PRJNA816047d_S_NODE_74144_length_268_cov_1.953488_g72309_i0	PRJNA816047	74144	268	1.953488	5.23534784	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	66.6	1.3099999999999999e-10	NR	HLL61392.1	2109671	g72309	i0	49.3	0.75	67	34	75	0	266	66	84	150	HLL61392.1 DAK2 domain-containing protein [Candidatus Nitrosocosmicus sp.]	diamond	201	66.6	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
32921357	32921357	PRJNA816047a_S_NODE_80521_length_241_cov_0.916667_g77861_i0	PRJNA816047	80521	241	0.916667	2.20916747	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	58.2	1.29e-7	NR	HSA72759.1	2169593	g77861	i0	45.8	1.46887966804979	59	32	73.4	0	21	197	433	491	HSA72759.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon]	diamond	354	58.2	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
33110027	33110027	PRJNA816047d_S_NODE_81198_length_262_cov_0.928230_g79363_i0	PRJNA816047	81198	262	0.92823	2.4319626	Nitrososphaera sp.	1971748	Archaea	Archaea	161	1.18e-46	NR	HXG07328.1	1971748	g79363	i0	89.5	0.984732824427481	86	9	98.5	0	260	3	55	140	HXG07328.1 AccI family restriction endonuclease [Nitrososphaera sp.]	diamond	258	161	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
33160643	33160643	PRJNA816047d_S_NODE_14216_length_613_cov_3267.750000_g12583_i0	PRJNA816047	14216	613	3267.75	20031.3075	Nitrososphaera sp.	1971748	Archaea	Archaea	54.7	5.63e-5	NR	HEV8387623.1	1971748	g12583	i0	37.9	0.32300163132137	66	40	32.3	1	261	64	39	103	HEV8387623.1 polysaccharide deacetylase family protein [Nitrososphaera sp.]	diamond	198	54.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.

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