metadata: contig_metadata: 14 rows where bioproject = "PRJNA1050291" and tax

14 rows where bioproject = "PRJNA1050291" 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
2726566	2726566	PRJNA1050291_P_NODE_2463_length_1693_cov_4.262963_g1690_i0	PRJNA1050291	2463	1693	4.262963	72.17196359	Chlamydiales bacterium	2047757	Bacteria	Bacteria	546	1.5299999999999998e-185	NR	HEV7738334.1	2047757	g1690	i0	53.6	0.898405197873597	507	227	89	3	5	1510	7	510	HEV7738334.1 transposase [Chlamydiales bacterium]	diamond	1521	546	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
7828647	7828647	PRJNA1050291_P_NODE_21947_length_231_cov_2.189873_g21056_i0	PRJNA1050291	21947	231	2.189873	5.05860663	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g21056	i0	100	1	231	0	100	0	1	231	1407857	1408087	Parachlamydia acanthamoebae UV-7, complete genome	blastn	231	427	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
9103483	9103483	PRJNA1050291_P_NODE_13988_length_299_cov_1.623894_g13097_i0	PRJNA1050291	13988	299	1.623894	4.85544306	Mucisphaera calidilacus	2527982	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1712644202\|gb\|CP036280.1\|	2527982	g13097	i0	100	0.0936454849498328	28	0	9	0	49	76	1244494	1244467	Mucisphaera calidilacus strain Pan265 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Mucisphaera	Mucisphaera calidilacus
10379451	10379451	PRJNA1050291_P_NODE_4929_length_708_cov_4.817323_g4041_i0	PRJNA1050291	4929	708	4.817323	34.10664684	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	1303	0	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g4041	i0	99.859	1	708	1	100	0	1	708	137283	137990	Parachlamydia acanthamoebae UV-7, complete genome	blastn	708	1303	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
12490012	12490012	PRJNA1050291_P_NODE_8830_length_426_cov_5.158640_g7939_i0	PRJNA1050291	8830	426	5.15864	21.9758064	Parachlamydia	83551	Bacteria	Bacteria	787	0	NTclustered	gi\|589811296\|dbj\|AB812094.1\|	83552	g7939	i0	100	113.800469483568	426	0	100	0	1	426	551	126	Parachlamydia acanthamoebae gene for 16S ribosomal RNA, partial sequence, strain: Leol	blastn	48479	787	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
16752905	16752905	PRJNA1050291_P_NODE_17914_length_254_cov_2.121547_g17023_i0	PRJNA1050291	17914	254	2.121547	5.38872938	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	270	5.8499999999999984e-68	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g17023	i0	99.329	1.02362204724409	149	1	100	0	106	254	2118128	2117980	Parachlamydia acanthamoebae UV-7, complete genome	blastn	260	270	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
19301553	19301553	PRJNA1050291_P_NODE_10596_length_368_cov_2.410169_g9705_i0	PRJNA1050291	10596	368	2.410169	8.86942192	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	680	0	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g9705	i0	100	1	368	0	100	0	1	368	2513245	2512878	Parachlamydia acanthamoebae UV-7, complete genome	blastn	368	680	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
20577208	20577208	PRJNA1050291_P_NODE_4937_length_707_cov_6.397476_g4049_i0	PRJNA1050291	4937	707	6.397476	45.23015532	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	1306	0	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g4049	i0	100	1.3041018387553	707	0	100	0	1	707	2517991	2518697	Parachlamydia acanthamoebae UV-7, complete genome	blastn	922	1306	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
26615510	26615510	PRJNA1050291_P_NODE_14921_length_286_cov_1.352113_g14030_i0	PRJNA1050291	14921	286	1.352113	3.86704318	Pseudomonadati	3379134	Bacteria	Bacteria	68.2	6.99e-11	NR	HEV3203136.1	2052164	g14030	i0	52.5	1.52097902097902	59	28	61.9	0	180	4	108	166	HEV3203136.1 class I SAM-dependent methyltransferase [Gemmataceae bacterium]	diamond	435	68.6	0.994169096209913	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27951403	27951403	PRJNA1050291_P_NODE_19645_length_247_cov_0.896552_g18754_i0	PRJNA1050291	19645	247	0.896552	2.21448344	Haloferula sargassicola	490096	Bacteria	Bacteria	61.6	7.6e-9	NR	WP_353566207.1	490096	g18754	i0	45.6	1.93117408906883	79	43	96	0	8	244	20	98	WP_353566207.1 hypothetical protein [Haloferula sargassicola]	diamond	477	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sargassicola
28961942	28961942	PRJNA1050291_P_NODE_13288_length_310_cov_6.130802_g12397_i0	PRJNA1050291	13288	310	6.130802	19.0054862	Pirellulales bacterium	2715253	Bacteria	Bacteria	45.4	0.00912	NR	MBN2290920.1	2715253	g12397	i0	59.1	0.425806451612903	44	18	42.6	0	134	3	451	494	MBN2290920.1 hypothetical protein [Pirellulales bacterium]	diamond	132	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
29655898	29655898	PRJNA1050291_P_NODE_10890_length_361_cov_0.885417_g9999_i0	PRJNA1050291	10890	361	0.885417	3.19635537	Candidatus Didemnitutus sp.	2814259	Bacteria	Bacteria	189	1.31e-57	NR	HVU15522.1	2814259	g9999	i0	77.5	1.98614958448753	120	27	99.7	0	361	2	144	263	HVU15522.1 hypothetical protein [Candidatus Didemnitutus sp.]	diamond	717	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Candidatus Didemnitutus	Candidatus Didemnitutus sp.
30185101	30185101	PRJNA1050291_P_NODE_14092_length_297_cov_2.075893_g13201_i0	PRJNA1050291	14092	297	2.075893	6.16540221	Bacteria	2	Bacteria	Bacteria	67	4.25e-11	NR	MFA5251620.1	2026778	g13201	i0	44.3	1.94949494949495	97	51	98	2	292	2	86	179	MFA5251620.1 AP2 domain-containing protein [Phycisphaerae bacterium]	diamond	579	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31995171	31995171	PRJNA1050291_P_NODE_18978_length_250_cov_0.881356_g18087_i0	PRJNA1050291	18978	250	0.881356	2.20339	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.5	1.87e-9	NR	MCH7988511.1	2026780	g18087	i0	35.4	0.984	82	53	98.4	0	248	3	152	233	MCH7988511.1 hypothetical protein [Planctomycetota bacterium]	diamond	246	63.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);;