metadata: contig_metadata: 11 rows where bioproject = "PRJNA770826" and tax

11 rows where bioproject = "PRJNA770826" and tax_kingdom = "Thermoproteati"

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
18598721	18598721	PRJNA770826_P_NODE_5635_length_355_cov_2.601307_g5464_i0	PRJNA770826	5635	355	2.601307	9.23463985	Thermoproteota archaeon	2056631	Archaea	Archaea	168	1.21e-45	NR	MFC1755240.1	2056631	g5464	i0	66.1	2.99154929577465	118	40	99.7	0	355	2	475	592	MFC1755240.1 pyruvate, phosphate dikinase [Thermoproteota archaeon]	diamond	1062	168	1	Archaea	Thermoproteati	Thermoproteota					Thermoproteota archaeon
27084938	27084938	PRJNA770826_P_NODE_35402_length_165_cov_0.896552_g35231_i0	PRJNA770826	35402	165	0.896552	1.4793108	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	41.2	0.0255	NR	MEM1566586.1	3045160	g35231	i0	36.4	1.6	44	28	80	0	32	163	28	71	MEM1566586.1 thioredoxin [Candidatus Bathyarchaeia archaeon]	diamond	264	41.2	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
27211107	27211107	PRJNA770826_P_NODE_27682_length_168_cov_0.873950_g27511_i0	PRJNA770826	27682	168	0.87395	1.468236	Nitrososphaerota archaeon	2026795	Archaea	Archaea	44.3	0.00271	NR	MDE1862708.1	2026795	g27511	i0	42	1.85714285714286	50	29	89.3	0	166	17	94	143	MDE1862708.1 DUF2589 domain-containing protein [Nitrososphaerota archaeon]	diamond	312	44.3	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
27622077	27622077	PRJNA770826_P_NODE_13884_length_216_cov_1.245509_g13713_i0	PRJNA770826	13884	216	1.245509	2.69029944	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	73.9	1.31e-14	NR	RLI24483.1	2026714	g13713	i0	47.1	1.875	68	36	94.4	0	5	208	48	115	RLI24483.1 MAG: 30S ribosomal protein S19e [Candidatus Bathyarchaeota archaeon]	diamond	405	73.9	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
28032529	28032529	PRJNA770826_P_NODE_10905_length_244_cov_1.333333_g10734_i0	PRJNA770826	10905	244	1.333333	3.25333252	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	82.8	1.54e-17	NR	HYA81894.1	3045160	g10734	i0	55.6	3.59016393442623	72	32	88.5	0	239	24	114	185	HYA81894.1 NAD(P)H-dependent oxidoreductase [Candidatus Bathyarchaeia archaeon]	diamond	876	82.8	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
28063927	28063927	PRJNA770826_P_NODE_16005_length_202_cov_1.359477_g15834_i0	PRJNA770826	16005	202	1.359477	2.74614354	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	96.3	1.3700000000000002e-21	NR	MEM2104181.1	3045160	g15834	i0	65.2	5.86633663366337	66	23	98	0	199	2	315	380	MEM2104181.1 pyridoxal phosphate-dependent aminotransferase [Candidatus Bathyarchaeia archaeon]	diamond	1185	96.3	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
28474514	28474514	PRJNA770826_P_NODE_43366_length_162_cov_0.920354_g43195_i0	PRJNA770826	43366	162	0.920354	1.49097348	Nitrosopumilaceae archaeon	2202732	Archaea	Archaea	42	0.0243	NR	HSF28567.1	2202732	g43195	i0	34	0.925925925925926	50	33	92.6	0	10	159	619	668	HSF28567.1 M1 family metallopeptidase [Nitrosopumilaceae archaeon]	diamond	150	42	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
29368165	29368165	PRJNA770826_P_NODE_16589_length_199_cov_0.966667_g16418_i0	PRJNA770826	16589	199	0.966667	1.92366733	root	1	Root_unresolved	Root_unresolved	43.5	0.00383	NR	MBD3172705.1	2026714	g16418	i0	35	2.71356783919598	60	38	90.5	1	183	4	1	59	MBD3172705.1 thioredoxin [Candidatus Bathyarchaeota archaeon]	diamond	540	43.9	0.990888382687927	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
30306516	30306516	PRJNA770826_P_NODE_28372_length_167_cov_0.881356_g28201_i0	PRJNA770826	28372	167	0.881356	1.47186452	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	74.7	3.51e-14	NR	HEX7142370.1	2169593	g28201	i0	66.7	3.88023952095808	54	18	97	0	5	166	105	158	HEX7142370.1 SDR family oxidoreductase [Nitrososphaeraceae archaeon]	diamond	648	74.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
30464438	30464438	PRJNA770826_P_NODE_38493_length_164_cov_0.904348_g38322_i0	PRJNA770826	38493	164	0.904348	1.48313072	Candidatus Bathyarchaeia archaeon	3045160	Archaea	Archaea	65.5	8.21e-11	NR	HXY79063.1	3045160	g38322	i0	60.4	1.86585365853659	53	20	97	1	5	163	6	57	HXY79063.1 SDR family oxidoreductase [Candidatus Bathyarchaeia archaeon]	diamond	306	65.5	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota	Candidatus Bathyarchaeia				Candidatus Bathyarchaeia archaeon
31168433	31168433	PRJNA770826_P_NODE_11215_length_241_cov_1.062500_g11044_i0	PRJNA770826	11215	241	1.0625	2.560625	root	1	Root_unresolved	Root_unresolved	58.9	7.16e-8	NR	MCC6005138.1	1961369	g11044	i0	61.9	1.07053941908714	42	16	52.3	0	141	16	49	90	MCC6005138.1 ankyrin repeat domain-containing protein [Thermofilum sp.]	diamond	258	59.3	0.993254637436762	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermofilales	Thermofilaceae	Thermofilum	Thermofilum sp.

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