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

9 rows where analysis = "blastn", bioproject = "PRJNA1047749" 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
174935	174935	PRJNA1047749_P_NODE_20861_length_312_cov_2.338912_g20594_i0	PRJNA1047749	20861	312	2.338912	7.29740544	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	100	1.03e-16	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g20594	i0	91.892	0.618589743589744	74	2	24	4	170	242	2390093	2390163	Parachlamydia acanthamoebae UV-7, complete genome	blastn	193	100	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
174949	174949	PRJNA1047749_P_NODE_21861_length_308_cov_5.280851_g21594_i0	PRJNA1047749	21861	308	5.280851	16.26502108	Paludisphaera borealis	1387353	Bacteria	Bacteria	130	1.29e-25	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g21594	i0	83.099	1.84415584415584	142	24	46	0	6	147	347141	347282	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	568	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
2285450	2285450	PRJNA1047749_P_NODE_27342_length_297_cov_2.709821_g27075_i0	PRJNA1047749	27342	297	2.709821	8.04816837	Gemmata	113	Bacteria	Bacteria	196	1.2e-45	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g27075	i0	90.066	50.4579124579125	151	15	51	0	1	151	7197638	7197788	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	14986	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
7388100	7388100	PRJNA1047749_P_NODE_34386_length_269_cov_5.321429_g34119_i0	PRJNA1047749	34386	269	5.321429	14.31464401	Gemmata	113	Bacteria	Bacteria	195	3.87e-45	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g34119	i0	92.029	71.185873605948	138	11	51	0	131	268	7198136	7197999	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	19149	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
7827819	7827819	PRJNA1047749_P_NODE_39107_length_252_cov_2.743017_g38840_i0	PRJNA1047749	39107	252	2.743017	6.91240284	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	287	5.75e-73	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g38840	i0	88.608	15.8134920634921	237	25	94	2	16	251	5576552	5576317	Tautonia plasticadhaerens strain ElP chromosome	blastn	3985	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
10378661	10378661	PRJNA1047749_P_NODE_47869_length_222_cov_5.134228_g47602_i0	PRJNA1047749	47869	222	5.134228	11.39798616	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	62.1	3.27e-5	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g47602	i0	100	1.60810810810811	33	0	15	0	102	134	2682167	2682199	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	357	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
10378691	10378691	PRJNA1047749_P_NODE_50129_length_207_cov_6.059701_g49862_i0	PRJNA1047749	50129	207	6.059701	12.54358107	Congregicoccus parvus	3081749	Bacteria	Bacteria	159	1.04e-34	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g49862	i0	85.161	4.11111111111111	155	23	75	0	26	180	3565427	3565581	Opitutales bacterium ASA1 DNA, complete genome	blastn	851	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
18861940	18861940	PRJNA1047749_P_NODE_35555_length_265_cov_1.609375_g35288_i0	PRJNA1047749	35555	265	1.609375	4.26484375	Gemmata	113	Bacteria	Bacteria	298	2.82e-76	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g35288	i0	87.308	8.12830188679245	260	33	98	0	6	265	99113	98854	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	2154	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
25236342	25236342	PRJNA1047749_P_NODE_16340_length_312_cov_6.506276_g16073_i0	PRJNA1047749	16340	312	6.506276	20.29958112	Gemmata	113	Bacteria	Bacteria	159	1.67e-34	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g16073	i0	89.6	1.20192307692308	125	13	40	0	178	302	2291727	2291603	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	375	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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