metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA694770" 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
675149	675149	PRJNA694770_P_NODE_67281_length_268_cov_1.579487_g66987_i0	PRJNA694770	67281	268	1.579487	4.23302516	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	355	1.67e-93	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g66987	i0	91.288	92.3917910447761	264	18	97	5	1	260	7051436	7051698	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	24761	355	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2456631	2456631	PRJNA694770_P_NODE_94142_length_244_cov_0.900585_g93848_i0	PRJNA694770	94142	244	0.900585	2.1974274	Singulisphaera	466152	Bacteria	Bacteria	379	8.889999999999998e-101	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g93848	i0	94.694	111.217213114754	245	11	100	2	1	244	946	703	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	27137	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
3225031	3225031	PRJNA694770_P_NODE_26163_length_382_cov_0.996764_g25869_i0	PRJNA694770	26163	382	0.996764	3.80763848	Saltatorellus ferox	2528018	Bacteria	Bacteria	366	1.1499999999999996e-96	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g25869	i0	84.932	410.03664921466	365	51	95	3	20	382	2933002	2932640	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	156634	366	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
8327003	8327003	PRJNA694770_P_NODE_20807_length_418_cov_1.034783_g20513_i0	PRJNA694770	20807	418	1.034783	4.32539294	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	486	9.3e-133	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g20513	i0	87.765	689.736842105263	425	41	100	9	1	418	7050762	7050342	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	288310	486	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8327865	8327865	PRJNA694770_P_NODE_52827_length_290_cov_1.313364_g52533_i0	PRJNA694770	52827	290	1.313364	3.8087556	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	219	2.5e-52	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g52533	i0	82.591	5.82068965517241	247	43	85	0	44	290	1517692	1517446	Tautonia plasticadhaerens strain ElP chromosome	blastn	1688	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
8834117	8834117	PRJNA694770_P_NODE_78787_length_251_cov_0.865169_g78493_i0	PRJNA694770	78787	251	0.865169	2.17157419	Isosphaera	127	Bacteria	Bacteria	182	2.78e-41	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g78493	i0	80.488	144.199203187251	246	41	97	6	9	251	408	167	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	36194	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
9603055	9603055	PRJNA694770_P_NODE_47068_length_305_cov_1.418103_g46774_i0	PRJNA694770	47068	305	1.418103	4.32521415	Singulisphaera acidiphila	466153	Bacteria	Bacteria	364	3.2199999999999992e-96	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g46774	i0	88.312	100.56393442623	308	31	100	5	1	305	7354759	7354454	Singulisphaera acidiphila DSM 18658, complete genome	blastn	30672	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
10879560	10879560	PRJNA694770_P_NODE_81969_length_249_cov_1.607955_g81675_i0	PRJNA694770	81969	249	1.607955	4.00380795	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	342	1.1899999999999999e-89	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g81675	i0	91.633	122.168674698795	251	16	100	5	1	249	3722563	3722316	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	30420	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
12152895	12152895	PRJNA694770_P_NODE_14930_length_484_cov_3.695864_g14636_i0	PRJNA694770	14930	484	3.695864	17.88798176	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	599	1.3399999999999997e-166	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g14636	i0	88.911	299.857438016529	496	41	100	9	1	484	5936660	5936167	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	145131	599	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13427933	13427933	PRJNA694770_P_NODE_32111_length_354_cov_2.302491_g31817_i0	PRJNA694770	32111	354	2.302491	8.15081814	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	514	3.55e-141	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g31817	i0	92.758	151.590395480226	359	20	100	5	1	354	4317739	4317382	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	53663	514	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14704356	14704356	PRJNA694770_P_NODE_75672_length_254_cov_1.701657_g75378_i0	PRJNA694770	75672	254	1.701657	4.32220878	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	292	1.25e-74	NTclustered	gi\|781823269\|emb\|LN802595.1\|	120965	g75378	i0	88.703	95.8385826771653	239	27	94	0	1	239	299	61	Uncultured planctomycete partial 16S rRNA gene, clone denovo3842	blastn	24343	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
15978740	15978740	PRJNA694770_P_NODE_99233_length_241_cov_0.916667_g98939_i0	PRJNA694770	99233	241	0.916667	2.20916747	Tuwongella immobilis	692036	Bacteria	Bacteria	226	1.2099999999999997e-54	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g98939	i0	89.944	48.0373443983403	179	13	100	5	67	241	2736194	2736017	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	11577	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
24900575	24900575	PRJNA694770_P_NODE_34620_length_345_cov_1.132353_g34326_i0	PRJNA694770	34620	345	1.132353	3.90661785	Phycisphaera sp.	2030824	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g34326	i0	100	0.0811594202898551	28	0	8	0	296	323	2414468	2414441	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
24901257	24901257	PRJNA694770_P_NODE_60760_length_278_cov_1.936585_g60466_i0	PRJNA694770	60760	278	1.936585	5.3837063	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	315	2.96e-81	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g60466	i0	87.05	5.18345323741007	278	36	100	0	1	278	5165217	5165494	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1441	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;