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

8 rows where analysis = "blastn", bioproject = "PRJNA715462" 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
706388	706388	PRJNA715462_P_NODE_63861_length_244_cov_0.900585_g63065_i0	PRJNA715462	63861	244	0.900585	2.1974274	Opitutales bacterium	2026772	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2891482117\|emb\|OZ219851.1\|	2026772	g63065	i0	96.774	0.127049180327869	31	1	13	0	90	120	1524794	1524764	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 10	blastn	31	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
3257235	3257235	PRJNA715462_P_NODE_37443_length_289_cov_0.916667_g36647_i0	PRJNA715462	37443	289	0.916667	2.64916763	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	237	6.88e-58	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g36647	i0	82.374	2.79930795847751	278	43	95	5	12	286	2178581	2178855	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	809	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
5809524	5809524	PRJNA715462_P_NODE_36645_length_291_cov_1.412844_g35849_i0	PRJNA715462	36645	291	1.412844	4.11137604	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	195	4.23e-45	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g35849	i0	80.153	73.3676975945017	262	50	90	2	31	291	3051575	3051835	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	21350	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
5810007	5810007	PRJNA715462_P_NODE_62105_length_245_cov_0.895349_g61309_i0	PRJNA715462	62105	245	0.895349	2.19360505	Limnoglobus roseus	2598579	Bacteria	Bacteria	333	7.049999999999999e-87	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g61309	i0	91.358	2.00816326530612	243	21	99	0	1	243	8044201	8043959	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	492	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
8359101	8359101	PRJNA715462_P_NODE_32647_length_311_cov_0.894958_g31851_i0	PRJNA715462	32647	311	0.894958	2.78331938	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g31851	i0	100	0.527331189710611	30	0	10	0	185	214	1852363	1852334	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	164	56.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
11395894	11395894	PRJNA715462_P_NODE_56529_length_248_cov_0.880000_g55733_i0	PRJNA715462	56529	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	237	5.77e-58	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g55733	i0	84.81	19.3629032258065	237	34	95	2	9	244	2196621	2196386	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	4802	239	0.99163179916318	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
19833259	19833259	PRJNA715462_P_NODE_61196_length_245_cov_0.895349_g60400_i0	PRJNA715462	61196	245	0.895349	2.19360505	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	206	1.6e-48	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g60400	i0	86.957	0.751020408163265	184	22	75	2	40	222	194676	194858	Planctomyces sp. SH-PL62, complete genome	blastn	184	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
22383485	22383485	PRJNA715462_P_NODE_42418_length_273_cov_2.815000_g41622_i0	PRJNA715462	42418	273	2.815	7.68495	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g41622	i0	100	0.102564102564103	28	0	10	0	9	36	3193309	3193336	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	28	52.8	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);;