metadata: contig_metadata: 6 rows where bioproject = "PRJNA795983" and tax

6 rows where bioproject = "PRJNA795983" and tax_kingdom = "Nanobdellati"

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_species
17794186	17794186	PRJNA795983_S_NODE_11354_length_371_cov_2.560403_g11229_i0	PRJNA795983	11354	371	2.560403	9.49909513	Nanobdellota archaeon	2026764	Archaea	Archaea	173	1.15e-47	NR	MCA9485224.1	2026764	g11229	i0	67.5	0.970350404312669	120	39	97	0	362	3	285	404	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	360	173	1	Archaea	Nanobdellati	Nanobdellota	Nanobdellota archaeon
29548317	29548317	PRJNA795983_S_NODE_2350_length_675_cov_1.528239_g2240_i0	PRJNA795983	2350	675	1.528239	10.31561325	Nanobdellota archaeon	2026764	Archaea	Archaea	48.1	0.0185	NR	MEK6859808.1	2026764	g2240	i0	66.7	0.133333333333333	30	10	13.3	0	99	10	107	136	MEK6859808.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	90	48.1	1	Archaea	Nanobdellati	Nanobdellota	Nanobdellota archaeon
29832677	29832677	PRJNA795983_S_NODE_27791_length_275_cov_1.361386_g27666_i0	PRJNA795983	27791	275	1.361386	3.7438115	Nanobdellota archaeon	2026764	Archaea	Archaea	114	2.7300000000000003e-27	NR	MCA9485224.1	2026764	g27666	i0	57.8	0.981818181818182	90	37	97.1	1	8	274	224	313	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	270	114	1	Archaea	Nanobdellati	Nanobdellota	Nanobdellota archaeon
31254447	31254447	PRJNA795983_S_NODE_23855_length_289_cov_3.726852_g23730_i0	PRJNA795983	23855	289	3.726852	10.77060228	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	47.8	9.52e-4	NR	MCK4967494.1	3121606	g23730	i0	35.7	0.8719723183391	84	47	87.2	4	257	6	150	226	MCK4967494.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon]	diamond	252	47.8	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
31286017	31286017	PRJNA795983_S_NODE_7855_length_424_cov_1.794872_g7730_i0	PRJNA795983	7855	424	1.794872	7.61025728	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	52.4	1.14e-4	NR	MBI2972040.1	3121606	g7730	i0	37.7	0.431603773584906	61	38	43.2	0	59	241	418	478	MBI2972040.1 lytic murein transglycosylase [Candidatus Aenigmatarchaeota archaeon]	diamond	183	52.4	1	Archaea	Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
31887052	31887052	PRJNA795983_S_NODE_1717_length_764_cov_2.403763_g1619_i0	PRJNA795983	1717	764	2.403763	18.36474932	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	47.4	0.045	NR	UCD03602.1	2026803	g1619	i0	32.5	0.804973821989529	160	91	60.1	8	1	459	462	611	UCD03602.1 MAG: S8 family serine peptidase [Candidatus Woesearchaeota archaeon]	diamond	615	47.4	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota 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);;