metadata: contig_metadata: 18 rows where bioproject = "PRJEB48218" and tax

18 rows where bioproject = "PRJEB48218" 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
62621	62621	PRJEB48218_S_NODE_26181_length_168_cov_2.244604_g25219_i0	PRJEB48218	26181	168	2.244604	3.77093472	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	198	1.7099999999999997e-46	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g25219	i0	96.639	213.583333333333	119	4	71	0	50	168	2908804	2908922	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	35882	198	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
62833	62833	PRJEB48218_S_NODE_6981_length_370_cov_10751.023460_g6019_i0	PRJEB48218	6981	370	10751.02346	39778.786802	Terriglobia	204432	Bacteria	Bacteria	170	1.5e-46	NR	HEY1497794.1	2068625	g6019	i0	79.6	1.63783783783784	103	21	83.5	0	313	5	101	203	HEY1497794.1 TonB-dependent receptor [Candidatus Solibacter sp.]	diamond	606	170	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter sp.
3888633	3888633	PRJEB48218_S_NODE_24524_length_176_cov_37.367347_g23562_i0	PRJEB48218	24524	176	37.367347	65.76653072	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	206	1.08e-48	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g23562	i0	93.478	20.5454545454545	138	9	78	0	16	153	138	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	3616	206	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6440687	6440687	PRJEB48218_S_NODE_24646_length_176_cov_1.816327_g23684_i0	PRJEB48218	24646	176	1.816327	3.19673552	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	111	2.42e-20	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g23684	i0	78.531	2.03409090909091	177	32	99	5	1	174	3943436	3943263	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	358	111	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8989582	8989582	PRJEB48218_S_NODE_19388_length_214_cov_2.005405_g18426_i0	PRJEB48218	19388	214	2.005405	4.2915667	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	174	3.86e-39	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g18426	i0	81.659	8.36448598130841	229	24	100	13	1	214	3176838	3177063	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	1790	174	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
10265183	10265183	PRJEB48218_S_NODE_11989_length_258_cov_5.179039_g11027_i0	PRJEB48218	11989	258	5.179039	13.36192062	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	316	7.539999999999998e-82	NTclustered	gi\|217038899\|gb\|EU810989.1\|	171953	g11027	i0	91.453	121.031007751938	234	15	90	5	24	255	1	231	Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence	blastn	31226	316	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11540700	11540700	PRJEB48218_S_NODE_20570_length_204_cov_10.057143_g19608_i0	PRJEB48218	20570	204	10.057143	20.51657172	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	339	1.22e-88	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g19608	i0	96.569	101.323529411765	204	7	100	0	1	204	738	941	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	20670	339	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
16639616	16639616	PRJEB48218_S_NODE_7834_length_340_cov_11759.463023_g6872_i0	PRJEB48218	7834	340	11759.463023	39982.1742782	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	357	6.08e-94	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g6872	i0	95.133	240.808823529412	226	11	66	0	115	340	3301038	3300813	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	81875	357	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17913958	17913958	PRJEB48218_S_NODE_16535_length_230_cov_30.825871_g15573_i0	PRJEB48218	16535	230	30.825871	70.8995033	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	233	6.83e-57	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g15573	i0	87.019	254.869565217391	208	26	90	1	24	230	3298163	3298370	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	58620	233	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
23014798	23014798	PRJEB48218_S_NODE_7939_length_337_cov_3.159091_g6977_i0	PRJEB48218	7939	337	3.159091	10.64613667	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	339	2.1799999999999997e-88	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g6977	i0	87	171.908011869436	300	39	89	0	38	337	634712	635011	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	57933	339	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
24288244	24288244	PRJEB48218_S_NODE_18980_length_217_cov_2.122340_g18018_i0	PRJEB48218	18980	217	2.12234	4.6054778	Mesoterricola sediminis	2927980	Bacteria	Bacteria	128	3.1e-25	NTclustered	gi\|2490895851\|dbj\|AP027081.1\|	2927980	g18018	i0	81.212	1.50691244239631	165	25	75	6	56	217	3370766	3370927	Mesoterricola sediminis W786 DNA, complete genome	blastn	327	128	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola sediminis
26970071	26970071	PRJEB48218_S_NODE_24142_length_179_cov_2.306667_g23180_i0	PRJEB48218	24142	179	2.306667	4.12893393	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	105	1.26e-24	NR	MBX7184240.1	2793154	g23180	i0	92.9	1.87709497206704	56	4	93.9	0	173	6	397	452	MBX7184240.1 CusA/CzcA family heavy metal efflux RND transporter [Vicinamibacteria bacterium]	diamond	336	105	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
27823415	27823415	PRJEB48218_S_NODE_20464_length_205_cov_2.977273_g19502_i0	PRJEB48218	20464	205	2.977273	6.10340965	Candidatus Polarisedimenticolaceae bacterium	2910585	Bacteria	Bacteria	42.7	0.0235	NR	HEX5042409.1	2910585	g19502	i0	48	1.46341463414634	50	24	71.7	2	19	165	189	237	HEX5042409.1 hypothetical protein [Candidatus Polarisedimenticolaceae bacterium]	diamond	300	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Candidatus Polarisedimenticolia	Candidatus Polarisedimenticolales	Candidatus Polarisedimenticolaceae		Candidatus Polarisedimenticolaceae bacterium
28044222	28044222	PRJEB48218_S_NODE_24005_length_180_cov_2.066225_g23043_i0	PRJEB48218	24005	180	2.066225	3.719205	Terriglobia bacterium	2081523	Bacteria	Bacteria	110	2.5100000000000004e-27	NR	HLQ77968.1	2081523	g23043	i0	86.7	2	60	8	100	0	1	180	15	74	HLQ77968.1 methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [Terriglobia bacterium]	diamond	360	110	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
29086332	29086332	PRJEB48218_S_NODE_23228_length_185_cov_2.641026_g22266_i0	PRJEB48218	23228	185	2.641026	4.8858981	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	130	1.58e-34	NR	HVA96474.1	2952895	g22266	i0	88.5	0.989189189189189	61	7	98.9	0	2	184	116	176	HVA96474.1 glycosyltransferase [Candidatus Acidiferrales bacterium]	diamond	183	130	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
31423903	31423903	PRJEB48218_S_NODE_24116_length_179_cov_2.660000_g23154_i0	PRJEB48218	24116	179	2.66	4.7614	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	46.2	5.85e-4	NR	HET9319555.1	2212468	g23154	i0	62.9	0.58659217877095	35	11	55.3	1	74	172	54	88	HET9319555.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	105	46.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
32056572	32056572	PRJEB48218_S_NODE_28238_length_159_cov_2.238462_g27276_i0	PRJEB48218	28238	159	2.238462	3.55915458	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	58.2	4.21e-8	NR	HEX8459685.1	2283092	g27276	i0	47.1	0.962264150943396	51	27	96.2	0	2	154	50	100	HEX8459685.1 ThiF family adenylyltransferase [Pyrinomonadaceae bacterium]	diamond	153	58.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32214910	32214910	PRJEB48218_S_NODE_10498_length_279_cov_3.972000_g9536_i0	PRJEB48218	10498	279	3.972	11.08188	Candidatus Angelobacter sp.	2976921	Bacteria	Bacteria	62.4	6.99e-9	NR	HZJ34632.1	2976921	g9536	i0	66.7	0.580645161290323	54	18	58.1	0	27	188	443	496	HZJ34632.1 hypothetical protein [Candidatus Angelobacter sp.]	diamond	162	62.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia			Candidatus Angelobacter	Candidatus Angelobacter sp.

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