metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1126661" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1126661" 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
282160	282160	PRJNA1126661_P_NODE_15601_length_326_cov_4.885375_g15072_i0	PRJNA1126661	15601	326	4.885375	15.9263225	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	182	3.749999999999999e-41	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g15072	i0	89.041	1.17791411042945	146	16	45	0	3	148	13910	14055	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	384	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
1557442	1557442	PRJNA1126661_P_NODE_81902_length_218_cov_4.303448_g81372_i0	PRJNA1126661	81902	218	4.303448	9.38151664	Gimesia chilikensis	2605989	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1712542717\|gb\|CP036342.1\|	2605989	g81372	i0	100	0.903669724770642	29	0	13	0	25	53	7149306	7149278	Gimesia chilikensis strain MalM14 chromosome	blastn	197	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia chilikensis
2833172	2833172	PRJNA1126661_P_NODE_4383_length_417_cov_4.648256_g3856_i0	PRJNA1126661	4383	417	4.648256	19.38322752	Gemmataceae bacterium	2052164	Bacteria	Bacteria	473	7.219999999999999e-129	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g3856	i0	87.381	101.213429256595	420	44	99	9	2	417	320357	319943	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	42206	473	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
2833488	2833488	PRJNA1126661_P_NODE_80843_length_222_cov_4.550336_g80313_i0	PRJNA1126661	80843	222	4.550336	10.10174592	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	241	3.9200000000000003e-59	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g80313	i0	88.119	0.90990990990991	202	24	91	0	1	202	367878	368079	Luteolibacter sp. Populi chromosome, complete genome	blastn	202	241	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
4109589	4109589	PRJNA1126661_P_NODE_51464_length_294_cov_5.452489_g50935_i0	PRJNA1126661	51464	294	5.452489	16.03031766	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	183	9.27e-42	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g50935	i0	88.667	29.5748299319728	150	17	51	0	145	294	145914	145765	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	8695	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4858924	4858924	PRJNA1126661_P_NODE_29064_length_326_cov_2.727273_g28535_i0	PRJNA1126661	29064	326	2.727273	8.89090998	Gemmata	113	Bacteria	Bacteria	198	3.72e-46	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g28535	i0	90.667	31.1564417177914	150	12	46	2	178	326	6451049	6450901	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	10157	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
6660019	6660019	PRJNA1126661_P_NODE_17326_length_326_cov_4.450593_g16797_i0	PRJNA1126661	17326	326	4.450593	14.50893318	Lignipirellula cremea	2528010	Bacteria	Bacteria	147	1.37e-30	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g16797	i0	85.034	1.5	147	18	44	3	176	320	9103595	9103739	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	489	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
6660741	6660741	PRJNA1126661_P_NODE_9366_length_326_cov_7.806324_g8837_i0	PRJNA1126661	9366	326	7.806324	25.44861624	Pirellulimonas nuda	2528009	Bacteria	Bacteria	119	2.98e-22	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g8837	i0	81.208	1.84662576687117	149	26	45	2	4	151	363613	363760	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	602	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
7935674	7935674	PRJNA1126661_P_NODE_60367_length_277_cov_2.303922_g59837_i0	PRJNA1126661	60367	277	2.303922	6.38186394	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	130	1.14e-25	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g59837	i0	82.119	51.4909747292419	151	27	55	0	24	174	2041224	2041374	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	14263	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11234525	11234525	PRJNA1126661_P_NODE_74589_length_242_cov_0.923077_g74059_i0	PRJNA1126661	74589	242	0.923077	2.23384634	Akkermansia	239934	Bacteria	Bacteria	246	9.32e-61	NTclustered	gi\|183579827\|emb\|AM905424.1\|	239935	g74059	i0	88.945	243.409090909091	199	22	82	0	1	199	1001	1199	Akkermansia muciniphila 23S rRNA gene, strain CIP107961	blastn	58905	246	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
12509961	12509961	PRJNA1126661_P_NODE_9730_length_326_cov_7.498024_g9201_i0	PRJNA1126661	9730	326	7.498024	24.44355824	Gemmata	113	Bacteria	Bacteria	233	1.02e-56	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g9201	i0	95.238	80.8588957055215	147	7	91	0	178	324	4797965	4797819	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	26360	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
13036581	13036581	PRJNA1126661_P_NODE_8491_length_326_cov_8.944664_g7962_i0	PRJNA1126661	8491	326	8.944664	29.15960464	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	233	1.02e-56	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g7962	i0	94.667	14.5184049079755	150	8	91	0	177	326	271648	271797	Lacipirellula limnantheis strain I41 chromosome	blastn	4733	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
15585582	15585582	PRJNA1126661_P_NODE_61253_length_275_cov_2.113861_g60723_i0	PRJNA1126661	61253	275	2.113861	5.81311775	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	206	1.83e-48	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g60723	i0	91.333	5.03272727272727	150	13	100	0	126	275	1210119	1209970	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	1384	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
20684228	20684228	PRJNA1126661_P_NODE_77977_length_231_cov_10.873418_g77447_i0	PRJNA1126661	77977	231	10.873418	25.11759558	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	315	2.38e-81	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g77447	i0	92.377	65.2813852813853	223	13	96	4	1	221	2003316	2003096	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	15080	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
21959208	21959208	PRJNA1126661_P_NODE_38578_length_301_cov_3.951754_g38049_i0	PRJNA1126661	38578	301	3.951754	11.89477954	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	67.6	1e-6	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g38049	i0	83.333	10.3023255813953	78	8	26	5	223	300	8506911	8506983	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	3101	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata

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