metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1182301" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1182301" 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
1593792	1593792	PRJNA1182301_P_NODE_58862_length_244_cov_0.900585_g58737_i0	PRJNA1182301	58862	244	0.900585	2.1974274	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	243	1.22e-59	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g58737	i0	85	1.52459016393443	240	34	98	2	6	244	1338246	1338008	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	372	243	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4145175	4145175	PRJNA1182301_P_NODE_22904_length_285_cov_1.273585_g22779_i0	PRJNA1182301	22904	285	1.273585	3.62971725	Luteitalea pratensis	1855912	Bacteria	Bacteria	161	4.19e-35	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g22779	i0	80.365	3.05263157894737	219	38	76	4	69	284	3855034	3855250	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	870	161	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
4145271	4145271	PRJNA1182301_P_NODE_2684_length_528_cov_2.334066_g2560_i0	PRJNA1182301	2684	528	2.334066	12.32386848	Terriglobus roseus	392734	Bacteria	Bacteria	789	0	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g2560	i0	95.723	201.833333333333	491	19	93	2	1	489	927706	928196	Terriglobus roseus DSM 18391, complete genome	blastn	106568	789	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
6696616	6696616	PRJNA1182301_P_NODE_42326_length_259_cov_1.623656_g42201_i0	PRJNA1182301	42326	259	1.623656	4.20526904	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	99	2.99e-16	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g42201	i0	84.848	0.575289575289575	99	14	38	1	7	104	1936017	1935919	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	149	99	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9246836	9246836	PRJNA1182301_P_NODE_50728_length_250_cov_0.870056_g50603_i0	PRJNA1182301	50728	250	0.870056	2.17514	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	150	7.799999999999999e-32	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g50603	i0	83.851	49.736	161	22	64	4	63	221	4804530	4804688	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	12434	150	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11797114	11797114	PRJNA1182301_P_NODE_3270_length_493_cov_2.828571_g3146_i0	PRJNA1182301	3270	493	2.828571	13.94485503	Alloacidobacterium dinghuense	2763107	Bacteria	Bacteria	795	0	NTclustered	gi\|1895675831\|gb\|CP060394.1\|	2763107	g3146	i0	95.749	179.762677484787	494	19	100	2	1	493	4009129	4009621	Alloacidobacterium dinghuense strain 4Y35 chromosome, complete genome	blastn	88623	795	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Alloacidobacterium	Alloacidobacterium dinghuense
11797695	11797695	PRJNA1182301_P_NODE_57010_length_245_cov_1.790698_g56885_i0	PRJNA1182301	57010	245	1.790698	4.3872101	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	183	7.519999999999998e-42	NTclustered	gi\|2575803519\|emb\|OY729431.1\|	2793154	g56885	i0	82.028	0.885714285714286	217	37	88	2	10	225	962903	963118	MAG: Vicinamibacteria bacterium isolate 6b1ebb23-bf14-4213-9fd5-2478dc99539b genome assembly, chromosome: 1	blastn	217	183	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
15621302	15621302	PRJNA1182301_P_NODE_33293_length_271_cov_1.166667_g33168_i0	PRJNA1182301	33293	271	1.166667	3.16166757	Occallatibacter riparius	1002689	Bacteria	Bacteria	462	9.69e-126	NTclustered	gi\|2304899767\|gb\|CP093313.1\|	1002689	g33168	i0	97.417	149.029520295203	271	7	100	0	1	271	6620313	6620583	Occallatibacter riparius strain DSM 25168 chromosome, complete genome	blastn	40387	462	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Occallatibacter	Occallatibacter riparius
20719451	20719451	PRJNA1182301_P_NODE_16117_length_304_cov_1.467532_g15992_i0	PRJNA1182301	16117	304	1.467532	4.46129728	Terriglobus roseus	392734	Bacteria	Bacteria	451	2.39e-122	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g15992	i0	93.96	137.519736842105	298	18	98	0	7	304	928264	928561	Terriglobus roseus DSM 18391, complete genome	blastn	41806	451	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
20719768	20719768	PRJNA1182301_P_NODE_29397_length_276_cov_1.413793_g29272_i0	PRJNA1182301	29397	276	1.413793	3.90206868	Terriglobus roseus	392734	Bacteria	Bacteria	484	2.11e-132	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g29272	i0	98.54	111.978260869565	274	4	99	0	3	276	929070	928797	Terriglobus roseus DSM 18391, complete genome	blastn	30906	484	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
21995628	21995628	PRJNA1182301_P_NODE_51398_length_249_cov_1.710227_g51273_i0	PRJNA1182301	51398	249	1.710227	4.25846523	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	272	1.5899999999999998e-68	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g51273	i0	86.454	93.5060240963855	251	30	100	4	1	249	2645500	2645252	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	23283	272	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23270846	23270846	PRJNA1182301_P_NODE_40459_length_261_cov_2.069149_g40334_i0	PRJNA1182301	40459	261	2.069149	5.40047889	Terriglobus roseus	392734	Bacteria	Bacteria	383	7.43e-102	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g40334	i0	93.103	84.3831417624521	261	18	100	0	1	261	928388	928128	Terriglobus roseus DSM 18391, complete genome	blastn	22024	383	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
23271262	23271262	PRJNA1182301_P_NODE_57859_length_245_cov_0.895349_g57734_i0	PRJNA1182301	57859	245	0.895349	2.19360505	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	128	3.57e-25	NTclustered	gi\|2874253854\|emb\|OY969910.1\|	171953	g57734	i0	93.103	122.85306122449	87	6	36	0	143	229	441817	441903	MAG: uncultured Acidobacteriota bacterium isolate MFD01213.bin.1.136 genome assembly, chromosome: 1	blastn	30099	128	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);;