metadata: contig_metadata: 5 rows where bioproject = "PRJNA816047" and tax

5 rows where bioproject = "PRJNA816047" 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
26180395	26180395	PRJNA816047d_S_NODE_45541_length_324_cov_1.686347_g43706_i0	PRJNA816047	45541	324	1.686347	5.46376428	Halobaculum	43927	Archaea	Archaea	52.8	0.03	NTclustered	gi\|2090002430\|gb\|CP082284.1\|	2872158	g43706	i0	87.5	0.296296296296296	48	2	14	4	195	240	243487	243532	Halobaculum rubrum strain C46 chromosome, complete genome	blastn	96	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halobaculum	Halobaculum rubrum
26417916	26417916	PRJNA816047d_S_NODE_131055_length_230_cov_2.209040_g129220_i0	PRJNA816047	131055	230	2.20904	5.080792	Salinirubellus salinus	1364945	Archaea	Archaea	52.8	0.021	NTclustered	gi\|2297614754\|gb\|CP104003.1\|	1364945	g129220	i0	100	0.121739130434783	28	0	12	0	144	171	2542871	2542844	Salinirubellus salinus strain ZS-35-S2 chromosome, complete genome	blastn	28	52.8	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Natronomonadaceae	Salinirubellus	Salinirubellus salinus
26546823	26546823	PRJNA816047a_S_NODE_53704_length_288_cov_2.283721_g51044_i0	PRJNA816047	53704	288	2.283721	6.57711648	Pyrococcus sp. ST	33866	Archaea	Archaea	54.7	0.007	NTclustered	gi\|388248755\|gb\|CP003534.1\|	1183377	g51044	i0	92.105	0.131944444444444	38	3	13	0	169	206	186961	186924	Pyrococcus sp. ST04, complete genome	blastn	38	54.7	1	Archaea		Methanobacteriati	Methanobacteriota	Thermococci	Thermococcales	Thermococcaceae	Pyrococcus	Pyrococcus sp. ST04
33044532	33044532	PRJNA816047b_S_NODE_39580_length_271_cov_1.712121_g37268_i0	PRJNA816047	39580	271	1.712121	4.63984791	root	1	Root_unresolved	Root_unresolved	48.5	1.36e-4	NR	HET8689268.1	2213	g37268	i0	40.4	2.2140221402214	47	26	52	1	230	90	93	137	HET8689268.1 DUF2591 domain-containing protein [Methanosarcina sp.]	diamond	600	48.5	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanosarcinales	Methanosarcinaceae	Methanosarcina	Methanosarcina sp.
33127080	33127080	PRJNA816047d_S_NODE_77479_length_264_cov_3.383886_g75644_i0	PRJNA816047	77479	264	3.383886	8.93345904	Methanoplanus endosymbiosus	33865	Archaea	Archaea	127	7.57e-34	NR	WP_257741831.1	33865	g75644	i0	67.9	1.84090909090909	81	26	92	0	249	7	153	233	WP_257741831.1 N-acetylneuraminate synthase family protein [Methanoplanus endosymbiosus]	diamond	486	127	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanomicrobiaceae	Methanoplanus	Methanoplanus endosymbiosus

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