metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA454503" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA454503" 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
1717164	1717164	PRJNA454503_P_NODE_3022_length_689_cov_5.500000_g2725_i0	PRJNA454503	3022	689	5.5	37.895	Humisphaera borealis	2807512	Bacteria	Bacteria	604	4.2099999999999986e-168	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g2725	i0	83.188	108.499274310595	690	87	99	18	1	685	5063348	5062683	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	74756	604	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
6819723	6819723	PRJNA454503_P_NODE_14106_length_306_cov_1.053061_g13777_i0	PRJNA454503	14106	306	1.053061	3.22236666	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	473	5.139999999999999e-129	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g13777	i0	96.516	265.493464052288	287	8	94	2	1	287	1768	1484	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	81241	473	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
6820400	6820400	PRJNA454503_P_NODE_65806_length_208_cov_0.884354_g65477_i0	PRJNA454503	65806	208	0.884354	1.83945632	Humisphaera borealis	2807512	Bacteria	Bacteria	265	2.15e-66	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g65477	i0	89.904	17.9519230769231	208	17	99	4	3	208	5063713	5063508	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	3734	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
8095894	8095894	PRJNA454503_P_NODE_69447_length_207_cov_0.890411_g69118_i0	PRJNA454503	69447	207	0.890411	1.84315077	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g69118	i0	100	0.144927536231884	30	0	14	0	110	139	1644999	1644970	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
8746536	8746536	PRJNA454503_P_NODE_18747_length_275_cov_1.037383_g18418_i0	PRJNA454503	18747	275	1.037383	2.85280325	Verrucomicrobiaceae	203557	Bacteria	Bacteria	436	5.969999999999999e-118	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g18418	i0	95.588	260.189090909091	272	12	99	0	4	275	2182	2453	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	71552	436	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
9370304	9370304	PRJNA454503_P_NODE_43168_length_223_cov_1.604938_g42839_i0	PRJNA454503	43168	223	1.604938	3.57901174	Gemmataceae bacterium	2052164	Bacteria	Bacteria	263	8.4e-66	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g42839	i0	87.892	1	223	27	100	0	1	223	7242577	7242799	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	223	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
10646172	10646172	PRJNA454503_P_NODE_3109_length_679_cov_7.092233_g2810_i0	PRJNA454503	3109	679	7.092233	48.15626207	Paludisphaera borealis	1387353	Bacteria	Bacteria	935	0	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g2810	i0	91.545	136.79970544919	686	47	100	9	1	679	122924	123605	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	92887	935	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
13195665	13195665	PRJNA454503_P_NODE_1551_length_962_cov_6.864595_g1300_i0	PRJNA454503	1551	962	6.864595	66.0374039	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	1044	0	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g1300	i0	86.509	98.943866943867	971	106	100	21	1	962	4554600	4555554	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	95184	1044	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
13196508	13196508	PRJNA454503_P_NODE_8171_length_392_cov_1.178248_g7842_i0	PRJNA454503	8171	392	1.178248	4.61873216	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	481	4.03e-131	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g7842	i0	88.974	237.163265306122	390	42	99	1	1	390	1042	1430	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	92968	481	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
14471465	14471465	PRJNA454503_P_NODE_7292_length_417_cov_1.376404_g6963_i0	PRJNA454503	7292	417	1.376404	5.73960468	Rosistilla carotiformis	2528017	Bacteria	Bacteria	219	3.739999999999999e-52	NTclustered	gi\|1712756907\|gb\|CP036348.1\|	2528017	g6963	i0	77.25	128.175059952038	400	73	94	18	5	394	1459611	1460002	Rosistilla carotiformis strain Poly24 chromosome	blastn	53449	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla carotiformis
18293652	18293652	PRJNA454503_P_NODE_11755_length_329_cov_1.242537_g11426_i0	PRJNA454503	11755	329	1.242537	4.08794673	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	377	4.5e-100	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g11426	i0	88.715	101.465045592705	319	23	95	11	19	329	7051680	7051367	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	33382	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23395228	23395228	PRJNA454503_P_NODE_90719_length_167_cov_4.292453_g90390_i0	PRJNA454503	90719	167	4.292453	7.16839651	Humisphaera borealis	2807512	Bacteria	Bacteria	217	4.69e-52	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g90390	i0	91.72	131.167664670659	157	12	94	1	6	162	5062978	5062823	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	21905	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
24045729	24045729	PRJNA454503_P_NODE_69099_length_207_cov_0.890411_g68770_i0	PRJNA454503	69099	207	0.890411	1.84315077	Gemmata	113	Bacteria	Bacteria	156	1.34e-33	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g68770	i0	80.556	3.1304347826087	216	30	100	4	1	207	2954944	2955156	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	648	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
24668687	24668687	PRJNA454503_P_NODE_48440_length_217_cov_1.666667_g48111_i0	PRJNA454503	48440	217	1.666667	3.61666739	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	158	3.95e-34	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g48111	i0	87.5	30.4562211981567	136	17	63	0	1	136	2859414	2859549	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	6609	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;