metadata: contig_metadata: 23 rows where analysis = "diamond", bioproject = "PRJNA683902" and tax

23 rows where analysis = "diamond", bioproject = "PRJNA683902" 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
22342513	22342513	PRJNA683902_S_NODE_18358_length_256_cov_1.771689_g17914_i0	PRJNA683902	18358	256	1.771689	4.53552384	Bacteria	2	Bacteria	Bacteria	92.4	1.28e-20	NR	WP_115310898.1	103891	g17914	i0	48.8	2.91796875	82	42	96.1	0	256	11	35	116	WP_115310898.1 glycosyltransferase family 2 protein [Veillonella criceti]	diamond	747	93.2	0.991416309012876	Bacteria		Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella criceti
26607179	26607179	PRJNA683902_S_NODE_31541_length_173_cov_1.661765_g31097_i0	PRJNA683902	31541	173	1.661765	2.87485345	Lachnospiraceae bacterium RM5	1200721	Bacteria	Bacteria	42	0.0273	NR	SEQ39217.1	1200721	g31097	i0	35.2	0.936416184971098	54	29	83.2	1	154	11	402	455	SEQ39217.1 putative efflux protein, MATE family [Lachnospiraceae bacterium RM5]	diamond	162	42	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium RM5
26670395	26670395	PRJNA683902_S_NODE_30121_length_178_cov_1.652482_g29677_i0	PRJNA683902	30121	178	1.652482	2.94141796	Amycolatopsis anabasis	1840409	Bacteria	Bacteria	41.2	0.0404	NR	WP_158892349.1	1840409	g29677	i0	40.5	0.707865168539326	42	23	70.8	1	34	159	75	114	WP_158892349.1 hypothetical protein [Amycolatopsis anabasis]	diamond	126	41.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis anabasis
26987145	26987145	PRJNA683902_S_NODE_24822_length_204_cov_1.598802_g24378_i0	PRJNA683902	24822	204	1.598802	3.26155608	Mycobacterium neglectum	242737	Bacteria	Bacteria	42	0.0411	NR	WP_099042215.1	242737	g24378	i0	49.1	0.779411764705882	53	21	76.5	2	14	169	43	90	WP_099042215.1 TIGR01777 family oxidoreductase [Mycobacterium neglectum]	diamond	159	42	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium neglectum
27271824	27271824	PRJNA683902_S_NODE_27803_length_188_cov_1.536424_g27359_i0	PRJNA683902	27803	188	1.536424	2.88847712	Exiguobacterium sp. S22-S28	3342768	Bacteria	Bacteria	89.4	6.360000000000001e-21	NR	WP_393966238.1	3342768	g27359	i0	59	5.8563829787234	61	25	97.3	0	4	186	13	73	WP_393966238.1 DUF1801 domain-containing protein [Exiguobacterium sp. S22-S28]	diamond	1101	89.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium sp. S22-S28
27504772	27504772	PRJNA683902_S_NODE_34323_length_164_cov_1.228346_g33879_i0	PRJNA683902	34323	164	1.228346	2.01448744	Bacteria	2	Bacteria	Bacteria	106	6.22e-28	NR	KZK52508.1	1359	g33879	i0	100	2.96341463414634	54	0	98.8	0	1	162	54	107	KZK52508.1 Mobile element protein [Lactococcus cremoris]	diamond	486	106	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus cremoris
27587801	27587801	PRJNA683902_S_NODE_12804_length_355_cov_2.270440_g12360_i0	PRJNA683902	12804	355	2.27044	8.060062	Fredinandcohnia sp. 179-A 1	2837515	Bacteria	Bacteria	51.2	1.36e-4	NR	WP_412966700.1	3235176	g12360	i0	58.5	0.346478873239437	41	17	34.6	0	2	124	83	123	WP_412966700.1 leucine-rich repeat domain-containing protein [Fredinandcohnia sp. 179-A 10B2 NHS]	diamond	123	51.2	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Fredinandcohnia	Fredinandcohnia sp. 179-A 10B2 NHS
27662611	27662611	PRJNA683902_S_NODE_32704_length_169_cov_1.477273_g32260_i0	PRJNA683902	32704	169	1.477273	2.49659137	Bacteria	2	Bacteria	Bacteria	52.8	3.89e-6	NR	WP_198965499.1	133549	g32260	i0	50	7.84615384615385	50	25	88.8	0	158	9	52	101	WP_198965499.1 non-ribosomal peptide synthetase [Mycobacterium shottsii]	diamond	1326	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium shottsii
28313974	28313974	PRJNA683902_S_NODE_18366_length_256_cov_1.543379_g17922_i0	PRJNA683902	18366	256	1.543379	3.95105024	Candidatus Dormiibacterota bacterium	2052315	Bacteria	Bacteria	48.9	2.03e-4	NR	HVB98927.1	2052315	g17922	i0	51.3	0.45703125	39	19	45.7	0	118	2	1	39	HVB98927.1 superoxide dismutase [Candidatus Dormiibacterota bacterium]	diamond	117	48.9	1	Bacteria		Bacillati	Candidatus Dormiibacterota					Candidatus Dormiibacterota bacterium
28313977	28313977	PRJNA683902_S_NODE_22366_length_219_cov_3.412088_g21922_i0	PRJNA683902	22366	219	3.412088	7.47247272	Streptomyces sp. NPDC	1931	Bacteria	Bacteria	42.7	0.0274	NR	WP_355920396.1	3154278	g21922	i0	43.8	0.657534246575342	48	25	63	1	31	168	1	48	WP_355920396.1 ribosome small subunit-dependent GTPase A [Streptomyces sp. NPDC004533]	diamond	144	42.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NPDC004533
28408667	28408667	PRJNA683902_S_NODE_22706_length_217_cov_1.588889_g22262_i0	PRJNA683902	22706	217	1.588889	3.44788913	Richelia intracellularis HH	1164990	Bacteria	Bacteria	131	6.389999999999999e-38	NR	CCH68009.1	1165094	g22262	i0	98.3	0.829493087557604	60	1	82.9	0	216	37	33	92	CCH68009.1 hypothetical protein RINTHH_18540 [Richelia intracellularis HH01]	diamond	180	131	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia intracellularis
28862117	28862117	PRJNA683902_S_NODE_35748_length_160_cov_1.268293_g35304_i0	PRJNA683902	35748	160	1.268293	2.0292688	Bacteria	2	Bacteria	Bacteria	63.5	7.65e-11	NR	WP_271190726.1	85006	g35304	i0	100	1.125	30	0	56.3	0	91	2	1	30	WP_271190726.1 MULTISPECIES: hypothetical protein [Micrococcales]	diamond	180	63.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales
29260931	29260931	PRJNA683902_S_NODE_35229_length_161_cov_2.508065_g34785_i0	PRJNA683902	35229	161	2.508065	4.03798465	Anaerolineales bacterium	2073117	Bacteria	Bacteria	52.8	2.85e-6	NR	HLE28913.1	2073117	g34785	i0	72.4	4.09937888198758	29	8	54	0	161	75	215	243	HLE28913.1 WecB/TagA/CpsF family glycosyltransferase [Anaerolineales bacterium]	diamond	660	52.8	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29671218	29671218	PRJNA683902_S_NODE_31290_length_174_cov_1.394161_g30846_i0	PRJNA683902	31290	174	1.394161	2.42584014	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	60.5	1.84e-9	NR	MBX9724270.1	2364082	g30846	i0	93.3	0.517241379310345	30	2	51.7	0	2	91	141	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	90	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30145073	30145073	PRJNA683902_S_NODE_38752_length_153_cov_1.008621_g38308_i0	PRJNA683902	38752	153	1.008621	1.54319013	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	95.5	2.08e-21	NR	WP_303678795.1	1528099	g38308	i0	100	0.980392156862745	50	0	98	0	3	152	120	169	WP_303678795.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Lawsonella clevelandensis]	diamond	150	95.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
30366961	30366961	PRJNA683902_S_NODE_34032_length_165_cov_0.914062_g33588_i0	PRJNA683902	34032	165	0.914062	1.5082023	Lawsonella	1847725	Bacteria	Bacteria	117	3.32e-30	NR	WP_290599170.1	1847725	g33588	i0	100	0.981818181818182	54	0	98.2	0	3	164	254	307	WP_290599170.1 MULTISPECIES: ADP-ribosylglycohydrolase family protein [Lawsonella]	diamond	162	117	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella
30461772	30461772	PRJNA683902_S_NODE_33833_length_165_cov_2.382812_g33389_i0	PRJNA683902	33833	165	2.382812	3.9316398	Clostridiaceae bacterium	1898204	Bacteria	Bacteria	42	0.00616	NR	NLL65181.1	1898204	g33389	i0	65.5	0.527272727272727	29	10	52.7	0	77	163	1	29	NLL65181.1 riboflavin biosynthesis protein RibD [Clostridiaceae bacterium]	diamond	87	42	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae		Clostridiaceae bacterium
30599173	30599173	PRJNA683902_S_NODE_29853_length_179_cov_1.612676_g29409_i0	PRJNA683902	29853	179	1.612676	2.88669004	Bacteria	2	Bacteria	Bacteria	54.3	1.23e-6	NR	WP_102712320.1	474957	g29409	i0	71.4	1.6927374301676	35	10	58.7	0	1	105	259	293	WP_102712320.1 methionyl-tRNA formyltransferase [Paenibacillus castaneae]	diamond	303	54.3	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus castaneae
30757318	30757318	PRJNA683902_S_NODE_24834_length_204_cov_1.401198_g24390_i0	PRJNA683902	24834	204	1.401198	2.85844392	Bacillati	1783272	Bacteria	Bacteria	90.5	4.71e-21	NR	WP_275532484.1	1965578	g24390	i0	60	1.89705882352941	65	26	95.6	0	200	6	86	150	WP_275532484.1 pyroglutamyl-peptidase I [Pseudoflavonifractor sp. An187]	diamond	387	91.3	0.991237677984666	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Pseudoflavonifractor	Pseudoflavonifractor sp. An187
31694036	31694036	PRJNA683902_S_NODE_31477_length_173_cov_2.036765_g31033_i0	PRJNA683902	31477	173	2.036765	3.52360345	Chloroflexia bacterium	2448782	Bacteria	Bacteria	39.7	0.0306	NR	HET6263163.1	2448782	g31033	i0	46.2	0.676300578034682	39	15	57.2	1	53	151	25	63	HET6263163.1 hypothetical protein [Chloroflexia bacterium]	diamond	117	39.7	1	Bacteria		Bacillati	Chloroflexota	Chloroflexia				Chloroflexia bacterium
31820470	31820470	PRJNA683902_S_NODE_38617_length_153_cov_1.620690_g38173_i0	PRJNA683902	38617	153	1.62069	2.4796557	Nocardia brasiliensis	37326	Bacteria	Bacteria	68.9	4.05e-12	NR	WP_195136093.1	37326	g38173	i0	69.6	6.45098039215686	46	14	90.2	0	12	149	100	145	WP_195136093.1 dTDP-4-dehydrorhamnose reductase [Nocardia brasiliensis]	diamond	987	68.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia brasiliensis
32548567	32548567	PRJNA683902_S_NODE_18979_length_249_cov_1.830189_g18535_i0	PRJNA683902	18979	249	1.830189	4.55717061	Clostridia bacterium	2044939	Bacteria	Bacteria	42.7	0.0166	NR	MBQ7327491.1	2044939	g18535	i0	38.3	0.72289156626506	60	33	72.3	2	224	45	9	64	MBQ7327491.1 30S ribosomal protein S11 [Clostridia bacterium]	diamond	180	42.7	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
32705722	32705722	PRJNA683902_S_NODE_34540_length_163_cov_2.166667_g34096_i0	PRJNA683902	34540	163	2.166667	3.53166721	Neobacillus cucumis	1740721	Bacteria	Bacteria	99.4	1.72e-24	NR	MFC4290748.1	1740721	g34096	i0	100	0.993865030674847	54	0	99.4	0	162	1	20	73	MFC4290748.1 hypothetical protein [Neobacillus cucumis]	diamond	162	99.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus cucumis

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