metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA690124" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA690124" 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
1945672	1945672	PRJNA690124_P_NODE_49222_length_248_cov_0.891429_g48856_i0	PRJNA690124	49222	248	0.891429	2.21074392	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	255	1.59e-63	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g48856	i0	85.259	1.01209677419355	251	33	100	3	1	248	2967731	2967980	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	251	255	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
3220406	3220406	PRJNA690124_P_NODE_45823_length_251_cov_0.876404_g45457_i0	PRJNA690124	45823	251	0.876404	2.19977404	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	200	7.679999999999999e-47	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g45457	i0	82.833	31.7250996015936	233	30	91	9	21	248	3215245	3215472	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	7963	200	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3220472	3220472	PRJNA690124_P_NODE_48703_length_248_cov_0.891429_g48337_i0	PRJNA690124	48703	248	0.891429	2.21074392	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	320	5.57e-83	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g48337	i0	89.919	14.0403225806452	248	25	100	0	1	248	606158	605911	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	3482	320	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4497093	4497093	PRJNA690124_P_NODE_24024_length_334_cov_2.007663_g23658_i0	PRJNA690124	24024	334	2.007663	6.70559442	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	427	4.48e-115	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g23658	i0	90.303	230.308383233533	330	27	98	5	1	327	328	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	76923	427	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4497586	4497586	PRJNA690124_P_NODE_45624_length_251_cov_0.876404_g45258_i0	PRJNA690124	45624	251	0.876404	2.19977404	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	213	9.86e-51	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g45258	i0	92.053	13.800796812749	151	12	60	0	2	152	1444151	1444301	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	3464	213	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9598104	9598104	PRJNA690124_P_NODE_47768_length_249_cov_0.886364_g47402_i0	PRJNA690124	47768	249	0.886364	2.20704636	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	243	1.25e-59	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g47402	i0	84.615	20.6546184738956	247	34	98	4	1	245	4906627	4906871	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	5143	243	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9598134	9598134	PRJNA690124_P_NODE_49148_length_248_cov_0.891429_g48782_i0	PRJNA690124	49148	248	0.891429	2.21074392	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	204	5.849999999999999e-48	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g48782	i0	81.673	13.7379032258065	251	40	100	6	1	248	1972638	1972391	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	3407	204	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10873793	10873793	PRJNA690124_P_NODE_55949_length_242_cov_0.923077_g55583_i0	PRJNA690124	55949	242	0.923077	2.23384634	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	122	1.6399999999999998e-23	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g55583	i0	78.218	0.834710743801653	202	36	82	8	42	239	2287990	2288187	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	202	122	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19029853	19029853	PRJNA690124_P_NODE_11895_length_466_cov_1.732824_g11530_i0	PRJNA690124	11895	466	1.732824	8.07495984	Bacteria	2	Bacteria	Bacteria	442	2.2999999999999994e-119	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g11530	i0	91.798	223.774678111588	317	26	68	0	1	317	317	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	104279	446	0.991031390134529	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19796412	19796412	PRJNA690124_P_NODE_44256_length_252_cov_0.871508_g43890_i0	PRJNA690124	44256	252	0.871508	2.19620016	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	211	3.56e-50	NTclustered	gi\|2893356059\|emb\|OZ220482.1\|	2651171	g43890	i0	81.818	58.8452380952381	253	44	100	2	1	252	294351	294100	MAG: Thermoanaerobaculia bacterium isolate 1ba308f5-42e2-4878-81ff-2dc7ade272f8 genome assembly, chromosome: 1	blastn	14829	211	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
22347050	22347050	PRJNA690124_P_NODE_53278_length_244_cov_0.912281_g52912_i0	PRJNA690124	53278	244	0.912281	2.22596564	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2893358444\|emb\|OZ220736.1\|	2910147	g52912	i0	100	0.122950819672131	30	0	12	0	195	224	414388	414417	MAG: Vicinamibacterales bacterium isolate e96e4bd8-36b5-4932-a7c8-d2011ef2eb69 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
23622144	23622144	PRJNA690124_P_NODE_35119_length_280_cov_2.004831_g34753_i0	PRJNA690124	35119	280	2.004831	5.6135268	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2893358415\|emb\|OZ220706.1\|	1978231	g34753	i0	100	0.1	28	0	10	0	141	168	1163466	1163493	MAG: Acidobacteriota bacterium isolate 3e01828c-349b-4d98-9675-17abf9a03cac genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
23622494	23622494	PRJNA690124_P_NODE_50499_length_247_cov_0.896552_g50133_i0	PRJNA690124	50499	247	0.896552	2.21448344	Geothrix sp.	1962974	Bacteria	Bacteria	145	3.58e-30	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g50133	i0	81.921	33.3157894736842	177	26	70	5	7	180	429696	429869	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	8229	145	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.

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