metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax

5 rows where analysis = "blastn", bioproject = "PRJEB10140" 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
2562339	2562339	PRJEB10140_P_NODE_252343_length_168_cov_0.873950_g235034_i0	PRJEB10140	252343	168	0.87395	1.468236	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	167	4.83e-37	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g235034	i0	92.982	1.38095238095238	114	8	68	0	1	114	3433449	3433336	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	232	167	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4810251	4810251	PRJEB10140_P_NODE_278604_length_164_cov_0.886957_g261295_i0	PRJEB10140	278604	164	0.886957	1.45460948	Granulicella	940557	Bacteria	Bacteria	143	7.9e-30	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g261295	i0	83.436	80.109756097561	163	17	96	10	7	164	1212457	1212300	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	13138	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
10215187	10215187	PRJEB10140_P_NODE_248109_length_169_cov_0.866667_g230800_i0	PRJEB10140	248109	169	0.866667	1.46466723	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	154	3.76e-33	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g230800	i0	86.429	0.828402366863905	140	19	83	0	6	145	1898272	1898411	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	140	154	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
11490694	11490694	PRJEB10140_P_NODE_270450_length_165_cov_0.896552_g253141_i0	PRJEB10140	270450	165	0.896552	1.4793108	Geothrix sp. 21YS21S-4	3068889	Bacteria	Bacteria	119	1.34e-22	NTclustered	gi\|2565867660\|gb\|CP132719.1\|	3068889	g253141	i0	84.298	37.0606060606061	121	19	73	0	20	140	1654021	1654141	Geothrix sp. 21YS21S-4 chromosome, complete genome	blastn	6115	119	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-4
22964571	22964571	PRJEB10140_P_NODE_268739_length_165_cov_0.896552_g251430_i0	PRJEB10140	268739	165	0.896552	1.4793108	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	84.2	4.89e-12	NTclustered	gi\|2874253721\|emb\|OY969563.1\|	2952895	g251430	i0	93.103	0.351515151515152	58	2	35	2	106	162	6929543	6929599	MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1	blastn	58	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales 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);;