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

9 rows where analysis = "blastn", bioproject = "PRJDB4470" 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
1283403	1283403	PRJDB4470_P_NODE_118382_length_163_cov_0.912281_g117227_i0	PRJDB4470	118382	163	0.912281	1.48701803	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	202	1.27e-47	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g117227	i0	89.024	6.39877300613497	164	16	100	2	1	163	2282069	2282231	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	1043	202	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2558967	2558967	PRJDB4470_P_NODE_111923_length_165_cov_0.879310_g110768_i0	PRJDB4470	111923	165	0.87931	1.4508615	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	195	2.17e-45	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g110768	i0	87.879	1	165	20	100	0	1	165	5807148	5806984	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	165	195	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
2559609	2559609	PRJDB4470_P_NODE_70123_length_220_cov_1.964912_g68968_i0	PRJDB4470	70123	220	1.964912	4.3228064	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	224	3.9e-54	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g68968	i0	87.065	34.0409090909091	201	23	90	3	22	220	317252	317451	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	7489	224	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
5111508	5111508	PRJDB4470_P_NODE_110205_length_165_cov_1.758621_g109050_i0	PRJDB4470	110205	165	1.758621	2.90172465	Terriglobus albidus	1592106	Bacteria	Bacteria	165	1.6999999999999998e-36	NTclustered	gi\|1724546188\|gb\|CP042806.1\|	1592106	g109050	i0	86.667	3.21818181818182	150	19	91	1	6	155	1163430	1163578	Terriglobus albidus strain ORNL chromosome, complete genome	blastn	531	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus albidus
7661585	7661585	PRJDB4470_P_NODE_19627_length_544_cov_5.397980_g18534_i0	PRJDB4470	19627	544	5.3979799999999996	29.3650112	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	660	0	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g18534	i0	89.642	275.553308823529	531	38	96	15	1	522	715726	716248	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	149901	660	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12763174	12763174	PRJDB4470_P_NODE_56731_length_262_cov_0.906103_g55576_i0	PRJDB4470	56731	262	0.906103	2.37398986	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g55576	i0	96.875	0.255725190839695	32	1	12	0	33	64	2338543	2338574	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	67	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22961100	22961100	PRJDB4470_P_NODE_118959_length_163_cov_0.912281_g117804_i0	PRJDB4470	118959	163	0.912281	1.48701803	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	78.7	2.24e-10	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g117804	i0	76.506	39.4662576687117	166	25	100	11	1	163	53	207	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	6433	78.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22961676	22961676	PRJDB4470_P_NODE_68639_length_224_cov_1.485714_g67484_i0	PRJDB4470	68639	224	1.485714	3.32799936	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	353	4.87e-93	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g67484	i0	95.089	103.9375	224	11	100	0	1	224	4649714	4649491	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	23282	353	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
24235560	24235560	PRJDB4470_P_NODE_65900_length_231_cov_2.587912_g64745_i0	PRJDB4470	65900	231	2.587912	5.97807672	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	329	8.51e-86	NTclustered	gi\|2874253852\|emb\|OY969908.1\|	194844	g64745	i0	94.037	100.532467532468	218	11	94	2	15	231	2169279	2169495	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1	blastn	23223	329	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae 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);;