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

9 rows where analysis = "blastn", bioproject = "PRJNA986547" and tax_phylum = "Planctomycetota"

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
2249438	2249438	PRJNA986547_P_NODE_262_length_965_cov_10.013453_g197_i0	PRJNA986547	262	965	10.013453	96.62982145	Aureliella helgolandensis	2527968	Bacteria	Bacteria	1334	0	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g197	i0	91.658	276.900518134715	971	70	100	11	1	965	6999885	6998920	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	267209	1334	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
2249452	2249452	PRJNA986547_P_NODE_3242_length_309_cov_5.444915_g3160_i0	PRJNA986547	3242	309	5.444915	16.82478735	planctomycete str. 658	149590	Bacteria	Bacteria	372	1.95e-98	NTclustered	gi\|12583971\|gb\|AF245375.1\|AF245375	149590	g3160	i0	88.462	158.042071197411	312	30	100	6	1	309	1024	1332	Planctomycete str. 658 23S ribosomal RNA gene, partial sequence	blastn	48835	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 658
2249455	2249455	PRJNA986547_P_NODE_382_length_762_cov_11.703919_g304_i0	PRJNA986547	382	762	11.703919	89.18386278	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	407	1.42e-108	NTclustered	gi\|2621780281\|emb\|OY776568.1\|	2026778	g304	i0	77.528	863.771653543307	712	137	92	22	62	760	4344814	4345515	MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1	blastn	658194	407	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
8627147	8627147	PRJNA986547_P_NODE_14287_length_226_cov_5.843137_g14205_i0	PRJNA986547	14287	226	5.843137	13.20548962	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	113	9.1e-21	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g14205	i0	85.217	0.508849557522124	115	12	50	4	49	160	1310854	1310742	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	115	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
16277144	16277144	PRJNA986547_P_NODE_8713_length_250_cov_3.864407_g8631_i0	PRJNA986547	8713	250	3.864407	9.6610175	Humisphaera borealis	2807512	Bacteria	Bacteria	99	2.87e-16	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g8631	i0	82.456	0.456	114	18	45	2	137	249	2087074	2087186	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	114	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
20100585	20100585	PRJNA986547_P_NODE_12616_length_238_cov_2.115152_g12534_i0	PRJNA986547	12616	238	2.115152	5.03406176	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|134021154\|gb\|EF019730.1\|	120965	g12534	i0	100	99.6302521008403	238	0	100	0	1	238	899	662	Uncultured planctomycete clone Elev_16S_902 16S ribosomal RNA gene, partial sequence	blastn	23712	440	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
22949994	22949994	PRJNA986547_P_NODE_3478_length_302_cov_8.925764_g3396_i0	PRJNA986547	3478	302	8.925764	26.95580728	Engelhardtia	139931	Bacteria	Bacteria	257	5.55e-64	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g3396	i0	82.178	334.201986754967	303	51	99	3	2	302	5246218	5246519	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	100929	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
24223962	24223962	PRJNA986547_P_NODE_7359_length_258_cov_9.902703_g7277_i0	PRJNA986547	7359	258	9.902703	25.54897374	Gemmata	113	Bacteria	Bacteria	65.8	3.02e-6	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g7277	i0	74.269	1.77906976744186	171	36	65	8	47	213	6867164	6867330	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	459	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
25200414	25200414	PRJNA986547_P_NODE_440_length_690_cov_5.713128_g360_i0	PRJNA986547	440	690	5.713128	39.4205832	Aureliella helgolandensis	2527968	Bacteria	Bacteria	1098	0	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g360	i0	95.389	118.331884057971	694	24	100	6	1	690	7001023	7001712	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	81649	1098	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis

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