metadata: contig_metadata: 5 rows where bioproject = "PRJNA657343", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA657343", tax_kingdom = "Pseudomonadati" 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
21025635	21025635	PRJNA657343_P_NODE_38237_length_167_cov_0.881356_g38213_i0	PRJNA657343	38237	167	0.881356	1.47186452	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	87.4	2.37e-18	NR	HEX2692510.1	2026741	g38213	i0	81.3	16.3293413173653	48	9	86.2	0	21	164	159	206	HEX2692510.1 L-glutamate gamma-semialdehyde dehydrogenase [Gemmatimonadaceae bacterium]	diamond	2727	87.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
26681989	26681989	PRJNA657343_P_NODE_44521_length_162_cov_0.920354_g44497_i0	PRJNA657343	44521	162	0.920354	1.49097348	Bacteria	2	Bacteria	Bacteria	48.9	7.08e-5	NR	HTR79696.1	2026741	g44497	i0	47.7	4.40740740740741	44	23	81.5	0	3	134	132	175	HTR79696.1 CAP domain-containing protein [Gemmatimonadaceae bacterium]	diamond	714	48.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
27018046	27018046	PRJNA657343_P_NODE_26302_length_188_cov_1.093525_g26278_i0	PRJNA657343	26302	188	1.093525	2.055827	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	72.4	6.06e-13	NR	MEZ4425532.1	2026742	g26278	i0	48.3	3.82978723404255	60	31	95.7	0	3	182	206	265	MEZ4425532.1 FAD-dependent oxidoreductase [Gemmatimonadota bacterium]	diamond	720	72.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
27112811	27112811	PRJNA657343_P_NODE_6882_length_308_cov_2.196911_g6858_i0	PRJNA657343	6882	308	2.196911	6.76648588	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	48.9	5.45e-4	NR	MBM3956824.1	2026742	g6858	i0	33.7	2.62987012987013	98	61	95.5	3	4	297	124	217	MBM3956824.1 tandem-95 repeat protein [Gemmatimonadota bacterium]	diamond	810	48.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
32041296	32041296	PRJNA657343_P_NODE_44678_length_162_cov_0.920354_g44654_i0	PRJNA657343	44678	162	0.920354	1.49097348	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	42.4	0.00577	NR	MBW7934580.1	2026741	g44654	i0	54.3	1.2962962962963	35	16	64.8	0	6	110	36	70	MBW7934580.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	210	42.4	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);;