metadata: contig_metadata: 7 rows where bioproject = "PRJNA513467", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJNA513467", tax_clade = "PVC group" and tax_kingdom = "Pseudomonadati"

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
5590529	5590529	PRJNA513467_S_NODE_7425_length_157_cov_1.300000_g7402_i0	PRJNA513467	7425	157	1.3	2.041	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	230	5.58e-56	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g7402	i0	95.205	110.910828025478	146	6	92	1	9	153	7051451	7051596	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	17413	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14515586	14515586	PRJNA513467_S_NODE_1872_length_259_cov_2.004505_g1849_i0	PRJNA513467	1872	259	2.004505	5.19166795	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	263	1e-65	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g1849	i0	88.636	170.200772200772	220	19	83	6	44	259	7050446	7050229	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	44082	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15138951	15138951	PRJNA513467_S_NODE_2892_length_219_cov_4.060440_g2869_i0	PRJNA513467	2892	219	4.06044	8.8923636	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	122	7.7699999999999995e-31	NR	MCE2925315.1	2026777	g2869	i0	79.2	0.986301369863014	72	15	98.6	0	218	3	227	298	MCE2925315.1 class II fumarate hydratase [Phycisphaeraceae bacterium]	diamond	216	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
18338323	18338323	PRJNA513467_S_NODE_2715_length_224_cov_2.754011_g2692_i0	PRJNA513467	2715	224	2.754011	6.16898464	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	316	6.39e-82	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g2692	i0	92.444	79.4151785714286	225	12	99	5	3	224	1829857	1830079	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	17789	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
21512839	21512839	PRJNA513467_S_NODE_1077_length_322_cov_2.449123_g1054_i0	PRJNA513467	1077	322	2.449123	7.88617606	Schlesneria	656899	Bacteria	Bacteria	398	3.3699999999999992e-106	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g1054	i0	89.097	132.937888198758	321	32	99	3	3	322	754	1072	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	42806	401	0.992518703241895	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
27155371	27155371	PRJNA513467_S_NODE_1542_length_279_cov_3.004132_g1519_i0	PRJNA513467	1542	279	3.004132	8.38152828	Bacteria	2	Bacteria	Bacteria	132	1.81e-33	NR	HSX10464.1	2047757	g1519	i0	75.7	2.41935483870968	74	18	79.6	0	226	5	823	896	HSX10464.1 excinuclease ABC subunit UvrA [Chlamydiales bacterium]	diamond	675	132	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29966265	29966265	PRJNA513467_S_NODE_1491_length_283_cov_1.890244_g1468_i0	PRJNA513467	1491	283	1.890244	5.34939052	Bacteria	2	Bacteria	Bacteria	74.3	3.51e-13	NR	MDB6124125.1	2024890	g1468	i0	52.1	7.70671378091873	73	33	77.4	2	6	224	298	368	MDB6124125.1 hypothetical protein [Pedosphaera sp.]	diamond	2181	74.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.

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);;