metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA533623" 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
506426	506426	PRJNA533623_P_NODE_32901_length_391_cov_2.763636_g31130_i0	PRJNA533623	32901	391	2.763636	10.80581676	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	614	3.7999999999999998e-171	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g31130	i0	98.837	0.994884910485934	344	4	88	0	25	368	819683	819340	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	389	614	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
506440	506440	PRJNA533623_P_NODE_33621_length_385_cov_8.533951_g31850_i0	PRJNA533623	33621	385	8.533951	32.85571135	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	568	2.9499999999999995e-157	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g31850	i0	96.501	20.3662337662338	343	12	89	0	23	365	3847290	3846948	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	7841	568	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
506492	506492	PRJNA533623_P_NODE_35501_length_372_cov_10.919614_g33729_i0	PRJNA533623	35501	372	10.919614	40.62096408	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	531	3.73e-146	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g33729	i0	95.495	134.663978494624	333	14	89	1	22	353	4841591	4841923	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	50095	531	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2393537	2393537	PRJNA533623_P_NODE_6082_length_931_cov_21.785057_g4786_i0	PRJNA533623	6082	931	21.785057	202.81888067	Chloracidobacterium	458032	Bacteria	Bacteria	928	0	NTclustered	gi\|2033637735\|gb\|CP072633.1\|	458033	g4786	i0	97.431	14.733619763695	545	13	58	1	1	544	621861	622405	Chloracidobacterium thermophilum strain B chromosome 2, complete sequence	blastn	13717	928	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum
8160150	8160150	PRJNA533623_P_NODE_8507_length_800_cov_361.312585_g7039_i0	PRJNA533623	8507	800	361.312585	2890.50068	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	63.9	3.71e-5	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g7039	i0	100	0.1275	34	0	5	0	3	36	6001275	6001308	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	102	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10046189	10046189	PRJNA533623_P_NODE_168_length_3288_cov_89.759529_g97_i0	PRJNA533623	168	3288	89.759529	2951.29331352	Chloracidobacterium	458032	Bacteria	Bacteria	1526	0	NTclustered	gi\|2033638576\|gb\|CP072634.1\|	2821536	g97	i0	85.54	31.6946472019465	1473	197	55	16	389	1853	1668477	1669941	Chloracidobacterium sp. D chromosome 1, complete sequence	blastn	104212	1526	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium sp. D
11985920	11985920	PRJNA533623_P_NODE_72190_length_213_cov_2.888158_g70409_i0	PRJNA533623	72190	213	2.888158	6.15177654	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	89.8	1.43e-13	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g70409	i0	79.412	3.32863849765258	136	20	62	8	46	177	5347290	5347421	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	709	89.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
14534588	14534588	PRJNA533623_P_NODE_10852_length_712_cov_116.588326_g9268_i0	PRJNA533623	10852	712	116.588326	830.10888112	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	63.9	3.29e-5	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g9268	i0	100	0.143258426966292	34	0	5	0	3	36	6001275	6001308	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	102	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23459323	23459323	PRJNA533623_P_NODE_67039_length_229_cov_5.416667_g65258_i0	PRJNA533623	67039	229	5.416667	12.40416743	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	307	3.95e-79	NTclustered	gi\|76574298\|gb\|DQ139446.1\|	171953	g65258	i0	96.739	92.4148471615721	184	6	80	0	25	208	520	703	Uncultured Acidobacteria bacterium clone CAL11 23S ribosomal RNA gene, partial sequence	blastn	21163	307	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);;