metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA795663" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA795663" 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
779523	779523	PRJNA795663_S_NODE_8621_length_205_cov_3.982143_g8516_i0	PRJNA795663	8621	205	3.982143	8.16339315	Gemmataceae bacterium	2052164	Bacteria	Bacteria	329	7.39e-86	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g8516	i0	95.61	118.346341463415	205	9	100	0	1	205	319354	319150	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	24261	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
3330622	3330622	PRJNA795663_S_NODE_6163_length_237_cov_2.540000_g6058_i0	PRJNA795663	6163	237	2.54	6.0198	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	305	1.48e-78	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g6058	i0	94.472	230.324894514768	199	9	84	2	39	237	1484	1680	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	54587	305	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
3330638	3330638	PRJNA795663_S_NODE_7223_length_222_cov_1.372973_g7118_i0	PRJNA795663	7223	222	1.372973	3.04800006	Limnoglobus roseus	2598579	Bacteria	Bacteria	316	6.319999999999998e-82	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g7118	i0	92.694	43.4189189189189	219	16	100	0	1	219	2956673	2956891	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	9639	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
5044555	5044555	PRJNA795663_S_NODE_344_length_821_cov_5.272959_g278_i0	PRJNA795663	344	821	5.272959	43.29099339	Verrucomicrobiota	74201	Bacteria	Bacteria	928	0	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g278	i0	87.093	200.237515225335	829	95	100	11	1	821	915447	914623	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	164395	928	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5882825	5882825	PRJNA795663_S_NODE_12405_length_177_cov_1.828571_g12300_i0	PRJNA795663	12405	177	1.828571	3.23657067	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	292	8.09e-75	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g12300	i0	96.61	18.0790960451977	177	4	100	2	1	177	5153596	5153422	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	3200	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7157681	7157681	PRJNA795663_S_NODE_14466_length_166_cov_2.046512_g14361_i0	PRJNA795663	14466	166	2.046512	3.39720992	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	193	7.85e-45	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g14361	i0	89.677	14.5361445783133	155	11	91	5	16	166	1599153	1599306	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	2413	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
7157836	7157836	PRJNA795663_S_NODE_4806_length_266_cov_2.445415_g4701_i0	PRJNA795663	4806	266	2.445415	6.5048039	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	279	1.03e-70	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g4701	i0	87.2	208.342105263158	250	26	94	4	4	253	2002884	2002641	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	55419	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9707560	9707560	PRJNA795663_S_NODE_14668_length_165_cov_2.101562_g14563_i0	PRJNA795663	14668	165	2.101562	3.4675773	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	217	4.619999999999999e-52	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g14563	i0	90.303	202.2	165	16	100	0	1	165	2751010	2750846	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	33363	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12258768	12258768	PRJNA795663_S_NODE_10850_length_187_cov_1.026667_g10745_i0	PRJNA795663	10850	187	1.026667	1.91986729	Paludisphaera borealis	1387353	Bacteria	Bacteria	307	3.09e-79	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g10745	i0	96.277	43.6310160427808	188	6	100	1	1	187	122562	122375	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	8159	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
14808015	14808015	PRJNA795663_S_NODE_3372_length_313_cov_1.163043_g3267_i0	PRJNA795663	3372	313	1.163043	3.64032459	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	435	2.49e-117	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g3267	i0	91.693	22.9968051118211	313	26	100	0	1	313	5153948	5153636	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	7198	435	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18630782	18630782	PRJNA795663_S_NODE_10935_length_186_cov_1.852349_g10830_i0	PRJNA795663	10935	186	1.852349	3.44536914	Humisphaera borealis	2807512	Bacteria	Bacteria	211	2.48e-50	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g10830	i0	87.097	13.6505376344086	186	24	100	0	1	186	5063212	5063027	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	2539	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
18630945	18630945	PRJNA795663_S_NODE_2255_length_377_cov_2.141176_g2150_i0	PRJNA795663	2255	377	2.141176	8.07223352	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	401	3.089999999999999e-107	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g2150	i0	89.623	16.6472148541114	318	30	84	3	39	353	1316471	1316154	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	6276	401	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22456652	22456652	PRJNA795663_S_NODE_6758_length_228_cov_2.246073_g6653_i0	PRJNA795663	6758	228	2.246073	5.12104644	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	344	2.99e-90	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g6653	i0	93.886	184.092105263158	229	13	100	1	1	228	2002284	2002512	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	41973	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23732103	23732103	PRJNA795663_S_NODE_12379_length_177_cov_2.121429_g12274_i0	PRJNA795663	12379	177	2.121429	3.75492933	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	263	6.349999999999999e-66	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g12274	i0	93.714	108.242937853107	175	11	99	0	1	175	2002475	2002649	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	19159	263	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);;