metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA897077" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA897077" 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
4702165	4702165	PRJNA897077_P_NODE_15844_length_252_cov_0.871508_g15717_i0	PRJNA897077	15844	252	0.871508	2.19620016	Candidatus Piscichlamydia cyprini	1233676	Bacteria	Bacteria	353	5.59e-93	NTclustered	gi\|406857609\|gb\|JX470313.1\|	1233676	g15717	i0	92.095	80.25	253	17	100	3	1	252	266	16	Candidatus Piscichlamydia cyprinis isolate E4 16S ribosomal RNA gene, partial sequence	blastn	20223	353	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Piscichlamydiaceae	Candidatus Piscichlamydia	Candidatus Piscichlamydia cyprini
7251664	7251664	PRJNA897077_P_NODE_11486_length_292_cov_0.835616_g11359_i0	PRJNA897077	11486	292	0.835616	2.43999872	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	351	2.38e-92	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g11359	i0	88.514	76.0034246575343	296	27	100	6	1	292	4959863	4960155	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	22193	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
7251849	7251849	PRJNA897077_P_NODE_4326_length_465_cov_1.163265_g4199_i0	PRJNA897077	4326	465	1.163265	5.40918225	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	641	2.11e-179	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g4199	i0	91.649	167.008602150538	467	33	99	6	1	463	2002707	2002243	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	77659	641	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8526352	8526352	PRJNA897077_P_NODE_13267_length_272_cov_2.231156_g13140_i0	PRJNA897077	13267	272	2.231156	6.06874432	Urbifossiella limnaea	2528023	Bacteria	Bacteria	298	2.9e-76	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g13140	i0	86.397	133.0625	272	37	100	0	1	272	2018537	2018266	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	36193	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11447893	11447893	PRJNA897077_P_NODE_2689_length_585_cov_1.558594_g2562_i0	PRJNA897077	2689	585	1.558594	9.1177749	Bacteria	2	Bacteria	Bacteria	641	2.6999999999999992e-179	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g2562	i0	86.464	447.594871794872	591	72	100	7	1	585	2003016	2002428	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	261843	641	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
12352437	12352437	PRJNA897077_P_NODE_10090_length_311_cov_0.983193_g9963_i0	PRJNA897077	10090	311	0.983193	3.05773023	Urbifossiella limnaea	2528023	Bacteria	Bacteria	370	7.06e-98	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g9963	i0	88.35	69.5176848874598	309	35	99	1	2	309	2018022	2017714	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	21620	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
12352473	12352473	PRJNA897077_P_NODE_12230_length_283_cov_1.857143_g12103_i0	PRJNA897077	12230	283	1.857143	5.25571469	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	418	2.2399999999999995e-112	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g12103	i0	93.286	360.268551236749	283	19	100	0	1	283	4959852	4959570	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	101956	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
13627360	13627360	PRJNA897077_P_NODE_15451_length_253_cov_0.866667_g15324_i0	PRJNA897077	15451	253	0.866667	2.19266751	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	60.2	1.37e-4	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g15324	i0	92.683	0.162055335968379	41	3	16	0	186	226	1886225	1886185	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	41	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
17451856	17451856	PRJNA897077_P_NODE_2094_length_662_cov_2.112054_g1968_i0	PRJNA897077	2094	662	2.112054	13.981797479999999	Urbifossiella limnaea	2528023	Bacteria	Bacteria	723	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g1968	i0	86.527	78.9924471299094	668	77	100	10	1	662	2018210	2017550	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	52293	723	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
22550530	22550530	PRJNA897077_P_NODE_4158_length_474_cov_1.897756_g4031_i0	PRJNA897077	4158	474	1.897756	8.99536344	Urbifossiella limnaea	2528023	Bacteria	Bacteria	665	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g4031	i0	92.308	150.289029535865	468	36	99	0	1	468	2020018	2019551	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	71237	665	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
23825759	23825759	PRJNA897077_P_NODE_16499_length_250_cov_0.881356_g16372_i0	PRJNA897077	16499	250	0.881356	2.20339	Planctomycetia bacterium	2052181	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1927964719\|gb\|CP054188.1\|	2052181	g16372	i0	100	3.972	250	0	100	0	1	250	3418930	3419179	MAG: Planctomycetia bacterium isolate H1_AMX1 chromosome, complete genome	blastn	993	462	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
23825839	23825839	PRJNA897077_P_NODE_2999_length_557_cov_1.853306_g2872_i0	PRJNA897077	2999	557	1.853306	10.32291442	Gemmataceae bacterium	2052164	Bacteria	Bacteria	671	0	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g2872	i0	88.51	149.524236983842	557	60	99	4	1	556	320503	319950	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	83285	671	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
25470823	25470823	PRJNA897077_P_NODE_10380_length_306_cov_2.008584_g10253_i0	PRJNA897077	10380	306	2.008584	6.14626704	Frigoriglobus	2774146	Bacteria	Bacteria	407	5.29e-109	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g10253	i0	90.615	92.3496732026144	309	25	100	4	1	306	2003052	2003359	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	28259	407	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);;