metadata: contig_metadata: 10 rows where bioproject = "PRJNA806354" and tax

10 rows where bioproject = "PRJNA806354" 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
3357031	3357031	PRJNA806354_P_NODE_4103_length_669_cov_2.927852_g3996_i0	PRJNA806354	4103	669	2.927852	19.58732988	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1098	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g3996	i0	96.263	262.866965620329	669	25	100	0	1	669	861	193	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	175858	1098	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
11009956	11009956	PRJNA806354_P_NODE_41549_length_239_cov_5.548193_g41440_i0	PRJNA806354	41549	239	5.548193	13.26018127	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	425	1.1e-114	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g41440	i0	98.745	267.97489539749	239	3	100	0	1	239	2190	2428	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	64046	425	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
12285480	12285480	PRJNA806354_P_NODE_38390_length_245_cov_2.470930_g38281_i0	PRJNA806354	38390	245	2.47093	6.0537785	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	318	1.9699999999999998e-82	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g38281	i0	92.07	109.028571428571	227	16	93	2	1	227	2582744	2582968	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	26712	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
13559716	13559716	PRJNA806354_P_NODE_9271_length_460_cov_3.713178_g9162_i0	PRJNA806354	9271	460	3.713178	17.0806188	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	649	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g9162	i0	92.157	246.408695652174	459	36	99	0	1	459	2192048	2192506	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	113348	649	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
16108548	16108548	PRJNA806354_P_NODE_40593_length_242_cov_0.911243_g40484_i0	PRJNA806354	40593	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	130	5.06e-33	NR	WP_007279800.1	256847	g40484	i0	75.6	417.520661157025	78	19	96.7	0	7	240	631	708	WP_007279800.1 ATP-dependent chaperone ClpB [Lentisphaera araneosa]	diamond	101040	130	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera araneosa
22483011	22483011	PRJNA806354_P_NODE_39578_length_243_cov_7.982353_g39469_i0	PRJNA806354	39578	243	7.982353	19.39711779	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g39469	i0	100	262.777777777778	243	0	100	0	1	243	2384	2626	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	63855	449	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
23758753	23758753	PRJNA806354_P_NODE_6519_length_541_cov_4.720085_g6410_i0	PRJNA806354	6519	541	4.720085	25.53565985	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	706	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g6410	i0	90.538	95.1700554528651	539	43	99	8	3	537	2190679	2190145	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	51487	706	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27243785	27243785	PRJNA806354_P_NODE_28923_length_275_cov_2.920792_g28814_i0	PRJNA806354	28923	275	2.920792	8.032178	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.7	0.0104	NR	MEM7518636.1	2026780	g28814	i0	58.3	0.392727272727273	36	15	39.3	0	27	134	4	39	MEM7518636.1 DUF1601 domain-containing protein [Planctomycetota bacterium]	diamond	108	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29201674	29201674	PRJNA806354_P_NODE_41349_length_241_cov_0.916667_g41240_i0	PRJNA806354	41349	241	0.916667	2.20916747	Omnitrophica bacterium RIFCSPHIGHO2_	2035772	Bacteria	Bacteria	74.7	3.64e-15	NR	OGW83799.1	1801823	g41240	i0	57.7	0.647302904564315	52	22	64.7	0	2	157	61	112	OGW83799.1 MAG: hypothetical protein A3C47_04815 [Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_51_18]	diamond	156	74.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_51_18
32362328	32362328	PRJNA806354_P_NODE_38259_length_246_cov_0.890173_g38150_i0	PRJNA806354	38259	246	0.890173	2.18982558	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	154	5.02e-44	NR	MDE2028918.1	2035772	g38150	i0	92.5	1.95121951219512	80	6	97.6	0	4	243	183	262	MDE2028918.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatA [Candidatus Omnitrophota bacterium]	diamond	480	154	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota 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);;