metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA734348" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA734348" 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
717661	717661	PRJNA734348_P_NODE_16281_length_520_cov_4.380313_g15595_i0	PRJNA734348	16281	520	4.380313	22.7776276	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	743	0	NTclustered	gi\|2874254056\|emb\|OY970380.1\|	2651171	g15595	i0	92.5	855.561538461538	520	37	99	2	2	520	2982596	2983114	MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1	blastn	444892	743	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
718233	718233	PRJNA734348_P_NODE_41201_length_310_cov_2.805907_g40505_i0	PRJNA734348	41201	310	2.805907	8.6983117	Luteitalea pratensis	1855912	Bacteria	Bacteria	156	2.15e-33	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g40505	i0	85.333	1.98064516129032	150	22	48	0	161	310	621829	621978	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	614	156	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
1992873	1992873	PRJNA734348_P_NODE_107842_length_247_cov_0.885057_g107144_i0	PRJNA734348	107842	247	0.885057	2.18609079	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	239	1.6e-58	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g107144	i0	84.211	1	247	37	99	2	2	247	6171955	6172200	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	247	239	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
1993118	1993118	PRJNA734348_P_NODE_120322_length_244_cov_0.900585_g119624_i0	PRJNA734348	120322	244	0.900585	2.1974274	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	119	2.14e-22	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g119624	i0	80.368	0.668032786885246	163	27	65	3	3	161	6012733	6012894	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	163	119	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1994832	1994832	PRJNA734348_P_NODE_71882_length_268_cov_1.405128_g71184_i0	PRJNA734348	71882	268	1.405128	3.76574304	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	353	6.01e-93	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g71184	i0	90.602	0.992537313432836	266	25	99	0	3	268	5294679	5294944	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	266	353	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3268873	3268873	PRJNA734348_P_NODE_146203_length_216_cov_4.363636_g145505_i0	PRJNA734348	146203	216	4.363636	9.42545376	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	217	6.39e-52	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g145505	i0	85.784	3.86111111111111	204	29	94	0	1	204	3061020	3060817	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	834	217	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3268979	3268979	PRJNA734348_P_NODE_16503_length_515_cov_7.857466_g15815_i0	PRJNA734348	16503	515	7.857466	40.4659499	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	667	0	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g15815	i0	90.038	194.978640776699	522	42	100	10	1	515	1349	1867	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	100414	667	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
3270480	3270480	PRJNA734348_P_NODE_92303_length_251_cov_0.865169_g91605_i0	PRJNA734348	92303	251	0.865169	2.17157419	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	213	9.86e-51	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g91605	i0	83.929	79.5856573705179	224	34	89	2	29	251	4202703	4202925	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	19976	213	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
4545709	4545709	PRJNA734348_P_NODE_129804_length_242_cov_0.911243_g129106_i0	PRJNA734348	129804	242	0.911243	2.20520806	Holophagales bacterium	2478486	Bacteria	Bacteria	147	9.72e-31	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g129106	i0	78.601	1.00413223140496	243	36	97	14	8	242	2262968	2263202	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	243	147	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
5822153	5822153	PRJNA734348_P_NODE_58825_length_281_cov_1.139423_g58128_i0	PRJNA734348	58825	281	1.139423	3.20177863	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	226	1.4399999999999994e-54	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g58128	i0	81.404	2.0355871886121	285	45	100	6	1	281	4325634	4325354	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	572	226	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5822766	5822766	PRJNA734348_P_NODE_9365_length_781_cov_7.562147_g8756_i0	PRJNA734348	9365	781	7.562147	59.06036807	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	1059	0	NTclustered	gi\|76574295\|gb\|DQ139443.1\|	171953	g8756	i0	91.678	101.883482714469	769	56	98	5	13	781	1302	542	Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence	blastn	79571	1059	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8370399	8370399	PRJNA734348_P_NODE_121947_length_243_cov_4.352941_g121249_i0	PRJNA734348	121947	243	4.352941	10.57764663	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	180	9.63e-41	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g121249	i0	86.957	2.53086419753086	161	20	66	1	4	164	1501852	1502011	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	615	180	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10921385	10921385	PRJNA734348_P_NODE_141509_length_230_cov_2.605096_g140811_i0	PRJNA734348	141509	230	2.605096	5.9917208	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	270	5.21e-68	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g140811	i0	88.393	65.9217391304348	224	26	97	0	1	224	3149470	3149693	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	15162	270	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
12677118	12677118	PRJNA734348_P_NODE_80210_length_260_cov_2.422460_g79512_i0	PRJNA734348	80210	260	2.42246	6.298396	Pseudomonadati	3379134	Bacteria	Bacteria	76.8	1.41e-9	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g79512	i0	89.831	2.66153846153846	59	6	23	0	23	81	2741937	2741879	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	692	76.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13471168	13471168	PRJNA734348_P_NODE_136531_length_237_cov_3.652439_g135833_i0	PRJNA734348	136531	237	3.652439	8.65628043	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	241	4.23e-59	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g135833	i0	86.283	88.0379746835443	226	25	95	6	12	237	2367039	2367258	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	20865	241	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13472442	13472442	PRJNA734348_P_NODE_62091_length_277_cov_2.656863_g61394_i0	PRJNA734348	62091	277	2.656863	7.35951051	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	99	3.23e-16	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g61394	i0	79.71	1.96028880866426	138	26	49	2	3	139	2293785	2293921	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	543	99	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14745910	14745910	PRJNA734348_P_NODE_113932_length_245_cov_3.389535_g113234_i0	PRJNA734348	113932	245	3.389535	8.30436075	Terriglobus roseus	392734	Bacteria	Bacteria	111	3.6e-20	NTclustered	gi\|1085637902\|emb\|LT629690.1\|	392734	g113234	i0	93.333	36.4734693877551	75	5	31	0	40	114	2942	2868	Terriglobus roseus strain GAS232 genome assembly, chromosome: I	blastn	8936	111	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
14746074	14746074	PRJNA734348_P_NODE_123132_length_243_cov_1.435294_g122434_i0	PRJNA734348	123132	243	1.435294	3.48776442	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	196	9.56e-46	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g122434	i0	83.105	50.8024691358025	219	34	90	3	26	243	6045231	6045447	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	12345	196	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14747151	14747151	PRJNA734348_P_NODE_41312_length_310_cov_2.763713_g40616_i0	PRJNA734348	41312	310	2.763713	8.5675103	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	243	1.6000000000000004e-59	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g40616	i0	95.973	37.741935483871	149	6	95	0	162	310	5101706	5101558	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	11700	243	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
14747783	14747783	PRJNA734348_P_NODE_75652_length_264_cov_2.230366_g74954_i0	PRJNA734348	75652	264	2.230366	5.88816624	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	315	2.79e-81	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g74954	i0	88.258	93.2234848484848	264	29	99	2	1	262	635153	634890	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	24611	315	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
15225464	15225464	PRJNA734348_P_NODE_127532_length_242_cov_0.976331_g126834_i0	PRJNA734348	127532	242	0.976331	2.36272102	Bacteria	2	Bacteria	Bacteria	392	1.1299999999999999e-104	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g126834	i0	95.868	247.619834710744	242	10	100	0	1	242	1687468	1687227	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	59924	392	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16019281	16019281	PRJNA734348_P_NODE_101253_length_249_cov_0.875000_g100555_i0	PRJNA734348	101253	249	0.875	2.17875	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	187	5.919999999999998e-43	NTclustered	gi\|2621704939\|emb\|OY762226.1\|	2910147	g100555	i0	80.488	67.4417670682731	246	46	98	2	4	248	2682279	2682035	MAG: Vicinamibacterales bacterium isolate 0d5134ca-f8ab-4963-ab29-a032ed897002 genome assembly, chromosome: 1	blastn	16793	187	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
17294990	17294990	PRJNA734348_P_NODE_110974_length_246_cov_1.450867_g110276_i0	PRJNA734348	110974	246	1.450867	3.56913282	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	169	2.11e-37	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g110276	i0	79.435	33.1260162601626	248	43	99	7	3	246	1400942	1401185	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	8149	169	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
17295366	17295366	PRJNA734348_P_NODE_132274_length_241_cov_0.916667_g131576_i0	PRJNA734348	132274	241	0.916667	2.20916747	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	141	4.5e-29	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g131576	i0	92.157	62.3817427385892	102	4	41	3	137	235	1135577	1135677	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	15034	141	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17295918	17295918	PRJNA734348_P_NODE_24014_length_401_cov_1.393293_g23319_i0	PRJNA734348	24014	401	1.393293	5.58710493	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	217	1.29e-51	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g23319	i0	77.475	3.3640897755611	404	64	99	21	1	395	3097446	3097061	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	1349	217	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17296492	17296492	PRJNA734348_P_NODE_51074_length_289_cov_1.245370_g50377_i0	PRJNA734348	51074	289	1.24537	3.5991193	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	255	1.9e-63	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g50377	i0	85.597	3.6643598615917	243	35	84	0	4	246	1625043	1625285	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	1059	255	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18568655	18568655	PRJNA734348_P_NODE_108415_length_247_cov_0.885057_g107717_i0	PRJNA734348	108415	247	0.885057	2.18609079	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	147	9.96e-31	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g107717	i0	78.733	0.894736842105263	221	45	89	2	18	237	3304725	3304506	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	221	147	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19844693	19844693	PRJNA734348_P_NODE_19956_length_450_cov_4.530504_g19265_i0	PRJNA734348	19956	450	4.530504	20.387268	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	726	0	NTclustered	gi\|2874254056\|emb\|OY970380.1\|	2651171	g19265	i0	95.778	140.155555555556	450	19	100	0	1	450	2980677	2981126	MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1	blastn	63070	726	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
19845270	19845270	PRJNA734348_P_NODE_47376_length_294_cov_1.393665_g46679_i0	PRJNA734348	47376	294	1.393665	4.0973751	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	302	2.4500000000000002e-77	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g46679	i0	88.627	185.445578231293	255	20	85	8	1	249	4648427	4648678	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	54521	302	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
22394991	22394991	PRJNA734348_P_NODE_142278_length_229_cov_2.493590_g141580_i0	PRJNA734348	142278	229	2.49359	5.7103211	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	158	4.21e-34	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g141580	i0	84.024	1.36244541484716	169	21	74	4	6	174	4346051	4346213	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	312	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
22395812	22395812	PRJNA734348_P_NODE_47718_length_293_cov_1.950000_g47021_i0	PRJNA734348	47718	293	1.95	5.7135	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	122	2.0399999999999998e-23	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g47021	i0	91.209	2.2457337883959	91	6	31	2	2	92	3097167	3097255	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	658	122	1	Bacteria	Pseudomonadati	Acidobacteriota					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);;