metadata: contig_metadata: 8 rows where bioproject = "PRJNA811237" and tax

8 rows where bioproject = "PRJNA811237" 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
17387141	17387141	PRJNA811237_S_NODE_22714_length_180_cov_1.557252_g22474_i0	PRJNA811237	22714	180	1.557252	2.8030536	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	209	8.56e-50	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g22474	i0	90.123	99.2111111111111	162	14	89	2	1	161	2314459	2314619	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	17858	209	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
23761402	23761402	PRJNA811237_S_NODE_5079_length_323_cov_0.930657_g4839_i0	PRJNA811237	5079	323	0.930657	3.00602211	FCB group	1783270	Bacteria	Bacteria	185	7.509999999999998e-55	NR	HEY9229717.1	2026741	g4839	i0	76.6	9.96594427244582	107	25	99.4	0	322	2	76	182	HEY9229717.1 NADP-dependent isocitrate dehydrogenase [Gemmatimonadaceae bacterium]	diamond	3219	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26959155	26959155	PRJNA811237_S_NODE_5362_length_315_cov_1.270677_g5122_i0	PRJNA811237	5362	315	1.270677	4.00263255	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	48.9	5.76e-4	NR	MEO5509184.1	2910168	g5122	i0	31.7	0.990476190476191	104	68	97.1	2	2	307	480	582	MEO5509184.1 acyl-CoA dehydrogenase [Longimicrobiales bacterium]	diamond	312	48.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
27812596	27812596	PRJNA811237_S_NODE_17624_length_198_cov_2.140940_g17384_i0	PRJNA811237	17624	198	2.14094	4.2390612	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	57.4	1.38e-7	NR	MCC7001122.1	2026741	g17384	i0	63.9	1.62121212121212	36	13	54.5	0	110	3	2	37	MCC7001122.1 aldehyde dehydrogenase family protein [Gemmatimonadaceae bacterium]	diamond	321	57.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30157625	30157625	PRJNA811237_S_NODE_32932_length_163_cov_0.894737_g32692_i0	PRJNA811237	32932	163	0.894737	1.45842131	Pseudomonadati	3379134	Bacteria	Bacteria	92.4	4e-20	NR	KPK82456.1	1703359	g32692	i0	87	73.5460122699387	54	7	99.4	0	1	162	434	487	KPK82456.1 MAG: phosphoribosylformylglycinamidine synthase [Gemmatimonas sp. SM23_52]	diamond	11988	92.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. SM23_52
30180548	30180548	PRJNA811237_S_NODE_34472_length_162_cov_0.902655_g34232_i0	PRJNA811237	34472	162	0.902655	1.4623011	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	61.6	1.46e-9	NR	MEO5903208.1	2026741	g34232	i0	56	9.2962962962963	50	22	92.6	0	154	5	191	240	MEO5903208.1 ceramidase domain-containing protein [Gemmatimonadaceae bacterium]	diamond	1506	61.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30844235	30844235	PRJNA811237_S_NODE_27074_length_168_cov_0.857143_g26834_i0	PRJNA811237	27074	168	0.857143	1.44000024	Longimicrobium sp.	2029185	Bacteria	Bacteria	40.4	0.0208	NR	HEX8831295.1	2029185	g26834	i0	48.7	0.696428571428571	39	19	67.9	1	45	158	20	58	HEX8831295.1 hypothetical protein [Longimicrobium sp.]	diamond	117	40.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32615077	32615077	PRJNA811237_S_NODE_6200_length_296_cov_1.651822_g5960_i0	PRJNA811237	6200	296	1.651822	4.88939312	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	43.5	0.037	NR	HEY6853401.1	2448054	g5960	i0	41.5	0.658783783783784	65	35	62.8	1	282	97	175	239	HEY6853401.1 response regulator [Gemmatimonadales bacterium]	diamond	195	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales 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);;