metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA898105" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA898105" 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
3424673	3424673	PRJNA898105_P_NODE_7563_length_245_cov_0.895349_g7363_i0	PRJNA898105	7563	245	0.895349	2.19360505	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g7363	i0	97.959	227.955102040816	245	5	100	0	1	245	532	776	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	55849	425	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
3424682	3424682	PRJNA898105_P_NODE_8103_length_242_cov_0.911243_g7903_i0	PRJNA898105	8103	242	0.911243	2.20520806	Planctomycetales bacterium ZRK34	2723666	Bacteria	Bacteria	63.9	1.01e-5	NTclustered	gi\|1898316769\|gb\|CP050848.1\|	2723666	g7903	i0	93.023	0.177685950413223	43	3	18	0	200	242	594295	594337	Planctomycetales bacterium ZRK34 chromosome, complete genome	blastn	43	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium ZRK34
5977138	5977138	PRJNA898105_P_NODE_3745_length_298_cov_1.555556_g3545_i0	PRJNA898105	3745	298	1.555556	4.63555688	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	440	5.059999999999997e-119	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g3545	i0	93.289	116.684563758389	298	20	100	0	1	298	2060038	2059741	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	34772	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
5977160	5977160	PRJNA898105_P_NODE_6405_length_250_cov_0.870056_g6205_i0	PRJNA898105	6405	250	0.870056	2.17514	Lacipirellula parvula	2650471	Bacteria	Bacteria	340	4.31e-89	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g6205	i0	91.2	1	250	22	100	0	1	250	3775882	3776131	Lacipirellula parvula PX69 DNA, complete genome	blastn	250	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
7252013	7252013	PRJNA898105_P_NODE_8446_length_236_cov_2.404908_g8246_i0	PRJNA898105	8446	236	2.404908	5.67558288	uncultured Chlamydia sp.	199738	Bacteria	Bacteria	381	2.379999999999999e-101	NTclustered	gi\|170792156\|gb\|EU403820.1\|	199738	g8246	i0	95.763	106.728813559322	236	10	100	0	1	236	378	143	Uncultured Chlamydia sp. clone MP9B13 16S ribosomal RNA gene, partial sequence	blastn	25188	381	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	uncultured Chlamydia sp.
7622250	7622250	PRJNA898105_P_NODE_3146_length_330_cov_1.198444_g2946_i0	PRJNA898105	3146	330	1.198444	3.9548652	Chlamydiia	204429	Bacteria	Bacteria	431	3.419999999999999e-116	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g2946	i0	90.741	100.318181818182	324	29	98	1	1	324	2363406	2363728	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	33105	433	0.995381062355658	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
12723751	12723751	PRJNA898105_P_NODE_1970_length_426_cov_1.699717_g1770_i0	PRJNA898105	1970	426	1.699717	7.24079442	Chlamydiia	204429	Bacteria	Bacteria	604	2.509999999999999e-168	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g1770	i0	92.272	137.478873239437	427	32	100	1	1	426	2361608	2361182	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	58566	604	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
16546739	16546739	PRJNA898105_P_NODE_4353_length_283_cov_1.642857_g4153_i0	PRJNA898105	4353	283	1.642857	4.64928531	Humisphaera	2807511	Bacteria	Bacteria	361	3.82e-95	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g4153	i0	92.829	91.0459363957597	251	14	88	3	32	281	5064105	5063858	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	25766	363	0.994490358126722	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
17452022	17452022	PRJNA898105_P_NODE_2534_length_369_cov_1.040541_g2334_i0	PRJNA898105	2534	369	1.040541	3.83959629	Candidatus Syngnamydia medusae	3141954	Bacteria	Bacteria	492	1.7399999999999996e-134	NTclustered	gi\|1127901232\|emb\|LT599033.1\|	3141954	g2334	i0	90.786	383.777777777778	369	32	99	2	1	368	3328	2961	Uncultured Simkania sp. partial 23S rRNA gene, isolate M1	blastn	141614	492	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia medusae
23826011	23826011	PRJNA898105_P_NODE_6759_length_248_cov_1.320000_g6559_i0	PRJNA898105	6759	248	1.32	3.2736	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	403	5.38e-108	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g6559	i0	95.968	126.016129032258	248	10	100	0	1	248	1826610	1826363	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	31252	403	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales 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);;