metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJDB4941" and tax

17 rows where analysis = "blastn", bioproject = "PRJDB4941" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1284404	1284404	PRJDB4941_P_NODE_16102_length_262_cov_1.755869_g15334_i0	PRJDB4941	16102	262	1.755869	4.60037678	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	121	6.46e-23	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g15334	i0	81.046	5.65267175572519	153	27	58	2	101	252	838302	838151	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	1481	121	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
2560416	2560416	PRJDB4941_P_NODE_40723_length_162_cov_0.920354_g39955_i0	PRJDB4941	40723	162	0.920354	1.49097348	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	86.1	1.33e-12	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g39955	i0	86.842	0.728395061728395	76	10	47	0	52	127	2440133	2440058	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	118	86.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
2560579	2560579	PRJDB4941_P_NODE_9163_length_383_cov_2.931138_g8395_i0	PRJDB4941	9163	383	2.931138	11.22625854	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	222	2.63e-53	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g8395	i0	77.869	1.12793733681462	366	76	95	5	1	363	432408	432771	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	432	222	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3836260	3836260	PRJDB4941_P_NODE_14904_length_275_cov_2.628319_g14136_i0	PRJDB4941	14904	275	2.628319	7.22787725	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	298	2.94e-76	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g14136	i0	86.397	1.98545454545455	272	37	99	0	1	272	4209447	4209718	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	546	298	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5112744	5112744	PRJDB4941_P_NODE_2985_length_904_cov_4.746199_g2319_i0	PRJDB4941	2985	904	4.746199	42.90563896	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	520	2.08e-142	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g2319	i0	84.045	10.5398230088496	539	86	60	0	13	551	3586846	3587384	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	9528	520	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6388401	6388401	PRJDB4941_P_NODE_18466_length_240_cov_1.801047_g17698_i0	PRJDB4941	18466	240	1.801047	4.3225128	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	163	9.56e-36	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g17698	i0	80.374	2.03333333333333	214	42	89	0	18	231	2057456	2057243	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	488	163	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7662416	7662416	PRJDB4941_P_NODE_14347_length_282_cov_2.167382_g13579_i0	PRJDB4941	14347	282	2.167382	6.11201724	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	207	5.25e-49	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g13579	i0	81.569	0.904255319148936	255	43	90	4	1	253	197052	197304	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	255	207	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10213267	10213267	PRJDB4941_P_NODE_32989_length_172_cov_1.268293_g32221_i0	PRJDB4941	32989	172	1.268293	2.18146396	Tunturiibacter gelidiferens	3069689	Bacteria	Bacteria	137	3.87e-28	NTclustered	gi\|2750677617\|gb\|CP132938.1\|	3069689	g32221	i0	84.892	13.7441860465116	139	17	80	3	35	171	2701035	2700899	Tunturiibacter gelidoferens strain M8UP39 chromosome	blastn	2364	137	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter gelidiferens
11488428	11488428	PRJDB4941_P_NODE_33870_length_169_cov_1.733333_g33102_i0	PRJDB4941	33870	169	1.733333	2.92933277	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	89.8	1.08e-13	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g33102	i0	80.992	2.80473372781065	121	15	69	7	27	143	2613829	2613713	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	474	89.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
11488481	11488481	PRJDB4941_P_NODE_37270_length_166_cov_0.888889_g36502_i0	PRJDB4941	37270	166	0.888889	1.47555574	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	126	8.08e-25	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g36502	i0	81.212	24.9578313253012	165	24	98	6	1	163	183797	183956	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	4143	126	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
12763797	12763797	PRJDB4941_P_NODE_22851_length_211_cov_2.543210_g22083_i0	PRJDB4941	22851	211	2.54321	5.3661731	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	128	2.99e-25	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g22083	i0	83.333	1.30805687203791	138	23	65	0	1	138	4465994	4465857	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	276	128	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
14038288	14038288	PRJDB4941_P_NODE_2072_length_1221_cov_6.953925_g1499_i0	PRJDB4941	2072	1221	6.953925	84.90742425	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	665	0	NTclustered	gi\|2874254159\|emb\|OY970389.1\|	2283092	g1499	i0	80.022	5.42342342342342	901	178	74	2	42	941	1378537	1379436	MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1	blastn	6622	665	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
14038539	14038539	PRJDB4941_P_NODE_35492_length_167_cov_3.898305_g34724_i0	PRJDB4941	35492	167	3.898305	6.51016935	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	139	1.05e-28	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g34724	i0	82.927	1.58083832335329	164	19	97	9	1	162	3750353	3750509	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	264	139	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15312902	15312902	PRJDB4941_P_NODE_9793_length_365_cov_1.544304_g9025_i0	PRJDB4941	9793	365	1.544304	5.6367096	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	220	8.97e-53	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g9025	i0	77.717	20.8164383561644	368	76	100	4	1	365	959843	959479	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	7598	220	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
19135908	19135908	PRJDB4941_P_NODE_28996_length_185_cov_1.911765_g28228_i0	PRJDB4941	28996	185	1.911765	3.53676525	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	126	9.18e-25	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g28228	i0	79.558	12.0486486486486	181	33	97	4	6	184	3114337	3114515	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	2229	126	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
19136034	19136034	PRJDB4941_P_NODE_37516_length_165_cov_1.603448_g36748_i0	PRJDB4941	37516	165	1.603448	2.6456892	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	174	2.82e-39	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g36748	i0	85.89	19.4909090909091	163	23	99	0	1	163	5641109	5641271	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	3216	174	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21686683	21686683	PRJDB4941_P_NODE_14878_length_276_cov_1.458150_g14110_i0	PRJDB4941	14878	276	1.45815	4.024494	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	263	1.08e-65	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g14110	i0	84	3.21739130434783	275	42	99	2	1	274	4825685	4825958	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	888	263	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota 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);;