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

25 rows where analysis = "blastn", bioproject = "PRJNA914897" 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
1251020	1251020	PRJNA914897_P_NODE_30201_length_287_cov_1.345794_g29777_i0	PRJNA914897	30201	287	1.345794	3.86242878	Frigoriglobus	2774146	Bacteria	Bacteria	429	1.05e-115	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g29777	i0	93.75	98.2613240418118	288	15	99	3	1	285	2002741	2003028	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	28201	431	0.995359628770302	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2170312	2170312	PRJNA914897_P_NODE_32082_length_276_cov_1.738916_g31658_i0	PRJNA914897	32082	276	1.738916	4.79940816	Humisphaera borealis	2807512	Bacteria	Bacteria	357	4.8e-94	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g31658	i0	92.829	39.3297101449275	251	10	90	7	11	259	5063295	5063051	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	10855	357	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
3445747	3445747	PRJNA914897_P_NODE_30803_length_284_cov_1.156398_g30379_i0	PRJNA914897	30803	284	1.156398	3.28417032	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	388	1.7599999999999998e-103	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g30379	i0	91.579	108.669014084507	285	18	99	4	5	284	1831297	1831014	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	30862	388	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
5998069	5998069	PRJNA914897_P_NODE_21865_length_357_cov_1.732394_g21441_i0	PRJNA914897	21865	357	1.732394	6.18464658	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	379	1.37e-100	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g21441	i0	86.111	42.6106442577031	360	40	100	10	1	357	2271501	2271853	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	15212	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
5998095	5998095	PRJNA914897_P_NODE_24465_length_332_cov_0.891892_g24041_i0	PRJNA914897	24465	332	0.891892	2.96108144	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	359	1.6499999999999998e-94	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g24041	i0	86.228	127.361445783133	334	42	100	4	1	332	2503033	2502702	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	42284	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
7272976	7272976	PRJNA914897_P_NODE_15026_length_459_cov_1.386010_g14604_i0	PRJNA914897	15026	459	1.38601	6.3617859	Humisphaera borealis	2807512	Bacteria	Bacteria	252	4.09e-62	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g14604	i0	93.491	52.082788671024	169	11	76	0	257	425	5064099	5063931	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	23906	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
7273000	7273000	PRJNA914897_P_NODE_17706_length_411_cov_1.100592_g17284_i0	PRJNA914897	17706	411	1.100592	4.52343312	Limnoglobus roseus	2598579	Bacteria	Bacteria	652	0	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g17284	i0	95.377	159.9099756691	411	18	99	1	2	411	2958570	2958160	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	65723	652	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
7273012	7273012	PRJNA914897_P_NODE_19186_length_389_cov_2.126582_g18764_i0	PRJNA914897	19186	389	2.126582	8.27240398	Urbifossiella limnaea	2528023	Bacteria	Bacteria	460	5.21e-125	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g18764	i0	88.205	85.7120822622108	390	41	99	5	1	387	2018224	2017837	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	33342	460	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
7273026	7273026	PRJNA914897_P_NODE_20586_length_372_cov_1.100334_g20163_i0	PRJNA914897	20586	372	1.100334	4.09324248	Humisphaera borealis	2807512	Bacteria	Bacteria	372	2.39e-98	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g20163	i0	84.946	101.465053763441	372	51	99	5	3	372	5062855	5063223	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	37745	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
7273077	7273077	PRJNA914897_P_NODE_26606_length_313_cov_1.845833_g26182_i0	PRJNA914897	26606	313	1.845833	5.77745729	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	224	5.86e-54	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g26182	i0	83.267	52.6837060702875	251	34	79	8	68	313	190	437	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	16490	224	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
8903816	8903816	PRJNA914897_P_NODE_24527_length_331_cov_1.201550_g24103_i0	PRJNA914897	24527	331	1.20155	3.9771305	Gemmata	113	Bacteria	Bacteria	416	9.6e-112	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g24103	i0	89.458	145.516616314199	332	31	99	4	1	330	4797995	4798324	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	48166	416	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
9822667	9822667	PRJNA914897_P_NODE_13968_length_482_cov_1.775061_g13546_i0	PRJNA914897	13968	482	1.775061	8.55579402	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	322	3.24e-83	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g13546	i0	79.175	220.331950207469	509	73	100	16	1	482	1829996	1830498	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	106200	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
10179546	10179546	PRJNA914897_P_NODE_10988_length_561_cov_2.059426_g10568_i0	PRJNA914897	10988	561	2.059426	11.55337986	Limnoglobus	2731450	Bacteria	Bacteria	623	9.339999999999998e-174	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g10568	i0	87.08	465.673796791444	565	56	99	13	1	557	2001699	2002254	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	261243	623	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13648382	13648382	PRJNA914897_P_NODE_12331_length_522_cov_1.581292_g11911_i0	PRJNA914897	12331	522	1.581292	8.25434424	Limnoglobus roseus	2598579	Bacteria	Bacteria	793	0	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g11911	i0	94.073	158.818007662835	523	30	100	1	1	522	2957369	2956847	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	82903	793	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
13648501	13648501	PRJNA914897_P_NODE_29171_length_294_cov_1.009050_g28747_i0	PRJNA914897	29171	294	1.00905	2.966607	Limnoglobus roseus	2598579	Bacteria	Bacteria	449	8.28e-122	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g28747	i0	94.237	198.972789115646	295	16	100	1	1	294	2956544	2956250	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	58498	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
16197705	16197705	PRJNA914897_P_NODE_21673_length_359_cov_1.814685_g21249_i0	PRJNA914897	21673	359	1.814685	6.51471915	Aquisphaera giovannonii	406548	Bacteria	Bacteria	531	3.5799999999999993e-146	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g21249	i0	93.352	231.233983286908	361	21	100	2	1	359	5180145	5180504	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	83013	531	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
16553482	16553482	PRJNA914897_P_NODE_35173_length_258_cov_1.610811_g34749_i0	PRJNA914897	35173	258	1.610811	4.15589238	Planctomycetia	203683	Bacteria	Bacteria	353	5.749999999999998e-93	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g34749	i0	91.506	90.9186046511628	259	18	99	3	1	257	4318016	4317760	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	23457	353	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17473013	17473013	PRJNA914897_P_NODE_17234_length_418_cov_1.339130_g16812_i0	PRJNA914897	17234	418	1.33913	5.5975634	planctomycete str. 139	149588	Bacteria	Bacteria	689	0	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g16812	i0	96.845	118.952153110048	412	13	99	0	7	418	2387	1976	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	49722	689	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
17473206	17473206	PRJNA914897_P_NODE_41814_length_242_cov_1.284024_g41390_i0	PRJNA914897	41814	242	1.284024	3.10733808	Luteolibacter luteus	2728835	Bacteria	Bacteria	91.6	4.62e-14	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g41390	i0	91.176	6.85123966942149	68	4	27	2	37	102	3804777	3804710	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	1658	91.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
17828521	17828521	PRJNA914897_P_NODE_38174_length_248_cov_1.548571_g37750_i0	PRJNA914897	38174	248	1.548571	3.84045608	Stieleria	2795973	Bacteria	Bacteria	257	4.43e-64	NTclustered	gi\|1712721777\|gb\|CP037423.1\|	2527979	g37750	i0	85.83	89.366935483871	247	29	99	4	3	248	1766841	1766600	Stieleria neptunia strain Enr13 chromosome	blastn	22163	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria neptunia
17828525	17828525	PRJNA914897_P_NODE_39954_length_245_cov_1.453488_g39530_i0	PRJNA914897	39954	245	1.453488	3.5610456	Gemmataceae	1914233	Bacteria	Bacteria	270	5.609999999999999e-68	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g39530	i0	86.885	118.808163265306	244	29	99	3	3	245	3633916	3633675	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	29108	272	0.992647058823529	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
18746390	18746390	PRJNA914897_P_NODE_15815_length_443_cov_1.605405_g15393_i0	PRJNA914897	15815	443	1.605405	7.11194415	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	551	3.469999999999999e-152	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g15393	i0	89.087	359.422121896163	449	41	100	7	1	443	7052183	7052629	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	159224	551	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21296957	21296957	PRJNA914897_P_NODE_38357_length_248_cov_0.880000_g37933_i0	PRJNA914897	38357	248	0.88	2.1824	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	398	2.5e-106	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g37933	i0	95.935	63.5362903225806	246	9	99	1	3	248	1832080	1831836	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	15757	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
22928642	22928642	PRJNA914897_P_NODE_15918_length_441_cov_1.271739_g15496_i0	PRJNA914897	15918	441	1.271739	5.60836899	Gemmata	113	Bacteria	Bacteria	601	3.3799999999999993e-167	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g15496	i0	94.615	404.859410430839	390	17	88	4	54	441	1142	755	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	178543	601	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
23847204	23847204	PRJNA914897_P_NODE_32219_length_275_cov_2.128713_g31795_i0	PRJNA914897	32219	275	2.128713	5.85396075	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	329	1.04e-85	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g31795	i0	89.219	144.930909090909	269	22	95	5	6	267	7050583	7050851	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	39856	329	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);;