metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA688352" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA688352" 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
666864	666864	PRJNA688352_P_NODE_12541_length_241_cov_0.875000_g12438_i0	PRJNA688352	12541	241	0.875	2.10875	Rohdeia mirabilis	2528008	Bacteria	Bacteria	213	9.4e-51	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g12438	i0	83.19	4.04564315352697	232	39	96	0	1	232	3153994	3154225	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	975	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
666913	666913	PRJNA688352_P_NODE_8221_length_249_cov_0.875000_g8118_i0	PRJNA688352	8221	249	0.875	2.17875	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	93.5	1.33e-14	NTclustered	gi\|2108078657\|gb\|CP070747.1\|	2052180	g8118	i0	90.141	0.718875502008032	71	7	29	0	177	247	1486641	1486571	MAG: Phycisphaerales bacterium isolate bin358 chromosome	blastn	179	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
1942847	1942847	PRJNA688352_P_NODE_12522_length_241_cov_0.916667_g12419_i0	PRJNA688352	12522	241	0.916667	2.20916747	Lacipirellula parvula	2650471	Bacteria	Bacteria	163	9.61e-36	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g12419	i0	87.413	6.87136929460581	143	16	59	2	100	241	6715011	6715152	Lacipirellula parvula PX69 DNA, complete genome	blastn	1656	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
1942896	1942896	PRJNA688352_P_NODE_7642_length_250_cov_0.870056_g7539_i0	PRJNA688352	7642	250	0.870056	2.17514	Urbifossiella limnaea	2528023	Bacteria	Bacteria	117	7.92e-22	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g7539	i0	90.909	7.34	88	6	35	2	1	87	7185952	7186038	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1835	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
1942913	1942913	PRJNA688352_P_NODE_8902_length_248_cov_0.880000_g8799_i0	PRJNA688352	8902	248	0.88	2.1824	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	182	2.74e-41	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g8799	i0	80	11.9516129032258	245	49	99	0	2	246	7304732	7304976	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2964	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3217754	3217754	PRJNA688352_P_NODE_12523_length_241_cov_0.916667_g12420_i0	PRJNA688352	12523	241	0.916667	2.20916747	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	152	2.08e-32	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g12420	i0	80	8.31535269709544	215	35	88	7	31	241	2103336	2103126	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	2004	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
4494848	4494848	PRJNA688352_P_NODE_8324_length_249_cov_0.875000_g8221_i0	PRJNA688352	8324	249	0.875	2.17875	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	202	2.1099999999999998e-47	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g8221	i0	81.707	0.987951807228916	246	42	98	3	1	244	5778569	5778813	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	246	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
8319993	8319993	PRJNA688352_P_NODE_10927_length_244_cov_0.900585_g10824_i0	PRJNA688352	10927	244	0.900585	2.1974274	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g10824	i0	96.875	0.131147540983607	32	1	13	0	15	46	3658263	3658232	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	32	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
12146306	12146306	PRJNA688352_P_NODE_9150_length_247_cov_0.885057_g9047_i0	PRJNA688352	9150	247	0.885057	2.18609079	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	257	4.41e-64	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g9047	i0	88.318	85.0526315789474	214	25	87	0	1	214	1863949	1863736	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	21008	257	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
12656226	12656226	PRJNA688352_P_NODE_9790_length_246_cov_0.890173_g9687_i0	PRJNA688352	9790	246	0.890173	2.18982558	Planctomycetia	203683	Bacteria	Bacteria	276	1.21e-69	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g9687	i0	87.5	12.6056910569106	240	29	97	1	1	239	2374535	2374296	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	3101	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13420799	13420799	PRJNA688352_P_NODE_10711_length_244_cov_0.900585_g10608_i0	PRJNA688352	10711	244	0.900585	2.1974274	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	172	1.62e-38	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g10608	i0	83.511	7.59426229508197	188	27	76	4	59	244	2459239	2459054	Lacipirellula limnantheis strain I41 chromosome	blastn	1853	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
15205463	15205463	PRJNA688352_P_NODE_8892_length_248_cov_0.880000_g8789_i0	PRJNA688352	8892	248	0.88	2.1824	Planctomycetia	203683	Bacteria	Bacteria	316	7.2e-82	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g8789	i0	89.879	91.5362903225806	247	23	99	2	3	247	2077858	2078104	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	22701	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15969540	15969540	PRJNA688352_P_NODE_10373_length_245_cov_0.895349_g10270_i0	PRJNA688352	10373	245	0.895349	2.19360505	Lacipirellula parvula	2650471	Bacteria	Bacteria	211	3.45e-50	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g10270	i0	84.762	1.82448979591837	210	32	86	0	36	245	635247	635456	Lacipirellula parvula PX69 DNA, complete genome	blastn	447	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
16479642	16479642	PRJNA688352_P_NODE_8893_length_248_cov_0.880000_g8790_i0	PRJNA688352	8893	248	0.88	2.1824	PVC group	1783257	Bacteria	Bacteria	169	2.13e-37	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g8790	i0	81.25	18.4879032258065	208	39	84	0	2	209	7411875	7412082	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	4585	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
17244878	17244878	PRJNA688352_P_NODE_8874_length_248_cov_0.880000_g8771_i0	PRJNA688352	8874	248	0.88	2.1824	Pirellulimonas nuda	2528009	Bacteria	Bacteria	150	7.729999999999999e-32	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g8771	i0	84.314	4.65322580645161	153	24	62	0	75	227	367961	368113	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	1154	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
21069286	21069286	PRJNA688352_P_NODE_11997_length_242_cov_0.857988_g11894_i0	PRJNA688352	11997	242	0.857988	2.07633096	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	287	5.49e-73	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g11894	i0	88.017	3.00826446280992	242	29	100	0	1	242	1213331	1213572	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	728	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
22344239	22344239	PRJNA688352_P_NODE_9178_length_247_cov_0.885057_g9075_i0	PRJNA688352	9178	247	0.885057	2.18609079	Rosistilla ulvae	1930277	Bacteria	Bacteria	340	4.25e-89	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g9075	i0	91.837	2.97570850202429	245	19	99	1	4	247	5988589	5988345	Rosistilla ulvae strain EC9 chromosome	blastn	735	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
24893044	24893044	PRJNA688352_P_NODE_7960_length_250_cov_0.870056_g7857_i0	PRJNA688352	7960	250	0.870056	2.17514	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	207	4.57e-49	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g7857	i0	81.967	88.932	244	44	98	0	2	245	4414058	4414301	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	22233	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae 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);;