metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA758770" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA758770" 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
7119449	7119449	PRJNA758770_S_NODE_26686_length_249_cov_0.886364_g26560_i0	PRJNA758770	26686	249	0.886364	2.20704636	Microbacterium sp. 4NA327F11	2502229	Bacteria	Bacteria	120	1.49e-32	NR	WP_137878045.1	2502229	g26560	i0	100	0.72289156626506	60	0	72.3	0	248	69	93	152	WP_137878045.1 type II 3-dehydroquinate dehydratase [Microbacterium sp. 4NA327F11]	diamond	180	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. 4NA327F11
14769593	14769593	PRJNA758770_S_NODE_28492_length_247_cov_0.896552_g28366_i0	PRJNA758770	28492	247	0.896552	2.21448344	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	143	3.38e-39	NR	MFN8103146.1	2080302	g28366	i0	82.9	0.995951417004049	82	14	99.6	0	1	246	183	264	MFN8103146.1 fumarylacetoacetate hydrolase family protein [Acidimicrobiia bacterium]	diamond	246	143	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
23693617	23693617	PRJNA758770_S_NODE_26259_length_250_cov_0.881356_g26133_i0	PRJNA758770	26259	250	0.881356	2.20339	Austwickia sp.	1872664	Bacteria	Bacteria	161	3.1799999999999998e-46	NR	MBK7721467.1	1872664	g26133	i0	96.4	0.996	83	3	99.6	0	249	1	239	321	MBK7721467.1 undecaprenyl/decaprenyl-phosphate alpha-N-acetylglucosaminyl 1-phosphate transferase [Austwickia sp.]	diamond	249	161	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae	Austwickia	Austwickia sp.
26736166	26736166	PRJNA758770_S_NODE_31201_length_244_cov_0.912281_g31075_i0	PRJNA758770	31201	244	0.912281	2.22596564	Kineosporiaceae bacterium	2487580	Bacteria	Bacteria	88.6	8.63e-19	NR	MBL8930629.1	2487580	g31075	i0	97.8	0.565573770491803	46	1	56.6	0	140	3	1	46	MBL8930629.1 ATP-binding cassette domain-containing protein [Kineosporiaceae bacterium]	diamond	138	88.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kineosporiales	Kineosporiaceae		Kineosporiaceae bacterium
28000870	28000870	PRJNA758770_S_NODE_30505_length_244_cov_1.619883_g30379_i0	PRJNA758770	30505	244	1.619883	3.95251452	Streptomyces flaveolus	67297	Bacteria	Bacteria	41.2	0.0455	NR	WP_350722076.1	67297	g30379	i0	34.2	0.971311475409836	79	34	75	2	6	188	7	85	WP_350722076.1 LGFP repeat-containing protein [Streptomyces flaveolus]	diamond	237	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces flaveolus
28316453	28316453	PRJNA758770_S_NODE_25186_length_251_cov_0.876404_g25060_i0	PRJNA758770	25186	251	0.876404	2.19977404	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	59.7	2.64e-8	NR	HEV2754138.1	2586742	g25060	i0	37.2	0.932270916334661	78	49	93.2	0	12	245	77	154	HEV2754138.1 hypothetical protein [Solirubrobacteraceae bacterium]	diamond	234	59.7	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
28379533	28379533	PRJNA758770_S_NODE_27906_length_248_cov_0.891429_g27780_i0	PRJNA758770	27906	248	0.891429	2.21074392	Mycolicibacterium hodleri	49897	Bacteria	Bacteria	110	6.440000000000001e-27	NR	WP_140691945.1	49897	g27780	i0	69	0.858870967741935	71	22	85.9	0	34	246	101	171	WP_140691945.1 tyrosinase family protein [Mycolicibacterium hodleri]	diamond	213	110	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium hodleri
28600683	28600683	PRJNA758770_S_NODE_29547_length_246_cov_0.901734_g29421_i0	PRJNA758770	29547	246	0.901734	2.21826564	Brevibacterium ravenspurgense	479117	Bacteria	Bacteria	157	1.71e-42	NR	WP_244878092.1	479117	g29421	i0	98.8	0.98780487804878	81	1	98.8	0	3	245	664	744	WP_244878092.1 DNA gyrase/topoisomerase IV subunit A [Brevibacterium ravenspurgense]	diamond	243	157	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium ravenspurgense
28916054	28916054	PRJNA758770_S_NODE_31208_length_244_cov_0.912281_g31082_i0	PRJNA758770	31208	244	0.912281	2.22596564	Planotetraspora kaengkrachanensis	575193	Bacteria	Bacteria	58.5	9.9e-8	NR	WP_203880655.1	575193	g31082	i0	63	1.25409836065574	46	17	56.6	0	235	98	325	370	WP_203880655.1 glycosyltransferase family 4 protein [Planotetraspora kaengkrachanensis]	diamond	306	58.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Planotetraspora	Planotetraspora kaengkrachanensis
29579099	29579099	PRJNA758770_S_NODE_31610_length_243_cov_0.917647_g31484_i0	PRJNA758770	31610	243	0.917647	2.22988221	Pengzhenrongella sp.	2888820	Bacteria	Bacteria	77.8	6.94e-17	NR	HEY5516400.1	2888820	g31484	i0	69	1.2962962962963	58	16	71.6	1	180	7	2	57	HEY5516400.1 hypothetical protein [Pengzhenrongella sp.]	diamond	315	77.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales		Pengzhenrongella	Pengzhenrongella sp.
31728107	31728107	PRJNA758770_S_NODE_15437_length_301_cov_0.960526_g15311_i0	PRJNA758770	15437	301	0.960526	2.89118326	Nocardioides sp.	35761	Bacteria	Bacteria	43.1	0.0169	NR	WP_331527776.1	35761	g15311	i0	33.3	0.687707641196013	69	33	60.8	2	92	274	9	72	WP_331527776.1 LPXTG cell wall anchor domain-containing protein [Nocardioides sp.]	diamond	207	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp.
31886310	31886310	PRJNA758770_S_NODE_24317_length_252_cov_0.871508_g24191_i0	PRJNA758770	24317	252	0.871508	2.19620016	Actinomycetales bacterium	1911520	Bacteria	Bacteria	173	4.5e-50	NR	NLE72998.1	1911520	g24191	i0	100	1	84	0	100	0	1	252	59	142	NLE72998.1 GGDEF domain-containing protein [Actinomycetales bacterium]	diamond	252	173	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales			Actinomycetales bacterium
31896048	31896048	PRJNA758770_S_NODE_30737_length_244_cov_0.912281_g30611_i0	PRJNA758770	30737	244	0.912281	2.22596564	Bacillati	1783272	Bacteria	Bacteria	127	2.53e-34	NR	HEY5844433.1	1785	g30611	i0	77.8	22.905737704918	81	18	99.6	0	243	1	158	238	HEY5844433.1 3-oxoacyl-ACP reductase family protein [Mycobacterium sp.]	diamond	5589	127	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
32139562	32139562	PRJNA758770_S_NODE_24118_length_252_cov_0.871508_g23992_i0	PRJNA758770	24118	252	0.871508	2.19620016	Actinoplanes sp. OR16	946334	Bacteria	Bacteria	55.8	8.87e-7	NR	WP_232050000.1	946334	g23992	i0	62.5	0.785714285714286	40	15	47.6	0	131	250	1	40	WP_232050000.1 GlxA family transcriptional regulator [Actinoplanes sp. OR16]	diamond	198	55.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Actinoplanes	Actinoplanes sp. OR16

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