metadata: contig_metadata: 4 rows where bioproject = "PRJNA675331" and tax

4 rows where bioproject = "PRJNA675331" and tax_kingdom = "Methanobacteriati"

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
26765448	26765448	PRJNA675331_P_NODE_24101_length_241_cov_0.916667_g23929_i0	PRJNA675331	24101	241	0.916667	2.20916747	Thermoplasmatota archaeon	2806419	Archaea	Archaea	43.5	0.0172	NR	MDG6225782.1	2806419	g23929	i0	34.5	0.684647302904564	55	36	68.5	0	56	220	180	234	MDG6225782.1 metalloprotease family protein [Thermoplasmatota archaeon]	diamond	165	43.5	1	Archaea		Methanobacteriati	Thermoplasmatota					Thermoplasmatota archaeon
26923794	26923794	PRJNA675331_P_NODE_9922_length_316_cov_0.946502_g9750_i0	PRJNA675331	9922	316	0.946502	2.99094632	Geoglobus ahangari	113653	Archaea	Archaea	86.7	1.42e-17	NR	WP_048095167.1	113653	g9750	i0	42.9	0.996835443037975	105	57	99.7	2	315	1	45	146	WP_048095167.1 bis-aminopropyl spermidine synthase family protein [Geoglobus ahangari]	diamond	315	86.7	1	Archaea		Methanobacteriati	Methanobacteriota	Archaeoglobi	Archaeoglobales	Archaeoglobaceae	Geoglobus	Geoglobus ahangari
31535881	31535881	PRJNA675331_P_NODE_12896_length_284_cov_1.459716_g12724_i0	PRJNA675331	12896	284	1.459716	4.14559344	Methanomicrobiales archaeon HGW-Methanomicrobiales-4	2013820	Archaea	Archaea	47.4	0.00104	NR	PKL59616.1	2013820	g12724	i0	39.7	0.71830985915493	68	34	70.8	2	1	201	159	220	PKL59616.1 MAG: hypothetical protein CVV33_06900, partial [Methanomicrobiales archaeon HGW-Methanomicrobiales-4]	diamond	204	47.4	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales			Methanomicrobiales archaeon HGW-Methanomicrobiales-4
32705448	32705448	PRJNA675331_P_NODE_7780_length_350_cov_0.866426_g7608_i0	PRJNA675331	7780	350	0.866426	3.032491	uncultured Methanospirillum sp.	262503	Archaea	Archaea	89	2.15e-19	NR	WP_319578547.1	262503	g7608	i0	44.5	3.63428571428571	110	60	94.3	1	21	350	15	123	WP_319578547.1 ferritin [uncultured Methanospirillum sp.]	diamond	1272	89	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanospirillaceae	Methanospirillum	uncultured Methanospirillum 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);;