metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA781196" 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
759289	759289	PRJNA781196_P_NODE_40261_length_282_cov_1.492823_g39884_i0	PRJNA781196	40261	282	1.492823	4.20976086	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	514	2.76e-141	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g39884	i0	99.644	259.617021276596	281	1	99	0	2	282	4722	4442	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	73212	514	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
2035312	2035312	PRJNA781196_P_NODE_38122_length_289_cov_1.083333_g37745_i0	PRJNA781196	38122	289	1.083333	3.13083237	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	462	1.04e-125	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g37745	i0	95.517	142.826989619377	290	12	100	1	1	289	3046326	3046615	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	41277	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
2486731	2486731	PRJNA781196_P_NODE_41422_length_278_cov_1.575610_g41045_i0	PRJNA781196	41422	278	1.57561	4.3801958	Planctomycetia	203683	Bacteria	Bacteria	377	3.72e-100	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g41045	i0	91.336	97.276978417266207	277	23	99	1	1	277	1454	1179	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	27043	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
3310179	3310179	PRJNA781196_P_NODE_15283_length_422_cov_1.315186_g14906_i0	PRJNA781196	15283	422	1.315186	5.55008492	Urbifossiella limnaea	2528023	Bacteria	Bacteria	483	1.22e-131	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g14906	i0	88.557	167.5663507109	402	41	95	5	23	422	4212047	4212445	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	70713	483	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
4587379	4587379	PRJNA781196_P_NODE_2564_length_921_cov_2.520047_g2282_i0	PRJNA781196	2564	921	2.520047	23.20963287	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1212	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g2282	i0	90.635	366.972855591748	929	63	99	15	1	912	5935886	5936807	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	337982	1212	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4587880	4587880	PRJNA781196_P_NODE_58104_length_248_cov_0.891429_g57727_i0	PRJNA781196	58104	248	0.891429	2.21074392	Chthoniobacter flavus	191863	Bacteria	Bacteria	368	1.96e-97	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g57727	i0	95.279	270.915322580645	233	10	94	1	1	233	2418	2187	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	67187	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
8412048	8412048	PRJNA781196_P_NODE_11527_length_477_cov_1.351485_g11151_i0	PRJNA781196	11527	477	1.351485	6.44658345	planctomycete str. 139	149588	Bacteria	Bacteria	664	0	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g11151	i0	91.824	147.176100628931	477	36	99	3	3	477	10	485	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	70203	664	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
9687630	9687630	PRJNA781196_P_NODE_29408_length_323_cov_1.136000_g29031_i0	PRJNA781196	29408	323	1.136	3.66928	Urbifossiella limnaea	2528023	Bacteria	Bacteria	403	7.27e-108	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g29031	i0	89.873	100.452012383901	316	28	98	4	4	317	2019862	2019549	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	32446	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
13513593	13513593	PRJNA781196_P_NODE_6671_length_603_cov_3.562264_g6297_i0	PRJNA781196	6671	603	3.562264	21.48045192	Urbifossiella limnaea	2528023	Bacteria	Bacteria	667	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6297	i0	86.601	192.860696517413	612	72	100	4	1	603	2018886	2018276	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	116295	667	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
18611049	18611049	PRJNA781196_P_NODE_48235_length_257_cov_1.695652_g47858_i0	PRJNA781196	48235	257	1.695652	4.35782564	Planctomycetales bacterium ZRK34	2723666	Bacteria	Bacteria	126	1.36e-24	NTclustered	gi\|1898316769\|gb\|CP050848.1\|	2723666	g47858	i0	92.135	2.91828793774319	89	7	35	0	6	94	3919915	3919827	Planctomycetales bacterium ZRK34 chromosome, complete genome	blastn	750	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium ZRK34
19062925	19062925	PRJNA781196_P_NODE_28135_length_329_cov_1.046875_g27758_i0	PRJNA781196	28135	329	1.046875	3.44421875	Gemmataceae	1914233	Bacteria	Bacteria	303	7.74e-78	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g27758	i0	83.582	119.334346504559	335	43	100	10	1	329	2017989	2017661	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	39261	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
19886487	19886487	PRJNA781196_P_NODE_59996_length_246_cov_1.676301_g59619_i0	PRJNA781196	59996	246	1.676301	4.12370046	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g59619	i0	98.78	98.7845528455285	246	3	100	0	1	246	869	624	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	24301	438	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22437074	22437074	PRJNA781196_P_NODE_66998_length_242_cov_0.923077_g66621_i0	PRJNA781196	66998	242	0.923077	2.23384634	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g66621	i0	99.587	47.3140495867769	242	1	100	0	1	242	265463	265704	Tautonia plasticadhaerens strain ElP chromosome	blastn	11450	442	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
24985968	24985968	PRJNA781196_P_NODE_4960_length_690_cov_2.439222_g4599_i0	PRJNA781196	4960	690	2.439222	16.8306318	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	804	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g4599	i0	87.767	116.408695652174	703	67	100	14	1	690	1599860	1599164	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	80322	804	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
24986064	24986064	PRJNA781196_P_NODE_5560_length_655_cov_1.625430_g5194_i0	PRJNA781196	5560	655	1.62543	10.6465665	planctomycete str. 139	149588	Bacteria	Bacteria	835	0	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g5194	i0	89.802	157.317557251908	657	59	99	7	2	655	2850	2199	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	103043	835	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139

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