metadata: contig_metadata: 5 rows where bioproject = "PRJNA283169", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA283169", 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
20185057	20185057	PRJNA283169_S_NODE_916_length_275_cov_0.163717_g902_i0	PRJNA283169	916	275	0.163717	0.45022175	Gemmatimonas	173479	Bacteria	Bacteria	108	5.32e-19	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g902	i0	92.105	3.46545454545455	76	6	28	0	48	123	972680	972605	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	953	108	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	uncultured Gemmatimonadaceae bacterium
29127022	29127022	PRJNA283169_P_NODE_3849_length_213_cov_0.945122_g3786_i0	PRJNA283169	3849	213	0.945122	2.01310986	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	88.6	1.52e-19	NR	TFG61846.1	2448054	g3786	i0	60.9	0.971830985915493	69	27	97.2	0	1	207	36	104	TFG61846.1 MAG: hypothetical protein E4H28_08345, partial [Gemmatimonadales bacterium]	diamond	207	88.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
29934003	29934003	PRJNA283169_P_NODE_5451_length_183_cov_1.164179_g5388_i0	PRJNA283169	5451	183	1.164179	2.13044757	FCB group	1783270	Bacteria	Bacteria	47	5.02e-4	NR	MCR4341997.1	2026741	g5388	i0	46.6	3.47540983606557	58	31	95.1	0	9	182	68	125	MCR4341997.1 PD-(D/E)XK nuclease-like domain-containing protein [Gemmatimonadaceae bacterium]	diamond	636	47	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
30516437	30516437	PRJNA283169_S_NODE_1393_length_231_cov_0.120879_g1379_i0	PRJNA283169	1393	231	0.120879	0.27923049	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	101	6.1e-23	NR	MBK6423886.1	2026742	g1379	i0	86.2	0.753246753246753	58	8	75.3	0	231	58	174	231	MBK6423886.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	174	101	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
32463109	32463109	PRJNA283169_P_NODE_1899_length_296_cov_0.805668_g1837_i0	PRJNA283169	1899	296	0.805668	2.3847772800000002	Pseudomonadati	3379134	Bacteria	Bacteria	45.8	0.00115	NR	MBA3645311.1	2026741	g1837	i0	60.6	0.628378378378378	33	9	29.4	1	12	98	75	107	MBA3645311.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	186	45.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae 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);;