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

5 rows where analysis = "diamond", bioproject = "PRJNA1120060" and tax_phylum = "Chlorobiota"

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
26657195	26657195	PRJNA1120060_P_NODE_2352221_length_259_cov_2.220430_g2334160_i0	PRJNA1120060	2352221	259	2.22043	5.7509137	Pelodictyon phaeoclathratiforme	34090	Bacteria	Bacteria	45.4	0.00484	NR	WP_012509472.1	34090	g2334160	i0	48.8	0.474903474903475	41	19	45.2	1	142	258	248	288	WP_012509472.1 MBL fold metallo-hydrolase [Pelodictyon phaeoclathratiforme]	diamond	123	45.4	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon phaeoclathratiforme
27796380	27796380	PRJNA1120060_P_NODE_3395644_length_216_cov_8.314685_g3377524_i0	PRJNA1120060	3395644	216	8.314685	17.9597196	Chlorobium sp.	1095	Bacteria	Bacteria	42.7	0.0256	NR	WP_331561693.1	1095	g3377524	i0	40.7	0.75	54	30	75	1	191	30	91	142	WP_331561693.1 rhodanese-like domain-containing protein [Chlorobium sp.]	diamond	162	42.7	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium sp.
29057899	29057899	PRJNA1120060_P_NODE_1319908_length_305_cov_0.922414_g1301951_i0	PRJNA1120060	1319908	305	0.922414	2.8133627	Chlorobiaceae bacterium	2067991	Bacteria	Bacteria	43.5	0.0418	NR	NTU57465.1	2067991	g1301951	i0	31.6	0.963934426229508	98	56	85.6	3	277	17	646	743	NTU57465.1 BamA/TamA family outer membrane protein [Chlorobiaceae bacterium]	diamond	294	43.5	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae		Chlorobiaceae bacterium
32281802	32281802	PRJNA1120060_P_NODE_1755439_length_282_cov_7.129187_g1737429_i0	PRJNA1120060	1755439	282	7.129187	20.10430734	Chlorobium sp.	1095	Bacteria	Bacteria	140	2.86e-36	NR	MBV5330742.1	1095	g1737429	i0	75.8	2.02127659574468	95	22	100	1	282	1	363	457	MBV5330742.1 glycosyltransferase [Chlorobium sp.]	diamond	570	140	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium sp.
32345636	32345636	PRJNA1120060_P_NODE_2507139_length_253_cov_4.288889_g2489067_i0	PRJNA1120060	2507139	253	4.288889	10.85088917	Chlorobiota bacterium	2268192	Bacteria	Bacteria	46.2	0.0025	NR	MDB5033862.1	2268192	g2489067	i0	35.9	0.758893280632411	64	41	75.9	0	208	17	228	291	MDB5033862.1 amino acid permease-associated region [Chlorobiota bacterium]	diamond	192	46.2	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota 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);;