metadata: contig_metadata: 12 rows where bioproject = "PRJNA665531" and tax

12 rows where bioproject = "PRJNA665531" and tax_clade = "PVC group"

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
1905285	1905285	PRJNA665531_P_NODE_10862_length_316_cov_1.473251_g10626_i0	PRJNA665531	10862	316	1.473251	4.65547316	Gemmataceae bacterium	2052164	Bacteria	Bacteria	562	1.11e-155	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g10626	i0	98.734	115.398734177215	316	4	100	0	1	316	319083	318768	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	36466	562	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
1905423	1905423	PRJNA665531_P_NODE_17762_length_248_cov_0.880000_g17526_i0	PRJNA665531	17762	248	0.88	2.1824	Pirellulales bacterium	2715253	Bacteria	Bacteria	156	3.51e-45	NR	HTU25858.1	2715253	g17526	i0	89	1.98387096774194	82	9	99.2	0	2	247	25	106	HTU25858.1 50S ribosomal protein L2 [Pirellulales bacterium]	diamond	492	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
7007970	7007970	PRJNA665531_P_NODE_17506_length_249_cov_0.875000_g17270_i0	PRJNA665531	17506	249	0.875	2.17875	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	155	6.82e-42	NR	MBX3357020.1	2026777	g17270	i0	92.8	2	83	6	100	0	1	249	338	420	MBX3357020.1 ATP-dependent zinc metalloprotease FtsH [Phycisphaeraceae bacterium]	diamond	498	155	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
13383634	13383634	PRJNA665531_P_NODE_9231_length_345_cov_1.132353_g8995_i0	PRJNA665531	9231	345	1.132353	3.90661785	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	385	2.83e-102	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g8995	i0	89.068	71.1536231884058	311	32	90	1	37	345	3990870	3990560	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	24548	385	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
19756099	19756099	PRJNA665531_P_NODE_10736_length_318_cov_1.065306_g10500_i0	PRJNA665531	10736	318	1.065306	3.38767308	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	492	1.48e-134	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g10500	i0	94.671	116.64465408805	319	14	100	3	1	318	2834193	2834509	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	37093	492	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
19756463	19756463	PRJNA665531_P_NODE_676_length_1343_cov_5.033858_g590_i0	PRJNA665531	676	1343	5.033858	67.60471294	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1267	0	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g590	i0	85.62	478.580789277736	1217	164	90	11	126	1337	2583090	2584300	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	642734	1267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21031805	21031805	PRJNA665531_P_NODE_14597_length_271_cov_1.555556_g14361_i0	PRJNA665531	14597	271	1.555556	4.21555676	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	95.3	4.07e-15	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g14361	i0	74.088	3.65682656826568	274	52	98	18	1	265	5627246	5626983	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	991	95.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
27049971	27049971	PRJNA665531_P_NODE_13562_length_281_cov_1.927885_g13326_i0	PRJNA665531	13562	281	1.927885	5.41735685	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	105	3.85e-24	NR	WP_059062089.1	389348	g13326	i0	55.2	0.928825622775801	87	39	92.9	0	278	18	586	672	WP_059062089.1 penicillin-binding transpeptidase domain-containing protein [Candidatus Protochlamydia naegleriophila]	diamond	261	105	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
29512848	29512848	PRJNA665531_P_NODE_17070_length_251_cov_0.865169_g16834_i0	PRJNA665531	17070	251	0.865169	2.17157419	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	94.7	2.13e-20	NR	HMN39257.1	2052180	g16834	i0	62.4	1.01593625498008	85	29	99.2	2	251	3	1145	1228	HMN39257.1 ATP-dependent RNA helicase HrpA [Phycisphaerales bacterium]	diamond	255	94.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29544425	29544425	PRJNA665531_P_NODE_18190_length_246_cov_0.890173_g17954_i0	PRJNA665531	18190	246	0.890173	2.18982558	Planctomycetota bacterium	2026780	Bacteria	Bacteria	140	1.4299999999999998e-37	NR	MEK6643633.1	2026780	g17954	i0	81.5	1.96341463414634	81	15	98.8	0	3	245	275	355	MEK6643633.1 site-specific integrase [Planctomycetota bacterium]	diamond	483	140	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32579375	32579375	PRJNA665531_P_NODE_17499_length_249_cov_0.875000_g17263_i0	PRJNA665531	17499	249	0.875	2.17875	Gemmata sp.	1914242	Bacteria	Bacteria	83.2	2.25e-16	NR	HEV3436776.1	1914242	g17263	i0	57.8	1	83	31	97.6	2	248	6	365	445	HEV3436776.1 HEAT repeat domain-containing protein [Gemmata sp.]	diamond	249	83.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
32862533	32862533	PRJNA665531_P_NODE_17960_length_247_cov_0.885057_g17724_i0	PRJNA665531	17960	247	0.885057	2.18609079	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.00503	NR	MEM9353643.1	2026780	g17724	i0	45.5	0.40080971659919	33	18	40.1	0	78	176	48	80	MEM9353643.1 hypothetical protein [Planctomycetota bacterium]	diamond	99	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;