metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA700095" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA700095" 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
683127	683127	PRJNA700095_P_NODE_11841_length_557_cov_3.549587_g10594_i0	PRJNA700095	11841	557	3.549587	19.77119959	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	817	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g10594	i0	93.369	170.662477558348	558	28	99	8	1	555	1727991	1728542	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	95059	817	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5786656	5786656	PRJNA700095_P_NODE_28905_length_316_cov_2.041152_g27641_i0	PRJNA700095	28905	316	2.041152	6.45004032	Candidatus Euplotechlamydia quinta	2936506	Bacteria	Bacteria	486	6.849999999999999e-133	NTclustered	gi\|2226301499\|gb\|ON271409.1\|	2936506	g27641	i0	94.603	99.4272151898734	315	16	99	1	3	316	13	327	Chlamydiia bacterium (ex Euplotes octocarinatus) isolate Zam5b-1 16S ribosomal RNA gene, partial sequence	blastn	31419	486	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Euplotechlamydia	Candidatus Euplotechlamydia quinta
7061746	7061746	PRJNA700095_P_NODE_28426_length_319_cov_3.004065_g27162_i0	PRJNA700095	28426	319	3.004065	9.58296735	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	385	2.5999999999999995e-102	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g27162	i0	88.401	56.9843260188088	319	37	100	0	1	319	2149471	2149789	Opitutaceae bacterium TAV5, complete genome	blastn	18178	385	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
7061986	7061986	PRJNA700095_P_NODE_8906_length_659_cov_6.843003_g7708_i0	PRJNA700095	8906	659	6.843003	45.09538977	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	1000	0	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g7708	i0	94.118	111.784522003035	663	30	100	7	1	659	1903714	1903057	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	73666	1000	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
13436982	13436982	PRJNA700095_P_NODE_44991_length_264_cov_1.261780_g43727_i0	PRJNA700095	44991	264	1.26178	3.3310992	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	409	1.2399999999999998e-109	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g43727	i0	94.677	86.8825757575758	263	14	99	0	1	263	1315086	1315348	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	22937	409	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13436985	13436985	PRJNA700095_P_NODE_46391_length_261_cov_1.207447_g45127_i0	PRJNA700095	46391	261	1.207447	3.15143667	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	248	2.8299999999999997e-61	NTclustered	gi\|1966856672\|gb\|CP068477.1\|	1903058	g45127	i0	86.463	122.272030651341	229	27	87	4	28	255	906781	907006	MAG: Candidatus Xiphinematobacter sp. isolate P15 chromosome, complete genome	blastn	31913	248	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
15985859	15985859	PRJNA700095_P_NODE_48933_length_255_cov_2.642857_g47669_i0	PRJNA700095	48933	255	2.642857	6.73928535	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	169	2.2e-37	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g47669	i0	81.481	74.4156862745098	216	31	83	9	42	252	1641727	1641516	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	18976	169	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
17761966	17761966	PRJNA700095_P_NODE_18034_length_422_cov_6.283668_g16771_i0	PRJNA700095	18034	422	6.283668	26.51707896	Verrucomicrobiota	74201	Bacteria	Bacteria	680	0	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g16771	i0	95.735	50.7630331753555	422	18	100	0	1	422	2926	3347	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	21422	686	0.991253644314869	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
21085502	21085502	PRJNA700095_P_NODE_16977_length_439_cov_4.346995_g15714_i0	PRJNA700095	16977	439	4.346995	19.08330805	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	573	7.319999999999998e-159	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g15714	i0	90.531	106.649202733485	433	41	99	0	1	433	1903819	1904251	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	46819	573	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
21085588	21085588	PRJNA700095_P_NODE_35797_length_287_cov_1.294393_g34533_i0	PRJNA700095	35797	287	1.294393	3.71490791	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	490	4.749999999999998e-134	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g34533	i0	98.214	113.505226480836	280	5	98	0	8	287	2497085	2497364	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	32576	490	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
22360494	22360494	PRJNA700095_P_NODE_58538_length_246_cov_0.867052_g57274_i0	PRJNA700095	58538	246	0.867052	2.13294792	Humisphaera borealis	2807512	Bacteria	Bacteria	348	2.53e-91	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g57274	i0	92.245	126.089430894309	245	19	99	0	1	245	5064312	5064556	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	31018	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis

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