metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA694770" 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
675017	675017	PRJNA694770_P_NODE_63281_length_275_cov_1.004950_g62987_i0	PRJNA694770	63281	275	1.00495	2.7636125	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	82.4	3.22e-11	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g62987	i0	89.231	0.4	65	7	24	0	50	114	2748989	2749053	Luteolibacter sp. Populi chromosome, complete genome	blastn	110	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
675149	675149	PRJNA694770_P_NODE_67281_length_268_cov_1.579487_g66987_i0	PRJNA694770	67281	268	1.579487	4.23302516	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	355	1.67e-93	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g66987	i0	91.288	92.3917910447761	264	18	97	5	1	260	7051436	7051698	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	24761	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1951673	1951673	PRJNA694770_P_NODE_87082_length_247_cov_0.885057_g86788_i0	PRJNA694770	87082	247	0.885057	2.18609079	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	124	4.66e-24	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g86788	i0	94.937	31.7732793522267	79	4	32	0	58	136	808844	808922	Luteolibacter sp. SL250 chromosome	blastn	7848	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
2456631	2456631	PRJNA694770_P_NODE_94142_length_244_cov_0.900585_g93848_i0	PRJNA694770	94142	244	0.900585	2.1974274	Singulisphaera	466152	Bacteria	Bacteria	379	8.889999999999998e-101	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g93848	i0	94.694	111.217213114754	245	11	100	2	1	244	946	703	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	27137	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
3225031	3225031	PRJNA694770_P_NODE_26163_length_382_cov_0.996764_g25869_i0	PRJNA694770	26163	382	0.996764	3.80763848	Saltatorellus ferox	2528018	Bacteria	Bacteria	366	1.1499999999999996e-96	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g25869	i0	84.932	410.03664921466	365	51	95	3	20	382	2933002	2932640	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	156634	366	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
5779041	5779041	PRJNA694770_P_NODE_81325_length_250_cov_0.870056_g81031_i0	PRJNA694770	81325	250	0.870056	2.17514	Luteolibacter luteus	2728835	Bacteria	Bacteria	274	4.44e-69	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g81031	i0	86.694	0.992	248	31	99	2	1	247	2471528	2471774	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	248	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
7053990	7053990	PRJNA694770_P_NODE_74446_length_256_cov_2.103825_g74152_i0	PRJNA694770	74446	256	2.103825	5.385792	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	137	6.25e-28	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g74152	i0	80.435	33.56640625	184	32	71	4	7	188	1116877	1116696	Lacunisphaera limnophila strain IG16b, complete genome	blastn	8593	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
8327003	8327003	PRJNA694770_P_NODE_20807_length_418_cov_1.034783_g20513_i0	PRJNA694770	20807	418	1.034783	4.32539294	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	486	9.3e-133	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g20513	i0	87.765	689.736842105263	425	41	100	9	1	418	7050762	7050342	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	288310	486	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8327865	8327865	PRJNA694770_P_NODE_52827_length_290_cov_1.313364_g52533_i0	PRJNA694770	52827	290	1.313364	3.8087556	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	219	2.5e-52	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g52533	i0	82.591	5.82068965517241	247	43	85	0	44	290	1517692	1517446	Tautonia plasticadhaerens strain ElP chromosome	blastn	1688	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
8834117	8834117	PRJNA694770_P_NODE_78787_length_251_cov_0.865169_g78493_i0	PRJNA694770	78787	251	0.865169	2.17157419	Isosphaera	127	Bacteria	Bacteria	182	2.78e-41	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g78493	i0	80.488	144.199203187251	246	41	97	6	9	251	408	167	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	36194	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
9603055	9603055	PRJNA694770_P_NODE_47068_length_305_cov_1.418103_g46774_i0	PRJNA694770	47068	305	1.418103	4.32521415	Singulisphaera acidiphila	466153	Bacteria	Bacteria	364	3.2199999999999992e-96	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g46774	i0	88.312	100.56393442623	308	31	100	5	1	305	7354759	7354454	Singulisphaera acidiphila DSM 18658, complete genome	blastn	30672	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
10879560	10879560	PRJNA694770_P_NODE_81969_length_249_cov_1.607955_g81675_i0	PRJNA694770	81969	249	1.607955	4.00380795	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	342	1.1899999999999999e-89	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g81675	i0	91.633	122.168674698795	251	16	100	5	1	249	3722563	3722316	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	30420	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
12152895	12152895	PRJNA694770_P_NODE_14930_length_484_cov_3.695864_g14636_i0	PRJNA694770	14930	484	3.695864	17.88798176	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	599	1.3399999999999997e-166	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g14636	i0	88.911	299.857438016529	496	41	100	9	1	484	5936660	5936167	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	145131	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13427933	13427933	PRJNA694770_P_NODE_32111_length_354_cov_2.302491_g31817_i0	PRJNA694770	32111	354	2.302491	8.15081814	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	514	3.55e-141	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g31817	i0	92.758	151.590395480226	359	20	100	5	1	354	4317739	4317382	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	53663	514	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13429205	13429205	PRJNA694770_P_NODE_77531_length_251_cov_1.730337_g77237_i0	PRJNA694770	77531	251	1.730337	4.34314587	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	195	3.57e-45	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g77237	i0	85.185	0.752988047808765	189	28	75	0	48	236	4075725	4075913	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	189	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
13429587	13429587	PRJNA694770_P_NODE_91771_length_245_cov_0.895349_g91477_i0	PRJNA694770	91771	245	0.895349	2.19360505	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	158	4.56e-34	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g91477	i0	81.538	6.64489795918367	195	33	79	3	51	243	2545452	2545259	Luteolibacter sp. LG18 DNA, complete genome	blastn	1628	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
14704277	14704277	PRJNA694770_P_NODE_72832_length_259_cov_1.655914_g72538_i0	PRJNA694770	72832	259	1.655914	4.28881726	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	69.4	2.34e-7	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g72538	i0	81.395	0.332046332046332	86	14	33	2	105	189	1527775	1527859	Luteolibacter sp. LG18 DNA, complete genome	blastn	86	69.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
14704356	14704356	PRJNA694770_P_NODE_75672_length_254_cov_1.701657_g75378_i0	PRJNA694770	75672	254	1.701657	4.32220878	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	292	1.25e-74	NTclustered	gi\|781823269\|emb\|LN802595.1\|	120965	g75378	i0	88.703	95.8385826771653	239	27	94	0	1	239	299	61	Uncultured planctomycete partial 16S rRNA gene, clone denovo3842	blastn	24343	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
14705017	14705017	PRJNA694770_P_NODE_99552_length_241_cov_0.916667_g99258_i0	PRJNA694770	99552	241	0.916667	2.20916747	Actomonas aquatica	2866162	Bacteria	Bacteria	182	2.65e-41	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g99258	i0	95.575	9.96265560165975	113	5	47	0	129	241	346195	346307	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	2401	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
15978740	15978740	PRJNA694770_P_NODE_99233_length_241_cov_0.916667_g98939_i0	PRJNA694770	99233	241	0.916667	2.20916747	Tuwongella immobilis	692036	Bacteria	Bacteria	226	1.2099999999999997e-54	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g98939	i0	89.944	48.0373443983403	179	13	100	5	67	241	2736194	2736017	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	11577	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
22352207	22352207	PRJNA694770_P_NODE_58398_length_282_cov_1.253589_g58104_i0	PRJNA694770	58398	282	1.253589	3.53512098	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	475	1.2999999999999999e-129	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g58104	i0	97.153	0.99645390070922	281	8	99	0	1	281	3352062	3351782	Luteolibacter sp. SL250 chromosome	blastn	281	475	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
24900575	24900575	PRJNA694770_P_NODE_34620_length_345_cov_1.132353_g34326_i0	PRJNA694770	34620	345	1.132353	3.90661785	Phycisphaera sp.	2030824	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g34326	i0	100	0.0811594202898551	28	0	8	0	296	323	2414468	2414441	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
24901257	24901257	PRJNA694770_P_NODE_60760_length_278_cov_1.936585_g60466_i0	PRJNA694770	60760	278	1.936585	5.3837063	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	315	2.96e-81	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g60466	i0	87.05	5.18345323741007	278	36	100	0	1	278	5165217	5165494	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1441	315	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);;