metadata: contig_metadata: 4 rows where bioproject = "PRJNA867519", tax_clade = "Methanomada group" and tax

4 rows where bioproject = "PRJNA867519", tax_clade = "Methanomada group" and tax_superkingdom = "Archaea"

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
27339762	27339762	PRJNA867519_P_NODE_19823_length_276_cov_1.896552_g19669_i0	PRJNA867519	19823	276	1.896552	5.23448352	Methanobrevibacter sp.	66852	Archaea	Archaea	84.7	1.01e-16	NR	WP_292800363.1	66852	g19669	i0	39.6	1.04347826086957	96	53	98.9	2	276	4	906	1001	WP_292800363.1 hypothetical protein [Methanobrevibacter sp.]	diamond	288	84.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29076406	29076406	PRJNA867519_P_NODE_6768_length_421_cov_1.583333_g6614_i0	PRJNA867519	6768	421	1.583333	6.66583193	Methanocaldococcus indicus	213231	Archaea	Archaea	45.1	0.032	NR	XMY58652.1	213231	g6614	i0	34.5	0.847980997624703	119	64	81.9	6	57	401	172	280	XMY58652.1 60S ribosomal export protein NMD3 [Methanocaldococcus indicus]	diamond	357	45.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanococci	Methanococcales	Methanocaldococcaceae	Methanocaldococcus	Methanocaldococcus indicus
29454751	29454751	PRJNA867519_P_NODE_3310_length_571_cov_2.190763_g3159_i0	PRJNA867519	3310	571	2.190763	12.50925673	uncultured Methanobrevibacter sp.	253161	Archaea	Archaea	91.7	1.95e-19	NR	WP_297983794.1	253161	g3159	i0	34.6	0.956217162872154	182	111	93	5	1	531	3	181	WP_297983794.1 translationally-controlled tumor protein [uncultured Methanobrevibacter sp.]	diamond	546	91.7	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	uncultured Methanobrevibacter sp.
29557785	29557785	PRJNA867519_P_NODE_10550_length_351_cov_1.568345_g10396_i0	PRJNA867519	10550	351	1.568345	5.50489095	Methanobacteriati	3366610	Archaea	Archaea	48.5	0.00101	NR	MDP6626642.1	2599940	g10396	i0	30.5	3.13675213675214	95	63	78.6	2	32	307	206	300	MDP6626642.1 mechanosensitive ion channel family protein [Methanopyri archaeon]	diamond	1101	48.9	0.991820040899796	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanopyri				Methanopyri archaeon

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