metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1164198" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1164198" 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
2862779	2862779	PRJNA1164198_P_NODE_16203_length_307_cov_2.632479_g15934_i0	PRJNA1164198	16203	307	2.632479	8.08171053	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	239	2.05e-58	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g15934	i0	82.394	189.296416938111	284	40	91	10	1	279	3047224	3047502	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	58114	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
2862868	2862868	PRJNA1164198_P_NODE_31643_length_229_cov_3.166667_g31374_i0	PRJNA1164198	31643	229	3.166667	7.25166743	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	145	3.28e-30	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g31374	i0	82.249	0.737991266375546	169	29	73	1	1	168	588717	588549	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	169	145	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
6689890	6689890	PRJNA1164198_P_NODE_21146_length_270_cov_1.517766_g20877_i0	PRJNA1164198	21146	270	1.517766	4.0979682	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	342	1.31e-89	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g20877	i0	89.63	133.048148148148	270	27	100	1	1	270	3992068	3991800	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	35923	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
7965180	7965180	PRJNA1164198_P_NODE_16167_length_308_cov_1.174468_g15898_i0	PRJNA1164198	16167	308	1.174468	3.61736144	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	525	1.4099999999999995e-144	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g15898	i0	97.403	244.857142857143	308	8	100	0	1	308	2488	2795	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	75416	525	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
7965191	7965191	PRJNA1164198_P_NODE_18627_length_287_cov_1.518692_g18358_i0	PRJNA1164198	18627	287	1.518692	4.35864604	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	420	6.31e-113	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g18358	i0	93.056	115.257839721254	288	18	100	2	1	287	1249726	1250012	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	33079	420	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
13065601	13065601	PRJNA1164198_P_NODE_2991_length_725_cov_3.254601_g2770_i0	PRJNA1164198	2991	725	3.254601	23.59585725	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	1201	0	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g2770	i0	96.556	128.51724137931	726	24	100	1	1	725	1070	1795	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	93175	1201	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
13792836	13792836	PRJNA1164198_P_NODE_9311_length_408_cov_2.259701_g9046_i0	PRJNA1164198	9311	408	2.259701	9.21958008	Planctopirus	1649480	Bacteria	Bacteria	749	0	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g9046	i0	99.755	133.252450980392	408	1	100	0	1	408	2794	2387	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	54367	754	0.993368700265252	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
16889127	16889127	PRJNA1164198_P_NODE_5994_length_513_cov_3.020455_g5739_i0	PRJNA1164198	5994	513	3.020455	15.49493415	Prosthecobacter debontii	48467	Bacteria	Bacteria	898	0	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g5739	i0	98.252	274.009746588694	515	5	100	3	1	513	4544	4032	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	140567	898	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
18163607	18163607	PRJNA1164198_P_NODE_28835_length_245_cov_0.906977_g28566_i0	PRJNA1164198	28835	245	0.906977	2.22209365	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	298	2.57e-76	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g28566	i0	88.71	247.408163265306	248	23	100	3	1	245	7051213	7051458	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	60615	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19437961	19437961	PRJNA1164198_P_NODE_29136_length_245_cov_0.906977_g28867_i0	PRJNA1164198	29136	245	0.906977	2.22209365	Planctopirus limnophila	120	Bacteria	Bacteria	137	5.93e-28	NTclustered	gi\|296012614\|gb\|CP001744.1\|	521674	g28867	i0	97.5	1.11428571428571	80	2	55	0	166	245	2052389	2052468	Planctopirus limnophila DSM 3776 chromosome, complete genome	blastn	273	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
20713330	20713330	PRJNA1164198_P_NODE_27937_length_247_cov_0.896552_g27668_i0	PRJNA1164198	27937	247	0.896552	2.21448344	Urbifossiella limnaea	2528023	Bacteria	Bacteria	255	1.59e-63	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g27668	i0	85.714	5.05668016194332	245	31	98	4	5	247	204870	204628	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1249	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
23264192	23264192	PRJNA1164198_P_NODE_2079_length_859_cov_2.913486_g1894_i0	PRJNA1164198	2079	859	2.913486	25.02684474	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	1459	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g1894	i0	97.322	272.527357392317	859	23	100	0	1	859	1052	194	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	234101	1459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis

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