metadata: contig_metadata: 21 rows where analysis = "diamond", bioproject = "PRJNA1012699" and tax

21 rows where analysis = "diamond", bioproject = "PRJNA1012699" 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
158016	158016	PRJNA1012699_P_NODE_2981_length_250_cov_0.881356_g2949_i0	PRJNA1012699	2981	250	0.881356	2.20339	Antrihabitans	2799491	Bacteria	Bacteria	58.9	8.03e-8	NR	WP_149428361.1	2495913	g2949	i0	47.6	2.664	63	31	73.2	1	68	250	9	71	WP_149428361.1 bifunctional metallophosphatase/5'-nucleotidase [Antrihabitans cavernicola]	diamond	666	58.9	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Antrihabitans	Antrihabitans cavernicola
2708354	2708354	PRJNA1012699_P_NODE_2863_length_251_cov_0.876404_g2831_i0	PRJNA1012699	2863	251	0.876404	2.19977404	Propionicimonas paludicola	185243	Bacteria	Bacteria	171	2.74e-49	NR	WP_098459877.1	185243	g2831	i0	95.2	0.99203187250996006	83	4	99.2	0	3	251	115	197	WP_098459877.1 M20/M25/M40 family metallo-hydrolase [Propionicimonas paludicola]	diamond	249	171	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Propionicimonas	Propionicimonas paludicola
2708365	2708365	PRJNA1012699_P_NODE_3383_length_247_cov_0.896552_g3351_i0	PRJNA1012699	3383	247	0.896552	2.21448344	Tsukamurella spumae	44753	Bacteria	Bacteria	144	1.12e-39	NR	WP_168544997.1	44753	g3351	i0	87.7	5.90283400809717	81	10	98.4	0	4	246	223	303	WP_168544997.1 globin domain-containing protein [Tsukamurella spumae]	diamond	1458	144	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella spumae
4830444	4830444	PRJNA1012699_P_NODE_2564_length_255_cov_1.708791_g2532_i0	PRJNA1012699	2564	255	1.708791	4.35741705	Mycolicibacterium sp. BiH	2320850	Bacteria	Bacteria	153	3.859999999999999e-42	NR	WP_270720296.1	3018808	g2532	i0	94	0.988235294117647	84	5	98.8	0	254	3	158	241	WP_270720296.1 ATP-binding protein [Mycolicibacterium sp. BiH015]	diamond	252	153	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium sp. BiH015
10361281	10361281	PRJNA1012699_P_NODE_3929_length_242_cov_1.822485_g3897_i0	PRJNA1012699	3929	242	1.822485	4.4104137	Janibacter massiliensis	2058291	Bacteria	Bacteria	157	2.06e-46	NR	WP_199847399.1	2058291	g3897	i0	100	0.991735537190083	80	0	99.2	0	2	241	130	209	WP_199847399.1 NUDIX hydrolase [Janibacter massiliensis]	diamond	240	157	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter massiliensis
14186638	14186638	PRJNA1012699_P_NODE_2912_length_251_cov_0.876404_g2880_i0	PRJNA1012699	2912	251	0.876404	2.19977404	Pseudonocardia	1847	Bacteria	Bacteria	96.3	2.84e-22	NR	WP_185716742.1	37331	g2880	i0	60.5	4.0996015936255	86	30	98	2	248	3	100	185	WP_185716742.1 TetR/AcrR family transcriptional regulator [Pseudonocardia petroleophila]	diamond	1029	96.7	0.995863495346432	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia petroleophila
27160992	27160992	PRJNA1012699_P_NODE_3482_length_246_cov_0.901734_g3450_i0	PRJNA1012699	3482	246	0.901734	2.21826564	Streptomyces antibioticus	1890	Bacteria	Bacteria	40.8	0.0374	NR	KUN29409.1	1890	g3450	i0	37.3	0.621951219512195	51	26	62.2	1	45	197	39	83	KUN29409.1 hypothetical protein AQJ23_01095 [Streptomyces antibioticus]	diamond	153	40.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces antibioticus
27571976	27571976	PRJNA1012699_P_NODE_3644_length_245_cov_0.901163_g3612_i0	PRJNA1012699	3644	245	0.901163	2.20784935	Actinomycetota bacterium	2900548	Bacteria	Bacteria	43.9	0.0151	NR	MBA2600961.1	2900548	g3612	i0	41.7	0.73469387755102	60	33	71	1	193	20	12	71	MBA2600961.1 hypothetical protein [Actinomycetota bacterium]	diamond	180	43.9	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
28613937	28613937	PRJNA1012699_P_NODE_2987_length_250_cov_0.881356_g2955_i0	PRJNA1012699	2987	250	0.881356	2.20339	Corynebacterium suicordis	203264	Bacteria	Bacteria	106	8.17e-26	NR	WP_194556657.1	203264	g2955	i0	100	0.612	51	0	61.2	0	5	157	224	274	WP_194556657.1 indole-3-glycerol phosphate synthase TrpC [Corynebacterium suicordis]	diamond	153	106	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium suicordis
28985354	28985354	PRJNA1012699_P_NODE_3888_length_243_cov_0.917647_g3856_i0	PRJNA1012699	3888	243	0.917647	2.22988221	Cyanophyceae	3028117	Bacteria	Bacteria	69.3	6.24e-12	NR	MBA3924338.1	2723028	g3856	i0	40	4.62962962962963	75	44	92.6	1	239	15	156	229	MBA3924338.1 class I SAM-dependent methyltransferase [Nostocaceae cyanobacterium]	diamond	1125	69.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae		Nostocaceae cyanobacterium
29245455	29245455	PRJNA1012699_P_NODE_3469_length_246_cov_0.901734_g3437_i0	PRJNA1012699	3469	246	0.901734	2.21826564	Actinomycetota bacterium	2900548	Bacteria	Bacteria	43.9	0.0149	NR	MDQ4033982.1	2900548	g3437	i0	41.4	0.707317073170732	58	29	67.1	2	47	211	239	294	MDQ4033982.1 hypothetical protein [Actinomycetota bacterium]	diamond	174	43.9	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
30351362	30351362	PRJNA1012699_P_NODE_1852_length_287_cov_1.448598_g1820_i0	PRJNA1012699	1852	287	1.448598	4.15747626	Anaerolineae bacterium	2052143	Bacteria	Bacteria	52.8	3.08e-6	NR	MCW5848612.1	2052143	g1820	i0	47.7	0.679442508710801	65	33	66.9	1	256	65	60	124	MCW5848612.1 profilin [Anaerolineae bacterium]	diamond	195	52.8	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
30351363	30351363	PRJNA1012699_P_NODE_3352_length_247_cov_0.896552_g3320_i0	PRJNA1012699	3352	247	0.896552	2.21448344	Actinomycetota bacterium	2900548	Bacteria	Bacteria	42.4	0.0356	NR	NBN89043.1	2900548	g3320	i0	35.4	0.789473684210526	65	37	78.9	1	43	237	106	165	NBN89043.1 hypothetical protein [Actinomycetota bacterium]	diamond	195	42.4	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
30540368	30540368	PRJNA1012699_P_NODE_2973_length_250_cov_0.881356_g2941_i0	PRJNA1012699	2973	250	0.881356	2.20339	Kocuria marina	223184	Bacteria	Bacteria	101	7.57e-26	NR	WP_367404059.1	223184	g2941	i0	92.5	0.636	53	4	63.6	0	159	1	1	53	WP_367404059.1 hypothetical protein [Kocuria marina]	diamond	159	101	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria marina
30563914	30563914	PRJNA1012699_P_NODE_3213_length_248_cov_0.891429_g3181_i0	PRJNA1012699	3213	248	0.891429	2.21074392	Propionibacteriaceae	31957	Bacteria	Bacteria	107	9.98e-27	NR	WP_207474474.1	2782008	g3181	i0	64.2	1.93548387096774	81	29	98	0	244	2	136	216	WP_207474474.1 acVLRF1 family peptidyl-tRNA hydrolase [Tessaracoccus sp. SD287]	diamond	480	107	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Tessaracoccus	Tessaracoccus sp. SD287
30658996	30658996	PRJNA1012699_P_NODE_3333_length_247_cov_0.896552_g3301_i0	PRJNA1012699	3333	247	0.896552	2.21448344	Bacteria	2	Bacteria	Bacteria	59.7	4.16e-8	NR	WP_196426878.1	44253	g3301	i0	54.5	9.78947368421053	66	26	80.2	2	6	203	1989	2050	WP_196426878.1 DUF4347 domain-containing protein [Paenibacillus validus]	diamond	2418	59.7	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus validus
30816988	30816988	PRJNA1012699_P_NODE_3634_length_245_cov_0.901163_g3602_i0	PRJNA1012699	3634	245	0.901163	2.20784935	Tsukamurella	2060	Bacteria	Bacteria	126	1.6499999999999995e-31	NR	WP_415847287.1	147577	g3602	i0	77.2	3.86938775510204	79	18	96.7	0	239	3	1567	1645	WP_415847287.1 amino acid adenylation domain-containing protein [Tsukamurella strandjordii]	diamond	948	126	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella strandjordii
30919714	30919714	PRJNA1012699_P_NODE_3734_length_244_cov_0.912281_g3702_i0	PRJNA1012699	3734	244	0.912281	2.22596564	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	42.4	0.0491	NR	HZQ38230.1	2026734	g3702	i0	39.1	0.786885245901639	64	36	77.5	2	19	207	69	130	HZQ38230.1 MFS transporter [Dehalococcoidia bacterium]	diamond	192	42.4	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
31077662	31077662	PRJNA1012699_P_NODE_3835_length_243_cov_0.917647_g3803_i0	PRJNA1012699	3835	243	0.917647	2.22988221	Streptococcus oralis	1303	Bacteria	Bacteria	157	2.3499999999999994e-42	NR	WP_285300881.1	1303	g3803	i0	97.5	2.95061728395062	80	2	98.8	0	241	2	307	386	WP_285300881.1 SEC10/PgrA surface exclusion domain-containing protein [Streptococcus oralis]	diamond	717	157	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
31741464	31741464	PRJNA1012699_P_NODE_3017_length_250_cov_0.881356_g2985_i0	PRJNA1012699	3017	250	0.881356	2.20339	Tsukamurella sp. M9C	2877520	Bacteria	Bacteria	131	2.27e-33	NR	WP_224646690.1	2877520	g2985	i0	85.5	0.996	83	12	99.6	0	2	250	228	310	WP_224646690.1 BREX-2 system phosphatase PglZ [Tsukamurella sp. M9C]	diamond	249	131	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella sp. M9C
31773148	31773148	PRJNA1012699_P_NODE_3497_length_246_cov_0.901734_g3465_i0	PRJNA1012699	3497	246	0.901734	2.21826564	Tsukamurella sp. USMM236	3081301	Bacteria	Bacteria	87.8	5.22e-18	NR	WP_336670575.1	3081301	g3465	i0	65.8	1.75609756097561	76	26	92.7	0	15	242	358	433	WP_336670575.1 hypothetical protein [Tsukamurella sp. USMM236]	diamond	432	87.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella sp. USMM236

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