metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA315314" 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
4893089	4893089	PRJNA315314_S_NODE_14784_length_212_cov_53.710383_g14463_i0	PRJNA315314	14784	212	53.710383	113.86601196	Bacteria	2	Bacteria	Bacteria	248	2.2099999999999997e-61	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g14463	i0	88.35	142.5	206	24	97	0	7	212	29533	29328	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	30210	248	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5484169	5484169	PRJNA315314_S_NODE_14085_length_217_cov_11.569149_g13764_i0	PRJNA315314	14085	217	11.569149	25.10505333	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	257	3.78e-64	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g13764	i0	88.318	224.857142857143	214	25	99	0	1	214	3559284	3559071	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	48794	257	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
5484241	5484241	PRJNA315314_S_NODE_1825_length_574_cov_1582.480734_g1555_i0	PRJNA315314	1825	574	1582.480734	9083.43941316	Geothrix sp. 21YS21S-4	3068889	Bacteria	Bacteria	512	2.1599999999999997e-140	NTclustered	gi\|2565867660\|gb\|CP132719.1\|	3068889	g1555	i0	91.029	126.923344947735	379	34	66	0	196	574	150537	150915	Geothrix sp. 21YS21S-4 chromosome, complete genome	blastn	72854	512	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-4
6168039	6168039	PRJNA315314_S_NODE_10705_length_247_cov_138.633028_g10384_i0	PRJNA315314	10705	247	138.633028	342.42357916	Geothrix	44675	Bacteria	Bacteria	326	1.19e-84	NTclustered	gi\|84452201\|emb\|AM180899.1\|	171953	g10384	i0	90.688	591.882591093117	247	20	99	3	1	245	1717	1472	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone LS_LKC11_kan2	blastn	146195	326	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7443152	7443152	PRJNA315314_S_NODE_14646_length_213_cov_57.543478_g14325_i0	PRJNA315314	14646	213	57.543478	122.56760814	Bacteria	2	Bacteria	Bacteria	337	4.62e-88	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g14325	i0	96.117	128.215962441315	206	8	97	0	8	213	4231896	4231691	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	27310	339	0.994100294985251	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7443217	7443217	PRJNA315314_S_NODE_25286_length_166_cov_183.029197_g24965_i0	PRJNA315314	25286	166	183.029197	303.82846702	Bacteria	2	Bacteria	Bacteria	291	2.7099999999999998e-74	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g24965	i0	98.193	249.849397590361	166	3	100	0	1	166	2366070	2366235	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	41475	291	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8034291	8034291	PRJNA315314_S_NODE_5967_length_330_cov_7.239203_g5646_i0	PRJNA315314	5967	330	7.239203	23.8893699	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	324	5.9599999999999995e-84	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g5646	i0	85.625	137.2	320	33	95	13	1	312	4233633	4233947	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	45276	324	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9309059	9309059	PRJNA315314_S_NODE_6148_length_325_cov_296.341216_g5827_i0	PRJNA315314	6148	325	296.341216	963.108952	Geothrix sp. 21YS21S-4	3068889	Bacteria	Bacteria	556	5.31e-154	NTclustered	gi\|2565867660\|gb\|CP132719.1\|	3068889	g5827	i0	97.538	244.310769230769	325	8	100	0	1	325	151826	151502	Geothrix sp. 21YS21S-4 chromosome, complete genome	blastn	79401	556	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-4
11859459	11859459	PRJNA315314_S_NODE_19810_length_185_cov_669.224359_g19489_i0	PRJNA315314	19810	185	669.224359	1238.06506415	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	172	1.16e-38	NTclustered	gi\|112980853\|gb\|DQ829657.1\|	171953	g19489	i0	83.511	179.475675675676	188	27	100	4	1	185	382	196	Uncultured Acidobacteria bacterium clone DON33 23S ribosomal RNA gene, partial sequence	blastn	33203	172	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11859708	11859708	PRJNA315314_S_NODE_6070_length_327_cov_353.506711_g5749_i0	PRJNA315314	6070	327	353.506711	1155.96694497	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	370	7.47e-98	NTclustered	gi\|217038917\|gb\|EU811008.1\|	171953	g5749	i0	87.195	187.100917431193	328	39	100	3	1	327	382	57	Uncultured Acidobacteria bacterium clone 01QCW 23S ribosomal RNA gene, partial sequence	blastn	61182	370	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14409755	14409755	PRJNA315314_S_NODE_2432_length_507_cov_14.585774_g2129_i0	PRJNA315314	2432	507	14.585774	73.94987418	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	488	3.1899999999999996e-133	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g2129	i0	84.54	243.364891518738	511	59	99	16	3	507	2366660	2367156	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	123386	488	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15092962	15092962	PRJNA315314_S_NODE_14092_length_217_cov_8.239362_g13771_i0	PRJNA315314	14092	217	8.239362	17.87941554	Holophagaceae	574976	Bacteria	Bacteria	346	7.85e-91	NTclustered	gi\|84452196\|emb\|AM180894.1\|	44676	g13771	i0	95.392	236.087557603687	217	10	100	0	1	217	1167	951	Geothrix fermentans partial 23S rRNA gene, strain DSM 14018	blastn	51231	346	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix fermentans
16367893	16367893	PRJNA315314_S_NODE_2953_length_460_cov_9.185615_g2636_i0	PRJNA315314	2953	460	9.185615	42.253829	Holophaga	35838	Bacteria	Bacteria	427	6.349999999999998e-115	NTclustered	gi\|84452201\|emb\|AM180899.1\|	171953	g2636	i0	83.582	282.930434782609	469	64	99	9	1	458	1260	1726	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone LS_LKC11_kan2	blastn	130148	427	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16958522	16958522	PRJNA315314_S_NODE_9954_length_256_cov_81.414097_g9633_i0	PRJNA315314	9954	256	81.414097	208.42008832	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	246	9.95e-61	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g9633	i0	85.656	168.4921875	244	23	93	11	19	256	716223	715986	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	43134	246	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20782264	20782264	PRJNA315314_S_NODE_17777_length_195_cov_4.156627_g17456_i0	PRJNA315314	17777	195	4.156627	8.10542265	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	167	5.7699999999999995e-37	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g17456	i0	95.238	268.805128205128	105	5	54	0	91	195	10686	10790	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	52417	167	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20782568	20782568	PRJNA315314_S_NODE_6377_length_319_cov_18.141379_g6056_i0	PRJNA315314	6377	319	18.141379	57.87099901	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	455	1.95e-123	NTclustered	gi\|192805573\|emb\|FM176375.1\|	194844	g6056	i0	92.476	98.5862068965517	319	22	99	2	1	318	318	1	Uncultured Acidobacteriaceae bacterium partial 16S rRNA gene, clone CL5.H127	blastn	31449	455	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
22742062	22742062	PRJNA315314_S_NODE_13418_length_222_cov_20.989637_g13097_i0	PRJNA315314	13418	222	20.989637	46.59699414	Bacteria	2	Bacteria	Bacteria	220	5.099999999999999e-53	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g13097	i0	85.068	81.2792792792793	221	27	99	6	1	219	3298696	3298912	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	18044	222	0.990990990990991	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
22742208	22742208	PRJNA315314_S_NODE_6418_length_318_cov_29.965398_g6097_i0	PRJNA315314	6418	318	29.965398	95.28996564	Bacteria	2	Bacteria	Bacteria	394	4.3e-105	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g6097	i0	89.241	616.474842767296	316	33	99	1	4	318	2367342	2367657	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	196039	394	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23332823	23332823	PRJNA315314_S_NODE_21039_length_180_cov_27.947020_g20718_i0	PRJNA315314	21039	180	27.94702	50.304636	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	215	1.84e-51	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g20718	i0	89.655	62.75	174	10	93	6	1	168	4649790	4649961	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	11295	215	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
24017120	24017120	PRJNA315314_S_NODE_17359_length_197_cov_6.660714_g17038_i0	PRJNA315314	17359	197	6.660714	13.12160658	Bacteria	2	Bacteria	Bacteria	211	2.66e-50	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g17038	i0	91.026	67.6446700507614	156	14	79	0	2	157	2774634	2774479	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	13326	213	0.990610328638498	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales 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);;