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

10 rows where analysis = "diamond", bioproject = "PRJNA1078753" 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_genus	tax_species
27257104	27257104	PRJNA1078753_P_NODE_40103_length_243_cov_0.905882_g39907_i0	PRJNA1078753	40103	243	0.905882	2.20129326	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	60.8	1.52e-8	NR	HDI02708.1	3121606	g39907	i0	43.9	5.20987654320988	57	32	70.4	0	241	71	696	752	HDI02708.1 AAA family ATPase [Candidatus Aenigmatarchaeota archaeon]	diamond	1266	60.8	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota		Candidatus Aenigmatarchaeota archaeon
27699619	27699619	PRJNA1078753_P_NODE_12924_length_324_cov_1.557769_g12728_i0	PRJNA1078753	12924	324	1.557769	5.04717156	Candidatus Iainarchaeum archaeon	3101447	Archaea	Archaea	55.8	3.38e-7	NR	MCD6229174.1	2026736	g12728	i0	41.2	2.9537037037037	85	47	77.8	3	69	320	33	115	MCD6229174.1 DUF4430 domain-containing protein [Candidatus Iainarchaeum archaeon]	diamond	957	55.8	1	Archaea	Nanobdellati	Candidatus Iainarchaeota	Candidatus Iainarchaeum	Candidatus Iainarchaeum archaeon
27857063	27857063	PRJNA1078753_P_NODE_13945_length_315_cov_1.272727_g13749_i0	PRJNA1078753	13945	315	1.272727	4.00909005	Candidatus Altiarchaeota archaeon	2599821	Archaea	Archaea	67	2.58e-10	NR	MFH0861630.1	2599821	g13749	i0	40.5	0.8	84	34	76.2	3	314	75	83	154	MFH0861630.1 serpin family protein [Candidatus Altiarchaeota archaeon]	diamond	252	67	1	Archaea	Nanobdellati	Candidatus Altarchaeota		Candidatus Altiarchaeota archaeon
28006723	28006723	PRJNA1078753_P_NODE_14865_length_308_cov_1.042553_g14669_i0	PRJNA1078753	14865	308	1.042553	3.21106324	root	1	Root_unresolved	Root_unresolved	124	1.85e-30	NR	MBW2981830.1	2026803	g14669	i0	56.4	1.95779220779221	101	43	97.4	1	306	7	814	914	MBW2981830.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Woesearchaeota archaeon]	diamond	603	124	1	Archaea	Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
28614997	28614997	PRJNA1078753_P_NODE_18387_length_285_cov_1.452830_g18191_i0	PRJNA1078753	18387	285	1.45283	4.1405655	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	109	4.09e-26	NR	MBI1970550.1	2026803	g18191	i0	50.5	1	95	46	98.9	1	283	2	15	109	MBI1970550.1 NAD(P)-dependent glycerol-3-phosphate dehydrogenase [Candidatus Woesearchaeota archaeon]	diamond	285	109	1	Archaea	Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
28930723	28930723	PRJNA1078753_P_NODE_13288_length_321_cov_1.237903_g13092_i0	PRJNA1078753	13288	321	1.237903	3.97366863	Candidatus Iainarchaeum archaeon	3101447	Archaea	Archaea	44.7	0.0204	NR	MFH1255825.1	2026736	g13092	i0	62.1	0.271028037383178	29	11	27.1	0	2	88	6109	6137	MFH1255825.1 LamG-like jellyroll fold domain-containing protein [Candidatus Iainarchaeum archaeon]	diamond	87	44.7	1	Archaea	Nanobdellati	Candidatus Iainarchaeota	Candidatus Iainarchaeum	Candidatus Iainarchaeum archaeon
29688128	29688128	PRJNA1078753_P_NODE_23010_length_266_cov_1.595855_g22814_i0	PRJNA1078753	23010	266	1.595855	4.2449743	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	44.3	0.013	NR	MCK5177034.1	3121606	g22814	i0	45.1	0.575187969924812	51	24	57.5	1	80	232	52	98	MCK5177034.1 phosphatidylserine decarboxylase [Candidatus Aenigmatarchaeota archaeon]	diamond	153	44.3	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota		Candidatus Aenigmatarchaeota archaeon
29814663	29814663	PRJNA1078753_P_NODE_36811_length_245_cov_0.895349_g36615_i0	PRJNA1078753	36811	245	0.895349	2.19360505	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	90.5	6.02e-19	NR	MBW2981830.1	2026803	g36615	i0	57.7	4.8734693877551	78	31	94.3	2	13	243	807	883	MBW2981830.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Woesearchaeota archaeon]	diamond	1194	90.5	1	Archaea	Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
30762642	30762642	PRJNA1078753_P_NODE_14554_length_310_cov_1.299578_g14358_i0	PRJNA1078753	14554	310	1.299578	4.0286918	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	91.7	2.14e-19	NR	MCD6495763.1	3121606	g14358	i0	45.9	1.64516129032258	85	46	82.3	0	2	256	272	356	MCD6495763.1 polyprenyl synthetase family protein [Candidatus Aenigmatarchaeota archaeon]	diamond	510	91.7	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota		Candidatus Aenigmatarchaeota archaeon
31805852	31805852	PRJNA1078753_P_NODE_42757_length_241_cov_0.916667_g42561_i0	PRJNA1078753	42757	241	0.916667	2.20916747	Nanobdellota archaeon	2026764	Archaea	Archaea	109	1.91e-26	NR	MFH1409828.1	2026764	g42561	i0	63.6	1.95435684647303	77	28	95.9	0	236	6	118	194	MFH1409828.1 glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Nanoarchaeota archaeon]	diamond	471	109	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota 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);;