metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA982106" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA982106" 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
963774	963774	PRJNA982106_P_NODE_20641_length_251_cov_0.865169_g20401_i0	PRJNA982106	20641	251	0.865169	2.17157419	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	76.8	1.35e-9	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g20401	i0	95.745	15.5657370517928	47	2	19	0	1	47	6220393	6220439	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	3907	76.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6067090	6067090	PRJNA982106_P_NODE_20845_length_251_cov_0.865169_g20605_i0	PRJNA982106	20845	251	0.865169	2.17157419	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	291	4.43e-74	NTclustered	gi\|2874253721\|emb\|OY969563.1\|	2952895	g20605	i0	87.698	9.7410358565737	252	27	99	4	2	251	1570485	1570236	MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1	blastn	2445	291	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
8616917	8616917	PRJNA982106_P_NODE_27827_length_245_cov_0.895349_g27587_i0	PRJNA982106	27827	245	0.895349	2.19360505	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	248	2.6299999999999997e-61	NTclustered	gi\|2874253956\|emb\|OY970281.1\|	194844	g27587	i0	84.898	1.83265306122449	245	37	100	0	1	245	195589	195345	MAG: uncultured Acidobacteriaceae bacterium isolate MFD00008.bin.c.2 genome assembly, chromosome: 1	blastn	449	248	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
12443010	12443010	PRJNA982106_P_NODE_25530_length_247_cov_0.885057_g25290_i0	PRJNA982106	25530	247	0.885057	2.18609079	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	62.1	3.71e-5	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g25290	i0	97.222	15.7651821862348	36	1	15	0	148	183	855447	855482	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	3894	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
12443042	12443042	PRJNA982106_P_NODE_26910_length_246_cov_0.890173_g26670_i0	PRJNA982106	26910	246	0.890173	2.18982558	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g26670	i0	92.5	0.16260162601626	40	2	16	1	28	67	6040581	6040543	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	40	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
16266732	16266732	PRJNA982106_P_NODE_22693_length_249_cov_0.875000_g22453_i0	PRJNA982106	22693	249	0.875	2.17875	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	198	2.74e-46	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g22453	i0	81.048	68.7670682730924	248	47	99	0	2	249	4559010	4558763	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	17123	198	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
18815680	18815680	PRJNA982106_P_NODE_28795_length_244_cov_0.900585_g28555_i0	PRJNA982106	28795	244	0.900585	2.1974274	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	185	2.0799999999999994e-42	NTclustered	gi\|2621703956\|emb\|OY762911.1\|	2651171	g28555	i0	80.567	3.76229508196721	247	42	100	6	1	244	2822055	2821812	MAG: Thermoanaerobaculia bacterium isolate 14c23368-4dca-4d55-9b94-f295180eceef genome assembly, chromosome: 1	blastn	918	185	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
18815727	18815727	PRJNA982106_P_NODE_31335_length_242_cov_0.911243_g31095_i0	PRJNA982106	31335	242	0.911243	2.20520806	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	174	4.46e-39	NTclustered	gi\|2893358444\|emb\|OZ220736.1\|	2910147	g31095	i0	79.916	8.64049586776859	239	46	98	2	5	242	4063627	4063390	MAG: Vicinamibacterales bacterium isolate e96e4bd8-36b5-4932-a7c8-d2011ef2eb69 genome assembly, chromosome: 1	blastn	2091	174	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
21366027	21366027	PRJNA982106_P_NODE_30037_length_243_cov_0.905882_g29797_i0	PRJNA982106	30037	243	0.905882	2.20129326	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	156	1.6200000000000002e-33	NTclustered	gi\|2874253939\|emb\|OY970264.1\|	171953	g29797	i0	78.903	0.975308641975309	237	44	96	6	2	235	4358677	4358444	MAG: uncultured Acidobacteriota bacterium isolate MFD03726.bin.c.8 genome assembly, chromosome: 1	blastn	237	156	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22641052	22641052	PRJNA982106_P_NODE_30218_length_243_cov_0.905882_g29978_i0	PRJNA982106	30218	243	0.905882	2.20129326	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	189	1.6e-43	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g29978	i0	81.545	0.958847736625514	233	39	95	4	1	231	763779	764009	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	233	189	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25190332	25190332	PRJNA982106_P_NODE_9840_length_328_cov_1.925490_g9600_i0	PRJNA982106	9840	328	1.92549	6.3156072	Chloracidobacterium validum	2821543	Bacteria	Bacteria	89.8	2.35e-13	NTclustered	gi\|2033661925\|gb\|CP072649.1\|	2821543	g9600	i0	94.737	0.173780487804878	57	3	17	0	164	220	650253	650197	Chloracidobacterium validum strain BV2-C chromosome 2, complete sequence	blastn	57	89.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium validum

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