metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA565778" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA565778" 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
26952785	26952785	PRJNA565778_S_NODE_27182_length_211_cov_314.793103_g26886_i0	PRJNA565778	27182	211	314.793103	664.21344733	Nanobdellota archaeon	2026764	Archaea	Archaea	60.8	3.19e-10	NR	MDO8509095.1	2026764	g26886	i0	69.4	0.511848341232227	36	11	51.2	0	40	147	1	36	MDO8509095.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	108	60.8	1	Archaea		Nanobdellati	Nanobdellota	Nanobdellota archaeon
27458874	27458874	PRJNA565778_S_NODE_14823_length_286_cov_81.630522_g14527_i0	PRJNA565778	14823	286	81.630522	233.46329292	Nanobdellota archaeon	2026764	Archaea	Archaea	53.9	4.77e-6	NR	MEK6844540.1	2026764	g14527	i0	48.1	0.545454545454545	52	27	54.5	0	3	158	154	205	MEK6844540.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	156	53.9	1	Archaea		Nanobdellati	Nanobdellota	Nanobdellota archaeon
27806208	27806208	PRJNA565778_S_NODE_25344_length_219_cov_71.719780_g25048_i0	PRJNA565778	25344	219	71.71978	157.0663182	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	54.7	1.26e-6	NR	MBM3233565.1	2026773	g25048	i0	60.5	0.945205479452055	38	15	52.1	0	105	218	164	201	MBM3233565.1 nucleotidyltransferase domain-containing protein [Candidatus Pacearchaeota archaeon]	diamond	207	54.7	1	Archaea	Candidatus Pacearchaeota	Nanobdellati		Candidatus Pacearchaeota archaeon
28293137	28293137	PRJNA565778_S_NODE_2706_length_591_cov_116.447653_g2538_i0	PRJNA565778	2706	591	116.447653	688.20562923	root	1	Root_unresolved	Root_unresolved	160	6.9e-45	NR	MFP4403897.1	2026803	g2538	i0	48.3	3.69543147208122	180	90	91.4	3	541	2	35	211	MFP4403897.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	2184	160	1	Archaea		Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
28532402	28532402	PRJNA565778_S_NODE_21707_length_237_cov_903.915000_g21411_i0	PRJNA565778	21707	237	903.915	2142.27855	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	75.9	7.53e-14	NR	MEM3113508.1	2026773	g21411	i0	71.2	1.86075949367089	52	15	65.8	0	156	1	96	147	MEM3113508.1 helicase C-terminal domain-containing protein [Candidatus Pacearchaeota archaeon]	diamond	441	75.9	1	Archaea	Candidatus Pacearchaeota	Nanobdellati		Candidatus Pacearchaeota archaeon
29069159	29069159	PRJNA565778_S_NODE_39968_length_165_cov_3.703125_g39672_i0	PRJNA565778	39968	165	3.703125	6.11015625	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	68.9	6.48e-12	NR	MCC5994730.1	3121606	g39672	i0	73.9	0.836363636363636	46	11	81.8	1	137	3	307	352	MCC5994730.1 AAA family ATPase [Candidatus Aenigmatarchaeota archaeon]	diamond	138	68.9	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
29921705	29921705	PRJNA565778_S_NODE_11091_length_327_cov_344.262069_g10795_i0	PRJNA565778	11091	327	344.262069	1125.73696563	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	42.7	0.00661	NR	MBN1792603.1	2026803	g10795	i0	52.6	0.715596330275229	38	17	34.9	1	160	47	4	40	MBN1792603.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	234	42.7	1	Archaea		Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
30205596	30205596	PRJNA565778_S_NODE_29632_length_202_cov_2.048485_g29336_i0	PRJNA565778	29632	202	2.048485	4.1379397000000004	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	60.5	4.83e-9	NR	MBW3002391.1	2026803	g29336	i0	52.8	2.3168316831683202	53	25	78.7	0	3	161	140	192	MBW3002391.1 HAD family hydrolase [Candidatus Woesearchaeota archaeon]	diamond	468	60.5	1	Archaea		Nanobdellati	Candidatus Woesearchaeota	Candidatus Woesearchaeota archaeon
31849462	31849462	PRJNA565778_S_NODE_14737_length_287_cov_7.680000_g14441_i0	PRJNA565778	14737	287	7.68	22.0416	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	141	3.77e-37	NR	MCC5994651.1	3121606	g14441	i0	85.9	0.888501742160279	85	12	88.9	0	255	1	447	531	MCC5994651.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon]	diamond	255	141	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota archaeon
32829197	32829197	PRJNA565778_S_NODE_16420_length_273_cov_3.758475_g16124_i0	PRJNA565778	16420	273	3.758475	10.26063675	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	147	5.82e-41	NR	MCC5994635.1	3121606	g16124	i0	90	0.879120879120879	80	8	87.9	0	242	3	156	235	MCC5994635.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon]	diamond	240	147	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota	Candidatus Aenigmatarchaeota 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);;