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

8 rows where bioproject = "PRJNA560932", 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
26794236	26794236	PRJNA560932_P_NODE_25341_length_354_cov_1.128114_g24985_i0	PRJNA560932	25341	354	1.128114	3.99352356	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	143	7.4e-40	NR	HMK54085.1	2099680	g24985	i0	63.2	7.72881355932203	114	42	96.6	0	11	352	39	152	HMK54085.1 arsenite methyltransferase [Methanobacteriaceae archaeon]	diamond	2736	143	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
27015705	27015705	PRJNA560932_P_NODE_4802_length_779_cov_13.703966_g4480_i0	PRJNA560932	4802	779	13.703966	106.75389514	Methanobacterium lacus	877455	Archaea	Archaea	49.7	0.00269	NR	WP_013645769.1	877455	g4480	i0	21.4	0.612323491655969	159	106	59.7	7	703	239	6	149	WP_013645769.1 hypothetical protein [Methanobacterium lacus]	diamond	477	49.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium lacus
27837002	27837002	PRJNA560932_P_NODE_3624_length_887_cov_4.083538_g3343_i0	PRJNA560932	3624	887	4.083538	36.22098206	Methanobacteriaceae archaeon	2099680	Archaea	Archaea	69.3	5.14e-9	NR	MBX7077174.1	2099680	g3343	i0	30	1.01465614430665	300	171	94.4	12	49	885	91	372	MBX7077174.1 hypothetical protein [Methanobacteriaceae archaeon]	diamond	900	69.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae		Methanobacteriaceae archaeon
29100168	29100168	PRJNA560932_P_NODE_27848_length_340_cov_1.153558_g27492_i0	PRJNA560932	27848	340	1.153558	3.9220972	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	87.8	1.84e-17	NR	WP_295723618.1	253161	g27492	i0	45.3	1.51764705882353	86	44	75.9	2	265	8	751	833	WP_295723618.1 cyclic nucleotide-binding serine/threonine-protein kinase [uncultured Methanobrevibacter sp.]	diamond	516	87.8	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
30029930	30029930	PRJNA560932_P_NODE_62911_length_244_cov_0.900585_g62555_i0	PRJNA560932	62911	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	48.5	3.59e-4	NR	WP_292750070.1	66852	g62555	i0	34.9	3.02459016393443	86	50	98.4	3	1	240	62	147	WP_292750070.1 Ig-like domain repeat protein [Methanobrevibacter sp.]	diamond	738	48.9	0.991820040899796	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30219347	30219347	PRJNA560932_P_NODE_64552_length_243_cov_0.905882_g64196_i0	PRJNA560932	64552	243	0.905882	2.20129326	root	1	Root_unresolved	Root_unresolved	106	5.460000000000001e-26	NR	MBO6123828.1	66852	g64196	i0	56.8	18.9753086419753	81	35	100	0	1	243	150	230	MBO6123828.1 carbon-nitrogen hydrolase family protein [Methanobrevibacter sp.]	diamond	4611	107	0.990654205607477	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
31596305	31596305	PRJNA560932_P_NODE_8196_length_607_cov_1.228464_g7843_i0	PRJNA560932	8196	607	1.228464	7.45677648	Methanobrevibacter sp.	66852	Archaea	Archaea	62	2.89e-7	NR	MBQ9026846.1	66852	g7843	i0	33.2	1.07248764415157	217	114	94.4	12	607	35	406	617	MBQ9026846.1 Ig-like domain repeat protein [Methanobrevibacter sp.]	diamond	651	62	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32860092	32860092	PRJNA560932_P_NODE_34560_length_309_cov_1.305085_g34204_i0	PRJNA560932	34560	309	1.305085	4.03271265	Methanobrevibacter sp. 87.7	387957	Archaea	Archaea	48.9	5.54e-4	NR	WP_143744780.1	387957	g34204	i0	29.7	0.980582524271845	101	62	89.3	3	277	2	97	197	WP_143744780.1 Ig-like domain repeat protein [Methanobrevibacter sp. 87.7]	diamond	303	48.9	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. 87.7

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