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

5 rows where analysis = "blastn", bioproject = "PRJNA674050" 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
3718004	3718004	PRJNA674050_P_NODE_16683_length_269_cov_2.576531_g16480_i0	PRJNA674050	16683	269	2.576531	6.93086839	Bacteria	2	Bacteria	Bacteria	241	4.900000000000001e-59	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g16480	i0	83.273	174.28624535316	275	33	100	8	1	269	887088	887355	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	46883	241	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4471189	4471189	PRJNA674050_P_NODE_10704_length_295_cov_2.072072_g10501_i0	PRJNA674050	10704	295	2.072072	6.1126124	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	418	2.3399999999999992e-112	NTclustered	gi\|76574296\|gb\|DQ139444.1\|	171953	g10501	i0	92.759	162.233898305085	290	19	98	2	1	289	31	319	Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence	blastn	47859	418	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9572331	9572331	PRJNA674050_P_NODE_27148_length_249_cov_0.886364_g26945_i0	PRJNA674050	27148	249	0.886364	2.20704636	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	289	1.58e-73	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g26945	i0	87.649	74.3574297188755	251	27	100	4	1	249	283797	284045	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	18515	289	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
17221808	17221808	PRJNA674050_P_NODE_25074_length_250_cov_3.745763_g24871_i0	PRJNA674050	25074	250	3.745763	9.3644075	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	372	1.53e-98	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g24871	i0	93.6	281.684	250	14	99	2	2	250	10561	10313	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	70421	372	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21045893	21045893	PRJNA674050_P_NODE_1437_length_559_cov_3.539095_g1239_i0	PRJNA674050	1437	559	3.539095	19.78354105	Thermoanaerobaculum sp.	2510637	Bacteria	Bacteria	329	2.2699999999999996e-85	NTclustered	gi\|2314712957\|dbj\|AP024672.1\|	2510637	g1239	i0	78.014	192.34168157424	564	97	98	23	10	559	1172396	1171846	MAG: Thermoanaerobaculum sp. KatS3mg007 DNA, complete genome	blastn	107519	329	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae	Thermoanaerobaculum	Thermoanaerobaculum sp.

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