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

10 rows where analysis = "blastn", bioproject = "PRJNA758088" 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
3288930	3288930	PRJNA758088_P_NODE_338083_length_244_cov_0.900585_g331112_i0	PRJNA758088	338083	244	0.900585	2.1974274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	327	3.27e-85	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g331112	i0	94.393	110.036885245902	214	10	87	2	1	212	7051637	7051424	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	26849	327	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5838408	5838408	PRJNA758088_P_NODE_154825_length_339_cov_1.157895_g147854_i0	PRJNA758088	154825	339	1.157895	3.92526405	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	472	2.07e-128	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g147854	i0	92.239	169.259587020649	335	22	98	3	1	332	1600340	1600007	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	57379	472	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
6307947	6307947	PRJNA758088_P_NODE_361225_length_241_cov_0.916667_g354254_i0	PRJNA758088	361225	241	0.916667	2.20916747	Planctomycetaceae	126	Bacteria	Bacteria	311	3.24e-80	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g354254	i0	91.892	132.211618257261	222	18	92	0	1	222	374346	374125	Alienimonas californiensis strain CA12 chromosome	blastn	31863	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis
7581666	7581666	PRJNA758088_P_NODE_304846_length_248_cov_0.880000_g297875_i0	PRJNA758088	304846	248	0.88	2.1824	Singulisphaera	466152	Bacteria	Bacteria	206	1.6299999999999998e-48	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g297875	i0	82.258	82.1895161290323	248	34	99	7	1	246	150	389	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	20383	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
8388611	8388611	PRJNA758088_P_NODE_181087_length_315_cov_1.909091_g174116_i0	PRJNA758088	181087	315	1.909091	6.01363665	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	324	5.66e-84	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g174116	i0	86.275	9.86031746031746	306	33	96	8	3	303	7630542	7630843	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	3106	324	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
15232642	15232642	PRJNA758088_P_NODE_67712_length_523_cov_1.266667_g60766_i0	PRJNA758088	67712	523	1.266667	6.62466841	Planctomycetia	203683	Bacteria	Bacteria	725	0	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g60766	i0	91.589	318.569789674952	535	30	100	11	1	523	5179532	5179001	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	166612	728	0.995879120879121	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
17315482	17315482	PRJNA758088_P_NODE_317054_length_247_cov_0.885057_g310083_i0	PRJNA758088	317054	247	0.885057	2.18609079	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	294	3.36e-75	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g310083	i0	92.271	25.3562753036437	207	16	84	0	1	207	5827099	5827305	Planctomyces sp. SH-PL62, complete genome	blastn	6263	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
17316227	17316227	PRJNA758088_P_NODE_367314_length_241_cov_0.898810_g360343_i0	PRJNA758088	367314	241	0.89881	2.1661321	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	60.2	1.3e-4	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g360343	i0	92.683	0.170124481327801	41	3	17	0	15	55	1266551	1266511	Planctomyces sp. SH-PL62, complete genome	blastn	41	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
24962543	24962543	PRJNA758088_P_NODE_230900_length_280_cov_1.487923_g223929_i0	PRJNA758088	230900	280	1.487923	4.1661844	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	396	1.03e-105	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g223929	i0	92.143	5.81428571428571	280	22	100	0	1	280	2503138	2502859	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	1628	396	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
24963486	24963486	PRJNA758088_P_NODE_293140_length_250_cov_0.870056_g286169_i0	PRJNA758088	293140	250	0.870056	2.17514	Bythopirellula goksoeyrii	1400387	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g286169	i0	98.4	267.312	250	4	100	0	1	250	5092688	5092937	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	66828	440	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii

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