metadata: contig_metadata: 9 rows where bioproject = "PRJNA1073712" and tax

9 rows where bioproject = "PRJNA1073712" 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
2291583	2291583	PRJNA1073712_P_NODE_8002_length_282_cov_1.473684_g7919_i0	PRJNA1073712	8002	282	1.473684	4.15578888	Singulisphaera	466152	Bacteria	Bacteria	318	2.32e-82	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g7919	i0	87.189	75.031914893617	281	34	99	2	4	282	4644971	4645251	Singulisphaera acidiphila DSM 18658, complete genome	blastn	21159	320	0.99375	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
5290412	5290412	PRJNA1073712_P_NODE_16365_length_242_cov_0.911243_g16282_i0	PRJNA1073712	16365	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	154	1.52e-41	NR	HEX2475483.1	2691534	g16282	i0	95	5.93801652892562	80	4	99.2	0	2	241	416	495	HEX2475483.1 excinuclease ABC subunit UvrA [Lacipirellulaceae bacterium]	diamond	1437	155	0.993548387096774	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
7840230	7840230	PRJNA1073712_P_NODE_16847_length_241_cov_0.916667_g16764_i0	PRJNA1073712	16847	241	0.916667	2.20916747	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	401	1.8699999999999993e-107	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g16764	i0	96.68	154.211618257261	241	8	100	0	1	241	2002347	2002587	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	37165	401	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7840244	7840244	PRJNA1073712_P_NODE_3527_length_374_cov_2.262458_g3444_i0	PRJNA1073712	3527	374	2.262458	8.46159292	uncultured Opitutia bacterium	575426	Bacteria	Bacteria	689	0	NTclustered	gi\|523452328\|gb\|KF182748.1\|	575426	g3444	i0	100	99.6390374331551	373	0	99	0	1	373	870	498	Uncultured Opitutae bacterium clone S1-003 16S ribosomal RNA gene, partial sequence	blastn	37265	689	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				uncultured Opitutia bacterium
12941360	12941360	PRJNA1073712_P_NODE_16571_length_241_cov_1.595238_g16488_i0	PRJNA1073712	16571	241	1.595238	3.84452358	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	337	5.35e-88	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g16488	i0	92.437	131.900414937759	238	15	98	3	1	237	267483	267248	Tautonia plasticadhaerens strain ElP chromosome	blastn	31788	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
23968530	23968530	PRJNA1073712_P_NODE_10059_length_261_cov_1.670213_g9976_i0	PRJNA1073712	10059	261	1.670213	4.35925593	Isosphaeraceae	1763524	Bacteria	Bacteria	449	7.22e-122	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g9976	i0	97.701	172.750957854406	261	6	100	0	1	261	5180413	5180673	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	45088	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
24413499	24413499	PRJNA1073712_P_NODE_15000_length_244_cov_0.900585_g14917_i0	PRJNA1073712	15000	244	0.900585	2.1974274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	219	2.05e-52	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g14917	i0	83.333	116.274590163934	246	32	99	8	2	242	2001830	2002071	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	28371	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
27636214	27636214	PRJNA1073712_P_NODE_1684_length_482_cov_1.555012_g1601_i0	PRJNA1073712	1684	482	1.555012	7.49515784	Puniceicoccales bacterium	2478473	Bacteria	Bacteria	52.8	1.12e-4	NR	MDR1434996.1	2478473	g1601	i0	32.8	1.5746887966805	125	70	73.4	5	369	16	90	207	MDR1434996.1 glycosyltransferase family 8 protein [Puniceicoccales bacterium]	diamond	759	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales			Puniceicoccales bacterium
30722285	30722285	PRJNA1073712_P_NODE_14274_length_245_cov_1.709302_g14191_i0	PRJNA1073712	14274	245	1.709302	4.1877899	Pseudomonadati	3379134	Bacteria	Bacteria	146	8.329999999999999e-40	NR	NDG63003.1	2026780	g14191	i0	82.7	17.8530612244898	81	14	99.2	0	1	243	221	301	NDG63003.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Planctomycetota bacterium]	diamond	4374	147	0.993197278911565	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);;