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

5 rows where bioproject = "PRJNA1031674" 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
8660031	8660031	PRJNA1031674_P_NODE_27167_length_242_cov_1.473373_g26956_i0	PRJNA1031674	27167	242	1.473373	3.56556266	Archaea	2157	Archaea	Archaea	276	1.19e-69	NTclustered	gi\|42557759\|emb\|AJ627422.1\|	29281	g26956	i0	87.19	17.5247933884298	242	31	100	0	1	242	40881	41122	Uncultured crenarchaeote genomic fragment 54d9	blastn	4241	276	1	Archaea	Thermoproteati	Thermoproteota					uncultured crenarchaeote
11645437	11645437	PRJNA1031674_P_NODE_5710_length_358_cov_2.722807_g5500_i0	PRJNA1031674	5710	358	2.722807	9.74764906	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	656	0	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g5500	i0	99.721	18.8687150837989	358	1	100	0	1	358	849227	849584	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	6755	656	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
12920590	12920590	PRJNA1031674_P_NODE_6211_length_348_cov_1.076364_g6000_i0	PRJNA1031674	6211	348	1.076364	3.74574672	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	551	2.669999999999999e-152	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g6000	i0	95.402	43.7931034482759	348	13	100	2	1	348	848437	848093	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	15240	551	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
29056373	29056373	PRJNA1031674_P_NODE_9388_length_301_cov_1.986842_g9177_i0	PRJNA1031674	9388	301	1.986842	5.98039442	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	130	4.13e-36	NR	HUO61987.1	3045160	g9177	i0	71.4	0.976744186046512	98	28	97.7	0	1	294	7	104	HUO61987.1 hypothetical protein [Candidatus Bathyarchaeia archaeon]	diamond	294	130	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
30351620	30351620	PRJNA1031674_P_NODE_17772_length_267_cov_2.221649_g17561_i0	PRJNA1031674	17772	267	2.221649	5.93180283	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	50.1	5.16e-6	NR	HKQ22232.1	2169593	g17561	i0	60.5	0.426966292134831	38	15	42.7	0	93	206	7	44	HKQ22232.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	114	50.1	1	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);;