metadata: contig_metadata: 24 rows where bioproject = "PRJNA293022", tax_kingdom = "Pseudomonadati" and tax

24 rows where bioproject = "PRJNA293022", tax_kingdom = "Pseudomonadati" 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
373252	373252	PRJNA293022_P_NODE_32521_length_245_cov_3.265306_g31784_i0	PRJNA293022	32521	245	3.265306	7.9999997	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	449	6.710000000000001e-122	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g31784	i0	100	105.048979591837	243	0	99	0	1	243	634970	635212	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	25737	449	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
373467	373467	PRJNA293022_P_NODE_82241_length_155_cov_2.424528_g81504_i0	PRJNA293022	82241	155	2.424528	3.7580184	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	263	5.41e-66	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g81504	i0	97.403	146.432258064516	154	4	99	0	2	155	3298766	3298919	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	22697	263	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
2923869	2923869	PRJNA293022_P_NODE_19383_length_324_cov_1.076364_g18646_i0	PRJNA293022	19383	324	1.076364	3.48741936	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	534	2.4799999999999998e-147	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g18646	i0	96.584	103.104938271605	322	11	99	0	1	322	11325	11646	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	33406	534	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2924132	2924132	PRJNA293022_P_NODE_75423_length_164_cov_0.904348_g74686_i0	PRJNA293022	75423	164	0.904348	1.48313072	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	283	4.46e-72	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g74686	i0	98.148	0.98780487804878	162	3	99	0	1	162	3159125	3158964	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	162	283	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
4200309	4200309	PRJNA293022_P_NODE_13684_length_386_cov_37.136499_g12947_i0	PRJNA293022	13684	386	37.136499	143.34688614	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	551	2.979999999999999e-152	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g12947	i0	92.487	120.269430051813	386	27	99	2	2	386	3558485	3558101	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	46424	551	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
8026723	8026723	PRJNA293022_P_NODE_68687_length_168_cov_1.403361_g67950_i0	PRJNA293022	68687	168	1.403361	2.35764648	Sulfidibacter corallicola	2818388	Bacteria	Bacteria	106	1.07e-18	NTclustered	gi\|2013124720\|gb\|CP071793.1\|	2818388	g67950	i0	100	65.5297619047619	57	0	34	0	110	166	3680211	3680267	Sulfidibacter corallicola strain M133 chromosome, complete genome	blastn	11009	106	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Acanthopleuribacterales	Acanthopleuribacteraceae	Sulfidibacter	Sulfidibacter corallicola
9301281	9301281	PRJNA293022_P_NODE_2208_length_895_cov_20.773050_g1767_i0	PRJNA293022	2208	895	20.77305	185.9187975	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	1266	0	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g1767	i0	92.214	90.7575418994413	899	63	100	5	1	895	634491	635386	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	81228	1266	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
9301318	9301318	PRJNA293022_P_NODE_31148_length_251_cov_1.811881_g30411_i0	PRJNA293022	31148	251	1.811881	4.54782131	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	438	1.4899999999999995e-118	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g30411	i0	98.4	314.274900398406	250	2	99	2	1	249	641862	641614	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	78883	438	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
9301471	9301471	PRJNA293022_P_NODE_67148_length_169_cov_1.583333_g66411_i0	PRJNA293022	67148	169	1.583333	2.67583277	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	267	4.63e-67	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g66411	i0	95.238	19.3786982248521	168	8	99	0	2	169	2365856	2365689	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	3275	267	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11851894	11851894	PRJNA293022_P_NODE_29630_length_258_cov_2.167464_g28893_i0	PRJNA293022	29630	258	2.167464	5.59205712	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	468	1.97e-127	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g28893	i0	99.609	98.3604651162791	256	1	99	0	3	258	634239	633984	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	25377	468	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
13127065	13127065	PRJNA293022_P_NODE_32931_length_244_cov_1.389744_g32194_i0	PRJNA293022	32931	244	1.389744	3.39097536	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	315	2.5399999999999992e-81	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g32194	i0	90.123	65.9344262295082	243	22	99	2	3	244	1689581	1689340	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	16088	315	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13127074	13127074	PRJNA293022_P_NODE_34431_length_238_cov_2.497354_g33694_i0	PRJNA293022	34431	238	2.497354	5.94370252	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	348	2.4300000000000005e-91	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g33694	i0	93.22	123.680672268908	236	16	99	0	1	236	2367424	2367659	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	29436	348	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18225074	18225074	PRJNA293022_P_NODE_64155_length_173_cov_1.653226_g63418_i0	PRJNA293022	64155	173	1.653226	2.86008098	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	89.8	1.11e-13	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g63418	i0	86.585	1.00578034682081	82	9	47	2	8	88	3464150	3464230	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	174	89.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
19499228	19499228	PRJNA293022_P_NODE_48396_length_200_cov_2.920530_g47659_i0	PRJNA293022	48396	200	2.92053	5.84106	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	158	3.58e-34	NTclustered	gi\|2874253950\|emb\|OY970275.1\|	171953	g47659	i0	81.592	215.695	201	28	98	8	5	200	4267432	4267628	MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.c.2 genome assembly, chromosome: 1	blastn	43139	158	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21461511	21461511	PRJNA293022_P_NODE_62137_length_176_cov_1.622047_g61400_i0	PRJNA293022	62137	176	1.622047	2.85480272	root	1	Root_unresolved	Root_unresolved	139	1.11e-28	NTclustered	gi\|2874253769\|emb\|OY969716.1\|	171953	g61400	i0	88.793	91.75	116	10	66	3	60	175	4151591	4151479	MAG: uncultured Acidobacteriota bacterium isolate MFD04540.bin.c.1 genome assembly, chromosome: 1	blastn	16148	139	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22049981	22049981	PRJNA293022_P_NODE_79798_length_162_cov_0.734513_g79061_i0	PRJNA293022	79798	162	0.734513	1.18991106	Luteitalea pratensis	1855912	Bacteria	Bacteria	202	1.26e-47	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g79061	i0	89.809	194.648148148148	157	16	97	0	6	162	653608	653764	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	31533	202	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
23325245	23325245	PRJNA293022_P_NODE_21399_length_307_cov_4.205426_g20662_i0	PRJNA293022	21399	307	4.205426	12.91065782	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	375	1.5e-99	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g20662	i0	88.852	186.508143322476	305	34	99	0	1	305	3559019	3559323	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	57258	375	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
24011569	24011569	PRJNA293022_P_NODE_19079_length_326_cov_4.072202_g18342_i0	PRJNA293022	19079	326	4.072202	13.27537852	Bacteria	2	Bacteria	Bacteria	196	1.34e-45	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g18342	i0	87.952	53.5092024539877	166	20	51	0	92	257	30170	30335	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	17444	196	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24599273	24599273	PRJNA293022_P_NODE_1420_length_1063_cov_19.014793_g1070_i0	PRJNA293022	1420	1063	19.014793	202.12724959	Bryobacterales bacterium	2026791	Bacteria	Bacteria	1325	0	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g1070	i0	89.229	102.952022577611	1077	93	100	19	1	1063	6660252	6659185	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	109438	1325	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
24599418	24599418	PRJNA293022_P_NODE_50100_length_197_cov_1.195946_g49363_i0	PRJNA293022	50100	197	1.195946	2.35601362	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	207	3.44e-49	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g49363	i0	85.859	106.081218274112	198	25	99	2	1	196	3559246	3559050	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	20898	207	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
29442338	29442338	PRJNA293022_P_NODE_79630_length_162_cov_0.920354_g78893_i0	PRJNA293022	79630	162	0.920354	1.49097348	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	41.2	0.0407	NR	HEX6202390.1	2651171	g78893	i0	47.2	0.666666666666667	36	19	66.7	0	136	29	137	172	HEX6202390.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	108	41.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
29789746	29789746	PRJNA293022_P_NODE_50951_length_195_cov_1.801370_g50214_i0	PRJNA293022	50951	195	1.80137	3.5126715	Candidatus Solibacter sp.	2068625	Bacteria	Bacteria	41.2	0.0308	NR	MEO8369265.1	2068625	g50214	i0	56	0.384615384615385	25	11	38.5	0	172	98	8	32	MEO8369265.1 hypothetical protein [Candidatus Solibacter sp.]	diamond	75	41.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter sp.
31749211	31749211	PRJNA293022_P_NODE_78397_length_162_cov_1.831858_g77660_i0	PRJNA293022	78397	162	1.831858	2.96760996	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	96.7	1.5699999999999994e-23	NR	HYZ82997.1	2212468	g77660	i0	78.4	0.944444444444444	51	11	94.4	0	8	160	1	51	HYZ82997.1 peroxiredoxin [Bryobacteraceae bacterium]	diamond	153	96.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
32572158	32572158	PRJNA293022_P_NODE_56079_length_186_cov_1.394161_g55342_i0	PRJNA293022	56079	186	1.394161	2.59313946	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	40.8	0.0293	NR	HYN10246.1	2910147	g55342	i0	43.9	0.661290322580645	41	23	66.1	0	4	126	29	69	HYN10246.1 PadR family transcriptional regulator [Vicinamibacterales bacterium]	diamond	123	40.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales 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);;