metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA806354" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA806354" 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
3357031	3357031	PRJNA806354_P_NODE_4103_length_669_cov_2.927852_g3996_i0	PRJNA806354	4103	669	2.927852	19.58732988	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1098	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g3996	i0	96.263	262.866965620329	669	25	100	0	1	669	861	193	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	175858	1098	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
11009956	11009956	PRJNA806354_P_NODE_41549_length_239_cov_5.548193_g41440_i0	PRJNA806354	41549	239	5.548193	13.26018127	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	425	1.1e-114	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g41440	i0	98.745	267.97489539749	239	3	100	0	1	239	2190	2428	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	64046	425	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
12285480	12285480	PRJNA806354_P_NODE_38390_length_245_cov_2.470930_g38281_i0	PRJNA806354	38390	245	2.47093	6.0537785	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	318	1.9699999999999998e-82	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g38281	i0	92.07	109.028571428571	227	16	93	2	1	227	2582744	2582968	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	26712	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
13559716	13559716	PRJNA806354_P_NODE_9271_length_460_cov_3.713178_g9162_i0	PRJNA806354	9271	460	3.713178	17.0806188	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	649	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g9162	i0	92.157	246.408695652174	459	36	99	0	1	459	2192048	2192506	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	113348	649	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
22483011	22483011	PRJNA806354_P_NODE_39578_length_243_cov_7.982353_g39469_i0	PRJNA806354	39578	243	7.982353	19.39711779	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g39469	i0	100	262.777777777778	243	0	100	0	1	243	2384	2626	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	63855	449	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
23758753	23758753	PRJNA806354_P_NODE_6519_length_541_cov_4.720085_g6410_i0	PRJNA806354	6519	541	4.720085	25.53565985	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	706	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g6410	i0	90.538	95.1700554528651	539	43	99	8	3	537	2190679	2190145	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	51487	706	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;