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

11 rows where analysis = "blastn", bioproject = "PRJNA782235" 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
763325	763325	PRJNA782235_P_NODE_21221_length_247_cov_0.885057_g21032_i0	PRJNA782235	21221	247	0.885057	2.18609079	Urbifossiella limnaea	2528023	Bacteria	Bacteria	145	3.58e-30	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g21032	i0	80	6.8663967611336	210	31	83	10	34	237	5686932	5687136	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1696	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
2039408	2039408	PRJNA782235_P_NODE_27782_length_241_cov_0.916667_g27593_i0	PRJNA782235	27782	241	0.916667	2.20916747	Aquisphaera giovannonii	406548	Bacteria	Bacteria	279	9.14e-71	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g27593	i0	87.552	1	241	30	100	0	1	241	1663112	1663352	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	241	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
7141695	7141695	PRJNA782235_P_NODE_11006_length_283_cov_1.266667_g10817_i0	PRJNA782235	11006	283	1.266667	3.58466761	Urbifossiella limnaea	2528023	Bacteria	Bacteria	313	1.09e-80	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g10817	i0	86.713	33.5371024734982	286	32	99	6	1	282	2020030	2020313	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	9491	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
7142044	7142044	PRJNA782235_P_NODE_8726_length_307_cov_0.987179_g8537_i0	PRJNA782235	8726	307	0.987179	3.03063953	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	396	1.15e-105	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g8537	i0	91.93	202.954397394137	285	20	92	3	8	290	2750194	2750477	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	62307	396	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12691952	12691952	PRJNA782235_P_NODE_15710_length_254_cov_0.850829_g15521_i0	PRJNA782235	15710	254	0.850829	2.16110566	Chlamydiia	204429	Bacteria	Bacteria	283	7.51e-72	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g15521	i0	87.059	168.188976377953	255	28	98	5	1	250	405	659	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	42720	285	0.992982456140351	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
16065704	16065704	PRJNA782235_P_NODE_14333_length_262_cov_1.566138_g14144_i0	PRJNA782235	14333	262	1.566138	4.10328156	Blastopirellula sp. J2-11	2943192	Bacteria	Bacteria	198	2.9e-46	NTclustered	gi\|2283101653\|gb\|CP097384.1\|	2943192	g14144	i0	83.105	102.446564885496	219	35	84	2	44	262	2919561	2919777	Blastopirellula sp. J2-11 chromosome	blastn	26841	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp. J2-11
19890247	19890247	PRJNA782235_P_NODE_26536_length_242_cov_0.911243_g26347_i0	PRJNA782235	26536	242	0.911243	2.20520806	Symmachiella dynata	2527995	Bacteria	Bacteria	76.8	1.29e-9	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g26347	i0	94.118	1.6900826446281	51	2	21	1	29	78	5156278	5156328	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	409	76.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
19890254	19890254	PRJNA782235_P_NODE_27256_length_242_cov_0.911243_g27067_i0	PRJNA782235	27256	242	0.911243	2.20520806	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	381	2.449999999999999e-101	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g27067	i0	95.781	71.1198347107438	237	8	97	2	1	235	7501797	7502033	Tautonia plasticadhaerens strain ElP chromosome	blastn	17211	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
20338766	20338766	PRJNA782235_P_NODE_22596_length_246_cov_0.890173_g22407_i0	PRJNA782235	22596	246	0.890173	2.18982558	Pirellula	123	Bacteria	Bacteria	364	2.509999999999999e-96	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g22407	i0	93.496	144.060975609756	246	14	100	1	1	246	830	587	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	35439	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
21166078	21166078	PRJNA782235_P_NODE_6037_length_359_cov_1.346154_g5848_i0	PRJNA782235	6037	359	1.346154	4.83269286	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	612	1.2399999999999996e-170	NTclustered	gi\|380838170\|gb\|JN868141.1\|	120965	g5848	i0	97.493	97.9888579387187	359	8	100	1	1	359	760	403	Uncultured planctomycete clone LZX186 16S ribosomal RNA gene, partial sequence	blastn	35178	612	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
25439100	25439100	PRJNA782235_P_NODE_13260_length_269_cov_1.153061_g13071_i0	PRJNA782235	13260	269	1.153061	3.10173409	Chlamydiia	204429	Bacteria	Bacteria	244	3.79e-60	NTclustered	gi\|1000729566\|gb\|KT030899.1\|	1345621	g13071	i0	86.147	58.7992565055762	231	26	84	6	2	228	1709	1937	Candidatus Similichlamydia labri strain SM160513-33 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	15817	244	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Parilichlamydiaceae	Candidatus Similichlamydia	Candidatus Similichlamydia labri

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