metadata: contig_metadata: 25 rows where analysis = "diamond", bioproject = "PRJNA733995" and tax

25 rows where analysis = "diamond", bioproject = "PRJNA733995" 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
7095363	7095363	PRJNA733995_P_NODE_9186_length_284_cov_2.066351_g9139_i0	PRJNA733995	9186	284	2.066351	5.86843684	Actinomycetes	1760	Bacteria	Bacteria	143	1.5899999999999999e-40	NR	HEU5456857.1	35761	g9139	i0	76.6	1.98591549295775	94	22	99.3	0	1	282	67	160	HEU5456857.1 hypothetical protein [Nocardioides sp.]	diamond	564	143	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp.
9645111	9645111	PRJNA733995_P_NODE_14148_length_226_cov_2.516340_g14101_i0	PRJNA733995	14148	226	2.51634	5.6869284	Geodermatophilaceae	85030	Bacteria	Bacteria	117	1.74e-28	NR	MCW2695403.1	1873466	g14101	i0	84.7	4.84513274336283	72	11	95.6	0	6	221	38	109	MCW2695403.1 nadE2 [Modestobacter sp.]	diamond	1095	118	0.991525423728814	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter	Modestobacter sp.
13470438	13470438	PRJNA733995_P_NODE_9871_length_275_cov_2.108911_g9824_i0	PRJNA733995	9871	275	2.108911	5.79950525	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	130	6.6000000000000005e-37	NR	HWD53607.1	2201156	g9824	i0	71.3	1.02545454545455	94	24	99.3	1	273	1	13	106	HWD53607.1 SHOCT domain-containing protein [Acidimicrobiales bacterium]	diamond	282	130	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
14745558	14745558	PRJNA733995_P_NODE_14172_length_220_cov_4.115646_g14125_i0	PRJNA733995	14172	220	4.115646	9.0544212	Actinomycetota bacterium	2900548	Bacteria	Bacteria	109	1.8099999999999999e-28	NR	MBN9634693.1	2900548	g14125	i0	100	0.75	55	0	75	0	3	167	112	166	MBN9634693.1 ATP-binding cassette domain-containing protein [Actinomycetota bacterium]	diamond	165	109	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
14745619	14745619	PRJNA733995_P_NODE_9452_length_281_cov_1.451923_g9405_i0	PRJNA733995	9452	281	1.451923	4.07990363	Leifsonia naganoensis	150025	Bacteria	Bacteria	136	8.289999999999998e-35	NR	WP_343850588.1	150025	g9405	i0	81.7	0.99288256227758	93	17	99.3	0	3	281	790	882	WP_343850588.1 helix-turn-helix transcriptional regulator [Leifsonia naganoensis]	diamond	279	136	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia naganoensis
19843547	19843547	PRJNA733995_P_NODE_14016_length_235_cov_2.351852_g13969_i0	PRJNA733995	14016	235	2.351852	5.5268522	Actinomycetes bacterium	1883427	Bacteria	Bacteria	149	1.54e-41	NR	MCU1486148.1	1883427	g13969	i0	92.3	0.995744680851064	78	6	99.6	0	234	1	210	287	MCU1486148.1 acyl-CoA dehydrogenase [Actinomycetes bacterium]	diamond	234	149	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				Actinomycetes bacterium
21119171	21119171	PRJNA733995_P_NODE_10457_length_268_cov_1.579487_g10410_i0	PRJNA733995	10457	268	1.579487	4.23302516	Trebonia sp.	2767075	Bacteria	Bacteria	90.9	9.77e-20	NR	MDX6340077.1	2767075	g10410	i0	53.9	6.02238805970149	89	39	97.4	1	265	5	122	210	MDX6340077.1 hypothetical protein [Trebonia sp.]	diamond	1614	90.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Treboniaceae	Trebonia	Trebonia sp.
23669640	23669640	PRJNA733995_P_NODE_11459_length_256_cov_2.016393_g11412_i0	PRJNA733995	11459	256	2.016393	5.16196608	Actinomycetota bacterium	2900548	Bacteria	Bacteria	123	1.47e-31	NR	MDQ3358740.1	2900548	g11412	i0	77.5	0.83203125	71	16	83.2	0	256	44	294	364	MDQ3358740.1 hypothetical protein [Actinomycetota bacterium]	diamond	213	123	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
26735449	26735449	PRJNA733995_P_NODE_8961_length_288_cov_1.116279_g8914_i0	PRJNA733995	8961	288	1.116279	3.21488352	Actinomycetota bacterium	2900548	Bacteria	Bacteria	45.8	0.00492	NR	MFM8304466.1	2900548	g8914	i0	40.3	0.645833333333333	62	31	60.4	2	68	241	100	159	MFM8304466.1 zinc-binding dehydrogenase [Actinomycetota bacterium]	diamond	186	45.8	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
26767538	26767538	PRJNA733995_P_NODE_11761_length_252_cov_2.284916_g11714_i0	PRJNA733995	11761	252	2.284916	5.75798832	unclassified Streptomyces	2593676	Bacteria	Bacteria	40.8	0.0415	NR	WP_385247137.1	2593676	g11714	i0	44.2	0.511904761904762	43	24	51.2	0	143	15	8	50	WP_385247137.1 MULTISPECIES: hypothetical protein [unclassified Streptomyces]	diamond	129	40.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
27125440	27125440	PRJNA733995_P_NODE_7842_length_308_cov_0.982979_g7795_i0	PRJNA733995	7842	308	0.982979	3.02757532	Bacteria	2	Bacteria	Bacteria	93.6	4.56e-20	NR	HEY2766212.1	1873463	g7795	i0	48.6	2.06493506493507	107	45	95.5	2	303	10	7	112	HEY2766212.1 bifunctional RNase H/acid phosphatase [Pseudonocardiaceae bacterium]	diamond	636	94	0.995744680851064	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae		Pseudonocardiaceae bacterium
27188879	27188879	PRJNA733995_P_NODE_4722_length_398_cov_1.344615_g4675_i0	PRJNA733995	4722	398	1.344615	5.3515677	Actinomycetes	1760	Bacteria	Bacteria	53.1	4.49e-5	NR	WP_108952806.1	67301	g4675	i0	34.5	9.36934673366834	119	52	88.9	5	358	5	1	94	WP_108952806.1 DUF262 domain-containing protein [Streptomyces fragilis]	diamond	3729	53.5	0.992523364485981	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces fragilis
27631431	27631431	PRJNA733995_P_NODE_9464_length_281_cov_1.125000_g9417_i0	PRJNA733995	9464	281	1.125	3.16125	Bacteria	2	Bacteria	Bacteria	134	1.4499999999999998e-37	NR	HUF32867.1	2201156	g9417	i0	68.5	7.55871886120996	89	28	95	0	278	12	102	190	HUF32867.1 alpha/beta family hydrolase [Acidimicrobiales bacterium]	diamond	2124	135	0.992592592592593	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
27873661	27873661	PRJNA733995_P_NODE_7665_length_310_cov_3.033755_g7618_i0	PRJNA733995	7665	310	3.033755	9.4046405	unclassified Rhodococcus (in: high G+C Gram-positive bacteria)	192944	Bacteria	Bacteria	160	3.49e-44	NR	WP_054186524.1	192944	g7618	i0	66.4	1.44193548387097	149	4	99.7	1	2	310	170	318	WP_054186524.1 MULTISPECIES: hydantoinase/oxoprolinase N-terminal domain-containing protein [unclassified Rhodococcus (in: high G+C Gram-positive bacteria)]	diamond	447	160	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus
27947068	27947068	PRJNA733995_P_NODE_10185_length_271_cov_2.823232_g10138_i0	PRJNA733995	10185	271	2.823232	7.65095872	Mycobacteroides	670516	Bacteria	Bacteria	106	2.89e-26	NR	WP_070938709.1	948102	g10138	i0	92.7	1.22878228782288	55	4	60.9	0	170	6	130	184	WP_070938709.1 TetR/AcrR family transcriptional regulator [Mycobacteroides franklinii]	diamond	333	107	0.990654205607477	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides franklinii
28473637	28473637	PRJNA733995_P_NODE_12846_length_246_cov_1.335260_g12799_i0	PRJNA733995	12846	246	1.33526	3.2847396	Pontimonas sp.	2304492	Bacteria	Bacteria	40.4	0.0422	NR	MEQ9086909.1	2304492	g12799	i0	34.9	0.524390243902439	43	28	52.4	0	181	53	30	72	MEQ9086909.1 hypothetical protein [Pontimonas sp.]	diamond	129	40.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Pontimonas	Pontimonas sp.
28505112	28505112	PRJNA733995_P_NODE_7887_length_307_cov_0.957265_g7840_i0	PRJNA733995	7887	307	0.957265	2.93880355	Streptomyces sp. NPDC127197	3345388	Bacteria	Bacteria	43.5	0.0366	NR	WP_385785415.1	3345388	g7840	i0	36.8	0.664495114006515	68	43	66.4	0	204	1	24	91	WP_385785415.1 ATP-binding protein [Streptomyces sp. NPDC127197]	diamond	204	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC127197
29989236	29989236	PRJNA733995_P_NODE_8051_length_303_cov_1.339130_g8004_i0	PRJNA733995	8051	303	1.33913	4.0575639	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	43.5	0.0394	NR	WP_361314835.1	3154897	g8004	i0	35	0.594059405940594	60	38	59.4	1	236	57	141	199	WP_361314835.1 DUF3492 domain-containing protein [Streptomyces sp. NPDC020742]	diamond	180	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC020742
30526283	30526283	PRJNA733995_P_NODE_8253_length_299_cov_2.924779_g8206_i0	PRJNA733995	8253	299	2.924779	8.74508921	Dietzia cinnamea	321318	Bacteria	Bacteria	118	6.999999999999998e-30	NR	WP_061228862.1	321318	g8206	i0	70.8	0.963210702341137	96	1	69.2	1	207	1	1	96	WP_061228862.1 PDR/VanB family oxidoreductase [Dietzia cinnamea]	diamond	288	118	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia	Dietzia cinnamea
30557688	30557688	PRJNA733995_P_NODE_9393_length_282_cov_1.133971_g9346_i0	PRJNA733995	9393	282	1.133971	3.19779822	Knoellia flava	913969	Bacteria	Bacteria	80.5	1.03e-15	NR	WP_035946348.1	913969	g9346	i0	92	0.531914893617021	50	4	53.2	0	152	3	1	50	WP_035946348.1 hypothetical protein [Knoellia flava]	diamond	150	80.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Knoellia	Knoellia flava
30968812	30968812	PRJNA733995_P_NODE_10174_length_272_cov_1.160804_g10127_i0	PRJNA733995	10174	272	1.160804	3.15738688	Actinomycetota bacterium	2900548	Bacteria	Bacteria	86.7	7.08e-18	NR	NBU15968.1	2900548	g10127	i0	53.4	1.88602941176471	88	39	94.9	2	261	4	233	320	NBU15968.1 2OG-Fe(II) oxygenase [Actinomycetota bacterium]	diamond	513	86.7	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
30968841	30968841	PRJNA733995_P_NODE_9054_length_286_cov_2.727700_g9007_i0	PRJNA733995	9054	286	2.7277	7.801222	Microbacterium sp. GCS4	1692239	Bacteria	Bacteria	178	1.84e-49	NR	WP_050723285.1	1692239	g9007	i0	97.9	0.996503496503496	95	2	99.7	0	285	1	331	425	WP_050723285.1 Ig-like domain-containing protein [Microbacterium sp. GCS4]	diamond	285	178	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. GCS4
31284589	31284589	PRJNA733995_P_NODE_5835_length_356_cov_1.632509_g5788_i0	PRJNA733995	5835	356	1.632509	5.81173204	Yinghuangia sp. ASG 1	2846307	Bacteria	Bacteria	72.8	3.97e-12	NR	WP_231774599.1	2896848	g5788	i0	37.9	1.92977528089888	116	61	94.4	3	353	18	63	171	WP_231774599.1 WD40 repeat domain-containing protein [Yinghuangia sp. ASG 101]	diamond	687	72.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Yinghuangia	Yinghuangia sp. ASG 101
31284597	31284597	PRJNA733995_P_NODE_9735_length_277_cov_1.509804_g9688_i0	PRJNA733995	9735	277	1.509804	4.18215708	Rhodococcus sp. PvP104	2817911	Bacteria	Bacteria	132	1.56e-36	NR	MBP2521034.1	2817911	g9688	i0	98.5	0.736462093862816	68	1	73.6	0	3	206	102	169	MBP2521034.1 hypothetical protein [Rhodococcus sp. PvP104]	diamond	204	132	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. PvP104
31316321	31316321	PRJNA733995_P_NODE_13995_length_236_cov_2.361963_g13948_i0	PRJNA733995	13995	236	2.361963	5.57423268	Aquipuribacter hungaricus	545624	Bacteria	Bacteria	141	4.38e-41	NR	WP_340295291.1	545624	g13948	i0	88.5	1.98305084745763	78	9	99.2	0	236	3	19	96	WP_340295291.1 DUF721 domain-containing protein, partial [Aquipuribacter hungaricus]	diamond	468	141	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Aquipuribacter	Aquipuribacter hungaricus

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