metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA169559" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA169559" 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
1639999	1639999	PRJNA169559_P_NODE_7822_length_607_cov_5.489619_g6236_i0	PRJNA169559	7822	607	5.489619	33.32198733	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	673	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g6236	i0	86.829	116.31136738056	615	66	99	15	2	607	2058780	2059388	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	70601	673	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
2915725	2915725	PRJNA169559_P_NODE_37243_length_241_cov_140.844340_g35166_i0	PRJNA169559	37243	241	140.84434	339.4348594	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	285	1.96e-72	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g35166	i0	87.967	176.107883817427	241	29	100	0	1	241	454817	454577	Luteolibacter sp. AS25 chromosome, complete genome	blastn	42442	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
5468352	5468352	PRJNA169559_P_NODE_32465_length_255_cov_1.853982_g30389_i0	PRJNA169559	32465	255	1.853982	4.7276541	Tautonia sociabilis	2080755	Bacteria	Bacteria	379	9.359999999999998e-101	NTclustered	gi\|2260349439\|ref\|NR_176521.1\|	2080755	g30389	i0	92.188	106.286274509804	256	19	100	1	1	255	1219	1474	Tautonia sociabilis strain GM2012 16S ribosomal RNA, partial sequence	blastn	27103	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia sociabilis
9293053	9293053	PRJNA169559_P_NODE_23348_length_323_cov_2.942177_g21275_i0	PRJNA169559	23348	323	2.942177	9.50323171	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	71.3	8.37e-8	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g21275	i0	97.561	0.126934984520124	41	1	13	0	20	60	2899691	2899731	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	41	71.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
9293151	9293151	PRJNA169559_P_NODE_32848_length_254_cov_1.253333_g30772_i0	PRJNA169559	32848	254	1.253333	3.18346582	Humisphaera borealis	2807512	Bacteria	Bacteria	128	3.72e-25	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g30772	i0	96.154	47.1614173228346	78	3	61	0	177	254	5062760	5062683	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	11979	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
14393939	14393939	PRJNA169559_P_NODE_10532_length_521_cov_25.491870_g8755_i0	PRJNA169559	10532	521	25.49187	132.8126427	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	758	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g8755	i0	93.09	258.172744721689	521	31	100	5	1	521	2467	1952	Luteolibacter sp. SL250 chromosome	blastn	134508	758	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
19491185	19491185	PRJNA169559_P_NODE_9016_length_565_cov_252.555970_g7331_i0	PRJNA169559	9016	565	252.55597	1426.9412305	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum	3342349	Bacteria	Bacteria	656	0	NTclustered	gi\|2851290179\|emb\|OZ197277.1\|	3342349	g7331	i0	87.805	187.955752212389	574	53	100	16	1	565	177528	176963	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum strain Digiganteum-PALH genome assembly, chromosome: 1	blastn	106195	656	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae symbiont of Dictyostelium giganteum
22041688	22041688	PRJNA169559_P_NODE_38198_length_239_cov_2.338095_g36121_i0	PRJNA169559	38198	239	2.338095	5.58804705	Humisphaera borealis	2807512	Bacteria	Bacteria	403	5.15e-108	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g36121	i0	97.071	74.7824267782427	239	7	100	0	1	239	5065002	5064764	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	17873	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
22731624	22731624	PRJNA169559_P_NODE_7438_length_622_cov_3.241147_g5882_i0	PRJNA169559	7438	622	3.2411469999999998	20.15993434	Pseudomonadati	3379134	Bacteria	Bacteria	614	6.279999999999998e-171	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g5882	i0	85.294	80.2138263665595	612	70	97	16	1	600	1250228	1250831	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	49893	614	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila

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