metadata: contig_metadata: 21 rows where bioproject = "PRJNA193544", tax_phylum = "Acidobacteriota" and tax

21 rows where bioproject = "PRJNA193544", 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
1055264	1055264	PRJNA193544_S_NODE_2541_length_173_cov_17.076389_g2526_i0	PRJNA193544	2541	173	17.076389	29.54215297	Terriglobia	204432	Bacteria	Bacteria	226	8.089999999999997e-55	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g2526	i0	90.173	506.924855491329	173	17	100	0	1	173	286354	286526	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	87698	226	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
1640677	1640677	PRJNA193544_S_NODE_282_length_364_cov_15.665672_g267_i0	PRJNA193544	282	364	15.665672	57.02304608	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	468	2.89e-127	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g267	i0	89.863	55.9423076923077	365	35	100	2	1	364	4232309	4232672	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	20363	468	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2916556	2916556	PRJNA193544_S_NODE_2543_length_173_cov_14.805556_g2528_i0	PRJNA193544	2543	173	14.805556	25.61361188	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	213	6.3e-51	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g2528	i0	90.625	77.7398843930636	160	15	92	0	3	162	4648726	4648885	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	13449	213	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
4193001	4193001	PRJNA193544_S_NODE_504_length_316_cov_146.843206_g489_i0	PRJNA193544	504	316	146.843206	464.02453096	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	370	7.19e-98	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g489	i0	91.76	146.237341772152	267	21	84	1	51	316	4649793	4649527	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	46211	370	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
5469205	5469205	PRJNA193544_S_NODE_1525_length_212_cov_70.010929_g1510_i0	PRJNA193544	1525	212	70.010929	148.42316948	Geothrix sp. PMB-07	3068640	Bacteria	Bacteria	339	1.28e-88	NTclustered	gi\|2563347696\|gb\|CP132333.1\|	3068640	g1510	i0	96.569	259.768867924528	204	7	96	0	1	204	1426297	1426500	Geothrix sp. PMB-07 chromosome, complete genome	blastn	55071	339	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. PMB-07
6743532	6743532	PRJNA193544_S_NODE_1046_length_247_cov_15.284404_g1031_i0	PRJNA193544	1046	247	15.284404	37.75247788	Geothrix sp. 21YS21S-2	3068893	Bacteria	Bacteria	368	1.95e-97	NTclustered	gi\|2566094019\|gb\|CP132910.1\|	3068893	g1031	i0	95.633	539.024291497976	229	10	93	0	19	247	221365	221137	Geothrix sp. 21YS21S-2 chromosome, complete genome	blastn	133139	368	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-2
8019269	8019269	PRJNA193544_S_NODE_2607_length_171_cov_6.126761_g2592_i0	PRJNA193544	2607	171	6.126761	10.47676131	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	117	5.01e-22	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g2592	i0	80.745	2.01754385964912	161	21	91	10	17	171	4650024	4649868	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	345	117	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
8019271	8019271	PRJNA193544_S_NODE_2867_length_163_cov_42.208955_g2852_i0	PRJNA193544	2867	163	42.208955	68.80059665	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	241	2.7000000000000008e-59	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g2852	i0	93.75	204.361963190184	160	10	98	0	1	160	4649397	4649556	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	33311	241	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
8019273	8019273	PRJNA193544_S_NODE_3227_length_155_cov_15.444444_g3212_i0	PRJNA193544	3227	155	15.444444	23.9388882	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	193	7.2e-45	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g3212	i0	89.241	290.703225806452	158	12	99	3	2	155	4648511	4648667	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	45059	193	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9294001	9294001	PRJNA193544_S_NODE_788_length_274_cov_5.073469_g773_i0	PRJNA193544	788	274	5.073469	13.90130506	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	375	1.3099999999999998e-99	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g773	i0	91.822	118.368613138686	269	22	98	0	1	269	3556653	3556385	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	32433	375	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
11258440	11258440	PRJNA193544_S_NODE_1209_length_233_cov_21.436275_g1194_i0	PRJNA193544	1209	233	21.436275	49.94652075	Geothrix	44675	Bacteria	Bacteria	414	2.3099999999999998e-111	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g1194	i0	98.712	109.309012875536	233	3	100	0	1	233	1294086	1294318	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	25469	414	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
11844472	11844472	PRJNA193544_S_NODE_350_length_347_cov_102.751572_g335_i0	PRJNA193544	350	347	102.751572	356.54795484	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	584	2.6199999999999987e-162	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g335	i0	97.118	109	347	9	99	1	1	346	4232026	4231680	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	37823	584	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12533892	12533892	PRJNA193544_S_NODE_630_length_297_cov_14.511194_g615_i0	PRJNA193544	630	297	14.511194	43.09824618	Holophagaceae	574976	Bacteria	Bacteria	544	3.7299999999999996e-150	NTclustered	gi\|84452196\|emb\|AM180894.1\|	44676	g615	i0	99.663	167.208754208754	297	1	100	0	1	297	1199	903	Geothrix fermentans partial 23S rRNA gene, strain DSM 14018	blastn	49661	549	0.990892531876138	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix fermentans
13119676	13119676	PRJNA193544_S_NODE_251_length_374_cov_25.507246_g236_i0	PRJNA193544	251	374	25.507246	95.39710004	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	401	3.069999999999999e-107	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g236	i0	86.17	716.516042780749	376	47	99	5	1	372	4233490	4233864	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	267977	401	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15668680	15668680	PRJNA193544_S_NODE_1793_length_200_cov_26.783626_g1778_i0	PRJNA193544	1793	200	26.783626	53.567252	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	326	9.27e-85	NTclustered	gi\|117557513\|emb\|AM180902.2\|	171953	g1778	i0	96	117	200	8	100	0	1	200	368	169	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone ZC6	blastn	23400	326	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15668696	15668696	PRJNA193544_S_NODE_2833_length_164_cov_30.088889_g2818_i0	PRJNA193544	2833	164	30.088889000000002	49.34577796	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	270	3.4699999999999992e-68	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g2818	i0	96.894	273.658536585366	161	5	98	0	4	164	4652233	4652073	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	44880	270	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15668697	15668697	PRJNA193544_S_NODE_293_length_361_cov_26.996988_g278_i0	PRJNA193544	293	361	26.996988	97.45912668	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	348	3.9e-91	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g278	i0	84.341	85.1246537396122	364	48	99	8	2	361	29317	29675	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	30730	348	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19491865	19491865	PRJNA193544_S_NODE_156_length_421_cov_9380.061224_g142_i0	PRJNA193544	156	421	9380.061224	39490.05775304	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	433	1.2399999999999998e-116	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g142	i0	95.588	118.70783847981	272	8	64	4	152	421	30789	31058	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	49976	433	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22042553	22042553	PRJNA193544_S_NODE_938_length_257_cov_14.973684_g923_i0	PRJNA193544	938	257	14.973684	38.48236788	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	305	1.63e-78	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g923	i0	88.627	91.7665369649805	255	23	98	6	5	257	2366993	2367243	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	23584	305	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24007235	24007235	PRJNA193544_S_NODE_819_length_270_cov_15985.240664_g804_i0	PRJNA193544	819	270	15985.240664	43160.1497928	Geothrix	44675	Bacteria	Bacteria	427	3.5199999999999993e-115	NTclustered	gi\|84452196\|emb\|AM180894.1\|	44676	g804	i0	99.156	94.5037037037037	237	2	88	0	34	270	1405	1169	Geothrix fermentans partial 23S rRNA gene, strain DSM 14018	blastn	25516	427	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix fermentans
28842274	28842274	PRJNA193544_S_NODE_2928_length_162_cov_2.827068_g2913_i0	PRJNA193544	2928	162	2.827068	4.57985016	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	58.2	1.1e-9	NR	MBI3423676.1	1978231	g2913	i0	83.9	0.574074074074074	31	5	57.4	0	98	6	3	33	MBI3423676.1 Flp family type IVb pilin [Acidobacteriota bacterium]	diamond	93	58.2	1	Bacteria	Pseudomonadati	Acidobacteriota					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);;