metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA661142" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA661142" 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
3179053	3179053	PRJNA661142_P_NODE_7883_length_268_cov_19.278539_g7818_i0	PRJNA661142	7883	268	19.278539	51.66648452	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	132	3.06e-26	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g7818	i0	82.55	0.555970149253731	149	26	56	0	120	268	1338565	1338417	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	149	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
9556673	9556673	PRJNA661142_P_NODE_768_length_788_cov_23.121786_g719_i0	PRJNA661142	768	788	23.121786	182.19967368	Isosphaera sp. Io3-6	886834	Bacteria	Bacteria	1303	0	NTclustered	gi\|307591270\|gb\|GQ889467.1\|	886834	g719	i0	98.512	93.6573604060914	739	10	94	1	23	760	1035	297	Isosphaera sp. Io3-6 16S ribosomal RNA gene, partial sequence	blastn	73802	1303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp. Io3-6
9556682	9556682	PRJNA661142_P_NODE_8068_length_264_cov_112.720930_g8003_i0	PRJNA661142	8068	264	112.72093	297.5832552	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	401	2.0799999999999993e-107	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g8003	i0	96	134.704545454545	250	5	94	5	18	264	5935755	5936002	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	35562	401	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13382168	13382168	PRJNA661142_P_NODE_12351_length_163_cov_0.894737_g12286_i0	PRJNA661142	12351	163	0.894737	1.45842131	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	99	1.72e-16	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g12286	i0	78.667	39.9815950920245	150	30	91	2	7	155	74725	74873	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	6517	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
13382174	13382174	PRJNA661142_P_NODE_12731_length_161_cov_0.910714_g12666_i0	PRJNA661142	12731	161	0.910714	1.46624954	Lignipirellula cremea	2528010	Bacteria	Bacteria	128	2.16e-25	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g12666	i0	82.353	3.25465838509317	153	21	92	5	1	148	8902401	8902552	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	524	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
22305387	22305387	PRJNA661142_P_NODE_2198_length_529_cov_24.968750_g2135_i0	PRJNA661142	2198	529	24.96875	132.0846875	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	612	1.8999999999999995e-170	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g2135	i0	89.648	293.319470699433	483	46	91	4	24	503	1867075	1867556	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	155166	612	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
25388119	25388119	PRJNA661142_P_NODE_1760_length_576_cov_50.130930_g1699_i0	PRJNA661142	1760	576	50.13093	288.7541568	Luteolibacter	518753	Bacteria	Bacteria	573	9.809999999999998e-159	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g1699	i0	85.923	233.480902777778	547	65	93	8	39	576	2217888	2217345	Luteolibacter sp. LG18 DNA, complete genome	blastn	134485	573	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18

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