metadata: contig_metadata: 35 rows where analysis = "diamond", bioproject = "PRJNA681861" and tax

35 rows where analysis = "diamond", bioproject = "PRJNA681861" and tax_kingdom = "Bacillati"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1933552	1933552	PRJNA681861_P_NODE_17602_length_358_cov_2.428571_g15504_i0	PRJNA681861	17602	358	2.428571	8.69428418	Mycolicibacterium llatzerense	280871	Bacteria	Bacteria	97.4	9.13e-24	NR	WP_260973504.1	280871	g15504	i0	85.9	0.536312849162011	64	1	46.9	1	358	191	25	88	WP_260973504.1 hypothetical protein [Mycolicibacterium llatzerense]	diamond	192	97.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium llatzerense
26670249	26670249	PRJNA681861_P_NODE_29961_length_217_cov_1.771277_g27861_i0	PRJNA681861	29961	217	1.771277	3.84367109	Mycobacteriaceae	1762	Bacteria	Bacteria	60.1	4.69e-10	NR	WP_293023781.1	1762	g27861	i0	100	0.373271889400922	27	0	37.3	0	137	217	1	27	WP_293023781.1 MULTISPECIES: hypothetical protein [Mycobacteriaceae]	diamond	81	60.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae
26702016	26702016	PRJNA681861_P_NODE_42761_length_174_cov_2.268966_g40661_i0	PRJNA681861	42761	174	2.268966	3.94800084	Mycobacterium riyadhense	486698	Bacteria	Bacteria	92.4	1.02e-20	NR	WP_204810534.1	486698	g40661	i0	86.7	0.775862068965517	45	6	77.6	0	4	138	59	103	WP_204810534.1 hypothetical protein [Mycobacterium riyadhense]	diamond	135	92.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium riyadhense
26892400	26892400	PRJNA681861_P_NODE_17941_length_352_cov_2.074303_g15843_i0	PRJNA681861	17941	352	2.074303	7.30154656	Mycobacteroides abscessus	36809	Bacteria	Bacteria	223	2.6799999999999996e-72	NR	WP_415733672.1	36809	g15843	i0	83.8	1.15909090909091	136	2	98.9	1	350	3	16	151	WP_415733672.1 hypothetical protein [Mycobacteroides abscessus]	diamond	408	223	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides abscessus
26904063	26904063	PRJNA681861_P_NODE_22661_length_282_cov_2.387352_g20561_i0	PRJNA681861	22661	282	2.387352	6.73233264	Heyndrickxia	2837504	Bacteria	Bacteria	53.1	3.43e-6	NR	GIN83968.1	46224	g20561	i0	55.4	1.1595744680851101	56	25	59.6	0	172	5	37	92	GIN83968.1 hypothetical protein J6TS2_03540 [Heyndrickxia sporothermodurans]	diamond	327	53.1	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Heyndrickxia	Heyndrickxia sporothermodurans
27082043	27082043	PRJNA681861_P_NODE_19882_length_318_cov_4.020761_g17782_i0	PRJNA681861	19882	318	4.020761	12.78601998	Gemella haemolysans	1379	Bacteria	Bacteria	95.5	2.81e-20	NR	WP_204641379.1	1379	g17782	i0	79.7	0.556603773584906	59	12	55.7	0	2	178	2032	2090	WP_204641379.1 YSIRK-type signal peptide-containing protein [Gemella haemolysans]	diamond	177	95.5	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
27303438	27303438	PRJNA681861_P_NODE_42283_length_177_cov_1.513514_g40183_i0	PRJNA681861	42283	177	1.513514	2.67891978	Mycobacterium syngnathidarum	1908205	Bacteria	Bacteria	97.1	1.13e-21	NR	WP_075909249.1	1908205	g40183	i0	79.3	0.983050847457627	58	12	98.3	0	2	175	571	628	WP_075909249.1 hypothetical protein [Mycobacterium syngnathidarum]	diamond	174	97.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium syngnathidarum
27429934	27429934	PRJNA681861_P_NODE_44723_length_163_cov_1.746269_g42623_i0	PRJNA681861	44723	163	1.746269	2.84641847	Mycolicibacterium llatzerense	280871	Bacteria	Bacteria	130	6.439999999999999e-38	NR	MCT7373219.1	280871	g42623	i0	100	0.975460122699387	53	0	97.5	0	3	161	9	61	MCT7373219.1 hypothetical protein [Mycolicibacterium llatzerense]	diamond	159	130	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium llatzerense
27650838	27650838	PRJNA681861_P_NODE_28384_length_227_cov_3.297980_g26284_i0	PRJNA681861	28384	227	3.29798	7.4864146	Streptococcus shenyangsis	2589786	Bacteria	Bacteria	144	4.24e-38	NR	WP_216629101.1	2589786	g26284	i0	100	0.991189427312775	75	0	99.1	0	226	2	1816	1890	WP_216629101.1 Ig-like domain-containing protein, partial [Streptococcus shenyangsis]	diamond	225	144	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus shenyangsis
27694280	27694280	PRJNA681861_P_NODE_35924_length_188_cov_3.289308_g33824_i0	PRJNA681861	35924	188	3.289308	6.18389904	Mycobacteriaceae	1762	Bacteria	Bacteria	75.1	5.17e-14	NR	MCB1292083.1	1785	g33824	i0	62.9	9.8936170212766	62	23	98.9	0	2	187	63	124	MCB1292083.1 rep protein [Mycobacterium sp.]	diamond	1860	75.5	0.994701986754967	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
27714270	27714270	PRJNA681861_P_NODE_22564_length_283_cov_2.570866_g20464_i0	PRJNA681861	22564	283	2.570866	7.27555078	Mycolicibacterium llatzerense	280871	Bacteria	Bacteria	186	1.41e-53	NR	WP_260973500.1	280871	g20464	i0	98.9	10.9611307420495	94	1	99.6	0	1	282	404	497	WP_260973500.1 type IV secretory system conjugative DNA transfer family protein [Mycolicibacterium llatzerense]	diamond	3102	186	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium llatzerense
27714271	27714271	PRJNA681861_P_NODE_43904_length_167_cov_8.268116_g41804_i0	PRJNA681861	43904	167	8.268116	13.80775372	Actinomycetota bacterium	2900548	Bacteria	Bacteria	42	0.0255	NR	HCU94049.1	2900548	g41804	i0	53.1	0.574850299401198	32	13	53.9	1	68	157	141	172	HCU94049.1 hypothetical protein [Actinomycetota bacterium]	diamond	96	42	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
27745660	27745660	PRJNA681861_P_NODE_46384_length_154_cov_2.032000_g44284_i0	PRJNA681861	46384	154	2.032	3.12928	Rothia mucilaginosa	43675	Bacteria	Bacteria	109	1.02e-26	NR	MBF1673448.1	43675	g44284	i0	98	0.993506493506494	51	1	99.4	0	153	1	139	189	MBF1673448.1 hypothetical protein [Rothia mucilaginosa]	diamond	153	109	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
28598049	28598049	PRJNA681861_P_NODE_26247_length_244_cov_27.213953_g24147_i0	PRJNA681861	26247	244	27.213953	66.40204532	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	47.4	2e-4	NR	PZM84364.1	2052166	g24147	i0	63.2	0.467213114754098	38	14	46.7	0	213	100	78	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	114	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28629702	28629702	PRJNA681861_P_NODE_33447_length_198_cov_34.130178_g31347_i0	PRJNA681861	33447	198	34.130178	67.57775244	Staphylococcus aureus	1280	Bacteria	Bacteria	66.6	1.91e-12	NR	MCS4580470.1	1280	g31347	i0	100	0.666666666666667	44	0	66.7	0	3	134	1	44	MCS4580470.1 hypothetical protein [Staphylococcus aureus]	diamond	132	66.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
28661147	28661147	PRJNA681861_P_NODE_27467_length_235_cov_1.684466_g25367_i0	PRJNA681861	27467	235	1.684466	3.9584951	Rothia mucilaginosa	43675	Bacteria	Bacteria	142	8.399999999999999e-38	NR	MBF1672772.1	43675	g25367	i0	90.9	0.982978723404255	77	7	98.3	0	233	3	517	593	MBF1672772.1 hypothetical protein [Rothia mucilaginosa]	diamond	231	142	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
29134924	29134924	PRJNA681861_P_NODE_10949_length_548_cov_3.990366_g9001_i0	PRJNA681861	10949	548	3.990366	21.86720568	Limosilactobacillus urinaemulieris	2742600	Bacteria	Bacteria	47.4	0.00126	NR	WP_206683839.1	2742600	g9001	i0	100	0.142335766423358	26	0	14.2	0	533	456	4	29	WP_206683839.1 hypothetical protein, partial [Limosilactobacillus urinaemulieris]	diamond	78	47.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus urinaemulieris
29197991	29197991	PRJNA681861_P_NODE_16669_length_377_cov_1.931034_g14574_i0	PRJNA681861	16669	377	1.931034	7.27999818	Mycolicibacterium llatzerense	280871	Bacteria	Bacteria	92	3.01e-21	NR	WP_260973506.1	280871	g14574	i0	71.6	0.588859416445623	74	20	58.9	1	155	376	1	73	WP_260973506.1 hypothetical protein [Mycolicibacterium llatzerense]	diamond	222	92	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium llatzerense
29450183	29450183	PRJNA681861_P_NODE_43650_length_169_cov_2.071429_g41550_i0	PRJNA681861	43650	169	2.071429	3.50071501	Mycobacterium riyadhense	486698	Bacteria	Bacteria	67.8	4.85e-12	NR	WP_204810526.1	486698	g41550	i0	83.3	0.63905325443787	36	6	63.9	0	166	59	170	205	WP_204810526.1 hypothetical protein [Mycobacterium riyadhense]	diamond	108	67.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium riyadhense
29513397	29513397	PRJNA681861_P_NODE_44510_length_164_cov_2.074074_g42410_i0	PRJNA681861	44510	164	2.074074	3.40148136	Rothia mucilaginosa	43675	Bacteria	Bacteria	75.1	4.94e-14	NR	WP_303976277.1	43675	g42410	i0	54.2	1.51829268292683	83	7	95.1	1	158	3	73	155	WP_303976277.1 MBL fold metallo-hydrolase [Rothia mucilaginosa]	diamond	249	75.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
30176727	30176727	PRJNA681861_P_NODE_28632_length_226_cov_1.532995_g26532_i0	PRJNA681861	28632	226	1.532995	3.4645687	uncultured Actinomyces sp.	249061	Bacteria	Bacteria	74.7	1.67e-13	NR	WP_314966209.1	249061	g26532	i0	97.2	1.46017699115044	36	1	47.8	0	116	223	1154	1189	WP_314966209.1 SdrD B-like domain-containing protein, partial [uncultured Actinomyces sp.]	diamond	330	74.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
30240059	30240059	PRJNA681861_P_NODE_22172_length_288_cov_1.868726_g20072_i0	PRJNA681861	22172	288	1.868726	5.38193088	Rothia mucilaginosa	43675	Bacteria	Bacteria	162	9.59e-45	NR	MBF1672772.1	43675	g20072	i0	84.2	0.989583333333333	95	15	99	0	286	2	380	474	MBF1672772.1 hypothetical protein [Rothia mucilaginosa]	diamond	285	162	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
30524349	30524349	PRJNA681861_P_NODE_23973_length_267_cov_1.831933_g21873_i0	PRJNA681861	23973	267	1.831933	4.89126111	Rothia mucilaginosa	43675	Bacteria	Bacteria	67	1.75e-12	NR	MBF1673601.1	43675	g21873	i0	96.9	0.359550561797753	32	1	36	0	1	96	36	67	MBF1673601.1 hypothetical protein [Rothia mucilaginosa]	diamond	96	67	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
30745545	30745545	PRJNA681861_P_NODE_25874_length_248_cov_1.726027_g23774_i0	PRJNA681861	25874	248	1.726027	4.28054696	Schaalia sp.	2691890	Bacteria	Bacteria	145	1.06e-41	NR	MBF1086717.1	2691890	g23774	i0	92.1	0.919354838709677	76	6	91.9	0	230	3	1	76	MBF1086717.1 hypothetical protein [Schaalia sp.]	diamond	228	145	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia sp.
30840344	30840344	PRJNA681861_P_NODE_6334_length_863_cov_3.347722_g4878_i0	PRJNA681861	6334	863	3.347722	28.89084086	Limosilactobacillus urinaemulieris	2742600	Bacteria	Bacteria	47.4	0.00324	NR	WP_206683839.1	2742600	g4878	i0	100	0.0903823870220162	26	0	9	0	16	93	4	29	WP_206683839.1 hypothetical protein, partial [Limosilactobacillus urinaemulieris]	diamond	78	47.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus urinaemulieris
30871875	30871875	PRJNA681861_P_NODE_44714_length_163_cov_1.850746_g42614_i0	PRJNA681861	44714	163	1.850746	3.01671598	Actinomycetes	1760	Bacteria	Bacteria	89	5.05e-19	NR	WP_193393917.1	1760	g42614	i0	88.1	1.08588957055215	59	2	99.4	1	163	2	8	66	WP_193393917.1 MULTISPECIES: Mur ligase family protein [Actinomycetes]	diamond	177	89	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes
31136091	31136091	PRJNA681861_P_NODE_22095_length_289_cov_1.838462_g19995_i0	PRJNA681861	22095	289	1.838462	5.31315518	Mycobacteriaceae	1762	Bacteria	Bacteria	131	2.07e-37	NR	WP_242528645.1	36809	g19995	i0	80.5	1.70242214532872	82	8	85.1	1	1	246	35	108	WP_242528645.1 hypothetical protein [Mycobacteroides abscessus]	diamond	492	131	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides abscessus
31155940	31155940	PRJNA681861_P_NODE_27615_length_233_cov_3.715686_g25515_i0	PRJNA681861	27615	233	3.715686	8.65754838	Streptococcus pneumoniae	1313	Bacteria	Bacteria	67.4	1.42e-11	NR	MDG9168660.1	1313	g25515	i0	88.2	0.437768240343348	34	4	43.8	0	2	103	2	35	MDG9168660.1 hypothetical protein [Streptococcus pneumoniae]	diamond	102	67.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
31282664	31282664	PRJNA681861_P_NODE_13155_length_464_cov_2.944828_g11127_i0	PRJNA681861	13155	464	2.944828	13.66400192	Heyndrickxia sporothermodurans	46224	Bacteria	Bacteria	133	3.82e-37	NR	GIN83967.1	46224	g11127	i0	58.8	0.737068965517241	114	43	73.1	2	121	459	2	112	GIN83967.1 hypothetical protein J6TS2_03530 [Heyndrickxia sporothermodurans]	diamond	342	133	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Heyndrickxia	Heyndrickxia sporothermodurans
31504327	31504327	PRJNA681861_P_NODE_31016_length_211_cov_1.450549_g28916_i0	PRJNA681861	31016	211	1.450549	3.06065839	Rothia mucilaginosa	43675	Bacteria	Bacteria	144	3.77e-39	NR	WP_303975959.1	43675	g28916	i0	98.6	0.995260663507109	70	1	99.5	0	210	1	149	218	WP_303975959.1 hypothetical protein [Rothia mucilaginosa]	diamond	210	144	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
31788591	31788591	PRJNA681861_P_NODE_46997_length_151_cov_2.204918_g44897_i0	PRJNA681861	46997	151	2.204918	3.32942618	Mycobacterium sp. SM1	2816243	Bacteria	Bacteria	60.1	1.99e-9	NR	WP_213440952.1	2816243	g44897	i0	66	0.993377483443709	50	17	99.3	0	150	1	85	134	WP_213440952.1 hypothetical protein [Mycobacterium sp. SM1]	diamond	150	60.1	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. SM1
32010311	32010311	PRJNA681861_P_NODE_44338_length_165_cov_1.933824_g42238_i0	PRJNA681861	44338	165	1.933824	3.1908096	Rothia mucilaginosa	43675	Bacteria	Bacteria	58.2	1.43e-8	NR	WP_303976178.1	43675	g42238	i0	83.3	0.654545454545455	36	6	65.5	0	108	1	1	36	WP_303976178.1 hypothetical protein [Rothia mucilaginosa]	diamond	108	58.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
32263692	32263692	PRJNA681861_P_NODE_28738_length_225_cov_2.153061_g26638_i0	PRJNA681861	28738	225	2.153061	4.84438725	Rothia mucilaginosa	43675	Bacteria	Bacteria	69.7	6.75e-12	NR	WP_303975987.1	43675	g26638	i0	97.1	0.466666666666667	35	1	46.7	0	205	101	30	64	WP_303975987.1 hypothetical protein [Rothia mucilaginosa]	diamond	105	69.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
32327082	32327082	PRJNA681861_P_NODE_13379_length_457_cov_3.264019_g11340_i0	PRJNA681861	13379	457	3.264019	14.91656683	Mycobacterium syngnathidarum	1908205	Bacteria	Bacteria	71.2	6.85e-12	NR	WP_075909250.1	1908205	g11340	i0	58	0.656455142231947	100	29	57.8	4	272	9	1	99	WP_075909250.1 hypothetical protein [Mycobacterium syngnathidarum]	diamond	300	71.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium syngnathidarum
32327083	32327083	PRJNA681861_P_NODE_46979_length_151_cov_2.352459_g44879_i0	PRJNA681861	46979	151	2.352459	3.55221309	Mycolicibacterium llatzerense	280871	Bacteria	Bacteria	82.4	1.06e-16	NR	WP_260973500.1	280871	g44879	i0	89.8	0.973509933774834	49	5	97.4	0	149	3	50	98	WP_260973500.1 type IV secretory system conjugative DNA transfer family protein [Mycolicibacterium llatzerense]	diamond	147	82.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium llatzerense

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