metadata: contig_metadata: 10 rows where bioproject = "PRJNA1010780" and tax

10 rows where bioproject = "PRJNA1010780" and tax_phylum = "Candidatus Woesearchaeota"

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
27761478	27761478	PRJNA1010780_S_NODE_28844_length_275_cov_2.216667_g27555_i0	PRJNA1010780	28844	275	2.216667	6.09583425	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	83.2	1.08e-16	NR	MBI2102779.1	2026803	g27555	i0	48.9	0.96	88	42	96	2	266	3	162	246	MBI2102779.1 DUF1152 domain-containing protein [Candidatus Woesearchaeota archaeon]	diamond	264	83.2	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
28226972	28226972	PRJNA1010780_S_NODE_55286_length_163_cov_4.250000_g53997_i0	PRJNA1010780	55286	163	4.25	6.9275	root	1	Root_unresolved	Root_unresolved	56.6	1.55e-7	NR	MBS3128698.1	2026803	g53997	i0	75	5.59509202453988	32	8	58.9	0	30	125	539	570	MBS3128698.1 adenylyltransferase/cytidyltransferase family protein [Candidatus Woesearchaeota archaeon]	diamond	912	57	0.992982456140351	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
28360967	28360967	PRJNA1010780_S_NODE_34986_length_231_cov_1.219388_g33697_i0	PRJNA1010780	34986	231	1.219388	2.81678628	Candidatus Woesearchaeota archaeon CG1_	2026803	Archaea	Archaea	47.4	7.01e-4	NR	OIO63997.1	1805422	g33697	i0	64.3	0.363636363636364	28	10	36.4	0	231	148	23	50	OIO63997.1 MAG: hypothetical protein AUJ83_00365 [Candidatus Woesearchaeota archaeon CG1_02_33_12]	diamond	84	47.4	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon CG1_02_33_12
29308251	29308251	PRJNA1010780_S_NODE_42269_length_198_cov_2.024540_g40980_i0	PRJNA1010780	42269	198	2.02454	4.0085892	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	60.1	1.55e-8	NR	MBS3128698.1	2026803	g40980	i0	44.6	0.848484848484849	56	31	84.8	0	197	30	832	887	MBS3128698.1 adenylyltransferase/cytidyltransferase family protein [Candidatus Woesearchaeota archaeon]	diamond	168	60.1	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
30382639	30382639	PRJNA1010780_S_NODE_6393_length_1057_cov_7.737769_g5753_i0	PRJNA1010780	6393	1057	7.737769	81.78821833	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	266	3.73e-83	NR	MEM4247195.1	2026803	g5753	i0	41.1	0.993377483443709	350	186	99.1	7	11	1057	5	335	MEM4247195.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Woesearchaeota archaeon]	diamond	1050	266	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
31045981	31045981	PRJNA1010780_S_NODE_2795_length_1571_cov_6.460938_g2489_i0	PRJNA1010780	2795	1571	6.460938	101.50133598	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	148	2.14e-38	NR	MBI2572645.1	2026803	g2489	i0	53.6	0.815404201145767	140	64	26.5	1	1504	1088	7	146	MBI2572645.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	1281	148	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
31393574	31393574	PRJNA1010780_S_NODE_20076_length_401_cov_2.284153_g18787_i0	PRJNA1010780	20076	401	2.284153	9.15945353	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	90.5	5.04e-19	NR	MFT4261595.1	2026803	g18787	i0	38.5	1.91521197007481	130	67	93.5	3	6	380	33	154	MFT4261595.1 isocyanide synthase family protein [Candidatus Woesearchaeota archaeon]	diamond	768	90.5	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
32089429	32089429	PRJNA1010780_S_NODE_7458_length_959_cov_8.863636_g6708_i0	PRJNA1010780	7458	959	8.863636	85.00226924	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	253	5.6e-79	NR	MBD3203160.1	2026803	g6708	i0	44.9	0.954118873826903	305	153	94.8	4	959	51	22	313	MBD3203160.1 pyridoxal-phosphate dependent enzyme [Candidatus Woesearchaeota archaeon]	diamond	915	253	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
32184331	32184331	PRJNA1010780_S_NODE_16198_length_502_cov_2.781585_g14955_i0	PRJNA1010780	16198	502	2.781585	13.9635567	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	120	3.02e-31	NR	RMF06501.1	2026803	g14955	i0	52.7	1.35657370517928	112	52	66.9	1	3	338	31	141	RMF06501.1 MAG: ribose 5-phosphate isomerase B [Candidatus Woesearchaeota archaeon]	diamond	681	120	1	Archaea	Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
32215951	32215951	PRJNA1010780_S_NODE_12418_length_644_cov_8.586207_g11326_i0	PRJNA1010780	12418	644	8.586207	55.29517308	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	100	2.55e-22	NR	MFA6088836.1	2026803	g11326	i0	29.9	0.824534161490683	177	112	80.6	2	562	44	21	189	MFA6088836.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	531	100	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);;