metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1050291" and tax

7 rows where analysis = "diamond", 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
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);;