metadata: contig_metadata: 24 rows where analysis = "diamond", bioproject = "PRJNA339266" and tax

24 rows where analysis = "diamond", bioproject = "PRJNA339266" 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
27011304	27011304	PRJNA339266_P_NODE_4302_length_190_cov_3.026144_g4272_i0	PRJNA339266	4302	190	3.026144	5.7496736	Microbacterium sp.	51671	Bacteria	Bacteria	40.8	0.0196	NR	HKP06390.1	51671	g4272	i0	58.3	0.836842105263158	36	8	45.8	2	162	76	2	37	HKP06390.1 hypothetical protein [Microbacterium sp.]	diamond	159	40.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp.
27106126	27106126	PRJNA339266_S_NODE_7002_length_196_cov_7.962264_g6991_i0	PRJNA339266	7002	196	7.962264	15.60603744	Corynebacterium durum	61592	Bacteria	Bacteria	136	8.31e-38	NR	WP_303129707.1	61592	g6991	i0	96.9	0.994897959183674	65	2	99.5	0	196	2	107	171	WP_303129707.1 YwqG family protein [Corynebacterium durum]	diamond	195	136	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium durum
27264424	27264424	PRJNA339266_S_NODE_7123_length_195_cov_9.126582_g7112_i0	PRJNA339266	7123	195	9.126582	17.7968349	Microbacterium sp. C448	1177594	Bacteria	Bacteria	118	4.73e-30	NR	CDK00663.1	1177594	g7112	i0	100	0.984615384615385	64	0	98.5	0	194	3	32	95	CDK00663.1 Permease of the major facilitator superfamily (fragment) [Microbacterium sp. C448]	diamond	192	118	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. C448
27485495	27485495	PRJNA339266_P_NODE_6903_length_167_cov_2.276923_g6873_i0	PRJNA339266	6903	167	2.276923	3.80246141	Acidothermaceae bacterium	2575569	Bacteria	Bacteria	49.3	6.42e-5	NR	HEY5051051.1	2575569	g6873	i0	87.5	0.431137724550898	24	3	43.1	0	74	3	32	55	HEY5051051.1 DUF349 domain-containing protein [Acidothermaceae bacterium]	diamond	72	49.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Acidothermales	Acidothermaceae		Acidothermaceae bacterium
27517058	27517058	PRJNA339266_P_NODE_7843_length_156_cov_14.983193_g7813_i0	PRJNA339266	7843	156	14.983193	23.37378108	Nocardioides sp. BE266	2817725	Bacteria	Bacteria	43.5	0.00594	NR	WP_310245366.1	2817725	g7813	i0	82.6	1.32692307692308	23	4	44.2	0	155	87	286	308	WP_310245366.1 metal ABC transporter substrate-binding protein [Nocardioides sp. BE266]	diamond	207	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. BE266
27675155	27675155	PRJNA339266_P_NODE_3524_length_199_cov_2.567901_g3494_i0	PRJNA339266	3524	199	2.567901	5.11012299	Rubrobacter sp.	2036010	Bacteria	Bacteria	45.1	0.003	NR	MBA3426762.1	2036010	g3494	i0	40.3	0.934673366834171	62	32	90.5	3	6	185	146	204	MBA3426762.1 NAD(P)/FAD-dependent oxidoreductase [Rubrobacter sp.]	diamond	186	45.1	1	Bacteria	Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae	Rubrobacter	Rubrobacter sp.
28053685	28053685	PRJNA339266_P_NODE_3805_length_195_cov_3.316456_g3775_i0	PRJNA339266	3805	195	3.316456	6.4670892	Agromyces sp. ISL-38	2819107	Bacteria	Bacteria	44.3	0.00574	NR	MBT2499425.1	2819107	g3775	i0	92	0.384615384615385	25	2	38.5	0	75	1	42	66	MBT2499425.1 sugar-binding protein [Agromyces sp. ISL-38]	diamond	75	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agromyces	Agromyces sp. ISL-38
28085290	28085290	PRJNA339266_S_NODE_1105_length_311_cov_110.875912_g1094_i0	PRJNA339266	1105	311	110.875912	344.82408632	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	157	2.19e-45	NR	HEY5727283.1	2080302	g1094	i0	76.8	3.81993569131833	99	23	95.5	0	311	15	51	149	HEY5727283.1 amino acid ABC transporter permease [Acidimicrobiia bacterium]	diamond	1188	157	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
28165829	28165829	PRJNA339266_P_NODE_7725_length_158_cov_1.231405_g7695_i0	PRJNA339266	7725	158	1.231405	1.9456199	Pseudonocardiaceae	2070	Bacteria	Bacteria	50.1	3.05e-5	NR	WP_253885181.1	103728	g7695	i0	85.7	4.29113924050633	28	4	53.2	0	73	156	5	32	WP_253885181.1 aconitate hydratase [Actinokineospora diospyrosa]	diamond	678	50.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinokineospora	Actinokineospora diospyrosa
28590711	28590711	PRJNA339266_P_NODE_5487_length_183_cov_9.287671_g5457_i0	PRJNA339266	5487	183	9.287671	16.99643793	Microlunatus sp.	39595	Bacteria	Bacteria	75.9	3.37e-14	NR	HEY5845740.1	39595	g5457	i0	72.7	0.721311475409836	44	12	72.1	0	3	134	452	495	HEY5845740.1 cardiolipin synthase [Microlunatus sp.]	diamond	132	75.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sp.
28685472	28685472	PRJNA339266_P_NODE_8627_length_151_cov_1.824561_g8597_i0	PRJNA339266	8627	151	1.824561	2.75508711	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	58.5	2.07e-8	NR	PZP89997.1	1528099	g8597	i0	97.7	1.70860927152318	43	1	85.4	0	151	23	219	261	PZP89997.1 MAG: CDP-diacylglycerol--glycerol-3-phosphate 3-phosphatidyltransferase [Lawsonella clevelandensis]	diamond	258	58.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
28716945	28716945	PRJNA339266_S_NODE_267_length_442_cov_7.765432_g256_i0	PRJNA339266	267	442	7.765432	34.32320944	Micromonospora andamanensis	1287068	Bacteria	Bacteria	206	7.7700000000000005e-66	NR	WP_377560877.1	1287068	g256	i0	99	0.68552036199095	101	1	68.6	0	440	138	40	140	WP_377560877.1 hypothetical protein, partial [Micromonospora andamanensis]	diamond	303	206	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora andamanensis
28906082	28906082	PRJNA339266_P_NODE_7268_length_162_cov_5.952000_g7238_i0	PRJNA339266	7268	162	5.952	9.64224	Lawsonella	1847725	Bacteria	Bacteria	75.9	1.85e-16	NR	WP_290598482.1	1847725	g7238	i0	81.6	0.907407407407407	49	2	77.8	1	158	33	32	80	WP_290598482.1 MULTISPECIES: DUF3263 domain-containing protein [Lawsonella]	diamond	147	75.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
29032815	29032815	PRJNA339266_P_NODE_1828_length_234_cov_2.746193_g1798_i0	PRJNA339266	1828	234	2.746193	6.42609162	Williamsia limnetica	882452	Bacteria	Bacteria	108	1.04e-28	NR	WP_110472209.1	882452	g1798	i0	81	1.61538461538462	63	12	80.8	0	44	232	1	63	WP_110472209.1 DUF4235 domain-containing protein [Williamsia limnetica]	diamond	378	108	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	Williamsia limnetica
29632139	29632139	PRJNA339266_S_NODE_16770_length_157_cov_1.791667_g16759_i0	PRJNA339266	16770	157	1.791667	2.81291719	Microbacterium foliorum	104336	Bacteria	Bacteria	107	2.24e-25	NR	WP_314095445.1	104336	g16759	i0	100	0.993630573248408	52	0	99.4	0	2	157	400	451	WP_314095445.1 glycosyltransferase [Microbacterium foliorum]	diamond	156	107	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium foliorum
30200811	30200811	PRJNA339266_P_NODE_6012_length_179_cov_5.802817_g5982_i0	PRJNA339266	6012	179	5.802817	10.38704243	Marmoricola sp.	1909296	Bacteria	Bacteria	73.2	2.92e-13	NR	MCW2711089.1	1909296	g5982	i0	58.2	0.921787709497207	55	23	92.2	0	178	14	584	638	MCW2711089.1 glycosyl transferase family protein [Marmoricola sp.]	diamond	165	73.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Marmoricola	Marmoricola sp.
30959415	30959415	PRJNA339266_S_NODE_934_length_325_cov_13.590278_g923_i0	PRJNA339266	934	325	13.590278	44.1684035	Mycobacterium sp.	1785	Bacteria	Bacteria	53.9	1.17e-5	NR	MBV9321584.1	1785	g923	i0	41.3	1.38461538461538	75	42	67.4	1	62	280	158	232	MBV9321584.1 AMP-binding protein [Mycobacterium sp.]	diamond	450	53.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
31071536	31071536	PRJNA339266_S_NODE_9235_length_183_cov_3.047945_g9224_i0	PRJNA339266	9235	183	3.047945	5.57773935	Actinomycetes	1760	Bacteria	Bacteria	84.7	2.68e-19	NR	WP_185048361.1	1073253	g9224	i0	78	3.27868852459016	50	11	82	0	32	181	1	50	WP_185048361.1 hypothetical protein [Thermocatellispora tengchongensis]	diamond	600	84.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Thermocatellispora	Thermocatellispora tengchongensis
31338564	31338564	PRJNA339266_P_NODE_5276_length_184_cov_3.442177_g5246_i0	PRJNA339266	5276	184	3.442177	6.33360568	Conyzicola lurida	1172621	Bacteria	Bacteria	50.4	2.93e-5	NR	WP_184236218.1	1172621	g5246	i0	96.2	0.423913043478261	26	1	42.4	0	183	106	66	91	WP_184236218.1 UbiA family prenyltransferase [Conyzicola lurida]	diamond	78	50.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Conyzicola	Conyzicola lurida
31623245	31623245	PRJNA339266_P_NODE_3336_length_201_cov_7.975610_g3306_i0	PRJNA339266	3336	201	7.97561	16.0309761	Actinomycetota bacterium	2900548	Bacteria	Bacteria	70.9	1.04e-12	NR	MDQ2845367.1	2900548	g3306	i0	60.5	1.28358208955224	86	14	98.5	1	200	3	105	190	MDQ2845367.1 hypothetical protein [Actinomycetota bacterium]	diamond	258	70.9	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
32224493	32224493	PRJNA339266_P_NODE_1218_length_260_cov_2.421525_g1188_i0	PRJNA339266	1218	260	2.421525	6.295965	Clavibacter michiganensis	28447	Bacteria	Bacteria	99	3.4000000000000003e-22	NR	WP_167435314.1	28447	g1188	i0	83.9	2.60769230769231	56	9	64.6	0	89	256	313	368	WP_167435314.1 DUF2510 domain-containing protein [Clavibacter michiganensis]	diamond	678	99	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Clavibacter	Clavibacter michiganensis
32351142	32351142	PRJNA339266_P_NODE_4579_length_188_cov_2.264901_g4549_i0	PRJNA339266	4579	188	2.264901	4.25801388	Pseudonocardiales bacterium	2201155	Bacteria	Bacteria	55.1	6.54e-7	NR	PZS18073.1	2201155	g4549	i0	85.7	1.78723404255319	28	4	44.7	0	186	103	228	255	PZS18073.1 MAG: mannosyltransferase [Pseudonocardiales bacterium]	diamond	336	55.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales			Pseudonocardiales bacterium
32477706	32477706	PRJNA339266_P_NODE_7899_length_156_cov_1.848739_g7869_i0	PRJNA339266	7899	156	1.848739	2.88403284	Collinsella tanakaei	626935	Bacteria	Bacteria	100	5.02e-23	NR	WP_235422042.1	626935	g7869	i0	96.1	0.980769230769231	51	2	98.1	0	2	154	18	68	WP_235422042.1 PTS beta-glucoside transporter subunit IIBCA [Collinsella tanakaei]	diamond	153	100	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Coriobacteriaceae	Collinsella	Collinsella tanakaei
32509449	32509449	PRJNA339266_P_NODE_259_length_380_cov_3.247813_g234_i0	PRJNA339266	259	380	3.247813	12.3416894	Micromonospora andamanensis	1287068	Bacteria	Bacteria	199	2.74e-63	NR	WP_377560877.1	1287068	g234	i0	99	0.773684210526316	98	1	77.4	0	375	82	43	140	WP_377560877.1 hypothetical protein, partial [Micromonospora andamanensis]	diamond	294	199	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora andamanensis

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