metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1020854" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1020854" 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
161307	161307	PRJNA1020854_S_NODE_7521_length_547_cov_1040.063707_g4899_i0	PRJNA1020854	7521	547	1040.063707	5689.14847729	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	599	1.53e-166	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g4899	i0	88.431	54.617915904936	510	41	91	16	1	500	7728938	7728437	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	29876	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
1435730	1435730	PRJNA1020854_S_NODE_26282_length_205_cov_7.465909_g23518_i0	PRJNA1020854	26282	205	7.465909	15.30511345	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	316	5.75e-82	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g23518	i0	94.634	36.7121951219512	205	10	100	1	1	205	2834516	2834313	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	7526	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
2710971	2710971	PRJNA1020854_S_NODE_11143_length_379_cov_62.034286_g8391_i0	PRJNA1020854	11143	379	62.034286	235.10994394	uncultured Verrucomicrobium sp.	114704	Bacteria	Bacteria	462	1.4099999999999999e-125	NTclustered	gi\|296172422\|emb\|FN668204.2\|	114704	g8391	i0	97.091	68.1187335092348	275	7	72	1	106	379	451	725	Uncultured Verrucomicrobium sp. partial 16S rRNA gene, clone ZS-4-361	blastn	25817	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	uncultured Verrucomicrobium sp.
3987798	3987798	PRJNA1020854_S_NODE_42724_length_151_cov_14.959016_g39960_i0	PRJNA1020854	42724	151	14.959016	22.58811416	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	263	5.23e-66	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g39960	i0	98.013	17.3973509933775	151	3	100	0	1	151	2497266	2497116	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	2627	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
4831346	4831346	PRJNA1020854_S_NODE_30284_length_187_cov_7.000000_g27520_i0	PRJNA1020854	30284	187	7	13.09	Verrucomicrobiota	74201	Bacteria	Bacteria	283	5.209999999999999e-72	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g27520	i0	98.148	31.5828877005348	162	3	87	0	1	162	944	783	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	5906	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
5264202	5264202	PRJNA1020854_S_NODE_7565_length_544_cov_1035.833010_g4941_i0	PRJNA1020854	7565	544	1035.83301	5634.9315744	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	547	5.599999999999998e-151	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g4941	i0	87.5	97.2628676470588	480	53	88	6	18	494	693	218	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	52911	547	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
9088364	9088364	PRJNA1020854_S_NODE_19348_length_252_cov_6.089686_g16584_i0	PRJNA1020854	19348	252	6.089686	15.34600872	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	438	1.5e-118	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g16584	i0	98.016	76.5436507936508	252	5	100	0	1	252	2833844	2834095	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	19289	438	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
9088617	9088617	PRJNA1020854_S_NODE_32328_length_180_cov_2.417219_g29564_i0	PRJNA1020854	32328	180	2.417219	4.3509942	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	62.1	2.54e-5	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g29564	i0	92.857	0.233333333333333	42	3	23	0	1	42	4677726	4677767	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	42	62.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
9088629	9088629	PRJNA1020854_S_NODE_32908_length_178_cov_2.442953_g30144_i0	PRJNA1020854	32908	178	2.442953	4.34845634	Urbifossiella limnaea	2528023	Bacteria	Bacteria	200	5.08e-47	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g30144	i0	87.006	0.99438202247191	177	23	99	0	1	177	5920133	5919957	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	177	200	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
9088768	9088768	PRJNA1020854_S_NODE_41628_length_154_cov_2.240000_g38864_i0	PRJNA1020854	41628	154	2.24	3.4496000000000002	Aureliella helgolandensis	2527968	Bacteria	Bacteria	130	5.68e-26	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g38864	i0	98.63	1.26623376623377	73	1	47	0	7	79	5554640	5554568	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	195	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
10364595	10364595	PRJNA1020854_S_NODE_9889_length_418_cov_3.796915_g7159_i0	PRJNA1020854	9889	418	3.796915	15.8711047	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	673	0	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g7159	i0	95.694	207.538277511962	418	18	100	0	1	418	1830937	1830520	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	86751	673	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
12914489	12914489	PRJNA1020854_S_NODE_20151_length_245_cov_912.379630_g17387_i0	PRJNA1020854	20151	245	912.37963	2235.3300935	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	257	4.37e-64	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g17387	i0	89.372	65.7795918367347	207	19	84	3	40	245	1831413	1831209	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	16116	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
12914620	12914620	PRJNA1020854_S_NODE_25951_length_207_cov_3.707865_g23187_i0	PRJNA1020854	25951	207	3.707865	7.67528055	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	333	5.779999999999999e-87	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g23187	i0	95.673	36.8743961352657	208	7	100	2	1	207	2364784	2364990	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	7633	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14189812	14189812	PRJNA1020854_S_NODE_39472_length_159_cov_1.938462_g36708_i0	PRJNA1020854	39472	159	1.938462	3.08215458	Luteolibacter sp.	1962973	Bacteria	Bacteria	147	5.869999999999999e-31	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g36708	i0	86.466	2.42138364779874	133	18	84	0	1	133	1722194	1722326	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	385	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
15030851	15030851	PRJNA1020854_S_NODE_15572_length_294_cov_1159.800000_g12808_i0	PRJNA1020854	15572	294	1159.8	3409.812	Pirellulaceae	2691357	Bacteria	Bacteria	241	5.42e-59	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g12808	i0	85.47	368.15306122449	234	31	79	3	56	288	3097757	3097526	Pirellula sp. SH-Sr6A, complete genome	blastn	108237	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
15463318	15463318	PRJNA1020854_S_NODE_10113_length_410_cov_526.167979_g7377_i0	PRJNA1020854	10113	410	526.167979	2157.2887139	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	520	8.979999999999998e-143	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g7377	i0	93.466	467.936585365854	352	20	85	3	62	410	1831263	1830912	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	191854	520	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
15463528	15463528	PRJNA1020854_S_NODE_19313_length_252_cov_2328.807175_g16549_i0	PRJNA1020854	19313	252	2328.807175	5868.594081	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	250	7.55e-62	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g16549	i0	93.064	412.777777777778	173	9	68	2	55	225	2833210	2833381	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	104020	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
16737597	16737597	PRJNA1020854_S_NODE_12414_length_348_cov_971.579937_g9650_i0	PRJNA1020854	12414	348	971.579937	3381.09818076	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	333	1.05e-86	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g9650	i0	86.842	137.827586206897	304	32	86	5	1	300	1903093	1902794	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	47964	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
16737880	16737880	PRJNA1020854_S_NODE_25314_length_210_cov_13.977901_g22550_i0	PRJNA1020854	25314	210	13.977901	29.3535921	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	335	1.6299999999999994e-87	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g22550	i0	95.673	26.4761904761905	208	9	99	0	3	210	2450	2243	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	5560	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
16738173	16738173	PRJNA1020854_S_NODE_41594_length_154_cov_2.408000_g38830_i0	PRJNA1020854	41594	154	2.408	3.70832	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	250	4.18e-62	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g38830	i0	96.104	38.1363636363636	154	5	100	1	1	154	2365569	2365417	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	5873	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18012541	18012541	PRJNA1020854_S_NODE_16935_length_277_cov_5.705645_g14171_i0	PRJNA1020854	16935	277	5.705645	15.80463665	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	457	4.62e-124	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g14171	i0	96.403	27.9819494584838	278	9	100	1	1	277	2834757	2834480	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	7751	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
20129806	20129806	PRJNA1020854_S_NODE_39216_length_159_cov_4.338462_g36452_i0	PRJNA1020854	39216	159	4.338462	6.89815458	root	1	Root_unresolved	Root_unresolved	231	1.58e-56	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g36452	i0	93.082	12.5157232704403	159	9	100	2	1	159	1830336	1830492	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	1990	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
21405201	21405201	PRJNA1020854_S_NODE_13977_length_319_cov_3.993103_g11213_i0	PRJNA1020854	13977	319	3.993103	12.73799857	Bacteria	2	Bacteria	Bacteria	331	3.43e-86	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g11213	i0	85.804	242.46394984326	317	40	99	5	5	319	27751	28064	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	77346	331	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
23113213	23113213	PRJNA1020854_S_NODE_25519_length_209_cov_6.238889_g22755_i0	PRJNA1020854	25519	209	6.238889	13.03927801	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	209	1.03e-49	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g22755	i0	84.834	246.55980861244	211	28	100	3	1	209	2634	2426	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	51531	209	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
24386768	24386768	PRJNA1020854_S_NODE_13640_length_324_cov_666.728814_g10876_i0	PRJNA1020854	13640	324	666.72881400000006	2160.20135736	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	292	1.65e-74	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g10876	i0	86.296	107.595679012346	270	36	83	1	7	275	2562350	2562619	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	34861	292	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);;