metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA315399" 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
384580	384580	PRJNA315399_S_NODE_15501_length_303_cov_6.755639_g15300_i0	PRJNA315399	15501	303	6.755639	20.46958617	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	355	1.92e-93	NTclustered	gi\|76574297\|gb\|DQ139445.1\|	171953	g15300	i0	90.977	112.838283828383	266	20	87	4	6	268	13	277	Uncultured Acidobacteria bacterium clone CAL4 23S ribosomal RNA gene, partial sequence	blastn	34190	355	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1658062	1658062	PRJNA315399_P_NODE_454942_length_155_cov_12.288136_g454494_i0	PRJNA315399	454942	155	12.288136	19.0466108	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	84.2	4.52e-12	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g454494	i0	82.178	0.651612903225806	101	15	64	3	4	102	4217651	4217552	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	101	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
4211379	4211379	PRJNA315399_S_NODE_101604_length_178_cov_1.489362_g101403_i0	PRJNA315399	101604	178	1.489362	2.65106436	Luteitalea pratensis	1855912	Bacteria	Bacteria	291	2.93e-74	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g101403	i0	96.067	2.07865168539326	178	7	100	0	1	178	5847976	5847799	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	370	291	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
4211963	4211963	PRJNA315399_S_NODE_171684_length_155_cov_6.737288_g171483_i0	PRJNA315399	171684	155	6.737288	10.4427964	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	180	5.599999999999998e-41	NTclustered	gi\|2874253852\|emb\|OY969908.1\|	194844	g171483	i0	87.662	26.5870967741935	154	19	99	0	1	154	2169550	2169397	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1	blastn	4121	180	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
5487668	5487668	PRJNA315399_P_NODE_90445_length_205_cov_15.321429_g89997_i0	PRJNA315399	90445	205	15.321429	31.40892945	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	126	1.04e-24	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g89997	i0	96.104	19.1170731707317	77	3	38	0	113	189	4839154	4839078	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	3919	126	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5489321	5489321	PRJNA315399_S_NODE_85365_length_186_cov_2.912752_g85164_i0	PRJNA315399	85365	186	2.912752	5.41771872	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	180	6.99e-41	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g85164	i0	88.079	0.811827956989247	151	18	81	0	2	152	3281646	3281496	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	151	180	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
5489346	5489346	PRJNA315399_S_NODE_87785_length_184_cov_44.455782_g87584_i0	PRJNA315399	87785	184	44.455782	81.79863888	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	202	1.47e-47	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g87584	i0	94.615	25.625	130	7	71	0	16	145	317252	317381	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	4715	202	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9995062	9995062	PRJNA315399_S_NODE_48548_length_216_cov_6.256983_g48347_i0	PRJNA315399	48548	216	6.256983	13.51508328	Bacteria	2	Bacteria	Bacteria	305	1.33e-78	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g48347	i0	93.269	271.699074074074	208	13	96	1	1	207	9263	9470	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	58687	305	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10588413	10588413	PRJNA315399_S_NODE_162869_length_157_cov_8.758333_g162668_i0	PRJNA315399	162869	157	8.758333	13.75058281	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	174	2.65e-39	NTclustered	gi\|2874253786\|emb\|OY969770.1\|	2952895	g162668	i0	90.769	119.216560509554	130	12	83	0	14	143	3515720	3515849	MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1	blastn	18717	174	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
10589401	10589401	PRJNA315399_S_NODE_71849_length_195_cov_1.493671_g71648_i0	PRJNA315399	71849	195	1.493671	2.91265845	Luteitalea pratensis	1855912	Bacteria	Bacteria	268	1.5399999999999998e-67	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g71648	i0	92.105	0.974358974358974	190	15	97	0	1	190	870792	870603	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	190	268	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
11862230	11862230	PRJNA315399_P_NODE_488690_length_152_cov_4.104348_g488242_i0	PRJNA315399	488690	152	4.104348	6.23860896	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	54.7	0.003	NTclustered	gi\|2893356059\|emb\|OZ220482.1\|	2651171	g488242	i0	96.875	0.210526315789474	32	1	21	0	2	33	1135942	1135973	MAG: Thermoanaerobaculia bacterium isolate 1ba308f5-42e2-4878-81ff-2dc7ade272f8 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
13819000	13819000	PRJNA315399_P_NODE_18331_length_301_cov_22.727273_g17888_i0	PRJNA315399	18331	301	22.727273	68.40909173	Acidobacteriota	57723	Bacteria	Bacteria	147	1.25e-30	NTclustered	gi\|470484216\|ref\|NR_076636.1\|	33075	g17888	i0	93.878	37.6810631229236	98	4	32	2	14	110	1	97	Acidobacterium capsulatum strain 161 23S ribosomal RNA gene, complete sequence	blastn	11342	147	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacterium	Acidobacterium capsulatum
14411156	14411156	PRJNA315399_P_NODE_266852_length_180_cov_9.818182_g266404_i0	PRJNA315399	266852	180	9.818182	17.6727276	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	60.2	9.13e-5	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g266404	i0	92.683	0.227777777777778	41	3	23	0	23	63	1861706	1861666	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	41	60.2	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14411893	14411893	PRJNA315399_P_NODE_387892_length_163_cov_2.976190_g387444_i0	PRJNA315399	387892	163	2.97619	4.8511897	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	99	1.72e-16	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g387444	i0	90.541	0.828220858895706	74	7	45	0	75	148	2109570	2109643	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	135	99	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
20783659	20783659	PRJNA315399_P_NODE_266157_length_180_cov_13.566434_g265709_i0	PRJNA315399	266157	180	13.566434	24.4195812	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	119	1.48e-22	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g265709	i0	95.89	19.5888888888889	73	3	41	0	90	162	4839151	4839079	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	3526	119	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23336685	23336685	PRJNA315399_S_NODE_168299_length_156_cov_4.168067_g168098_i0	PRJNA315399	168299	156	4.168067	6.50218452	Edaphobacter paludis	3035702	Bacteria	Bacteria	99	1.63e-16	NTclustered	gi\|2737763816\|gb\|CP121194.1\|	3035702	g168098	i0	79.433	1.80769230769231	141	27	90	2	12	151	160955	160816	Edaphobacter paludis strain DSM 109919 chromosome, complete genome	blastn	282	99	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter paludis

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