metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA560932" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA560932" 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
1820298	1820298	PRJNA560932_P_NODE_28482_length_336_cov_3.163498_g28126_i0	PRJNA560932	28482	336	3.163498	10.62935328	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	429	1.2499999999999996e-115	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g28126	i0	91.693	101.889880952381	313	20	91	6	1	307	7051352	7051664	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	34235	429	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1820418	1820418	PRJNA560932_P_NODE_4282_length_825_cov_2.425532_g3978_i0	PRJNA560932	4282	825	2.425532	20.010639	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	1386	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g3978	i0	97.192	111.718787878788	819	23	99	0	7	825	3558031	3557213	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	92168	1386	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
1820432	1820432	PRJNA560932_P_NODE_45722_length_270_cov_1.563452_g45366_i0	PRJNA560932	45722	270	1.563452	4.2213204	Limnoglobus roseus	2598579	Bacteria	Bacteria	464	2.6799999999999994e-126	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g45366	i0	97.77	120.1	269	6	99	0	2	270	2957388	2957120	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	32427	464	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
1820569	1820569	PRJNA560932_P_NODE_6722_length_666_cov_2.156830_g6371_i0	PRJNA560932	6722	666	2.15683	14.3644878	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1081	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g6371	i0	95.946	253.45045045045	666	27	100	0	1	666	194	859	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	168798	1081	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
3095788	3095788	PRJNA560932_P_NODE_58803_length_247_cov_0.885057_g58447_i0	PRJNA560932	58803	247	0.885057	2.18609079	Urbifossiella limnaea	2528023	Bacteria	Bacteria	333	7.119999999999999e-87	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g58447	i0	91.463	184.064777327935	246	15	99	4	2	247	2019352	2019113	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	45464	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
3681890	3681890	PRJNA560932_P_NODE_52503_length_251_cov_0.865169_g52147_i0	PRJNA560932	52503	251	0.865169	2.17157419	Verrucomicrobiota	74201	Bacteria	Bacteria	246	9.72e-61	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g52147	i0	87.156	75.3625498007968	218	27	86	1	35	251	1316133	1315916	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	18916	246	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4372196	4372196	PRJNA560932_P_NODE_48944_length_260_cov_1.459893_g48588_i0	PRJNA560932	48944	260	1.459893	3.7957218	Luteolibacter sp.	1962973	Bacteria	Bacteria	104	6.45e-18	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g48588	i0	86.458	0.830769230769231	96	11	37	2	7	101	2693427	2693333	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	216	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
4372206	4372206	PRJNA560932_P_NODE_50044_length_256_cov_2.311475_g49688_i0	PRJNA560932	50044	256	2.311475	5.917376	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	466	7.01e-127	NTclustered	gi\|312861021\|gb\|HM750069.1\|	156588	g49688	i0	99.608	99.671875	255	1	99	0	2	256	509	255	Uncultured Verrucomicrobia bacterium clone PS06-10-84 16S ribosomal RNA gene, partial sequence	blastn	25516	466	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
6922734	6922734	PRJNA560932_P_NODE_46906_length_267_cov_1.051546_g46550_i0	PRJNA560932	46906	267	1.051546	2.80762782	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	377	3.55e-100	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g46550	i0	92.453	147.101123595506	265	18	99	2	4	267	2002000	2002263	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	39276	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7508535	7508535	PRJNA560932_P_NODE_56166_length_248_cov_1.360000_g55810_i0	PRJNA560932	56166	248	1.36	3.3728	Schlesneria	656899	Bacteria	Bacteria	342	1.1899999999999999e-89	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g55810	i0	93.833	74.1290322580645	227	14	92	0	22	248	6998680	6998906	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	18384	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
8197764	8197764	PRJNA560932_P_NODE_60147_length_246_cov_0.890173_g59791_i0	PRJNA560932	60147	246	0.890173	2.18982558	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	174	4.55e-39	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g59791	i0	81.448	75.8211382113821	221	33	88	8	2	218	7914640	7914856	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	18652	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13298560	13298560	PRJNA560932_P_NODE_17931_length_415_cov_1.669591_g17575_i0	PRJNA560932	17931	415	1.669591	6.92880265	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	209	2.24e-49	NTclustered	gi\|559134048\|tpe\|HG788966.1\|	264201	g17575	i0	81.961	2.60722891566265	255	39	61	7	164	415	143	393	TPA: Candidatus Protochlamydia amoebophila UWE25 transfer-messenger mRNA Proto_amoeb_UWE25, single chain mature transcript	blastn	1082	209	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
13298946	13298946	PRJNA560932_P_NODE_7931_length_616_cov_1.351750_g7578_i0	PRJNA560932	7931	616	1.35175	8.32678	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	481	6.57e-131	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g7578	i0	81.697	96.9675324675325	601	89	95	19	1	587	1903690	1904283	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	59732	481	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
14573726	14573726	PRJNA560932_P_NODE_49312_length_259_cov_1.241935_g48956_i0	PRJNA560932	49312	259	1.241935	3.21661165	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	348	2.69e-91	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g48956	i0	91.085	187.660231660232	258	21	99	2	2	259	2168625	2168370	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	48604	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15158579	15158579	PRJNA560932_P_NODE_30072_length_329_cov_0.902344_g29716_i0	PRJNA560932	30072	329	0.902344	2.96871176	Verrucomicrobiota	74201	Bacteria	Bacteria	451	2.61e-122	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g29716	i0	92.949	75.8297872340426	312	18	94	4	1	310	467	158	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	24948	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
15847364	15847364	PRJNA560932_P_NODE_20193_length_392_cov_1.282132_g19837_i0	PRJNA560932	20193	392	1.282132	5.02595744	Limnoglobus roseus	2598579	Bacteria	Bacteria	597	3.8399999999999987e-166	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g19837	i0	94.148	82.0663265306122	393	21	100	2	1	392	2957430	2957821	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	32170	597	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
15847551	15847551	PRJNA560932_P_NODE_39753_length_289_cov_1.004630_g39397_i0	PRJNA560932	39753	289	1.00463	2.9033807	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	484	2.2299999999999998e-132	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g39397	i0	96.886	41.1314878892734	289	9	100	0	1	289	348	60	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	11887	484	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
15847611	15847611	PRJNA560932_P_NODE_47213_length_266_cov_1.015544_g46857_i0	PRJNA560932	47213	266	1.015544	2.70134704	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	263	1.03e-65	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g46857	i0	85.075	248.755639097744	268	28	98	9	3	264	4469542	4469281	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	66169	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
15847722	15847722	PRJNA560932_P_NODE_64033_length_243_cov_0.905882_g63677_i0	PRJNA560932	64033	243	0.905882	2.20129326	Caulifigura coniformis	2527983	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g63677	i0	100	0.123456790123457	30	0	12	0	97	126	1885941	1885970	Caulifigura coniformis strain Pan44 chromosome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
19671249	19671249	PRJNA560932_P_NODE_4896_length_772_cov_5.300429_g4570_i0	PRJNA560932	4896	772	5.300429	40.91931188	Poriferisphaera corsica	2528020	Bacteria	Bacteria	67.6	2.76e-6	NTclustered	gi\|1712598971\|gb\|CP036425.1\|	2528020	g4570	i0	93.333	0.0582901554404145	45	3	6	0	277	321	1032725	1032769	Poriferisphaera corsica strain KS4 chromosome, complete genome	blastn	45	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Poriferisphaera	Poriferisphaera corsica
21532542	21532542	PRJNA560932_P_NODE_27937_length_339_cov_2.003759_g27581_i0	PRJNA560932	27937	339	2.003759	6.79274301	Prosthecobacter	48463	Bacteria	Bacteria	551	2.589999999999999e-152	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g27581	i0	96.142	59.4188790560472	337	13	99	0	1	337	1159	1495	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	20143	551	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
22221718	22221718	PRJNA560932_P_NODE_32418_length_318_cov_1.257143_g32062_i0	PRJNA560932	32418	318	1.257143	3.99771474	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	226	1.6599999999999994e-54	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g32062	i0	81.979	2.66981132075472	283	36	86	12	16	290	1302447	1302722	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	849	226	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
22221943	22221943	PRJNA560932_P_NODE_65378_length_242_cov_0.911243_g65022_i0	PRJNA560932	65378	242	0.911243	2.20520806	Opitutus terrae	107709	Bacteria	Bacteria	156	1.6200000000000002e-33	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g65022	i0	87.143	4.4504132231405	140	15	57	3	104	242	1181588	1181451	Opitutus terrae PB90-1, complete genome	blastn	1077	156	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
22807705	22807705	PRJNA560932_P_NODE_52678_length_251_cov_0.865169_g52322_i0	PRJNA560932	52678	251	0.865169	2.17157419	Schlesneria	656899	Bacteria	Bacteria	370	5.53e-98	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g52322	i0	93.227	112.262948207171	251	17	100	0	1	251	2295	2045	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	28178	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
23497002	23497002	PRJNA560932_P_NODE_33299_length_314_cov_1.514523_g32943_i0	PRJNA560932	33299	314	1.514523	4.75560222	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	438	1.9299999999999998e-118	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g32943	i0	92.063	67.3757961783439	315	20	99	5	1	313	3722504	3722193	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	21156	438	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
24082515	24082515	PRJNA560932_P_NODE_6439_length_679_cov_4.054455_g6093_i0	PRJNA560932	6439	679	4.054455	27.52974945	Gemmata	113	Bacteria	Bacteria	1216	0	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g6093	i0	98.969	117.496318114875	679	7	100	0	1	679	1038039	1038717	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	79780	1216	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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