metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA800090" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA800090" 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
4626801	4626801	PRJNA800090_P_NODE_191944_length_228_cov_1.798742_g189759_i0	PRJNA800090	191944	228	1.798742	4.10113176	Planctomyces sp. 599	79928	Bacteria	Bacteria	416	6.259999999999998e-112	NTclustered	gi\|4775517\|emb\|AJ231189.1\|	79928	g189759	i0	99.561	96.6359649122807	228	1	100	0	1	228	771	544	Planctomyces sp. (strain 599) 16S rRNA gene, partial	blastn	22033	416	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. 599
8449885	8449885	PRJNA800090_P_NODE_123187_length_287_cov_2.004587_g121002_i0	PRJNA800090	123187	287	2.004587	5.75316469	Gemmata-like str. JW11-2f5	121118	Bacteria	Bacteria	431	2.919999999999999e-116	NTclustered	gi\|10436091\|gb\|AF239696.1\|AF239696	121118	g121002	i0	93.772	115.717770034843	289	14	100	4	1	287	1451	1165	Gemmata-like str. JW11-2f5 16S ribosomal RNA gene, partial sequence	blastn	33211	431	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Gemmata-like str. JW11-2f5
12277707	12277707	PRJNA800090_P_NODE_184630_length_231_cov_0.901235_g182445_i0	PRJNA800090	184630	231	0.901235	2.08185285	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	217	6.919999999999999e-52	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g182445	i0	84.234	7.76623376623377	222	35	96	0	1	222	1894296	1894075	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	1794	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
12699637	12699637	PRJNA800090_P_NODE_118570_length_294_cov_1.280000_g116385_i0	PRJNA800090	118570	294	1.28	3.7632	Singulisphaera	466152	Bacteria	Bacteria	466	8.22e-127	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g116385	i0	95.238	84.5	294	14	100	0	1	294	978	685	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	24843	466	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
17375872	17375872	PRJNA800090_P_NODE_151774_length_254_cov_2.140541_g149589_i0	PRJNA800090	151774	254	2.140541	5.43697414	Gemmataceae bacterium	2052164	Bacteria	Bacteria	412	9.18e-111	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g149589	i0	96.4	309.452755905512	250	9	98	0	1	250	319277	319526	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	78601	412	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
19072114	19072114	PRJNA800090_P_NODE_155795_length_250_cov_3.060773_g153610_i0	PRJNA800090	155795	250	3.060773	7.6519325	Gemmata	113	Bacteria	Bacteria	399	7.019999999999998e-107	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g153610	i0	95.935	190.456	246	10	99	0	1	246	4798165	4797920	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	47614	399	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
19072733	19072733	PRJNA800090_P_NODE_52975_length_488_cov_1.735084_g50791_i0	PRJNA800090	52975	488	1.735084	8.46720992	Gemmata	113	Bacteria	Bacteria	737	0	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g50791	i0	93.902	85.9938524590164	492	24	100	5	1	488	3635129	3634640	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	41965	737	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
23749768	23749768	PRJNA800090_P_NODE_134419_length_272_cov_1.773399_g132234_i0	PRJNA800090	134419	272	1.773399	4.82364528	Planctopirus ephydatiae	2528019	Bacteria	Bacteria	348	2.8400000000000003e-91	NTclustered	gi\|1712709119\|gb\|CP036299.1\|	2528019	g132234	i0	89.744	75.4411764705882	273	26	100	2	1	272	3937877	3938148	Planctopirus ephydatiae strain spb1 chromosome, complete genome	blastn	20520	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus ephydatiae
23750663	23750663	PRJNA800090_P_NODE_174299_length_235_cov_0.879518_g172114_i0	PRJNA800090	174299	235	0.879518	2.0668673	Chlamydiales bacterium BSEPT1	3097555	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2783367630\|emb\|OZ156466.1\|	3097555	g172114	i0	100	0.119148936170213	28	0	12	0	92	119	1434922	1434895	Chlamydiales bacterium BSEPT1 isolate 488b1680-3485-4b59-b0c6-665df4973624 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium BSEPT1
25448365	25448365	PRJNA800090_S_NODE_9920_length_372_cov_1.112211_g9808_i0	PRJNA800090	9920	372	1.112211	4.13742492	Gemmata	113	Bacteria	Bacteria	555	2.2099999999999994e-153	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g9808	i0	93.583	72.8682795698925	374	20	100	3	1	372	3635011	3634640	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	27107	555	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana

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