metadata: contig_metadata: 9 rows where bioproject = "PRJNA857143" and tax

9 rows where bioproject = "PRJNA857143" 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
8496685	8496685	PRJNA857143_S_NODE_193967_length_242_cov_1.384615_g192874_i0	PRJNA857143	193967	242	1.384615	3.3507683	Vulcanisaeta moutnovskia	985052	Archaea	Archaea	52.8	0.022	NTclustered	gi\|323706731\|gb\|CP002529.1\|	985053	g192874	i0	100	0.115702479338843	28	0	12	0	142	169	336100	336127	Vulcanisaeta moutnovskia 768-28, complete genome	blastn	28	52.8	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Thermoproteales	Thermoproteaceae	Vulcanisaeta	Vulcanisaeta moutnovskia
11047315	11047315	PRJNA857143_S_NODE_184589_length_246_cov_1.410405_g183496_i0	PRJNA857143	184589	246	1.410405	3.4695963	Candidatus Methanosuratincola petrocarbonis (ex Vanwonterghem et al. 2016)	1867261	Archaea	Archaea	58.4	4.78e-4	NTclustered	gi\|2551788334\|gb\|CP130488.1\|	1867261	g183496	i0	100	0.98780487804878	31	0	13	0	60	90	1063606	1063636	MAG: Candidatus Methanosuratincola petrocarbonis isolate LWZ-6 chromosome, complete genome	blastn	243	58.4	1	Archaea	Thermoproteati	Thermoproteota	Methanosuratincolia	Candidatus Methanomethylicales	Candidatus Methanomethylicaceae	Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016)	Candidatus Methanosuratincola petrocarbonis (ex Vanwonterghem et al. 2016)
12323204	12323204	PRJNA857143_S_NODE_35850_length_439_cov_7.046448_g34758_i0	PRJNA857143	35850	439	7.046448	30.93390672	Archaea	2157	Archaea	Archaea	155	4.0999999999999994e-44	NR	MBD3185947.1	2026714	g34758	i0	63.6	2.2619589977221	110	40	75.2	0	3	332	147	256	MBD3185947.1 acetyl-CoA C-acyltransferase [Candidatus Bathyarchaeota archaeon]	diamond	993	155	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
26674918	26674918	PRJNA857143_S_NODE_192501_length_243_cov_0.917647_g191408_i0	PRJNA857143	192501	243	0.917647	2.22988221	Nitrosopumilus sp.	2024843	Archaea	Archaea	114	1.23e-28	NR	MBA3284908.1	2024843	g191408	i0	69.6	1.95061728395062	79	24	97.5	0	239	3	148	226	MBA3284908.1 hypothetical protein [Nitrosopumilus sp.]	diamond	474	114	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
28854963	28854963	PRJNA857143_S_NODE_70108_length_354_cov_3.313167_g69015_i0	PRJNA857143	70108	354	3.313167	11.72861118	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	45.1	0.00626	NR	MCJ7637365.1	2169593	g69015	i0	37.3	0.703389830508475	83	42	61.9	1	18	236	36	118	MCJ7637365.1 ADP-ribosyltransferase domain-containing protein [Nitrososphaeraceae archaeon]	diamond	249	45.1	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
29683894	29683894	PRJNA857143_S_NODE_155850_length_262_cov_1.650794_g154757_i0	PRJNA857143	155850	262	1.650794	4.32508028	root	1	Root_unresolved	Root_unresolved	49.7	1.33e-4	NR	HIQ29069.1	311458	g154757	i0	51.4	0.824427480916031	37	18	42.4	0	1	111	129	165	HIQ29069.1 TatD family deoxyribonuclease [Candidatus Caldarchaeum subterraneum]	diamond	216	49.7	1	Archaea	Thermoproteati	Nitrososphaerota		Candidatus Caldarchaeales	Candidatus Caldarchaeaceae	Candidatus Caldarchaeum	Candidatus Caldarchaeum subterraneum
29991941	29991941	PRJNA857143_S_NODE_74971_length_346_cov_2.637363_g73878_i0	PRJNA857143	74971	346	2.637363	9.12527598	Nitrosopumilus sp.	2024843	Archaea	Archaea	57.8	5.11e-7	NR	MBA3284908.1	2024843	g73878	i0	37.6	0.875722543352601	101	51	85.8	5	298	2	1	91	MBA3284908.1 hypothetical protein [Nitrosopumilus sp.]	diamond	303	57.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
30339965	30339965	PRJNA857143_S_NODE_49372_length_397_cov_7.296296_g48279_i0	PRJNA857143	49372	397	7.296296	28.96629512	Candidatus Bathyarchaeota archaeon	2026714	Archaea	Archaea	101	2.25e-23	NR	MBD3185947.1	2026714	g48279	i0	74.2	0.468513853904282	62	16	46.9	0	2	187	195	256	MBD3185947.1 acetyl-CoA C-acyltransferase [Candidatus Bathyarchaeota archaeon]	diamond	186	101	1	Archaea	Thermoproteati	Candidatus Bathyarchaeota					Candidatus Bathyarchaeota archaeon
30466087	30466087	PRJNA857143_S_NODE_146753_length_269_cov_1.591837_g145660_i0	PRJNA857143	146753	269	1.591837	4.28204153	Desulfurococcales archaeon ex4484_217_2	2012519	Archaea	Archaea	63.9	1.05e-10	NR	OYT55921.1	2012519	g145660	i0	44.4	2.67657992565056	81	40	88.1	3	238	2	42	119	OYT55921.1 MAG: aminoacyl-tRNA hydrolase [Desulfurococcales archaeon ex4484_217_2]	diamond	720	63.9	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Desulfurococcales			Desulfurococcales archaeon ex4484_217_2

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