metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA757618" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA757618" 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
2008326	2008326	PRJNA757618_P_NODE_17382_length_288_cov_1.451163_g16330_i0	PRJNA757618	17382	288	1.451163	4.17934944	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	486	6.159999999999999e-133	NTclustered	gi\|76574296\|gb\|DQ139444.1\|	171953	g16330	i0	97.213	99.3402777777778	287	8	99	0	1	287	768	1054	Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence	blastn	28610	486	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2008684	2008684	PRJNA757618_P_NODE_39642_length_246_cov_0.895954_g38590_i0	PRJNA757618	39642	246	0.895954	2.20404684	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	313	9.23e-81	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g38590	i0	90.083	0.983739837398374	242	22	98	2	3	243	662262	662502	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	242	313	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10936564	10936564	PRJNA757618_P_NODE_27289_length_253_cov_0.866667_g26237_i0	PRJNA757618	27289	253	0.866667	2.19266751	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	198	2.7899999999999998e-46	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g26237	i0	81.25	1.01185770750988	256	39	100	8	1	253	3139969	3139720	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	256	198	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
10936918	10936918	PRJNA757618_P_NODE_7989_length_399_cov_1.852761_g6937_i0	PRJNA757618	7989	399	1.852761	7.39251639	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	590	6.55e-164	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g6937	i0	94.517	144.25313283208	383	19	96	2	18	399	2367320	2367701	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	57557	590	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13486183	13486183	PRJNA757618_P_NODE_22891_length_265_cov_1.572917_g21839_i0	PRJNA757618	22891	265	1.572917	4.16823005	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	148	3.0000000000000003e-31	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g21839	i0	79.524	0.792452830188679	210	41	79	2	51	259	1489711	1489919	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	210	148	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21135132	21135132	PRJNA757618_P_NODE_34237_length_249_cov_0.875000_g33185_i0	PRJNA757618	34237	249	0.875	2.17875	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	344	3.32e-90	NTclustered	gi\|2626289183\|emb\|OY843586.1\|	2052142	g33185	i0	91.633	1.00803212851406	251	18	100	3	1	249	1227559	1227808	MAG: Acidobacteriaceae bacterium isolate 6f8c9a11-1c30-45b4-a4a5-28695f68a2e2 genome assembly, chromosome: 1	blastn	251	344	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
24959351	24959351	PRJNA757618_P_NODE_48160_length_242_cov_0.917160_g47108_i0	PRJNA757618	48160	242	0.91716	2.2195272	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	355	1.48e-93	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g47108	i0	93.333	41.4380165289256	240	16	99	0	1	240	2895266	2895027	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	10028	355	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22

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