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

15 rows where analysis = "blastn", bioproject = "PRJNA683669" 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
664909	664909	PRJNA683669_P_NODE_17641_length_308_cov_1.327660_g17409_i0	PRJNA683669	17641	308	1.32766	4.0891928	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	484	2.3899999999999998e-132	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g17409	i0	95.114	116.311688311688	307	15	99	0	2	308	2003487	2003793	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	35824	484	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1940942	1940942	PRJNA683669_P_NODE_22582_length_273_cov_1.005000_g22350_i0	PRJNA683669	22582	273	1.005	2.74365	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	392	1.2999999999999999e-104	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g22350	i0	92.701	101.805860805861	274	16	99	4	1	272	2002762	2003033	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	27793	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1941005	1941005	PRJNA683669_P_NODE_30542_length_245_cov_1.732558_g30310_i0	PRJNA683669	30542	245	1.732558	4.2447671	Pedosphaera parvula	1032527	Bacteria	Bacteria	285	2.0000000000000002e-72	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g30310	i0	91.787	24.4530612244898	207	13	84	4	35	239	1458	1254	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	5991	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
2450263	2450263	PRJNA683669_P_NODE_3962_length_654_cov_2.235800_g3740_i0	PRJNA683669	3962	654	2.2358	14.622132	Schlesneria	656899	Bacteria	Bacteria	769	0	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g3740	i0	87.879	96.652905198776807	660	71	100	7	1	654	1705	1049	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	63211	773	0.994825355756792	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
3215829	3215829	PRJNA683669_P_NODE_28363_length_248_cov_0.880000_g28131_i0	PRJNA683669	28363	248	0.88	2.1824	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	165	2.76e-36	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g28131	i0	79.087	1.06048387096774	263	37	99	8	2	246	3031845	3031583	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	263	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
4492953	4492953	PRJNA683669_P_NODE_31244_length_245_cov_0.895349_g31012_i0	PRJNA683669	31244	245	0.895349	2.19360505	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	438	1.45e-118	NTclustered	gi\|339646202\|gb\|JN038591.1\|	120965	g31012	i0	98.785	101.575510204082	247	1	100	1	1	245	50	296	Uncultured planctomycete clone MA-R8 16S ribosomal RNA gene, partial sequence	blastn	24886	438	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
5768507	5768507	PRJNA683669_P_NODE_12265_length_369_cov_1.300676_g12034_i0	PRJNA683669	12265	369	1.300676	4.79949444	Planctomycetota bacterium	2026780	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g12034	i0	100	0.0785907859078591	29	0	8	0	135	163	703689	703717	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
5768630	5768630	PRJNA683669_P_NODE_31265_length_245_cov_0.895349_g31033_i0	PRJNA683669	31265	245	0.895349	2.19360505	Aquisphaera giovannonii	406548	Bacteria	Bacteria	67.6	7.9e-7	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g31033	i0	80.851	1.80816326530612	94	10	38	4	1	93	1615838	1615752	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	443	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
6278847	6278847	PRJNA683669_P_NODE_15645_length_328_cov_1.125490_g15414_i0	PRJNA683669	15645	328	1.12549	3.6916072	Gemmata	113	Bacteria	Bacteria	540	5.3999999999999985e-149	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g15414	i0	96.364	141.655487804878	330	8	100	3	1	328	708	1035	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	46463	540	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
10868977	10868977	PRJNA683669_P_NODE_26549_length_251_cov_0.865169_g26317_i0	PRJNA683669	26549	251	0.865169	2.17157419	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	152	2.18e-32	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g26317	i0	80.095	0.840637450199203	211	36	83	5	18	225	3450383	3450590	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	211	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11378512	11378512	PRJNA683669_P_NODE_5069_length_574_cov_2.259481_g4842_i0	PRJNA683669	5069	574	2.259481	12.96942094	Schlesneria	656899	Bacteria	Bacteria	577	7.559999999999998e-160	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g4842	i0	85.147	152.390243902439	579	69	100	13	1	574	589	23	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	87472	577	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
12144323	12144323	PRJNA683669_P_NODE_22170_length_275_cov_1.524752_g21938_i0	PRJNA683669	22170	275	1.524752	4.193068	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	457	4.58e-124	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g21938	i0	96.715	11.7818181818182	274	9	99	0	1	274	3556396	3556669	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	3240	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
23617849	23617849	PRJNA683669_P_NODE_24079_length_263_cov_1.547368_g23847_i0	PRJNA683669	24079	263	1.547368	4.06957784	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	431	2.639999999999999e-116	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g23847	i0	96.198	35.0684410646388	263	10	100	0	1	263	225	487	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	9223	431	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
24126818	24126818	PRJNA683669_P_NODE_19539_length_291_cov_2.119266_g19307_i0	PRJNA683669	19539	291	2.119266	6.16706406	Planctomycetaceae	126	Bacteria	Bacteria	148	3.3399999999999993e-31	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g19307	i0	93.939	82.9381443298969	99	5	34	1	185	282	4955476	4955574	Planctomyces sp. SH-PL14, complete genome	blastn	24135	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
24891054	24891054	PRJNA683669_P_NODE_16700_length_317_cov_1.262295_g16469_i0	PRJNA683669	16700	317	1.262295	4.00147515	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	244	4.56e-60	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g16469	i0	87.923	66.0662460567823	207	25	65	0	11	217	7233102	7233308	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	20943	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris

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