metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax_phylum = "Verrucomicrobiota"

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
759289	759289	PRJNA781196_P_NODE_40261_length_282_cov_1.492823_g39884_i0	PRJNA781196	40261	282	1.492823	4.20976086	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	514	2.76e-141	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g39884	i0	99.644	259.617021276596	281	1	99	0	2	282	4722	4442	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	73212	514	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
2035312	2035312	PRJNA781196_P_NODE_38122_length_289_cov_1.083333_g37745_i0	PRJNA781196	38122	289	1.083333	3.13083237	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	462	1.04e-125	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g37745	i0	95.517	142.826989619377	290	12	100	1	1	289	3046326	3046615	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	41277	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
4587880	4587880	PRJNA781196_P_NODE_58104_length_248_cov_0.891429_g57727_i0	PRJNA781196	58104	248	0.891429	2.21074392	Chthoniobacter flavus	191863	Bacteria	Bacteria	368	1.96e-97	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g57727	i0	95.279	270.915322580645	233	10	94	1	1	233	2418	2187	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	67187	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
19886487	19886487	PRJNA781196_P_NODE_59996_length_246_cov_1.676301_g59619_i0	PRJNA781196	59996	246	1.676301	4.12370046	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g59619	i0	98.78	98.7845528455285	246	3	100	0	1	246	869	624	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	24301	438	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii

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