metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_phylum = "Candidatus Woesearchaeota"

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_species
26741382	26741382	PRJEB11748_P_NODE_357141_length_194_cov_3.315789_g354958_i0	PRJEB11748	357141	194	3.315789	6.43263066	Nanobdellati	1783276	Archaea	Archaea	63.5	8.99e-10	NR	MBS3175368.1	2026803	g354958	i0	76.6	1.48453608247423	47	11	72.7	0	174	34	725	771	MBS3175368.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	288	63.9	0.993740219092332	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
28264557	28264557	PRJEB11748_P_NODE_376546_length_182_cov_6.297521_g374363_i0	PRJEB11748	376546	182	6.297521	11.46148822	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	47	2.53e-4	NR	MBS3152738.1	2026803	g374363	i0	51.4	0.576923076923077	35	17	57.7	0	107	3	78	112	MBS3152738.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	105	47	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
28580493	28580493	PRJEB11748_P_NODE_305987_length_216_cov_19.638710_g303804_i0	PRJEB11748	305987	216	19.63871	42.4196136	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	63.2	1.76e-10	NR	MFA6073969.1	2026803	g303804	i0	44.3	0.972222222222222	70	30	97.2	2	214	5	83	143	MFA6073969.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	210	63.2	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
29054157	29054157	PRJEB11748_P_NODE_314828_length_212_cov_13.576159_g312645_i0	PRJEB11748	314828	212	13.576159	28.78145708	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	78.6	5.67e-15	NR	MEM2138828.1	2026803	g312645	i0	53.5	1.00471698113208	71	32	99.1	1	3	212	412	482	MEM2138828.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	213	78.6	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
30412338	30412338	PRJEB11748_P_NODE_265673_length_237_cov_11.710227_g263490_i0	PRJEB11748	265673	237	11.710227	27.75323799	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	85.9	5e-20	NR	MDO8642207.1	2026803	g263490	i0	67.7	0.784810126582278	62	20	78.5	0	46	231	13	74	MDO8642207.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	186	85.9	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
31201400	31201400	PRJEB11748_P_NODE_132235_length_359_cov_8.651007_g130058_i0	PRJEB11748	132235	359	8.651007	31.05711513	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	84.3	5.22e-18	NR	MBN88194.1	2026803	g130058	i0	47.6	0.701949860724234	84	44	70.2	0	337	86	53	136	MBN88194.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	252	84.3	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
32087674	32087674	PRJEB11748_P_NODE_329578_length_206_cov_7.889655_g327395_i0	PRJEB11748	329578	206	7.889655	16.2526893	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	48.1	2.79e-4	NR	MBD3318704.1	2026803	g327395	i0	47.9	0.699029126213592	48	25	69.9	0	2	145	111	158	MBD3318704.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	144	48.1	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
32404157	32404157	PRJEB11748_P_NODE_323419_length_209_cov_1.594595_g321236_i0	PRJEB11748	323419	209	1.594595	3.33270355	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	50.1	6.14e-5	NR	MBI3027357.1	2026803	g321236	i0	41.7	0.861244019138756	60	35	86.1	0	181	2	96	155	MBI3027357.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	180	50.1	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
32530763	32530763	PRJEB11748_P_NODE_202599_length_281_cov_10.218182_g200416_i0	PRJEB11748	202599	281	10.218182	28.71309142	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	126	3.81e-32	NR	NMB66914.1	2026803	g200416	i0	89.1	0.683274021352313	64	7	68.3	0	90	281	345	408	NMB66914.1 Glu-tRNA(Gln) amidotransferase subunit GatD [Candidatus Woesearchaeota archaeon]	diamond	192	126	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
32845612	32845612	PRJEB11748_P_NODE_278900_length_230_cov_2.769231_g276717_i0	PRJEB11748	278900	230	2.769231	6.3692313	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	83.2	1.78e-16	NR	MBI3034744.1	2026803	g276717	i0	50	1.74782608695652	68	34	88.7	0	11	214	168	235	MBI3034744.1 HAD-IIIC family phosphatase [Candidatus Woesearchaeota archaeon]	diamond	402	83.2	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota 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);;