metadata: contig_metadata: 24 rows where bioproject = "PRJNA493632" and tax

24 rows where bioproject = "PRJNA493632" and tax_phylum = "Candidatus Micrarchaeota"

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
465319	465319	PRJNA493632_P_NODE_51521_length_597_cov_8.654580_g48282_i0	PRJNA493632	51521	597	8.65458	51.6678426	uncultured Candidatus Micrarchaeota archaeon	2220064	Archaea	Archaea	800	0	NTclustered	gi\|2874253680\|emb\|OY969114.1\|	2220064	g48282	i0	90.849	77.3015075376884	601	49	100	6	1	597	523550	522952	MAG: uncultured Candidatus Micrarchaeota archaeon isolate MFD05580.bin.1.37 genome assembly, chromosome: 1	blastn	46149	800	1	Archaea	Nanobdellati	Candidatus Micrarchaeota					uncultured Candidatus Micrarchaeota archaeon
1100456	1100456	PRJNA493632_P_NODE_129641_length_409_cov_1.937500_g126227_i0	PRJNA493632	129641	409	1.9375	7.924375	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	207	1.8199999999999998e-60	NR	MEM3020197.1	2953041	g126227	i0	100	0.770171149144254	105	0	77	0	407	93	554	658	MEM3020197.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon]	diamond	315	207	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
3009222	3009222	PRJNA493632_P_NODE_1263_length_2470_cov_22.917397_g814_i0	PRJNA493632	1263	2470	22.917397	566.0597059	Candidatus Micrarchaeum sp.	2282148	Archaea	Archaea	2863	0	NTclustered	gi\|1972912857\|gb\|CP060530.1\|	2282148	g814	i0	87.701	10.5493927125506	2488	266	100	37	1	2470	972516	974981	Candidatus Micrarchaeum sp. strain A_DKE chromosome, complete genome	blastn	26057	2863	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae	Candidatus Micrarchaeum	Candidatus Micrarchaeum sp.
14491096	14491096	PRJNA493632_P_NODE_358412_length_281_cov_1.480769_g354973_i0	PRJNA493632	358412	281	1.480769	4.16096089	uncultured Candidatus Micrarchaeota archaeon	2220064	Archaea	Archaea	254	6.62e-63	NTclustered	gi\|2874253896\|emb\|OY970071.1\|	2220064	g354973	i0	84.921	5.76868327402135	252	36	89	2	3	253	703032	702782	MAG: uncultured Candidatus Micrarchaeota archaeon isolate MFD01476.bin.c.9 genome assembly, chromosome: 1	blastn	1621	254	1	Archaea	Nanobdellati	Candidatus Micrarchaeota					uncultured Candidatus Micrarchaeota archaeon
14497188	14497188	PRJNA493632_P_NODE_705172_length_225_cov_8.026316_g701731_i0	PRJNA493632	705172	225	8.026316	18.059211	Candidatus Micrarchaeum sp.	2282148	Archaea	Archaea	416	6.159999999999998e-112	NTclustered	gi\|1972912857\|gb\|CP060530.1\|	2282148	g701731	i0	100	1	225	0	100	0	1	225	312218	311994	Candidatus Micrarchaeum sp. strain A_DKE chromosome, complete genome	blastn	225	416	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae	Candidatus Micrarchaeum	Candidatus Micrarchaeum sp.
15761976	15761976	PRJNA493632_P_NODE_189053_length_353_cov_0.996429_g185622_i0	PRJNA493632	189053	353	0.996429	3.51739437	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	249	2.16e-75	NR	MEM3020553.1	2953041	g185622	i0	100	0.994334277620397	117	0	99.4	0	3	353	9	125	MEM3020553.1 DNA-directed RNA polymerase subunit A' [Candidatus Micrarchaeaceae archaeon]	diamond	351	249	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
15766844	15766844	PRJNA493632_P_NODE_4533_length_1596_cov_152.528562_g3448_i0	PRJNA493632	4533	1596	152.528562	2434.35584952	uncultured Candidatus Micrarchaeota archaeon	2220064	Archaea	Archaea	1910	0	NTclustered	gi\|2874253680\|emb\|OY969114.1\|	2220064	g3448	i0	92.144	57.6522556390977	1362	94	85	11	5	1358	524403	523047	MAG: uncultured Candidatus Micrarchaeota archaeon isolate MFD05580.bin.1.37 genome assembly, chromosome: 1	blastn	92013	1910	1	Archaea	Nanobdellati	Candidatus Micrarchaeota					uncultured Candidatus Micrarchaeota archaeon
18320765	18320765	PRJNA493632_P_NODE_815_length_2867_cov_69.663923_g482_i0	PRJNA493632	815	2867	69.663923	1997.26467241	Candidatus Micrarchaeum sp.	2282148	Archaea	Archaea	5158	0	NTclustered	gi\|1972912857\|gb\|CP060530.1\|	2282148	g482	i0	99.716	9.47471224276247	2817	8	98	0	51	2867	972174	974990	Candidatus Micrarchaeum sp. strain A_DKE chromosome, complete genome	blastn	27164	5158	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae	Candidatus Micrarchaeum	Candidatus Micrarchaeum sp.
22137879	22137879	PRJNA493632_P_NODE_305078_length_293_cov_11.195455_g301640_i0	PRJNA493632	305078	293	11.195455	32.80268315	Candidatus Micrarchaeum sp.	2282148	Archaea	Archaea	449	8.25e-122	NTclustered	gi\|1972912857\|gb\|CP060530.1\|	2282148	g301640	i0	99.197	2.47440273037543	249	2	99	0	45	293	180782	180534	Candidatus Micrarchaeum sp. strain A_DKE chromosome, complete genome	blastn	725	449	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae	Candidatus Micrarchaeum	Candidatus Micrarchaeum sp.
24691951	24691951	PRJNA493632_P_NODE_560100_length_247_cov_3.442529_g556661_i0	PRJNA493632	560100	247	3.442529	8.50304663	Candidatus Micrarchaeum sp.	2282148	Archaea	Archaea	287	5.62e-73	NTclustered	gi\|1972912857\|gb\|CP060530.1\|	2282148	g556661	i0	87.649	5.42105263157895	251	25	100	5	1	247	972566	972318	Candidatus Micrarchaeum sp. strain A_DKE chromosome, complete genome	blastn	1339	287	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae	Candidatus Micrarchaeum	Candidatus Micrarchaeum sp.
26601546	26601546	PRJNA493632_P_NODE_527281_length_250_cov_0.870056_g523842_i0	PRJNA493632	527281	250	0.870056	2.17514	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	162	8.59e-45	NR	MEM3020278.1	2953041	g523842	i0	100	0.996	83	0	99.6	0	249	1	56	138	MEM3020278.1 DNA gyrase subunit B [Candidatus Micrarchaeaceae archaeon]	diamond	249	162	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
26949876	26949876	PRJNA493632_P_NODE_305762_length_293_cov_3.336364_g302324_i0	PRJNA493632	305762	293	3.336364	9.77554652	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	158	3.539999999999999e-47	NR	MEM0150127.1	2953041	g302324	i0	90.7	1.98634812286689	97	9	99.3	0	3	293	12	108	MEM0150127.1 EMC3/TMCO1 family protein [Candidatus Micrarchaeaceae archaeon]	diamond	582	158	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
27329543	27329543	PRJNA493632_P_NODE_268483_length_310_cov_1.219409_g265047_i0	PRJNA493632	268483	310	1.219409	3.7801679	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	179	3.7699999999999985e-55	NR	MEM3019988.1	2953041	g265047	i0	100	0.919354838709677	95	0	91.9	0	25	309	1	95	MEM3019988.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon]	diamond	285	179	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
28181835	28181835	PRJNA493632_P_NODE_629926_length_243_cov_0.905882_g626485_i0	PRJNA493632	629926	243	0.905882	2.20129326	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	157	1.76e-44	NR	MEM0149382.1	2953041	g626485	i0	93.8	1.98765432098765	81	5	100	0	1	243	290	370	MEM0149382.1 carbamoyltransferase C-terminal domain-containing protein [Candidatus Micrarchaeaceae archaeon]	diamond	483	157	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
28213238	28213238	PRJNA493632_P_NODE_178326_length_361_cov_1.534722_g174898_i0	PRJNA493632	178326	361	1.534722	5.54034642	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	248	1.53e-77	NR	MEM3020566.1	2953041	g174898	i0	100	0.997229916897507	120	0	99.7	0	360	1	125	244	MEM3020566.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon]	diamond	360	248	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
28339963	28339963	PRJNA493632_P_NODE_609426_length_244_cov_0.900585_g605985_i0	PRJNA493632	609426	244	0.900585	2.1974274	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	127	1.3699999999999998e-35	NR	MEM3020281.1	2953041	g605985	i0	100	0.823770491803279	67	0	82.4	0	242	42	89	155	MEM3020281.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon]	diamond	201	127	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
28371304	28371304	PRJNA493632_P_NODE_118026_length_425_cov_1.360795_g114615_i0	PRJNA493632	118026	425	1.360795	5.78337875	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	265	1.98e-82	NR	MEM3020197.1	2953041	g114615	i0	100	0.995294117647059	141	0	99.5	0	424	2	249	389	MEM3020197.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon]	diamond	423	265	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
29066154	29066154	PRJNA493632_P_NODE_133968_length_404_cov_1.329305_g130551_i0	PRJNA493632	133968	404	1.329305	5.3703922	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	273	3.92e-84	NR	MEM4839344.1	2953041	g130551	i0	99.3	0.995049504950495	134	1	99.5	0	403	2	21	154	MEM4839344.1 Fe-S cluster assembly protein SufB [Candidatus Micrarchaeaceae archaeon]	diamond	402	273	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
29634130	29634130	PRJNA493632_P_NODE_643270_length_242_cov_0.911243_g639829_i0	PRJNA493632	643270	242	0.911243	2.20520806	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	112	1.42e-29	NR	MEM3876389.1	2953041	g639829	i0	100	1.38842975206612	56	0	69.4	0	169	2	1	56	MEM3876389.1 aminotransferase class V-fold PLP-dependent enzyme [Candidatus Micrarchaeaceae archaeon]	diamond	336	112	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
30108133	30108133	PRJNA493632_P_NODE_475412_length_257_cov_1.255435_g471973_i0	PRJNA493632	475412	257	1.255435	3.22646795	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	171	4.23e-50	NR	MEM4839909.1	2953041	g471973	i0	97.6	0.992217898832685	85	2	99.2	0	1	255	39	123	MEM4839909.1 transcription initiation factor IIB [Candidatus Micrarchaeaceae archaeon]	diamond	255	171	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
30329792	30329792	PRJNA493632_P_NODE_192752_length_350_cov_1.462094_g189320_i0	PRJNA493632	192752	350	1.462094	5.117329	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	186	4.04e-53	NR	MEM3020197.1	2953041	g189320	i0	100	0.994285714285714	116	0	99.4	0	350	3	405	520	MEM3020197.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon]	diamond	348	186	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
30803205	30803205	PRJNA493632_P_NODE_275294_length_307_cov_1.564103_g271858_i0	PRJNA493632	275294	307	1.564103	4.80179621	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	174	6.4700000000000004e-49	NR	MEM3020197.1	2953041	g271858	i0	95.1	0.996742671009772	102	5	99.7	0	306	1	34	135	MEM3020197.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon]	diamond	306	174	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
31593893	31593893	PRJNA493632_P_NODE_658116_length_241_cov_0.916667_g654675_i0	PRJNA493632	658116	241	0.916667	2.20916747	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	156	6.59e-44	NR	MEM3876386.1	2953041	g654675	i0	100	0.983402489626556	79	0	98.3	0	3	239	319	397	MEM3876386.1 SufD family Fe-S cluster assembly protein [Candidatus Micrarchaeaceae archaeon]	diamond	237	156	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
32826376	32826376	PRJNA493632_P_NODE_652540_length_241_cov_1.375000_g649099_i0	PRJNA493632	652540	241	1.375	3.31375	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	154	3.3299999999999996e-45	NR	MEM3985098.1	2953041	g649099	i0	100	0.95850622406639	77	0	95.9	0	10	240	1	77	MEM3985098.1 endonuclease III domain-containing protein [Candidatus Micrarchaeaceae archaeon]	diamond	231	154	1	Archaea	Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae 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);;