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

11 rows where bioproject = "PRJNA577580" 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_clade	tax_kingdom	tax_phylum	tax_species
6241734	6241734	PRJNA577580_P_NODE_4325_length_432_cov_2.621170_g4247_i0	PRJNA577580	4325	432	2.6211700000000002	11.3234544	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	214	2.6e-65	NR	MBD3210255.1	2250274	g4247	i0	74.3	8.75	140	34	97.2	1	421	2	205	342	MBD3210255.1 ATPase [Candidatus Micrarchaeota archaeon]	diamond	3780	214	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeota archaeon
14592884	14592884	PRJNA577580_P_NODE_2492_length_573_cov_2.720000_g2414_i0	PRJNA577580	2492	573	2.72	15.5856	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	289	1.07e-93	NR	MCB9359323.1	2026803	g2414	i0	77	7.93193717277487	191	38	100	3	573	1	99	283	MCB9359323.1 phosphopyruvate hydratase [Candidatus Woesearchaeota archaeon]	diamond	4545	289	1	Archaea		Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
26731093	26731093	PRJNA577580_P_NODE_141_length_1706_cov_9.000000_g122_i0	PRJNA577580	141	1706	9	153.54	Candidatus Altiarchaeota archaeon	2599821	Archaea	Archaea	63.9	1.02e-6	NR	MBN2518414.1	2599821	g122	i0	49.1	0.093200468933177	53	25	9	1	662	510	257	309	MBN2518414.1 hypothetical protein [Candidatus Altiarchaeota archaeon]	diamond	159	63.9	1	Archaea		Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeota archaeon
27806375	27806375	PRJNA577580_P_NODE_10804_length_280_cov_1.130435_g10726_i0	PRJNA577580	10804	280	1.130435	3.165218	Nanobdellota archaeon	2026764	Archaea	Archaea	59.3	8.79e-8	NR	MEA3329733.1	2026764	g10726	i0	40	0.964285714285714	90	42	92.1	3	1	258	310	391	MEA3329733.1 dockerin type I domain-containing protein [Nanoarchaeota archaeon]	diamond	270	59.3	1	Archaea		Nanobdellati	Nanobdellota	Nanobdellota archaeon
28469443	28469443	PRJNA577580_P_NODE_8986_length_303_cov_2.595652_g8908_i0	PRJNA577580	8986	303	2.595652	7.86482556	Nanobdellota archaeon	2026764	Archaea	Archaea	55.5	2.95e-7	NR	MBU1246094.1	2026764	g8908	i0	31.6	0.97029702970297	98	61	93.1	3	282	1	18	113	MBU1246094.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	294	55.5	1	Archaea		Nanobdellati	Nanobdellota	Nanobdellota archaeon
28500920	28500920	PRJNA577580_P_NODE_3207_length_501_cov_31.317757_g3129_i0	PRJNA577580	3207	501	31.317757	156.90196257	Candidatus Altiarchaeota archaeon	2599821	Archaea	Archaea	52.4	1.91e-4	NR	MBN2518414.1	2599821	g3129	i0	43.1	0.347305389221557	58	27	34.7	2	128	301	254	305	MBN2518414.1 hypothetical protein [Candidatus Altiarchaeota archaeon]	diamond	174	52.4	1	Archaea		Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeota archaeon
28847938	28847938	PRJNA577580_P_NODE_1288_length_793_cov_2.748611_g1219_i0	PRJNA577580	1288	793	2.748611	21.79648523	Nanobdellota archaeon	2026764	Archaea	Archaea	51.2	6.62e-5	NR	MCA9460456.1	2026764	g1219	i0	45.2	0.158890290037831	42	23	15.9	0	641	516	5	46	MCA9460456.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	126	51.2	1	Archaea		Nanobdellati	Nanobdellota	Nanobdellota archaeon
29132455	29132455	PRJNA577580_P_NODE_6189_length_361_cov_2.680556_g6111_i0	PRJNA577580	6189	361	2.680556	9.67680716	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	57.4	1.11e-6	NR	MBS3088859.1	2026773	g6111	i0	66.7	0.299168975069252	36	12	29.9	0	2	109	908	943	MBS3088859.1 DUF1554 domain-containing protein [Candidatus Pacearchaeota archaeon]	diamond	108	57.4	1	Archaea	Candidatus Pacearchaeota	Nanobdellati		Candidatus Pacearchaeota archaeon
29903683	29903683	PRJNA577580_P_NODE_11971_length_267_cov_1.793814_g11893_i0	PRJNA577580	11971	267	1.793814	4.78948338	root	1	Root_unresolved	Root_unresolved	63.2	3.24e-9	NR	MBR9706353.1	2026773	g11893	i0	61.4	1.4494382022471901	44	17	49.4	0	262	131	635	678	MBR9706353.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	387	63.2	1	Archaea	Candidatus Pacearchaeota	Nanobdellati		Candidatus Pacearchaeota archaeon
30711557	30711557	PRJNA577580_P_NODE_5754_length_374_cov_0.956811_g5676_i0	PRJNA577580	5754	374	0.956811	3.57847314	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	163	8.309999999999999e-45	NR	MFB6246063.1	2026773	g5676	i0	63.1	1.9572192513369	122	45	97.9	0	367	2	193	314	MFB6246063.1 ABC-ATPase domain-containing protein [Candidatus Pacearchaeota archaeon]	diamond	732	163	1	Archaea	Candidatus Pacearchaeota	Nanobdellati		Candidatus Pacearchaeota archaeon
32608884	32608884	PRJNA577580_P_NODE_15560_length_245_cov_0.906977_g15482_i0	PRJNA577580	15560	245	0.906977	2.22209365	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	43.1	0.0279	NR	MCX8195051.1	2250274	g15482	i0	58.6	0.355102040816327	29	12	35.5	0	3	89	248	276	MCX8195051.1 hypothetical protein [Candidatus Micrarchaeota archaeon]	diamond	87	43.1	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeota 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);;