metadata: contig_metadata: 14 rows where bioproject = "PRJNA815356" and tax

14 rows where bioproject = "PRJNA815356" 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
819075	819075	PRJNA815356_P_NODE_2321_length_437_cov_3.453297_g2159_i0	PRJNA815356	2321	437	3.453297	15.09090789	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	425	2.16e-114	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g2159	i0	84.651	81.6659038901602	430	62	98	4	9	437	2191109	2190683	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	35688	425	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
3370011	3370011	PRJNA815356_P_NODE_9763_length_247_cov_0.896552_g9600_i0	PRJNA815356	9763	247	0.896552	2.21448344	Prosthecobacter debontii	48467	Bacteria	Bacteria	390	4.1699999999999997e-104	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g9600	i0	95.181	277.975708502024	249	8	100	4	1	247	3114	3360	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	68660	390	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
6331991	6331991	PRJNA815356_P_NODE_8785_length_253_cov_1.438889_g8622_i0	PRJNA815356	8785	253	1.438889	3.64038917	Singulisphaera	466152	Bacteria	Bacteria	340	4.379999999999999e-89	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g8622	i0	90.98	92.8893280632411	255	20	100	3	1	253	3	256	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	23501	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
8880942	8880942	PRJNA815356_P_NODE_8627_length_255_cov_1.285714_g8464_i0	PRJNA815356	8627	255	1.285714	3.2785707	Planctomycetia	203683	Bacteria	Bacteria	316	7.44e-82	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g8464	i0	89.412	117.756862745098	255	21	99	6	1	252	121326	121577	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	30028	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
9747222	9747222	PRJNA815356_P_NODE_9188_length_251_cov_0.876404_g9025_i0	PRJNA815356	9188	251	0.876404	2.19977404	Bythopirellula goksoeyrii	1400387	Bacteria	Bacteria	276	1.24e-69	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g9025	i0	86.939	202.593625498008	245	32	98	0	4	248	5093375	5093619	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	50851	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
10156416	10156416	PRJNA815356_P_NODE_4748_length_325_cov_1.932540_g4585_i0	PRJNA815356	4748	325	1.93254	6.280755	Bacteria	2	Bacteria	Bacteria	294	4.6e-75	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g4585	i0	86.517	91.2584615384615	267	36	82	0	59	325	2192287	2192021	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	29659	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
10156425	10156425	PRJNA815356_P_NODE_7548_length_269_cov_1.663265_g7385_i0	PRJNA815356	7548	269	1.663265	4.47418285	Planctomycetia	203683	Bacteria	Bacteria	431	2.71e-116	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g7385	i0	95.896	82.8847583643123	268	7	99	3	1	267	5179151	5178887	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	22296	431	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
11022881	11022881	PRJNA815356_P_NODE_1349_length_556_cov_3.062112_g1188_i0	PRJNA815356	1349	556	3.062112	17.02534272	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	470	1.28e-127	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g1188	i0	82.206	209.379496402878	562	84	100	14	1	556	2584435	2583884	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	116415	470	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
12707463	12707463	PRJNA815356_P_NODE_8990_length_252_cov_0.871508_g8827_i0	PRJNA815356	8990	252	0.871508	2.19620016	Frigoriglobus	2774146	Bacteria	Bacteria	416	7.029999999999999e-112	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g8827	i0	96.443	114.472222222222	253	7	100	2	1	252	2001940	2002191	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	28847	416	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16121745	16121745	PRJNA815356_P_NODE_5453_length_308_cov_1.702128_g5290_i0	PRJNA815356	5453	308	1.702128	5.24255424	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	525	1.4099999999999995e-144	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g5290	i0	97.411	169.535714285714	309	7	100	1	1	308	1114	806	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	52217	525	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
19945682	19945682	PRJNA815356_P_NODE_4816_length_323_cov_2.424000_g4653_i0	PRJNA815356	4816	323	2.424	7.82952	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	505	1.9399999999999995e-138	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g4653	i0	94.785	102.349845201238	326	13	100	4	1	323	7051281	7050957	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	33059	505	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24179554	24179554	PRJNA815356_P_NODE_8699_length_254_cov_1.381215_g8536_i0	PRJNA815356	8699	254	1.381215	3.5082861	Parachlamydia	83551	Bacteria	Bacteria	324	4.43e-84	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g8536	i0	89.883	137.582677165354	257	18	100	7	1	254	788	1039	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	34946	327	0.990825688073395	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
25045443	25045443	PRJNA815356_P_NODE_4820_length_323_cov_1.984000_g4657_i0	PRJNA815356	4820	323	1.984	6.40832	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	459	1.5299999999999999e-124	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g4657	i0	92.523	93.0340557275542	321	22	99	2	4	323	4421662	4421343	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	30050	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
27148820	27148820	PRJNA815356_P_NODE_9142_length_251_cov_0.876404_g8979_i0	PRJNA815356	9142	251	0.876404	2.19977404	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	43.1	0.0294	NR	MEQ8770546.1	2052180	g8979	i0	35	0.717131474103586	60	34	71.7	1	63	242	223	277	MEQ8770546.1 hypothetical protein [Phycisphaerales bacterium]	diamond	180	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;