metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA771359" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA771359" 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_species
747033	747033	PRJNA771359_S_NODE_2621_length_206_cov_8.360947_g2538_i0	PRJNA771359	2621	206	8.360947	17.22355082	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	292	9.75e-75	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g2538	i0	92.271	211.325242718447	207	15	100	1	1	206	2283895	2283689	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	43533	292	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
2023039	2023039	PRJNA771359_S_NODE_2742_length_202_cov_2.654545_g2659_i0	PRJNA771359	2742	202	2.654545	5.3621809	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	147	7.84e-31	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g2659	i0	80.402	101.282178217822	199	34	98	4	6	202	3301031	3300836	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	20459	147	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
2023053	2023053	PRJNA771359_S_NODE_3562_length_178_cov_6.000000_g3479_i0	PRJNA771359	3562	178	6	10.68	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	165	1.85e-36	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g3479	i0	83.799	50.1516853932584	179	24	100	5	1	178	4233950	4233776	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	8927	165	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
3298252	3298252	PRJNA771359_S_NODE_3603_length_177_cov_2.950000_g3520_i0	PRJNA771359	3603	177	2.95	5.2215	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	237	3.85e-58	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g3520	i0	91.061	162.536723163842	179	11	100	5	1	177	4733722	4733547	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	28769	237	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
3298255	3298255	PRJNA771359_S_NODE_3723_length_174_cov_2.430657_g3640_i0	PRJNA771359	3723	174	2.430657	4.22934318	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	278	2.22e-70	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g3640	i0	95.402	248.344827586207	174	8	100	0	1	174	4651302	4651475	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	43212	278	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
3758499	3758499	PRJNA771359_S_NODE_2243_length_223_cov_7.973118_g2160_i0	PRJNA771359	2243	223	7.973118	17.78005314	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	324	3.8e-84	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g2160	i0	92.825	301.085201793722	223	16	100	0	1	223	2367388	2367610	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	67142	324	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
5850603	5850603	PRJNA771359_S_NODE_4285_length_163_cov_4.801587_g4202_i0	PRJNA771359	4285	163	4.801587	7.82658681	Bryobacterales bacterium	2026791	Bacteria	Bacteria	219	1.2699999999999999e-52	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g4202	i0	95.588	120.552147239264	136	6	83	0	28	163	2774498	2774633	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	19650	219	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales		Bryobacterales bacterium
7125767	7125767	PRJNA771359_S_NODE_3206_length_187_cov_11.553333_g3123_i0	PRJNA771359	3206	187	11.553333	21.60473271	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	322	1.1e-83	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g3123	i0	97.849	313.176470588235	186	4	99	0	2	187	148	333	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	58564	322	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
8400224	8400224	PRJNA771359_S_NODE_1227_length_304_cov_4.453184_g1144_i0	PRJNA771359	1227	304	4.453184	13.53767936	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	440	5.169999999999997e-119	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g1144	i0	92.787	127.026315789474	305	20	100	2	1	304	4841627	4841930	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	38616	440	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
8400266	8400266	PRJNA771359_S_NODE_3467_length_180_cov_18.699301_g3384_i0	PRJNA771359	3467	180	18.699301	33.6587418	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	178	2.41e-40	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g3384	i0	84.916	172.583333333333	179	23	98	4	4	180	886549	886725	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	31065	178	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
9675477	9675477	PRJNA771359_S_NODE_2768_length_201_cov_7.006098_g2685_i0	PRJNA771359	2768	201	7.006098	14.08225698	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	320	4.34e-83	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g2685	i0	95.522	228.004975124378	201	8	100	1	1	201	4233423	4233224	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	45829	320	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
10951117	10951117	PRJNA771359_S_NODE_1309_length_296_cov_4.247104_g1226_i0	PRJNA771359	1309	296	4.247104	12.57142784	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	250	9.08e-62	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g1226	i0	84.615	137.070945945946	260	31	86	9	33	288	2367245	2366991	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	40573	250	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
10951146	10951146	PRJNA771359_S_NODE_3109_length_190_cov_5.549020_g3026_i0	PRJNA771359	3109	190	5.54902	10.543138	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	193	9.22e-45	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g3026	i0	85.052	72.4684210526316	194	23	99	3	2	189	4003799	4003606	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	13769	193	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
14775916	14775916	PRJNA771359_S_NODE_1632_length_264_cov_4.995595_g1549_i0	PRJNA771359	1632	264	4.995595	13.1883708	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	135	2.3300000000000004e-27	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g1549	i0	81.765	19.4886363636364	170	24	63	7	98	264	1699525	1699360	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	5145	135	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales bacterium
15235224	15235224	PRJNA771359_S_NODE_1032_length_324_cov_18.986063_g949_i0	PRJNA771359	1032	324	18.986063	61.51484412	root	1	Root_unresolved	Root_unresolved	462	1.19e-125	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g949	i0	92.331	113.003086419753	326	23	100	2	1	324	4652821	4653146	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	36613	466	0.991416309012876	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
16049618	16049618	PRJNA771359_S_NODE_1493_length_275_cov_5.563025_g1410_i0	PRJNA771359	1493	275	5.563025	15.29831875	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	305	1.76e-78	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g1410	i0	87.037	79.4945454545455	270	35	98	0	6	275	45	314	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	21861	305	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
17325339	17325339	PRJNA771359_S_NODE_1254_length_301_cov_14.579545_g1171_i0	PRJNA771359	1254	301	14.579545	43.88443045	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	279	1.18e-70	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g1171	i0	85.294	332.255813953488	272	39	90	1	6	277	4232759	4233029	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	100009	279	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
17325412	17325412	PRJNA771359_S_NODE_894_length_342_cov_5.081967_g811_i0	PRJNA771359	894	342	5.081967	17.38032714	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	86.1	3.19e-12	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g811	i0	80.328	11.9678362573099	122	17	35	6	1	118	2119243	2119125	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	4093	86.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales bacterium
17325413	17325413	PRJNA771359_S_NODE_914_length_339_cov_6.701987_g831_i0	PRJNA771359	914	339	6.701987	22.71973593	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	207	6.46e-49	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g831	i0	84.091	310.958702064897	220	30	64	5	1	216	714368	714586	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	105415	207	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
17784366	17784366	PRJNA771359_S_NODE_1634_length_264_cov_4.374449_g1551_i0	PRJNA771359	1634	264	4.374449	11.54854536	Bacteria	2	Bacteria	Bacteria	283	7.859999999999999e-72	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g1551	i0	86.09	174.981060606061	266	34	99	2	1	263	4231695	4231960	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	46195	283	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
18598839	18598839	PRJNA771359_S_NODE_975_length_331_cov_4.731293_g892_i0	PRJNA771359	975	331	4.731293	15.66057983	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	529	1.1799999999999999e-145	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g892	i0	95.468	125.374622356495	331	15	100	0	1	331	4651977	4652307	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	41499	529	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
19873827	19873827	PRJNA771359_S_NODE_3756_length_173_cov_4.816176_g3673_i0	PRJNA771359	3756	173	4.816176	8.33198448	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	241	2.8900000000000007e-59	NTclustered	gi\|76574294\|gb\|DQ139442.1\|	171953	g3673	i0	92.398	98.2138728323699	171	10	98	2	4	173	391	559	Uncultured Acidobacteria bacterium clone CAL3 23S ribosomal RNA gene, partial sequence	blastn	16991	241	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
21149614	21149614	PRJNA771359_S_NODE_1917_length_239_cov_7.410891_g1834_i0	PRJNA771359	1917	239	7.410891	17.71202949	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	265	2.53e-66	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g1834	i0	86.611	344.083682008368	239	32	100	0	1	239	3559016	3559254	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	82236	265	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
21608891	21608891	PRJNA771359_S_NODE_1137_length_312_cov_9.109091_g1054_i0	PRJNA771359	1137	312	9.109091	28.42036392	Bacteria	2	Bacteria	Bacteria	193	1.65e-44	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g1054	i0	87.425	59.2275641025641	167	21	54	0	48	214	30336	30170	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	18479	193	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
22424310	22424310	PRJNA771359_S_NODE_1138_length_312_cov_7.927273_g1055_i0	PRJNA771359	1138	312	7.927273	24.73309176	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	342	1.5499999999999996e-89	NTclustered	gi\|217038917\|gb\|EU811008.1\|	171953	g1055	i0	86.624	163.878205128205	314	37	100	5	1	312	364	54	Uncultured Acidobacteria bacterium clone 01QCW 23S ribosomal RNA gene, partial sequence	blastn	51130	342	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
22424330	22424330	PRJNA771359_S_NODE_2158_length_227_cov_7.557895_g2075_i0	PRJNA771359	2158	227	7.557895	17.15642165	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g2075	i0	100	98.0704845814978	227	0	100	0	1	227	4232826	4233052	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	22262	420	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured 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);;