metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax_phylum = "Atribacterota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
28061980	28061980	PRJNA704949_P_NODE_122685_length_719_cov_2.749254_g109711_i0	PRJNA704949	122685	719	2.749254	19.76713626	Atribacterota bacterium	2952890	Bacteria	Bacteria	135	9.72e-35	NR	HNR66219.1	2952890	g109711	i0	55.7	0.959666203059805	115	51	48	0	362	18	1	115	HNR66219.1 IS21-like element helper ATPase IstB [Atribacterota bacterium]	diamond	690	135	1	Bacteria	Pseudomonadati	Atribacterota					Atribacterota bacterium
30347364	30347364	PRJNA704949_P_NODE_417612_length_421_cov_1.677419_g402470_i0	PRJNA704949	417612	421	1.677419	7.06193399	Pseudomonadati	3379134	Bacteria	Bacteria	80.9	1.07e-14	NR	WP_406607020.1	1805029	g402470	i0	36.4	2.70071258907363	118	71	84.1	1	60	413	283	396	WP_406607020.1 phage portal protein [Candidatus Infernicultor aquiphilus]	diamond	1137	80.9	1	Bacteria	Pseudomonadati	Atribacterota	Candidatus Phoenicimicrobiia	Candidatus Pheonicimicrobiales	Candidatus Phoenicimicrobiaceae	Candidatus Infernicultor	Candidatus Infernicultor aquiphilus
31062646	31062646	PRJNA704949_P_NODE_134175_length_693_cov_2.144410_g109711_i1	PRJNA704949	134175	693	2.14441	14.8607613	Atribacterota bacterium	2952890	Bacteria	Bacteria	135	7.379999999999998e-35	NR	HNR66219.1	2952890	g109711	i1	55.7	0.995670995670996	115	51	49.8	0	332	676	1	115	HNR66219.1 IS21-like element helper ATPase IstB [Atribacterota bacterium]	diamond	690	135	1	Bacteria	Pseudomonadati	Atribacterota					Atribacterota bacterium
31726384	31726384	PRJNA704949_P_NODE_1296397_length_221_cov_1.488372_g1281060_i0	PRJNA704949	1296397	221	1.488372	3.28930212	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	55.1	4.41e-8	NR	MDI3543332.1	2053509	g1281060	i0	65.6	0.434389140271493	32	11	43.4	0	47	142	13	44	MDI3543332.1 hypothetical protein [Candidatus Atribacteria bacterium]	diamond	96	55.1	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
32138077	32138077	PRJNA704949_P_NODE_2132818_length_163_cov_0.912281_g2117479_i0	PRJNA704949	2132818	163	0.912281	1.48701803	Atribacterota bacterium	2952890	Bacteria	Bacteria	61.6	5.73e-10	NR	HNR64735.1	2952890	g2117479	i0	63	0.846625766871166	46	17	84.7	0	160	23	122	167	HNR64735.1 hypothetical protein [Atribacterota bacterium]	diamond	138	61.6	1	Bacteria	Pseudomonadati	Atribacterota					Atribacterota bacterium

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