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

4 rows where bioproject = "PRJNA782235" and tax_phylum = "Gemmatimonadota"

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
26673409	26673409	PRJNA782235_P_NODE_19361_length_249_cov_0.875000_g19172_i0	PRJNA782235	19361	249	0.875	2.17875	Roseisolibacter sp. H3M3-2	3031323	Bacteria	Bacteria	43.5	0.014	NR	WP_275829784.1	3031323	g19172	i0	58.1	0.518072289156627	43	14	51.8	1	131	3	9	47	WP_275829784.1 DsbA family protein [Roseisolibacter sp. H3M3-2]	diamond	129	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Roseisolibacter	Roseisolibacter sp. H3M3-2
28064270	28064270	PRJNA782235_P_NODE_19165_length_249_cov_0.875000_g18976_i0	PRJNA782235	19165	249	0.875	2.17875	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	143	1.33e-38	NR	HEX6589341.1	2910168	g18976	i0	88.8	0.963855421686747	80	9	96.4	0	248	9	355	434	HEX6589341.1 methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [Longimicrobiales bacterium]	diamond	240	143	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
30148170	30148170	PRJNA782235_P_NODE_18632_length_249_cov_0.875000_g18443_i0	PRJNA782235	18632	249	0.875	2.17875	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	107	7.14e-25	NR	GJG86285.1	2839016	g18443	i0	88.6	1.8433734939759	70	8	84.3	0	249	40	308	377	GJG86285.1 heme ABC transporter ATPase [Gemmatimonadetes bacterium T265]	diamond	459	107	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadetes bacterium T265
31222438	31222438	PRJNA782235_P_NODE_10955_length_283_cov_1.466667_g10766_i0	PRJNA782235	10955	283	1.466667	4.15066761	Longimicrobium sp.	2029185	Bacteria	Bacteria	146	1.5899999999999999e-40	NR	HWK90258.1	2029185	g10766	i0	80.9	0.996466431095406	94	18	99.6	0	1	282	158	251	HWK90258.1 AI-2E family transporter [Longimicrobium sp.]	diamond	282	146	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium 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);;