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

5 rows where bioproject = "PRJNA890871" and tax_clade = "Methanomada group"

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
30371916	30371916	PRJNA890871_P_NODE_34412_length_294_cov_3.466063_g34277_i0	PRJNA890871	34412	294	3.466063	10.19022522	Methanobrevibacter sp.	66852	Archaea	Archaea	79.3	3.66e-17	NR	MBO6110342.1	66852	g34277	i0	55.1	0.704081632653061	69	31	70.4	0	272	66	1	69	MBO6110342.1 hypothetical protein [Methanobrevibacter sp.]	diamond	207	79.3	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30466596	30466596	PRJNA890871_P_NODE_17853_length_382_cov_1.750809_g17718_i0	PRJNA890871	17853	382	1.750809	6.68809038	Methanobrevibacter sp.	66852	Archaea	Archaea	62.4	1.75e-8	NR	MBP3225391.1	66852	g17718	i0	49.2	0.479057591623037	61	30	47.1	1	200	379	1	61	MBP3225391.1 hypothetical protein [Methanobrevibacter sp.]	diamond	183	62.4	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
30845484	30845484	PRJNA890871_P_NODE_1594_length_1521_cov_4.435083_g1493_i0	PRJNA890871	1594	1521	4.435083	67.45761243	Methanobrevibacter sp.	66852	Archaea	Archaea	110	1.53e-25	NR	MBO6110343.1	66852	g1493	i0	71	0.258382642998028	69	20	13.6	0	993	787	1	69	MBO6110343.1 hypothetical protein [Methanobrevibacter sp.]	diamond	393	110	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32078659	32078659	PRJNA890871_P_NODE_9778_length_492_cov_2.634845_g9643_i0	PRJNA890871	9778	492	2.634845	12.9634374	Methanobrevibacter sp.	66852	Archaea	Archaea	65.1	1.69e-10	NR	MBO6109614.1	66852	g9643	i0	38.8	0.48780487804878	80	47	48.8	1	322	83	5	82	MBO6109614.1 hypothetical protein [Methanobrevibacter sp.]	diamond	240	65.1	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32616338	32616338	PRJNA890871_P_NODE_3940_length_762_cov_6.965167_g3809_i0	PRJNA890871	3940	762	6.965167	53.07457254	Methanobrevibacter sp.	66852	Archaea	Archaea	240	2.3e-76	NR	MBO6110344.1	66852	g3809	i0	71.7	0.653543307086614	166	47	65.4	0	263	760	3	168	MBO6110344.1 hypothetical protein [Methanobrevibacter sp.]	diamond	498	240	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);;