metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1115053" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1115053" and tax_phylum = "Thermodesulfobacteriota"

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
27406973	27406973	PRJNA1115053_S_NODE_329763_length_154_cov_1.297297_g327946_i0	PRJNA1115053	329763	154	1.297297	1.99783738	Desulfovibrio	872	Bacteria	Bacteria	63.5	5.05e-10	NR	WP_027174739.1	872	g327946	i0	52.8	5.16233766233766	53	23	99.4	1	154	2	362	414	WP_027174739.1 MULTISPECIES: aminopeptidase [Desulfovibrio]	diamond	795	63.9	0.993740219092332	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio
27691253	27691253	PRJNA1115053_S_NODE_172084_length_207_cov_1.402439_g170267_i0	PRJNA1115053	172084	207	1.402439	2.90304873	Syntrophobacter	29526	Bacteria	Bacteria	65.5	2.15e-10	NR	WP_041439928.1	119484	g170267	i0	41.8	1.94202898550725	67	37	97.1	1	2	202	333	397	WP_041439928.1 hypothetical protein [Syntrophobacter fumaroxidans]	diamond	402	65.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	Syntrophobacter fumaroxidans
30352923	30352923	PRJNA1115053_S_NODE_171132_length_207_cov_2.493902_g169315_i0	PRJNA1115053	171132	207	2.493902	5.16237714	Syntrophobacteraceae bacterium	2052185	Bacteria	Bacteria	44.3	0.00418	NR	MDR3556630.1	2052185	g169315	i0	40.5	0.536231884057971	37	22	53.6	0	63	173	111	147	MDR3556630.1 ubiquinol-cytochrome c reductase iron-sulfur subunit [Syntrophobacteraceae bacterium]	diamond	111	44.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae		Syntrophobacteraceae bacterium
31300344	31300344	PRJNA1115053_S_NODE_349235_length_151_cov_1.333333_g347418_i0	PRJNA1115053	349235	151	1.333333	2.01333283	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	40.8	0.0497	NR	MEJ2158404.1	2049433	g347418	i0	38.5	0.774834437086093	39	24	77.5	0	15	131	57	95	MEJ2158404.1 uroporphyrinogen decarboxylase family protein [Desulfobacteraceae bacterium]	diamond	117	40.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
32754697	32754697	PRJNA1115053_S_NODE_179020_length_203_cov_2.700000_g177203_i0	PRJNA1115053	179020	203	2.7	5.481	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	42.7	0.0224	NR	MEX1346713.1	2044940	g177203	i0	48.8	0.635467980295567	43	20	60.6	1	35	157	333	375	MEX1346713.1 PilC/PilY family type IV pilus protein [Desulfobacterales bacterium]	diamond	129	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales 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);;