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

5 rows where bioproject = "PRJNA315314" and tax_kingdom = "Nanobdellati"

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
5484310	5484310	PRJNA315314_S_NODE_23045_length_173_cov_14.256944_g22724_i0	PRJNA315314	23045	173	14.256944	24.66451312	Nanoarchaeum equitans	160232	Archaea	Archaea	56.5	0.001	NTclustered	gi\|507148462\|ref\|NR_103265.1\|	228908	g22724	i0	100	0.520231213872832	30	0	17	0	115	144	49	20	Nanoarchaeum equitans Kin4-M 5S ribosomal RNA, complete sequence	blastn	90	56.5	1	Archaea	Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Nanoarchaeales	Nanoarchaeaceae	Nanoarchaeum	Nanoarchaeum equitans
13134699	13134699	PRJNA315314_S_NODE_3771_length_412_cov_4.026110_g3450_i0	PRJNA315314	3771	412	4.02611	16.5875732	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	187	3.05e-56	NR	HII16280.1	2026803	g3450	i0	70.2	8.89805825242718	114	34	83	0	70	411	64	177	HII16280.1 SDR family oxidoreductase [Candidatus Woesearchaeota archaeon]	diamond	3666	187	1	Archaea	Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
27738063	27738063	PRJNA315314_S_NODE_17664_length_196_cov_2.293413_g17343_i0	PRJNA315314	17664	196	2.293413	4.49508948	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	58.2	7.12e-8	NR	MBW2995161.1	2026803	g17343	i0	45.5	1.88265306122449	66	34	98	1	3	194	472	537	MBW2995161.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	369	58.2	1	Archaea	Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
28748092	28748092	PRJNA315314_S_NODE_28127_length_159_cov_2.223077_g27806_i0	PRJNA315314	28127	159	2.223077	3.53469243	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	65.5	8.98e-12	NR	MBI5229261.1	2250274	g27806	i0	58.5	1	53	22	100	0	159	1	57	109	MBI5229261.1 30S ribosomal protein S19e [Candidatus Micrarchaeota archaeon]	diamond	159	65.5	1	Archaea	Nanobdellati	Candidatus Micrarchaeota					Candidatus Micrarchaeota archaeon
31717858	31717858	PRJNA315314_S_NODE_10937_length_245_cov_2.305556_g10616_i0	PRJNA315314	10937	245	2.305556	5.6486122	Candidatus Altarchaeaceae archaeon	3107023	Archaea	Archaea	58.5	1.02e-7	NR	MFN3527883.1	3107023	g10616	i0	40	2.19183673469388	65	39	79.6	0	244	50	540	604	MFN3527883.1 phosphoenolpyruvate carboxykinase (GTP) [Candidatus Altarchaeaceae archaeon]	diamond	537	58.5	1	Archaea	Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeia	Candidatus Altarchaeales	Candidatus Altarchaeaceae		Candidatus Altarchaeaceae 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);;