metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA283169" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA283169" and tax_phylum = "Planctomycetota"

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
371804	371804	PRJNA283169_P_NODE_6441_length_169_cov_1.016667_g6378_i0	PRJNA283169	6441	169	1.016667	1.71816723	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	158	2.91e-34	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g6378	i0	90.678	215.201183431953	118	11	70	0	6	123	3454591	3454708	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	36369	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
5475228	5475228	PRJNA283169_P_NODE_885_length_412_cov_1.878788_g823_i0	PRJNA283169	885	412	1.878788	7.74060656	Gemmataceae bacterium	2052164	Bacteria	Bacteria	588	2.4399999999999994e-163	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g823	i0	98.788	101.507281553398	330	4	100	0	1	330	319633	319962	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	41821	588	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
10575720	10575720	PRJNA283169_P_NODE_3689_length_216_cov_1.730539_g3626_i0	PRJNA283169	3689	216	1.730539	3.73796424	Caulifigura coniformis	2527983	Bacteria	Bacteria	267	6.25e-67	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g3626	i0	88.889	15.8935185185185	216	24	100	0	1	216	2926057	2926272	Caulifigura coniformis strain Pan44 chromosome	blastn	3433	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
15674480	15674480	PRJNA283169_P_NODE_3733_length_215_cov_1.548193_g3670_i0	PRJNA283169	3733	215	1.548193	3.32861495	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	296	7.93e-76	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g3670	i0	93.171	111.125581395349	205	9	93	4	1	201	7051628	7051425	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	23892	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16949152	16949152	PRJNA283169_P_NODE_3954_length_211_cov_0.950617_g3891_i0	PRJNA283169	3954	211	0.950617	2.00580187	Caulifigura coniformis	2527983	Bacteria	Bacteria	346	7.59e-91	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g3891	i0	96.226	127.293838862559	212	6	100	2	1	211	2926655	2926865	Caulifigura coniformis strain Pan44 chromosome	blastn	26859	346	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
19497694	19497694	PRJNA283169_P_NODE_2456_length_263_cov_1.836449_g2394_i0	PRJNA283169	2456	263	1.836449	4.82986087	Humisphaera borealis	2807512	Bacteria	Bacteria	372	1.62e-98	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g2394	i0	92.636	17.6235741444867	258	19	98	0	1	258	5062908	5063165	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	4635	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
20773289	20773289	PRJNA283169_P_NODE_6257_length_171_cov_1.557377_g6194_i0	PRJNA283169	6257	171	1.557377	2.66311467	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	217	4.8e-52	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g6194	i0	89.595	134.631578947368	173	14	99	4	2	171	7051977	7051806	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	23022	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23323804	23323804	PRJNA283169_P_NODE_2859_length_245_cov_2.081633_g2796_i0	PRJNA283169	2859	245	2.081633	5.10000085	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	342	1.17e-89	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g2796	i0	91.903	151.391836734694	247	17	100	2	1	245	7051862	7052107	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	37091	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24597889	24597889	PRJNA283169_P_NODE_4680_length_196_cov_1.061224_g4617_i0	PRJNA283169	4680	196	1.061224	2.07999904	Gimesia panareensis	2527978	Bacteria	Bacteria	82.4	2.16e-11	NTclustered	gi\|1712615819\|gb\|CP036277.1\|	2527978	g4617	i0	92.857	2.20918367346939	56	4	29	0	28	83	2381233	2381178	Gimesia panareensis strain Pan110 chromosome, complete genome	blastn	433	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia panareensis

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);;