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

10 rows where bioproject = "PRJNA1034995" 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
3995111	3995111	PRJNA1034995_S_NODE_51644_length_159_cov_2.775862_g51488_i0	PRJNA1034995	51644	159	2.775862	4.41362058	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	195	2.07e-45	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g51488	i0	92.593	28.3207547169811	135	10	85	0	3	137	3991031	3990897	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	4503	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
6546643	6546643	PRJNA1034995_S_NODE_54106_length_152_cov_3.935780_g53950_i0	PRJNA1034995	54106	152	3.93578	5.9823856	Pedosphaera parvula	1032527	Bacteria	Bacteria	204	3.2399999999999996e-48	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g53950	i0	90.85	81.6710526315789	153	12	100	2	1	152	1240	1089	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	12414	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
11647085	11647085	PRJNA1034995_S_NODE_41150_length_199_cov_6.134615_g40994_i0	PRJNA1034995	41150	199	6.134615	12.20788385	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	311	2.58e-80	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g40994	i0	98.851	21.7638190954774	174	2	87	0	1	174	3557873	3558046	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	4331	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
15471337	15471337	PRJNA1034995_S_NODE_34153_length_239_cov_4.362245_g33997_i0	PRJNA1034995	34153	239	4.362245	10.42576555	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	307	4.15e-79	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g33997	i0	92.523	239.983263598326	214	16	90	0	1	214	28254	28467	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	57356	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18020278	18020278	PRJNA1034995_S_NODE_27595_length_291_cov_11.217742_g27439_i0	PRJNA1034995	27595	291	11.217742	32.64362922	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	219	2.5099999999999998e-52	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g27439	i0	85.854	1.19587628865979	205	29	70	0	59	263	1351055	1350851	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	348	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
20569684	20569684	PRJNA1034995_S_NODE_39797_length_206_cov_2.257669_g39641_i0	PRJNA1034995	39797	206	2.257669	4.65079814	Aquisphaera giovannonii	406548	Bacteria	Bacteria	65.8	2.31e-6	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g39641	i0	97.436	0.189320388349515	39	0	18	1	127	164	1166166	1166204	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	39	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
21845298	21845298	PRJNA1034995_S_NODE_24358_length_324_cov_12.601423_g24202_i0	PRJNA1034995	24358	324	12.601423	40.82861052	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	91.6	6.45e-14	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g24202	i0	88.312	25.820987654321	77	7	31	2	176	251	4377695	4377620	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	8366	91.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
30216649	30216649	PRJNA1034995_S_NODE_33352_length_244_cov_16.457711_g33196_i0	PRJNA1034995	33352	244	16.457711	40.15681484	Bacteria	2	Bacteria	Bacteria	120	7.880000000000001e-33	NR	MBI2814774.1	2026771	g33196	i0	77.6	1.81967213114754	76	17	93.4	0	242	15	3	78	MBI2814774.1 GxxExxY protein [Opitutia bacterium]	diamond	444	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
30698589	30698589	PRJNA1034995_S_NODE_44854_length_183_cov_2.235714_g44698_i0	PRJNA1034995	44854	183	2.235714	4.09135662	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0427	NR	MBZ0151840.1	2026780	g44698	i0	35.7	0.688524590163934	42	27	68.9	0	19	144	121	162	MBZ0151840.1 ABC transporter permease [Planctomycetota bacterium]	diamond	126	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31489086	31489086	PRJNA1034995_S_NODE_43116_length_190_cov_4.564626_g42960_i0	PRJNA1034995	43116	190	4.564626	8.6727894	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0303	NR	TET35009.1	2026780	g42960	i0	38.9	0.568421052631579	36	22	56.8	0	120	13	23	58	TET35009.1 MAG: hypothetical protein E3J72_12805 [Planctomycetota bacterium]	diamond	108	42	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);;