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

9 rows where analysis = "blastn", bioproject = "PRJNA975724" 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
946171	946171	PRJNA975724_S_NODE_42121_length_315_cov_0.954545_g41940_i0	PRJNA975724	42121	315	0.954545	3.00681675	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	505	1.8799999999999995e-138	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g41940	i0	95.847	129.793650793651	313	12	99	1	1	312	4467217	4466905	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	40885	505	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
946280	946280	PRJNA975724_S_NODE_46161_length_305_cov_2.224138_g45980_i0	PRJNA975724	46161	305	2.224138	6.7836209	Phycisphaera mikurensis	547188	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|381385343\|dbj\|AP012338.1\|	1142394	g45980	i0	92.5	0.222950819672131	40	2	13	1	26	65	3653611	3653573	Phycisphaera mikurensis NBRC 102666 DNA, complete genome	blastn	68	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
6049860	6049860	PRJNA975724_S_NODE_60145_length_278_cov_2.629268_g59964_i0	PRJNA975724	60145	278	2.629268	7.30936504	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	316	8.22e-82	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g59964	i0	87.544	69.9820143884892	281	25	99	9	3	278	4469489	4469214	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	19455	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
11149945	11149945	PRJNA975724_S_NODE_4909_length_525_cov_1.703540_g4730_i0	PRJNA975724	4909	525	1.70354	8.943585	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	582	1.4799999999999999e-161	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g4730	i0	86.932	78.8190476190476	528	58	99	10	3	525	1867784	1867263	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	41380	582	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11470596	11470596	PRJNA975724_S_NODE_12029_length_433_cov_4.822222_g11848_i0	PRJNA975724	12029	433	4.822222	20.88022126	Planctopirus	1649480	Bacteria	Bacteria	544	5.66e-150	NTclustered	gi\|470485078\|ref\|NR_076683.1\|	120	g11848	i0	89.401	94.4965357967668	434	43	99	2	1	432	1616	1184	Planctomyces limnophilus strain Mue 290 23S ribosomal RNA gene, complete sequence	blastn	40917	544	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
17523567	17523567	PRJNA975724_S_NODE_18594_length_393_cov_2.037500_g18413_i0	PRJNA975724	18594	393	2.0375	8.007375	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	464	4.07e-126	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g18413	i0	89.067	251.089058524173	375	40	95	1	15	389	2191019	2190646	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	98678	464	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
18797208	18797208	PRJNA975724_S_NODE_1095_length_782_cov_8.662906_g950_i0	PRJNA975724	1095	782	8.662906	67.74392492	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	1018	0	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g950	i0	90.114	120.695652173913	789	70	100	7	1	782	4469230	4468443	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	94384	1018	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
21349086	21349086	PRJNA975724_S_NODE_73797_length_257_cov_1.673913_g73616_i0	PRJNA975724	73797	257	1.673913	4.30195641	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	296	9.78e-76	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g73616	i0	87.938	72.3035019455253	257	23	97	7	8	257	7051926	7051671	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	18582	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
22622663	22622663	PRJNA975724_S_NODE_18_length_2943_cov_7.134146_g17_i0	PRJNA975724	18	2943	7.134146	209.95791678	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1290	0	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g17	i0	76.214	180.427454977914	2678	500	93	115	3	2631	2620694	2623283	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	530998	1290	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae 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);;