metadata: contig_metadata: 5 rows where bioproject = "PRJDB12134", tax_phylum = "Acidobacteriota" and tax

5 rows where bioproject = "PRJDB12134", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

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_species
14028082	14028082	PRJDB12134_P_NODE_13952_length_244_cov_0.912281_g13817_i0	PRJDB12134	13952	244	0.912281	2.22596564	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	58.4	4.73e-4	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g13817	i0	100	1.86475409836066	31	0	15	0	25	55	2469284	2469254	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	455	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
15302162	15302162	PRJDB12134_P_NODE_13473_length_247_cov_0.890805_g13338_i0	PRJDB12134	13473	247	0.890805	2.20028835	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	257	4.41e-64	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g13338	i0	86.134	29.3198380566802	238	33	96	0	10	247	2559665	2559902	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	7242	257	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
24225844	24225844	PRJDB12134_P_NODE_10600_length_280_cov_1.256039_g10465_i0	PRJDB12134	10600	280	1.256039	3.5169092	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	505	1.65e-138	NTclustered	gi\|112980873\|gb\|DQ829677.1\|	171953	g10465	i0	99.286	370.785714285714	280	1	100	1	1	280	1174	1452	Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence	blastn	103820	505	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
29400770	29400770	PRJDB12134_P_NODE_10969_length_274_cov_1.552239_g10834_i0	PRJDB12134	10969	274	1.552239	4.25313486	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	141	1.91e-37	NR	HEU4693445.1	2910147	g10834	i0	75.8	2.98905109489051	91	22	99.6	0	2	274	23	113	HEU4693445.1 thymidine phosphorylase family protein [Vicinamibacterales bacterium]	diamond	819	141	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales bacterium
31865420	31865420	PRJDB12134_P_NODE_13277_length_248_cov_0.885714_g13142_i0	PRJDB12134	13277	248	0.885714	2.19657072	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	68.2	4.24e-12	NR	HYJ92050.1	2283092	g13142	i0	45.8	0.870967741935484	72	39	87.1	0	240	25	84	155	HYJ92050.1 type VI secretion system tube protein Hcp [Pyrinomonadaceae bacterium]	diamond	216	68.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae 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);;