metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA1156092" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA1156092" 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
302628	302628	PRJNA1156092_P_NODE_13421_length_314_cov_1.278008_g13291_i0	PRJNA1156092	13421	314	1.278008	4.01294512	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	171	7.77e-38	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g13291	i0	90.625	54.0095541401274	128	12	41	0	4	131	5363271	5363398	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	16959	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
2853664	2853664	PRJNA1156092_P_NODE_15343_length_297_cov_1.031250_g15213_i0	PRJNA1156092	15343	297	1.03125	3.0628125	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	448	3.0099999999999998e-121	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g15213	i0	93.96	69.3771043771044	298	14	99	4	1	296	16357	16652	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	20605	448	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
2853701	2853701	PRJNA1156092_P_NODE_17203_length_283_cov_1.100000_g17073_i0	PRJNA1156092	17203	283	1.1	3.113	Polystyrenella longa	2528007	Bacteria	Bacteria	311	3.9000000000000005e-80	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g17073	i0	87.64	275.053003533569	267	33	94	0	1	267	1416643	1416909	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	77840	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
6680602	6680602	PRJNA1156092_P_NODE_20186_length_262_cov_1.507937_g20056_i0	PRJNA1156092	20186	262	1.507937	3.95079494	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	350	7.57e-92	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g20056	i0	91.154	158.358778625954	260	20	98	3	5	262	5364729	5364471	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	41490	350	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
7956059	7956059	PRJNA1156092_P_NODE_31347_length_242_cov_0.911243_g31217_i0	PRJNA1156092	31347	242	0.911243	2.20520806	Planctomycetota bacterium	2026780	Bacteria	Bacteria	209	1.22e-49	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g31217	i0	82.231	703.719008264463	242	43	100	0	1	242	721606	721847	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	170300	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
9230979	9230979	PRJNA1156092_P_NODE_3788_length_520_cov_2.373602_g3659_i0	PRJNA1156092	3788	520	2.373602	12.3427304	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	490	9.11e-134	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g3659	i0	86.214	64.3134615384615	457	57	87	4	24	476	3081779	3082233	Stratiformator vulcanicus strain Pan189 chromosome	blastn	33443	490	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
10506697	10506697	PRJNA1156092_P_NODE_29769_length_244_cov_0.900585_g29639_i0	PRJNA1156092	29769	244	0.900585	2.1974274	Symmachiella dynata	2527995	Bacteria	Bacteria	213	9.540000000000001e-51	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g29639	i0	84.071	106.561475409836	226	31	91	5	4	226	1041110	1040887	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	26001	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
10506820	10506820	PRJNA1156092_P_NODE_6509_length_416_cov_1.795918_g6379_i0	PRJNA1156092	6509	416	1.795918	7.47101888	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	390	7.47e-104	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g6379	i0	84.211	419.802884615385	418	48	99	13	1	412	4469091	4469496	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	174638	390	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
12515903	12515903	PRJNA1156092_P_NODE_16850_length_285_cov_1.580189_g16720_i0	PRJNA1156092	16850	285	1.580189	4.50353865	Phycisphaera	666508	Bacteria	Bacteria	255	1.87e-63	NTclustered	gi\|470476024\|ref\|NR_076315.1\|	547188	g16720	i0	83.513	385.852631578947	279	41	97	5	9	285	778	1053	Phycisphaera mikurensis strain FYK2301M01 23S ribosomal RNA gene, complete sequence	blastn	109968	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
13056672	13056672	PRJNA1156092_P_NODE_6711_length_411_cov_2.023669_g6581_i0	PRJNA1156092	6711	411	2.023669	8.31727959	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	542	1.9199999999999999e-149	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g6581	i0	90.663	157.272506082725	407	38	99	0	1	407	4958181	4957775	Planctomyces sp. SH-PL14, complete genome	blastn	64639	542	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
14331730	14331730	PRJNA1156092_P_NODE_1872_length_708_cov_2.034646_g1748_i0	PRJNA1156092	1872	708	2.034646	14.40529368	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	900	0	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g1748	i0	89.704	159.398305084746	709	67	99	6	3	708	4955779	4956484	Planctomyces sp. SH-PL14, complete genome	blastn	112854	900	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
16879884	16879884	PRJNA1156092_P_NODE_22954_length_250_cov_0.870056_g22824_i0	PRJNA1156092	22954	250	0.870056	2.17514	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	276	1.2299999999999999e-69	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g22824	i0	87.045	105.572	247	28	98	3	6	250	653586	653830	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	26393	276	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19428783	19428783	PRJNA1156092_P_NODE_18616_length_273_cov_1.140000_g18486_i0	PRJNA1156092	18616	273	1.14	3.1122	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	283	8.159999999999999e-72	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g18486	i0	87.55	38.2710622710623	249	26	90	5	1	246	7051915	7051669	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	10448	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19428876	19428876	PRJNA1156092_P_NODE_24676_length_249_cov_0.875000_g24546_i0	PRJNA1156092	24676	249	0.875	2.17875	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	183	7.659999999999998e-42	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g24546	i0	80.242	54.4538152610442	248	45	98	4	5	248	2622125	2621878	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	13559	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19429035	19429035	PRJNA1156092_P_NODE_3756_length_522_cov_1.178174_g3627_i0	PRJNA1156092	3756	522	1.178174	6.15006828	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	643	6.639999999999998e-180	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g3627	i0	88.826	97.4655172413793	528	53	100	4	1	522	7050825	7050298	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	50877	643	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20704082	20704082	PRJNA1156092_P_NODE_17017_length_284_cov_1.459716_g16887_i0	PRJNA1156092	17017	284	1.459716	4.14559344	Aureliella helgolandensis	2527968	Bacteria	Bacteria	278	3.97e-70	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g16887	i0	84.838	69.6619718309859	277	41	98	1	1	277	6998828	6999103	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	19784	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
21979661	21979661	PRJNA1156092_P_NODE_25018_length_248_cov_0.880000_g24888_i0	PRJNA1156092	25018	248	0.88	2.1824	Rohdeia mirabilis	2528008	Bacteria	Bacteria	80.5	1.03e-10	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g24888	i0	96	0.201612903225806	50	1	20	1	179	228	2108813	2108861	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	50	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
21979753	21979753	PRJNA1156092_P_NODE_30678_length_243_cov_0.905882_g30548_i0	PRJNA1156092	30678	243	0.905882	2.20129326	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	73.1	1.68e-8	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g30548	i0	82.418	30.8765432098765	91	9	38	6	26	116	2527548	2527465	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	7503	73.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
23255281	23255281	PRJNA1156092_P_NODE_7979_length_384_cov_0.980707_g7849_i0	PRJNA1156092	7979	384	0.980707	3.76591488	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	544	4.96e-150	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g7849	i0	92.268	139.744791666667	388	22	99	6	3	384	7051291	7050906	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	53662	544	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);;