metadata: contig_metadata: 34 rows where analysis = "diamond", bioproject = "PRJNA859990" and tax

34 rows where analysis = "diamond", bioproject = "PRJNA859990" 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
3787925	3787925	PRJNA859990_S_NODE_14963_length_270_cov_1.441624_g14702_i0	PRJNA859990	14963	270	1.441624	3.8923848	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	173	4.929999999999999e-48	NR	WP_394268257.1	1528099	g14702	i0	100	0.988888888888889	89	0	98.9	0	268	2	503	591	WP_394268257.1 carbamoyl-phosphate synthase large subunit, partial [Lawsonella clevelandensis]	diamond	267	173	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
26706629	26706629	PRJNA859990_S_NODE_19781_length_246_cov_0.982659_g19520_i0	PRJNA859990	19781	246	0.982659	2.41734114	Arthrobacter	1663	Bacteria	Bacteria	167	3.399999999999999e-47	NR	WP_026544141.1	1663	g19520	i0	100	1	82	0	100	0	246	1	275	356	WP_026544141.1 MULTISPECIES: LpqB family beta-propeller domain-containing protein [Arthrobacter]	diamond	246	167	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter
26897067	26897067	PRJNA859990_S_NODE_12921_length_288_cov_1.813953_g12660_i0	PRJNA859990	12921	288	1.813953	5.22418464	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	185	3.5999999999999986e-55	NR	PZP89038.1	1528099	g12660	i0	100	0.989583333333333	95	0	99	0	286	2	38	132	PZP89038.1 MAG: hypothetical protein DI579_03810 [Lawsonella clevelandensis]	diamond	285	185	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
27276456	27276456	PRJNA859990_S_NODE_17903_length_251_cov_0.865169_g17642_i0	PRJNA859990	17903	251	0.865169	2.17157419	Lawsonella sp.	2041415	Bacteria	Bacteria	68.9	1.64e-12	NR	WP_320617017.1	2041415	g17642	i0	58.5	0.633466135458167	53	22	63.3	0	82	240	10	62	WP_320617017.1 helix-turn-helix domain-containing protein [Lawsonella sp.]	diamond	159	68.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella sp.
27402858	27402858	PRJNA859990_S_NODE_19663_length_246_cov_1.572254_g19402_i0	PRJNA859990	19663	246	1.572254	3.86774484	Rhodococcus erythropolis	1833	Bacteria	Bacteria	68.9	4.66e-13	NR	WP_070386765.1	1833	g19402	i0	62.3	1.47560975609756	53	19	63.4	1	91	246	16	68	WP_070386765.1 hypothetical protein [Rhodococcus erythropolis]	diamond	363	68.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus erythropolis
27560451	27560451	PRJNA859990_S_NODE_20584_length_244_cov_1.251462_g20323_i0	PRJNA859990	20584	244	1.251462	3.05356728	Microbacterium sp. Marseille-Q6648	2937991	Bacteria	Bacteria	150	2.3e-43	NR	WP_251453747.1	2937991	g20323	i0	100	0.995901639344262	81	0	99.6	0	244	2	175	255	WP_251453747.1 triose-phosphate isomerase family protein [Microbacterium sp. Marseille-Q6648]	diamond	243	150	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. Marseille-Q6648
28286620	28286620	PRJNA859990_S_NODE_20706_length_244_cov_0.900585_g20445_i0	PRJNA859990	20706	244	0.900585	2.1974274	Lawsonella	1847725	Bacteria	Bacteria	158	9.139999999999999e-48	NR	WP_290595504.1	1847725	g20445	i0	98.8	0.995901639344262	81	1	99.6	0	2	244	4	84	WP_290595504.1 MULTISPECIES: anti-sigma factor family protein [Lawsonella]	diamond	243	158	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
28413202	28413202	PRJNA859990_S_NODE_10826_length_310_cov_1.261603_g10565_i0	PRJNA859990	10826	310	1.261603	3.9109693	Lawsonella	1847725	Bacteria	Bacteria	188	4.43e-58	NR	WP_290595354.1	1847725	g10565	i0	100	0.880645161290323	91	0	88.1	0	310	38	137	227	WP_290595354.1 MULTISPECIES: transcriptional repressor LexA [Lawsonella]	diamond	273	188	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
28602694	28602694	PRJNA859990_S_NODE_18247_length_250_cov_0.870056_g17986_i0	PRJNA859990	18247	250	0.870056	2.17514	Rothia terrae	396015	Bacteria	Bacteria	120	6.679999999999999e-32	NR	GAA1742275.1	396015	g17986	i0	71.1	1.98	83	24	99.6	0	249	1	86	168	GAA1742275.1 hypothetical protein GCM10009794_04150 [Rothia terrae]	diamond	495	120	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia terrae
28768503	28768503	PRJNA859990_S_NODE_20787_length_244_cov_0.900585_g20526_i0	PRJNA859990	20787	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	43.5	0.0201	NR	WP_195114668.1	1823	g20526	i0	30.8	2.74180327868852	65	34	79.9	2	8	202	110	163	WP_195114668.1 DUF6301 family protein [Nocardia otitidiscaviarum]	diamond	669	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia otitidiscaviarum
28823316	28823316	PRJNA859990_S_NODE_19548_length_247_cov_0.867816_g19287_i0	PRJNA859990	19548	247	0.867816	2.14350552	Enteractinococcus helveticum	1837282	Bacteria	Bacteria	97.4	1.48e-21	NR	WP_043057904.1	1837282	g19287	i0	55.6	0.983805668016194	81	36	98.4	0	244	2	291	371	WP_043057904.1 DUF4192 family protein [Enteractinococcus helveticum]	diamond	243	97.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Enteractinococcus	Enteractinococcus helveticum
28918122	28918122	PRJNA859990_S_NODE_14928_length_270_cov_2.218274_g14667_i0	PRJNA859990	14928	270	2.218274	5.9893398	Lawsonella	1847725	Bacteria	Bacteria	180	3.709999999999999e-54	NR	WP_290595334.1	1847725	g14667	i0	100	0.988888888888889	89	0	98.9	0	268	2	194	282	WP_290595334.1 MULTISPECIES: inositol monophosphatase family protein [Lawsonella]	diamond	267	180	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
29549613	29549613	PRJNA859990_S_NODE_22270_length_241_cov_0.880952_g22009_i0	PRJNA859990	22270	241	0.880952	2.12309432	Nocardia carnea	37328	Bacteria	Bacteria	41.2	0.0294	NR	WP_033245318.1	37328	g22009	i0	42.1	0.473029045643154	38	22	47.3	0	214	101	39	76	WP_033245318.1 hypothetical protein, partial [Nocardia carnea]	diamond	114	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia carnea
29707219	29707219	PRJNA859990_S_NODE_22130_length_241_cov_0.916667_g21869_i0	PRJNA859990	22130	241	0.916667	2.20916747	Lawsonella	1847725	Bacteria	Bacteria	163	4.1799999999999997e-47	NR	WP_290599201.1	1847725	g21869	i0	97.5	0.995850622406639	80	2	99.6	0	1	240	56	135	WP_290599201.1 MULTISPECIES: glycerophosphodiester phosphodiesterase family protein [Lawsonella]	diamond	240	163	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
29738955	29738955	PRJNA859990_S_NODE_19950_length_246_cov_0.884393_g19689_i0	PRJNA859990	19950	246	0.884393	2.17560678	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	156	2.17e-44	NR	WQD13621.1	1528099	g19689	i0	92.6	0.98780487804878	81	6	98.8	0	3	245	148	228	WQD13621.1 MAG: hypothetical protein U1U88_001932 [Lawsonella clevelandensis]	diamond	243	156	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
29810426	29810426	PRJNA859990_S_NODE_9391_length_330_cov_1.451362_g9130_i0	PRJNA859990	9391	330	1.451362	4.7894946	Lawsonella	1847725	Bacteria	Bacteria	214	2.2799999999999999e-69	NR	WP_304135529.1	1528099	g9130	i0	99.1	2.97272727272727	109	1	99.1	0	2	328	32	140	WP_304135529.1 hypothetical protein [Lawsonella clevelandensis]	diamond	981	214	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
29897253	29897253	PRJNA859990_S_NODE_21831_length_242_cov_0.875740_g21570_i0	PRJNA859990	21831	242	0.87574	2.1192908	Lawsonella	1847725	Bacteria	Bacteria	160	1.91e-43	NR	WP_290595296.1	1847725	g21570	i0	100	0.979338842975207	79	0	97.9	0	1	237	564	642	WP_290595296.1 MULTISPECIES: alanine--tRNA ligase [Lawsonella]	diamond	237	160	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
29960290	29960290	PRJNA859990_S_NODE_22271_length_241_cov_0.880952_g22010_i0	PRJNA859990	22271	241	0.880952	2.12309432	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	162	3.44e-46	NR	WP_303678908.1	1528099	g22010	i0	98.8	0.995850622406639	80	1	99.6	0	1	240	108	187	WP_303678908.1 glycosyltransferase 87 family protein [Lawsonella clevelandensis]	diamond	240	162	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
30149680	30149680	PRJNA859990_S_NODE_21052_length_243_cov_1.358824_g20791_i0	PRJNA859990	21052	243	1.358824	3.30194232	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	160	2.09e-44	NR	WP_304135578.1	1528099	g20791	i0	100	1	81	0	100	0	243	1	381	461	WP_304135578.1 proteasome ATPase [Lawsonella clevelandensis]	diamond	243	160	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
30181426	30181426	PRJNA859990_S_NODE_11372_length_304_cov_1.000000_g11111_i0	PRJNA859990	11372	304	1	3.04	Lawsonella	1847725	Bacteria	Bacteria	149	6.449999999999998e-43	NR	WP_290595556.1	1847725	g11111	i0	100	0.720394736842105	73	0	72	0	85	303	1	73	WP_290595556.1 MULTISPECIES: aminoacyl-tRNA hydrolase [Lawsonella]	diamond	219	149	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
30181428	30181428	PRJNA859990_S_NODE_18592_length_249_cov_0.920455_g18331_i0	PRJNA859990	18592	249	0.920455	2.29193295	Lawsonella	1847725	Bacteria	Bacteria	163	1.69e-44	NR	WP_290595296.1	1847725	g18331	i0	100	0.987951807228916	82	0	98.8	0	247	2	629	710	WP_290595296.1 MULTISPECIES: alanine--tRNA ligase [Lawsonella]	diamond	246	163	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
30276595	30276595	PRJNA859990_S_NODE_18352_length_250_cov_0.870056_g18091_i0	PRJNA859990	18352	250	0.870056	2.17514	Corynebacterium lubricantis	541095	Bacteria	Bacteria	89.4	2.48e-20	NR	WP_018298120.1	541095	g18091	i0	76.5	0.612	51	12	61.2	0	2	154	107	157	WP_018298120.1 MarR family winged helix-turn-helix transcriptional regulator [Corynebacterium lubricantis]	diamond	153	89.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium lubricantis
30348108	30348108	PRJNA859990_S_NODE_21792_length_242_cov_0.905325_g21531_i0	PRJNA859990	21792	242	0.905325	2.1908865	Bacteria	2	Bacteria	Bacteria	90.9	4.11e-19	NR	WP_058234455.1	472569	g21531	i0	55.4	75.7933884297521	92	28	97.9	2	4	240	353	444	WP_058234455.1 molecular chaperone DnaK [Devriesea agamarum]	diamond	18342	91.7	0.991275899672846	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Devriesea	Devriesea agamarum
30655323	30655323	PRJNA859990_S_NODE_19953_length_246_cov_0.884393_g19692_i0	PRJNA859990	19953	246	0.884393	2.17560678	Corynebacterium lubricantis	541095	Bacteria	Bacteria	148	2.3e-44	NR	WP_018296342.1	541095	g19692	i0	96.3	1	82	3	100	0	1	246	21	102	WP_018296342.1 DUF2283 domain-containing protein [Corynebacterium lubricantis]	diamond	246	148	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium lubricantis
31074392	31074392	PRJNA859990_S_NODE_18655_length_249_cov_0.875000_g18394_i0	PRJNA859990	18655	249	0.875	2.17875	Corynebacterium	1716	Bacteria	Bacteria	57.8	2.02e-7	NR	WP_231725442.1	1716	g18394	i0	53.1	1.7710843373494	49	23	59	0	219	73	282	330	WP_231725442.1 MULTISPECIES: alpha/beta hydrolase family protein [Corynebacterium]	diamond	441	57.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium
31255767	31255767	PRJNA859990_S_NODE_22275_length_241_cov_0.880952_g22014_i0	PRJNA859990	22275	241	0.880952	2.12309432	Nocardioides luteus	1844	Bacteria	Bacteria	60.8	1.49e-8	NR	WP_196876101.1	1844	g22014	i0	52.5	0.759336099585062	61	25	72.2	2	4	177	413	472	WP_196876101.1 CCA tRNA nucleotidyltransferase [Nocardioides luteus]	diamond	183	60.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides luteus
31382413	31382413	PRJNA859990_S_NODE_20376_length_245_cov_0.883721_g20115_i0	PRJNA859990	20376	245	0.883721	2.16511645	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	166	1.7099999999999998e-48	NR	WP_303678787.1	1528099	g20115	i0	96.3	0.991836734693878	81	3	99.2	0	1	243	132	212	WP_303678787.1 hypothetical protein [Lawsonella clevelandensis]	diamond	243	166	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31698611	31698611	PRJNA859990_S_NODE_17877_length_251_cov_0.865169_g17616_i0	PRJNA859990	17877	251	0.865169	2.17157419	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	159	1.19e-44	NR	WP_394268147.1	1528099	g17616	i0	98.8	0.99203187250996006	83	1	99.2	0	1	249	160	242	WP_394268147.1 DNA polymerase IV [Lawsonella clevelandensis]	diamond	249	159	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31761823	31761823	PRJNA859990_S_NODE_20097_length_245_cov_1.459302_g19836_i0	PRJNA859990	20097	245	1.459302	3.5752899	Microbacterium sp. HSID17254	2419509	Bacteria	Bacteria	78.6	9.32e-15	NR	WP_126893512.1	2419509	g19836	i0	97.6	0.514285714285714	42	1	51.4	0	2	127	860	901	WP_126893512.1 phage tail tape measure protein [Microbacterium sp. HSID17254]	diamond	126	78.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. HSID17254
32014947	32014947	PRJNA859990_S_NODE_15798_length_264_cov_0.738220_g15537_i0	PRJNA859990	15798	264	0.73822	1.9489008	Streptomyces sp. NBC_	1931	Bacteria	Bacteria	43.1	0.0352	NR	WP_266939906.1	2903855	g15537	i0	42	0.568181818181818	50	29	56.8	0	39	188	525	574	WP_266939906.1 MDR family MFS transporter [Streptomyces sp. NBC_01408]	diamond	150	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01408
32046658	32046658	PRJNA859990_S_NODE_20678_length_244_cov_0.900585_g20417_i0	PRJNA859990	20678	244	0.900585	2.1974274	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	167	2.7899999999999998e-46	NR	WP_304136108.1	1528099	g20417	i0	100	0.995901639344262	81	0	99.6	0	2	244	205	285	WP_304136108.1 ATP-dependent helicase [Lawsonella clevelandensis]	diamond	243	167	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
32773208	32773208	PRJNA859990_S_NODE_21240_length_243_cov_0.905882_g20979_i0	PRJNA859990	21240	243	0.905882	2.20129326	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	154	1.17e-42	NR	WP_053962752.1	1528099	g20979	i0	95.1	1	81	4	100	0	1	243	314	394	WP_053962752.1 glycine--tRNA ligase [Lawsonella clevelandensis]	diamond	243	154	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
32804728	32804728	PRJNA859990_S_NODE_17760_length_251_cov_1.438202_g17499_i0	PRJNA859990	17760	251	1.438202	3.60988702	Lawsonella	1847725	Bacteria	Bacteria	167	1.32e-50	NR	WP_290598522.1	1847725	g17499	i0	97.6	0.9800796812749	82	2	98	0	3	248	84	165	WP_290598522.1 MULTISPECIES: tRNA adenosine deaminase-associated protein [Lawsonella]	diamond	246	167	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
32836204	32836204	PRJNA859990_S_NODE_17440_length_253_cov_1.016667_g17179_i0	PRJNA859990	17440	253	1.016667	2.57216751	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	175	8.51e-53	NR	WP_303678969.1	1528099	g17179	i0	100	0.99604743083004	84	0	99.6	0	2	253	43	126	WP_303678969.1 rhomboid family intramembrane serine protease [Lawsonella clevelandensis]	diamond	252	175	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis

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