metadata: contig_metadata: 10 rows where bioproject = "PRJNA438111" and tax

10 rows where bioproject = "PRJNA438111" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_species
1708921	1708921	PRJNA438111_P_NODE_3162_length_548_cov_2.152216_g2673_i0	PRJNA438111	3162	548	2.152216	11.79414368	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	261	5.61e-81	NR	MBD3210254.1	2250274	g2673	i0	64.8	3.98540145985401	182	64	99.6	0	1	546	240	421	MBD3210254.1 ATP citrate synthase [Candidatus Micrarchaeota archaeon]	diamond	2184	261	1	Archaea		Nanobdellati	Candidatus Micrarchaeota			Candidatus Micrarchaeota archaeon
2984550	2984550	PRJNA438111_P_NODE_23543_length_223_cov_2.927835_g22918_i0	PRJNA438111	23543	223	2.927835	6.52907205	Archaea	2157	Archaea	Archaea	121	2.75e-31	NR	MBW3020274.1	2026803	g22918	i0	81.1	2.98654708520179	74	14	99.6	0	223	2	114	187	MBW3020274.1 tyrosine--tRNA ligase [Candidatus Woesearchaeota archaeon]	diamond	666	122	0.991803278688525	Archaea		Nanobdellati	Candidatus Woesearchaeota			Candidatus Woesearchaeota archaeon
24660963	24660963	PRJNA438111_P_NODE_79520_length_158_cov_3.193798_g78895_i0	PRJNA438111	79520	158	3.193798	5.04620084	Nanobdellota archaeon	2026764	Archaea	Archaea	56.5	0.001	NTclustered	gi\|2759011699\|dbj\|AP031373.1\|	2026764	g78895	i0	96.97	0.208860759493671	33	1	21	0	120	152	538683	538715	Nanoarchaeota archaeon YN1 DNA, complete genome	blastn	33	56.5	1	Archaea		Nanobdellati	Nanobdellota			Nanobdellota archaeon
27297242	27297242	PRJNA438111_P_NODE_89523_length_151_cov_2.262295_g88898_i0	PRJNA438111	89523	151	2.262295	3.41606545	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	43.5	0.00468	NR	MEM4710823.1	2026803	g88898	i0	51.1	1.88741721854305	47	18	85.4	2	6	134	75	120	MEM4710823.1 class I SAM-dependent methyltransferase [Candidatus Woesearchaeota archaeon]	diamond	285	43.5	1	Archaea		Nanobdellati	Candidatus Woesearchaeota			Candidatus Woesearchaeota archaeon
29823020	29823020	PRJNA438111_P_NODE_82111_length_156_cov_3.322835_g81486_i0	PRJNA438111	82111	156	3.322835	5.1836226	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	62.8	9.38e-10	NR	HID73323.1	2250274	g81486	i0	69.2	3.94230769230769	52	13	98.1	2	2	154	320	369	HID73323.1 ATPase [Candidatus Micrarchaeota archaeon]	diamond	615	62.8	1	Archaea		Nanobdellati	Candidatus Micrarchaeota			Candidatus Micrarchaeota archaeon
30029224	30029224	PRJNA438111_P_NODE_70391_length_164_cov_3.007407_g69766_i0	PRJNA438111	70391	164	3.007407	4.93214748	root	1	Root_unresolved	Root_unresolved	74.7	4.22e-14	NR	ODS38793.1	1849364	g69766	i0	75.9	4.92073170731707	54	13	98.8	0	3	164	191	244	ODS38793.1 MAG: hypothetical protein A7316_07045 [Candidatus Altiarchaeales archaeon WOR_SM1_86-2]	diamond	807	75.1	0.994673768308922	Archaea		Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeia	Candidatus Altarchaeales	Candidatus Altiarchaeales archaeon WOR_SM1_86-2
30629239	30629239	PRJNA438111_P_NODE_88413_length_151_cov_6.811475_g87788_i0	PRJNA438111	88413	151	6.811475	10.28532725	root	1	Root_unresolved	Root_unresolved	78.2	1.86e-15	NR	MBT4539725.1	2026803	g87788	i0	69.4	6.79470198675497	49	15	97.4	0	3	149	44	92	MBT4539725.1 D-glycerate dehydrogenase [Candidatus Woesearchaeota archaeon]	diamond	1026	78.2	1	Archaea		Nanobdellati	Candidatus Woesearchaeota			Candidatus Woesearchaeota archaeon
31561464	31561464	PRJNA438111_P_NODE_15076_length_270_cov_3.647303_g14451_i0	PRJNA438111	15076	270	3.647303	9.8477181	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	110	1.3600000000000002e-26	NR	MBD3204677.1	2026803	g14451	i0	58.9	1	90	36	100	1	270	1	138	226	MBD3204677.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Candidatus Woesearchaeota archaeon]	diamond	270	110	1	Archaea		Nanobdellati	Candidatus Woesearchaeota			Candidatus Woesearchaeota archaeon
32668026	32668026	PRJNA438111_P_NODE_3440_length_528_cov_3.224449_g2933_i0	PRJNA438111	3440	528	3.224449	17.02509072	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	221	4.8199999999999985e-68	NR	MBI1970550.1	2026803	g2933	i0	62.9	0.994318181818182	175	65	99.4	0	527	3	175	349	MBI1970550.1 NAD(P)-dependent glycerol-3-phosphate dehydrogenase [Candidatus Woesearchaeota archaeon]	diamond	525	221	1	Archaea		Nanobdellati	Candidatus Woesearchaeota			Candidatus Woesearchaeota archaeon
32668074	32668074	PRJNA438111_P_NODE_88500_length_151_cov_5.614754_g87875_i0	PRJNA438111	88500	151	5.614754	8.47827854	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	50.4	1.6e-5	NR	MCK5606787.1	2026773	g87875	i0	40.8	0.973509933774834	49	29	97.4	0	151	5	97	145	MCK5606787.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	147	50.4	1	Archaea	Candidatus Pacearchaeota	Nanobdellati				Candidatus Pacearchaeota 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);;