metadata: contig_metadata: 10 rows where bioproject = "PRJDB4470", tax_clade = "FCB group" and tax

10 rows where bioproject = "PRJDB4470", tax_clade = "FCB group" 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
5112328	5112328	PRJDB4470_P_NODE_94125_length_177_cov_1.492188_g92970_i0	PRJDB4470	94125	177	1.492188	2.64117276	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	62	1.4e-9	NR	HZM26761.1	2448054	g92970	i0	60.3	3.74576271186441	58	23	98.3	0	2	175	37	94	HZM26761.1 SDR family oxidoreductase [Gemmatimonadales bacterium]	diamond	663	62	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
6387379	6387379	PRJDB4470_P_NODE_114106_length_164_cov_1.382609_g112951_i0	PRJDB4470	114106	164	1.382609	2.26747876	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	207	2.76e-49	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g112951	i0	90.506	63.4817073170732	158	13	96	2	8	164	8261566	8261410	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	10411	207	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		uncultured Gemmatimonadales bacterium
24234966	24234966	PRJDB4470_P_NODE_110800_length_165_cov_0.896552_g109645_i0	PRJDB4470	110800	165	0.896552	1.4793108	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	178	2.18e-40	NTclustered	gi\|2621703510\|emb\|OY762557.1\|	2910168	g109645	i0	86.585	105.569696969697	164	18	98	4	4	165	3610655	3610494	MAG: Longimicrobiales bacterium isolate c10e2151-7d97-4465-9cf7-a78a4796a63d genome assembly, chromosome: 1	blastn	17419	178	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales		Longimicrobiales bacterium
27822403	27822403	PRJDB4470_P_NODE_70584_length_219_cov_1.794118_g69429_i0	PRJDB4470	70584	219	1.794118	3.92911842	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	120	3.7199999999999995e-30	NR	MBL8988644.1	2026742	g69429	i0	78.9	3.87671232876712	71	15	97.3	0	214	2	330	400	MBL8988644.1 aldehyde dehydrogenase family protein [Gemmatimonadota bacterium]	diamond	849	120	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
28895567	28895567	PRJDB4470_P_NODE_100528_length_169_cov_1.275000_g99373_i0	PRJDB4470	100528	169	1.275	2.15475	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	77.8	5.71e-15	NR	PYO77019.1	2026742	g99373	i0	67.3	3.83431952662722	55	18	97.6	0	3	167	286	340	PYO77019.1 MAG: amino acid permease [Gemmatimonadota bacterium]	diamond	648	77.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
29900350	29900350	PRJDB4470_P_NODE_105411_length_167_cov_0.864407_g104256_i0	PRJDB4470	105411	167	0.864407	1.44355969	Pseudomonadati	3379134	Bacteria	Bacteria	45.8	0.0011	NR	HET7584929.1	2026741	g104256	i0	45.5	4.88622754491018	55	29	97	1	164	3	568	622	HET7584929.1 tetratricopeptide repeat protein [Gemmatimonadaceae bacterium]	diamond	816	45.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
31391424	31391424	PRJDB4470_P_NODE_65016_length_234_cov_1.654054_g63861_i0	PRJDB4470	65016	234	1.654054	3.87048636	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	69.3	1.3e-11	NR	HEX6535207.1	2026741	g63861	i0	62.7	1.26923076923077	51	18	65.4	1	4	156	197	246	HEX6535207.1 OmpA family protein [Gemmatimonadaceae bacterium]	diamond	297	69.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
32055487	32055487	PRJDB4470_P_NODE_102458_length_168_cov_0.873950_g101303_i0	PRJDB4470	102458	168	0.87395	1.468236	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	42.4	0.0191	NR	HET9982412.1	2910168	g101303	i0	41.8	0.982142857142857	55	29	98.2	1	4	168	69	120	HET9982412.1 hypothetical protein [Longimicrobiales bacterium]	diamond	165	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales		Longimicrobiales bacterium
32150558	32150558	PRJDB4470_P_NODE_109778_length_166_cov_0.863248_g108623_i0	PRJDB4470	109778	166	0.863248	1.43299168	Gemmatimonadetes bacterium T265	2839016	Bacteria	Bacteria	71.6	1.13e-13	NR	GJG88110.1	2839016	g108623	i0	84.1	0.795180722891566	44	7	79.5	0	2	133	144	187	GJG88110.1 hypothetical protein tb265_32910 [Gemmatimonadetes bacterium T265]	diamond	132	71.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadetes bacterium T265
32182253	32182253	PRJDB4470_P_NODE_86678_length_188_cov_0.892086_g85523_i0	PRJDB4470	86678	188	0.892086	1.67712168	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	41.6	0.0402	NR	HEY6222781.1	2448054	g85523	i0	44.9	0.781914893617021	49	22	78.2	1	8	154	105	148	HEY6222781.1 transporter [Gemmatimonadales bacterium]	diamond	147	41.6	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);;