metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA383995" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA383995" and tax_phylum = "Bacillota"

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
6782968	6782968	PRJNA383995_P_NODE_17706_length_163_cov_0.894737_g17607_i0	PRJNA383995	17706	163	0.894737	1.45842131	Streptococcus thermophilus	1308	Bacteria	Bacteria	112	5.08e-27	NR	TKW62483.1	1308	g17607	i0	100	1.98773006134969	54	0	99.4	0	1	162	550	603	TKW62483.1 MAG: hypothetical protein DI612_08705, partial [Streptococcus thermophilus]	diamond	324	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
27137919	27137919	PRJNA383995_P_NODE_16622_length_165_cov_0.879310_g16523_i0	PRJNA383995	16622	165	0.87931	1.4508615	Levyella massiliensis	938289	Bacteria	Bacteria	112	2.9e-28	NR	WP_019190309.1	938289	g16523	i0	96.3	0.981818181818182	54	2	98.2	0	3	164	116	169	WP_019190309.1 MaoC/PaaZ C-terminal domain-containing protein [Levyella massiliensis]	diamond	162	112	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Levyella	Levyella massiliensis
28085782	28085782	PRJNA383995_P_NODE_17645_length_163_cov_0.894737_g17546_i0	PRJNA383995	17645	163	0.894737	1.45842131	Mediannikoviicoccus vaginalis	2899727	Bacteria	Bacteria	92.4	3.82e-20	NR	WP_237036350.1	2899727	g17546	i0	92.5	0.975460122699387	53	4	97.5	0	3	161	801	853	WP_237036350.1 DNA mismatch repair protein MutS [Mediannikoviicoccus vaginalis]	diamond	159	92.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Mediannikoviicoccus	Mediannikoviicoccus vaginalis
28686007	28686007	PRJNA383995_P_NODE_16987_length_164_cov_0.939130_g16888_i0	PRJNA383995	16987	164	0.93913	1.5401732	Clostridiales bacterium	1898207	Bacteria	Bacteria	43.1	0.00941	NR	NLE68665.1	1898207	g16888	i0	51.4	0.676829268292683	37	15	67.7	1	3	113	97	130	NLE68665.1 hypothetical protein [Clostridiales bacterium]	diamond	111	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
30282037	30282037	PRJNA383995_P_NODE_17892_length_163_cov_0.894737_g17793_i0	PRJNA383995	17892	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	106	7.45e-28	NR	MBN9993869.1	1639	g17793	i0	100	3.97546012269939	54	0	99.4	0	163	2	28	81	MBN9993869.1 hypothetical protein [Listeria monocytogenes]	diamond	648	106	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
30439808	30439808	PRJNA383995_P_NODE_18373_length_162_cov_0.902655_g18274_i0	PRJNA383995	18373	162	0.902655	1.4623011	Peptoniphilus	162289	Bacteria	Bacteria	109	7e-27	NR	WP_316714872.1	1175452	g18274	i0	100	1.96296296296296	53	0	98.1	0	3	161	305	357	WP_316714872.1 Na+/H+ antiporter NhaC family protein, partial [Peptoniphilus rhinitidis]	diamond	318	109	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus rhinitidis

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