metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA309466" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA309466" 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
26599098	26599098	PRJNA309466_P_NODE_11601_length_189_cov_1.092857_g11544_i0	PRJNA309466	11601	189	1.092857	2.06549973	Nocardia carnea	37328	Bacteria	Bacteria	40	0.0456	NR	WP_033245318.1	37328	g11544	i0	39.5	0.603174603174603	38	23	60.3	0	19	132	39	76	WP_033245318.1 hypothetical protein, partial [Nocardia carnea]	diamond	114	40	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia carnea
27074218	27074218	PRJNA309466_P_NODE_5182_length_254_cov_4.809756_g5125_i0	PRJNA309466	5182	254	4.809756	12.21678024	Clostridia bacterium	2044939	Bacteria	Bacteria	42.7	0.0419	NR	MBQ7035414.1	2044939	g5125	i0	37.5	0.566929133858268	48	26	52	1	72	203	432	479	MBQ7035414.1 oligosaccharide flippase family protein [Clostridia bacterium]	diamond	144	42.7	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
27863821	27863821	PRJNA309466_P_NODE_12805_length_182_cov_1.518797_g12748_i0	PRJNA309466	12805	182	1.518797	2.76421054	Clostridiales bacterium	1898207	Bacteria	Bacteria	43.1	0.0116	NR	MCC8022615.1	1898207	g12748	i0	40.7	0.89010989010989	54	32	89	0	21	182	30	83	MCC8022615.1 hypothetical protein [Clostridiales bacterium]	diamond	162	43.1	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
27881455	27881455	PRJNA309466_P_NODE_9685_length_201_cov_210264.072368_g9628_i0	PRJNA309466	9685	201	210264.072368	422630.78545968	root	1	Root_unresolved	Root_unresolved	45.4	0.00237	NR	WP_206602796.1	2094	g9628	i0	95.2	792.358208955224	21	1	31.3	0	45	107	240	260	WP_206602796.1 NADH-quinone oxidoreductase subunit L [Mycoplasmopsis arginini]	diamond	159264	45.4	1	Bacteria		Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
28148229	28148229	PRJNA309466_P_NODE_18385_length_161_cov_2.758929_g18328_i0	PRJNA309466	18385	161	2.758929	4.44187569	Candidatus Gastranaerophilaceae bacterium	3022870	Bacteria	Bacteria	95.9	2.32e-21	NR	HNW26825.1	3022870	g18328	i0	82.4	0.950310559006211	51	9	95	0	3	155	640	690	HNW26825.1 BT4734/BF3469 family protein [Candidatus Gastranaerophilaceae bacterium]	diamond	153	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales	Candidatus Gastranaerophilaceae		Candidatus Gastranaerophilaceae bacterium
28197105	28197105	PRJNA309466_P_NODE_16206_length_167_cov_1.059322_g16149_i0	PRJNA309466	16206	167	1.059322	1.7690677400000001	Streptococcus	1301	Bacteria	Bacteria	91.3	1.06e-19	NR	WP_216629097.1	2589786	g16149	i0	98.2	1.97604790419162	55	1	98.8	0	166	2	1275	1329	WP_216629097.1 DUF1542 domain-containing protein, partial [Streptococcus shenyangsis]	diamond	330	91.3	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus shenyangsis
28369038	28369038	PRJNA309466_P_NODE_13506_length_178_cov_2.286822_g13449_i0	PRJNA309466	13506	178	2.286822	4.07054316	Bulleidia sp. 1	2704657	Bacteria	Bacteria	38.9	0.0495	NR	BFR83729.1	3241172	g13449	i0	45.7	0.589887640449438	35	18	59	1	41	145	15	48	BFR83729.1 hypothetical protein AB8736_04110 [Bulleidia sp. 10714-15]	diamond	105	38.9	1	Bacteria		Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Bulleidia	Bulleidia sp. 10714-15
28842588	28842588	PRJNA309466_P_NODE_17028_length_165_cov_0.887931_g16971_i0	PRJNA309466	17028	165	0.887931	1.46508615	Beutenbergiaceae bacterium	3012325	Bacteria	Bacteria	41.2	0.0447	NR	HLS25559.1	3012325	g16971	i0	43.6	0.709090909090909	39	22	70.9	0	146	30	62	100	HLS25559.1 hypothetical protein [Beutenbergiaceae bacterium]	diamond	117	41.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Beutenbergiaceae		Beutenbergiaceae bacterium
28937547	28937547	PRJNA309466_P_NODE_7188_length_224_cov_1.051429_g7131_i0	PRJNA309466	7188	224	1.051429	2.35520096	Acetoanaerobium sp.	1872093	Bacteria	Bacteria	110	1.3e-29	NR	MBP8762288.1	1872093	g7131	i0	75.8	0.883928571428571	66	16	88.4	0	2	199	29	94	MBP8762288.1 hypothetical protein [Acetoanaerobium sp.]	diamond	198	110	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Filifactoraceae	Acetoanaerobium	Acetoanaerobium sp.
29316334	29316334	PRJNA309466_P_NODE_13869_length_176_cov_3.968504_g13812_i0	PRJNA309466	13869	176	3.968504	6.98456704	Candidatus Anoxymicrobiaceae bacterium	2952901	Bacteria	Bacteria	44.3	0.0043	NR	HEY5494628.1	2952901	g13812	i0	46.9	0.835227272727273	49	25	81.8	1	144	1	101	149	HEY5494628.1 glycosyltransferase [Candidatus Anoxymicrobiaceae bacterium]	diamond	147	44.3	1	Bacteria		Bacillati	Actinomycetota	Candidatus Geothermincolia	Candidatus Geothermincolales	Candidatus Anoxymicrobiaceae		Candidatus Anoxymicrobiaceae bacterium
29442389	29442389	PRJNA309466_P_NODE_8970_length_207_cov_1.943038_g8913_i0	PRJNA309466	8970	207	1.943038	4.02208866	Streptomyces genisteinicus	2768068	Bacteria	Bacteria	43.9	0.00226	NR	QNP67920.1	2768068	g8913	i0	38.7	1.79710144927536	62	38	89.9	0	19	204	28	89	QNP67920.1 hypothetical protein IAG43_33820 [Streptomyces genisteinicus]	diamond	372	43.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces genisteinicus
29631777	29631777	PRJNA309466_P_NODE_10270_length_197_cov_886.790541_g10213_i0	PRJNA309466	10270	197	886.790541	1746.97736577	Staphylococcus aureus	1280	Bacteria	Bacteria	49.3	8.55e-6	NR	MBO8584329.1	1280	g10213	i0	100	1.09644670050761	24	0	36.5	0	137	66	21	44	MBO8584329.1 histone protein [Staphylococcus aureus]	diamond	216	49.3	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
29631779	29631779	PRJNA309466_P_NODE_16790_length_165_cov_2.456897_g16733_i0	PRJNA309466	16790	165	2.456897	4.05388005	Stenomitos rutilans	1886682	Bacteria	Bacteria	62.4	1.05e-9	NR	MBW4469305.1	1382958	g16733	i0	60.4	0.963636363636364	53	19	92.7	1	154	2	169	221	MBW4469305.1 hypothetical protein [Stenomitos rutilans HA7619-LM2]	diamond	159	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos rutilans
29744113	29744113	PRJNA309466_P_NODE_16250_length_167_cov_0.881356_g16193_i0	PRJNA309466	16250	167	0.881356	1.47186452	Corynebacterium	1716	Bacteria	Bacteria	115	5.750000000000001e-29	NR	MDU7286123.1	161879	g16193	i0	100	6.91616766467066	55	0	98.8	0	3	167	88	142	MDU7286123.1 ATP-binding cassette domain-containing protein [Corynebacterium kroppenstedtii]	diamond	1155	115	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kroppenstedtii
29979450	29979450	PRJNA309466_P_NODE_17731_length_163_cov_0.912281_g17674_i0	PRJNA309466	17731	163	0.912281	1.48701803	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	102	1.3899999999999998e-23	NR	WP_306559082.1	1528099	g17674	i0	100	0.975460122699387	53	0	97.5	0	5	163	273	325	WP_306559082.1 sensor histidine kinase [Lawsonella clevelandensis]	diamond	159	102	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
30453635	30453635	PRJNA309466_P_NODE_14753_length_172_cov_1.853659_g14696_i0	PRJNA309466	14753	172	1.853659	3.18829348	Ureibacillus xyleni	614648	Bacteria	Bacteria	41.2	0.00551	NR	WP_161946748.1	614648	g14696	i0	42.5	0.697674418604651	40	23	69.8	0	152	33	2	41	WP_161946748.1 hypothetical protein [Ureibacillus xyleni]	diamond	120	41.2	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Ureibacillus	Ureibacillus xyleni
30628717	30628717	PRJNA309466_P_NODE_16253_length_167_cov_0.881356_g16196_i0	PRJNA309466	16253	167	0.881356	1.47186452	Bacillota	1239	Bacteria	Bacteria	72.8	3.35e-13	NR	MBR3199418.1	1903720	g16196	i0	59.3	12.4670658682635	54	21	97	1	165	4	18	70	MBR3199418.1 hypothetical protein [Bacilli bacterium]	diamond	2082	73.2	0.994535519125683	Bacteria		Bacillati	Bacillota	Bacilli				Bacilli bacterium
31274914	31274914	PRJNA309466_P_NODE_5115_length_255_cov_11.990291_g5058_i0	PRJNA309466	5115	255	11.990291	30.57524205	Corynebacterium glucuronolyticum	39791	Bacteria	Bacteria	40.4	0.048	NR	WP_221389519.1	39791	g5058	i0	31.7	0.741176470588235	63	39	69.4	2	61	237	5	67	WP_221389519.1 hypothetical protein, partial [Corynebacterium glucuronolyticum]	diamond	189	40.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium glucuronolyticum
31306521	31306521	PRJNA309466_P_NODE_17355_length_164_cov_0.904348_g17298_i0	PRJNA309466	17355	164	0.904348	1.48313072	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	87.8	1.68e-18	NR	WP_394268176.1	1528099	g17298	i0	97.8	1.64634146341463	45	1	82.3	0	164	30	711	755	WP_394268176.1 ATP-dependent Clp protease ATP-binding subunit, partial [Lawsonella clevelandensis]	diamond	270	87.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31939064	31939064	PRJNA309466_P_NODE_7557_length_220_cov_1.216374_g7500_i0	PRJNA309466	7557	220	1.216374	2.6760228	Bacillus paralicheniformis	1648923	Bacteria	Bacteria	43.1	0.0107	NR	WP_216393782.1	1648923	g7500	i0	40	1.05	40	24	54.5	0	160	41	4	43	WP_216393782.1 HNH endonuclease [Bacillus paralicheniformis]	diamond	231	43.1	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paralicheniformis
31939065	31939065	PRJNA309466_P_NODE_8577_length_210_cov_5.608696_g8520_i0	PRJNA309466	8577	210	5.608696	11.7782616	Acidimicrobiia bacterium	2080302	Bacteria	Bacteria	53.5	4.12e-7	NR	HKY47145.1	2080302	g8520	i0	36.5	0.9	63	33	85.7	2	180	1	29	87	HKY47145.1 hypothetical protein [Acidimicrobiia bacterium]	diamond	189	53.5	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
32160876	32160876	PRJNA309466_P_NODE_12098_length_186_cov_0.978102_g12041_i0	PRJNA309466	12098	186	0.978102	1.81926972	Staphylococcus epidermidis	1282	Bacteria	Bacteria	47.4	6.21e-5	NR	WP_145357379.1	1282	g12041	i0	100	0.403225806451613	25	0	40.3	0	182	108	1	25	WP_145357379.1 LPXTG cell wall anchor domain-containing protein, partial [Staphylococcus epidermidis]	diamond	75	47.4	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
32178467	32178467	PRJNA309466_P_NODE_16258_length_167_cov_0.881356_g16201_i0	PRJNA309466	16258	167	0.881356	1.47186452	Bacteria	2	Bacteria	Bacteria	41.6	0.00493	NR	MFK5284370.1	1597	g16201	i0	53.7	1.47305389221557	41	18	73.7	1	39	161	1	40	MFK5284370.1 recombination protein NinB [Lacticaseibacillus paracasei]	diamond	246	41.6	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lacticaseibacillus	Lacticaseibacillus paracasei
32319214	32319214	PRJNA309466_P_NODE_13859_length_176_cov_4.637795_g13802_i0	PRJNA309466	13859	176	4.637795	8.1625192	Anaerolineae bacterium	2052143	Bacteria	Bacteria	99	1.22e-22	NR	MBA3868150.1	2052143	g13802	i0	94.1	1.73863636363636	51	3	86.9	0	14	166	188	238	MBA3868150.1 HAMP domain-containing histidine kinase [Anaerolineae bacterium]	diamond	306	99	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32792171	32792171	PRJNA309466_P_NODE_18760_length_158_cov_7.908257_g18703_i0	PRJNA309466	18760	158	7.908257	12.49504606	Gaiellaceae bacterium	2838783	Bacteria	Bacteria	42.4	0.0161	NR	MDF2749474.1	2838783	g18703	i0	59.3	2.0506329113924	27	11	51.3	0	3	83	304	330	MDF2749474.1 major facilitator superfamily 1 [Gaiellaceae bacterium]	diamond	324	42.4	1	Bacteria		Bacillati	Actinomycetota	Thermoleophilia	Gaiellales	Gaiellaceae		Gaiellaceae bacterium
32823912	32823912	PRJNA309466_P_NODE_5740_length_244_cov_1.543590_g5683_i0	PRJNA309466	5740	244	1.54359	3.7663596	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	43.5	0.0198	NR	HMO23427.1	2052166	g5683	i0	31.7	1.54918032786885	63	43	77.5	0	13	201	112	174	HMO23427.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	378	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium

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