metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA689790" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA689790" 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
668711	668711	PRJNA689790_S_NODE_14201_length_160_cov_2.170732_g14086_i0	PRJNA689790	14201	160	2.170732	3.4731712	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	183	4.5099999999999996e-42	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g14086	i0	90.58	6.41875	138	13	86	0	1	138	2191690	2191553	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	1027	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
9597288	9597288	PRJNA689790_S_NODE_4988_length_270_cov_21.502146_g4873_i0	PRJNA689790	4988	270	21.502146	58.0557942	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g4873	i0	96.97	0.122222222222222	33	0	12	1	141	173	1708785	1708754	Luteolibacter sp. Populi chromosome, complete genome	blastn	33	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
16480978	16480978	PRJNA689790_S_NODE_2453_length_410_cov_3.329759_g2338_i0	PRJNA689790	2453	410	3.329759	13.6520119	Verrucomicrobiota	74201	Bacteria	Bacteria	490	7.04e-134	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g2338	i0	88.452	134.521951219512	407	46	99	1	3	409	2407	2002	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	55154	492	0.995934959349594	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
21071204	21071204	PRJNA689790_S_NODE_9897_length_188_cov_2.013245_g9782_i0	PRJNA689790	9897	188	2.013245	3.7849006	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	222	1.16e-53	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g9782	i0	89.266	10.6010638297872	177	19	94	0	12	188	1867436	1867260	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	1993	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
24894919	24894919	PRJNA689790_S_NODE_16460_length_151_cov_2.394737_g16345_i0	PRJNA689790	16460	151	2.394737	3.61605287	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	207	2.49e-49	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g16345	i0	91.447	42.7086092715232	152	12	100	1	1	151	1867034	1866883	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	6449	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;