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

10 rows where analysis = "blastn", bioproject = "PRJNA906294" 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
2163462	2163462	PRJNA906294_P_NODE_221502_length_244_cov_1.029240_g217386_i0	PRJNA906294	221502	244	1.02924	2.5113456	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	346	9.019999999999999e-91	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g217386	i0	95.392	189.049180327869	217	10	89	0	1	217	2498040	2497824	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	46128	346	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
2163567	2163567	PRJNA906294_P_NODE_226322_length_242_cov_2.366864_g222206_i0	PRJNA906294	226322	242	2.366864	5.72781088	Urbifossiella limnaea	2528023	Bacteria	Bacteria	215	2.63e-51	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g222206	i0	82.988	1.66942148760331	241	38	99	3	3	242	3846345	3846583	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	404	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
3437520	3437520	PRJNA906294_P_NODE_166523_length_290_cov_1.649770_g162407_i0	PRJNA906294	166523	290	1.64977	4.784333	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	239	1.92e-58	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g162407	i0	81.973	100.558620689655	294	42	99	10	4	290	3453834	3454123	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	29162	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
5990260	5990260	PRJNA906294_P_NODE_170185_length_286_cov_1.399061_g166069_i0	PRJNA906294	170185	286	1.399061	4.00131446	Adhaeretor mobilis	1930276	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1712449852\|gb\|CP036263.1\|	1930276	g166069	i0	100	0.0979020979020979	28	0	10	0	121	148	1256132	1256159	Adhaeretor mobilis strain HG15A2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Adhaeretor	Adhaeretor mobilis
9814743	9814743	PRJNA906294_P_NODE_164608_length_292_cov_3.584475_g160492_i0	PRJNA906294	164608	292	3.584475	10.466667	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	213	1.17e-50	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g160492	i0	85.784	135.753424657534	204	25	69	4	27	228	4317090	4317291	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	39640	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13640810	13640810	PRJNA906294_P_NODE_179351_length_276_cov_1.339901_g175235_i0	PRJNA906294	179351	276	1.339901	3.69812676	Fontisphaera persica	2974023	Bacteria	Bacteria	324	4.87e-84	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g175235	i0	87.9	41.2898550724638	281	27	99	5	3	276	3861594	3861874	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	11396	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
14915720	14915720	PRJNA906294_P_NODE_205112_length_250_cov_4.124294_g200996_i0	PRJNA906294	205112	250	4.124294	10.310735	Candidatus Xiphinematobacter sp. Idaho Grape	1704307	Bacteria	Bacteria	329	9.34e-86	NTclustered	gi\|939198278\|gb\|CP012665.1\|	1704307	g200996	i0	90.476	163.316	252	20	99	3	1	249	15769	15519	Candidatus Xiphinematobacter sp. Idaho Grape, complete genome	blastn	40829	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp. Idaho Grape
17826396	17826396	PRJNA906294_P_NODE_77354_length_506_cov_1.302540_g73245_i0	PRJNA906294	77354	506	1.30254	6.5908524	Schlesneria	656899	Bacteria	Bacteria	462	1.93e-125	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g73245	i0	83.562	372.509881422925	511	66	100	12	1	506	586	89	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	188490	462	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
18739463	18739463	PRJNA906294_P_NODE_211755_length_248_cov_0.868571_g207639_i0	PRJNA906294	211755	248	0.868571	2.15405608	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	300	7.26e-77	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g207639	i0	88.71	85.875	248	25	99	3	1	246	2621794	2622040	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	21297	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
23838766	23838766	PRJNA906294_P_NODE_157359_length_301_cov_4.859649_g153243_i0	PRJNA906294	157359	301	4.859649	14.62754349	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	372	1.89e-98	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g153243	i0	89.037	222.129568106312	301	31	100	2	1	301	3894530	3894828	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	66861	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;