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

5 rows where bioproject = "PRJNA515078" 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_species
27756219	27756219	PRJNA515078_P_NODE_3844_length_493_cov_3.120614_g3612_i0	PRJNA515078	3844	493	3.1206140000000002	15.38462702	Pseudomonadati	3379134	Bacteria	Bacteria	179	5.489999999999999e-52	NR	RMH69234.1	2026742	g3612	i0	57.6	3.79107505070994	151	63	91.9	1	39	491	53	202	RMH69234.1 MAG: lipase [Gemmatimonadota bacterium]	diamond	1869	179	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
29808170	29808170	PRJNA515078_P_NODE_32251_length_155_cov_0.991525_g32018_i0	PRJNA515078	32251	155	0.991525	1.53686375	Pseudomonadati	3379134	Bacteria	Bacteria	54.3	7.51e-7	NR	MFQ5537975.1	2026742	g32018	i0	52.9	4.74193548387097	51	24	98.7	0	2	154	90	140	MFQ5537975.1 enoyl-CoA hydratase/isomerase family protein [Gemmatimonadota bacterium]	diamond	735	54.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
30930259	30930259	PRJNA515078_P_NODE_20214_length_193_cov_1.410256_g19981_i0	PRJNA515078	20214	193	1.410256	2.72179408	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	84.7	3.14e-17	NR	HVE34968.1	2026741	g19981	i0	62.1	1.0259067357513	66	23	99.5	1	2	193	136	201	HVE34968.1 aminomethyl-transferring glycine dehydrogenase [Gemmatimonadaceae bacterium]	diamond	198	84.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
31150991	31150991	PRJNA515078_P_NODE_14935_length_227_cov_1.547368_g14702_i0	PRJNA515078	14935	227	1.547368	3.51252536	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	54.7	9.95e-7	NR	MCI0432253.1	2026742	g14702	i0	37.9	0.766519823788546	58	36	76.7	0	37	210	148	205	MCI0432253.1 aquaporin family protein [Gemmatimonadota bacterium]	diamond	174	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
32590415	32590415	PRJNA515078_P_NODE_31119_length_157_cov_1.300000_g30886_i0	PRJNA515078	31119	157	1.3	2.041	Pseudomonadati	3379134	Bacteria	Bacteria	72.8	2.8e-13	NR	RMH74066.1	2026742	g30886	i0	66	1.91082802547771	50	17	95.5	0	8	157	156	205	RMH74066.1 MAG: polyamine aminopropyltransferase [Gemmatimonadota bacterium]	diamond	300	72.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota 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);;