metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1034995" and tax

7 rows where analysis = "blastn", 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

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);;