metadata: contig_metadata: 8 rows where bioproject = "PRJNA340009", tax_clade = "Methanomada group" and tax

8 rows where bioproject = "PRJNA340009", tax_clade = "Methanomada 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
27028680	27028680	PRJNA340009_P_NODE_26342_length_240_cov_2.649215_g26035_i0	PRJNA340009	26342	240	2.649215	6.358116	Methanobrevibacter	2172	Archaea	Archaea	85.5	4.71e-19	NR	WP_292896157.1	66852	g26035	i0	91.5	1.7625	47	4	58.8	0	239	99	99	145	WP_292896157.1 molybdenum cofactor biosynthesis protein MoaE [Methanobrevibacter sp.]	diamond	423	85.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27565708	27565708	PRJNA340009_P_NODE_33024_length_218_cov_2.325444_g32717_i0	PRJNA340009	33024	218	2.325444	5.06946792	root	1	Root_unresolved	Root_unresolved	56.2	2.51e-7	NR	MDD3986108.1	2164	g32717	i0	70.3	2.44954128440367	37	9	50.9	1	112	2	168	202	MDD3986108.1 hypothetical protein [Methanobacterium sp.]	diamond	534	56.2	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
27611944	27611944	PRJNA340009_P_NODE_71984_length_163_cov_0.894737_g71677_i0	PRJNA340009	71984	163	0.894737	1.45842131	Methanobrevibacter sp.	66852	Archaea	Archaea	48.5	1.1e-4	NR	MBO7694745.1	66852	g71677	i0	56.4	0.717791411042945	39	14	66.3	1	155	48	36	74	MBO7694745.1 leucine-rich repeat domain-containing protein [Methanobrevibacter sp.]	diamond	117	48.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
28323510	28323510	PRJNA340009_P_NODE_22826_length_255_cov_1.878641_g22519_i0	PRJNA340009	22826	255	1.878641	4.79053455	root	1	Root_unresolved	Root_unresolved	42.4	0.00642	NR	WP_404805568.1	2173	g22519	i0	43.4	1.87058823529412	53	28	60	1	255	103	2	54	WP_404805568.1 hypothetical protein, partial [Methanobrevibacter smithii]	diamond	477	42.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
28685500	28685500	PRJNA340009_P_NODE_39367_length_202_cov_9.673203_g39060_i0	PRJNA340009	39367	202	9.6732030000000009	19.53987006	Methanobacterium sp. PtaU1.Bin	2164	Archaea	Archaea	81.6	3.99e-16	NR	OPY23655.1	1811675	g39060	i0	78.7	0.698019801980198	47	10	69.8	0	60	200	2	48	OPY23655.1 MAG: pyrroloquinoline quinone biosynthesis protein PqqE [Methanobacterium sp. PtaU1.Bin097]	diamond	141	81.6	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp. PtaU1.Bin097
28811309	28811309	PRJNA340009_P_NODE_77108_length_161_cov_0.910714_g76801_i0	PRJNA340009	77108	161	0.910714	1.46624954	Methanobrevibacter sp.	66852	Archaea	Archaea	85.5	1.04e-17	NR	MBO7734457.1	66852	g76801	i0	77.6	0.91304347826087	49	11	91.3	0	15	161	565	613	MBO7734457.1 hypothetical protein [Methanobrevibacter sp.]	diamond	147	85.5	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30454084	30454084	PRJNA340009_P_NODE_43793_length_193_cov_7.520833_g43486_i0	PRJNA340009	43793	193	7.520833	14.51520769	Methanobrevibacter sp.	66852	Archaea	Archaea	52.4	7.29e-6	NR	WP_292846015.1	66852	g43486	i0	40.9	2.75129533678756	66	33	93.3	2	192	13	145	210	WP_292846015.1 hypothetical protein [Methanobrevibacter sp.]	diamond	531	52.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31813131	31813131	PRJNA340009_P_NODE_65077_length_166_cov_0.871795_g64770_i0	PRJNA340009	65077	166	0.871795	1.4471797	Methanobrevibacter sp.	66852	Archaea	Archaea	49.7	4.5e-5	NR	MBO7694449.1	66852	g64770	i0	50	0.795180722891566	44	22	79.5	0	6	137	71	114	MBO7694449.1 hypothetical protein [Methanobrevibacter sp.]	diamond	132	49.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter 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);;