metadata: contig_metadata: 14 rows where bioproject = "PRJNA492363" and tax

14 rows where bioproject = "PRJNA492363" 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
25565491	25565491	PRJNA492363_S_NODE_10033_length_304_cov_1.502058_g9212_i0	PRJNA492363	10033	304	1.502058	4.56625632	archaeon	1906665	Archaea	Archaea	103	1.17e-24	NR	MEI7962107.1	1906665	g9212	i0	98	0.493421052631579	50	1	49.3	0	102	251	1	50	MEI7962107.1 Dam family site-specific DNA-(adenine-N6)-methyltransferase [archaeon]	diamond	150	103	1	Archaea								archaeon
25625233	25625233	PRJNA492363_S_NODE_89513_length_207_cov_1.739726_g88692_i0	PRJNA492363	89513	207	1.739726	3.60123282	root	1	Root_unresolved	Root_unresolved	73.1	1.39e-8	NTclustered	gi\|969874815\|gb\|CP013695.1\|	2285	g88692	i0	100	164.835748792271	39	0	19	0	169	207	1765474	1765512	Sulfolobus acidocaldarius strain NG05B_CO5_07 chromosome	blastn	34121	73.1	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobus	Sulfolobus acidocaldarius
25703389	25703389	PRJNA492363_S_NODE_93538_length_205_cov_0.888889_g92717_i0	PRJNA492363	93538	205	0.888889	1.82222245	root	1	Root_unresolved	Root_unresolved	119	3.98e-33	NR	OLS22052.1	1841597	g92717	i0	80.9	14.8829268292683	68	13	99.5	0	205	2	1	68	OLS22052.1 MAG: hypothetical protein HeimC2_31060 [Candidatus Heimdallarchaeota archaeon LC_2]	diamond	3051	120	0.991666666666667	Archaea		Promethearchaeati	Candidatus Heimdallarchaeota					Candidatus Heimdallarchaeota archaeon LC_2
26169766	26169766	PRJNA492363_S_NODE_94877_length_204_cov_2.111888_g94056_i0	PRJNA492363	94877	204	2.111888	4.30825152	archaeon	1906665	Archaea	Archaea	108	2.67e-26	NR	RYG92473.1	1906665	g94056	i0	83.1	0.867647058823529	59	10	86.8	0	2	178	235	293	RYG92473.1 MAG: hypothetical protein EON65_59145, partial [archaeon]	diamond	177	108	1	Archaea								archaeon
26518887	26518887	PRJNA492363_S_NODE_3024_length_509_cov_19157.062500_g2210_i0	PRJNA492363	3024	509	19157.0625	97509.448125	archaeon	1906665	Archaea	Archaea	254	1.38e-82	NR	MEI7962107.1	1906665	g2210	i0	86.9	4.15520628683694	137	18	80.7	0	508	98	134	270	MEI7962107.1 Dam family site-specific DNA-(adenine-N6)-methyltransferase [archaeon]	diamond	2115	254	1	Archaea								archaeon
26519202	26519202	PRJNA492363_S_NODE_54184_length_231_cov_1.882353_g53363_i0	PRJNA492363	54184	231	1.882353	4.34823543	archaeon	1906665	Archaea	Archaea	99	5.19e-22	NR	NCQ51940.1	1906665	g53363	i0	56.6	1.97402597402597	76	33	98.7	0	2	229	1008	1083	NCQ51940.1 hypothetical protein [archaeon]	diamond	456	99	1	Archaea								archaeon
32935232	32935232	PRJNA492363_S_NODE_26409_length_243_cov_0.967033_g25588_i0	PRJNA492363	26409	243	0.967033	2.34989019	Thermoplasmata archaeon	1906666	Archaea	Archaea	45.1	0.00577	NR	UCE38197.1	1906666	g25588	i0	48.5	0.839506172839506	68	24	76.5	3	236	51	1032	1094	UCE38197.1 MAG: PKD domain-containing protein [Thermoplasmata archaeon]	diamond	204	45.1	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
32969670	32969670	PRJNA492363_S_NODE_4290_length_429_cov_1.391304_g3469_i0	PRJNA492363	4290	429	1.391304	5.96869416	archaeon	1906665	Archaea	Archaea	219	3.8899999999999985e-68	NR	RYG92473.1	1906665	g3469	i0	69.7	0.993006993006993	142	43	99.3	0	428	3	98	239	RYG92473.1 MAG: hypothetical protein EON65_59145, partial [archaeon]	diamond	426	219	1	Archaea								archaeon
32986730	32986730	PRJNA492363_S_NODE_87899_length_208_cov_1.306122_g87078_i0	PRJNA492363	87899	208	1.306122	2.71673376	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	134	2.65e-36	NR	HJY14496.1	2169593	g87078	i0	91.3	0.995192307692308	69	6	99.5	0	1	207	181	249	HJY14496.1 PQQ-binding-like beta-propeller repeat protein [Nitrososphaeraceae archaeon]	diamond	207	134	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32986775	32986775	PRJNA492363_S_NODE_95267_length_204_cov_0.895105_g94446_i0	PRJNA492363	95267	204	0.895105	1.8260142	archaeon	1906665	Archaea	Archaea	90.1	4.38e-19	NR	RYG67916.1	1906665	g94446	i0	60.6	0.970588235294118	66	26	97.1	0	1	198	213	278	RYG67916.1 MAG: MFS transporter [archaeon]	diamond	198	90.1	1	Archaea								archaeon
33020807	33020807	PRJNA492363_S_NODE_99100_length_202_cov_0.907801_g98279_i0	PRJNA492363	99100	202	0.907801	1.83375802	Methanoregula sp.	2052170	Archaea	Archaea	56.6	2.79e-7	NR	WP_372962383.1	2052170	g98279	i0	67.5	0.594059405940594	40	13	59.4	0	133	14	1	40	WP_372962383.1 TonB-dependent receptor domain-containing protein, partial [Methanoregula sp.]	diamond	120	56.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
33037706	33037706	PRJNA492363_S_NODE_20948_length_247_cov_1.827957_g20127_i0	PRJNA492363	20948	247	1.827957	4.51505379	Halobacterium noricense	223182	Archaea	Archaea	78.6	6.07e-15	NR	WP_232590654.1	223182	g20127	i0	47.7	0.789473684210526	65	34	78.9	0	226	32	286	350	WP_232590654.1 lactonase family protein [Halobacterium noricense]	diamond	195	78.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halobacteriaceae	Halobacterium	Halobacterium noricense
33037735	33037735	PRJNA492363_S_NODE_36972_length_238_cov_1.310734_g36151_i0	PRJNA492363	36972	238	1.310734	3.11954692	Nitrosopumilaceae archaeon	2202732	Archaea	Archaea	80.1	3.16e-16	NR	HWY35014.1	2202732	g36151	i0	47.4	1.97899159663866	78	41	98.3	0	1	234	111	188	HWY35014.1 hypothetical protein [Nitrosopumilaceae archaeon]	diamond	471	80.1	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
33054818	33054818	PRJNA492363_S_NODE_74645_length_220_cov_1.610063_g73824_i0	PRJNA492363	74645	220	1.610063	3.5421386	archaeon	1906665	Archaea	Archaea	46.6	0.00121	NR	RYH30569.1	1906665	g73824	i0	82.8	0.395454545454545	29	5	39.5	0	129	215	2064	2092	RYH30569.1 MAG: hypothetical protein EON65_04765 [archaeon]	diamond	87	46.6	1	Archaea								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);;