metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1111082" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1111082" 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
4042248	4042248	PRJNA1111082_P_NODE_7104_length_303_cov_1.134783_g7059_i0	PRJNA1111082	7104	303	1.134783	3.43839249	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	303	7.06e-78	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g7059	i0	85.099	4.89108910891089	302	39	99	4	1	299	3216247	3216545	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1482	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
5318346	5318346	PRJNA1111082_P_NODE_8125_length_284_cov_1.582938_g8080_i0	PRJNA1111082	8125	284	1.582938	4.49554392	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	217	8.79e-52	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g8080	i0	81.004	1.87676056338028	279	48	98	4	2	278	4821548	4821273	Lacipirellula limnantheis strain I41 chromosome	blastn	533	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
9142963	9142963	PRJNA1111082_P_NODE_3188_length_430_cov_1.092437_g3143_i0	PRJNA1111082	3188	430	1.092437	4.6974791	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	326	2.21e-84	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g3143	i0	81.022	2.81860465116279	411	76	95	2	21	430	4559574	4559983	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1212	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
12969241	12969241	PRJNA1111082_P_NODE_4611_length_366_cov_0.962457_g4566_i0	PRJNA1111082	4611	366	0.962457	3.52259262	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	222	2.5e-53	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g4566	i0	84.932	43.4535519125683	219	33	60	0	131	349	1050706	1050488	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	15904	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15518037	15518037	PRJNA1111082_P_NODE_6733_length_310_cov_1.729958_g6688_i0	PRJNA1111082	6733	310	1.729958	5.3628698	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	512	1.11e-140	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g6688	i0	96.452	231.81935483871	310	11	100	0	1	310	2748601	2748292	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	71864	512	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20616662	20616662	PRJNA1111082_P_NODE_9957_length_257_cov_2.119565_g9912_i0	PRJNA1111082	9957	257	2.119565	5.44728205	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	243	1.2900000000000001e-59	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g9912	i0	84.553	4.83268482490272	246	36	95	2	13	257	2800909	2800665	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	1242	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
23167605	23167605	PRJNA1111082_P_NODE_12619_length_242_cov_0.923077_g12574_i0	PRJNA1111082	12619	242	0.923077	2.23384634	Lacipirellula parvula	2650471	Bacteria	Bacteria	322	1.5e-83	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g12574	i0	90.833	1.1198347107438	240	22	99	0	1	240	529002	528763	Lacipirellula parvula PX69 DNA, complete genome	blastn	271	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula

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