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

15 rows where analysis = "blastn", bioproject = "PRJNA1098727" 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
2761819	2761819	PRJNA1098727_P_NODE_8503_length_211_cov_1.246914_g8262_i0	PRJNA1098727	8503	211	1.246914	2.63098854	Pedosphaera parvula	1032527	Bacteria	Bacteria	316	5.95e-82	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g8262	i0	93.839	211.758293838863	211	11	99	2	2	210	1685	1895	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	44681	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
4037795	4037795	PRJNA1098727_P_NODE_11344_length_179_cov_2.292308_g11103_i0	PRJNA1098727	11344	179	2.292308	4.10323132	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	244	2.33e-60	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g11103	i0	91.573	33.8156424581006	178	13	99	2	2	178	1599406	1599582	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	6053	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
4037839	4037839	PRJNA1098727_P_NODE_2584_length_425_cov_1.925532_g2344_i0	PRJNA1098727	2584	425	1.925532	8.183511	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	632	1.1499999999999995e-176	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2344	i0	93.632	157.352941176471	424	25	99	2	3	425	2003049	2002627	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	66875	632	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4847878	4847878	PRJNA1098727_P_NODE_10104_length_191_cov_1.225352_g9863_i0	PRJNA1098727	10104	191	1.225352	2.34042232	Candidatus Uabimicrobium	2897349	Bacteria	Bacteria	189	1.1999999999999999e-43	NTclustered	gi\|1732437785\|dbj\|AP019860.1\|	2596890	g9863	i0	87.654	8.6020942408377	162	20	85	0	4	165	4988408	4988247	Planctomycetes bacterium SRT547 DNA, complete genome	blastn	1643	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
6122910	6122910	PRJNA1098727_P_NODE_4585_length_304_cov_1.172549_g4344_i0	PRJNA1098727	4585	304	1.172549	3.56454896	Verrucomicrobiota	74201	Bacteria	Bacteria	313	1.18e-80	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g4344	i0	86.879	79.5855263157895	282	33	92	4	2	281	1262	983	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	24194	316	0.990506329113924	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
7863827	7863827	PRJNA1098727_P_NODE_6687_length_241_cov_2.151042_g6446_i0	PRJNA1098727	6687	241	2.151042	5.18401122	Urbifossiella limnaea	2528023	Bacteria	Bacteria	285	1.96e-72	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6446	i0	88.285	117.091286307054	239	26	99	2	2	240	4212319	4212555	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	28219	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
10414499	10414499	PRJNA1098727_P_NODE_15429_length_163_cov_0.912281_g15188_i0	PRJNA1098727	15429	163	0.912281	1.48701803	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	84.2	4.82e-12	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g15188	i0	88.406	0.791411042944785	69	8	42	0	2	70	2040997	2041065	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	129	84.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
11689818	11689818	PRJNA1098727_P_NODE_13170_length_168_cov_0.873950_g12929_i0	PRJNA1098727	13170	168	0.87395	1.468236	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	141	2.93e-29	NTclustered	gi\|2021938515\|gb\|CP051247.1\|	2026779	g12929	i0	86.923	4.91071428571429	130	11	76	6	2	128	3417618	3417744	Planctomycetaceae bacterium isolate ih15 chromosome	blastn	825	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
11689833	11689833	PRJNA1098727_P_NODE_15510_length_162_cov_1.840708_g15269_i0	PRJNA1098727	15510	162	1.840708	2.98194696	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	195	2.12e-45	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g15269	i0	88.415	21.6234567901235	164	15	99	4	2	162	1315648	1315486	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	3503	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15513755	15513755	PRJNA1098727_P_NODE_7333_length_229_cov_1.022222_g7092_i0	PRJNA1098727	7333	229	1.022222	2.34088838	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	303	5.11e-78	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g7092	i0	90.789	55.8122270742358	228	19	99	2	2	228	2622149	2621923	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	12781	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17597557	17597557	PRJNA1098727_P_NODE_5094_length_285_cov_2.525424_g4853_i0	PRJNA1098727	5094	285	2.525424	7.1974584	Gemmataceae	1914233	Bacteria	Bacteria	440	4.8099999999999984e-119	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g4853	i0	94.7	167.863157894737	283	15	99	0	2	284	2382	2100	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	47841	440	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
18062808	18062808	PRJNA1098727_P_NODE_9175_length_201_cov_3.361842_g8934_i0	PRJNA1098727	9175	201	3.361842	6.75730242	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	331	2.01e-86	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g8934	i0	96.517	458.696517412935	201	5	99	1	2	200	1600313	1600513	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	92198	331	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
20612280	20612280	PRJNA1098727_P_NODE_11197_length_181_cov_0.810606_g10956_i0	PRJNA1098727	11197	181	0.810606	1.46719686	Planctomycetales bacterium 10988	2603660	Bacteria	Bacteria	228	2.379999999999999e-55	NTclustered	gi\|1775855904\|gb\|CP043547.1\|	2603660	g10956	i0	91.566	235.790055248619	166	12	91	2	7	171	2223378	2223214	Planctomycetales bacterium 10988 chromosome, complete genome	blastn	42678	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium 10988
21887937	21887937	PRJNA1098727_P_NODE_5098_length_285_cov_2.042373_g4857_i0	PRJNA1098727	5098	285	2.042373	5.82076305	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	350	8.34e-92	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g4857	i0	89.085	52.8315789473684	284	28	99	3	2	284	2004109	2004390	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	15057	350	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24437007	24437007	PRJNA1098727_P_NODE_6100_length_254_cov_2.804878_g5859_i0	PRJNA1098727	6100	254	2.804878	7.12439012	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	440	4.209999999999998e-119	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g5859	i0	98.024	135.984251968504	253	5	99	0	2	254	15935	15683	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	34540	440	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota 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);;