metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1067443" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1067443" 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
2732137	2732137	PRJNA1067443_P_NODE_363_length_756_cov_19.622255_g348_i0	PRJNA1067443	363	756	19.622255	148.3442478	Saltatorellus ferox	2528018	Bacteria	Bacteria	322	5.23e-83	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g348	i0	81.818	40.2830687830688	396	60	80	10	336	725	3393953	3393564	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	30454	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
4007819	4007819	PRJNA1067443_P_NODE_1384_length_523_cov_4.551111_g1366_i0	PRJNA1067443	1384	523	4.551111	23.80231053	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	348	5.84e-91	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g1366	i0	79.792	0.917782026768642	480	96	92	1	44	523	783169	783647	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	480	348	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
7834124	7834124	PRJNA1067443_P_NODE_2847_length_423_cov_2.340000_g2829_i0	PRJNA1067443	2847	423	2.34	9.8982	Limnoglobus roseus	2598579	Bacteria	Bacteria	233	1.3599999999999998e-56	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g2829	i0	80.808	2.2789598108747	297	57	70	0	127	423	9006183	9006479	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	964	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
11660134	11660134	PRJNA1067443_P_NODE_20330_length_245_cov_0.895349_g20312_i0	PRJNA1067443	20330	245	0.895349	2.19360505	Limnoglobus roseus	2598579	Bacteria	Bacteria	143	1.28e-29	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g20312	i0	81.765	32.1102040816327	170	31	69	0	31	200	4966726	4966895	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	7867	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
14210178	14210178	PRJNA1067443_P_NODE_19412_length_246_cov_0.890173_g19394_i0	PRJNA1067443	19412	246	0.890173	2.18982558	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	104	6.05e-18	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g19394	i0	88.764	1.01219512195122	89	5	35	4	53	138	3229767	3229681	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	249	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
16758517	16758517	PRJNA1067443_P_NODE_24454_length_197_cov_4.903226_g24436_i0	PRJNA1067443	24454	197	4.903226	9.65935522	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	342	9.039999999999999e-90	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g24436	i0	97.97	111.548223350254	197	4	100	0	1	197	558035	558231	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	21975	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18033182	18033182	PRJNA1067443_P_NODE_17695_length_249_cov_0.875000_g17677_i0	PRJNA1067443	17695	249	0.875	2.17875	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g17677	i0	97.059	0.136546184738956	34	0	13	1	198	230	2267311	2267278	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	34	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
21858581	21858581	PRJNA1067443_P_NODE_9798_length_287_cov_0.934579_g9780_i0	PRJNA1067443	9798	287	0.934579	2.68224173	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	141	5.510000000000001e-29	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g9780	i0	77.51	4.0383275261324	249	46	85	10	1	244	505567	505810	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	1159	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
23133754	23133754	PRJNA1067443_P_NODE_17859_length_249_cov_0.875000_g17841_i0	PRJNA1067443	17859	249	0.875	2.17875	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	340	4.29e-89	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g17841	i0	91.498	7.89156626506024	247	21	99	0	3	249	2441310	2441064	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	1965	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
24407237	24407237	PRJNA1067443_P_NODE_13480_length_265_cov_1.416667_g13462_i0	PRJNA1067443	13480	265	1.416667	3.75416755	Urbifossiella limnaea	2528023	Bacteria	Bacteria	217	8.119999999999999e-52	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g13462	i0	81.579	1.00377358490566	266	45	99	3	1	264	3190849	3190586	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	266	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
24407301	24407301	PRJNA1067443_P_NODE_16240_length_251_cov_1.662921_g16222_i0	PRJNA1067443	16240	251	1.662921	4.17393171	Pirellula staleyi	125	Bacteria	Bacteria	67.6	8.12e-7	NTclustered	gi\|283436255\|gb\|CP001848.1\|	530564	g16222	i0	87.931	0.442231075697211	58	5	23	2	14	70	1030518	1030574	Pirellula staleyi DSM 6068 chromosome, complete genome	blastn	111	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi

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