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

9 rows where analysis = "blastn", bioproject = "PRJNA385073" and tax_phylum = "Verrucomicrobiota"

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
406108	406108	PRJNA385073_P_NODE_42881_length_250_cov_1.446328_g42719_i0	PRJNA385073	42881	250	1.446328	3.61582	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	97.1	1.03e-15	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g42719	i0	86.022	1.116	93	10	37	3	100	191	7252435	7252345	Opitutaceae bacterium TAV5, complete genome	blastn	279	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
406121	406121	PRJNA385073_P_NODE_43561_length_250_cov_0.870056_g43399_i0	PRJNA385073	43561	250	0.870056	2.17514	Pedosphaera parvula	1032527	Bacteria	Bacteria	355	1.54e-93	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g43399	i0	92.4	77.032	250	17	100	1	1	250	1953	2200	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	19258	355	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
5509782	5509782	PRJNA385073_P_NODE_4045_length_582_cov_1.489194_g3889_i0	PRJNA385073	4045	582	1.489194	8.66710908	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1048	0	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g3889	i0	99.141	95.2285223367698	582	5	100	0	1	582	737394	736813	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	55423	1048	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15708417	15708417	PRJNA385073_P_NODE_23313_length_302_cov_3.026201_g23151_i0	PRJNA385073	23313	302	3.026201	9.13912702	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	117	9.83e-22	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g23151	i0	78.977	0.582781456953642	176	34	58	3	1	176	5027136	5027308	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	176	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
15708979	15708979	PRJNA385073_P_NODE_49513_length_246_cov_1.410405_g49351_i0	PRJNA385073	49513	246	1.410405	3.4695963	uncultured Verrucomicrobiales bacterium	100234	Bacteria	Bacteria	263	9.430000000000001e-66	NTclustered	gi\|192805056\|emb\|FM175858.1\|	100234	g49351	i0	94.186	70.4024390243902	172	10	70	0	74	245	1	172	Uncultured Verrucomicrobiales bacterium partial 16S rRNA gene, clone CL3.D142	blastn	17319	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium
16983871	16983871	PRJNA385073_P_NODE_60874_length_234_cov_4.136646_g60712_i0	PRJNA385073	60874	234	4.136646	9.67975164	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	372	1.42e-98	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g60712	i0	97.285	268.264957264957	221	3	94	3	15	234	3077	2859	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	62774	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
17653919	17653919	PRJNA385073_P_NODE_48214_length_247_cov_0.885057_g48052_i0	PRJNA385073	48214	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	257	4.41e-64	NTclustered	gi\|2076416356\|gb\|CP076040.1\|	2684114	g48052	i0	85.484	88.2550607287449	248	34	99	2	1	246	4362819	4362572	Opitutia bacterium ISCC 52 isolate E3 chromosome, complete genome	blastn	21799	257	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium ISCC 52
20807556	20807556	PRJNA385073_P_NODE_36117_length_263_cov_1.115789_g35955_i0	PRJNA385073	36117	263	1.115789	2.93452507	Fontisphaera persica	2974023	Bacteria	Bacteria	268	2.1899999999999998e-67	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g35955	i0	85.496	0.996197718631179	262	33	99	5	4	263	1624604	1624346	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	262	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
23358289	23358289	PRJNA385073_P_NODE_48879_length_247_cov_0.885057_g48717_i0	PRJNA385073	48879	247	0.885057	2.18609079	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g48717	i0	98.381	88.2834008097166	247	4	100	0	1	247	15867	15621	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	21806	435	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota 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);;