metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1143173" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1143173" 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
286088	286088	PRJNA1143173_P_NODE_22681_length_279_cov_2.932039_g22655_i0	PRJNA1143173	22681	279	2.932039	8.18038881	Aquisphaera giovannonii	406548	Bacteria	Bacteria	171	6.799999999999999e-38	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g22655	i0	78.201	1.48745519713262	289	48	99	13	1	277	5593520	5593235	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	415	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
286201	286201	PRJNA1143173_P_NODE_27701_length_264_cov_5.324607_g27675_i0	PRJNA1143173	27701	264	5.324607	14.05696248	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	427	3.43e-115	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g27675	i0	95.849	101.056818181818	265	9	99	2	1	263	4959756	4960020	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	26679	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
1561093	1561093	PRJNA1143173_P_NODE_36602_length_238_cov_7.078788_g36576_i0	PRJNA1143173	36602	238	7.078788	16.84751544	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	213	9.27e-51	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g36576	i0	87.5	4.69327731092437	184	23	77	0	17	200	6584205	6584022	Tautonia plasticadhaerens strain ElP chromosome	blastn	1117	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
2837204	2837204	PRJNA1143173_P_NODE_35123_length_243_cov_3.476471_g35097_i0	PRJNA1143173	35123	243	3.476471	8.44782453	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	220	5.67e-53	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g35097	i0	83.691	3.55555555555556	233	38	96	0	11	243	2764484	2764716	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	864	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2837301	2837301	PRJNA1143173_P_NODE_39363_length_228_cov_5.935484_g39337_i0	PRJNA1143173	39363	228	5.935484	13.53290352	uncultured Gemmata sp.	459262	Bacteria	Bacteria	377	2.95e-100	NTclustered	gi\|631904742\|gb\|KJ600064.1\|	459262	g39337	i0	96.507	114.947368421053	229	6	100	2	1	228	226	453	Uncultured Gemmata sp. clone D-05Catholyte029 16S ribosomal RNA gene, partial sequence	blastn	26208	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	uncultured Gemmata sp.
6664185	6664185	PRJNA1143173_P_NODE_28126_length_263_cov_3.000000_g28100_i0	PRJNA1143173	28126	263	3	7.89	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	294	3.61e-75	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g28100	i0	86.973	2.26996197718631	261	34	99	0	3	263	2281041	2281301	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	597	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
10489669	10489669	PRJNA1143173_P_NODE_19549_length_288_cov_5.139535_g19523_i0	PRJNA1143173	19549	288	5.139535	14.8018608	Urbifossiella limnaea	2528023	Bacteria	Bacteria	363	1.08e-95	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g19523	i0	91.078	0.934027777777778	269	23	93	1	4	271	4399950	4400218	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	269	363	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
10490080	10490080	PRJNA1143173_P_NODE_37689_length_234_cov_8.049689_g37663_i0	PRJNA1143173	37689	234	8.049689	18.83627226	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	154	5.5800000000000005e-33	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g37663	i0	79.186	0.944444444444444	221	46	94	0	6	226	3364327	3364107	Luteolibacter sp. SL250 chromosome	blastn	221	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
11765433	11765433	PRJNA1143173_P_NODE_8510_length_310_cov_6.561181_g8484_i0	PRJNA1143173	8510	310	6.561181	20.3396611	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	180	1.27e-40	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g8484	i0	88.591	0.480645161290323	149	15	48	2	163	310	3088539	3088686	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	149	180	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
13039952	13039952	PRJNA1143173_P_NODE_24851_length_272_cov_12.346734_g24825_i0	PRJNA1143173	24851	272	12.346734	33.58311648	Gemmataceae bacterium	2052164	Bacteria	Bacteria	137	6.7e-28	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g24825	i0	86.822	0.474264705882353	129	9	46	5	121	246	820998	821121	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	129	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
13040144	13040144	PRJNA1143173_P_NODE_34871_length_244_cov_1.695906_g34845_i0	PRJNA1143173	34871	244	1.695906	4.13801064	Horticoccus luteus	2862869	Bacteria	Bacteria	213	9.540000000000001e-51	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g34845	i0	83.857	0.913934426229508	223	36	91	0	1	223	2934400	2934622	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	223	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
15588844	15588844	PRJNA1143173_P_NODE_13113_length_299_cov_9.110619_g13087_i0	PRJNA1143173	13113	299	9.110619	27.24075081	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g13087	i0	92.5	0.133779264214047	40	2	13	1	166	204	1849572	1849533	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	40	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
15589035	15589035	PRJNA1143173_P_NODE_20933_length_284_cov_4.545024_g20907_i0	PRJNA1143173	20933	284	4.545024	12.90786816	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	320	6.51e-83	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g20907	i0	87.063	1.00704225352113	286	33	100	4	1	284	2744857	2745140	Gemmata sp. SH-PL17, complete genome	blastn	286	320	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
18137860	18137860	PRJNA1143173_P_NODE_19255_length_289_cov_3.842593_g19229_i0	PRJNA1143173	19255	289	3.842593	11.10509377	Aquisphaera giovannonii	406548	Bacteria	Bacteria	195	4.2e-45	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g19229	i0	84.135	32.1141868512111	208	26	71	6	5	208	8394737	8394533	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	9281	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
18137886	18137886	PRJNA1143173_P_NODE_20215_length_286_cov_5.699531_g20189_i0	PRJNA1143173	20215	286	5.699531	16.30065866	Urbifossiella limnaea	2528023	Bacteria	Bacteria	122	1.99e-23	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g20189	i0	78.462	16.8566433566434	195	36	67	5	95	286	3228608	3228799	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	4821	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
21963394	21963394	PRJNA1143173_P_NODE_43938_length_202_cov_5.627907_g43912_i0	PRJNA1143173	43938	202	5.627907	11.36837214	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	206	1.28e-48	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g43912	i0	85.149	5.42079207920792	202	29	99	1	2	202	7116307	7116508	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1095	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23238765	23238765	PRJNA1143173_P_NODE_32499_length_250_cov_9.056497_g32473_i0	PRJNA1143173	32499	250	9.056497	22.6412425	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	185	2.14e-42	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g32473	i0	80.658	1.904	243	43	96	4	1	241	1665323	1665083	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	476	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24512070	24512070	PRJNA1143173_P_NODE_24600_length_273_cov_5.320000_g24574_i0	PRJNA1143173	24600	273	5.32	14.5236	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	274	4.91e-69	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g24574	i0	84.871	33.5860805860806	271	41	99	0	3	273	6711506	6711776	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	9169	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
24512415	24512415	PRJNA1143173_P_NODE_40100_length_225_cov_7.651316_g40074_i0	PRJNA1143173	40100	225	7.651316	17.215461	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	206	1.4499999999999998e-48	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g40074	i0	83.26	1.00888888888889	227	34	100	4	1	225	5463675	5463899	Tautonia plasticadhaerens strain ElP chromosome	blastn	227	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
24512483	24512483	PRJNA1143173_P_NODE_42980_length_208_cov_9.562963_g42954_i0	PRJNA1143173	42980	208	9.562963	19.89096304	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	276	9.93e-70	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g42954	i0	90.777	104.908653846154	206	19	99	0	1	206	7290041	7290246	Tautonia plasticadhaerens strain ElP chromosome	blastn	21821	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens

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