metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1059246" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1059246" and tax_clade = "Stenosarchaea group"

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_class	tax_order	tax_family	tax_genus	tax_species
4003781	4003781	PRJNA1059246_P_NODE_61504_length_251_cov_1.235955_g60878_i0	PRJNA1059246	61504	251	1.235955	3.10224705	Haloferacaceae archaeon	2080321	Archaea	Archaea	109	3.82e-28	NR	MFB6154400.1	2080321	g60878	i0	62.7	1.9840637450199201	83	30	99.2	1	249	1	52	133	MFB6154400.1 peptide-methionine (S)-S-oxide reductase MsrA [Haloferacaceae archaeon]	diamond	498	109	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae		Haloferacaceae archaeon
27825248	27825248	PRJNA1059246_P_NODE_48764_length_294_cov_1.533937_g48138_i0	PRJNA1059246	48764	294	1.533937	4.50977478	Methanothrix sp.	90426	Archaea	Archaea	52	2.87e-5	NR	NMB86174.1	90426	g48138	i0	49.1	0.561224489795918	55	28	56.1	0	2	166	48	102	NMB86174.1 tetratricopeptide repeat protein [Methanothrix sp.]	diamond	165	52	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
28077581	28077581	PRJNA1059246_P_NODE_37305_length_351_cov_2.093525_g36679_i0	PRJNA1059246	37305	351	2.093525	7.34827275	Methanosarcinales archaeon	2250255	Archaea	Archaea	84.3	3.16e-16	NR	RYE85578.1	2250255	g36679	i0	44.4	0.923076923076923	108	54	88.9	3	349	38	404	509	RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon]	diamond	324	84.3	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
28330265	28330265	PRJNA1059246_P_NODE_67546_length_246_cov_0.890173_g66920_i0	PRJNA1059246	67546	246	0.890173	2.18982558	Natronoarchaeum rubrum	755311	Archaea	Archaea	60.1	1.46e-8	NR	WP_256393113.1	755311	g66920	i0	54.8	1.51219512195122	62	25	74.4	2	61	243	4	63	WP_256393113.1 histidine phosphatase family protein [Natronoarchaeum rubrum]	diamond	372	60.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronoarchaeaceae	Natronoarchaeum	Natronoarchaeum rubrum
29151612	29151612	PRJNA1059246_P_NODE_54649_length_275_cov_1.252475_g54023_i0	PRJNA1059246	54649	275	1.252475	3.44430625	Methanosarcinales archaeon	2250255	Archaea	Archaea	67	9.09e-12	NR	RYE81919.1	2250255	g54023	i0	42.1	0.829090909090909	76	42	81.8	2	2	226	34	108	RYE81919.1 MAG: hypothetical protein EOO65_06165 [Methanosarcinales archaeon]	diamond	228	67	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales			Methanosarcinales archaeon
29372238	29372238	PRJNA1059246_P_NODE_15529_length_593_cov_1.184615_g14929_i0	PRJNA1059246	15529	593	1.184615	7.02476695	Methanoregula sp.	2052170	Archaea	Archaea	77.8	8.44e-13	NR	MDD1698370.1	2052170	g14929	i0	29.7	1.02192242833052	202	109	97.1	7	591	16	336	514	MDD1698370.1 GPI anchored serine-threonine rich family protein [Methanoregula sp.]	diamond	606	77.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp.
30730489	30730489	PRJNA1059246_P_NODE_47394_length_301_cov_1.013158_g46768_i0	PRJNA1059246	47394	301	1.013158	3.04960558	Candidatus Methanophagaceae archaeon	3386247	Archaea	Archaea	72.4	2.63e-12	NR	KAF5437882.1	3386247	g46768	i0	48.6	0.737541528239203	74	30	73.8	2	48	269	137	202	KAF5437882.1 Kazal-type serine protease inhibitor domain-containing protein [Candidatus Methanophagaceae archaeon]	diamond	222	72.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales	Candidatus Methanophagaceae		Candidatus Methanophagaceae archaeon
31014877	31014877	PRJNA1059246_P_NODE_58375_length_262_cov_1.539683_g57749_i0	PRJNA1059246	58375	262	1.539683	4.03396946	Methanomicrobiales archaeon	2184052	Archaea	Archaea	56.2	9.2e-8	NR	NYT06209.1	2184052	g57749	i0	38.2	1.54580152671756	68	42	77.9	0	204	1	1	68	NYT06209.1 hypothetical protein [Methanomicrobiales archaeon]	diamond	405	56.2	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales archaeon
32058462	32058462	PRJNA1059246_P_NODE_46438_length_305_cov_1.793103_g45812_i0	PRJNA1059246	46438	305	1.793103	5.46896415	Methanogenium marinum	348610	Archaea	Archaea	40.8	0.0489	NR	WP_274923711.1	348610	g45812	i0	43.9	0.40327868852459	41	23	40.3	0	162	40	7	47	WP_274923711.1 hypothetical protein [Methanogenium marinum]	diamond	123	40.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanogenium	Methanogenium marinum

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);;