metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1253698" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1253698" 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
359526	359526	PRJNA1253698_S_NODE_12121_length_200_cov_1.026490_g11755_i0	PRJNA1253698	12121	200	1.02649	2.05298	Congregicoccus parvus	3081749	Bacteria	Bacteria	368	1.52e-97	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g11755	i0	100	119.575	199	0	99	0	2	200	1304862	1304664	Opitutales bacterium ASA1 DNA, complete genome	blastn	23915	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
359580	359580	PRJNA1253698_S_NODE_3241_length_388_cov_2.097345_g2876_i0	PRJNA1253698	3241	388	2.097345	8.1376986	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	438	2.429999999999999e-118	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g2876	i0	88.714	78.4072164948454	381	13	98	15	7	386	1250514	1250163	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	30422	438	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
1052810	1052810	PRJNA1253698_S_NODE_22261_length_163_cov_1.359649_g21895_i0	PRJNA1253698	22261	163	1.359649	2.21622787	Planctomycetia	203683	Bacteria	Bacteria	235	1.26e-57	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g21895	i0	93.21	42.8773006134969	162	8	99	2	3	163	122582	122741	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	6989	237	0.991561181434599	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
1634425	1634425	PRJNA1253698_S_NODE_17802_length_169_cov_1.275000_g17436_i0	PRJNA1253698	17802	169	1.275	2.15475	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	272	9.95e-69	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g17436	i0	95.833	15.0769230769231	168	7	99	0	1	168	2253	2420	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	2548	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
3603164	3603164	PRJNA1253698_S_NODE_11943_length_201_cov_1.539474_g11577_i0	PRJNA1253698	11943	201	1.539474	3.09434274	Parachlamydia	83551	Bacteria	Bacteria	311	2.61e-80	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g11577	i0	94.949	114.248756218905	198	10	99	0	1	198	1106	909	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	22964	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
5462970	5462970	PRJNA1253698_S_NODE_12545_length_197_cov_0.871622_g12179_i0	PRJNA1253698	12545	197	0.871622	1.71709534	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	246	7.29e-61	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g12179	i0	96.622	190.060913705584	148	5	75	0	2	149	2002707	2002560	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	37442	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8013109	8013109	PRJNA1253698_S_NODE_21227_length_165_cov_0.887931_g20861_i0	PRJNA1253698	21227	165	0.887931	1.46508615	Bremerella volcania	2527984	Bacteria	Bacteria	154	3.68e-33	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g20861	i0	87.313	154.357575757576	134	17	85	0	4	137	2674515	2674648	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	25469	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
8013121	8013121	PRJNA1253698_S_NODE_2707_length_433_cov_2.403646_g2343_i0	PRJNA1253698	2707	433	2.403646	10.40778718	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	418	3.5799999999999995e-112	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g2343	i0	84.439	162.15935334873	437	55	98	10	8	432	7050836	7050401	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	70215	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9287890	9287890	PRJNA1253698_S_NODE_4448_length_330_cov_1.217082_g4082_i0	PRJNA1253698	4448	330	1.217082	4.0163706	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	453	7.29e-123	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g4082	i0	91.541	138.981818181818	331	24	99	4	1	329	2061045	2060717	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	45864	453	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
9980877	9980877	PRJNA1253698_S_NODE_4188_length_340_cov_3.302405_g3822_i0	PRJNA1253698	4188	340	3.302405	11.228177	Isosphaeraceae	1763524	Bacteria	Bacteria	484	2.6699999999999994e-132	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g3822	i0	92.353	173.144117647059	340	26	100	0	1	340	5180272	5180611	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	58869	488	0.991803278688525	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
10563762	10563762	PRJNA1253698_S_NODE_21109_length_165_cov_0.896552_g20743_i0	PRJNA1253698	21109	165	0.896552	1.4793108	Rosistilla ulvae	1930277	Bacteria	Bacteria	169	1.31e-37	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g20743	i0	90.625	65.1757575757576	128	10	77	2	1	127	975932	976058	Rosistilla ulvae strain EC9 chromosome	blastn	10754	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
11838277	11838277	PRJNA1253698_S_NODE_17110_length_172_cov_1.186992_g16744_i0	PRJNA1253698	17110	172	1.186992	2.04162624	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	283	4.700000000000002e-72	NTclustered	gi\|880804243\|gb\|KT262987.1\|	174324	g16744	i0	97.024	91.5174418604651	168	5	98	0	2	169	168	1	Uncultured Chlamydiales bacterium clone SW2A 16S ribosomal RNA gene, partial sequence	blastn	15741	283	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
13113531	13113531	PRJNA1253698_S_NODE_20751_length_165_cov_1.163793_g20385_i0	PRJNA1253698	20751	165	1.163793	1.92025845	Symmachiella dynata	2527995	Bacteria	Bacteria	150	4.76e-32	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g20385	i0	85.034	60.5212121212121	147	22	89	0	4	150	1041607	1041461	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	9986	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
14388814	14388814	PRJNA1253698_S_NODE_6692_length_266_cov_0.875576_g6326_i0	PRJNA1253698	6692	266	0.875576	2.32903216	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	344	3.58e-90	NTclustered	gi\|576901465\|gb\|KF827058.1\|	120965	g6326	i0	90.299	39.6127819548872	268	19	99	7	2	266	306	43	Uncultured planctomycete clone B-30-43 16S ribosomal RNA gene, partial sequence	blastn	10537	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
15662553	15662553	PRJNA1253698_S_NODE_18313_length_168_cov_1.949580_g17947_i0	PRJNA1253698	18313	168	1.94958	3.2752944	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	272	9.95e-69	NTclustered	gi\|219857449\|ref\|NR_025037.1\|	112235	g17947	i0	100	97.5952380952381	147	0	88	0	1	147	279	425	Neochlamydia hartmannellae strain A1Hsp 16S ribosomal RNA, partial sequence	blastn	16396	272	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
19485668	19485668	PRJNA1253698_S_NODE_17296_length_171_cov_1.262295_g16930_i0	PRJNA1253698	17296	171	1.262295	2.15852445	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	274	2.8099999999999996e-69	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g16930	i0	95.858	168.654970760234	169	7	99	0	2	170	2681	2513	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	28840	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
19485740	19485740	PRJNA1253698_S_NODE_9716_length_221_cov_1.087209_g9350_i0	PRJNA1253698	9716	221	1.087209	2.40273189	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	298	2.28e-76	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g9350	i0	90.991	108.995475113122	222	18	100	2	1	221	2060160	2060380	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	24088	298	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
20761213	20761213	PRJNA1253698_S_NODE_14757_length_183_cov_1.604478_g14391_i0	PRJNA1253698	14757	183	1.604478	2.93619474	Waddlia malaysiensis	219016	Bacteria	Bacteria	167	5.33e-37	NTclustered	gi\|27903501\|gb\|AY184804.1\|	219016	g14391	i0	83.616	135.415300546448	177	27	96	2	5	180	2073	2248	Waddlia sp. G817 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24781	167	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia malaysiensis
20761266	20761266	PRJNA1253698_S_NODE_6717_length_265_cov_1.703704_g6351_i0	PRJNA1253698	6717	265	1.703704	4.5148156	Aquisphaera giovannonii	406548	Bacteria	Bacteria	433	7.399999999999998e-117	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g6351	i0	96.212	179.301886792453	264	10	99	0	2	265	5181004	5180741	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	47515	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
22036321	22036321	PRJNA1253698_S_NODE_19938_length_166_cov_1.307692_g19572_i0	PRJNA1253698	19938	166	1.307692	2.17076872	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	202	1.2999999999999998e-47	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g19572	i0	88.69	37.2289156626506	168	15	100	4	1	166	7050404	7050239	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	6180	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24585978	24585978	PRJNA1253698_S_NODE_4480_length_328_cov_2.369176_g4114_i0	PRJNA1253698	4480	328	2.369176	7.77089728	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	370	7.5e-98	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g4114	i0	87.311	95.3993902439024	331	33	98	8	6	328	7051687	7051358	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	31291	370	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);;