metadata: contig_metadata: 28 rows where analysis = "diamond", bioproject = "PRJNA706190" and tax

28 rows where analysis = "diamond", bioproject = "PRJNA706190" 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
15219659	15219659	PRJNA706190_P_NODE_92352_length_162_cov_0.920354_g92216_i0	PRJNA706190	92352	162	0.920354	1.49097348	uncultured Kocuria sp.	259305	Bacteria	Bacteria	99.4	1.47e-22	NR	WP_298585297.1	259305	g92216	i0	92.6	2	54	4	100	0	162	1	71	124	WP_298585297.1 helicase-related protein [uncultured Kocuria sp.]	diamond	324	99.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	uncultured Kocuria sp.
27252063	27252063	PRJNA706190_P_NODE_75123_length_165_cov_0.896552_g74987_i0	PRJNA706190	75123	165	0.896552	1.4793108	Bacteria	2	Bacteria	Bacteria	93.6	1.63e-20	NR	MDQ3812991.1	2033014	g74987	i0	78.2	3.98181818181818	55	12	100	0	165	1	310	364	MDQ3812991.1 excinuclease ABC subunit UvrC [Armatimonadota bacterium]	diamond	657	94	0.995744680851064	Bacteria		Bacillati	Armatimonadota					Armatimonadota bacterium
27368293	27368293	PRJNA706190_P_NODE_27683_length_193_cov_1.458333_g27547_i0	PRJNA706190	27683	193	1.458333	2.81458269	Streptococcus pneumoniae	1313	Bacteria	Bacteria	104	9.41e-28	NR	MBZ4299771.1	1313	g27547	i0	93.1	0.901554404145078	58	4	90.2	0	20	193	1	58	MBZ4299771.1 hypothetical protein [Streptococcus pneumoniae]	diamond	174	104	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
27368294	27368294	PRJNA706190_P_NODE_68083_length_166_cov_0.888889_g67947_i0	PRJNA706190	68083	166	0.888889	1.47555574	Lactobacillus crispatus	47770	Bacteria	Bacteria	47	3.29e-5	NR	TDN29744.1	47770	g67947	i0	59.5	2.36746987951807	37	15	66.9	0	161	51	26	62	TDN29744.1 hypothetical protein CEE73_10795, partial [Lactobacillus crispatus]	diamond	393	47	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
27810198	27810198	PRJNA706190_P_NODE_29784_length_190_cov_1.900709_g29648_i0	PRJNA706190	29784	190	1.900709	3.6113471	unclassified Lactococcus	2643510	Bacteria	Bacteria	117	2.18e-29	NR	WP_167593765.1	2643510	g29648	i0	95.2	0.978947368421053	62	3	97.9	0	5	190	138	199	WP_167593765.1 MULTISPECIES: FAD-binding oxidoreductase [unclassified Lactococcus]	diamond	186	117	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus
28167967	28167967	PRJNA706190_P_NODE_92405_length_162_cov_0.920354_g92269_i0	PRJNA706190	92405	162	0.920354	1.49097348	Actinomyces	1654	Bacteria	Bacteria	110	1.7700000000000002e-26	NR	WP_314927001.1	249061	g92269	i0	100	3	54	0	100	0	162	1	185	238	WP_314927001.1 beta-ketoacyl synthase N-terminal-like domain-containing protein [uncultured Actinomyces sp.]	diamond	486	110	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
28409992	28409992	PRJNA706190_P_NODE_70166_length_166_cov_0.888889_g70030_i0	PRJNA706190	70166	166	0.888889	1.47555574	Chloroflexota bacterium	2026724	Bacteria	Bacteria	41.2	0.0457	NR	MCC7104963.1	2026724	g70030	i0	45	0.72289156626506	40	19	72.3	1	125	6	624	660	MCC7104963.1 AAA family ATPase [Chloroflexota bacterium]	diamond	120	41.2	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
29041599	29041599	PRJNA706190_P_NODE_33868_length_185_cov_1.235294_g33732_i0	PRJNA706190	33868	185	1.235294	2.2852939	Actinomycetota bacterium	2900548	Bacteria	Bacteria	113	3.85e-30	NR	MFM1767291.1	2900548	g33732	i0	91.8	1.97837837837838	61	5	98.9	0	3	185	26	86	MFM1767291.1 hypothetical protein [Actinomycetota bacterium]	diamond	366	113	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
29104682	29104682	PRJNA706190_P_NODE_90588_length_162_cov_0.920354_g90452_i0	PRJNA706190	90588	162	0.920354	1.49097348	Alloiococcus otitis	1652	Bacteria	Bacteria	99.8	2.1699999999999998e-23	NR	WP_003778570.1	1652	g90452	i0	100	0.925925925925926	50	0	92.6	0	2	151	290	339	WP_003778570.1 NAD(P)H-dependent glycerol-3-phosphate dehydrogenase [Alloiococcus otitis]	diamond	150	99.8	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Alloiococcus	Alloiococcus otitis
29167900	29167900	PRJNA706190_P_NODE_93709_length_160_cov_2.126126_g93573_i0	PRJNA706190	93709	160	2.126126	3.4018016	Virgibacillus salexigens	61016	Bacteria	Bacteria	70.5	6.75e-14	NR	WP_337969740.1	61016	g93573	i0	67.9	0.99375	53	16	99.4	1	2	160	14	65	WP_337969740.1 hypothetical protein [Virgibacillus salexigens]	diamond	159	70.5	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Virgibacillus	Virgibacillus salexigens
29420133	29420133	PRJNA706190_P_NODE_84649_length_163_cov_0.912281_g84513_i0	PRJNA706190	84649	163	0.912281	1.48701803	Armatimonadota bacterium	2033014	Bacteria	Bacteria	42.4	0.0175	NR	HEX2950726.1	2033014	g84513	i0	44.4	0.828220858895706	45	22	82.8	1	29	163	87	128	HEX2950726.1 hypothetical protein [Armatimonadota bacterium]	diamond	135	42.4	1	Bacteria		Bacillati	Armatimonadota					Armatimonadota bacterium
30083308	30083308	PRJNA706190_P_NODE_18932_length_209_cov_1.562500_g18796_i0	PRJNA706190	18932	209	1.5625	3.265625	Scrofimicrobium canadense	2652290	Bacteria	Bacteria	42.4	0.0287	NR	WP_154542979.1	2652290	g18796	i0	37	0.77511961722488	54	34	77.5	0	40	201	154	207	WP_154542979.1 hypothetical protein [Scrofimicrobium canadense]	diamond	162	42.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Scrofimicrobium	Scrofimicrobium canadense
30441779	30441779	PRJNA706190_P_NODE_17153_length_213_cov_2.268293_g17017_i0	PRJNA706190	17153	213	2.268293	4.83146409	Bacteria	2	Bacteria	Bacteria	62.8	1.86e-9	NR	MFN8104210.1	2080302	g17017	i0	50.8	2.61971830985915	61	30	85.9	0	207	25	135	195	MFN8104210.1 EthD domain-containing protein [Acidimicrobiia bacterium]	diamond	558	63.2	0.993670886075949	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
30494311	30494311	PRJNA706190_P_NODE_78733_length_164_cov_0.904348_g78597_i0	PRJNA706190	78733	164	0.904348	1.48313072	Lactobacillus crispatus	47770	Bacteria	Bacteria	46.6	4.68e-5	NR	TDN07424.1	47770	g78597	i0	48.1	0.98780487804878	54	28	98.8	0	3	164	9	62	TDN07424.1 hypothetical protein CEE84_11690 [Lactobacillus crispatus]	diamond	162	46.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
30525743	30525743	PRJNA706190_P_NODE_41473_length_176_cov_0.818898_g41337_i0	PRJNA706190	41473	176	0.818898	1.44126048	Bacillus cereus	1396	Bacteria	Bacteria	40	0.0406	NR	WP_218011624.1	1396	g41337	i0	53.1	0.545454545454545	32	15	54.5	0	10	105	42	73	WP_218011624.1 hypothetical protein, partial [Bacillus cereus]	diamond	96	40	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
30557185	30557185	PRJNA706190_P_NODE_23233_length_201_cov_1.026316_g23097_i0	PRJNA706190	23233	201	1.026316	2.06289516	Renibacterium sp.	1914289	Bacteria	Bacteria	89.4	8.17e-19	NR	MBQ1443515.1	1914289	g23097	i0	97.7	0.641791044776119	43	1	64.2	0	160	32	1	43	MBQ1443515.1 RHS repeat-associated core domain-containing protein [Renibacterium sp.]	diamond	129	89.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Renibacterium	Renibacterium sp.
30725940	30725940	PRJNA706190_P_NODE_6654_length_259_cov_1.014286_g6518_i0	PRJNA706190	6654	259	1.014286	2.62700074	Lawsonella	1847725	Bacteria	Bacteria	171	2.6399999999999993e-52	NR	PZP88504.1	1528099	g6518	i0	100	2.95366795366795	85	0	98.5	0	259	5	62	146	PZP88504.1 MAG: nucleotide exchange factor GrpE [Lawsonella clevelandensis]	diamond	765	171	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
30968316	30968316	PRJNA706190_P_NODE_22914_length_201_cov_2.052632_g22778_i0	PRJNA706190	22914	201	2.052632	4.12579032	Catonella massiliensis	2799636	Bacteria	Bacteria	123	1.44e-33	NR	WP_208429929.1	2799636	g22778	i0	95.2	0.940298507462687	63	3	94	0	12	200	117	179	WP_208429929.1 hypothetical protein [Catonella massiliensis]	diamond	189	123	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Catonella	Catonella massiliensis
30999828	30999828	PRJNA706190_P_NODE_56274_length_168_cov_0.873950_g56138_i0	PRJNA706190	56274	168	0.87395	1.468236	Streptomyces sp. AS58	1519489	Bacteria	Bacteria	40.4	0.0159	NR	KOV65627.1	1519489	g56138	i0	60	0.535714285714286	30	9	53.6	1	109	20	8	34	KOV65627.1 hypothetical protein ADL00_18660 [Streptomyces sp. AS58]	diamond	90	40.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. AS58
31220650	31220650	PRJNA706190_P_NODE_40015_length_177_cov_1.382812_g39879_i0	PRJNA706190	40015	177	1.382812	2.44757724	Negativicoccus succinicivorans	620903	Bacteria	Bacteria	47.4	3.51e-4	NR	WP_273260611.1	620903	g39879	i0	40	0.847457627118644	50	30	84.7	0	3	152	293	342	WP_273260611.1 DEAD/DEAH box helicase [Negativicoccus succinicivorans]	diamond	150	47.4	1	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Negativicoccus	Negativicoccus succinicivorans
31326383	31326383	PRJNA706190_P_NODE_76095_length_165_cov_0.896552_g75959_i0	PRJNA706190	76095	165	0.896552	1.4793108	Aquiluna	529881	Bacteria	Bacteria	108	2.6600000000000003e-27	NR	MCF8524233.1	2053504	g75959	i0	94.3	3.90909090909091	53	3	96.4	0	163	5	177	229	MCF8524233.1 SDR family NAD(P)-dependent oxidoreductase [Aquiluna sp.]	diamond	645	108	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna sp.
31474111	31474111	PRJNA706190_P_NODE_19956_length_207_cov_1.278481_g19820_i0	PRJNA706190	19956	207	1.278481	2.64645567	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	68.2	2.47e-11	NR	WP_304136003.1	1528099	g19820	i0	96.8	0.91304347826087	63	2	91.3	0	17	205	519	581	WP_304136003.1 MDR family MFS transporter [Lawsonella clevelandensis]	diamond	189	68.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31695368	31695368	PRJNA706190_P_NODE_87617_length_163_cov_0.912281_g87481_i0	PRJNA706190	87617	163	0.912281	1.48701803	uncultured Rothia sp.	316088	Bacteria	Bacteria	110	2.41e-26	NR	WP_294454753.1	316088	g87481	i0	98.1	0.993865030674847	54	1	99.4	0	1	162	716	769	WP_294454753.1 phenylalanine--tRNA ligase subunit beta [uncultured Rothia sp.]	diamond	162	110	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	uncultured Rothia sp.
31737455	31737455	PRJNA706190_P_NODE_70197_length_166_cov_0.888889_g70061_i0	PRJNA706190	70197	166	0.888889	1.47555574	root	1	Root_unresolved	Root_unresolved	47.8	2.28e-5	NR	MES6300508.1	1747	g70061	i0	54.3	12.0361445783133	35	15	61.4	1	17	118	19	53	MES6300508.1 hypothetical protein [Cutibacterium acnes]	diamond	1998	47.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
32170161	32170161	PRJNA706190_P_NODE_46598_length_169_cov_2.041667_g46462_i0	PRJNA706190	46598	169	2.041667	3.45041723	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	58.9	3.96e-10	NR	KZU46937.1	1590	g46462	i0	75.7	2.07692307692308	37	9	65.7	0	49	159	1	37	KZU46937.1 hypothetical protein Nizo2766_1002 [Lactiplantibacillus plantarum]	diamond	351	58.9	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
32549880	32549880	PRJNA706190_P_NODE_87479_length_163_cov_0.912281_g87343_i0	PRJNA706190	87479	163	0.912281	1.48701803	Eggerthella lenta	84112	Bacteria	Bacteria	100	7.96e-24	NR	WP_233946983.1	84112	g87343	i0	92.5	0.975460122699387	53	4	97.5	0	3	161	283	335	WP_233946983.1 DNA polymerase, partial [Eggerthella lenta]	diamond	159	100	1	Bacteria		Bacillati	Actinomycetota	Coriobacteriia	Eggerthellales	Eggerthellaceae	Eggerthella	Eggerthella lenta
32581378	32581378	PRJNA706190_P_NODE_66939_length_166_cov_0.888889_g66803_i0	PRJNA706190	66939	166	0.888889	1.47555574	Bacillota bacterium	1879010	Bacteria	Bacteria	42	0.0242	NR	HHY19299.1	1879010	g66803	i0	43.5	0.831325301204819	46	25	81.3	1	24	158	344	389	HHY19299.1 hypothetical protein [Bacillota bacterium]	diamond	138	42	1	Bacteria		Bacillati	Bacillota					Bacillota bacterium
32643868	32643868	PRJNA706190_P_NODE_57000_length_168_cov_0.873950_g56864_i0	PRJNA706190	57000	168	0.87395	1.468236	Mycolicibacterium mucogenicum	56689	Bacteria	Bacteria	95.5	3.3100000000000003e-21	NR	WP_234785548.1	56689	g56864	i0	90.7	0.964285714285714	54	5	96.4	0	162	1	74	127	WP_234785548.1 hypothetical protein, partial [Mycolicibacterium mucogenicum]	diamond	162	95.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium mucogenicum

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