metadata: contig_metadata: 17 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax

17 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax_superkingdom = "Archaea"

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
10073213	10073213	PRJNA605033_P_NODE_11388_length_412_cov_2.628647_g9857_i0	PRJNA605033	11388	412	2.628647	10.83002564	Thermococcus	2263	Archaea	Archaea	256	1.69e-78	NR	MEO2152736.1	35749	g9857	i0	98.5	17.8252427184466	136	2	99	0	3	410	511	646	MEO2152736.1 DNA polymerase domain-containing protein [Thermococcus sp.]	diamond	7344	256	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp.
19708237	19708237	PRJNA605033_P_NODE_1576_length_1291_cov_2.747611_g758_i0	PRJNA605033	1576	1291	2.747611	35.47165801	Thermococcus	2263	Archaea	Archaea	807	1.87e-276	NR	WP_014121997.1	246969	g758	i0	88	2.16576297443842	466	20	99.9	3	2	1291	1	466	WP_014121997.1 DNA polymerase domain-containing protein [Thermococcus sp. AM4]	diamond	2796	807	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp. AM4
22823179	22823179	PRJNA605033_P_NODE_718_length_2342_cov_8.273082_g151_i0	PRJNA605033	718	2342	8.273082	193.75558044	root	1	Root_unresolved	Root_unresolved	451	4.2599999999999984e-148	NR	MCI0556924.1	1971748	g151	i0	54.6	7.47181895815542	441	192	56	4	325	1635	17	453	MCI0556924.1 IS110 family transposase [Nitrososphaera sp.]	diamond	17499	454	0.993392070484581	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
24809335	24809335	PRJNA605033_P_NODE_64140_length_222_cov_4.679144_g62571_i0	PRJNA605033	64140	222	4.679144	10.38769968	Halovenus aranensis	890420	Archaea	Archaea	67.8	3.8e-11	NR	SDJ86709.1	890420	g62571	i0	46.6	0.986486486486487	73	30	98.6	1	220	2	271	334	SDJ86709.1 Transposase DDE domain-containing protein [Halovenus aranensis]	diamond	219	67.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloarculaceae	Halovenus	Halovenus aranensis
26636772	26636772	PRJNA605033_P_NODE_117241_length_222_cov_1.652406_g115672_i0	PRJNA605033	117241	222	1.652406	3.66834132	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	55.1	1.23e-6	NR	MDW3611325.1	2169593	g115672	i0	100	0.648648648648649	24	0	32.4	0	149	220	282	305	MDW3611325.1 type I glutamate--ammonia ligase [Nitrososphaeraceae archaeon]	diamond	144	55.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
26858905	26858905	PRJNA605033_P_NODE_189821_length_170_cov_2.066667_g188252_i0	PRJNA605033	189821	170	2.066667	3.5133339	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	42	0.00447	NR	MBS3072054.1	2026773	g188252	i0	44.4	0.794117647058823	45	22	79.4	1	150	16	33	74	MBS3072054.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	135	42	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
26935006	26935006	PRJNA605033_P_NODE_153282_length_191_cov_3.147436_g151713_i0	PRJNA605033	153282	191	3.147436	6.01160276	Thermococcus	2263	Archaea	Archaea	133	2.07e-34	NR	WP_167728776.1	163002	g151713	i0	100	4.94764397905759	63	0	99	0	2	190	1761	1823	WP_167728776.1 DNA polymerase domain-containing protein [Thermococcus sp. 9N3]	diamond	945	133	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Thermococcus	Thermococcus sp. 9N3
27396342	27396342	PRJNA605033_P_NODE_77843_length_222_cov_2.604278_g76274_i0	PRJNA605033	77843	222	2.604278	5.78149716	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	50.1	8.79e-6	NR	HEX5977788.1	2169593	g76274	i0	100	0.648648648648649	24	0	32.4	0	220	149	69	92	HEX5977788.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	144	50.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
27869582	27869582	PRJNA605033_P_NODE_158365_length_187_cov_4.151316_g156796_i0	PRJNA605033	158365	187	4.151316	7.76296092	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	63.5	1.83e-11	NR	HZA64091.1	2169593	g156796	i0	82.9	0.561497326203209	35	6	56.1	0	45	149	42	76	HZA64091.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	105	63.5	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
28596069	28596069	PRJNA605033_P_NODE_109247_length_222_cov_1.807487_g107678_i0	PRJNA605033	109247	222	1.807487	4.01262114	Methanospirillum sp.	45200	Archaea	Archaea	50.1	7.37e-5	NR	MBP9009538.1	45200	g107678	i0	41.1	1.97297297297297	73	20	98.6	1	219	1	199	248	MBP9009538.1 DNA cytosine methyltransferase [Methanospirillum sp.]	diamond	438	50.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanospirillaceae	Methanospirillum	Methanospirillum sp.
28924711	28924711	PRJNA605033_P_NODE_141988_length_202_cov_1.802395_g140419_i0	PRJNA605033	141988	202	1.802395	3.6408379	root	1	Root_unresolved	Root_unresolved	94	4.569999999999999e-23	NR	MCI0562201.1	1971748	g140419	i0	84.9	1.57425742574257	53	8	78.7	0	4	162	53	105	MCI0562201.1 fluoride efflux transporter CrcB [Nitrososphaera sp.]	diamond	318	94	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
30079911	30079911	PRJNA605033_P_NODE_72492_length_222_cov_2.919786_g70923_i0	PRJNA605033	72492	222	2.919786	6.48192492	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	47.8	4.65e-4	NR	HLD15491.1	2910166	g70923	i0	91.7	0.324324324324324	24	2	32.4	0	221	150	312	335	HLD15491.1 signal recognition particle-docking protein FtsY [Candidatus Nanoarchaeia archaeon]	diamond	72	47.8	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia				Candidatus Nanoarchaeia archaeon
30585416	30585416	PRJNA605033_P_NODE_180613_length_174_cov_6.985612_g179044_i0	PRJNA605033	180613	174	6.985612	12.15496488	Pyrococcus furiosus	2261	Archaea	Archaea	110	1.47e-26	NR	4AHC_A	2261	g179044	i0	96.5	0.982758620689655	57	2	98.3	0	172	2	131	187	4AHC_A Chain A, DNA POLYMERASE [Pyrococcus furiosus]	diamond	171	110	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus furiosus
30996390	30996390	PRJNA605033_P_NODE_36874_length_261_cov_1.654867_g35307_i0	PRJNA605033	36874	261	1.654867	4.31920287	Candidatus Altiarchaeales archaeon	2250256	Archaea	Archaea	60.8	1.54e-8	NR	MBD3260715.1	2250256	g35307	i0	44.8	0.770114942528736	67	31	77	1	202	2	54	114	MBD3260715.1 IS200/IS605 family element transposase accessory protein TnpB [Candidatus Altiarchaeales archaeon]	diamond	201	60.8	1	Archaea		Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeia	Candidatus Altarchaeales			Candidatus Altiarchaeales archaeon
31547191	31547191	PRJNA605033_P_NODE_26656_length_290_cov_1.635294_g25094_i0	PRJNA605033	26656	290	1.635294	4.7423526	root	1	Root_unresolved	Root_unresolved	55.8	1.61e-6	NR	TRO47018.1	2026714	g25094	i0	55.8	2.23448275862069	43	19	44.5	0	4	132	423	465	TRO47018.1 HAD family hydrolase, partial [Candidatus Bathyarchaeota archaeon]	diamond	648	55.8	1	Archaea		Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
32229986	32229986	PRJNA605033_P_NODE_170558_length_180_cov_1.379310_g168989_i0	PRJNA605033	170558	180	1.37931	2.482758	Halobaculum sp.	1891221	Archaea	Archaea	40	0.0495	NR	MFB6177911.1	1891221	g168989	i0	35.8	0.883333333333333	53	28	78.3	1	177	37	49	101	MFB6177911.1 AAA family ATPase [Halobaculum sp.]	diamond	159	40	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum sp.
32892524	32892524	PRJNA605033_P_NODE_228780_length_155_cov_4.200000_g227211_i0	PRJNA605033	228780	155	4.2	6.51	Nitrosopumilus ureiphilus	1470067	Archaea	Archaea	44.3	0.00321	NR	WP_179372584.1	1470067	g227211	i0	53.6	2.12903225806452	28	13	54.2	0	1	84	439	466	WP_179372584.1 serpin family protein [Nitrosopumilus ureiphilus]	diamond	330	44.3	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus ureiphilus

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