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

7 rows where analysis = "blastn", bioproject = "PRJEB50332" 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
119446	119446	PRJEB50332_P_NODE_16541_length_204_cov_0.909091_g16459_i0	PRJEB50332	16541	204	0.909091	1.85454564	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	217	5.959999999999999e-52	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g16459	i0	88.525	9.12745098039216	183	16	88	5	4	183	473	293	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	1862	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
7368787	7368787	PRJEB50332_P_NODE_14886_length_207_cov_0.890411_g14804_i0	PRJEB50332	14886	207	0.890411	1.84315077	Akkermansia	239934	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|2240218473\|gb\|CP097283.1\|	239935	g14804	i0	100	99.7149758454106	207	0	100	0	1	207	874343	874137	Akkermansia muciniphila strain NB2A-8-WC chromosome	blastn	20641	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
7771877	7771877	PRJEB50332_P_NODE_4347_length_287_cov_1.548673_g4265_i0	PRJEB50332	4347	287	1.548673	4.44469151	Humisphaera borealis	2807512	Bacteria	Bacteria	427	3.7699999999999997e-115	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g4265	i0	94.585	480.81881533101	277	13	97	1	1	277	5063276	5063550	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	137995	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
9046693	9046693	PRJEB50332_P_NODE_3208_length_324_cov_1.114068_g3126_i0	PRJEB50332	3208	324	1.114068	3.60958032	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	364	3.439999999999999e-96	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g3126	i0	87.195	44.7746913580247	328	32	100	8	1	324	1600613	1600292	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	14507	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
9046731	9046731	PRJEB50332_P_NODE_6648_length_244_cov_1.808743_g6566_i0	PRJEB50332	6648	244	1.808743	4.41333292	Urbifossiella limnaea	2528023	Bacteria	Bacteria	318	1.9699999999999998e-82	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6566	i0	93.088	3.86065573770492	217	15	89	0	6	222	5053910	5054126	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	942	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
17971098	17971098	PRJEB50332_P_NODE_9835_length_225_cov_1.585366_g9753_i0	PRJEB50332	9835	225	1.585366	3.5670735	Lacipirellula parvula	2650471	Bacteria	Bacteria	302	1.8e-77	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g9753	i0	91.031	0.991111111111111	223	20	99	0	1	223	3022423	3022201	Lacipirellula parvula PX69 DNA, complete genome	blastn	223	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
20520258	20520258	PRJEB50332_P_NODE_10777_length_220_cov_1.547170_g10695_i0	PRJEB50332	10777	220	1.54717	3.403774	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	366	6.13e-97	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g10695	i0	96.804	34.7909090909091	219	7	99	0	1	219	736117	735899	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	7654	366	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);;