metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA575566" 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
8213275	8213275	PRJNA575566_P_NODE_30467_length_188_cov_2.015748_g30270_i0	PRJNA575566	30467	188	2.015748	3.78960624	Firmicutes bacterium ADurb.Bin356	1852890	Bacteria	Bacteria	102	3.02e-24	NR	OQA16478.1	1852890	g30270	i0	82.3	0.98936170212766	62	11	98.9	0	186	1	244	305	OQA16478.1 MAG: Glyceraldehyde-3-phosphate dehydrogenase A [Firmicutes bacterium ADurb.Bin356]	diamond	186	102	1	Bacteria		Bacillati	Bacillota					Firmicutes bacterium ADurb.Bin356
25363038	25363038	PRJNA575566_P_NODE_19340_length_239_cov_1.078652_g19143_i0	PRJNA575566	19340	239	1.078652	2.57797828	FCB group	1783270	Bacteria	Bacteria	147	8.279999999999997e-42	NR	ALL74070.1	1612433	g19143	i0	91.1	8.91213389121339	79	7	99.2	0	238	2	85	163	ALL74070.1 elongation factor TU, partial ['Podocarpus nagi' fasciation phytoplasma]	diamond	2130	148	0.993243243243243	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	'Podocarpus nagi' fasciation phytoplasma
26730971	26730971	PRJNA575566_P_NODE_25861_length_207_cov_0.876712_g25664_i0	PRJNA575566	25861	207	0.876712	1.81479384	Armatimonadota bacterium	2033014	Bacteria	Bacteria	74.7	1.22e-13	NR	MDQ7859368.1	2033014	g25664	i0	62.5	3.69565217391304	64	22	91.3	2	190	2	179	241	MDQ7859368.1 AMP-binding protein [Armatimonadota bacterium]	diamond	765	74.7	1	Bacteria		Bacillati	Armatimonadota					Armatimonadota bacterium
26921340	26921340	PRJNA575566_P_NODE_28522_length_203_cov_0.901408_g28325_i0	PRJNA575566	28522	203	0.901408	1.82985824	Clostridium lundense	319475	Bacteria	Bacteria	72.8	5.57e-13	NR	WP_027623033.1	319475	g28325	i0	48.5	2.89655172413793	66	34	97.5	0	203	6	378	443	WP_027623033.1 pyridoxal phosphate-dependent decarboxylase family protein [Clostridium lundense]	diamond	588	72.8	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium lundense
27585027	27585027	PRJNA575566_P_NODE_28404_length_203_cov_0.901408_g28207_i0	PRJNA575566	28404	203	0.901408	1.82985824	Cellulomonas sp. PSBB	40001	Bacteria	Bacteria	102	8.89e-27	NR	ASR55687.1	2003551	g28207	i0	62.7	0.990147783251232	67	25	99	0	3	203	22	88	ASR55687.1 hypothetical protein CBP52_11970 [Cellulomonas sp. PSBB021]	diamond	201	102	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas sp. PSBB021
28027180	28027180	PRJNA575566_P_NODE_3305_length_571_cov_0.821569_g3110_i0	PRJNA575566	3305	571	0.821569	4.69115899	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	46.6	0.0341	NR	HEX4539557.1	2201156	g3110	i0	32.9	0.893169877408056	170	71	74.1	8	517	95	79	234	HEX4539557.1 hypothetical protein [Acidimicrobiales bacterium]	diamond	510	46.6	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
28311363	28311363	PRJNA575566_P_NODE_28186_length_203_cov_1.352113_g27989_i0	PRJNA575566	28186	203	1.352113	2.74478939	Lachnospira sp.	2049031	Bacteria	Bacteria	46.2	0.00132	NR	MCI8426399.1	2049031	g27989	i0	34.4	3.59113300492611	64	35	94.6	1	12	203	550	606	MCI8426399.1 DNA internalization-related competence protein ComEC/Rec2 [Lachnospira sp.]	diamond	729	46.2	1	Bacteria		Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Lachnospira	Lachnospira sp.
28658734	28658734	PRJNA575566_P_NODE_26947_length_205_cov_0.888889_g26750_i0	PRJNA575566	26947	205	0.888889	1.82222245	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	49.7	8.05e-5	NR	HRF61263.1	2682144	g26750	i0	38.9	0.790243902439024	54	33	79	0	7	168	68	121	HRF61263.1 APC family permease [Fimbriimonadaceae bacterium]	diamond	162	49.7	1	Bacteria		Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
28847821	28847821	PRJNA575566_P_NODE_11748_length_306_cov_1.044898_g11551_i0	PRJNA575566	11748	306	1.044898	3.19738788	Stigonema ocellatum	221293	Bacteria	Bacteria	54.3	4.57e-6	NR	MBR8834845.1	221294	g11551	i0	53.1	0.480392156862745	49	22	47.1	1	153	10	152	200	MBR8834845.1 hypothetical protein [Stigonema ocellatum SAG 48.90 = DSM 106950]	diamond	147	54.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Stigonemataceae	Stigonema	Stigonema ocellatum
29858307	29858307	PRJNA575566_P_NODE_21471_length_225_cov_1.853659_g21274_i0	PRJNA575566	21471	225	1.853659	4.17073275	Clostridia bacterium	2044939	Bacteria	Bacteria	47.4	7.14e-4	NR	MBQ7391938.1	2044939	g21274	i0	43.1	0.68	51	27	65.3	1	7	153	388	438	MBQ7391938.1 InlB B-repeat-containing protein [Clostridia bacterium]	diamond	153	47.4	1	Bacteria		Bacillati	Bacillota	Clostridia				Clostridia bacterium
30630089	30630089	PRJNA575566_P_NODE_29053_length_202_cov_0.907801_g28856_i0	PRJNA575566	29053	202	0.907801	1.83375802	Micrococcales	85006	Bacteria	Bacteria	68.2	2.34e-11	NR	MDO5698836.1	1863	g28856	i0	44.1	9.34158415841584	68	35	96.5	1	199	5	122	189	MDO5698836.1 peptidoglycan-binding domain-containing protein [Dermatophilus congolensis]	diamond	1887	68.6	0.994169096209913	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermatophilaceae	Dermatophilus	Dermatophilus congolensis
30647987	30647987	PRJNA575566_P_NODE_13853_length_283_cov_0.792793_g13656_i0	PRJNA575566	13853	283	0.792793	2.24360419	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	43.9	0.0104	NR	HXA74293.1	2201156	g13656	i0	38.8	1.15547703180212	67	34	63.6	2	84	263	72	138	HXA74293.1 DUF501 domain-containing protein [Acidimicrobiales bacterium]	diamond	327	43.9	1	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales bacterium
30995884	30995884	PRJNA575566_P_NODE_27034_length_205_cov_0.888889_g26837_i0	PRJNA575566	27034	205	0.888889	1.82222245	Mycobacteriales bacterium	1957017	Bacteria	Bacteria	47	6.9e-4	NR	HEX3811592.1	1957017	g26837	i0	41.4	0.848780487804878	58	32	84.9	2	203	30	80	135	HEX3811592.1 acetoin utilization protein AcuC [Mycobacteriales bacterium]	diamond	174	47	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales			Mycobacteriales bacterium
31090590	31090590	PRJNA575566_P_NODE_23735_length_211_cov_1.280000_g23538_i0	PRJNA575566	23735	211	1.28	2.7008	Bacillus kwashiorkori	1522318	Bacteria	Bacteria	95.1	4.41e-21	NR	WP_062350715.1	1522318	g23538	i0	62.3	1.97630331753555	69	26	98.1	0	207	1	91	159	WP_062350715.1 FAD/NAD(P)-binding oxidoreductase [Bacillus kwashiorkori]	diamond	417	95.1	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus kwashiorkori
31578567	31578567	PRJNA575566_P_NODE_13836_length_283_cov_1.153153_g13639_i0	PRJNA575566	13836	283	1.153153	3.26342299	Bacilli	91061	Bacteria	Bacteria	77	3.24e-14	NR	MCA9766345.1	48221	g13639	i0	44.8	11.1519434628975	96	47	99.6	3	282	1	92	183	MCA9766345.1 inositol 2-dehydrogenase [Carnobacterium sp.]	diamond	3156	77.4	0.994832041343669	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium sp.
31786116	31786116	PRJNA575566_P_NODE_16777_length_257_cov_4.244898_g16580_i0	PRJNA575566	16777	257	4.244898	10.90938786	Parafrankia sp. EUN1f	102897	Bacteria	Bacteria	44.7	0.00851	NR	EFC82233.1	102897	g16580	i0	41.4	0.67704280155642	58	33	67.7	1	25	198	29	85	EFC82233.1 conserved hypothetical protein [Parafrankia sp. EUN1f]	diamond	174	44.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Frankiales	Frankiaceae	Parafrankia	Parafrankia sp. EUN1f
31976047	31976047	PRJNA575566_P_NODE_24318_length_209_cov_0.864865_g24121_i0	PRJNA575566	24318	209	0.864865	1.80756785	Actinomycetota bacterium	2900548	Bacteria	Bacteria	45.1	0.00336	NR	MEM9522269.1	2900548	g24121	i0	43.9	0.588516746411483	41	22	57.4	1	184	65	122	162	MEM9522269.1 mechanosensitive ion channel family protein [Actinomycetota bacterium]	diamond	123	45.1	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
32419206	32419206	PRJNA575566_P_NODE_25739_length_207_cov_0.876712_g25542_i0	PRJNA575566	25739	207	0.876712	1.81479384	Nostoc commune	1178	Bacteria	Bacteria	67	4.51e-11	NR	WP_251955386.1	1178	g25542	i0	48.6	2.1304347826087	72	32	98.6	2	3	206	186	256	WP_251955386.1 integrin alpha [Nostoc commune]	diamond	441	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune

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