metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA371613" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA371613" and tax_phylum = "Actinomycetota"

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
27801552	27801552	PRJNA371613_P_NODE_6264_length_184_cov_3.285714_g6088_i0	PRJNA371613	6264	184	3.285714	6.04571376	Corynebacterium macclintockiae	2913501	Bacteria	Bacteria	82	2.44e-16	NR	WP_284819838.1	2913501	g6088	i0	62.3	0.994565217391304	61	23	99.5	0	2	184	511	571	WP_284819838.1 AAA family ATPase [Corynebacterium macclintockiae]	diamond	183	82	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium macclintockiae
28053896	28053896	PRJNA371613_P_NODE_5265_length_207_cov_1.052941_g5089_i0	PRJNA371613	5265	207	1.052941	2.17958787	Gordonia prachuapensis	3115651	Bacteria	Bacteria	42.4	0.0317	NR	WP_330503865.1	3115651	g5089	i0	34.3	1.01449275362319	70	29	76.8	2	207	49	191	260	WP_330503865.1 serine/threonine dehydratase [Gordonia prachuapensis]	diamond	210	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia prachuapensis
28274918	28274918	PRJNA371613_P_NODE_7766_length_169_cov_0.969697_g7590_i0	PRJNA371613	7766	169	0.969697	1.63878793	Actinomycetota bacterium	2900548	Bacteria	Bacteria	91.3	7.720000000000001e-21	NR	MEW6635680.1	2900548	g7590	i0	73.2	1.98816568047337	56	15	99.4	0	169	2	163	218	MEW6635680.1 type I-C CRISPR-associated protein Cas5c [Actinomycetota bacterium]	diamond	336	91.3	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
28906297	28906297	PRJNA371613_P_NODE_8168_length_167_cov_0.984615_g7992_i0	PRJNA371613	8168	167	0.984615	1.64430705	Actinomycetota bacterium	2900548	Bacteria	Bacteria	45.8	0.00103	NR	MSV94700.1	2900548	g7992	i0	96	0.916167664670659	25	1	44.9	0	91	165	1	25	MSV94700.1 SDR family NAD(P)-dependent oxidoreductase [Actinomycetota bacterium]	diamond	153	45.8	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
29790366	29790366	PRJNA371613_P_NODE_7731_length_169_cov_0.969697_g7555_i0	PRJNA371613	7731	169	0.969697	1.63878793	Cutibacterium acnes	1747	Bacteria	Bacteria	117	5.51e-31	NR	WP_138223578.1	1747	g7555	i0	91.1	0.994082840236686	56	5	99.4	0	168	1	70	125	WP_138223578.1 HNH endonuclease family protein [Cutibacterium acnes]	diamond	168	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
30706706	30706706	PRJNA371613_P_NODE_5834_length_192_cov_1.258065_g5658_i0	PRJNA371613	5834	192	1.258065	2.4154848	Actinomadura rudentiformis	359158	Bacteria	Bacteria	42.4	0.0241	NR	WP_151569518.1	359158	g5658	i0	41.5	0.640625	41	22	60.9	1	29	145	164	204	WP_151569518.1 PQQ-binding-like beta-propeller repeat protein [Actinomadura rudentiformis]	diamond	123	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura rudentiformis
30770109	30770109	PRJNA371613_P_NODE_8794_length_164_cov_1.007874_g8618_i0	PRJNA371613	8794	164	1.007874	1.65291336	Dietzia cercidiphylli	498199	Bacteria	Bacteria	115	1.03e-29	NR	WP_338404243.1	498199	g8618	i0	98.1	0.98780487804878	54	1	98.8	0	3	164	15	68	WP_338404243.1 biliverdin-producing heme oxygenase [Dietzia cercidiphylli]	diamond	162	115	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia	Dietzia cercidiphylli
31433642	31433642	PRJNA371613_P_NODE_9216_length_162_cov_1.024000_g9040_i0	PRJNA371613	9216	162	1.024	1.65888	Corynebacterium casei	160386	Bacteria	Bacteria	89.4	4.58e-21	NR	MDN5784609.1	160386	g9040	i0	94.3	1.96296296296296	53	3	98.1	0	3	161	90	142	MDN5784609.1 helix-hairpin-helix domain-containing protein [Corynebacterium casei]	diamond	318	89.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium casei
31830195	31830195	PRJNA371613_P_NODE_7917_length_168_cov_0.977099_g7741_i0	PRJNA371613	7917	168	0.977099	1.64152632	Acidimicrobiales	84993	Bacteria	Bacteria	59.7	6.39e-9	NR	KRO42972.1	1655566	g7741	i0	100	1.55357142857143	29	0	51.8	0	167	81	189	217	KRO42972.1 MAG: hypothetical protein ABR58_06590 [Acidimicrobium sp. BACL19 MAG-120924-bin39]	diamond	261	59.7	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Acidimicrobiaceae	Acidimicrobium	Acidimicrobium sp. BACL19 MAG-120924-bin39
32855904	32855904	PRJNA371613_P_NODE_6560_length_179_cov_1.626761_g6384_i0	PRJNA371613	6560	179	1.626761	2.91190219	unclassified Dietzia	2617939	Bacteria	Bacteria	124	5.05e-34	NR	WP_069388984.1	2617939	g6384	i0	100	0.988826815642458	59	0	98.9	0	3	179	17	75	WP_069388984.1 MULTISPECIES: hypothetical protein [unclassified Dietzia]	diamond	177	124	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia

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