metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA438572" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA438572" 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
435059	435059	PRJNA438572_P_NODE_24121_length_242_cov_0.923077_g24002_i0	PRJNA438572	24121	242	0.923077	2.23384634	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	364	2.4699999999999992e-96	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g24002	i0	93.802	177.099173553719	242	15	100	0	1	242	5171957	5171716	Lacipirellula limnantheis strain I41 chromosome	blastn	42858	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
1090915	1090915	PRJNA438572_P_NODE_10121_length_322_cov_2.016064_g10002_i0	PRJNA438572	10121	322	2.016064	6.49172608	Verrucomicrobiota	74201	Bacteria	Bacteria	507	5.37e-139	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g10002	i0	95.062	35.7763975155279	324	12	100	3	1	322	5153022	5153343	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	11520	512	0.990234375	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1709769	1709769	PRJNA438572_P_NODE_12642_length_290_cov_1.437788_g12523_i0	PRJNA438572	12642	290	1.437788	4.1695852	Horticoccus luteus	2862869	Bacteria	Bacteria	464	2.9099999999999993e-126	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g12523	i0	95.517	221.68275862069	290	13	100	0	1	290	541268	541557	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	64288	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
5538713	5538713	PRJNA438572_P_NODE_19525_length_249_cov_0.886364_g19406_i0	PRJNA438572	19525	249	0.886364	2.20704636	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	265	2.6599999999999997e-66	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g19406	i0	86.722	40.8353413654619	241	28	96	3	11	249	1830851	1830613	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	10168	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
8088095	8088095	PRJNA438572_P_NODE_12927_length_288_cov_0.855814_g12808_i0	PRJNA438572	12927	288	0.855814	2.46474432	Lacipirellula parvula	2650471	Bacteria	Bacteria	318	2.3799999999999995e-82	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g12808	i0	87.368	124.604166666667	285	26	98	8	1	281	5162957	5163235	Lacipirellula parvula PX69 DNA, complete genome	blastn	35886	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
8088129	8088129	PRJNA438572_P_NODE_14667_length_272_cov_1.070352_g14548_i0	PRJNA438572	14667	272	1.070352	2.91135744	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	60.2	1.49e-4	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g14548	i0	100	0.117647058823529	32	0	12	0	138	169	3648388	3648419	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	32	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
9362999	9362999	PRJNA438572_P_NODE_18608_length_250_cov_2.220339_g18489_i0	PRJNA438572	18608	250	2.220339	5.5508475	Urbifossiella limnaea	2528023	Bacteria	Bacteria	285	2.05e-72	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g18489	i0	87.2	1	250	32	100	0	1	250	2521034	2520785	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	250	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
10638776	10638776	PRJNA438572_P_NODE_11749_length_300_cov_1.030837_g11630_i0	PRJNA438572	11749	300	1.030837	3.092511	Aeoliella mucimassa	2527972	Bacteria	Bacteria	392	1.4499999999999994e-104	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g11630	i0	90.635	116.666666666667	299	23	99	5	1	296	2043155	2043451	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	35000	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa

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