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

5 rows where analysis = "diamond", bioproject = "PRJNA1057075" and tax_kingdom = "Bacillati"

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
21853447	21853447	PRJNA1057075_S_NODE_298_length_481_cov_311.337963_g229_i0	PRJNA1057075	298	481	311.337963	1497.53560203	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	192	6.609999999999999e-60	NR	MCP3885490.1	2021380	g229	i0	73.6	0.77962577962578	125	33	78	0	478	104	27	151	MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium]	diamond	375	192	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
27414877	27414877	PRJNA1057075_S_NODE_9723_length_159_cov_2.872727_g9624_i0	PRJNA1057075	9723	159	2.872727	4.56763593	Anaerolineales bacterium	2073117	Bacteria	Bacteria	42.4	0.0158	NR	HEY3310137.1	2073117	g9624	i0	52.5	3	40	18	73.6	1	33	149	25	64	HEY3310137.1 PxKF domain-containing protein [Anaerolineales bacterium]	diamond	477	42.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29845788	29845788	PRJNA1057075_S_NODE_8991_length_164_cov_0.869565_g8892_i0	PRJNA1057075	8991	164	0.869565	1.4260866	Anaerolineae bacterium	2052143	Bacteria	Bacteria	41.2	0.0452	NR	MBN1262623.1	2052143	g8892	i0	43.1	0.932926829268293	51	21	82.3	2	157	23	346	394	MBN1262623.1 MFS transporter [Anaerolineae bacterium]	diamond	153	41.2	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30572242	30572242	PRJNA1057075_S_NODE_2593_length_261_cov_71.367925_g2494_i0	PRJNA1057075	2593	261	71.367925	186.27028425	Streptomyces griseorubens	66897	Bacteria	Bacteria	42.7	0.0399	NR	KEG43447.1	66897	g2494	i0	86.4	0.252873563218391	22	3	25.3	0	68	3	175	196	KEG43447.1 peptidase [Streptomyces griseorubens]	diamond	66	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces griseorubens
31955257	31955257	PRJNA1057075_S_NODE_6997_length_178_cov_0.689922_g6898_i0	PRJNA1057075	6997	178	0.689922	1.22806116	Bacteria	2	Bacteria	Bacteria	41.6	0.0408	NR	PJB61401.1	1973914	g6898	i0	39.1	2.32584269662921	46	28	77.5	0	2	139	19	64	PJB61401.1 MAG: hypothetical protein CO096_28990 [Armatimonadetes bacterium CG_4_9_14_3_um_filter_66_14]	diamond	414	41.6	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium CG_4_9_14_3_um_filter_66_14

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