metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA1126661" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA1126661" 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
15585268	15585268	PRJNA1126661_P_NODE_33433_length_301_cov_9.508772_g32904_i0	PRJNA1126661	33433	301	9.508772	28.62140372	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	134	9.72e-27	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g32904	i0	92.632	1.56146179401993	95	4	31	2	7	98	1960649	1960743	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	470	134	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20683648	20683648	PRJNA1126661_P_NODE_20937_length_326_cov_3.762846_g20408_i0	PRJNA1126661	20937	326	3.762846	12.26687796	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	224	6.139999999999998e-54	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g20408	i0	93.377	1.83128834355828	151	10	93	0	1	151	2618578	2618728	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	597	224	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
21959211	21959211	PRJNA1126661_P_NODE_38778_length_301_cov_3.877193_g38249_i0	PRJNA1126661	38778	301	3.877193	11.67035093	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	207	5.65e-49	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g38249	i0	91.391	1.99003322259136	151	13	94	0	1	151	1645216	1645066	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	599	207	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
25257366	25257366	PRJNA1126661_P_NODE_50400_length_295_cov_6.004505_g49871_i0	PRJNA1126661	50400	295	6.004505	17.71328975	Bacteria	2	Bacteria	Bacteria	100	9.64e-17	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g49871	i0	74.342	36.1186440677966	304	47	96	23	2	283	3221891	3222185	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	10655	100	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales 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);;