metadata: contig_metadata: 16 rows where bioproject = "PRJNA509429", tax_phylum = "Acidobacteriota" and tax

16 rows where bioproject = "PRJNA509429", 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_species
1110799	1110799	PRJNA509429_P_NODE_48521_length_157_cov_1.688525_g47693_i0	PRJNA509429	48521	157	1.688525	2.65098425	Thermoanaerobaculum	1434048	Bacteria	Bacteria	130	5.820000000000001e-26	NTclustered	gi\|117557516\|emb\|AM180905.2\|	171953	g47693	i0	84.962	87.5732484076433	133	14	83	5	20	150	947	819	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone UD5 LS_LKC11_kan4	blastn	13749	130	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
1760552	1760552	PRJNA509429_P_NODE_6922_length_554_cov_2.531792_g6162_i0	PRJNA509429	6922	554	2.531792	14.02612768	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	737	0	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g6162	i0	90.844	109.552346570397	557	41	100	8	1	554	31161	30612	Uncultured Acidobacteria bacterium clone 46h5 hypothetical protein, putative O-linked GlcNAc transferase, putative two-component response regulator, hypothetical protein, putative penicillin-resistance DD-carboxypeptidase, putative glycosyl transferase, hypothetical protein, conserved hypothetical protein, hypothetical protein, putative MaoC family dehydratase, putative D-3-phosphoglycerate dehydrogenase, putative magnesium and cobalt transport protein, putative phosphatidyl-glycerophosphatase, putative 2-methylthioadenine synthetase, hypothetical protein, putative glutamine cyclotransferase, and hypothetical protein genes, complete cds; 5S ribosomal RNA, 23S ribosomal RNA, tRNA-Ala, tRNA-Met, tRNA-Ile, and 16S ribosomal RNA genes, complete sequence; and hypothetical protein genes, complete cds	blastn	60692	737	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
2386313	2386313	PRJNA509429_P_NODE_49322_length_155_cov_2.041667_g48494_i0	PRJNA509429	49322	155	2.041667	3.16458385	Bacteria	2	Bacteria	Bacteria	134	4.42e-27	NTclustered	gi\|76574295\|gb\|DQ139443.1\|	171953	g48494	i0	83.803	8.89032258064516	142	21	91	2	1	141	243	103	Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence	blastn	1378	135	0.992592592592593	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
4312111	4312111	PRJNA509429_P_NODE_24524_length_261_cov_2.194690_g23696_i0	PRJNA509429	24524	261	2.19469	5.7281409	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	318	2.1299999999999995e-82	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g23696	i0	89.105	109.942528735632	257	26	98	2	1	256	3556701	3556446	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	28695	318	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
6862970	6862970	PRJNA509429_P_NODE_21386_length_287_cov_2.968254_g20558_i0	PRJNA509429	21386	287	2.968254	8.51888898	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	364	2.9999999999999993e-96	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g20558	i0	89.619	94.7351916376307	289	26	100	4	1	287	4357660	4357946	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	27189	364	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
8138276	8138276	PRJNA509429_P_NODE_20327_length_298_cov_1.684411_g19499_i0	PRJNA509429	20327	298	1.684411	5.01954478	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	370	6.73e-98	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g19499	i0	89.655	23.4093959731544	290	30	97	0	1	290	3557674	3557963	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	6976	370	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
10689090	10689090	PRJNA509429_P_NODE_6789_length_560_cov_3.670476_g6037_i0	PRJNA509429	6789	560	3.670476	20.5546656	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	621	3.3499999999999986e-173	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g6037	i0	87.138	124.15	552	66	98	5	2	550	4649933	4649384	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	69524	621	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
13239102	13239102	PRJNA509429_P_NODE_14471_length_372_cov_2.454006_g13647_i0	PRJNA509429	14471	372	2.454006	9.12890232	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	366	1.1099999999999999e-96	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g13647	i0	84.533	264.061827956989	375	53	100	5	1	372	4233579	4233951	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	98231	366	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
15788009	15788009	PRJNA509429_P_NODE_48393_length_157_cov_3.114754_g47565_i0	PRJNA509429	48393	157	3.114754	4.89016378	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	268	1.1799999999999998e-67	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g47565	i0	97.452	22.624203821656	157	4	100	0	1	157	3174425	3174581	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	3552	268	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
19611227	19611227	PRJNA509429_P_NODE_24556_length_261_cov_1.486726_g23728_i0	PRJNA509429	24556	261	1.486726	3.88035486	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	340	4.539999999999999e-89	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g23728	i0	90.625	106.524904214559	256	24	98	0	1	256	3556701	3556446	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	27803	340	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
22162000	22162000	PRJNA509429_P_NODE_32738_length_210_cov_1.862857_g31910_i0	PRJNA509429	32738	210	1.862857	3.9119997	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	309	9.9e-80	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g31910	i0	93.72	96.7285714285714	207	11	99	2	1	207	1821904	1822108	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	20313	309	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
23437653	23437653	PRJNA509429_P_NODE_2819_length_840_cov_3.370186_g2315_i0	PRJNA509429	2819	840	3.370186	28.3095624	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	902	0	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g2315	i0	86.235	106.311904761905	850	95	99	20	1	837	3175443	3176283	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	89302	902	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
23437711	23437711	PRJNA509429_P_NODE_44619_length_167_cov_1.515152_g43791_i0	PRJNA509429	44619	167	1.515152	2.53030384	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	209	7.85e-50	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g43791	i0	91.503	25.9760479041916	153	12	91	1	1	152	317259	317411	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	4338	209	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
24711182	24711182	PRJNA509429_P_NODE_17360_length_331_cov_4.608108_g16532_i0	PRJNA509429	17360	331	4.608108	15.25283748	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	457	5.65e-124	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g16532	i0	93.226	97.9486404833837	310	21	94	0	1	310	4649272	4649581	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	32421	457	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
27425049	27425049	PRJNA509429_P_NODE_50883_length_152_cov_1.324786_g50055_i0	PRJNA509429	50883	152	1.324786	2.01367472	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42	0.0202	NR	MDA1313252.1	1978231	g50055	i0	42.1	0.75	38	18	75	1	146	33	299	332	MDA1313252.1 glycosyltransferase [Acidobacteriota bacterium]	diamond	114	42	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
28972008	28972008	PRJNA509429_P_NODE_28008_length_236_cov_10.601990_g27180_i0	PRJNA509429	28008	236	10.60199	25.0206964	Terriglobales bacterium	2282142	Bacteria	Bacteria	43.1	0.0247	NR	HUK24316.1	2282142	g27180	i0	62.5	0.406779661016949	32	12	40.7	0	215	120	235	266	HUK24316.1 cellulose synthase family protein [Terriglobales bacterium]	diamond	96	43.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales		Terriglobales 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);;