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

8 rows where analysis = "blastn", bioproject = "PRJNA1022392" 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
1437228	1437228	PRJNA1022392_P_NODE_66782_length_168_cov_5.190083_g66113_i0	PRJNA1022392	66782	168	5.190083	8.71933944	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	193	7.97e-45	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g66113	i0	87.805	0.976190476190476	164	20	98	0	2	165	6058012	6058175	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	164	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
3988876	3988876	PRJNA1022392_P_NODE_55384_length_183_cov_2.323529_g54715_i0	PRJNA1022392	55384	183	2.323529	4.25205807	uncultured Planctomycetia bacterium	411917	Bacteria	Bacteria	298	1.81e-76	NTclustered	gi\|2259143267\|emb\|OW924839.1\|	411917	g54715	i0	96.154	96.1803278688525	182	7	99	0	1	182	162	343	uncultured Planctomycetia bacterium DNA containing 16S-23S intergenic spacer region, clone 43	blastn	17601	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				uncultured Planctomycetia bacterium
14190954	14190954	PRJNA1022392_P_NODE_54092_length_185_cov_1.260870_g53423_i0	PRJNA1022392	54092	185	1.26087	2.3326095	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	259	8.67e-65	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g53423	i0	93.22	147.178378378378	177	11	97	1	6	181	655074	654898	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	27228	259	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
15465061	15465061	PRJNA1022392_P_NODE_5253_length_490_cov_4.503386_g4725_i0	PRJNA1022392	5253	490	4.503386	22.0665914	Stieleria magnilauensis	2527963	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1712780605\|gb\|CP036432.1\|	2527963	g4725	i0	97.059	0.0693877551020408	34	1	7	0	423	456	2819665	2819632	Planctomycetes bacterium TBK1r chromosome	blastn	34	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria magnilauensis
21406044	21406044	PRJNA1022392_P_NODE_67477_length_168_cov_1.314050_g66808_i0	PRJNA1022392	67477	168	1.31405	2.207604	Planctomycetota	203682	Bacteria	Bacteria	268	1.29e-67	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g66808	i0	96.319	132.291666666667	163	6	97	0	3	165	1881728	1881890	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	22225	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
21838938	21838938	PRJNA1022392_P_NODE_35238_length_206_cov_2.308176_g34569_i0	PRJNA1022392	35238	206	2.308176	4.75484256	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	63.9	8.32e-6	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g34569	i0	97.368	29.621359223301	38	0	18	1	1	37	4881630	4881667	Luteolibacter sp. Populi chromosome, complete genome	blastn	6102	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
21839159	21839159	PRJNA1022392_P_NODE_53758_length_185_cov_2.376812_g53089_i0	PRJNA1022392	53758	185	2.376812	4.3971022	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	104	4.3e-18	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g53089	i0	92.958	2.92432432432432	71	5	38	0	6	76	7397175	7397105	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	541	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24388537	24388537	PRJNA1022392_P_NODE_64920_length_171_cov_1.491935_g64251_i0	PRJNA1022392	64920	171	1.491935	2.55120885	Gemmataceae bacterium	2052164	Bacteria	Bacteria	143	8.26e-30	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g64251	i0	94.624	10.3567251461988	93	4	54	1	59	151	4154675	4154584	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	1771	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;