metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA520845" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA520845" 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
489812	489812	PRJNA520845_P_NODE_200661_length_261_cov_1.361702_g199162_i0	PRJNA520845	200661	261	1.361702	3.55404222	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	350	7.539999999999999e-92	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g199162	i0	90.805	15.8812260536398	261	24	100	0	1	261	3253576	3253316	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	4145	350	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
1765445	1765445	PRJNA520845_P_NODE_214042_length_251_cov_0.865169_g212543_i0	PRJNA520845	214042	251	0.865169	2.17157419	Akkermansia muciniphila	239935	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g212543	i0	100	16.1115537848606	251	0	100	0	1	251	1836756	1836506	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	4044	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
3040414	3040414	PRJNA520845_P_NODE_183203_length_275_cov_1.524752_g181704_i0	PRJNA520845	183203	275	1.524752	4.193068	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	76.8	1.5e-9	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g181704	i0	91.071	0.549090909090909	56	5	21	0	130	185	869768	869713	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	151	76.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
5594461	5594461	PRJNA520845_P_NODE_229305_length_248_cov_0.880000_g227806_i0	PRJNA520845	229305	248	0.88	2.1824	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	204	5.849999999999999e-48	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g227806	i0	82.353	66.25	238	38	95	4	11	246	7379421	7379186	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	16430	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
10697230	10697230	PRJNA520845_P_NODE_93409_length_384_cov_1.771704_g91910_i0	PRJNA520845	93409	384	1.771704	6.80334336	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	311	5.48e-80	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g91910	i0	82.486	16.453125	354	62	92	0	31	384	1894050	1894403	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	6318	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11969765	11969765	PRJNA520845_P_NODE_243110_length_245_cov_2.412791_g241611_i0	PRJNA520845	243110	245	2.412791	5.91133795	Akkermansia muciniphila	239935	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2756360508\|gb\|CP156688.1\|	239935	g241611	i0	100	100	245	0	100	0	1	245	2505602	2505846	Akkermansia muciniphila strain AKK-TMU chromosome, complete genome	blastn	24500	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
17066426	17066426	PRJNA520845_P_NODE_176354_length_281_cov_0.932692_g174855_i0	PRJNA520845	176354	281	0.932692	2.62086452	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	449	7.86e-122	NTclustered	gi\|1590092048\|gb\|MK616426.1\|	305355	g174855	i0	95.699	112.523131672598	279	12	99	0	3	281	584	306	Uncultured Chlamydiae bacterium clone LG126_2 16S ribosomal RNA gene, partial sequence	blastn	31619	449	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
23442957	23442957	PRJNA520845_P_NODE_225919_length_249_cov_0.875000_g224420_i0	PRJNA520845	225919	249	0.875	2.17875	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	255	1.6e-63	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g224420	i0	86.192	96.5341365461847	239	29	95	4	1	237	7630767	7631003	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	24037	255	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);;