metadata: contig_metadata: 7 rows where bioproject = "PRJNA508758" and tax

7 rows where bioproject = "PRJNA508758" 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
5588577	5588577	PRJNA508758_P_NODE_68785_length_260_cov_1.647059_g67737_i0	PRJNA508758	68785	260	1.647059	4.2823534	Aureliella sp.	2795609	Bacteria	Bacteria	93.5	1.4e-14	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g67737	i0	96.429	24.8230769230769	56	2	22	0	8	63	5751523	5751578	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	6454	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
26950438	26950438	PRJNA508758_P_NODE_78462_length_248_cov_0.880000_g77414_i0	PRJNA508758	78462	248	0.88	2.1824	Chlamydia trachomatis	813	Bacteria	Bacteria	50.1	3.09e-6	NR	CQB88615.1	813	g77414	i0	69	0.350806451612903	29	9	35.1	0	210	124	1	29	CQB88615.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	87	50.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
28056131	28056131	PRJNA508758_P_NODE_31105_length_365_cov_1.571918_g30057_i0	PRJNA508758	31105	365	1.571918	5.7375007	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.6	0.00544	NR	MAG59128.1	2026780	g30057	i0	33.3	0.69041095890411	84	52	69	1	363	112	84	163	MAG59128.1 hypothetical protein [Planctomycetota bacterium]	diamond	252	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29729422	29729422	PRJNA508758_P_NODE_55330_length_287_cov_2.154206_g54282_i0	PRJNA508758	55330	287	2.154206	6.18257122	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	50.1	1.71e-4	NR	MBN1870407.1	2035772	g54282	i0	44.8	2.22648083623693	58	27	55.4	1	164	6	291	348	MBN1870407.1 elongation factor G [Candidatus Omnitrophota bacterium]	diamond	639	50.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
31119496	31119496	PRJNA508758_P_NODE_57175_length_284_cov_0.990521_g56127_i0	PRJNA508758	57175	284	0.990521	2.81307964	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	43.1	0.0416	NR	MDA3874445.1	2212473	g56127	i0	28.6	0.961267605633803	91	54	87.7	3	5	253	14	101	MDA3874445.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	273	43.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31910434	31910434	PRJNA508758_P_NODE_33597_length_353_cov_1.753571_g32549_i0	PRJNA508758	33597	353	1.753571	6.19010563	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.7	0.027	NR	HTG45229.1	2499141	g32549	i0	30	0.934844192634561	110	65	83.3	1	44	337	335	444	HTG45229.1 Ig-like domain-containing protein [Verrucomicrobiia bacterium]	diamond	330	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32732438	32732438	PRJNA508758_P_NODE_78640_length_248_cov_0.880000_g77592_i0	PRJNA508758	78640	248	0.88	2.1824	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	42.4	0.0235	NR	MCP5521441.1	2026801	g77592	i0	34.7	0.870967741935484	72	44	83.5	2	18	224	49	120	MCP5521441.1 type II toxin-antitoxin system VapC family toxin [Verrucomicrobiales bacterium]	diamond	216	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales 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);;