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

17 rows where analysis = "blastn", bioproject = "PRJNA1011844" 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
155724	155724	PRJNA1011844_P_NODE_105781_length_311_cov_3.436975_g97209_i0	PRJNA1011844	105781	311	3.436975	10.68899225	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	440	5.309999999999997e-119	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g97209	i0	93.046	81.1093247588424	302	20	97	1	11	311	1821941	1821640	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	25225	440	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
156056	156056	PRJNA1011844_P_NODE_130881_length_268_cov_3.907692_g122303_i0	PRJNA1011844	130881	268	3.907692	10.47261456	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	235	2.27e-57	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g122303	i0	83.398	8.71641791044776	259	38	96	4	1	256	4840697	4840441	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	2336	235	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
156453	156453	PRJNA1011844_P_NODE_162601_length_240_cov_2.017964_g154020_i0	PRJNA1011844	162601	240	2.017964	4.8431136	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g154020	i0	96.875	0.133333333333333	32	1	13	0	88	119	2338543	2338574	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1432794	1432794	PRJNA1011844_P_NODE_98262_length_332_cov_2.552124_g89698_i0	PRJNA1011844	98262	332	2.552124	8.47305168	Terriglobus roseus	392734	Bacteria	Bacteria	520	7.129999999999999e-143	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g89698	i0	96.215	93.0240963855422	317	12	95	0	3	319	927327	927011	Terriglobus roseus DSM 18391, complete genome	blastn	30884	520	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
2708307	2708307	PRJNA1011844_P_NODE_99483_length_328_cov_7.949020_g90915_i0	PRJNA1011844	99483	328	7.94902	26.0727856	Paludibaculum fermentans	1473598	Bacteria	Bacteria	357	5.84e-94	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g90915	i0	87.147	201.737804878049	319	36	97	5	11	327	4787484	4787169	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	66170	357	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
4829967	4829967	PRJNA1011844_P_NODE_154544_length_245_cov_1.779070_g145964_i0	PRJNA1011844	154544	245	1.77907	4.3587215	Holophaga	35838	Bacteria	Bacteria	412	8.81e-111	NTclustered	gi\|117557512\|emb\|AM180901.2\|	171953	g145964	i0	98.707	66.4775510204082	232	3	95	0	13	244	1067	1298	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone LS_LKC21_kan5	blastn	16287	412	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5259389	5259389	PRJNA1011844_P_NODE_169945_length_228_cov_12.309677_g161364_i0	PRJNA1011844	169945	228	12.309677	28.06606356	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g161364	i0	100	0.12719298245614	29	0	13	0	46	74	3938560	3938532	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
6105604	6105604	PRJNA1011844_P_NODE_95445_length_341_cov_1.029851_g86882_i0	PRJNA1011844	95445	341	1.029851	3.51179191	Bacteria	2	Bacteria	Bacteria	438	2.1199999999999993e-118	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g86882	i0	92.258	97.7536656891496	310	22	91	2	11	319	12163	11855	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	33334	438	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9083576	9083576	PRJNA1011844_P_NODE_132788_length_266_cov_1.663212_g124210_i0	PRJNA1011844	132788	266	1.663212	4.42414392	Terriglobus roseus	392734	Bacteria	Bacteria	409	1.2499999999999998e-109	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g124210	i0	96.748	145.323308270677	246	7	92	1	10	254	927025	926780	Terriglobus roseus DSM 18391, complete genome	blastn	38656	409	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
9083777	9083777	PRJNA1011844_P_NODE_149168_length_249_cov_0.875000_g140589_i0	PRJNA1011844	149168	249	0.875	2.17875	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g140589	i0	96.774	0.124497991967871	31	1	12	0	31	61	1754244	1754214	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11636458	11636458	PRJNA1011844_P_NODE_91490_length_354_cov_1.142349_g82932_i0	PRJNA1011844	91490	354	1.142349	4.04391546	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g82932	i0	92.308	1.94632768361582	39	3	11	0	105	143	1738989	1739027	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	689	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
12910732	12910732	PRJNA1011844_P_NODE_41531_length_739_cov_6.489489_g33662_i0	PRJNA1011844	41531	739	6.489489	47.95732371	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.021	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g33662	i0	96.97	0.0446549391069012	33	0	4	1	93	125	5841433	5841464	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	33	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16733259	16733259	PRJNA1011844_P_NODE_155974_length_244_cov_2.280702_g147394_i0	PRJNA1011844	155974	244	2.280702	5.56491288	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	298	2.56e-76	NTclustered	gi\|112980869\|gb\|DQ829673.1\|	171953	g147394	i0	90.667	141.758196721311	225	20	92	1	13	236	19	243	Uncultured Acidobacteria bacterium clone DON19 23S ribosomal RNA gene, partial sequence	blastn	34589	298	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18007483	18007483	PRJNA1011844_P_NODE_106615_length_310_cov_2.801688_g98042_i0	PRJNA1011844	106615	310	2.801688	8.6852328	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	237	7.450000000000001e-58	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g98042	i0	80.323	64.6838709677419	310	44	95	6	6	298	284047	283738	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	20052	237	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
18007553	18007553	PRJNA1011844_P_NODE_112775_length_296_cov_2.174888_g104199_i0	PRJNA1011844	112775	296	2.174888	6.43766848	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g104199	i0	94.444	0.121621621621622	36	1	12	1	57	92	2338543	2338577	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	36	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20558346	20558346	PRJNA1011844_P_NODE_44217_length_699_cov_5.945687_g36192_i0	PRJNA1011844	44217	699	5.945687	41.56035213	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g36192	i0	88	0.113018597997139	50	4	7	2	575	622	2675348	2675299	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	79	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24384012	24384012	PRJNA1011844_P_NODE_94640_length_343_cov_4.029630_g86078_i0	PRJNA1011844	94640	343	4.02963	13.8216309	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	394	4.68e-105	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g86078	i0	87.941	135.481049562682	340	33	97	4	7	339	3558109	3557771	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	46470	394	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;