metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1159911" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1159911" 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
308156	308156	PRJNA1159911_P_NODE_61521_length_306_cov_1.321888_g60979_i0	PRJNA1159911	61521	306	1.321888	4.04497728	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	292	1.54e-74	NTclustered	gi\|2874253950\|emb\|OY970275.1\|	171953	g60979	i0	84.694	20.4477124183007	294	43	96	2	1	293	4422372	4422664	MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.c.2 genome assembly, chromosome: 1	blastn	6257	292	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
308444	308444	PRJNA1159911_P_NODE_75081_length_272_cov_2.221106_g74539_i0	PRJNA1159911	75081	272	2.221106	6.04140832	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	102	2.44e-17	NTclustered	gi\|2874254120\|emb\|OY970205.1\|	194844	g74539	i0	94.118	61.0514705882353	68	2	24	1	137	202	6073648	6073581	MAG: uncultured Acidobacteriaceae bacterium isolate MFD02248.bin.1.24 genome assembly, chromosome: 1	blastn	16606	102	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
1583055	1583055	PRJNA1159911_P_NODE_73982_length_275_cov_0.940594_g73440_i0	PRJNA1159911	73982	275	0.940594	2.5866335	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g73440	i0	100	0.101818181818182	28	0	10	0	11	38	5432510	5432483	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
4134956	4134956	PRJNA1159911_P_NODE_59024_length_314_cov_0.958506_g58482_i0	PRJNA1159911	59024	314	0.958506	3.00970884	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	200	9.92e-47	NTclustered	gi\|2874253950\|emb\|OY970275.1\|	171953	g58482	i0	84.729	1.29617834394904	203	27	64	2	6	206	1387822	1387622	MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.c.2 genome assembly, chromosome: 1	blastn	407	200	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5411754	5411754	PRJNA1159911_P_NODE_87725_length_250_cov_2.683616_g87183_i0	PRJNA1159911	87725	250	2.683616	6.70904	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	243	1.25e-59	NTclustered	gi\|2874253928\|emb\|OY970253.1\|	171953	g87183	i0	86.697	6.104	218	29	87	0	33	250	312698	312915	MAG: uncultured Acidobacteriota bacterium isolate MFD01299.bin.c.2 genome assembly, chromosome: 1	blastn	1526	243	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7962097	7962097	PRJNA1159911_P_NODE_97127_length_244_cov_0.900585_g96585_i0	PRJNA1159911	97127	244	0.900585	2.1974274	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	171	5.82e-38	NTclustered	gi\|2874253928\|emb\|OY970253.1\|	171953	g96585	i0	80.995	1.56967213114754	221	36	89	5	22	239	419403	419620	MAG: uncultured Acidobacteriota bacterium isolate MFD01299.bin.c.2 genome assembly, chromosome: 1	blastn	383	171	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10512002	10512002	PRJNA1159911_P_NODE_67029_length_291_cov_1.027523_g66487_i0	PRJNA1159911	67029	291	1.027523	2.99009193	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	287	6.79e-73	NTclustered	gi\|2874253854\|emb\|OY969910.1\|	171953	g66487	i0	85.106	10.3367697594502	282	41	97	1	2	282	1268356	1268637	MAG: uncultured Acidobacteriota bacterium isolate MFD01213.bin.1.136 genome assembly, chromosome: 1	blastn	3008	287	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10512140	10512140	PRJNA1159911_P_NODE_73909_length_275_cov_1.143564_g73367_i0	PRJNA1159911	73909	275	1.143564	3.144801	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	331	2.9000000000000006e-86	NTclustered	gi\|2874253854\|emb\|OY969910.1\|	171953	g73367	i0	88.364	53.5018181818182	275	32	100	0	1	275	3155524	3155798	MAG: uncultured Acidobacteriota bacterium isolate MFD01213.bin.1.136 genome assembly, chromosome: 1	blastn	14713	331	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10512483	10512483	PRJNA1159911_P_NODE_90129_length_249_cov_0.875000_g89587_i0	PRJNA1159911	90129	249	0.875	2.17875	Tunturiibacter empetritectus	3069691	Bacteria	Bacteria	230	9.699999999999995e-56	NTclustered	gi\|2750692779\|gb\|CP132932.1\|	3069691	g89587	i0	84.034	86.5502008032128	238	38	96	0	1	238	1993542	1993305	Tunturiibacter empetritectus strain M8UP23 chromosome	blastn	21551	230	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter empetritectus
10512582	10512582	PRJNA1159911_P_NODE_94929_length_245_cov_1.325581_g94387_i0	PRJNA1159911	94929	245	1.325581	3.24767345	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	315	2.55e-81	NTclustered	gi\|2874253928\|emb\|OY970253.1\|	171953	g94387	i0	89.837	7.02857142857143	246	23	100	2	1	245	312879	313123	MAG: uncultured Acidobacteriota bacterium isolate MFD01299.bin.c.2 genome assembly, chromosome: 1	blastn	1722	315	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11785723	11785723	PRJNA1159911_P_NODE_100410_length_241_cov_1.833333_g99868_i0	PRJNA1159911	100410	241	1.833333	4.41833253	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	132	2.7100000000000004e-26	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g99868	i0	82.353	0.634854771784232	153	25	63	2	22	173	4910342	4910493	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	153	132	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
11787536	11787536	PRJNA1159911_P_NODE_97910_length_243_cov_0.905882_g97368_i0	PRJNA1159911	97910	243	0.905882	2.20129326	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	405	1.46e-108	NTclustered	gi\|2874253786\|emb\|OY969770.1\|	2952895	g97368	i0	96.708	100.222222222222	243	8	100	0	1	243	3514948	3515190	MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1	blastn	24354	405	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
15611226	15611226	PRJNA1159911_P_NODE_75433_length_272_cov_0.919598_g74891_i0	PRJNA1159911	75433	272	0.919598	2.50130656	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	148	3.0899999999999993e-31	NTclustered	gi\|2874253786\|emb\|OY969770.1\|	2952895	g74891	i0	84.416	0.566176470588235	154	21	56	3	119	270	5453132	5453284	MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1	blastn	154	148	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
19434029	19434029	PRJNA1159911_P_NODE_54556_length_329_cov_1.214844_g54014_i0	PRJNA1159911	54556	329	1.214844	3.99683676	Bryobacterales bacterium	2026791	Bacteria	Bacteria	167	1.06e-36	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g54014	i0	93.043	0.349544072948328	115	6	35	2	60	173	3102813	3102700	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	115	167	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
21984885	21984885	PRJNA1159911_P_NODE_58658_length_315_cov_1.272727_g58116_i0	PRJNA1159911	58658	315	1.272727	4.00909005	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	244	4.53e-60	NTclustered	gi\|2874253786\|emb\|OY969770.1\|	2952895	g58116	i0	80.635	1.27936507936508	315	61	100	0	1	315	1857998	1857684	MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1	blastn	403	244	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
21985252	21985252	PRJNA1159911_P_NODE_77878_length_267_cov_1.190722_g77336_i0	PRJNA1159911	77878	267	1.190722	3.17922774	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	135	2.36e-27	NTclustered	gi\|2874253721\|emb\|OY969563.1\|	2952895	g77336	i0	86.777	1.69288389513109	121	16	45	0	147	267	1482392	1482272	MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1	blastn	452	135	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
23260538	23260538	PRJNA1159911_P_NODE_71839_length_279_cov_1.868932_g71297_i0	PRJNA1159911	71839	279	1.868932	5.21432028	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	243	1.42e-59	NTclustered	gi\|2874253721\|emb\|OY969563.1\|	2952895	g71297	i0	91.061	1.88172043010753	179	16	64	0	1	179	6452882	6452704	MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1	blastn	525	243	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
23260962	23260962	PRJNA1159911_P_NODE_93039_length_247_cov_0.885057_g92497_i0	PRJNA1159911	93039	247	0.885057	2.18609079	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	237	5.74e-58	NTclustered	gi\|2874253950\|emb\|OY970275.1\|	171953	g92497	i0	84.362	80.6963562753036	243	36	98	2	6	247	2954517	2954758	MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.c.2 genome assembly, chromosome: 1	blastn	19932	237	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);;