metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA564013" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA564013" 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
1824721	1824721	PRJNA564013_P_NODE_220222_length_287_cov_5.013274_g217371_i0	PRJNA564013	220222	287	5.013274	14.38809638	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	189	1.94e-43	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g217371	i0	86.982	11.8675958188153	169	20	59	2	45	212	2996129	2996296	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	3406	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
3103981	3103981	PRJNA564013_P_NODE_91423_length_426_cov_4.572603_g88590_i0	PRJNA564013	91423	426	4.572603	19.47928878	Limnoglobus roseus	2598579	Bacteria	Bacteria	448	4.48e-121	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g88590	i0	86.634	0.948356807511737	404	54	95	0	19	422	2773654	2774057	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	404	448	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
4377679	4377679	PRJNA564013_P_NODE_27884_length_715_cov_4.585627_g25372_i0	PRJNA564013	27884	715	4.585627	32.78723305	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	806	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g25372	i0	87.84	149.292307692308	699	69	96	11	18	705	4317031	4317724	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	106744	806	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
8202564	8202564	PRJNA564013_P_NODE_245447_length_265_cov_3.514706_g242595_i0	PRJNA564013	245447	265	3.514706	9.3139709	Singulisphaera acidiphila	466153	Bacteria	Bacteria	113	1.1e-20	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g242595	i0	83.898	2.33584905660377	118	19	45	0	30	147	4872095	4871978	Singulisphaera acidiphila DSM 18658, complete genome	blastn	619	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
9476760	9476760	PRJNA564013_P_NODE_174908_length_329_cov_6.570896_g172058_i0	PRJNA564013	174908	329	6.570896	21.61824784	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	375	1.6199999999999998e-99	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g172058	i0	90.747	33.1519756838906	281	26	86	0	25	305	5812997	5813277	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	10907	375	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10752491	10752491	PRJNA564013_P_NODE_17169_length_875_cov_42.504914_g15045_i0	PRJNA564013	17169	875	42.504914	371.9179975	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	497	9.429999999999999e-136	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g15045	i0	83.005	1.27885714285714	559	85	63	10	299	851	6609191	6608637	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	1119	497	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
13305546	13305546	PRJNA564013_P_NODE_340351_length_204_cov_1.286713_g337499_i0	PRJNA564013	340351	204	1.286713	2.62489452	Singulisphaera acidiphila	466153	Bacteria	Bacteria	115	2.2400000000000003e-21	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g337499	i0	86.111	5.31862745098039	108	14	52	1	98	204	1287778	1287671	Singulisphaera acidiphila DSM 18658, complete genome	blastn	1085	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
14577824	14577824	PRJNA564013_P_NODE_204092_length_302_cov_5.439834_g201241_i0	PRJNA564013	204092	302	5.439834	16.42829868	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	156	2.08e-33	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g201241	i0	81.095	6.50993377483444	201	32	66	6	76	273	5816755	5816558	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	1966	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
14579765	14579765	PRJNA564013_P_NODE_310712_length_219_cov_1.575949_g307860_i0	PRJNA564013	310712	219	1.575949	3.45132831	Lacipirellula parvula	2650471	Bacteria	Bacteria	211	3.02e-50	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g307860	i0	84.163	4.01369863013699	221	32	100	3	1	219	12708	12927	Lacipirellula parvula PX69 DNA, complete genome	blastn	879	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
14581696	14581696	PRJNA564013_P_NODE_78352_length_457_cov_21.659091_g75529_i0	PRJNA564013	78352	457	21.659091	98.98204587	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	289	3.1e-73	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g75529	i0	79.567	3.7308533916849	416	75	90	9	25	435	5423188	5422778	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	1705	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
14581823	14581823	PRJNA564013_P_NODE_85032_length_440_cov_10.195251_g82202_i0	PRJNA564013	85032	440	10.195251	44.8591044	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	231	5.09e-56	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g82202	i0	86.222	0.511363636363636	225	17	50	7	202	421	5846175	5846390	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	225	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15855388	15855388	PRJNA564013_P_NODE_69473_length_484_cov_10.137116_g66662_i0	PRJNA564013	69473	484	10.137116	49.06364144	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	185	4.459999999999999e-42	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g66662	i0	82.11	500.485537190083	218	37	60	2	90	305	3722923	3722706	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	242235	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
16435561	16435561	PRJNA564013_P_NODE_352513_length_197_cov_2.029412_g349661_i0	PRJNA564013	352513	197	2.029412	3.99794164	Pseudomonadati	3379134	Bacteria	Bacteria	60.2	1.02e-4	NTclustered	gi\|1712524857\|gb\|CP036424.1\|	2527998	g349661	i0	94.737	1.91878172588832	38	2	20	0	104	141	2555089	2555052	Planctomycetes bacterium MalM25 chromosome	blastn	378	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
19677128	19677128	PRJNA564013_P_NODE_298976_length_226_cov_2.193939_g296124_i0	PRJNA564013	298976	226	2.193939	4.95830214	Rosistilla ulvae	1930277	Bacteria	Bacteria	65.8	2.58e-6	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g296124	i0	80.952	2.68141592920354	84	14	37	2	43	125	7048266	7048184	Rosistilla ulvae strain EC9 chromosome	blastn	606	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
22226551	22226551	PRJNA564013_P_NODE_237058_length_272_cov_6.161137_g234206_i0	PRJNA564013	237058	272	6.161137	16.75829264	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	235	2.31e-57	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g234206	i0	84.914	0.955882352941177	232	35	85	0	23	254	2983790	2983559	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	260	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;