metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJEB55122" and tax

26 rows where analysis = "diamond", bioproject = "PRJEB55122" 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
23073258	23073258	PRJEB55122_P_NODE_37939_length_168_cov_0.873950_g37542_i0	PRJEB55122	37939	168	0.87395	1.468236	Luteococcus sp.	1969402	Bacteria	Bacteria	110	6.5e-28	NR	WP_394277340.1	1969402	g37542	i0	94.6	1	56	3	100	0	168	1	174	229	WP_394277340.1 neutral zinc metallopeptidase [Luteococcus sp.]	diamond	168	110	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Luteococcus	Luteococcus sp.
26716618	26716618	PRJEB55122_P_NODE_22321_length_231_cov_1.142857_g21924_i0	PRJEB55122	22321	231	1.142857	2.63999967	Streptomyces sp. HSW2	1931	Bacteria	Bacteria	42.7	0.0123	NR	WP_349997640.1	3142890	g21924	i0	42	0.896103896103896	69	35	87	2	9	209	57	122	WP_349997640.1 hypothetical protein [Streptomyces sp. HSW2009]	diamond	207	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. HSW2009
27033524	27033524	PRJEB55122_P_NODE_28902_length_196_cov_1.578231_g28505_i0	PRJEB55122	28902	196	1.578231	3.09333276	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	42.4	0.028	NR	HMG40725.1	2201156	g28505	i0	47.5	0.903061224489796	59	24	81.1	3	189	31	350	407	HMG40725.1 hypothetical protein [Acidimicrobiales bacterium]	diamond	177	42.4	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
27690626	27690626	PRJEB55122_P_NODE_35264_length_173_cov_1.266129_g34867_i0	PRJEB55122	35264	173	1.266129	2.19040317	Dermatophilaceae	85018	Bacteria	Bacteria	71.2	2.72e-13	NR	WP_028326812.1	1863	g34867	i0	67.3	1.80346820809249	49	16	85	0	171	25	24	72	WP_028326812.1 TetR/AcrR family transcriptional regulator [Dermatophilus congolensis]	diamond	312	71.6	0.994413407821229	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae	Dermatophilus	Dermatophilus congolensis
27697381	27697381	PRJEB55122_P_NODE_37164_length_169_cov_0.866667_g36767_i0	PRJEB55122	37164	169	0.866667	1.46466723	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	41.2	0.0467	NR	WP_352195973.1	3157228	g36767	i0	44.4	0.63905325443787	36	20	63.9	0	12	119	235	270	WP_352195973.1 glycosyltransferase family 1 protein [Streptomyces sp. NPDC097619]	diamond	108	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC097619
27760456	27760456	PRJEB55122_P_NODE_37944_length_168_cov_0.873950_g37547_i0	PRJEB55122	37944	168	0.87395	1.468236	Rhodococcoides fascians	1828	Bacteria	Bacteria	114	1.71e-28	NR	WP_032371897.1	1828	g37547	i0	98.2	0.982142857142857	55	1	98.2	0	166	2	336	390	WP_032371897.1 tyrosine-type recombinase/integrase [Rhodococcoides fascians]	diamond	165	114	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
28549697	28549697	PRJEB55122_P_NODE_40367_length_165_cov_0.896552_g39970_i0	PRJEB55122	40367	165	0.896552	1.4793108	Microbacterium sp. oral taxon 186	712383	Bacteria	Bacteria	85.9	3.17e-18	NR	WP_005048760.1	712383	g39970	i0	100	0.8	44	0	80	0	2	133	285	328	WP_005048760.1 aldo/keto reductase [Microbacterium sp. oral taxon 186]	diamond	132	85.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. oral taxon 186
28581184	28581184	PRJEB55122_P_NODE_41807_length_164_cov_0.904348_g41410_i0	PRJEB55122	41807	164	0.904348	1.48313072	Cutibacterium avidum	33010	Bacteria	Bacteria	47.4	2.98e-4	NR	MDU3749855.1	33010	g41410	i0	42	3.65853658536585	50	29	91.5	0	164	15	375	424	MDU3749855.1 TraM recognition domain-containing protein [Cutibacterium avidum]	diamond	600	47.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium avidum
28889969	28889969	PRJEB55122_P_NODE_42268_length_163_cov_0.912281_g41871_i0	PRJEB55122	42268	163	0.912281	1.48701803	Corynebacterium	1716	Bacteria	Bacteria	102	3.58e-24	NR	WP_005388495.1	39791	g41871	i0	94.4	2.98159509202454	54	3	99.4	0	2	163	250	303	WP_005388495.1 YibE/F family protein [Corynebacterium glucuronolyticum]	diamond	486	102	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium glucuronolyticum
28896693	28896693	PRJEB55122_P_NODE_38428_length_167_cov_0.881356_g38031_i0	PRJEB55122	38428	167	0.881356	1.47186452	Leifsonia sp. TF	1870902	Bacteria	Bacteria	120	9.4e-31	NR	WP_208040083.1	2815212	g38031	i0	100	0.988023952095808	55	0	98.8	0	165	1	218	272	WP_208040083.1 glycosyltransferase family 4 protein [Leifsonia sp. TF02-11]	diamond	165	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. TF02-11
29086398	29086398	PRJEB55122_P_NODE_40588_length_165_cov_0.896552_g40191_i0	PRJEB55122	40588	165	0.896552	1.4793108	Luteococcus sp.	1969402	Bacteria	Bacteria	110	9.21e-27	NR	WP_394275493.1	1969402	g40191	i0	98.1	0.981818181818182	54	1	98.2	0	2	163	126	179	WP_394275493.1 sugar transferase [Luteococcus sp.]	diamond	162	110	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Luteococcus	Luteococcus sp.
29591068	29591068	PRJEB55122_P_NODE_40510_length_165_cov_0.896552_g40113_i0	PRJEB55122	40510	165	0.896552	1.4793108	Bifidobacteriaceae bacterium MCC	2291324	Bacteria	Bacteria	40	0.0236	NR	GDZ53054.1	2569517	g40113	i0	57.1	0.636363636363636	35	15	63.6	0	28	132	12	46	GDZ53054.1 hypothetical protein MCC02035_17470 [Bifidobacteriaceae bacterium MCC02035]	diamond	105	40	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae		Bifidobacteriaceae bacterium MCC02035
29622543	29622543	PRJEB55122_P_NODE_40310_length_165_cov_0.896552_g39913_i0	PRJEB55122	40310	165	0.896552	1.4793108	unclassified Luteococcus	2639923	Bacteria	Bacteria	93.6	9.25e-21	NR	WP_342090188.1	2639923	g39913	i0	77.8	1.96363636363636	54	12	98.2	0	163	2	176	229	WP_342090188.1 MULTISPECIES: glycoside hydrolase family 32 protein [unclassified Luteococcus]	diamond	324	93.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Luteococcus
29622544	29622544	PRJEB55122_P_NODE_42750_length_163_cov_0.912281_g42353_i0	PRJEB55122	42750	163	0.912281	1.48701803	Luteococcus sp.	1969402	Bacteria	Bacteria	58.5	2.7e-8	NR	WP_394277338.1	1969402	g42353	i0	100	0.496932515337423	27	0	49.7	0	154	74	1	27	WP_394277338.1 Bax inhibitor-1/YccA family membrane protein [Luteococcus sp.]	diamond	81	58.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Luteococcus	Luteococcus sp.
29970374	29970374	PRJEB55122_P_NODE_43991_length_159_cov_2.454545_g43594_i0	PRJEB55122	43991	159	2.454545	3.90272655	Streptomyces sp. A1499	2563104	Bacteria	Bacteria	43.1	0.00854	NR	THC52570.1	2563104	g43594	i0	60.6	0.622641509433962	33	12	62.3	1	113	15	28	59	THC52570.1 tryptophan synthase subunit alpha [Streptomyces sp. A1499]	diamond	99	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. A1499
30128073	30128073	PRJEB55122_P_NODE_43232_length_162_cov_0.920354_g42835_i0	PRJEB55122	43232	162	0.920354	1.49097348	Mobilicoccus caccae	1859295	Bacteria	Bacteria	90.1	2.46e-19	NR	WP_284305203.1	1859295	g42835	i0	79.2	0.981481481481482	53	11	98.1	0	160	2	284	336	WP_284305203.1 gamma-glutamyltransferase [Mobilicoccus caccae]	diamond	159	90.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae	Mobilicoccus	Mobilicoccus caccae
30570432	30570432	PRJEB55122_P_NODE_34813_length_174_cov_2.096000_g34416_i0	PRJEB55122	34813	174	2.096	3.64704	Streptomyces longispororuber	68230	Bacteria	Bacteria	41.6	0.00759	NR	WP_391884628.1	68230	g34416	i0	44.8	1	58	30	96.6	1	168	1	2	59	WP_391884628.1 hypothetical protein [Streptomyces longispororuber]	diamond	174	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces longispororuber
30570433	30570433	PRJEB55122_P_NODE_38193_length_167_cov_1.669492_g37796_i0	PRJEB55122	38193	167	1.669492	2.78805164	Lawsonella	1847725	Bacteria	Bacteria	114	1.46e-28	NR	WP_290595271.1	1847725	g37796	i0	100	0.988023952095808	55	0	98.8	0	3	167	155	209	WP_290595271.1 MULTISPECIES: bifunctional diaminohydroxyphosphoribosylaminopyrimidine deaminase/5-amino-6-(5-phosphoribosylamino)uracil reductase RibD [Lawsonella]	diamond	165	114	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
30665448	30665448	PRJEB55122_P_NODE_43293_length_162_cov_0.920354_g42896_i0	PRJEB55122	43293	162	0.920354	1.49097348	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	89	2.91e-19	NR	HEX2857889.1	2021380	g42896	i0	84.6	2.87037037037037	52	8	96.3	0	5	160	137	188	HEX2857889.1 polyprenyl synthetase family protein [Propionibacteriaceae bacterium]	diamond	465	89	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
31234046	31234046	PRJEB55122_P_NODE_39375_length_166_cov_0.888889_g38978_i0	PRJEB55122	39375	166	0.888889	1.47555574	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	67.4	7.88e-13	NR	HEX2495233.1	2838783	g38978	i0	84.6	0.704819277108434	39	6	70.5	0	166	50	60	98	HEX2495233.1 hypothetical protein [Gaiellaceae bacterium]	diamond	117	67.4	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae bacterium
31866651	31866651	PRJEB55122_P_NODE_30457_length_190_cov_1.475177_g30060_i0	PRJEB55122	30457	190	1.475177	2.8028363	Brachybacterium muris	219301	Bacteria	Bacteria	120	3.11e-32	NR	WP_237738762.1	219301	g30060	i0	100	0.994736842105263	63	0	99.5	0	189	1	130	192	WP_237738762.1 lysoplasmalogenase family protein [Brachybacterium muris]	diamond	189	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium muris
32056641	32056641	PRJEB55122_P_NODE_6398_length_559_cov_2.392157_g6013_i0	PRJEB55122	6398	559	2.392157	13.37215763	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	45.4	0.0366	NR	WP_390148821.1	3346311	g6013	i0	29	0.98211091234347	183	91	86.9	10	57	542	3	167	WP_390148821.1 sigma factor-like helix-turn-helix DNA-binding protein [Streptomyces sp. NPDC058045]	diamond	549	45.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC058045
32176683	32176683	PRJEB55122_P_NODE_43178_length_162_cov_0.920354_g42781_i0	PRJEB55122	43178	162	0.920354	1.49097348	Luteococcus	33983	Bacteria	Bacteria	102	1.65e-24	NR	WP_123576108.1	33984	g42781	i0	96.2	2.92592592592593	52	2	96.3	0	6	161	94	145	WP_123576108.1 GDP-L-fucose synthase family protein [Luteococcus japonicus]	diamond	474	103	0.990291262135922	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Luteococcus	Luteococcus japonicus
32246859	32246859	PRJEB55122_P_NODE_36618_length_169_cov_0.866667_g36221_i0	PRJEB55122	36618	169	0.866667	1.46466723	Agilicoccus flavus	2775968	Bacteria	Bacteria	60.8	4.7e-9	NR	WP_226345527.1	2775968	g36221	i0	76.7	0.763313609467456	43	10	76.3	0	168	40	264	306	WP_226345527.1 patatin-like phospholipase family protein [Agilicoccus flavus]	diamond	129	60.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae	Agilicoccus	Agilicoccus flavus
32341649	32341649	PRJEB55122_P_NODE_39019_length_166_cov_2.709402_g38622_i0	PRJEB55122	39019	166	2.709402	4.49760732	Catellatospora aurea	1337874	Bacteria	Bacteria	40.8	0.0407	NR	WP_376810015.1	1337874	g38622	i0	39.3	1.01204819277108	56	27	99.4	3	2	166	63	112	WP_376810015.1 hypothetical protein [Catellatospora aurea]	diamond	168	40.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Catellatospora	Catellatospora aurea
32625799	32625799	PRJEB55122_P_NODE_38580_length_167_cov_0.881356_g38183_i0	PRJEB55122	38580	167	0.881356	1.47186452	Micromonospora sp. NBC_	1876	Bacteria	Bacteria	42.7	0.0137	NR	WP_329105020.1	2975984	g38183	i0	51.4	0.62874251497006	35	17	62.9	0	48	152	1628	1662	WP_329105020.1 LamG-like jellyroll fold domain-containing protein [Micromonospora sp. NBC_01699]	diamond	105	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora sp. NBC_01699

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