metadata: contig_metadata: 9 rows where bioproject = "PRJNA662254", tax_clade = "Stenosarchaea group" and tax

9 rows where bioproject = "PRJNA662254", tax_clade = "Stenosarchaea group" and tax_phylum = "Methanobacteriota"

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
2437158	2437158	PRJNA662254_P_NODE_63842_length_242_cov_0.911243_g63191_i0	PRJNA662254	63842	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	99	2.76e-16	NTclustered	gi\|2006064443\|gb\|CP071462.1\|	2816475	g63191	i0	86.022	5.49586776859504	93	11	38	2	19	110	1306577	1306486	Haloterrigena alkaliphila strain KZCA68 chromosome, complete genome	blastn	1330	99	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Haloterrigena	Haloterrigena alkaliphila
15190509	15190509	PRJNA662254_P_NODE_53132_length_247_cov_0.885057_g52481_i0	PRJNA662254	53132	247	0.885057	2.18609079	Halorubrum	56688	Archaea	Archaea	54.7	0.006	NTclustered	gi\|1861358827\|gb\|CP054585.1\|	1853699	g52481	i0	100	0.700404858299595	29	0	12	0	141	169	1968068	1968040	Halorubrum sp. CBA1229 chromosome, complete genome	blastn	173	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. CBA1229
15931247	15931247	PRJNA662254_P_NODE_56073_length_246_cov_0.890173_g55422_i0	PRJNA662254	56073	246	0.890173	2.18982558	Methanoregula	395331	Archaea	Archaea	139	9.27e-40	NR	OPY37513.1	1811682	g55422	i0	81.5	3.95121951219512	81	15	98.8	0	245	3	92	172	OPY37513.1 MAG: Iron-sulfur flavoprotein [Methanoregula sp. PtaU1.Bin051]	diamond	972	140	0.992857142857143	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	Methanoregula sp. PtaU1.Bin051
23580997	23580997	PRJNA662254_P_NODE_49539_length_249_cov_0.875000_g48888_i0	PRJNA662254	49539	249	0.875	2.17875	Natrinema sp. 74	3384159	Archaea	Archaea	54.7	0.006	NTclustered	gi\|2869714891\|gb\|CP175698.1\|	3384159	g48888	i0	100	0.116465863453815	29	0	12	0	139	167	2650949	2650977	Natrinema sp. 74 chromosome, complete genome	blastn	29	54.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema sp. 74
29809199	29809199	PRJNA662254_P_NODE_63051_length_242_cov_0.911243_g62400_i0	PRJNA662254	63051	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	103	9.36e-24	NR	MCJ7445913.1	2595067	g62400	i0	70.9	1.95867768595041	79	23	97.9	0	240	4	197	275	MCJ7445913.1 SPFH domain-containing protein [Methanotrichaceae archaeon]	diamond	474	104	0.990384615384615	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae		Methanotrichaceae archaeon
31452616	31452616	PRJNA662254_P_NODE_65876_length_241_cov_0.910714_g65225_i0	PRJNA662254	65876	241	0.910714	2.19482074	root	1	Root_unresolved	Root_unresolved	55.5	1.18e-6	NR	WP_052721621.1	38027	g65225	i0	56.1	1.55601659751037	41	18	51	0	225	103	167	207	WP_052721621.1 Ig-like domain repeat protein [Methanosarcina siciliae]	diamond	375	55.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina siciliae
32211807	32211807	PRJNA662254_P_NODE_9318_length_547_cov_0.915612_g8676_i0	PRJNA662254	9318	547	0.915612	5.00839764	root	1	Root_unresolved	Root_unresolved	100	8.14e-21	NR	OPX78749.1	1811685	g8676	i0	43.4	4.94698354661792	182	85	97.6	8	544	11	584	751	OPX78749.1 MAG: HYR domain protein [Methanosaeta sp. PtaB.Bin039]	diamond	2706	101	0.99009900990099	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanosaeta sp. PtaB.Bin039
32799338	32799338	PRJNA662254_P_NODE_47760_length_250_cov_0.870056_g47109_i0	PRJNA662254	47760	250	0.870056	2.17514	Methanococcoides sp. SA1	2735871	Archaea	Archaea	149	6.12e-41	NR	NPE27660.1	2735871	g47109	i0	82.9	9.828	82	14	98.4	0	3	248	254	335	NPE27660.1 AAA family ATPase [Methanococcoides sp. SA1]	diamond	2457	149	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanococcoides	Methanococcoides sp. SA1
32893844	32893844	PRJNA662254_P_NODE_35480_length_281_cov_1.110577_g34829_i0	PRJNA662254	35480	281	1.110577	3.12072137	Natrinema salifodinae	1202768	Archaea	Archaea	43.1	0.0418	NR	WP_049989907.1	1202768	g34829	i0	47.1	0.544483985765125	51	25	54.4	1	263	111	160	208	WP_049989907.1 sugar porter family MFS transporter [Natrinema salifodinae]	diamond	153	43.1	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natrialbaceae	Natrinema	Natrinema salifodinae

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