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

10 rows where analysis = "diamond", bioproject = "PRJEB14803" 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_genus	tax_species
3847785	3847785	PRJEB14803_P_NODE_884_length_1432_cov_3.218325_g746_i0	PRJEB14803	884	1432	3.218325	46.086414	Candidatus Iainarchaeum archaeon	3101447	Archaea	Archaea	432	2.2999999999999994e-145	NR	MBS3062730.1	2026736	g746	i0	53.1	3.35195530726257	401	185	83.6	2	1207	11	4	403	MBS3062730.1 hydroxymethylglutaryl-CoA reductase, degradative [Candidatus Iainarchaeum archaeon]	diamond	4800	432	1	Archaea		Nanobdellati	Candidatus Iainarchaeota	Candidatus Iainarchaeum	Candidatus Iainarchaeum archaeon
15323607	15323607	PRJEB14803_P_NODE_27633_length_208_cov_2.404624_g27167_i0	PRJEB14803	27633	208	2.404624	5.00161792	Nanobdellota archaeon	2026764	Archaea	Archaea	106	9.87e-25	NR	MEA3378856.1	2026764	g27167	i0	70.6	19.6153846153846	68	20	98.1	0	3	206	484	551	MEA3378856.1 CDC48 family AAA ATPase [Nanoarchaeota archaeon]	diamond	4080	106	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
27159279	27159279	PRJEB14803_P_NODE_47082_length_151_cov_1.034483_g46616_i0	PRJEB14803	47082	151	1.034483	1.56206933	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	40.8	0.0237	NR	MBI2665100.1	2026803	g46616	i0	51.2	0.814569536423841	41	18	81.5	1	27	149	65	103	MBI2665100.1 cupredoxin family copper-binding protein [Candidatus Woesearchaeota archaeon]	diamond	123	40.8	1	Archaea		Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
27222561	27222561	PRJEB14803_P_NODE_4443_length_665_cov_3.304762_g4057_i0	PRJEB14803	4443	665	3.304762	21.9766673	Candidatus Iainarchaeum archaeon	3101447	Archaea	Archaea	45.4	0.0283	NR	MEM4327164.1	2026736	g4057	i0	35.3	0.230075187969925	51	33	23	0	158	310	46	96	MEM4327164.1 hypothetical protein [Candidatus Iainarchaeum archaeon]	diamond	153	45.4	1	Archaea		Nanobdellati	Candidatus Iainarchaeota	Candidatus Iainarchaeum	Candidatus Iainarchaeum archaeon
28574161	28574161	PRJEB14803_P_NODE_17287_length_285_cov_1.584000_g16821_i0	PRJEB14803	17287	285	1.584	4.5144	root	1	Root_unresolved	Root_unresolved	51.6	5.04e-5	NR	OIO44055.1	1805298	g16821	i0	33.8	6.77894736842105	80	51	83.2	2	4	240	1963	2041	OIO44055.1 MAG: hypothetical protein AUJ64_00885 [Candidatus Pacearchaeota archaeon CG1_02_39_14]	diamond	1932	51.6	1	Archaea	Candidatus Pacearchaeota	Nanobdellati			Candidatus Pacearchaeota archaeon CG1_02_39_14
28643963	28643963	PRJEB14803_P_NODE_9067_length_435_cov_1.557500_g8604_i0	PRJEB14803	9067	435	1.5575	6.775125	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	43.9	0.0173	NR	MBI4177269.1	3121606	g8604	i0	41.4	0.4	58	34	40	0	111	284	9	66	MBI4177269.1 Rieske 2Fe-2S domain-containing protein [Candidatus Aenigmatarchaeota archaeon]	diamond	174	43.9	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota		Candidatus Aenigmatarchaeota archaeon
28833181	28833181	PRJEB14803_P_NODE_42968_length_159_cov_0.967742_g42502_i0	PRJEB14803	42968	159	0.967742	1.53870978	Nanobdellota archaeon	2026764	Archaea	Archaea	49.3	5.61e-5	NR	MEK6938630.1	2026764	g42502	i0	47.1	1.94339622641509	51	27	96.2	0	5	157	292	342	MEK6938630.1 tyrosine--tRNA ligase [Nanoarchaeota archaeon]	diamond	309	49.3	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
29111099	29111099	PRJEB14803_P_NODE_44488_length_156_cov_0.842975_g44022_i0	PRJEB14803	44488	156	0.842975	1.315041	root	1	Root_unresolved	Root_unresolved	43.9	0.00422	NR	MAG49920.1	2026803	g44022	i0	43.6	1.42307692307692	39	22	75	0	146	30	15	53	MAG49920.1 glycosyl transferase family 25 [Candidatus Woesearchaeota archaeon]	diamond	222	43.9	1	Archaea		Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
29780435	29780435	PRJEB14803_P_NODE_9771_length_414_cov_2.089710_g9307_i0	PRJEB14803	9771	414	2.08971	8.6513994	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	120	1.98e-32	NR	MBI2546133.1	2026803	g9307	i0	61.3	0.673913043478261	93	35	67.4	1	54	332	7	98	MBI2546133.1 MGMT family protein [Candidatus Woesearchaeota archaeon]	diamond	279	120	1	Archaea		Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
32277886	32277886	PRJEB14803_P_NODE_17159_length_286_cov_2.589641_g16693_i0	PRJEB14803	17159	286	2.589641	7.40637326	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	122	4.77e-30	NR	MFH0832136.1	3121606	g16693	i0	58.5	2.95804195804196	94	39	98.6	0	286	5	723	816	MFH0832136.1 carbamoyl-phosphate synthase (glutamine-hydrolyzing) large subunit [Candidatus Aenigmatarchaeota archaeon]	diamond	846	122	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);;