metadata: contig_metadata: 9 rows where bioproject = "PRJNA942359" and tax

9 rows where bioproject = "PRJNA942359" and tax_kingdom = "Methanobacteriati"

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
10187546	10187546	PRJNA942359_P_NODE_20768_length_207_cov_4.455224_g20653_i0	PRJNA942359	20768	207	4.455224	9.22231368	Methanosarcina	2207	Archaea	Archaea	383	5.65e-102	NTclustered	gi\|827396966\|gb\|CP008746.1\|	796385	g20653	i0	100	40.9227053140097	207	0	100	0	1	207	4158541	4158747	Methanosarcina barkeri CM1, complete genome	blastn	8471	383	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina barkeri
22599965	22599965	PRJNA942359_P_NODE_16058_length_248_cov_0.891429_g15943_i0	PRJNA942359	16058	248	0.891429	2.21074392	Methanothrix sp.	90426	Archaea	Archaea	436	5.3e-118	NTclustered	gi\|2621703957\|emb\|OY762912.1\|	90426	g15943	i0	98.387	1	248	4	100	0	1	248	1275697	1275944	MAG: Methanothrix sp. isolate 80880379-7421-4bc7-b5fd-f9f5169ec620 genome assembly, chromosome: 1	blastn	248	436	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.
22599976	22599976	PRJNA942359_P_NODE_16438_length_248_cov_0.891429_g16323_i0	PRJNA942359	16438	248	0.891429	2.21074392	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	134	8.34e-35	NR	HWR96842.1	2032688	g16323	i0	85.4	0.991935483870968	82	12	99.2	0	1	246	261	342	HWR96842.1 DHA2 family efflux MFS transporter permease subunit [Candidatus Methanoperedens sp.]	diamond	246	134	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
25485403	25485403	PRJNA942359_P_NODE_20220_length_242_cov_0.923077_g20105_i0	PRJNA942359	20220	242	0.923077	2.23384634	Methanosarcina	2207	Archaea	Archaea	448	2.3799999999999995e-121	NTclustered	gi\|827396966\|gb\|CP008746.1\|	796385	g20105	i0	100	12	242	0	100	0	1	242	4371282	4371041	Methanosarcina barkeri CM1, complete genome	blastn	2904	448	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina barkeri
27948131	27948131	PRJNA942359_P_NODE_14325_length_251_cov_0.876404_g14210_i0	PRJNA942359	14325	251	0.876404	2.19977404	root	1	Root_unresolved	Root_unresolved	98.6	4.04e-22	NR	WP_048038854.1	2209	g14210	i0	56.6	5.85657370517928	83	36	99.2	0	249	1	274	356	WP_048038854.1 restriction endonuclease subunit S [Methanosarcina mazei]	diamond	1470	99	0.995959595959596	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina mazei
28320125	28320125	PRJNA942359_P_NODE_14446_length_251_cov_0.876404_g14331_i0	PRJNA942359	14446	251	0.876404	2.19977404	Candidatus Methanoperedens sp.	2032688	Archaea	Archaea	142	6.51e-39	NR	HWR98640.1	2032688	g14331	i0	81.7	0.9800796812749	82	15	98	0	1	246	120	201	HWR98640.1 DHH family phosphoesterase [Candidatus Methanoperedens sp.]	diamond	246	142	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Candidatus Methanoperedentaceae	Candidatus Methanoperedens	Candidatus Methanoperedens sp.
30530673	30530673	PRJNA942359_P_NODE_15773_length_249_cov_0.886364_g15658_i0	PRJNA942359	15773	249	0.886364	2.20704636	Methanobrevibacter gottschalkii	190974	Archaea	Archaea	145	1.54e-40	NR	WP_091698890.1	190974	g15658	i0	81.9	3	83	15	100	0	1	249	119	201	WP_091698890.1 CPBP family intramembrane glutamic endopeptidase [Methanobrevibacter gottschalkii]	diamond	747	145	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter gottschalkii
30973254	30973254	PRJNA942359_P_NODE_14314_length_251_cov_0.876404_g14199_i0	PRJNA942359	14314	251	0.876404	2.19977404	Haloferax	2251	Archaea	Archaea	52.8	1.23e-5	NR	WP_151114281.1	2251	g14199	i0	36.3	1.60159362549801	80	35	95.6	2	243	4	726	789	WP_151114281.1 MULTISPECIES: PD-(D/E)XK nuclease family protein [Haloferax]	diamond	402	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Haloferax
32774966	32774966	PRJNA942359_P_NODE_15660_length_249_cov_0.886364_g15545_i0	PRJNA942359	15660	249	0.886364	2.20704636	Methanothrix sp.	90426	Archaea	Archaea	143	1.59e-38	NR	MBP8623374.1	90426	g15545	i0	83.1	1	83	14	100	0	249	1	57	139	MBP8623374.1 anthranilate synthase component I [Methanothrix sp.]	diamond	249	143	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanothrix sp.

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