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

13 rows where analysis = "blastn", bioproject = "PRJNA1126198" 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
281264	281264	PRJNA1126198_P_NODE_231061_length_283_cov_1.485714_g230340_i0	PRJNA1126198	231061	283	1.485714	4.20457062	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	385	2.27e-102	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g230340	i0	93.156	1.85512367491166	263	16	93	2	22	283	3291242	3291503	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	525	385	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
281643	281643	PRJNA1126198_P_NODE_425261_length_246_cov_1.196532_g424540_i0	PRJNA1126198	425261	246	1.196532	2.94346872	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	422	1.47e-113	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g424540	i0	97.561	268.308943089431	246	6	100	0	1	246	9534	9289	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	66004	422	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1555741	1555741	PRJNA1126198_P_NODE_159682_length_308_cov_6.331915_g158963_i0	PRJNA1126198	159682	308	6.331915	19.5022982	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	508	1.42e-139	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g158963	i0	96.429	349.090909090909	308	11	100	0	1	308	4840213	4840520	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	107520	508	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6659067	6659067	PRJNA1126198_P_NODE_221766_length_286_cov_1.225352_g221045_i0	PRJNA1126198	221766	286	1.225352	3.50450672	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	147	1.18e-30	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g221045	i0	77.567	4.88461538461539	263	46	88	11	34	286	3019940	3020199	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	1397	147	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6659108	6659108	PRJNA1126198_P_NODE_242226_length_280_cov_1.497585_g241505_i0	PRJNA1126198	242226	280	1.497585	4.193238	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	451	2.18e-122	NTclustered	gi\|217038896\|gb\|EU810986.1\|	171953	g241505	i0	95.714	590.482142857143	280	12	100	0	1	280	314	35	Uncultured Acidobacteria bacterium clone 01QD6 23S ribosomal RNA gene, partial sequence	blastn	165335	451	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7934364	7934364	PRJNA1126198_P_NODE_283027_length_270_cov_1.131980_g282306_i0	PRJNA1126198	283027	270	1.13198	3.056346	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	257	4.8900000000000005e-64	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g282306	i0	85.772	0.911111111111111	246	31	90	4	21	264	5315989	5316232	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	246	257	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7934453	7934453	PRJNA1126198_P_NODE_333287_length_258_cov_1.686486_g332566_i0	PRJNA1126198	333287	258	1.686486	4.35113388	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	267	7.699999999999999e-67	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g332566	i0	88.636	66.6976744186046	220	23	85	2	10	228	154864	155082	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	17208	267	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
9209345	9209345	PRJNA1126198_P_NODE_291788_length_267_cov_2.835052_g291067_i0	PRJNA1126198	291788	267	2.835052	7.56958884	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g291067	i0	96.774	0.116104868913858	31	1	12	0	233	263	2338574	2338544	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11760337	11760337	PRJNA1126198_P_NODE_453050_length_243_cov_1.823529_g452329_i0	PRJNA1126198	453050	243	1.823529	4.43117547	Terriglobus roseus	392734	Bacteria	Bacteria	104	5.96e-18	NTclustered	gi\|1085637902\|emb\|LT629690.1\|	392734	g452329	i0	76.106	0.930041152263374	226	38	90	11	26	243	2312749	2312966	Terriglobus roseus strain GAS232 genome assembly, chromosome: I	blastn	226	104	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
16858559	16858559	PRJNA1126198_P_NODE_291614_length_268_cov_0.738462_g290893_i0	PRJNA1126198	291614	268	0.738462	1.97907816	uncultured Holophaga sp.	188475	Bacteria	Bacteria	82.4	3.13e-11	NTclustered	gi\|2621704223\|emb\|OY761614.1\|	188475	g290893	i0	97.872	13.5671641791045	47	1	18	0	23	69	1131542	1131588	MAG: uncultured Holophaga sp. isolate c3c763bb-72ba-4188-aae9-c4b83244ba6d genome assembly, chromosome: 1	blastn	3636	82.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
18881736	18881736	PRJNA1126198_P_NODE_151675_length_312_cov_1.715481_g150956_i0	PRJNA1126198	151675	312	1.715481	5.35230072	Bacteria	2	Bacteria	Bacteria	473	5.2499999999999996e-129	NTclustered	gi\|31789363\|gb\|AY281352.1\|	171953	g150956	i0	94.212	104.179487179487	311	16	99	2	2	312	3330	3638	Uncultured Acidobacteria bacterium clone 23k22 genomic sequence	blastn	32504	477	0.991614255765199	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19407057	19407057	PRJNA1126198_P_NODE_18356_length_503_cov_2.453488_g17663_i0	PRJNA1126198	18356	503	2.453488	12.34104464	Geothrix sp. 21YS21S-2	3068893	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|2566094019\|gb\|CP132910.1\|	3068893	g17663	i0	100	0.0556660039761431	28	0	6	0	164	191	3145741	3145768	Geothrix sp. 21YS21S-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-2
24507444	24507444	PRJNA1126198_P_NODE_361260_length_253_cov_0.866667_g360539_i0	PRJNA1126198	361260	253	0.866667	2.19266751	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	239	1.6400000000000002e-58	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g360539	i0	84.81	2.49407114624506	237	36	94	0	17	253	2343169	2342933	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	631	239	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);;