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

12 rows where analysis = "blastn", bioproject = "PRJNA909412" 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
1249231	1249231	PRJNA909412_P_NODE_12981_length_161_cov_2.008197_g12840_i0	PRJNA909412	12981	161	2.008197	3.23319717	Rosistilla	2795779	Bacteria	Bacteria	167	4.5799999999999995e-37	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g12840	i0	85.976	115.062111801242	164	14	99	9	3	161	974730	974889	Rosistilla ulvae strain EC9 chromosome	blastn	18525	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
3441497	3441497	PRJNA909412_P_NODE_1863_length_399_cov_2.166667_g1723_i0	PRJNA909412	1863	399	2.166667	8.64500133	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	636	8.299999999999999e-178	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1723	i0	95.489	163.611528822055	399	16	100	1	1	399	1808	1412	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	65281	636	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
5077425	5077425	PRJNA909412_P_NODE_12184_length_163_cov_1.725806_g12043_i0	PRJNA909412	12184	163	1.725806	2.81306378	Gemmataceae	1914233	Bacteria	Bacteria	209	7.62e-50	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g12043	i0	90.244	356.398773006135	164	10	98	6	1	160	3633834	3633673	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	58093	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
5993871	5993871	PRJNA909412_P_NODE_1185_length_515_cov_2.941176_g1048_i0	PRJNA909412	1185	515	2.941176	15.1470564	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	523	8.889999999999997e-144	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1048	i0	89.951	240.594174757282	408	37	79	3	2	408	1384	980	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	123906	523	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
5993947	5993947	PRJNA909412_P_NODE_3785_length_270_cov_1.909091_g3644_i0	PRJNA909412	3785	270	1.909091	5.1545457	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	455	1.6100000000000002e-123	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g3644	i0	97.037	84.9037037037037	270	8	100	0	1	270	5153588	5153319	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	22924	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12728684	12728684	PRJNA909412_P_NODE_9410_length_175_cov_1.220588_g9269_i0	PRJNA909412	9410	175	1.220588	2.136029	Gimesia	1649453	Bacteria	Bacteria	95.3	2.42e-15	NTclustered	gi\|1712496122\|gb\|CP036269.1\|	2527973	g9269	i0	77.64	21.5085714285714	161	33	92	3	1	161	2394735	2394892	Gimesia alba strain Pan241w chromosome	blastn	3764	95.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia alba
16193475	16193475	PRJNA909412_P_NODE_1853_length_400_cov_2.445983_g1713_i0	PRJNA909412	1853	400	2.445983	9.783932	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	662	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g1713	i0	96.725	160.4025	397	13	99	0	4	400	653	257	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	64161	662	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
17468980	17468980	PRJNA909412_P_NODE_3274_length_291_cov_1.416667_g3133_i0	PRJNA909412	3274	291	1.416667	4.12250097	Lignipirellula cremea	2528010	Bacteria	Bacteria	315	3.11e-81	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g3133	i0	89.02	96.7457044673539	255	26	87	2	35	288	1144396	1144143	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	28153	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
17468997	17468997	PRJNA909412_P_NODE_6194_length_211_cov_0.953488_g6053_i0	PRJNA909412	6194	211	0.953488	2.01185968	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	379	7.489999999999999e-101	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g6053	i0	99.052	119.284360189573	211	2	100	0	1	211	664	874	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	25169	379	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
19100684	19100684	PRJNA909412_P_NODE_11135_length_171_cov_3.272727_g10994_i0	PRJNA909412	11135	171	3.272727	5.59636317	Prosthecobacter	48463	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|219846433\|ref\|NR_026024.1\|	48464	g10994	i0	100	100.005847953216	171	0	100	0	1	171	1230	1060	Prosthecobacter fusiformis strain FC4 16S ribosomal RNA, partial sequence	blastn	17101	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
20375513	20375513	PRJNA909412_P_NODE_17536_length_150_cov_2.846847_g17395_i0	PRJNA909412	17536	150	2.846847	4.2702705	Bacteria	2	Bacteria	Bacteria	207	2.46e-49	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g17395	i0	91.946	10.04	149	10	99	2	2	150	2582829	2582975	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	1506	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
23842953	23842953	PRJNA909412_P_NODE_7139_length_197_cov_4.392405_g6998_i0	PRJNA909412	7139	197	4.392405	8.65303785	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.9	7.88e-6	NTclustered	gi\|2907625648\|emb\|OZ223208.1\|	2026780	g6998	i0	95.122	1.11675126903553	41	1	20	1	104	143	1495077	1495117	MAG: Planctomycetota bacterium isolate 604ccff8-4b2f-4b13-82eb-4b7433267518 genome assembly, chromosome: 1	blastn	220	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;