metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA393181" 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
410763	410763	PRJNA393181_S_NODE_40581_length_167_cov_2.953846_g40475_i0	PRJNA393181	40581	167	2.953846	4.93292282	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	58.4	3.01e-4	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g40475	i0	92.5	0.239520958083832	40	3	24	0	40	79	221262	221223	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	40	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
1685251	1685251	PRJNA393181_S_NODE_25482_length_227_cov_2.021053_g25376_i0	PRJNA393181	25482	227	2.021053	4.58779031	Occallatibacter riparius	1002689	Bacteria	Bacteria	97.1	9.21e-16	NTclustered	gi\|2304899767\|gb\|CP093313.1\|	1002689	g25376	i0	82.301	6.00881057268722	113	18	49	2	34	145	1627423	1627312	Occallatibacter riparius strain DSM 25168 chromosome, complete genome	blastn	1364	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Occallatibacter	Occallatibacter riparius
4238089	4238089	PRJNA393181_S_NODE_7504_length_434_cov_2.773300_g7398_i0	PRJNA393181	7504	434	2.7733	12.036122	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	390	7.819999999999999e-104	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g7398	i0	83.488	26.2258064516129	430	59	97	11	1	423	4220347	4219923	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	11382	390	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
6788191	6788191	PRJNA393181_S_NODE_28166_length_213_cov_2.375000_g28060_i0	PRJNA393181	28166	213	2.375	5.05875	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	154	4.9999999999999996e-33	NTclustered	gi\|2893358436\|emb\|OZ220728.1\|	2910147	g28060	i0	80.905	0.934272300469484	199	35	93	3	11	208	2091455	2091651	MAG: Vicinamibacterales bacterium isolate 73bbec36-abbb-48ff-8f96-0d8513c84f17 genome assembly, chromosome: 1	blastn	199	154	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
9338838	9338838	PRJNA393181_S_NODE_3808_length_566_cov_2.886578_g3711_i0	PRJNA393181	3808	566	2.886578	16.33803148	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	342	2.9599999999999998e-89	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g3711	i0	81.907	9.19787985865724	409	70	72	4	1	407	5487340	5486934	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	5206	342	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
9339162	9339162	PRJNA393181_S_NODE_8248_length_416_cov_3.435356_g8142_i0	PRJNA393181	8248	416	3.435356	14.29108096	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	315	4.62e-81	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g8142	i0	81.842	6.32932692307692	380	64	91	5	38	414	1860927	1860550	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	2633	315	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
9339205	9339205	PRJNA393181_S_NODE_9768_length_386_cov_2.338109_g9662_i0	PRJNA393181	9768	386	2.338109	9.02510074	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2891482070\|emb\|OZ219815.1\|	2793154	g9662	i0	87.755	0.126943005181347	49	4	13	2	236	284	886042	886088	MAG: Vicinamibacteria bacterium isolate 9f2a63bf-6400-4679-989b-6d6b125ab8ea genome assembly, chromosome: 1	blastn	49	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
10614422	10614422	PRJNA393181_S_NODE_33289_length_191_cov_2.493506_g33183_i0	PRJNA393181	33289	191	2.493506	4.76259646	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	97.1	7.48e-16	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g33183	i0	78.235	53.5078534031414	170	23	85	11	1	163	3305907	3306069	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	10220	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13163835	13163835	PRJNA393181_S_NODE_13191_length_332_cov_2.677966_g13085_i0	PRJNA393181	13191	332	2.677966	8.89084712	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	124	6.529999999999999e-24	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g13085	i0	95	1.98192771084337	80	3	24	1	82	161	5797809	5797887	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	658	124	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13164359	13164359	PRJNA393181_S_NODE_32711_length_193_cov_3.692308_g32605_i0	PRJNA393181	32711	193	3.692308	7.12615444	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	191	3.38e-44	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g32605	i0	84.694	2.02072538860104	196	24	100	6	1	193	3170146	3170338	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	390	191	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13164687	13164687	PRJNA393181_S_NODE_46871_length_152_cov_1.695652_g46765_i0	PRJNA393181	46871	152	1.695652	2.57739104	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	124	2.5999999999999996e-24	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g46765	i0	82.639	74.1842105263158	144	21	93	4	3	144	222681	222822	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	11276	124	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
13164722	13164722	PRJNA393181_S_NODE_5291_length_502_cov_1.935484_g5185_i0	PRJNA393181	5291	502	1.935484	9.71612968	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	254	1.25e-62	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g5185	i0	76.754	56.8227091633466	499	89	97	25	15	502	3105839	3105357	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	28525	254	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14439562	14439562	PRJNA393181_S_NODE_38572_length_173_cov_2.294118_g38466_i0	PRJNA393181	38572	173	2.294118	3.96882414	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	95.3	2.38e-15	NTclustered	gi\|2874253786\|emb\|OY969770.1\|	2952895	g38466	i0	86.207	2.92485549132948	87	12	50	0	55	141	1314406	1314320	MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1	blastn	506	95.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
15713038	15713038	PRJNA393181_S_NODE_24093_length_235_cov_2.414141_g23987_i0	PRJNA393181	24093	235	2.414141	5.67323135	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	165	2.59e-36	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g23987	i0	82.09	3.54893617021277	201	28	84	8	1	197	3695632	3695436	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	834	165	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18261923	18261923	PRJNA393181_S_NODE_21955_length_249_cov_2.721698_g21849_i0	PRJNA393181	21955	249	2.721698	6.77702802	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	263	9.56e-66	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g21849	i0	86.066	75.0682730923695	244	34	98	0	6	249	1860564	1860321	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	18692	263	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
18262284	18262284	PRJNA393181_S_NODE_36355_length_180_cov_2.727273_g36249_i0	PRJNA393181	36355	180	2.727273	4.9090914	Granulicella sp. 5B5	1617967	Bacteria	Bacteria	84.2	5.41e-12	NTclustered	gi\|1886125103\|gb\|CP046444.1\|	1617967	g36249	i0	86.667	0.827777777777778	75	10	42	0	8	82	225107	225033	Granulicella sp. 5B5 chromosome, complete genome	blastn	149	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. 5B5
18262520	18262520	PRJNA393181_S_NODE_45835_length_154_cov_2.410256_g45729_i0	PRJNA393181	45835	154	2.410256	3.71179424	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g45729	i0	100	1.15584415584416	30	0	24	0	108	137	2845270	2845241	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	178	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
19535974	19535974	PRJNA393181_S_NODE_16016_length_299_cov_2.782443_g15910_i0	PRJNA393181	16016	299	2.7824430000000002	8.31950457	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	294	4.18e-75	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g15910	i0	84.539	15.2274247491639	304	40	100	7	1	299	4220624	4220323	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	4553	294	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
20811811	20811811	PRJNA393181_S_NODE_17097_length_288_cov_3.784861_g16991_i0	PRJNA393181	17097	288	3.784861	10.90039968	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	261	4.07e-65	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g16991	i0	83.929	91.5555555555556	280	38	95	5	1	275	1118839	1119116	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	26368	261	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
20812231	20812231	PRJNA393181_S_NODE_33777_length_189_cov_2.710526_g33671_i0	PRJNA393181	33777	189	2.710526	5.12289414	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	237	4.17e-58	NTclustered	gi\|2874253939\|emb\|OY970264.1\|	171953	g33671	i0	89.362	61.4074074074074	188	20	99	0	1	188	535056	535243	MAG: uncultured Acidobacteriota bacterium isolate MFD03726.bin.c.8 genome assembly, chromosome: 1	blastn	11606	237	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20812661	20812661	PRJNA393181_S_NODE_7377_length_437_cov_3.295000_g7271_i0	PRJNA393181	7377	437	3.295	14.39915	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	448	4.61e-121	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g7271	i0	85.355	3.70480549199085	437	58	99	6	2	435	3433154	3433587	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	1619	448	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22086628	22086628	PRJNA393181_S_NODE_16838_length_291_cov_2.625984_g16732_i0	PRJNA393181	16838	291	2.625984	7.64161344	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	139	2.0099999999999999e-28	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g16732	i0	77.567	17.3951890034364	263	38	86	20	1	251	1938251	1937998	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	5062	139	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
22087225	22087225	PRJNA393181_S_NODE_39998_length_169_cov_1.833333_g39892_i0	PRJNA393181	39998	169	1.833333	3.09833277	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	58.4	3.03e-4	NTclustered	gi\|2621703956\|emb\|OY762911.1\|	2651171	g39892	i0	92.5	0.236686390532544	40	3	24	0	95	134	566131	566170	MAG: Thermoanaerobaculia bacterium isolate 14c23368-4dca-4d55-9b94-f295180eceef genome assembly, chromosome: 1	blastn	40	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
22755664	22755664	PRJNA393181_S_NODE_8238_length_417_cov_1.718421_g8132_i0	PRJNA393181	8238	417	1.718421	7.16581557	Pseudomonadati	3379134	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g8132	i0	87.755	0.544364508393285	49	4	12	2	9	57	2259489	2259443	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	227	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23362253	23362253	PRJNA393181_S_NODE_15679_length_303_cov_2.266917_g15573_i0	PRJNA393181	15679	303	2.266917	6.86875851	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	115	3.5500000000000005e-21	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g15573	i0	81.081	2.36633663366337	148	24	48	4	1	146	6347833	6347688	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	717	115	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
23362891	23362891	PRJNA393181_S_NODE_4139_length_549_cov_3.265625_g4038_i0	PRJNA393181	4139	549	3.265625	17.92828125	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	180	2.3699999999999998e-40	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g4038	i0	79.478	1.1384335154827	268	43	48	11	284	545	4615655	4615394	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	625	180	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24636622	24636622	PRJNA393181_S_NODE_1940_length_705_cov_2.443114_g1866_i0	PRJNA393181	1940	705	2.443114	17.2239537	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	209	3.95e-49	NTclustered	gi\|2108199008\|gb\|CP070706.1\|	1978231	g1866	i0	80.919	12.5489361702128	283	38	39	13	1	275	737963	738237	MAG: Acidobacteria bacterium isolate bin529 chromosome	blastn	8847	209	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
24636660	24636660	PRJNA393181_S_NODE_20840_length_257_cov_2.290909_g20734_i0	PRJNA393181	20840	257	2.290909	5.88763613	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	158	4.819999999999999e-34	NTclustered	gi\|2621701250\|emb\|OY759970.1\|	2910147	g20734	i0	82.682	17.9338521400778	179	29	69	2	8	185	3028241	3028064	MAG: Vicinamibacterales bacterium isolate d8048395-9ec3-4be5-9403-ce9d0d334964 genome assembly, chromosome: 1	blastn	4609	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales 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);;