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

7 rows where analysis = "blastn", bioproject = "PRJNA675331" 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
4475790	4475790	PRJNA675331_P_NODE_3544_length_498_cov_1.232941_g3373_i0	PRJNA675331	3544	498	1.232941	6.14004618	Aureliella sp.	2795609	Bacteria	Bacteria	455	3.1700000000000005e-123	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g3373	i0	83.399	214.574297188755	506	69	100	12	1	498	5640175	5640673	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	106858	455	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
6272478	6272478	PRJNA675331_P_NODE_23885_length_241_cov_0.916667_g23713_i0	PRJNA675331	23885	241	0.916667	2.20916747	Singulisphaera	466152	Bacteria	Bacteria	296	9.08e-76	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g23713	i0	90.043	181.178423236515	231	19	95	4	12	241	916	689	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	43664	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
8301118	8301118	PRJNA675331_P_NODE_23907_length_241_cov_0.916667_g23735_i0	PRJNA675331	23907	241	0.916667	2.20916747	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	322	1.5e-83	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g23735	i0	92.511	129.203319502075	227	14	93	3	1	225	4421026	4421251	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	31138	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
8301144	8301144	PRJNA675331_P_NODE_7887_length_348_cov_1.120000_g7715_i0	PRJNA675331	7887	348	1.12	3.8976	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	429	1.3e-115	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g7715	i0	89.504	110.57183908046	343	31	98	4	1	341	1844352	1844691	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	38479	429	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
13401879	13401879	PRJNA675331_P_NODE_7751_length_350_cov_1.357401_g7579_i0	PRJNA675331	7751	350	1.357401	4.7509035	planctomycete str. 449	79870	Bacteria	Bacteria	544	4.4699999999999996e-150	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g7579	i0	95.087	401.06	346	15	99	2	5	350	349	6	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	140371	544	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
15950446	15950446	PRJNA675331_P_NODE_11033_length_303_cov_0.934783_g10861_i0	PRJNA675331	11033	303	0.934783	2.83239249	planctomycete str. 449	79870	Bacteria	Bacteria	532	8.269999999999998e-147	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g10861	i0	98.35	137.244224422442	303	5	100	0	1	303	1051	749	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	41585	532	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
21050339	21050339	PRJNA675331_P_NODE_917_length_933_cov_1.281395_g785_i0	PRJNA675331	917	933	1.281395	11.955415350000001	Fontisphaera persica	2974023	Bacteria	Bacteria	976	0	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g785	i0	85.638	219.992497320472	940	122	99	13	3	933	3861198	3862133	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	205253	976	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica

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