metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA807685" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA807685" 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
806568	806568	PRJNA807685_P_NODE_33981_length_215_cov_1.724719_g32908_i0	PRJNA807685	33981	215	1.724719	3.70814585	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	231	2.27e-56	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g32908	i0	86.111	84.3488372093023	216	28	100	2	1	215	299522	299308	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	18135	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
3357685	3357685	PRJNA807685_P_NODE_8743_length_594_cov_1.691203_g7745_i0	PRJNA807685	8743	594	1.691203	10.04574582	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	527	8.009999999999997e-145	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g7745	i0	86.122	1.18013468013468	490	66	82	2	2	490	3732339	3731851	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	701	527	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
4634887	4634887	PRJNA807685_P_NODE_21704_length_295_cov_1.124031_g20631_i0	PRJNA807685	21704	295	1.124031	3.31589145	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	191	5.56e-44	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g20631	i0	78.819	1.30508474576271	288	58	97	3	9	295	3516600	3516885	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	385	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
8459722	8459722	PRJNA807685_P_NODE_55787_length_164_cov_0.921260_g54714_i0	PRJNA807685	55787	164	0.92126	1.5108664	Planctomycetia bacterium	2052181	Bacteria	Bacteria	141	2.84e-29	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g54714	i0	90.566	1.95731707317073	106	10	65	0	32	137	602654	602759	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	321	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
11010324	11010324	PRJNA807685_P_NODE_22729_length_285_cov_1.834677_g21656_i0	PRJNA807685	22729	285	1.834677	5.22882945	Phycisphaera sp.	2030824	Bacteria	Bacteria	106	1.99e-18	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g21656	i0	87.912	1.49122807017544	91	9	32	2	139	228	2947128	2947039	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	425	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
17384936	17384936	PRJNA807685_P_NODE_44774_length_183_cov_1.061644_g43701_i0	PRJNA807685	44774	183	1.061644	1.94280852	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	198	1.8899999999999998e-46	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g43701	i0	87.719	89.3989071038251	171	19	93	2	14	183	2191275	2191444	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	16360	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
22483404	22483404	PRJNA807685_P_NODE_29898_length_235_cov_1.368687_g28825_i0	PRJNA807685	29898	235	1.368687	3.21641445	Limnoglobus roseus	2598579	Bacteria	Bacteria	207	4.25e-49	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g28825	i0	83.186	5.53617021276596	226	38	96	0	1	226	4412105	4412330	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	1301	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
25032918	25032918	PRJNA807685_P_NODE_22320_length_289_cov_1.373016_g21247_i0	PRJNA807685	22320	289	1.373016	3.96801624	Thermogutta terrifontis	1331910	Bacteria	Bacteria	87.9	7.33e-13	NTclustered	gi\|1238331385\|gb\|CP018477.1\|	1331910	g21247	i0	86.585	1.4636678200692	82	7	28	4	182	261	4202519	4202440	Thermogutta terrifontis strain R1 chromosome, complete genome	blastn	423	87.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae	Thermogutta	Thermogutta terrifontis

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