metadata: contig_metadata: 24 rows where analysis = "diamond", bioproject = "PRJNA438111" and tax

24 rows where analysis = "diamond", bioproject = "PRJNA438111" and tax_clade = "Stenosarchaea group"

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_family	tax_genus	tax_species
14463344	14463344	PRJNA438111_P_NODE_76312_length_160_cov_6.282443_g75687_i0	PRJNA438111	76312	160	6.282443	10.0519088	Halopenitus sp.	1979403	Archaea	Archaea	100	2.4899999999999998e-23	NR	MFB6236188.1	1979403	g75687	i0	98.1	0.975	52	1	97.5	0	158	3	122	173	MFB6236188.1 MATE family efflux transporter [Halopenitus sp.]	diamond	156	100	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halopenitus	Halopenitus sp.
18285499	18285499	PRJNA438111_P_NODE_18715_length_246_cov_5.525346_g18090_i0	PRJNA438111	18715	246	5.525346	13.59235116	Methanothrix	2222	Archaea	Archaea	122	8.58e-31	NR	HNX39946.1	90426	g18090	i0	71.3	11.7682926829268	80	23	97.6	0	243	4	236	315	HNX39946.1 ATP citrate lyase citrate-binding domain-containing protein [Methanothrix sp.]	diamond	2895	123	0.991869918699187	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
24660620	24660620	PRJNA438111_P_NODE_54880_length_176_cov_4.734694_g54255_i0	PRJNA438111	54880	176	4.734694	8.33306144	Halobacteriales	2235	Archaea	Archaea	112	6.06e-27	NR	WP_018258693.1	437163	g54255	i0	87.9	7.90909090909091	58	7	98.9	0	1	174	351	408	WP_018258693.1 PD-(D/E)XK nuclease family protein [Halomicrobium katesii]	diamond	1392	112	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halomicrobium	Halomicrobium katesii
26822963	26822963	PRJNA438111_P_NODE_87701_length_152_cov_3.227642_g87076_i0	PRJNA438111	87701	152	3.227642	4.90601584	Salinarchaeum sp. Harcht-Bsk1	1333523	Archaea	Archaea	47.4	2.45e-4	NR	WP_020445251.1	1333523	g87076	i0	73.1	0.513157894736842	26	7	51.3	0	79	2	1	26	WP_020445251.1 hypothetical protein [Salinarchaeum sp. Harcht-Bsk1]	diamond	78	47.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronoarchaeaceae	Salinarchaeum	Salinarchaeum sp. Harcht-Bsk1
27107365	27107365	PRJNA438111_P_NODE_48202_length_183_cov_6.201299_g47577_i0	PRJNA438111	48202	183	6.201299	11.34837717	Natrialbaceae archaeon	2093806	Archaea	Archaea	45.4	0.00184	NR	MDZ7730426.1	2093806	g47577	i0	43.1	0.836065573770492	51	29	83.6	0	9	161	280	330	MDZ7730426.1 carboxypeptidase-like regulatory domain-containing protein [Natrialbaceae archaeon]	diamond	153	45.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae		Natrialbaceae archaeon
27138772	27138772	PRJNA438111_P_NODE_59902_length_171_cov_4.528169_g59277_i0	PRJNA438111	59902	171	4.528169	7.74316899	Halopenitus sp.	1979403	Archaea	Archaea	52	6.99e-6	NR	MFB6235460.1	1979403	g59277	i0	92.6	0.473684210526316	27	2	47.4	0	83	3	1	27	MFB6235460.1 transcription initiation factor IIB family protein [Halopenitus sp.]	diamond	81	52	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halopenitus	Halopenitus sp.
28134720	28134720	PRJNA438111_P_NODE_55865_length_175_cov_4.582192_g55240_i0	PRJNA438111	55865	175	4.582192	8.018836	Candidatus Methanoperedens	1392997	Archaea	Archaea	83.2	8.47e-17	NR	WP_096204006.1	1392998	g55240	i0	69	1.98857142857143	58	18	99.4	0	1	174	1413	1470	WP_096204006.1 neuraminidase-like domain-containing protein [Candidatus Methanoperedens nitroreducens]	diamond	348	83.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens nitratireducens
28244371	28244371	PRJNA438111_P_NODE_83406_length_155_cov_3.380952_g82781_i0	PRJNA438111	83406	155	3.380952	5.2404756	Natronomonas sp. LN261	2750669	Archaea	Archaea	57	1.01e-7	NR	WP_181691083.1	2750669	g82781	i0	96.3	0.52258064516129	27	1	52.3	0	2	82	332	358	WP_181691083.1 DHH family phosphoesterase [Natronomonas sp. LN261]	diamond	81	57	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Natronomonas	Natronomonas sp. LN261
28655039	28655039	PRJNA438111_P_NODE_66227_length_167_cov_1.978261_g65602_i0	PRJNA438111	66227	167	1.978261	3.30369587	Halobacteriaceae archaeon GCM10025711	3252693	Archaea	Archaea	81.3	6.92e-17	NR	MFC7045968.1	3252693	g65602	i0	60	0.988023952095808	55	22	98.8	0	3	167	113	167	MFC7045968.1 NAD-dependent protein deacylase [Halobacteriaceae archaeon GCM10025711]	diamond	165	81.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae		Halobacteriaceae archaeon GCM10025711
29160445	29160445	PRJNA438111_P_NODE_81209_length_157_cov_2.164062_g80584_i0	PRJNA438111	81209	157	2.164062	3.39757734	Methanosarcina sp.	2213	Archaea	Archaea	95.9	7.750000000000001e-22	NR	HET8687065.1	2213	g80584	i0	78.4	0.974522292993631	51	11	97.5	0	155	3	58	108	HET8687065.1 hypothetical protein [Methanosarcina sp.]	diamond	153	95.9	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
29949612	29949612	PRJNA438111_P_NODE_42411_length_191_cov_1.037037_g41786_i0	PRJNA438111	42411	191	1.037037	1.98074067	Natrinema gelatinilyticum	2961571	Archaea	Archaea	70.1	8.6e-13	NR	WP_256566890.1	2961571	g41786	i0	45.9	0.958115183246073	61	33	95.8	0	185	3	140	200	WP_256566890.1 DUF6338 family protein [Natrinema gelatinilyticum]	diamond	183	70.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema gelatinilyticum
29965998	29965998	PRJNA438111_P_NODE_4371_length_472_cov_5.203160_g3827_i0	PRJNA438111	4371	472	5.20316	24.5589152	Methanothrix	2222	Archaea	Archaea	108	4.67e-24	NR	MCX6674432.1	90426	g3827	i0	42.9	2.13559322033898	168	80	98.5	6	6	470	344	508	MCX6674432.1 S8 family serine peptidase [Methanothrix sp.]	diamond	1008	108	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
30233908	30233908	PRJNA438111_P_NODE_35572_length_203_cov_3.844828_g34947_i0	PRJNA438111	35572	203	3.844828	7.80500084	Methanothrix sp.	90426	Archaea	Archaea	65.5	2.1e-10	NR	MDH7597823.1	90426	g34947	i0	62.8	0.635467980295567	43	16	63.5	0	203	75	47	89	MDH7597823.1 SWIM zinc finger family protein [Methanothrix sp.]	diamond	129	65.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
30960677	30960677	PRJNA438111_P_NODE_11394_length_305_cov_1.615942_g10769_i0	PRJNA438111	11394	305	1.615942	4.9286231	Haloarchaeobius sp. FL176	2967129	Archaea	Archaea	62.8	7.02e-9	NR	WP_257300978.1	2967129	g10769	i0	40.8	1.97704918032787	103	56	96.4	2	299	6	537	639	WP_257300978.1 AMP-dependent synthetase/ligase [Haloarchaeobius sp. FL176]	diamond	603	62.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halorubellaceae	Haloarchaeobius	Haloarchaeobius sp. FL176
31118362	31118362	PRJNA438111_P_NODE_60015_length_171_cov_3.802817_g59390_i0	PRJNA438111	60015	171	3.802817	6.50281707	Halopenitus sp.	1979403	Archaea	Archaea	77.8	5.89e-15	NR	MFB6234634.1	1979403	g59390	i0	97.5	0.701754385964912	40	1	70.2	0	52	171	1	40	MFB6234634.1 AI-2E family transporter [Halopenitus sp.]	diamond	120	77.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halopenitus	Halopenitus sp.
31181459	31181459	PRJNA438111_P_NODE_19515_length_242_cov_4.234742_g18890_i0	PRJNA438111	19515	242	4.234742	10.24807564	Halovenus rubra	869890	Archaea	Archaea	155	1.19e-41	NR	WP_267637264.1	869890	g18890	i0	98.8	0.991735537190083	80	1	99.2	0	2	241	594	673	WP_267637264.1 class I SAM-dependent DNA methyltransferase [Halovenus rubra]	diamond	240	155	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halovenus	Halovenus rubra
31845896	31845896	PRJNA438111_P_NODE_78957_length_158_cov_5.674419_g78332_i0	PRJNA438111	78957	158	5.674419	8.96558202	Halopenitus sp.	1979403	Archaea	Archaea	71.6	4.32e-13	NR	MFB6235697.1	1979403	g78332	i0	96.8	0.588607594936709	31	1	58.9	0	3	95	267	297	MFB6235697.1 sulfite exporter TauE/SafE family protein [Halopenitus sp.]	diamond	93	71.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halopenitus	Halopenitus sp.
31877433	31877433	PRJNA438111_P_NODE_37737_length_197_cov_5.428571_g37112_i0	PRJNA438111	37737	197	5.428571	10.69428487	Methanomicrobia archaeon	2268195	Archaea	Archaea	81.6	3.42e-16	NR	HDS45311.1	2268195	g37112	i0	64.6	0.989847715736041	65	23	99	0	195	1	247	311	HDS45311.1 hypothetical protein [Methanomicrobia archaeon]	diamond	195	81.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia				Methanomicrobia archaeon
31940684	31940684	PRJNA438111_P_NODE_13717_length_281_cov_4.285714_g13092_i0	PRJNA438111	13717	281	4.285714	12.04285634	Candidatus Methanophagales archaeon	2056316	Archaea	Archaea	59.3	1.44e-8	NR	MCR5853184.1	2056316	g13092	i0	68.6	0.373665480427046	35	11	37.4	0	271	167	7	41	MCR5853184.1 tetratricopeptide repeat protein [Candidatus Methanophagales archaeon]	diamond	105	59.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales			Candidatus Methanophagales archaeon
31940724	31940724	PRJNA438111_P_NODE_59177_length_172_cov_2.902098_g58552_i0	PRJNA438111	59177	172	2.902098	4.99160856	Methanocellales archaeon	2666334	Archaea	Archaea	55.8	2.74e-7	NR	MDI6903002.1	2666334	g58552	i0	54.5	0.767441860465116	44	19	76.7	1	1	132	8	50	MDI6903002.1 hypothetical protein [Methanocellales archaeon]	diamond	132	55.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanocellales			Methanocellales archaeon
32067328	32067328	PRJNA438111_P_NODE_39138_length_195_cov_5.831325_g38513_i0	PRJNA438111	39138	195	5.831325	11.37108375	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	72.8	4.64e-13	NR	MCX9075357.1	2032688	g38513	i0	60	2.01538461538462	65	24	96.9	1	193	5	27	91	MCX9075357.1 caspase family protein [Candidatus Methanoperedens sp.]	diamond	393	72.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
32289292	32289292	PRJNA438111_P_NODE_10239_length_320_cov_1.694158_g9618_i0	PRJNA438111	10239	320	1.694158	5.4213056	Candidatus Methanophagales archaeon	2056316	Archaea	Archaea	61.2	4.05e-9	NR	MCR5853184.1	2056316	g9618	i0	71.4	0.328125	35	10	32.8	0	26	130	7	41	MCR5853184.1 tetratricopeptide repeat protein [Candidatus Methanophagales archaeon]	diamond	105	61.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales			Candidatus Methanophagales archaeon
32762555	32762555	PRJNA438111_P_NODE_49120_length_182_cov_5.281046_g48495_i0	PRJNA438111	49120	182	5.281046	9.61150372	Methanosarcinales archaeon	2250255	Archaea	Archaea	51.2	5.93e-6	NR	RZN37674.1	2250255	g48495	i0	49.1	1.68131868131868	55	28	90.7	0	168	4	47	101	RZN37674.1 MAG: hypothetical protein EF813_05580 [Methanosarcinales archaeon]	diamond	306	51.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
32793849	32793849	PRJNA438111_P_NODE_74720_length_161_cov_4.946970_g74095_i0	PRJNA438111	74720	161	4.94697	7.9646217	Methanosarcina sp. MTP4	1434100	Archaea	Archaea	50.1	3.16e-5	NR	WP_369799630.1	1434100	g74095	i0	53.7	0.763975155279503	41	19	76.4	0	6	128	12	52	WP_369799630.1 tetratricopeptide repeat protein [Methanosarcina sp. MTP4]	diamond	123	50.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp. MTP4

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);;