metadata: contig_metadata: 14 rows where bioproject = "PRJNA1237888", tax_phylum = "Acidobacteriota" and tax

14 rows where bioproject = "PRJNA1237888", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

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
346536	346536	PRJNA1237888_S_NODE_21_length_1679_cov_4.698160_g11_i0	PRJNA1237888	21	1679	4.69816	78.8821064	Terriglobus roseus	392734	Bacteria	Bacteria	2663	0	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g11	i0	95.298	103.935080405003	1680	77	100	2	1	1679	2078788	2077110	Terriglobus roseus DSM 18391, complete genome	blastn	174507	2663	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
346541	346541	PRJNA1237888_S_NODE_3261_length_225_cov_1.477273_g3211_i0	PRJNA1237888	3261	225	1.477273	3.32386425	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	405	1.33e-108	NTclustered	gi\|2836016426\|emb\|OZ196157.1\|	1241325	g3211	i0	99.111	25.2177777777778	225	2	100	0	1	225	1019507	1019731	MAG: uncultured Granulicella sp. isolate 532c3363-cb9a-4ff4-a964-62ae8f4e4543 genome assembly, chromosome: 1	blastn	5674	405	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
4173799	4173799	PRJNA1237888_S_NODE_1744_length_314_cov_2.781132_g1694_i0	PRJNA1237888	1744	314	2.781132	8.73275448	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	363	1.1999999999999999e-95	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g1694	i0	89.31	88.4140127388535	290	29	92	2	1	289	2366983	2367271	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	27762	363	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6724487	6724487	PRJNA1237888_S_NODE_1046_length_389_cov_5.094118_g996_i0	PRJNA1237888	1046	389	5.094118	19.81611902	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	669	0	NTclustered	gi\|157142428\|gb\|EU122699.1\|	171953	g996	i0	97.686	99.1182519280206	389	9	100	0	1	389	14	402	Uncultured Acidobacteria bacterium clone KL2-068 16S ribosomal RNA gene, partial sequence	blastn	38557	669	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8000035	8000035	PRJNA1237888_S_NODE_7127_length_163_cov_2.473684_g7077_i0	PRJNA1237888	7127	163	2.473684	4.03210492	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	268	1.24e-67	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g7077	i0	96.341	314.791411042945	164	5	100	1	1	163	1821173	1821336	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	51311	268	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
10550723	10550723	PRJNA1237888_S_NODE_5909_length_170_cov_2.942149_g5859_i0	PRJNA1237888	5909	170	2.942149	5.0016533	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	254	3.63e-63	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g5859	i0	93.567	286.317647058824	171	10	100	1	1	170	3176154	3176324	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	48674	254	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
13100507	13100507	PRJNA1237888_S_NODE_6331_length_167_cov_4.601695_g6281_i0	PRJNA1237888	6331	167	4.601695	7.68483065	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	174	2.87e-39	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g6281	i0	95.413	137.089820359281	109	5	65	0	1	109	1822650	1822542	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	22894	174	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
15649633	15649633	PRJNA1237888_S_NODE_3753_length_210_cov_2.751553_g3703_i0	PRJNA1237888	3753	210	2.751553	5.7782613	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	316	5.92e-82	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g3703	i0	93.81	47.0285714285714	210	13	100	0	1	210	1821944	1821735	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	9876	316	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
16923873	16923873	PRJNA1237888_S_NODE_2894_length_238_cov_1.100529_g2844_i0	PRJNA1237888	2894	238	1.100529	2.61925902	Bryobacterales bacterium	2026791	Bacteria	Bacteria	324	4.1e-84	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g2844	i0	91.176	147.31512605042	238	21	100	0	1	238	6660764	6661001	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	35061	324	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
16923879	16923879	PRJNA1237888_S_NODE_4214_length_200_cov_1.258278_g4164_i0	PRJNA1237888	4214	200	1.258278	2.516556	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	353	4.25e-93	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g4164	i0	98.5	214.165	200	3	100	0	1	200	9230	9429	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	42833	353	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21451634	21451634	PRJNA1237888_S_NODE_2557_length_254_cov_6.000000_g2507_i0	PRJNA1237888	2557	254	6	15.24	Terriglobus	392733	Bacteria	Bacteria	364	2.6099999999999993e-96	NTclustered	gi\|319923767\|gb\|CP002467.1\|	401053	g2507	i0	92.549	122.44094488189	255	17	100	2	1	254	3871428	3871681	Terriglobus saanensis SP1PR4, complete genome	blastn	31100	364	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus saanensis
22726772	22726772	PRJNA1237888_S_NODE_7258_length_163_cov_0.912281_g7208_i0	PRJNA1237888	7258	163	0.912281	1.48701803	Bacteria	2	Bacteria	Bacteria	92	9.31e-21	NR	MBV8205153.1	1978231	g7208	i0	79.2	10.7484662576687	53	11	97.5	0	162	4	53	105	MBV8205153.1 methyltransferase [Acidobacteriota bacterium]	diamond	1752	92.4	0.995670995670996	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
23299083	23299083	PRJNA1237888_S_NODE_2959_length_235_cov_3.811828_g2909_i0	PRJNA1237888	2959	235	3.811828	8.9577958	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	385	1.83e-102	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g2909	i0	96.552	110.102127659574	232	8	99	0	4	235	11442	11211	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	25874	385	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25275957	25275957	PRJNA1237888_S_NODE_6180_length_168_cov_1.554622_g6130_i0	PRJNA1237888	6180	168	1.554622	2.61176496	Granulicella	940557	Bacteria	Bacteria	305	9.81e-79	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g6130	i0	99.405	88.3511904761905	168	1	100	0	1	168	694822	694989	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	14843	305	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis

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);;